Re: [ROOT] Problem loading libMySQL.so

From: Fons Rademakers (Fons.Rademakers@cern.ch)
Date: Fri Mar 01 2002 - 09:23:51 MET


Hi Luis,

  could you try to specify the paths with out trailing /. Also check
that /usr/local/mysql/include/mysql.h contains mysql_create_db().

Cheers, Fons.




On Thu, 2002-02-28 at 20:07, Luis Silva wrote:
> 	Dear Rene.
> 
> 	Now I understand what you mean.
> 
> 	1. I did all procidure steps in
> http://root.cern.ch/root/Install.html
> 
> 	using configure's flags, in my case, for mysql:
> 
> root@hb-lippc2:/usr/local/root > ./configure linux --build=--enable-mysql
> --with-mysql-libdir=/usr/local/mysql/lib/
> --with-mysql-incdir=/usr/local/mysql/include/
> Configuring for linux
> Checking for libXpm ... /usr/X11R6/lib
> Checking for libpthread ... /usr/lib
> Checking for freetype.h ... /usr/include/freetype
> Checking for libttf ... /usr/lib
> Checking for arial.ttf ... no
> Checking for GL/gl.h ... no
> Checking for libGL, or libMesaGL ... no
> Checking for libGLU, or libMesaGLU ... no
> Checking for mysql.h ... /usr/local/mysql/include/
> Checking for libmysqlclient ... /usr/local/mysql/lib/
> Checking for libpq-fe.h ... no
> Checking for libpq ... no
> Checking for sql.h ... no
> Checking for libsqlod ... no
> Checking for libpacklib, or packlib ... no
> Checking for libkernlib, or kernlib ... no
> Checking for libPythia ... no
> Checking for libPythia6 ... no
> Checking for libVenus ... no
> Checking for libshift, or shift ... no
> Checking for libdcap ... no
> Checking for t_server.h ... no
> Checking for libsrp ... no
> Checking for libgmp ... no
> Checking for base/libmisc/libmisc ... no
> Checking for pwauth.h ... no
> Writing config/Makefile.config ... done
> Writing test/Makefile ... done
> Writing include/config.h ... done
> Writing bin/root-config ... done
> Writing etc/system.rootrc ... done
> Writing etc/root.mimes ... done
> Writing bin/memprobe ... done
> 
> To use TTF fonts set the TTFontPath resource in your .rootrc file.
> To build the ROOT OpenGL add-on library see README/INSTALL.
> 
> 
> To build ROOT type:
> 
>    gmake
>    gmake install
> 
> 	2. You may see that root recognize the paths to .../lib/ and to
> .../include/
> 
> 
> 	3. But when I do gmake, I get:
> ...
> g++ -O -pipe -Wall -Woverloaded-virtual -fPIC -Iinclude/  -D_REENTRANT
> -I/usr/local/mysql/include/ -o mysql/src/TMySQLServer.o -c
> mysql/src/TMySQLServer.cxx
> mysql/src/TMySQLServer.cxx: In method `Int_t
> TMySQLServer::CreateDataBase(const char *)':
> mysql/src/TMySQLServer.cxx:201: implicit declaration of function `int
> mysql_create_db(...)'
> mysql/src/TMySQLServer.cxx: In method `Int_t
> TMySQLServer::DropDataBase(const char *)':
> mysql/src/TMySQLServer.cxx:214: implicit declaration of function `int
> mysql_drop_db(...)'
> gmake: *** [mysql/src/.o] Error 1
> 
> 
> 	4. And I also did the installation not using configure's flags,
> but instead adding this line to Makefile:
> 
> export MYSQL= /usr/local/mysql/
> 
> 
> 	And then running ./configure, and the paths are also recognized.
> 
> 	6. What am I doing wrong this time?
> 
> 	Thanks in advance, Best regards.
> 
> 	Um abraço,
> 	Luís Silva.
> 
> +*************************+***********************************+
> |Luís Silva		  |/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/|
> |Colaborator at DESY 	  |Adress:FCUL 	      		      |
> |in Hamburg Germany	  |Campo Grande, Edifício C8,room 8518|
> |Experiment Hera-b        |1749-016 Lisboa-Portugal           |
> |e-mail:Luis.Silva@desy.de|Tel.: +351 21 750 00 00 Ext.:28518 |
> +=========================+===================================+
> 
> 
> On Wed, 27 Feb 2002, Rene Brun wrote:
> 
> > Luis,
> >
> > You did not answer my questions.
> >
> > If you use the binary distributions for Linux from our Web site,
> > these libraries still require some system libraries like libmysqlclient.so
> >
> > You probably have on your system an incompatible libmysqlclient.so
> >
> > In this case, you should reinstall ROOT from source and things should be OK.
> >
> > Rene Brun
> >
> > Luis Silva wrote:
> > >
> > >         Dear Rene Brun.
> > >
> > >         Sorry i forget to tell you that, in fact, the library does
> > > libMySQL exists in the right path.
> > >
> > >         Thank you.
> > >
> > >         Um abraço,
> > >         Luís Silva.
> > >
> > > +*************************+***********************************+
> > > |Luís Silva               |/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/|
> > > |Colaborator at DESY      |Adress:FCUL                        |
> > > |in Hamburg Germany       |Campo Grande, Edifício C8,room 8518|
> > > |Experiment Hera-b        |1749-016 Lisboa-Portugal           |
> > > |e-mail:Luis.Silva@desy.de|Tel.: +351 21 750 00 00 Ext.:28518 |
> > > +=========================+===================================+
> > >
> > > On Wed, 27 Feb 2002, Rene Brun wrote:
> > >
> > > > Hi Luis,
> > > >
> > > > Did you install ROOT yourself ? If yes, did you select the MySQL option ?
> > > > see: http://root.cern.ch/root/Install.html
> > > >
> > > > When creating the binary distributions for Linux, I included libMySQL.so
> > > > for the 4 versions of Linux that we support.
> > > >
> > > > To see if you have libMySQL, simply do ls -l $ROOTSYS/lib
> > > >
> > > > Rene Brun
> > > >
> > > > Luis Silva wrote:
> > > > >
> > > > >         Dear roottalk.
> > > > >
> > > > >         What I'trying to do is to take some data from a database mysql.
> > > > > This database is in a remote machine. I have root 3.02.7 installed in my
> > > > > localhost.
> > > > >
> > > > >         At this moment, I just want to do query tests over that database,
> > > > > using
> > > > > that macro (.../tutorials/) sqlselect.C from my localhost.
> > > > >
> > > > >         But when I load the library libMySQL.so I get:
> > > > >
> > > > > root [0] .L libMySQL.so
> > > > > Error in <TRint::ProcessLine>: macro libMySQL.so not found in path
> > > > > .:/usr/local/root/macros
> > > > >
> > > > >         And the LD_LIBRARY_PATH is well define:
> > > > >
> > > > > echo $LD_LIBRARY_PATH
> > > > > ...:/usr/local/root/lib
> > > > >
> > > > >         What will be the problem?
> > > > >
> > > > >         Best Regards.
> > > > >
> > > > >         Um abraço,
> > > > >         Luís Silva.
> > > > >
> > > > > +*************************+***********************************+
> > > > > |Luís Silva               |/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/|
> > > > > |Colaborator at DESY      |Adress:FCUL                        |
> > > > > |in Hamburg Germany       |Campo Grande, Edifício C8,room 8518|
> > > > > |Experiment Hera-b        |1749-016 Lisboa-Portugal           |
> > > > > |e-mail:Luis.Silva@desy.de|Tel.: +351 21 750 00 00 Ext.:28518 |
> > > > > +=========================+===================================+
> > > >
> >
-- 
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 : Sat Jan 04 2003 - 23:50:43 MET