DataBase » History » Version 5

Anonymous, 08/05/2008 12:19 PM

1 1 Anonymous
== Database Configuration == 
2 1 Anonymous
Make sure that the MySQL daemon is running, and that it will start at boot time: 
3 1 Anonymous
{{{ 
4 1 Anonymous
/sbin/service mysqld start 
5 1 Anonymous
/sbin/chkconfig --add mysqld 
6 1 Anonymous
/sbin/chkconfig mysqld on 
7 1 Anonymous
}}} 
8 1 Anonymous
	 	 
9 1 Anonymous
Make sure that you have access to the MySQL database management as ''root'' and login as user ''root ''with the corresponding password: 
10 1 Anonymous
{{{ 
11 1 Anonymous
mysql -u root -p 
12 1 Anonymous
}}} 
13 3 Anonymous
Login/Passwords can be found on the [wiki:secretAuthentication Authentication] page in the Restricted Area.
14 1 Anonymous
	 	 
15 1 Anonymous
Create new mysql users ''procksi_user ''and ''procksi_admin'': 
16 1 Anonymous
{{{ 
17 1 Anonymous
USE mysql; 
18 1 Anonymous
INSERT INTO user SET host='localhost', user='procksi_user', password=PASSWORD('''password_procksi_user'''); 
19 1 Anonymous
INSERT INTO user SET host='localhost', user='procksi_admin', password=PASSWORD('''password_procksi_admin'''); 
20 1 Anonymous
FLUSH PRIVILEGES; 
21 1 Anonymous
}}} 
22 3 Anonymous
Login/Passwords can be found on the [wiki:secretAuthentication Authentication] page in the Restricted Area.
23 1 Anonymous
	 	 
24 1 Anonymous
Repeat these steps analogously for ''procksi0-priv'', ''procksi1-priv'', and ''procksi2-priv.'' 
25 1 Anonymous
	 	 	 
26 1 Anonymous
Create a new database: 
27 1 Anonymous
{{{ 
28 1 Anonymous
CREATE DATABASE procksi_latest; 
29 1 Anonymous
}}} 
30 1 Anonymous
	 	 
31 1 Anonymous
Give privileges to users  ''procksi_user ''and ''procksi_admin'' for all compute nodes: 
32 1 Anonymous
{{{ 
33 1 Anonymous
GRANT ALL ON procksi_latest.* TO procksi_admin@localhost WITH GRANT OPTION; 
34 1 Anonymous
GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO procksi_user@localhost; 
35 2 Anonymous
GRANT SELECT, UPDATE, INSERT, DELETE ON procksi_latest.* TO "procksi_user"@"%.procksi.local"; 
36 1 Anonymous
FLUSH PRIVILEGES; 
37 1 Anonymous
}}} 
38 1 Anonymous
	 	 
39 1 Anonymous
If you change the password for ''procksi_user'', please make sure that you also change it in ''/home/procksi/latest/config/main.ini'' 
40 1 Anonymous
41 5 Anonymous
Import the main database ''procksi_latest'' from the backup given in ''/home/procksi/RELEASE/sql'': 
42 1 Anonymous
{{{ 
43 5 Anonymous
cd /home/procksi/RELEASE/admin
44 5 Anonymous
./loadDatabase.sh
45 1 Anonymous
}}} 
46 1 Anonymous
47 1 Anonymous
In order to create a database ''procksi_test'' for the test version, repeat the previous steps and set the privileges accordingly.