Re: brahms db access screwed up?

From: Christian Holm Christensen (cholm@hehi03.nbi.dk)
Date: Thu Jun 12 2003 - 10:45:07 EDT

Next message: Stephen J. Sanders: "Re: dAu setup and analysis question"

Previous message: Flemming Videbaek: "Fw: CTS: ticket 8805 videbaek Farm General"
In reply to: Jens Ivar Jordre: "Re: brahms db access screwed up?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Hi Jens Ivar et al, 

Jens Ivar Jordre <jensivar.jordre@fi.uib.no> wrote concerning
  Re: brahms db access screwed up? [Wed, 11 Jun 2003 23:25:21 +0200] 
----------------------------------------------------------------------
> Hi Steve and Brett.
> 
> I just met the same problem. I believe the reason is that the DNS 
> entries for 130.199.6.80 at BNL have not been updated properly. Our 
> BrahmsMain database contains the IP address for the host of the 
> calibration and geometry databases, which from within BNL (as far Hiro 
> and I can figure out) still points to rcas0005.

The IP number of brahms-db0.rcf.bnl.gov is 130.199.6.80, and 
rcas0005.rcf.bnl.gov is a DNS alias for brahms-db0.rcf.bnl.gov: 

  > host rcas0005.rcf.bnl.gov
  rcas0005.rcf.bnl.gov is an alias for brahms-db0.rcf.bnl.gov.
  brahms-db0.rcf.bnl.gov has address 130.199.6.80

> The remedy is to put both rcas0005 and brahms-db0 lines into your 
> .bratdb file. I.e. for the same DB have one line with rcas0005 as host 
> and another one with brahms-db0 as host.

I've changed the entries in BrahmsMain to point be
`brahms-db0.rcf.bnl.gov' (as I pointed out [1] back in April).  If
that causes problems, please change those back to the IP number: 

  localhost> ssh -t rssh.rcf.bnl.gov ssh brahms-db0
  brahms-db0> mysql -u root -p BrahmsMain
  mysql> UPDATE DB host='130.199.6.80' WHERE host LIKE "brahms-db0.%"; 
  mysql> \q
  brahms-db0> logout
  localhost> 

Some DNS' may need to be updated.  That was anyway the problem the
last time we had some problems. 

BTW. did those of you that have seen `Matrix Reloaded' notice what
system Trinity breaks into?  She does: 

  ssh -l root 127.0.0.1 

I bet you the password is `root' :-) 

Yours,

 ___  |  Christian Holm Christensen 
  |_| |	 -------------------------------------------------------------
    | |	 Address: Sankt Hansgade 23, 1. th.  Phone:  (+45) 35 35 96 91
     _|	          DK-2200 Copenhagen N       Cell:   (+45) 24 61 85 91
    _|	          Denmark                    Office: (+45) 353  25 305
 ____|	 Email:   cholm@nbi.dk               Web:    www.nbi.dk/~cholm
 | |

[1] http://www.sdcc.bnl.gov/brahms/private/list_hyper/brahms-dev-l/2559.html

Next message: Stephen J. Sanders: "Re: dAu setup and analysis question"
Previous message: Flemming Videbaek: "Fw: CTS: ticket 8805 videbaek Farm General"
In reply to: Jens Ivar Jordre: "Re: brahms db access screwed up?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.5 : Thu Jun 12 2003 - 10:46:17 EDT