Difference: SystemAdministratorGuideForEMI1 (64 vs. 65)

Revision 652012-04-20 - EricFrizziero

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

System Administrator Guide for CREAM for EMI-1 release

Line: 1505 to 1505
 mysql> select jstd.name, count(*) from job, job_status_type_description jstd, 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 job.id=status.jobId and jstd.type=status.type group by jstd.name;
Added:
>
>

0.1 How to clean the CREAM databases, sandboxes, log files?

[1] stop the service

      service tomcat5 stop

[2] delete cream log files

     rm -rf /var/log/cream/*

[3] delete tomcat log files

     rm -rf /var/log/tomcat5/*

[4] drop databases

      DROP DATABASE creamdb;
      DROP DATABASE delegationdb;

[5] delete sandboxes (see the value of the "CREAM_SANDBOX_DIR" parameter in the /etc/glite-ce-cream/cream-config.xml file)

      rm -rf "CREAM_SANDBOX_DIR"

[6] configure via yaim see: https://wiki.italiangrid.it/twiki/bin/view/CREAM/SystemAdministratorGuideForEMI1#1_4_CREAM_CE_configuration

 -- MassimoSgaravatto - 2011-04-07
 
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