RE: [BLAST_ANAWARE] MySQL access from the spuds

From: Maurik Holtrop (maurik.holtrop@unh.edu)
Date: Wed Nov 27 2002 - 21:26:40 EST


Hello Adrian,

OK, that tells me more than you think.
I think the missing library is libz.so, which "ought" to have been
loaded automatically when the libmysqlclient.so loads. So that's the
problem.
"Hacking around a little" I found out how to access the MySQL db (not
hard).
The following script worked for me:

.L /usr/lib/libz.so
TSQLServer
*server=TSQLServer::Connect("mysql://blast05.lns.mit.edu:3306/BLAST,"use
r","password");
// User and password found in adrian's directory :-)
TSQLResult *res = setver->Query("show tables");
for(int i=0;i<res->GetRowCount();i++){TSQLRow
*row=res->Next();printf("%s \n"),row->GetField(0));}

It printed a bunch of tables.

Please check and see if this fixes your problem.

Cheers,

        Maurik

-----Original Message-----
From: Adrian T Sindile [mailto:asindile@cisunix.unh.edu]
Sent: Wednesday, November 27, 2002 1:00 PM
To: Maurik Holtrop
Cc: Scott Garman; maurik@improv.unh.edu; blast_anaware@rocko.mit.edu
Subject: RE: [BLAST_ANAWARE] MySQL access from the spuds

Hi, again!
Actually, the problem is not solved, I forgot the xterm I was using had
been setup for the other ROOT version (/00), so the problem is still
there for /07. I get:

dlopen error: /home/blast/adrian/./libMySQL.so: undefined symbol:
Execute__7TObjectPCcT1

when I try to run the macro from my account on the spuds. I can run the
macro from blast05 though... So the mismatch between ROOT and
libMySQL.so
on the spuds is still not understood...

Adrian

-------------------------------
Adrian Sindile
Research Assistant
Nuclear Physics Group
University of New Hampshire
phone: (603)862-1691
FAX: (603)862-2998
email: asindile@alberti.unh.edu
http://einstein.unh.edu/~adrian/



This archive was generated by hypermail 2.1.2 : Mon Feb 24 2014 - 14:07:29 EST