[Serusers] could not open module mysql.so

[g.billoudet at arwen-tech.fr]

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