Installation - Revision history

Frank Esselink at 23:09, 12 February 2020

2020-02-12T23:09:33Z

← Older revision		Revision as of 16:09, 12 February 2020
Line 2:		Line 2:

	These installation instructions assume that you already have the following installed on your server:		These installation instructions assume that you already have the following installed on your server:
	* PHP 5.2 or later 5.x version with mcrypt extension		* PHP 7.2 or later 7.x version (must be on OOTP20 and StatsLab 3.20.09 or later)
			* PHP 5.2 or later 5.x version with mcrypt extension (all StatsLab versions 3.20.08 and earlier)
	* MySQL 5.2 or later installed.		* MySQL 5.2 or later installed.

	~~'' '''StatsLab does NOT currently support PHP 7.x.''' ''~~

	== Overview ==		== Overview ==

Frank Esselink: /* Generating the MySQL Files */

2019-01-11T05:21:38Z

Generating the MySQL Files

← Older revision		Revision as of 22:21, 10 January 2019
Line 55:		Line 55:

	Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running. Make sure that you are NOT using a Table Name Prefix. Leave that field blank.		Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running. Make sure that you are NOT using a Table Name Prefix. Leave that field blank.
			* [[OOTP19 MySQL Configuration]]
	* [[OOTP18 MySQL Configuration]]		* [[OOTP18 MySQL Configuration]]
	* [[OOTP15 MySQL Configuration]] - Database options are found in a new location in OOTP15. This link contains more information.		* [[OOTP15 MySQL Configuration]] - Database options are found in a new location in OOTP15. This link contains more information.

Frank Esselink: /* Generating the MySQL Files */

2019-01-10T23:24:05Z

Generating the MySQL Files

← Older revision		Revision as of 16:24, 10 January 2019
Line 52:		Line 52:

	== Generating the MySQL Files ==		== Generating the MySQL Files ==
	In order to generate the MySQL files required by StatsLab, you'll need to fire up OOTP, go into the game menu and find the Database Options screen. Once there, in ~~the bottom right~~ of the screen is a button that pulls up a menu which allows you several options for dumping OOTP data out of the game for external use. The three methods of ~~extracing~~ data are CSV files, MS Access files, and MySQL files. For each type of data dump, there is an option to configure the data dump which is separate from the option to generate the data dump. For StatsLab, you'll always want the MySQL dump.		In order to generate the MySQL files required by StatsLab, you'll need to fire up OOTP, go into the game menu and find the Database Options screen. Once there, in in a corner of the screen is a button that pulls up a menu which allows you several options for dumping OOTP data out of the game for external use. The three methods of extracting data are CSV files, MS Access files, and MySQL files. For each type of data dump, there is an option to configure the data dump which is separate from the option to generate the data dump. For StatsLab, you'll always want the MySQL dump.

	Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running.		Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running. Make sure that you are NOT using a Table Name Prefix. Leave that field blank.
	* [[OOTP18 MySQL Configuration]]		* [[OOTP18 MySQL Configuration]]
	* [[OOTP15 MySQL Configuration]] - Database options are found in a new location in OOTP15. This link contains more information.		* [[OOTP15 MySQL Configuration]] - Database options are found in a new location in OOTP15. This link contains more information.

Frank Esselink at 18:27, 12 July 2017

2017-07-12T18:27:15Z

← Older revision		Revision as of 11:27, 12 July 2017
Line 2:		Line 2:

	These installation instructions assume that you already have the following installed on your server:		These installation instructions assume that you already have the following installed on your server:
	* PHP 5.2 or later with mcrypt extension		* PHP 5.2 or later 5.x version with mcrypt extension
	* MySQL 5.2 or later installed.		* MySQL 5.2 or later installed.

			'' '''StatsLab does NOT currently support PHP 7.x.''' ''

	== Overview ==		== Overview ==

Frank Esselink: /* Generating the MySQL Files */

2017-03-25T04:44:09Z

Generating the MySQL Files

← Older revision		Revision as of 21:44, 24 March 2017
Line 53:		Line 53:

	Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running.		Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running.
			* [[OOTP18 MySQL Configuration]]
	* [[OOTP15 MySQL Configuration]] - Database options are found in a new location in OOTP15. This link contains more information.		* [[OOTP15 MySQL Configuration]] - Database options are found in a new location in OOTP15. This link contains more information.
	* [[OOTP14 MySQL Configuration]]		* [[OOTP14 MySQL Configuration]]

Frank Esselink at 18:54, 19 November 2015

2015-11-19T18:54:57Z

← Older revision		Revision as of 11:54, 19 November 2015
Line 132:		Line 132:
	== Next Steps ==		== Next Steps ==
	Once you've installed StatsLab, it's time to go [[Administration\|configure]] it from the [[Administration\|Admin]] screen.		Once you've installed StatsLab, it's time to go [[Administration\|configure]] it from the [[Administration\|Admin]] screen.

			OOTP doesn't export passwords, so the default password for StatsLab is 'baseball'. Be sure to change this for the commish account the first time you log in.

Frank Esselink: /* Connecting to the Database */

2014-09-22T17:31:18Z

Connecting to the Database

← Older revision		Revision as of 10:31, 22 September 2014
Line 86:		Line 86:
	Replace "sqlhost.domain.com" with your database's host, in quotes. If your database is hosted on the same server that you installed StatsLab on, you can usually use "localhost" as the host.		Replace "sqlhost.domain.com" with your database's host, in quotes. If your database is hosted on the same server that you installed StatsLab on, you can usually use "localhost" as the host.

	Replace "~~sqluuser~~" with the MySQL user you created for your StatsLab database.		Replace "sqluser" with the MySQL user you created for your StatsLab database.

	Replace "sqlpassword" with your MySQL user's password.		Replace "sqlpassword" with your MySQL user's password.

Frank Esselink: /* Generating the MySQL Files */

2014-07-08T18:56:16Z

Generating the MySQL Files

← Older revision		Revision as of 11:56, 8 July 2014
Line 53:		Line 53:

	Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running.		Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running.
	* [[OOTP15 MySQL Configuration]]		* [[OOTP15 MySQL Configuration]] - Database options are found in a new location in OOTP15. This link contains more information.
	* [[OOTP14 MySQL Configuration]]		* [[OOTP14 MySQL Configuration]]
	* [[OOTP13 MySQL Configuration]]		* [[OOTP13 MySQL Configuration]]

Frank Esselink: /* Generating the MySQL Files */

2014-05-27T23:04:10Z

Generating the MySQL Files

← Older revision		Revision as of 16:04, 27 May 2014
Line 53:		Line 53:

	Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running.		Configuring the MySQL dump in OOTP is a simple matter of checking and unchecking the correct boxes for the version of OOTP that you're running.
			* [[OOTP15 MySQL Configuration]]
	* [[OOTP14 MySQL Configuration]]		* [[OOTP14 MySQL Configuration]]
	* [[OOTP13 MySQL Configuration]]		* [[OOTP13 MySQL Configuration]]

Frank Esselink: /* Creating The Database */

2014-03-05T18:01:17Z

Creating The Database

← Older revision		Revision as of 11:01, 5 March 2014
Line 29:		Line 29:
	=== Creating The Database ===		=== Creating The Database ===
	From your website's admin console, be it cPanel or some other tool, you'll need to create a new MySQL database. Name it something like "StatsLab", and create a new user with access to the database. Make a note of the database name, the MySQL user name, and the password, as you'll need them later when configuring StatsLab to connect to the database.		From your website's admin console, be it cPanel or some other tool, you'll need to create a new MySQL database. Name it something like "StatsLab", and create a new user with access to the database. Make a note of the database name, the MySQL user name, and the password, as you'll need them later when configuring StatsLab to connect to the database.

			==== MySQL User Permissions ====
			In order for StatsLab to work properly, the MySQL user that StatsLab uses to access your StatsLab database must be configured to perform all the tasks that StatsLab needs to do. At minimum, the user needs to have the following permissions for the StatsLab database:

			ALTER, CREATE, CREATE TEMPORARY TABLES, DELETE, DROP, INDEX, INSERT, SELECT, UPDATE

	=== Creating the StatsLab Install Directory ===		=== Creating the StatsLab Install Directory ===