LSC Data Analysis Software Working Groups

Introduction

This page documents the setup of the BOSS databases at the observatories.

Setup of databases needed by onasys

In order to run onasys, the BOSS database needs to be configured. These services need a mySQL database and so we use the one from LDR since it is already configured on gateway. The following must be done as user grid on that gateway machine. The grid user has the following environment set up

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/ldcg/lib
export PATH=${PATH}:/ldcg/bin

source /ldcg/LDR/setup.sh

export GLUE_LOCATION=/ldcg/glue
. ${GLUE_LOCATION}/etc/glue-user-env.sh

export PS1="[\u@\h \W]\$ "

export TERM=xterm

X509_USER_CERT=/ldcg/LDR/ldr/etc/datarobotcert.pem
X509_USER_KEY=/ldcg/LDR/ldr/etc/datarobotkey.pem
export X509_USER_CERT X509_USER_KEY

mySQL configuration

Configure the mySQL database to accept network connections over the internal interface by stopping LDR, RLS and mySQL. See the LDR documentation for details on how to do this. The config file used by the LDR instance of mySQL is

/ldcg/LDR/mysql/data/my.cnf

which should be a symlink to

/export/LDR-local/mysql/data/my.cnf

Edit the my.cnf file and comment out the

skip-networking

line. In the [mysqld] section of the config file, add the line

bind-address = 10.12.0.5

where 10.12.0.5 should be replaced by the internal network address of the particular gateway machine being configured. Save the changes and restart mySQL, RLS and LDR according to the LDR instructions.

Create BOSS databases

There are three scripts that need to be run to create and configure the BOSS database. They are MySQLconfig.sql, MySQLGridConfig.sql and create_dag_tables.sql. You will need to edit MySQLconfig.sql and MySQLGridConfig.sql to set the password that onasys will use to communicate over the internal network with MySQL. The word PASSWORD must be replaced with the actual password for onasys. Run the scripts with:

[grid@ldas grid]$ mysql --user=root -p < MySQLconfig.sql
Enter password: 
[grid@ldas grid]$ mysql --user=root -p < MySQLGridConfig.sql
Enter password: 
[grid@ldas grid]$ mysql --user=root -p < create_dag_tables.sql
Enter password: 

to create the databases.

TODO: Can we make these grant statements more restrictive? What is the minimum users need to run onasys?

On the ldas-grid machine the command

onasys/src/sched_dagman/registerDAGManScheduler

from the onasys CVS must be run once by the admin so that BOSS knows about DAGman.

$Id: boss_setup.html,v 1.3 2005/10/25 21:17:49 bmoe Exp $