4.SetupISPyB.md

SynchWeb Development Environment for Workstations

4. Setup ISPyB

1. Clone ISPyB from GitHub

   $ cd /scratch/SynchWebDevEnvWS/server/mariadb/src
   $ git clone https://github.com/DiamondLightSource/ispyb-database --branch v1.5.2 --depth 1
   

2. Load MariaDB server module

   $ module load mariadb-server
   

3. Start MariaDB server

   $ mysqld --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf &
   

   Server starts in background, press return key to continue.

4. Start MariaDB client

   $ mysql --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf --user=root
   

   At mysql command prompt:

   > CREATE DATABASE ispyb;
   > CREATE USER 'ispyb'@'localhost' IDENTIFIED BY 'integration';
   > GRANT ALL ON ispyb.* TO 'ispyb'@'localhost';
   > FLUSH PRIVILEGES;
   > SHOW GRANTS FOR 'ispyb'@'localhost';
   > EXIT;
   

   This creates the “ispyb” database with user “ispyb” and password “integration”.

5. Setup ISPyB database

   $ cd /scratch/SynchWebDevEnvWS/server/mariadb/src/ispyb-database
   $ mysql --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf --user=root ispyb < schema/tables.sql
   $ mysql --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf --user=root ispyb < schema/lookups.sql
   $ mysql --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf --user=root ispyb < schema/routines.sql
   $ mysql --defaults-file=/scratch/SynchWebDevEnvWS/server/mariadb/my.cnf --user=root ispyb < schema/data.sql
   

6. ISPyB database connection details

   Host     : localhost
   Port     : 3306
   User     : ispyb
   Password : integration
   Database : ispyb
   

   TODO Add selected database browsers / IDEs.

7. Next : Setup SynchWeb