[ROOT] MySQL and ROOT

From: Timothy E Miller (tim@bnl.gov)
Date: Wed Jun 26 2002 - 22:03:31 MEST 

Hey ROOT-ers,

Here's the scenario:

I use a perl script to fill a MySQL database, accessing
the database via:

my $dbh = DBI->connect("DBI:mysql:database=dbname;host=localhost",
                       "username", "mypasswd");

I am able to store and fetch information without any problem in
perl.

However, when I switch over to ROOT, I have difficulties.  I
can not access the database via localhost.  I have to specify
the hostname and, since I'm on a laptop, have to insert my
network card so that it can connect to the hostname.

Here's the ROOT access line:

TSQLServer *phenix =
   TSQLServer::Connect("mysql://gateway:3306/phenix","username","password");

(The gateway hostname works, localhost does not)

I'm a little perplexed at why localhost doesn't work and
haven't had much luck on documentation?  Is there better
documentation than the Class Reference pages for the
MySQL support?

I've tried to check all (I think) the obvious network problems
but seriously doubt it is network related since the perl script
works just fine (with and without network card in for both
localhost and hostname).  What am I missing?

And before you think that I've forgotten...I've tried it on
both 3.02.07 and 3.03.06 (gcc 296, Linux).

Thanks,
-Tim Miller

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Timothy E. Miller       RHIC:  PHENIX Experiment
Post-Doctoral Res Assoc  AGS:   E864, E941
Vanderbilt University   Email: tim@bnl.gov

This archive was generated by hypermail 2b29 : Sat Jan 04 2003 - 23:50:58 MET