Achievo Installation

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.

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.

Unpacking

After you've link downloaded Achievo, untar the entire achievo archive to a place where you can access it with your webserver.

example:

    $ cd /usr/local/apache/htdocs # change to a web accessible directory
    $ tar xzvf ~user/achievo_x.x.tar.gz # unpack the tar.gz file

optional:

    $ ln -s achievo_x.x achievo # make a symbolic link

Create the database

Create an empty database in mysql and a user that has create, alter, select, insert, update and delete-access on the database.

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

    $ mysql -u root --password=secret mysql
    mysql> create database achievo_1_0;
    mysql> grant create,alter,select,insert,update,delete on achievo_1_0.*
           to achievo@localhost identified by 'secret';
    mysql> quit;

This creates a database named 'achievo_1_0', and a user with username '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 2: if you are using MySQL 4, you must also grant the 'lock tables' privilege to the user.