DataBase » History » Version 3

« Previous - Version 3/8 (diff) - Next » - Current version
Anonymous, 07/30/2008 11:34 AM


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;
INSERT INTO user SET host='localhost', user='procksi_admin', password=PASSWORD;
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/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.