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:

{{{ 

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.