Difference: SystemAdministratorGuideForEMI1 (45 vs. 46)

Revision 462011-11-02 - MassimoSgaravatto

Line: 1 to 1
 
META TOPICPARENT name="SystemAdministratorDocumentation"

System Administrator Guide for CREAM for EMI-1 release

Line: 680 to 680
 
  • Set in the siteinfo.def file the variable MYSQL_PASSWORD considering the mysql password of the remote host
  • On this remote host, grant appropriate privs to root@CE_HOST
  • Configure via yaim
Changed:
<
<
Please note that, because of bug #88078, the name of the databases are hardwired in some files to creamdb and delegationdb. This means there are problems if the same mysql server host should be used to host the databases of multiple CREAM CEs.
>
>
Please note that, because of bug #88078, the name of the databases are hardwired in some files to creamdb and delegationdb. This means that some manual hacks are needed if the same mysql server host should be used to host the databases of multiple CREAM CEs.

The files where the database names are specified are:

  • ce-cream.xml in the following lines:

 url="jdbc:mysql://localhost:3306/creamdb"

and:

url="jdbc:mysql://localhost:3306/delegationdb?autoReconnect=true"

It must NOT be changed in the following line:

<Resource name="jdbc/creamdb" 

  • createAndPopulateDB.sh in the following line:

 if [ $3 == "creamdb" -a -d /opt/glite/var/cream_sandbox ] ; then

  • populate_creamdb_mysql.sql in the following line:

CREATE DATABASE creamdb;

  • populate_delegationdb.sql in the following line:

DROP DATABASE IF EXISTS delegationdb; 

  • glite_cream_load_monitor in the following line:

 my $querycmd= "mysql -B --skip-column-names -u" . $userdb . " --password=\"" . $passworddb . "\" -e \"use creamdb;select count(*) from job_status AS status LEFT OUTER JOIN job_status AS latest ON latest.jobId=status.jobId AND status.id < latest.id WHERE latest.id IS null AND status.type IN ('0','1','2','3','4','6');\""; 

 

0.0.1 Configuration of the CREAM CLI

 
This site is powered by the TWiki collaboration platformCopyright © 2008-2021 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback