This document is meant to be a guide for migration and testing now that a snapshot of the RM databases has been captured and installed on mysql-node01, which has MySQL server 5.5.
CMT RM Web Pages
Is it possible to make alternate cgi scripts which use as host mysql-node01 rather than glastDB? If so, we can test all functionality without any impact on production pages. Do we know where all relevant scripts are?
Instances of Use of MySQL by the CMT RM
Use of MySQL 4.1 Client Library
The CMT RM Perl scripts uses the MySQL client library indirectly via the Perl module PBI, and the MySQL driver DBD::mysql. On Linux everything we require is already installed and on rhel5 or rhel6 machines will be using MySQL 5.0 or newer client library. We need to check whether jobs on Windows also depend on the client library (likely yes) and, if so, whether a newer version needs to be installed and tested.
Reference
Perl and MySQL
http://search.cpan.org/~capttofu/DBD-mysql-3.0002/lib/DBD/mysql.pm
CMT RM Script Inventory
Cron system
The following are all mentioned in the crontab table and can be found in ~glast/infraCron:
batchSub.pl
cleanSessions.pl
createLastest.pl
logClean.pl
rmTodo.pl
workflow.pl
The same directory contains the script cron.pl