Installing COOL on Linux

We assume you to install COOL on lxplus using SLC4 amd64.

The following instructions are formalized by Marco Clemencic. Feedback and suggentions are welcome.

1. Login lxplus, configure CMT, create working directory

      ssh lxplus.cern.ch
      tcsh
      setenv AFS /afs
      setenv SITEROOT $AFS/cern.ch
      setenv CMTROOT $SITEROOT/sw/contrib/CMT/v1r20p20070524
      setenv CMTCONFIG slc4_amd64_gcc34
      source $CMTROOT/mgr/setup.csh
      unsetenv ORACLE_HOME
      unsetenv PYTHONPATH
      unsetenv ROOTSYS
      unsetenv CMTPATH
      setenv CMTPROJECTPATH $SITEROOT/sw/lcg/app/releases
      setenv LD_LIBRARY_PATH
      mkdir -p ~/myLCG
      rm -rf ~/myLCG/COOL_2_5_0

Note

if you want to use SLC4 with the 32 bits OS version, connect to lx32slc4.cern.ch and set CMTCONFIG to slc4_ia32_gcc34.

2. Install and build COOL

• 2a - Create a new complete installation

            mkdir -p ~/myLCG/COOL_2_5_0
            cd ~/myLCG/COOL_2_5_0
            cvs -d :pserver:anonymous@cool.cvs.cern.ch:/cvs/COOL co -r COOL_2_5_0 -P cool.release
            cd src/config/cmt
            cmt broadcast cmt config
            cmt broadcast make
            cmt broadcast -select=Examples make examples

• 2b - Create a local CMT satellite

            mkdir -p ~/myLCG/MyCOOL_2_5_0/src/cmt
            cd ~/myLCG/MyCOOL_2_5_0/src
            cat > cmt/project.cmt <<EOF
            project MyCOOL_2_5_0
            use COOL COOL_2_5_0/src
            EOF
            cvs -d :pserver:anonymous@cool.cvs.cern.ch:/cvs/COOL co -r COOL_2_5_0 -P -d Examples cool/Examples
            cd Examples/cmt
            cmt config
            make examples
            source $SITEROOT/sw/lcg/app/releases/COOL/COOL_2_5_0/src/config/cmt/setup.csh

3. Run the usecases

Run the usecases example for Oracle, MySQL and SQLite. The way you set up the environment to run the example depends on the previous step.

• 3a - For a complete installation

            source ~/myLCG/COOL_2_5_0/src/config/cmt/setup.csh

• 3b - For a local satellite

            source $SITEROOT/sw/lcg/app/releases/COOL/COOL_2_5_0/src/config/cmt/setup.csh

      cp /afs/cern.ch/sw/lcg/app/releases/COOL/COOL_2_5_0/src/RelationalCool/tests/seal.opts.error ~/myLCG/COOL_2_5_0/src/Examples/seal.opts.error
      setenv SEAL_CONFIGURATION_FILE ~/myLCG/COOL_2_5_0/src/Examples/seal.opts.error
      setenv CORAL_AUTH_PATH ${HOME}/private
      example_Cool_UseCases "<oracle URL>"
      example_Cool_UseCases "<mysql URL>"
      example_Cool_UseCases "<sqlite URL>"

Note: The URL's mentioned above must respect the COOL supported connection string format.

-- AlexLoth - 14-Jan-2010