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

View topic | History: r69 < r68 < r67 < r66 | More topic actions...