How To Create a BOARD18 WEB Site - Revision history

Rich: /* Some comments about the BOARD18 MySQL Database */ added GRANT DELETE ON board18.game_link

2020-08-26T19:11:18Z

Some comments about the BOARD18 MySQL Database: added GRANT DELETE ON board18.game_link

← Older revision		Revision as of 19:11, 26 August 2020
Line 21:		Line 21:
	GRANT DELETE ON board18.auth_tokens TO 'board18'@'localhost';		GRANT DELETE ON board18.auth_tokens TO 'board18'@'localhost';
	GRANT DELETE ON board18.game_player TO 'board18'@'localhost';		GRANT DELETE ON board18.game_player TO 'board18'@'localhost';
			GRANT DELETE ON board18.game_link TO 'board18'@'localhost';
	</pre>		</pre>

	<span style="color: Fuchsia">As a somewhat less secure alternative one can modify the second line to include DELETE and eliminate the third and ~~fourth~~ lines.</span>		<span style="color: Fuchsia">As a somewhat less secure alternative one can modify the second line to include DELETE and eliminate the third, fourth and fifth lines.</span>

	<span style="color: Green">Many web hosting providers [such as ~~dreamhost~~] provide control panels that have all the capabilities needed to create a database and its associated usernames.</span>		<span style="color: Green">Many web hosting providers [such as DreamHost] provide control panels that have all the capabilities needed to create a database and its associated usernames.</span>

	===Perform these steps on your local PC===		===Perform these steps on your local PC===

Rich: /* Some comments about the BOARD18 MySQL Database */ added GRANT DELETE ON board18.game_player

2020-08-25T17:35:14Z

Some comments about the BOARD18 MySQL Database: added GRANT DELETE ON board18.game_player

← Older revision		Revision as of 17:35, 25 August 2020
Line 20:		Line 20:
	GRANT SELECT, INSERT, UPDATE ON board18.* TO 'board18'@'localhost';		GRANT SELECT, INSERT, UPDATE ON board18.* TO 'board18'@'localhost';
	GRANT DELETE ON board18.auth_tokens TO 'board18'@'localhost';		GRANT DELETE ON board18.auth_tokens TO 'board18'@'localhost';
			GRANT DELETE ON board18.game_player TO 'board18'@'localhost';
	</pre>		</pre>

	<span style="color: Fuchsia">~~The third line in the box above was added to support new authorization functionality.~~		<span style="color: Fuchsia">As a somewhat less secure alternative one can modify the second line to include DELETE and eliminate the third and fourth lines.</span>
	~~It should work but I have not yet tested it in production because my hosting provider does not allow direct access to~~
	~~the GRANT command. <br>~~
	As a somewhat less secure alternative one can modify the second line to include DELETE and eliminate the third ~~line~~.</span>

	<span style="color: Green">Many web hosting providers [such as dreamhost] provide ~~web pages~~ that have all the capabilities needed to create a database and its associated usernames.</span>		<span style="color: Green">Many web hosting providers [such as dreamhost] provide control panels that have all the capabilities needed to create a database and its associated usernames.</span>

	===Perform these steps on your local PC===		===Perform these steps on your local PC===

Rich: /* Perform these steps on your Linux web server */

2020-08-06T15:32:00Z

Perform these steps on your Linux web server

← Older revision		Revision as of 15:32, 6 August 2020
Line 55:		Line 55:
	** Change MAIL_PASS to your mail user password on this SMTP server.		** Change MAIL_PASS to your mail user password on this SMTP server.
	** Change MAIL_SENDER to the email address to which you wish replies to be sent.<ref>The installer of BOARD18 should create an Email address such as '''admin@my.site.org''' <br>and then use it to forward replies to an admin level player or to a group of admin level players.</ref>		** Change MAIL_SENDER to the email address to which you wish replies to be sent.<ref>The installer of BOARD18 should create an Email address such as '''admin@my.site.org''' <br>and then use it to forward replies to an admin level player or to a group of admin level players.</ref>
	** Change MAIL_TLS to '~~Yes~~' if your SMTP server requires TLS. <ref>Note: Changing MAIL_TLS to '~~Yes~~' may cause some older SMTP servers to reject your email.</ref>		** Change MAIL_TLS to 'tls' if your SMTP server requires TLS. <ref>Note: Changing MAIL_TLS to 'tls' may cause some older SMTP servers to reject your email.</ref>
	** Save the edited file.		** Save the edited file.
	* Edit the utility/config.php file.		* Edit the utility/config.php file.

Rich: /* Perform these steps on your Linux web server */ added Create the ''webroot''/php/configMail.php file.

2020-02-06T22:37:08Z

Perform these steps on your Linux web server: added Create the ''webroot''/php/configMail.php file.

← Older revision		Revision as of 22:37, 6 February 2020
Line 47:		Line 47:
	** Change the database user ID and password to the "board18 user" [see above].		** Change the database user ID and password to the "board18 user" [see above].
	** Save the edited file.		** Save the edited file.
			* Create the ''webroot''/php/configMail.php file.
			** Copy the ''webroot''/utility/configMailTemplate.php file to the ''webroot''/php/ directory.
			** Rename this copied file to ''webroot''/php/configMail.php.
	* Edit the ''webroot''/php/configMail.php file.		* Edit the ''webroot''/php/configMail.php file.
	** Change MAIL_HOST to point to your SMTP server.		** Change MAIL_HOST to point to your SMTP server.

Rich: /* Some comments about the BOARD18 MySQL Database */ modified comment

2019-07-19T19:27:49Z

Some comments about the BOARD18 MySQL Database: modified comment

← Older revision		Revision as of 19:27, 19 July 2019
Line 23:		Line 23:

	<span style="color: Fuchsia">The third line in the box above was added to support new authorization functionality.		<span style="color: Fuchsia">The third line in the box above was added to support new authorization functionality.
	It should work but I have not yet tested it.</span>		It should work but I have not yet tested it in production because my hosting provider does not allow direct access to
			the GRANT command. <br>
			As a somewhat less secure alternative one can modify the second line to include DELETE and eliminate the third line.</span>

	<span style="color: Green">Many web hosting providers [such as dreamhost] provide web pages that have all the capabilities needed to create a database and its associated usernames.</span>		<span style="color: Green">Many web hosting providers [such as dreamhost] provide web pages that have all the capabilities needed to create a database and its associated usernames.</span>

Rich: /* Some comments about the BOARD18 MySQL Database */ added comment

2019-07-19T17:55:56Z

Some comments about the BOARD18 MySQL Database: added comment

← Older revision		Revision as of 17:55, 19 July 2019
Line 22:		Line 22:
	</pre>		</pre>

	<span style="color: Fuchsia">Many web hosting providers [such as dreamhost] provide web pages that have all the capabilities needed to create a database and its associated usernames.</span>		<span style="color: Fuchsia">The third line in the box above was added to support new authorization functionality.
			It should work but I have not yet tested it.</span>

			<span style="color: Green">Many web hosting providers [such as dreamhost] provide web pages that have all the capabilities needed to create a database and its associated usernames.</span>

	===Perform these steps on your local PC===		===Perform these steps on your local PC===

Rich: /* Some comments about the BOARD18 MySQL Database */ added DELETE

2019-07-16T21:44:56Z

Some comments about the BOARD18 MySQL Database: added DELETE

← Older revision		Revision as of 21:44, 16 July 2019
Line 19:		Line 19:
	CREATE USER 'board18'@'localhost' IDENTIFIED BY 'board18';		CREATE USER 'board18'@'localhost' IDENTIFIED BY 'board18';
	GRANT SELECT, INSERT, UPDATE ON board18.* TO 'board18'@'localhost';		GRANT SELECT, INSERT, UPDATE ON board18.* TO 'board18'@'localhost';
			GRANT DELETE ON board18.auth_tokens TO 'board18'@'localhost';
	</pre>		</pre>

Rich: /* Perform these steps on your Linux web server */ added MAIL_TLS

2018-06-14T19:48:38Z

Perform these steps on your Linux web server: added MAIL_TLS

← Older revision		Revision as of 19:48, 14 June 2018
Line 46:		Line 46:
	** Change MAIL_PASS to your mail user password on this SMTP server.		** Change MAIL_PASS to your mail user password on this SMTP server.
	** Change MAIL_SENDER to the email address to which you wish replies to be sent.<ref>The installer of BOARD18 should create an Email address such as '''admin@my.site.org''' <br>and then use it to forward replies to an admin level player or to a group of admin level players.</ref>		** Change MAIL_SENDER to the email address to which you wish replies to be sent.<ref>The installer of BOARD18 should create an Email address such as '''admin@my.site.org''' <br>and then use it to forward replies to an admin level player or to a group of admin level players.</ref>
			** Change MAIL_TLS to 'Yes' if your SMTP server requires TLS. <ref>Note: Changing MAIL_TLS to 'Yes' may cause some older SMTP servers to reject your email.</ref>
	** Save the edited file.		** Save the edited file.
	* Edit the utility/config.php file.		* Edit the utility/config.php file.

Rich: /* Load the BOARD18 Game Boxes */ removed obsolete information

2017-03-26T17:29:55Z

Load the BOARD18 Game Boxes: removed obsolete information

← Older revision		Revision as of 17:29, 26 March 2017
Line 74:		Line 74:

	===Load the BOARD18 Game Boxes===		===Load the BOARD18 Game Boxes===
	* Login to your new BOARD18 web site as the admin player and select '''MENU''' - '''Administration'''.
	* On the left side of the page select '''Load Game Box'''.
	* For each game box .zip file that you previously downloaded from the WIKI, do the following:
	** Browse to and select the .zip file.
	** Press the '''Load Game Box''' button.

	~~'''~~This process is described in ~~more~~ detail [[~~BOARD18_Author's_Guide~~\|here]].~~'''~~		This process is described in detail [[How_To_Load_Board18_Game_Boxes#How_to_mass_load_BOARD18_game_boxes_using_Linux\|here]].

	==How to create a BOARD18 web site using Windows==		==How to create a BOARD18 web site using Windows==

Rich: /* Load the BOARD18 DataBase */ added note

2017-03-26T17:23:38Z

Load the BOARD18 DataBase: added note

← Older revision		Revision as of 17:23, 26 March 2017
Line 61:		Line 61:
	mysql -u username -p -h hostname databasename < board18db.txt		mysql -u username -p -h hostname databasename < board18db.txt
	</pre>		</pre>
			* Note: The cd command above may have to be modified. The intent is to go to the utility directory.
	* The hostname (DB_HOST), databasename (DB_DATABASE) and username should be those specified in the utility/config.php file.		* The hostname (DB_HOST), databasename (DB_DATABASE) and username should be those specified in the utility/config.php file.
	* When prompted for a password, enter the password specified in the utility/config.php file.		* When prompted for a password, enter the password specified in the utility/config.php file.

	You should now have an empty BOARD18 database. All the tables are defined but they are all empty.<br>		You should now have an empty BOARD18 database. All the tables are defined but they are all empty.<br>
	The only table that must be preloaded with data is the game box table.		The only table that must be preloaded with data is the game box table.

	===Create the initial BOARD18 admin player===		===Create the initial BOARD18 admin player===