Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
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 serviceservice 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 |