<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: [Serusers] could not open module mysql.so</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2743.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Trebuchet MS" size=2>If recompilation if done and dont work you
can use strace to see where are SER searching libmysqlclient:</FONT></DIV>
<DIV><FONT face="Trebuchet MS" size=2></FONT> </DIV>
<DIV><FONT face="Trebuchet MS" size=2>> strace ser -D
2>execlog</FONT></DIV>
<DIV><FONT face="Trebuchet MS" size=2>> grep "libmysqlclient"
execlog</FONT></DIV>
<DIV><FONT face="Trebuchet MS" size=2></FONT> </DIV>
<DIV><FONT face="Trebuchet MS" size=2>Probably SER try to open
/lib/libmysqlclient.so.12 and your mysql installation put the library under
/usr/lib/mysql</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ecolombo@arcotel.net href="mailto:ecolombo@arcotel.net">Ezequiel
Colombo</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=Paul.Cowie@dataflex.com
href="mailto:Paul.Cowie@dataflex.com">Paul Cowie</A> ; <A
title=g.billoudet@arwen-tech.fr
href="mailto:g.billoudet@arwen-tech.fr">g.billoudet@arwen-tech.fr</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, September 13, 2004 1:58
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Serusers] could not open
module mysql.so</DIV>
<DIV><BR></DIV>
<DIV><FONT face="Trebuchet MS" size=2>I think that this is due to mysql
upgrade from 3.23 to 4.</FONT></DIV>
<DIV><FONT face="Trebuchet MS" size=2>Try recompiling the ser mysql
module</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Paul.Cowie@dataflex.com href="mailto:Paul.Cowie@dataflex.com">Paul
Cowie</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=g.billoudet@arwen-tech.fr
href="mailto:g.billoudet@arwen-tech.fr">g.billoudet@arwen-tech.fr</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, September 13, 2004 1:25
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Serusers] could not open
module mysql.so</DIV>
<DIV><BR></DIV>
<P><FONT size=2>Gwen,</FONT> </P>
<P><FONT size=2>Where did you make the ln -s libmysqlclient.so.12
libmysqlclient.so.10?</FONT> </P>
<P><FONT size=2>I have the same problem - and have tried to link the old
embedded reference but without success</FONT> </P>
<P><FONT size=2>Regards</FONT> </P>
<P><FONT size=2>Paul</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: <A
href="mailto:g.billoudet@arwen-tech.fr">g.billoudet@arwen-tech.fr</A> [<A
href="mailto:g.billoudet@arwen-tech.fr">mailto:g.billoudet@arwen-tech.fr</A>]
</FONT><BR><FONT size=2>Sent: 10 September 2004 14:05</FONT> <BR><FONT
size=2>To: <A
href="mailto:g.billoudet@arwen-tech.fr">g.billoudet@arwen-tech.fr</A></FONT>
<BR><FONT size=2>Cc: <A
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A></FONT> <BR><FONT
size=2>Subject: RE: [Serusers] could not open module mysql.so</FONT> </P>
<P><FONT size=2>I finally found the solution...</FONT> </P>
<P><FONT size=2>First, I don't know why but I had a strange link file</FONT>
<BR><FONT size=2>(libmysqlclient.so.10) in my folder
/usr/local/lib/ser/modules. I deleted</FONT> <BR><FONT size=2>it and then I
got the following result of the command "ldd mysql.so" :</FONT> <BR><FONT
size=2> linux-gate.so.1 => (0xffffe000)</FONT>
<BR><FONT size=2> libmysqlclient.so.10 =>
/usr/lib/libmysqlclient.so.10 (0x40028000)</FONT> <BR><FONT
size=2> libz.so.1 => /usr/lib/libz.so.1 (0x4005f000)</FONT>
<BR><FONT size=2> libc.so.6 => /lib/tls/libc.so.6
(0x40070000)</FONT> <BR><FONT size=2> libcrypt.so.1 =>
/lib/libcrypt.so.1 (0x401b8000)</FONT> <BR><FONT size=2>
libnsl.so.1 => /lib/libnsl.so.1 (0x401e5000)</FONT> <BR><FONT
size=2> libm.so.6 => /lib/tls/libm.so.6 (0x401f8000)</FONT>
<BR><FONT size=2> /lib/ld-linux.so.2 => /lib/ld-linux.so.2
(0x80000000)</FONT> </P>
<P><FONT size=2>Now, I have the same result than Zeus but I didn't have
any</FONT> <BR><FONT size=2>/usr/lib/libmysqlclient.so.10...</FONT> </P>
<P><FONT size=2>When I installed the libmysql12, I obtained new files in
/usr/lib/</FONT> <BR><FONT size=2>(libmysqlclient.so.12 and some others).
When SER try to load mysql.so, it</FONT> <BR><FONT size=2>looks for the
library libmysqlclient.so.10 and obviously can't find it.</FONT> <BR><FONT
size=2>So I made a link with the following command :</FONT> <BR><FONT
size=2>ln -s libmysqlclient.so.12 libmysqlclient.so.10</FONT> </P>
<P><FONT size=2>And now, SER can load the mysql module !!</FONT> </P>
<P><FONT size=2>Thanks for your help Zeus !!</FONT> <BR><FONT size=2>Bye,
Gwen</FONT> </P><BR>
<P><FONT size=2>></FONT> <BR><FONT size=2>> Hi Zeus and other
serusers,</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>> The
mysql.so file is the one I got with
SER.(ser-0.8.12_linux_i386.tar.gz,</FONT> <BR><FONT size=2>> if I
remember...).</FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>
Could you tell me what output you get with this command :</FONT> <BR><FONT
size=2>> # ldconfig -v |grep mysql</FONT> <BR><FONT size=2>> ldconfig:
Path `/usr/lib' given more than once</FONT> <BR><FONT
size=2>>
libmysqlclient_r.so.12 -> libmysqlclient_r.so.12.0.0</FONT> <BR><FONT
size=2>>
libmysqlclient.so.12 -> libmysqlclient.so.12.0.0</FONT> <BR><FONT
size=2>>
libmysqlclient.so.10 -> libmysqlclient.so.10</FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>> Thanks,</FONT> <BR><FONT
size=2>> Gwen</FONT> <BR><FONT size=2>></FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>></FONT> <BR><FONT size=2>>>
Gwen,</FONT> <BR><FONT size=2>>></FONT> <BR><FONT size=2>>>
There is something wrong with your mysql.so file. Did you compile it</FONT>
<BR><FONT size=2>>> yourself or download it somewhere? It doesn't look
like mysql library is</FONT> <BR><FONT size=2>>> linked into it. My
ldd output is like this:</FONT> <BR><FONT size=2>>></FONT> <BR><FONT
size=2>>> sip:/usr/local/lib/ser/modules> ldd mysql.so</FONT>
<BR><FONT size=2>>>
libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10</FONT> <BR><FONT
size=2>>> (0x00bbb000)</FONT> <BR><FONT
size=2>>> libz.so.1
=> /usr/lib/libz.so.1 (0x00abf000)</FONT> <BR><FONT
size=2>>> libc.so.6
=> /lib/tls/libc.so.6 (0x003f3000)</FONT> <BR><FONT
size=2>>>
libcrypt.so.1 => /lib/libcrypt.so.1 (0x0056a000)</FONT> <BR><FONT
size=2>>> libnsl.so.1
=> /lib/libnsl.so.1 (0x0029e000)</FONT> <BR><FONT
size=2>>> libm.so.6
=> /lib/tls/libm.so.6 (0x00111000)</FONT> <BR><FONT
size=2>>>
libnss_files.so.2 => /lib/libnss_files.so.2 (0x00a7d000)</FONT> <BR><FONT
size=2>>>
libnss_dns.so.2 => /lib/libnss_dns.so.2 (0x006dd000)</FONT> <BR><FONT
size=2>>>
libresolv.so.2 => /lib/libresolv.so.2 (0x00967000)</FONT> <BR><FONT
size=2>>>
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x0036b000)</FONT> <BR><FONT
size=2>>></FONT> <BR><FONT size=2>>> Note the first line states
that mysql.so should dynamically load the</FONT> <BR><FONT size=2>>>
mysql</FONT> <BR><FONT size=2>>> library from
/usr/lib/libmysqlclient.so.10. It is absent from your</FONT> <BR><FONT
size=2>>> output.</FONT> <BR><FONT size=2>>> Either recompile
the module or download another copy from the FTP</FONT> <BR><FONT
size=2>>> server.</FONT> <BR><FONT size=2>>></FONT> <BR><FONT
size=2>>> Zeus</FONT> <BR><FONT size=2>>></FONT> <BR><FONT
size=2>>>> -----Original Message-----</FONT> <BR><FONT
size=2>>>> From: g.billoudet@arwen-tech.fr [<A
href="mailto:g.billoudet@arwen-tech.fr">mailto:g.billoudet@arwen-tech.fr</A>]</FONT>
<BR><FONT size=2>>>> Sent: Friday, 10 September 2004 5:10 PM</FONT>
<BR><FONT size=2>>>> To: Zeus Ng</FONT> <BR><FONT
size=2>>>> Cc: serusers@lists.iptel.org</FONT> <BR><FONT
size=2>>>> Subject: RE: [Serusers] could not open module
mysql.so</FONT> <BR><FONT size=2>>>></FONT> <BR><FONT
size=2>>>></FONT> <BR><FONT size=2>>>> Thank you for your
help Zeus,</FONT> <BR><FONT size=2>>>></FONT> <BR><FONT
size=2>>>> Here are the output of the commands :</FONT> <BR><FONT
size=2>>>></FONT> <BR><FONT size=2>>>> [root@linux gwen]#
ldd /usr/local/lib/ser/modules/mysql.so</FONT> <BR><FONT
size=2>>>>
linux-gate.so.1 => (0xffffe000)</FONT> <BR><FONT
size=2>>>>
libz.so.1 => /usr/lib/libz.so.1 (0x40028000)</FONT> <BR><FONT
size=2>>>>
libc.so.6 => /lib/tls/libc.so.6 (0x40039000)</FONT> <BR><FONT
size=2>>>>
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)</FONT> <BR><FONT
size=2>>>></FONT> <BR><FONT size=2>>>> [root@linux gwen]#
cat /etc/ld.conf</FONT> <BR><FONT size=2>>>> cat: /etc/ld.conf: No
such file or directory</FONT> <BR><FONT size=2>>>></FONT> <BR><FONT
size=2>>>> [root@linux gwen]# cat /etc/ld.so.conf</FONT> <BR><FONT
size=2>>>> /usr/X11R6/lib</FONT> <BR><FONT size=2>>>>
/usr/lib/qt3/lib</FONT> <BR><FONT size=2>>>>
/usr/local/lib/ser/modules</FONT> <BR><FONT size=2>>>>
/usr/lib</FONT> <BR><FONT size=2>>>></FONT> <BR><FONT
size=2>>>> Gwen</FONT> <BR><FONT
size=2>>>></FONT> <BR><FONT size=2>>>></FONT> <BR><FONT
size=2>>>> > Gwen,</FONT> <BR><FONT size=2>>>>
></FONT> <BR><FONT size=2>>>> > It appears that your mysql.so
is not link properly with the mysql</FONT> <BR><FONT size=2>>>>
> library. Send the following output to the list. It may give us
more</FONT> <BR><FONT size=2>>>> > insight on your
problem.</FONT> <BR><FONT size=2>>>> ></FONT> <BR><FONT
size=2>>>> > root# ldd
/usr/local/lib/ser/modules/mysql.so</FONT> <BR><FONT size=2>>>>
> root# cat /etc/ld.conf</FONT> <BR><FONT size=2>>>>
></FONT> <BR><FONT size=2>>>> ></FONT> <BR><FONT
size=2>>>> > Zeus</FONT> <BR><FONT size=2>>>>
></FONT> <BR><FONT size=2>>>> >> -----Original
Message-----</FONT> <BR><FONT size=2>>>> >> From:
serusers-bounces@lists.iptel.org</FONT> <BR><FONT size=2>>>> [<A
href="mailto:serusers-bounces@lists.iptel.org">mailto:serusers-bounces@iptel.org</A>]</FONT>
<BR><FONT size=2>>>> >> On Behalf Of
g.billoudet@arwen-tech.fr</FONT> <BR><FONT size=2>>>> >>
Sent: Friday, 10 September 2004 12:46 AM</FONT> <BR><FONT
size=2>>>> >> To: g.billoudet@arwen-tech.fr</FONT> <BR><FONT
size=2>>>> >> Cc: serusers@lists.iptel.org</FONT> <BR><FONT
size=2>>>> >> Subject: Re: [Serusers] could not open module
mysql.so</FONT> <BR><FONT size=2>>>> >></FONT> <BR><FONT
size=2>>>> >></FONT> <BR><FONT size=2>>>>
>></FONT> <BR><FONT size=2>>>> >> Hi,</FONT> <BR><FONT
size=2>>>> >></FONT> <BR><FONT size=2>>>> >> I
checked my MySQL-client package. So I installed</FONT> <BR><FONT
size=2>>>> >> MySQL-client-4.0.20-0.i386.rpm. I also had to
install the package</FONT> <BR><FONT size=2>>>> >>
libmysql12. But, I still have the same problem with the</FONT> <BR><FONT
size=2>>>> load of mysql</FONT> <BR><FONT size=2>>>>
>> module...</FONT> <BR><FONT size=2>>>> >></FONT>
<BR><FONT size=2>>>> >> I the folder /usr/lib, new files
appeared : libmysqlclient_r.so.12@</FONT> <BR><FONT size=2>>>>
>> libmysqlclient_r.so.12.0.0*</FONT> <BR><FONT size=2>>>>
>> libmysqlclient.so.10*</FONT> <BR><FONT size=2>>>> >>
libmysqlclient.so.12@</FONT> <BR><FONT size=2>>>> >>
libmysqlclient.so.12.0.0*</FONT> <BR><FONT size=2>>>>
>></FONT> <BR><FONT size=2>>>> >> What 'libmysqlclient'
files do you have in your folder</FONT> <BR><FONT size=2>>>>
/usr/lib and</FONT> <BR><FONT size=2>>>> >>
/usr/local/lib/ser/modules/ ??</FONT> <BR><FONT size=2>>>>
>></FONT> <BR><FONT size=2>>>> >> When I use
"/usr/local/sbin/ser -c", the message of the error is a</FONT> <BR><FONT
size=2>>>> >> bit different :</FONT> <BR><FONT
size=2>>>> >> 0(2570) loading module
/usr/local/lib/ser/modules/mysql.so</FONT> <BR><FONT size=2>>>>
>> 0(2570) ERROR: load_module: could not open module</FONT>
<BR><FONT size=2>>>> >>
</usr/local/lib/ser/modules/mysql.so>:</FONT> <BR><FONT
size=2>>>> >> /usr/local/lib/ser/modules/mysql.so: undefined
symbol:</FONT> <BR><FONT size=2>>>> >>
mysql_field_count</FONT> <BR><FONT size=2>>>> >>
0(2570) parse error (14,13-49): failed to load module</FONT> <BR><FONT
size=2>>>> >> # ...bla bla... don't mind</FONT> <BR><FONT
size=2>>>> >> ERROR: bad config file (1 errors)</FONT>
<BR><FONT size=2>>>> >></FONT> <BR><FONT size=2>>>>
>></FONT> <BR><FONT size=2>>>> >> Thanks for
help</FONT> <BR><FONT size=2>>>> >> Gwen</FONT> <BR><FONT
size=2>>>> >></FONT> <BR><FONT size=2>>>>
>></FONT> <BR><FONT size=2>>>> >></FONT> <BR><FONT
size=2>>>> ></FONT> <BR><FONT size=2>>>> ></FONT>
<BR><FONT size=2>>>></FONT> <BR><FONT size=2>>></FONT>
<BR><FONT size=2>>></FONT> <BR><FONT size=2>></FONT> <BR><FONT
size=2>> _______________________________________________</FONT> <BR><FONT
size=2>> Serusers mailing list</FONT> <BR><FONT size=2>>
serusers@lists.iptel.org</FONT> <BR><FONT size=2>> <A
href="http://lists.iptel.org/mailman/listinfo/serusers"
target=_blank>http://lists.iptel.org/mailman/listinfo/serusers</A></FONT>
<BR><FONT size=2>></FONT> </P>
<P><FONT size=2>_______________________________________________</FONT>
<BR><FONT size=2>Serusers mailing list</FONT> <BR><FONT
size=2>serusers@lists.iptel.org</FONT> <BR><FONT size=2><A
href="http://lists.iptel.org/mailman/listinfo/serusers"
target=_blank>http://lists.iptel.org/mailman/listinfo/serusers</A></FONT>
</P>
<P><FONT
size=2>**************************************************************************
</FONT><BR><B><FONT size=2>Disclaimer </FONT></B><BR><B><FONT size=2>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. </FONT></B></P>
<P><B><FONT
size=2>**************************************************************************
</FONT></B></P>
<P>
<HR>
<P></P>_______________________________________________<BR>Serusers mailing
list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>Serusers mailing
list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE></BODY></HTML>