Page History

...

1. Send a message to db-admin@slac.stanford.edu and cc horner@slac.stanford.edu to ask for an account on the MySQL server glastCalibDB.slac.stanford.edu with the same permissions on the calib and calib_test databases as the horner account.   They should send you a password.
   
   1. NOTE (January 2023): Sending an email to db-admin@slac.stanford.edu will no longer generate ServiceNow Incidents. Please submit your request for SLAC IT assistance using this form: https://slacprod.servicenowservices.com/gethelp.do

2. Create a MySQL options file in your home directory called ~/.my_cal.cnf.

   1. This file will contain the database access parameters the Python scripts will use.
   2. You can use a different file with the -o parameter. It can be useful to have different files for the calib and calib_test databases.

   3. Change the permissions so that you are the only one who can read it (chmod 600).

3. Add the following lines to the file:

   Code Block
   language text title cnf file collapse true
   [client] host=glastCalibDB.slac.stanford.edu user=<your database user name> password=<your database password> database=calib (for testing use calib_test)

   You may need to enclose your password in quotes if it contains certain special characters (like #).

...