Re: [ROOT] can't get to MySQL server?

From: Fons Rademakers (Fons.Rademakers@cern.ch)
Date: Thu Jun 26 2003 - 15:05:23 MEST


Hi John,

  seems database taq does not exist in the MySQL db on serverpc.

Also I've fixed the TSQLServer::Connect() to really return 0 in case of
an connection error. Fix in cvs version.

Cheers, Fons.



On Wed, 2003-06-25 at 20:41, Dr. John Krane wrote:
> Hi,
> 
> I'm using the following in my code:
> 
> TSQLServer* serv =
>      TSQLServer::Connect("mysql://serverpc.mydomain.com/taq",
> 			"myusername","mypassword");
> 
> Although I can reach the database from the Linux command line with
> 
>       mysql -h serverpc.mydomain.com -myusername -p
> 
> the code using TSQLServer gives me an error:
> 
> Error in <TMySQLServer::TMySQLServer>: connection to database taq on 
> serverpc.mydomain.com failed (error: Unknown MySQL Server Host 
> 'serverpc.mydomain.com' (1))
> Error in <TMySQLServer::Query>: not connected
> 
> Has anybody seen anything like this before?  As a possible hint, despite 
> the documentation to the contrary, the pointer "serv" does NOT return 0. 
>   (Forgive me for concealing the actual name of the serverpc with the 
> generic substitute name.)
> 
> 	- John
-- 
Org:    CERN, European Laboratory for Particle Physics.
Mail:   1211 Geneve 23, Switzerland
E-Mail: Fons.Rademakers@cern.ch              Phone: +41 22 7679248
WWW:    http://root.cern.ch/~rdm/            Fax:   +41 22 7679480



This archive was generated by hypermail 2b29 : Thu Jan 01 2004 - 17:50:12 MET