Difference: SystemAdministratorGuideForEMI1 (47 vs. 48)

Revision 482011-11-02 - MassimoSgaravatto

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

System Administrator Guide for CREAM for EMI-1 release

Line: 689 to 689
  The files where the database names are specified are:
Changed:
<
<
  • ce-cream.xml in the following lines:
>
>
  • $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:
 
 url="jdbc:mysql://localhost:3306/creamdb"
Line: 707 to 707
 <Resource name="jdbc/creamdb"
Changed:
<
<
  • createAndPopulateDB.sh in the following line:
>
>
  • /etc/glite-ce-cream/createAndPopulateDB.sh in the following line:
 
 if [ $3 == "creamdb" -a -d /opt/glite/var/cream_sandbox ] ; then
Changed:
<
<
  • populate_creamdb_mysql.sql in the following line:
>
>
  • /etc/glite-ce-cream/populate_creamdb_mysql.sql in the following lines:
 
Added:
>
>
/************ Drop: Database ***************/ DROP DATABASE IF EXISTS creamdb;

/************ Create: Database ***************/

 CREATE DATABASE creamdb;
Added:
>
>
/************ Use: Database ***************/ USE creamdb;
 
Changed:
<
<
  • populate_delegationdb.sql in the following line:
>
>
  • /etc/glite-ce-cream/populate_delegationdb.sql in the following line:
 
Added:
>
>
/************ Drop: Database ***************/
 DROP DATABASE IF EXISTS delegationdb;
Added:
>
>
/************ Create: Database ***************/ CREATE DATABASE delegationdb;

/************ Use Delegation DB ***************/

use delegationdb;

 
Changed:
<
<
  • glite_cream_load_monitor in the following line:
>
>
  • /usr/bin/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');\""; 
 
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