ProCKSI

== Database Configuration ==
Make sure that the MySQL daemon is running, and that it will start at boot time:
{{{
/sbin/service mysqld start
/sbin/chkconfig --add mysqld
/sbin/chkconfig mysqld on
}}}

Make sure that you have access to the MySQL database management as ''root'' and login as user ''root ''with the corresponding password:
{{{
mysql -u root -p
}}}
Login/Passwords can be found on the [wiki:secretAuthentication Authentication] page in the Restricted Area.

Create new mysql users ''procksi_user ''and ''procksi_admin'':
{{{
USE mysql;
INSERT INTO user SET host='localhost', user='procksi_user', password=PASSWORD('''password_procksi_user''');
INSERT INTO user SET host='localhost', user='procksi_admin', password=PASSWORD('''password_procksi_admin''');
FLUSH PRIVILEGES;
}}}
Login/Passwords can be found on the [wiki:secretAuthentication Authentication] page in the Restricted Area.

Repeat these steps analogously for ''procksi0-priv'', ''procksi1-priv'', and ''procksi2-priv.''

Create a new database:
{{{
CREATE DATABASE procksi_latest;
}}}

Give privileges to users ''procksi_user ''and ''procksi_admin'' for all compute nodes:
{{{
GRANT ALL ON procksi_latest.* TO procksi_admin@localhost WITH GRANT OPTION;
GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@localhost;
GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO "procksi_user"@"%.procksi.local";
FLUSH PRIVILEGES;
}}}

If you change the password for ''procksi_user'', please make sure that you also change it in ''/home/procksi/latest/config/main.ini''

Import the main database ''procksi_latest'' from the backup given in ''/home/procksi/RELEASE/sql''. Enter on the command line:
''/home/procksi/RELEASE/sql'':
{{{
cd /home/procksi/RELEASE/admin
./loadDatabase.sh
}}}

Set the PBS nodes attribues so that all tasks will be executed on slave nodes only and not on the master node. After logging in into mysql:
{{{
UPDATE modules SET pbs_node = 'slave';
}}}

In order to create a database ''procksi_test'' for the test version, repeat the previous steps and set the privileges accordingly.