From: Jens Ivar Jordre (jensivar.jordre@fi.uib.no)
Date: Mon Apr 28 2003 - 06:15:08 EDT
Howdy Flemming et al. Your scheme works well from the rcas nodes as far as I can tell. But brahms-db0.rcf.bnl.gov is not visible from outside BNL. Somebody has forgotten to update the necessary firewalls configs. I've submitted a problem ticket (number 8644). Until this problem has been fixed, I stumbled accross a solution. If in your bratmain config script you specify the IP address of rcas0005, i.e. 130.199.6.80, the MySQL server (I guess) still returns rcas0005 and not brahms-db0. So unless you've updated your .bratdbrc as described below, it should work. If on the other hand you have brahms-db0.rcf.bnl.gov as your main db host, then you run into trouble: Error in <TMySQLServer::TMySQLServer>: connection to database BrahmsMain on brahms-db0.rcf.bnl.gov failed (error: Unknown MySQL Server Host 'brahms-db0.rcf.bnl.gov' (4)) Best wishes from Jens Ivar Flemming Videbaek wrote: > Hi > The name of the db server has been changed to brahms-db0... > Even though rcas0005 is still known it seems our access i.e. what the machine and mysql thinks is still > the new-name. It seems at this point you MUST change your .bratdbrc files > ie. rcas0005.rcf.bnl.gov BrahmsMain query xxxxx -> to > brahms-db0.rcf.bnl.gov BrahmsMain query xxxxx and so on. > Please also revise your files ; you probably got ours from someone else > the normal usage should only have - passwords omitted.. > pii3 RUNDB > brahms-db0 .. BrahmsMain query .. > brahms-db0 .. BrahmsCalib query .. > brahms-db0 .. BrahmsGeom query ... > brahms-db0 .. BrahmsCalib insert ;; If you are making calibrations. > > Usually there should not be inserts for BrahmsGeom, and there is definite no need to have > brahmlib as an access account. > > Flemming > > ------------------------------------------------------ > Flemming Videbaek > Physics Department > Brookhaven National Laboratory > > tlf: 631-344-4106 > fax 631-344-1334 > e-mail: videbaek@bnl.gov > > ----- Original Message ----- > From: "Tony W. Chan" <tony@bnl.gov> > To: <videbaek@bnl.gov>; <ejkim@bnl.gov> > Sent: Friday, April 25, 2003 4:52 PM > Subject: rcas0005 > > > | Hi Flemming, > | > | ITD changed the name of rcas0005.rcf.bnl.gov to > | brahms-db0.rcf.bnl.gov, and made rcas0005 a DNS > | alis for brahms-db0. BRAHMS users should not have > | noticed any disruption in their access to rcas0005. > | Can you pass this information to BRAHMS users, and > | have them change rcas0005 to brahms-db0 wherever > | they have it in their code? > | > | We'll leave rcas0005 as an alias for brahms-db0 for > | 1-2 months so people have the chance to migrate to > | the new name. > | > | In 5-6 weeks, I will send a reminder regarding > | migration to brahms-db0. Thanks. > | > | Cheers, > | > | Tony > | > | > > -- _____________________________________________________ ________| Jens Ivar Jřrdre |_______ \ | Dept. of Physics Office: 521 | / \ | Allégt 55 Phone: +47 55 58 27 92 | / \ | 5007 Bergen Fax: +47 55 58 94 40 | / / | Norway E-mail: jensivar.jordre@fi.uib.no | \ / |_____________________________________________________| \ /__________) (_________\
This archive was generated by hypermail 2.1.5 : Mon Apr 28 2003 - 06:16:09 EDT