Creating the mysql database schema

The DCSS code uses several tables in the mysql database to determine who is currently allowed to use a beam line.

The standard SSRL DHS code also uses the same database to extract device configurations at start up.

To create this database, first install dcss, which contains three example database dumps in the the /dcss/examples/ directory.

• databaseTables.txt

  This file is the schema only for the database. It does not contain any example entries.

• exampleFullDatabase.txt

  This file is the same as databaseTables.txt except that the file also contains a snapshot of the state of SSRL's database on a particular date. This file is probably too cluttered for everyday use.

• simpleTables.txt

  This file is the same as the databaseTables.txt except that it contains a few simple entries for a simple beam line. This is probably a good starting point for most developers.

The following directions are provided which will assist in creating the database schema.

1. Log in to the mysql database.

   blctlxx:~/release-3_2/dcss/examples >mysql -u root -p
   Enter password: 
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 12313 to server version: 3.23.53a
   
   Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
   

2. Create an empty database called beamline_configuration.

   mysql> CREATE DATABASE beamline_configuration;

3. From the unix shell prompt type:

   mysql -u root -p beamline_configuration < simpleTables.txt

4. At some point be sure to grant select permissions for dcss and all dhs programs and related hostnames. See the instructions regarding the 'GRANT' command in Configuring User permissions and Configuring DHS.