Search


DASWG LAL Doxygen

Docs

How-To's
Technical
Software Docs
Minutes

Download

Browse CVS, Git, or SVN
Software Repositories
OS Security Updates
LIGO software virtual machine
VMware SL6 Install

Participate

SCCB - Software Change Control Board
Edit these pages
Sub-committees
Mailing List
Telecon

Projects

DMT
DQSEGDB
Glue
GraceDB
gstlal
LALSuite
LDAS Tools
LDG Client/Server
LDR
ligoDV
LIGOtools
LVAlert Administration
LVAlert
MatApps
Metaio
NDS Client
PyLAL
LSCSOFT VM

Legacy Projects

geopp
LDAS
LDM
LIGOtools
LSCGIS
Onasys
OSG-LIGO

Details on the setup of the online analysis infrastructure at the observatories

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$