[Brahms-dev-l] Re: Brahms-dev-l post from slindal@student.matnat.uio.no requires approval

    Hello.  If you want to submit mail to this list, you must register 
your mail address at first. You can register at 
http://lists.bnl.gov/mailman/listinfo    (I am forwarding it to 
brahms-dev-l)

    Now, about your problem, you must not have done this for long time 
(or not for recent runs).  Our RUNDB database is not pii3 anymore (since 
last October or so.)  It is replaced by brahms-rundb0.brahms.bnl.gov.   
(pii3 could have been used for upto run 04 since DB in pii3 was never 
stopped.  However, BNL firewall for access to pii3 was recently closed 
by ITD.  Hence, it does not work anymore.


Hiro


> ------------------------------------------------------------------------
>
> Subject:
> connect to database
> From:
> Svein Lindal <slindal@student.matnat.uio.no>
> Date:
> Fri, 29 Apr 2005 10:49:15 +0200 (CEST)
> To:
> brahms-dev-l@lists.bnl.gov
>
> To:
> brahms-dev-l@lists.bnl.gov
>
>
>Hello
>
>I'm trying to run Bjorns FLAP on the DSTS and I'm told that access to
>database is
>denied for user svein although I'm trying to connect as query:
>
>rcas0018(4) ~/svein>nice bratroot -l -q Processdst008307v10.C
> ********************************************
> *                                          *
> *       W E L C O M E  to  B R A T         *
> *             Version  2.25/09             *
> *                                          *
>brat [0]
>Processing Processdst008307v10.C...
>Adding file alldsts/dst008307v10.root
>Warning in <TClass::TClass>: no dictionary for class BdstRun is available
>Warning in <TClass::TClass>: no dictionary for class BdstGlobal is
>available
>Warning in <TClass::TClass>: no dictionary for class BdstFsTrack is
>available
>Warning in <TClass::TClass>: no dictionary for class BdstTrack is
>available
>Warning in <TClass::TClass>: no dictionary for class BdstMagnet is
>available
>Warning in <TClass::TClass>: no dictionary for class BdstTof is available
>Warning in <TClass::TClass>: no dictionary for class BdstC1 is available
>Warning in <TClass::TClass>: no dictionary for class BdstRich is available
>Warning in <TClass::TClass>: no dictionary for class BdstMrsTrack is
>available
>Warning in <TClass::TClass>: no dictionary for class BdstC4 is available
>Warning in <TClass::TClass>: no dictionary for class BdstTpm1Track is
>available
>Attempting to connect to database...
>Error in <TMySQLServer::TMySQLServer>: connection to database RUNDB on
>brahms-ru ndb0.brahms.bnl.gov failed (error: Access denied for user
>'svein'@'rcas0018.rcf. bnl.gov' (using password: NO))
>Error in <BrRdbmDb::Connect>: User  couldn't connect to database RUNDB @
>brahms- rundb0.brahms.bnl.gov
>Error in <BrRdbmMainDb::ConnectToDb>: couldn't connect to database RUNDB
>Error - couldn't connect!
>rcas0018(5) ~/svein>
>
>
>my .bratdbrc looks like this:
>brahms-db0.rcf.bnl.gov BrahmsMain   insert run2001
>brahms-db0.rcf.bnl.gov BrahmsCalib  insert run2001
>brahms-db0.rcf.bnl.gov BrahmsGeom   insert run2001
>brahms-db0.rcf.bnl.gov BrahmsMain query query-only
>brahms-db0.rcf.bnl.gov BrahmsCalib query query-only
>brahms-db0.rcf.bnl.gov BrahmsGeom query query-only
>brahms-db0.rcf.bnl.gov RUNDB query query-only
>pii3.brahms.bnl.gov RUNDB query query-only
>
>
>and this is the code where flap tries to connect:
>
>Int_t flapPidLooper::ConnectToDatabase() {
>
>  BrMainDb* mainDb = BrMainDb::Instance();
>  mainDb->SetUserName("query");
>  mainDb->SetHostName("brahms-db0.rcf.bnl.gov");
>  mainDb->SetDbName("BrahmsMain");
>
>  if (!mainDb->Connect())
>    return 0;
>  if (!mainDb->ConnectToCalib())
>    return 0;
>  if (!mainDb->ConnectToRun())
>    return 0;
>  if (!mainDb->ConnectToGeom())
>    return 0;
>
>  return 1;
>
>}
>
>I used to be able to connect with this setup some months ago.
>Does anyone have a suggestion as to what is wrong?
>
>Thanks a lot for your attention
>Svein.
>
>
>  
>


_______________________________________________
Brahms-dev-l mailing list
Brahms-dev-l@lists.bnl.gov
http://lists.bnl.gov/mailman/listinfo/brahms-dev-l