Current release: COOL_2_5_0

CMT documentation

How to build and run a simple COOL example using CMT

COOL_2_5_0 was built using CMT.

On lxplus (Linux SLC4 amd64)

  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
    
  2. 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.

  3. Install and build COOL
  4. 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
    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>"
    
  5. The URL's mentioned above must respect the COOL supported connection string format.

On Windows

We assume you have Windows machine with OpenAFS and Microsoft VisualStudio .NET 2003 installed.

You have to configure OpenAFS to map the directory "\afs" to a drive letter, for example "Z:".

  1. Setting up the environment
    Open a command prompt terminal.
    call "%VS71COMNTOOLS%\vsvars32.bat" > NUL
    set AFS=Z:
    set SITEROOT=%AFS%\cern.ch
    set CMTROOT=%SITEROOT%\sw\contrib\CMT\v1r20p20070208
    set CMTCONFIG=win32_vc71_dbg
    call %CMTROOT%\mgr\setup.bat
    set CMTPATH=
    set CMTPROJECTPATH=%SITEROOT%\sw\lcg\app\releases
    set AFSHOME=%AFS%\cern.ch\user\<firstletter>\<username>
    
  2. Build COOL
  3. 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
    copy %SITEROOT%\sw\lcg\app\releases\COOL\COOL_2_5_0\src\RelationalCool\tests\seal.opts.error %AFSHOME%\myLCG\COOL_2_5_0\src\Examples\seal.opts.error
    set SEAL_CONFIGURATION_FILE=%AFSHOME%\myLCG\COOL_2_5_0\src\Examples\seal.opts.error
    set CORAL_AUTH_PATH=%AFSHOME%\private
    example_Cool_UseCases <oracle URL>
    example_Cool_UseCases <mysql URL>
    example_Cool_UseCases <sqlite URL>
    

Explanation of the environment

CMTCONFIG
The string describing the platform you are on. It is the same of SCRAM_ARCH.
CMTROOT
The directory containing an installation of CMT. Currently we are using v1r20p20070208 (except on MacOSX where we are using v1r20p20070524).
CMTPROJECTPATH
This one instructs CMT about where to find the required projects (LCGCMT).
LD_LIBRARY_PATH
This is not needed by CMT, but need to be set because of a flaw in how the combination CMT/gmake works.
source $CMTROOT/mgr/setup.csh
Prepare the environment to use CMT

For any questions please contact Marco Clemencic.