Achievo Installation - Revision history

Wayneh: /* Configure Achievo's database connection */

2010-05-22T04:05:37Z

Configure Achievo's database connection

← Older revision		Revision as of 04:05, 22 May 2010
Line 36:		Line 36:
	Edit the file config.inc.php in the achievo directory, and set the		Edit the file config.inc.php in the achievo directory, and set the
	$config_db["default"]["host"], $config_db["default"]["driver"], $config_db["default"]["db"], $config_db["default"]["user"] and		$config_db["default"]["host"], $config_db["default"]["driver"], $config_db["default"]["db"], $config_db["default"]["user"] and
	$config_db["default"]["password"] variables to match your setup. ~~[http://www.jouercasino.eu casinos en ligne]~~		$config_db["default"]["password"] variables to match your setup.

	example:		example:
	$config_db["default"]["driver"] = "mysql";		$config_db["default"]["driver"] = "mysql";

RebeccaMendez: /* Configure Achievo's database connection */

2010-05-20T13:14:40Z

Configure Achievo's database connection

← Older revision		Revision as of 13:14, 20 May 2010
Line 36:		Line 36:
	Edit the file config.inc.php in the achievo directory, and set the		Edit the file config.inc.php in the achievo directory, and set the
	$config_db["default"]["host"], $config_db["default"]["driver"], $config_db["default"]["db"], $config_db["default"]["user"] and		$config_db["default"]["host"], $config_db["default"]["driver"], $config_db["default"]["db"], $config_db["default"]["user"] and
	$config_db["default"]["password"] variables to match your setup.		$config_db["default"]["password"] variables to match your setup. [http://www.jouercasino.eu casinos en ligne]

	example:		example:

Iamit: /* Create the database */

2010-05-11T09:11:41Z

Create the database

← Older revision		Revision as of 09:11, 11 May 2010
Line 25:		Line 25:
	mysql> grant create,alter,select,insert,update,delete,lock tables,		mysql> grant create,alter,select,insert,update,delete,lock tables,
	create view,drop,index		create view,drop,index
	on ~~achievo_1_4~~.* to achievo@localhost identified by 'secret';		on achievo_1_0.* to achievo@localhost identified by 'secret';
	mysql> quit;		mysql> quit;

Sandy: /* Cron script setup */

2010-02-17T08:34:08Z

Cron script setup

← Older revision		Revision as of 08:34, 17 February 2010
Line 69:		Line 69:

	== Cron script setup ==		== Cron script setup ==
	Achievo contains some useful cron scripts that can be run periodically from a cron job. See the ~~cron~~/~~README~~ file in the Achievo distribution for available cron features and instructions.		Achievo contains some useful cron scripts that can be run periodically from a cron job. See the doc/CRON file in the Achievo distribution for available cron features and instructions.

bahtiar: moved Installation to Achievo Installation

2010-02-12T14:08:07Z

moved Installation to Achievo Installation

← Older revision	Revision as of 14:08, 12 February 2010
(No difference)

Sandy: /* Installation Procedure */

2009-11-26T21:36:37Z

Installation Procedure

← Older revision		Revision as of 21:36, 26 November 2009
Line 1:		Line 1:
	== Installation Procedure ==		== Installation Procedure ==
	Note that this guide does not describe how to install a webserver or PHP or a database server. See the documentation for these programs on how to install those. This installation guide assumes that you already have a working webserver with PHP support and a MySQL database installed.		Note that this guide does not describe how to install a webserver or PHP or a database server. See the documentation for these programs on how to install those. This installation guide assumes that you already have a working webserver with PHP 5.2.x+ support and a MySQL 5+ database installed.

	'''Important''': this is the installation instruction for Achievo versions 1.0.RC1 and higher. The setup.php script mentioned did not yet exist in older versions. Older versions all contain a doc/ directory though inside the tar.gz file, which contains an INSTALL file describing how to get Achievo installed without a setup.php script.		'''Important''': this is the installation instruction for Achievo versions 1.0.RC1 and higher. The setup.php script mentioned did not yet exist in older versions. Older versions all contain a doc/ directory though inside the tar.gz file, which contains an INSTALL file describing how to get Achievo installed without a setup.php script.

Sandy: /* Create the database */

2009-11-26T21:35:52Z

Create the database

← Older revision		Revision as of 21:35, 26 November 2009
Line 16:		Line 16:
	== Create the database ==		== Create the database ==
	Create an empty database in mysql and a user that has create, alter,		Create an empty database in mysql and a user that has create, alter,
	select, insert, update and ~~delete~~-access on the database.		select, insert, update, delete, lock tables, create view, drop and index-access on the database.

	example (assuming your mysql root password is 'secret'):		example (assuming your mysql root password is 'secret'):

Sandy: /* Create the database */

2009-11-26T21:34:34Z

Create the database

← Older revision		Revision as of 21:34, 26 November 2009
Line 23:		Line 23:
	$ mysql -u root --password=secret		$ mysql -u root --password=secret
	mysql> create database achievo_1_0;		mysql> create database achievo_1_0;
	mysql> grant create,alter,select,insert,update,delete on ~~achievo_1_0~~.*		mysql> grant create,alter,select,insert,update,delete,lock tables,
	to achievo@localhost identified by 'secret';		create view,drop,index
			on achievo_1_4.* to achievo@localhost identified by 'secret';
	mysql> quit;		mysql> quit;

Line 30:		Line 31:
	'achievo' and password 'secret'.		'achievo' and password 'secret'.

	''Note'': the create and ~~alter~~ privileges are only needed during installation and upgrades. You can revoke these privileges once the installation is complete.		''Note'': the create,alter,create view,drop and index privileges are only needed during installation and upgrades. You can revoke these privileges once the installation is complete.

	~~''Note 2'': if you are using '''MySQL 4 or 5''', you must also grant the 'lock tables' privilege to the user.~~
	~~mysql> grant LOCK TABLES on achievo_1_0.* to achievo@localhost identified by 'secret';~~

	== Configure Achievo's database connection ==		== Configure Achievo's database connection ==

VirtualConcepts: /* Configure Achievo's database connection */

2009-01-28T14:22:55Z

Configure Achievo's database connection

← Older revision		Revision as of 14:22, 28 January 2009
Line 37:		Line 37:
	== Configure Achievo's database connection ==		== Configure Achievo's database connection ==
	Edit the file config.inc.php in the achievo directory, and set the		Edit the file config.inc.php in the achievo directory, and set the
	$~~config_databasehost~~, $~~config_databasename~~, $~~config_databaseuser~~ and		$config_db["default"]["host"], $config_db["default"]["driver"], $config_db["default"]["db"], $config_db["default"]["user"] and
	$~~config_databasepassword, $config_database~~ variables to match your setup.		$config_db["default"]["password"] variables to match your setup.

	example:		example:
			$config_db["default"]["driver"] = "mysql";
	$~~config_databasehost~~ = "~~localhost~~";		$config_db["default"]["host"] = "localhost";
	$~~config_databasename~~ = "~~achievo_1_0~~";		$config_db["default"]["db"] = "achievo_1_0";
	$~~config_databaseuser~~ = "~~achievo~~";		$config_db["default"]["user"] = "achievo";
	$~~config_databasepassword~~ = "~~secret~~";		$config_db["default"]["password"] = "secret";
	$~~config_database~~ = "~~mysql~~";

	== Configure administrator login ==		== Configure administrator login ==

Riker: /* Create the database */

2008-02-27T23:59:48Z

Create the database

← Older revision		Revision as of 23:59, 27 February 2008
Line 33:		Line 33:

	''Note 2'': if you are using '''MySQL 4 or 5''', you must also grant the 'lock tables' privilege to the user.		''Note 2'': if you are using '''MySQL 4 or 5''', you must also grant the 'lock tables' privilege to the user.
	mysql> grant LOCK TABLES on ~~achievo~~.* to achievo@localhost identified by 'secret';		mysql> grant LOCK TABLES on achievo_1_0.* to achievo@localhost identified by 'secret';

	== Configure Achievo's database connection ==		== Configure Achievo's database connection ==