Database instance access map

Complete: 3

Access from CERN and outside

Development

Service Access Mode Connect String Auth Path
frontier sitelocal-read-only (development test) frontier://FrontierPrep/[schemaname] None
frontier siteless-read-only (commandline,webservice,small test) frontier://cmsfrontier.cern.ch:8000/FrontierPrep/[schemaname] None
direct oracle read-only oracle://cms_orcoff_prep/[schemaname] /afs/cern.ch/cms/DB/conddb
direct oracle read-write oracle://cms_orcoff_prep/[schemaname] /afs/cern.ch/cms/DB/conddb
Note: please use siteless-read-only frontier only for indicated cases and temporary small tests.
   schemaname rule: CMS_COND_XXX where XXX is detector/task name
   oracle read-only account: CMS_COND_GENERAL_R
   site-local frontier access requires site-local-config.xml file in $CMS_PATH/SITECONF/<site>/JobConfig

Integration

Service Access Mode Connect String Auth Path
frontier sitelocal-read-only (preproduction test) frontier://FrontierInt/[schemaname] None
frontier siteless-read-only (commandline,webservice,small test) frontier://cmsfrontier.cern.ch:8000/FrontierInt/[schemaname] None
direct oracle read-only oracle://cms_orcoff_int/[schemaname] /afs/cern.ch/cms/DB/conddb
direct oracle read-write not allowed not allowed
   schemaname rule: CMS_COND_<RELEASE>_XXX where XXX is detector/task name
   oracle read-only account: CMS_COND_GENERAL_R
   sitelocal frontier access requires site-local-config.xml file in $CMS_PATH/SITECONF/<site>/JobConfig
Note: please use siteless-read-only frontier only for indicated cases and temporary small tests.

Production

Service Access Mode Connect String Auth Path
frontier sitelocal-read-only (production) frontier://FrontierProd/[schemaname] None
frontier siteless-read-only (commandline,webservice,small test) frontier://cmsfrontier.cern.ch:8000/FrontierProd/[schemaname] None
direct oracle read-only oracle://cms_orcoff_prod/[schemaname] /afs/cern.ch/cms/DB/conddb
direct oracle read-write not allowed not allowed
   schemaname rule: CMS_COND_<RELEASE>_XXX where XXX is detector/task name
   oracle read-only account: CMS_COND_GENERAL_R
   site-local frontier access requires site-local-config.xml file in $CMS_PATH/SITECONF/<site>/JobConfig
Note: please use siteless-read-only frontier only for indicated cases and temporary small tests.

Access from CMS pit on .cms network

Development

Unavailable

Integration

Unavailable

Production

Service Access Mode Connect String Auth Path
frontier siteless-read-only (allowed within .cms network) frontier://(proxyurl=http://localhost:3128)(serverurl=http://localhost:8000/FrontierOnProd)(serverurl=http://localhost:8000/FrontierOnProd)(retrieve-ziplevel=0)(failovertoserver=no)/[schemaname] None
direct oracle read-only (allowed to .cms group 'onlinedb' ) oracle://cms_orcon_prod/[schemaname] /nfshome0/xiezhen/conddb/readonly
direct oracle read-write (allowed to group 'onlinedb' ) oracle://cms_orcon_prod/[schemaname] /nfshome0/xiezhen/conddb

   schemaname rule: CMS_COND_<RELEASE>_XXX where XXX is detector/task name. <RELEASE> starts from 20X
   oracle read-only account: CMS_COND_GENERAL_R

Review Status

Editor/Reviewer and date Comments
ZhenXie - 26 Jul 2006 page author
JennyWilliams - 03 Apr 2007 moved page to SWGuide
ZhenXie -10 Apr 2008 rewrite completely
Responsible: ZhenXie
Last reviewed by: Reviewer
Edit | Attach | Watch | Print version | History: r27 < r26 < r25 < r24 < r23 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r24 - 2011-06-09 - DaveDykstra



 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    CMSPublic All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback