Re: [ROOT] Problem loading libMySQL.so (fwd)

From: Luis Silva (lsilva@mail.desy.de)
Date: Fri Mar 01 2002 - 09:30:13 MET


	Sorry again.

	I forget to tell you the versions of ROOT and MySQL

	ROOT 3.20.07

	MySQL 4.01


	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 |
+=========================+===================================+


---------- Forwarded message ----------
Date: Thu, 28 Feb 2002 20:07:24 +0100
From: Luis Silva <lsilva@hera-b.desy.de>
To: Rene Brun <Rene.Brun@cern.ch>
Cc: roottalk@root.cern.ch
Subject: Re: [ROOT] Problem loading libMySQL.so

	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 |
> > > > +=========================+===================================+
> > >
>



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