<!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>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></BODY></HTML>