Difference: SystemAdministratorGuideForEMI1 (49 vs. 50)

Revision 502011-11-02 - MassimoSgaravatto

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

System Administrator Guide for CREAM for EMI-1 release

Line: 680 to 680
 
  • Configure via yaim
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.
Changed:
<
<
The files where the database names are specified are:
>
>
The files where the database names are specified and should be changed before configuring via yaim are:
 
Changed:
<
<
  • $CATALINA_HOME/conf/Catalina/localhost/ce-cream.xml (created by yaim using as template /etc/glite-ce-cream/ce-cream.xml) in the following lines:
>
>
  • /etc/glite-ce-cream/ce-cream.xml (which is the template used by yaim to create $CATALINA_HOME/conf/Catalina/localhost/ce-cream.xml. In the following lines creamdb and delegationdb should be replaced with the new names:
 
 url="jdbc:mysql://localhost:3306/creamdb"
Line: 694 to 694
 url="jdbc:mysql://localhost:3306/delegationdb?autoReconnect=true"
Changed:
<
<
It must NOT be changed in the following line:
>
>
You must NOT change in the following line:
 
<Resource name="jdbc/creamdb" 
Changed:
<
<
  • /etc/glite-ce-cream/createAndPopulateDB.sh in the following line:
>
>
  • /etc/glite-ce-cream/createAndPopulateDB.sh. In the following line creamdb should be replaces with the chosen db name:
 
 if [ $3 == "creamdb" -a -d /opt/glite/var/cream_sandbox ] ; then
Changed:
<
<
  • /etc/glite-ce-cream/populate_creamdb_mysql.sql in the following lines:
>
>
  • /etc/glite-ce-cream/populate_creamdb_mysql.sql. In the following lines creamdb should be replaces with the chosen db name:
 
/************ Drop: Database ***************/
Line: 719 to 720
 USE creamdb;
Changed:
<
<
  • /etc/glite-ce-cream/populate_delegationdb.sql in the following line:
>
>
  • /etc/glite-ce-cream/populate_delegationdb.sql. in the following lines delegationdb should be replaced with the chosen db name :
 
/************ Drop: Database ***************/
Line: 733 to 734
 use delegationdb;
Changed:
<
<
  • /usr/bin/glite_cream_load_monitor in the following line:
>
>
  • /usr/bin/glite_cream_load_monitor. In the following line creamdb should be replaced with the chosen db name:
 
 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');\""; 
Added:
>
>
  • /etc/glite-ce-cream/cream-config.xml.template (which is used by yaim to generate /etc/glite-ce-cream/cream-config.xml). In this file add:

<cream db name>_database_version="2.4"
<delegation db name>_database_version="2.4"

just after:

creamdb_database_version="2.4"
delegationdb_database_version="2.4"

  • /opt/glite/yaim/functions/config_cream_db. In the following lines, creamdb and delegationdb should be replaced with the chosen db names:

  create_mysql_db creamdatabase ${CREAM_DB_USER} ${CREAM_DB_PASSWORD}  "${GLITE_CREAM_LOCATION_ETC}/glite-ce-cream/populate_creamdb_mysql.sql" ${CREAM_DB_HOST} \
    && create_mysql_db delegationdatabase ${CREAM_DB_USER} ${CREAM_DB_PASSWORD} "${GLITE_CREAM_LOCATION_ETC}/glite-ce-cream/populate_delegationdb.sql" ${CREAM_DB_HOST} \

  • /opt/glite/yaim/functions/config_cream_ce. In the following lines, creamdb and delegationdb should be replaced with the chosen db names:

-e "s/url=\"jdbc:mysql:\/\/localhost:3306\/delegationdb?autoReconnect=true/url=\"jdbc:mysql:\/\/${CREAM_DB_HOST}:3306\/delegationdb\?autoReconnect=true/" \
-e "s/url=\"jdbc:mysql:\/\/localhost:3306\/creamdb\"/url=\"jdbc:mysql:\/\/${CREAM_DB_HOST}:3306\/creamdb\"/" \

  • /opt/glite/yaim/functions/config_cream_drop. In the following lines, creamdb and delegationdb should be replaced with the chosen db names:

 mysqlshow --password="$MYSQL_PASSWORD" | grep "creamdatabase" > /dev/null 2>&1

mysql -u root --password="$MYSQL_PASSWORD" -e "DROP DATABASE creamdatabase"

mysqlshow --password="$MYSQL_PASSWORD" | grep "delegationdatabase" > /dev/null 2>&1

mysql -u root --password="$MYSQL_PASSWORD" -e "DROP DATABASE delegationdatabase"
 

0.0.1 Configuration of the CREAM CLI

The CREAM CLI is part of the EMI-UI. To configure it please refer to https://twiki.cern.ch/twiki/bin/view/EMI/EMIui#Client_Installation_Configuratio.

 
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