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.10.2 --depth 1
   

2. Load MariaDB server module (skip if already loaded)

   module load mariadb-server

3. Start MariaDB server (skip if already started)

   mysqld --defaults-file=~/.my.cnf &

   Server starts in background, press return key to continue.

4. Start MariaDB client using the password set in the previous step.

   mysql --defaults-file=~/.my.cnf

   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=~/.my.cnf ispyb < schema/tables.sql
   mysql --defaults-file=~/.my.cnf ispyb < schema/lookups.sql
   mysql --defaults-file=~/.my.cnf ispyb < schema/routines.sql
   mysql --defaults-file=~/.my.cnf 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