New subject: [Serusers] could not open module mysql.so

13 Sep 2004

Gwen,

Where did you make the ln -s libmysqlclient.so.12 libmysqlclient.so.10?

I have the same problem - and have tried to link the old embedded reference
but without success

Regards

Paul

-----Original Message-----
From: g.billoudet(a)arwen-tech.fr [mailto:g.billoudet@arwen-tech.fr] 
Sent: 10 September 2004 14:05
To: g.billoudet(a)arwen-tech.fr
Cc: serusers(a)lists.iptel.org
Subject: RE: [Serusers] could not open module mysql.so

I finally found the solution...

First, I don't know why but I had a strange link file
(libmysqlclient.so.10) in my folder /usr/local/lib/ser/modules. I deleted
it and then I got the following result of the command "ldd mysql.so" :
   linux-gate.so.1 =>  (0xffffe000)
   libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10 (0x40028000)
   libz.so.1 => /usr/lib/libz.so.1 (0x4005f000)
   libc.so.6 => /lib/tls/libc.so.6 (0x40070000)
   libcrypt.so.1 => /lib/libcrypt.so.1 (0x401b8000)
   libnsl.so.1 => /lib/libnsl.so.1 (0x401e5000)
   libm.so.6 => /lib/tls/libm.so.6 (0x401f8000)
   /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

Now, I have the same result than Zeus but I didn't have any
/usr/lib/libmysqlclient.so.10...

When I installed the libmysql12, I obtained new files in /usr/lib/
(libmysqlclient.so.12 and some others). When SER try to load mysql.so, it
looks for the library libmysqlclient.so.10 and obviously can't find it.
So I made a link with the following command :
ln -s libmysqlclient.so.12 libmysqlclient.so.10

And now, SER can load the mysql module !!

Thanks for your help Zeus !!
Bye, Gwen

...

 Hi Zeus and other serusers,

 The mysql.so file is the one I got with SER.(ser-0.8.12_linux_i386.tar.gz,
 if I remember...).

 Could you tell me what output you get with this command :
 # ldconfig -v |grep mysql
 ldconfig: Path `/usr/lib' given more than once
         libmysqlclient_r.so.12 -> libmysqlclient_r.so.12.0.0
         libmysqlclient.so.12 -> libmysqlclient.so.12.0.0
         libmysqlclient.so.10 -> libmysqlclient.so.10

 Thanks,
   Gwen

  Gwen,

 There is something wrong with your mysql.so file. Did you compile it
 yourself or download it somewhere? It doesn't look like mysql library is
 linked into it. My ldd output is like this:

 sip:/usr/local/lib/ser/modules> ldd mysql.so
         libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10
 (0x00bbb000)
         libz.so.1 => /usr/lib/libz.so.1 (0x00abf000)
         libc.so.6 => /lib/tls/libc.so.6 (0x003f3000)
         libcrypt.so.1 => /lib/libcrypt.so.1 (0x0056a000)
         libnsl.so.1 => /lib/libnsl.so.1 (0x0029e000)
         libm.so.6 => /lib/tls/libm.so.6 (0x00111000)
         libnss_files.so.2 => /lib/libnss_files.so.2 (0x00a7d000)
         libnss_dns.so.2 => /lib/libnss_dns.so.2 (0x006dd000)
         libresolv.so.2 => /lib/libresolv.so.2 (0x00967000)
         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x0036b000)

 Note the first line states that mysql.so should dynamically load the
 mysql
 library from /usr/lib/libmysqlclient.so.10. It is absent from your
 output.
 Either recompile the module or download another copy from the FTP
 server.

 Zeus

  -----Original Message-----
 From: g.billoudet(a)arwen-tech.fr [mailto:g.billoudet@arwen-tech.fr]
 Sent: Friday, 10 September 2004 5:10 PM
 To: Zeus Ng
 Cc: serusers(a)lists.iptel.org
 Subject: RE: [Serusers] could not open module mysql.so

 Thank you for your help Zeus,

 Here are the output of the commands :

 [root@linux gwen]# ldd /usr/local/lib/ser/modules/mysql.so
         linux-gate.so.1 =>  (0xffffe000)
         libz.so.1 => /usr/lib/libz.so.1 (0x40028000)
         libc.so.6 => /lib/tls/libc.so.6 (0x40039000)
         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

 [root@linux gwen]# cat /etc/ld.conf
 cat: /etc/ld.conf: No such file or directory

 [root@linux gwen]# cat /etc/ld.so.conf
 /usr/X11R6/lib
 /usr/lib/qt3/lib
 /usr/local/lib/ser/modules
 /usr/lib

   Gwen

  Gwen,

 It appears that your mysql.so is not link properly with the mysql
 library. Send the following output to the list. It may give us more
 insight on your problem.

 root#  ldd /usr/local/lib/ser/modules/mysql.so
 root#  cat /etc/ld.conf

 Zeus

> -----Original Message-----
> From: serusers-bounces(a)lists.iptel.org 
[mailto:serusers-bounces@lists.iptel.org]
 > On Behalf Of g.billoudet(a)arwen-tech.fr
> Sent: Friday, 10 September 2004 12:46 AM
> To: g.billoudet(a)arwen-tech.fr
> Cc: serusers(a)lists.iptel.org
> Subject: Re: [Serusers] could not open module mysql.so
>
>
>
> Hi,
>
> I checked my MySQL-client package. So I installed
> MySQL-client-4.0.20-0.i386.rpm. I also had to install the package
> libmysql12. But, I still have the same problem with the  load of mysql
 > module...
>
> I the folder /usr/lib, new files appeared : libmysqlclient_r.so.12@
> libmysqlclient_r.so.12.0.0*
> libmysqlclient.so.10*
> libmysqlclient.so.12@
> libmysqlclient.so.12.0.0*
>
> What 'libmysqlclient' files do you have in your folder  /usr/lib and
 > /usr/local/lib/ser/modules/ ??
>
> When I use "/usr/local/sbin/ser -c", the message of the error is a
> bit different :
>  0(2570) loading module /usr/local/lib/ser/modules/mysql.so
>  0(2570) ERROR: load_module: could not open module
> </usr/local/lib/ser/modules/mysql.so>:
> /usr/local/lib/ser/modules/mysql.so: undefined symbol:
> mysql_field_count
>  0(2570) parse error (14,13-49): failed to load module
> # ...bla bla... don't mind
> ERROR: bad config file (1 errors)
>
>
> Thanks for help
> Gwen
>
>
>

 _______________________________________________
 Serusers mailing list
 serusers(a)lists.iptel.org
 http://lists.iptel.org/mailman/listinfo/serusers

_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers

************************************************************************** 
Disclaimer 
This email transmission is confidential and intended solely for the person
or organisation to whom it is addressed. If you are not the intended
recipient, you must not copy, distribute or disseminate the information, or
take any action in reliance of it. Any views expressed in this message are
those of the individual sender, except where the sender specifically states
them to be the views of any organisation or employer. If you have received
this message in error, do not open any attachment but please notify the
sender (above) and delete this message from your system. Please rely on your
own virus check. Although all outbound mail is checked for viruses, no
responsibility is taken by the sender for any damage rising out of any bug
or virus infection. 
************************************************************************** 