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 

}}} 

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; 

}}} 

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 ALL ON procksi_latest.* TO procksi_admin@procksi0.cs.nott.ac.uk WITH GRANT OPTION; 

GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@procksi0.cs.nott.ac.uk; 

GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@procksi1.cs.nott.ac.uk; 

GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@procksi2.cs.nott.ac.uk; 

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/admin'': 

{{{ 

msysql -u procksi_admin -p procksi_latest < procksi_latest.sql 

}}} 

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