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

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.