Slow Controls Time History

From CLONWiki
Revision as of 17:35, 10 January 2007 by Boiarino (talk | contribs)
Jump to navigation Jump to search

Resides in CVSROOT=/home/epics/cvs, normally checked out to /home/epics/history and running on clon01 as user epics.

Main script is:

 get_latest_cont.pl

It reads EPICS channels and updates epics database on clondb1.

Cron job is checking if main script is running (if not it will try to restart it):

 0,15,30,45 * * * * /home/epics/history/www/check_get.pl

If started by cron job, log file /home/epics/history/log/get_latest_cont.log will be produced.

Web software runs on clasweb machine. It can be found in /u/group/clas/www/clasweb/htbin/epics_history' directory, in particular file 'db_parms.pm' contains the name of database machine (in our case clondb1) and other related attributes.

DUMPING FROM clasweb-bck:

mysqldump -uroot -pe1tocome epics | gzip > /misc/mysql/clasweb-bck/epics.sql.gz mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))