[Serusers] could not open module mysql.so

[Zeus Ng]

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 at arwen-tech.fr [mailto:g.billoudet at arwen-tech.fr] 
> Sent: Friday, 10 September 2004 5:10 PM
> To: Zeus Ng
> Cc: serusers at 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 at 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 at linux gwen]# cat /etc/ld.conf
> cat: /etc/ld.conf: No such file or directory
> 
> [root at 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 at lists.iptel.org 
> [mailto:serusers-bounces at lists.iptel.org] 
> >> On Behalf Of g.billoudet at arwen-tech.fr
> >> Sent: Friday, 10 September 2004 12:46 AM
> >> To: g.billoudet at arwen-tech.fr
> >> Cc: serusers at 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
> >>
> >>
> >>
> >
> >
>