Why do you use the MySQL server on "localhost" instead of pii3? How is database access to pii3 from NBI? Does it work? Is it fast or slow? Maybe you should implement a fall back list of "known" servers and connect to the "right" one depending where you are running, i.e. if hostname is *.bnl.gov, always use pii3, if hostname is *.nbi.dk, use the NBI, otherwise use "localhost" but if it is not available, use the server on pii3.brahms.bnl.gov K.O. On Wed, Jul 19, 2000 at 03:31:37PM +0200, Anders Holm wrote: > Data base testing > > In brat/test > - TestDB... programs now use a local mysql server rather than pii3. > - Operations needing mysql root privs extracted into shell scripts > TestDBCreate.sh and TestDBClean.sh. > - TestDBSetup, TestDBRead and TestDBWrite changed accordingly. > - README_TestDB has some documentation > > brat/db > - BrMainDB translates "localhost" host name to true name of local host > to make TCP/IP to be used in stead of unix sockets. (is there a better > way?) > - BrMainDB uses password parameters when connecting > > NB: If someone is thinking of using the data base software then I > would like to help you find the most convenient interface and > update the brat/db accordingly. > > Anders > ========================================================= > Anders Holm email: aholm@nbi.dk > Niels Bohr institute phone: (45) 35 32 52 13 > University of Copenhagen fax: (45) 35 32 50 16 > Blegdamsvej 17 > DK-2100 Copenhagen > Denmark > ======================================================== > -- Konstantin Olchanski Physics Department, Brookhaven National Laboratory, Long Island, New York olchansk@bnl.gov
This archive was generated by hypermail 2b29 : Thu Jul 20 2000 - 20:33:22 EDT