Database Installation

##Setup environment

To setup environment automatically one just sources one of environment.XXX script located in rcdb root directory.

source environment.bash      # for bash
source environment.csh       # for csh
source environment.zsh       # for zsh
source environment.fish      # for fish

If one needs to setup environment variables manually, here they are:

• RCDB_HOME - set to the rcdb directory (where environment.* scripts are located)
• PYTHONPATH - add $RCDB_HOME/python - in order to import rcdb module from python
• PATH - add "$RCDB_HOME":"$RCDB_HOME/bin":$PATH

If one wants to use C++ readout API

• LD_LIBRARY_PATH - add $RCDB_HOME/cpp/lib
• CPLUS_INCLUDE_PATH - add $RCDB_HOME/cpp/include
• PATH - add "$RCDB_HOME/bin"

##Create MySQL(MariaDB) database

Create database structure:

mysql -u root -p < schema.mysql.sql

Create user and give privilegies:

mysql -u root -p
CREATE USER rcdb;
GRANT ALL PRIVILEGES ON rcdb.* TO 'rcdb'@'localhost';