ProCKSI

h2. Database Configuration

Make sure that the [[MySQL]] daemon is running, and that it will start at boot time: 

<pre>

/sbin/service mysqld start 

/sbin/chkconfig --add mysqld 

/sbin/chkconfig mysqld on 

</pre>

Make sure that you have access to the [[MySQL]] database management as _root_ and login as user _root _with the corresponding password: 

<pre>

mysql -u root -p 

</pre>

Login/Passwords can be found on the [[secretAuthentication|Authentication]] page in the Restricted Area.

Create new mysql users _procksi_user _and _procksi_admin_: 

<pre>

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; 

</pre>

Login/Passwords can be found on the [[secretAuthentication|Authentication]] page in the Restricted Area.

Repeat these steps analogously for _procksi0-priv_, _procksi1-priv_, and _procksi2-priv._ 

Create a new database: 

<pre>

CREATE DATABASE procksi_latest; 

</pre>

Give privileges to users  _procksi_user _and _procksi_admin_ for all compute nodes: 

<pre>

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; 

</pre>

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_. On the command line, enter the following commands and provide the _procksi_admin_ password if asked:

<pre>

cd /home/procksi/RELEASE/admin

./loadDatabase.sh

</pre>

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:

<pre>

UPDATE modules SET pbs_node = 'slave';

</pre>

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