[Serusers] Problem with mysql.so on new server
Greger V. Teigre
greger at teigre.com
Sat Feb 3 11:16:14 CET 2007
You may be right, I'm not sure if ser is tested with mysql 5?!
Here is a grep on my rhel4 packages(all standard rhel4):
libdbi-dbd-mysql-0.6.5-10.RHEL4.1.i386.rpm
mysql-4.1.20-1.RHEL4.1.i386.rpm
mysql-devel-4.1.20-1.RHEL4.1.i386.rpm
mysql-server-4.1.20-1.RHEL4.1.i386.rpm
mysqlclient10-3.23.58-4.RHEL4.1.i386.rpm
php-mysql-4.3.9-3.22.i386.rpm
And your ldd of mysql.so does not look fine. I would say you have
probably compiled against mysql4 header files (left overs?!), but does
not have mysql4 client rpm installed.
g-)
sip wrote:
> I thought of that. It HAD an older version of the mysql client libraries on
> there, but I removed those (and all other mysql-related packages) before
> installing the new libraries and compiling ser.
>
> Again, everything compiles and links correctly. It's just missing something
> when it tries to load it. I'm wondering if perhaps SER doesn't work with the
> mysql5 client/development libs -- if something is missing from them that is
> expected.
>
> I'm most confused.
>
> N.
>
>
> On Thu, 1 Feb 2007 14:42:53 +0100, Atle Samuelsen wrote
>
>> Hi Sip,
>>
>> * sip <sip at infinideas.com> [070201 14:33]:
>>
>>> It is indeed most irksome. This works like a charm on all my other servers,
>>> but not on this one, and I haven't done anything differently except that my
>>> mysqlclient RPM is the one from the mysql.org (mysql 5) site for RHEL4
>>> (installing libmysqlclient.so.15 into /usr/lib instead of /usr/lib/mysql).
>>>
>>> But, of course, there are no errors on compile and no missing libraries upon
>>> link... so I'm confused.
>>>
>> Hmm.. did you only download mysqlclient? maybe you are mixing
>> libaries or something, like mysql-cient 4.1 and mysql client-5-devel
>>
>> I would propose to do a rpm -qa |grep mysql|grep clint |xargs rpm
>> --force -e and then install mysql client and mysql devel once more
>>
>> (ps, I have'nt tried the rpm -qa|grep... thingie..
>>
>> - Atle
>>
>>> N.
>>>
>>>
>>>
>>>
>>>
>>> On Thu, 1 Feb 2007 12:15:49 +0100, Atle Samuelsen wrote
>>>
>>>> Hi guys,
>>>>
>>>> It seems to work in my setup atleast :) I'v only got the defalt RHEL
>>>> 4 + mysql-devel packages installed.
>>>>
>>>> See under :
>>>>
>>>> [root at OgoBoo sip_router]# killall ser
>>>> [root at OgoBoo sip_router]# grep "mysql" /usr/local/etc/ser/ser.cfg
>>>> loadmodule "/usr/local/lib/ser/modules/mysql.so"
>>>> [root at OgoBoo sip_router]# cat /etc/redhat-release
>>>> Red Hat Enterprise Linux ES release 4 (Nahant Update 2)
>>>> [root at OgoBoo sip_router]# ser
>>>> Listening on
>>>> udp: 192.168.0.1 [192.168.0.1]:5080
>>>> Aliases:
>>>>
>>>> [root at OgoBoo sip_router]# ps -C ser
>>>> PID TTY TIME CMD
>>>> 17853 ? 00:00:00 ser
>>>> 17854 ? 00:00:00 ser
>>>> 17855 ? 00:00:00 ser
>>>> 17856 ? 00:00:00 ser
>>>> 17857 ? 00:00:00 ser
>>>> 17858 ? 00:00:00 ser
>>>> [root at OgoBoo sip_router]#
>>>>
>>>> [root at OgoBoo sip_router]# ldd /usr/local/lib/ser/modules/mysql.so
>>>> libmysqlclient.so.14 => /usr/lib/mysql/libmysqlclient.so.14
>>>> (0x001df000)
>>>> libz.so.1 => /usr/lib/libz.so.1 (0x00111000)
>>>> libc.so.6 => /lib/tls/libc.so.6 (0x00692000)
>>>> libcrypt.so.1 => /lib/libcrypt.so.1 (0x00121000)
>>>> libnsl.so.1 => /lib/libnsl.so.1 (0x00989000)
>>>> libm.so.6 => /lib/tls/libm.so.6 (0x0014f000)
>>>> libssl.so.4 => /lib/libssl.so.4 (0x00adc000)
>>>> libcrypto.so.4 => /lib/libcrypto.so.4 (0x002f8000)
>>>> /lib/ld-linux.so.2 (0x001c8000)
>>>> libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2
>>>> (0x00877000) libkrb5.so.3 => /usr/lib/libkrb5.so.3
>>>> (0x003e1000) libcom_err.so.2 => /lib/libcom_err.so.2
>>>> (0x00e4a000) libk5crypto.so.3 => /usr/lib/libk5crypto.so.3
>>>> (0x00f6c000) libresolv.so.2 => /lib/libresolv.so.2
>>>> (0x007ee000) libdl.so.2 => /lib/libdl.so.2 (0x00ed2000)
>>>>
>>>> - Atle
>>>>
>>>> * sip <sip at infinideas.com> [070201 11:56]:
>>>>
>>>>> [mysql]$ ldd mysql.so
>>>>> libc.so.6 => /lib/tls/libc.so.6 (0x009bc000)
>>>>> /lib/ld-linux.so.2 (0x0099e000)
>>>>>
>>>>> Looks just fine. Linked to the appropriate libs.
>>>>>
>>>>> I did a search on this error in the archives and it only comes up with one
>>>>> other message, also someone who was having problems in RHEL4. Are we
>>>>>
> sure it
>
>>>>> works in RHEL4?
>>>>>
>>>>> N.
>>>>>
>>>>>
>>>>> On Thu, 01 Feb 2007 09:41:32 +0100, Greger V. Teigre wrote
>>>>>
>>>>>> RHEL4 should be fine. ldd mysql.so should reveal if you are missing
>>>>>> any libraries. g-)
>>>>>>
>>>>>> sip wrote:
>>>>>>
>>>>>>> So... I've had ser 0.9.6 running on RH EL3, and FC3 and 4. I'm
>>>>>>>
>>> building out a
>>>
>>>>>>> server on RH EL4 for SER, but I've run into a snag. I'm sure it's
>>>>>>>
>>> something
>>>
>>>>>>> simple, but it has me stumped at the moment.
>>>>>>>
>>>>>>> I've recompiled mysql.so on the new server... compiles fine (as do the
>>>>>>>
>>> rest of
>>>
>>>>>>> the modules). However, when I try to start up SER with mysql.so
>>>>>>>
> loaded, it
>
>>>>>>> gives me this:
>>>>>>>
>>>>>>> ERROR: load_module: could not open module
>>>>>>> </usr/local/lib/ser/modules/mysql.so>:
>>>>>>>
>>> /usr/local/lib/ser/modules/mysql.so:
>>>
>>>>>>> undefined symbol: log
>>>>>>>
>>>>>>>
>>>>>>> Undefined symbol: log
>>>>>>>
>>>>>>>
>>>>>>> Never seen this before. Anyone know what it means or, more
>>>>>>>
>>> importantly, how to
>>>
>>>>>>> fix it (and no... I'm not going to scrap it all and go with Ottendorf
>>>>>>>
>>> yet, so
>>>
>>>>>>> that's not a solution ;) )?
>>>>>>>
>>>>>>>
>>>>>>> N.
>>>>>>> _______________________________________________
>>>>>>> Serusers mailing list
>>>>>>> Serusers at lists.iptel.org
>>>>>>> http://lists.iptel.org/mailman/listinfo/serusers
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>> _______________________________________________
>>>>> Serusers mailing list
>>>>> Serusers at lists.iptel.org
>>>>> http://lists.iptel.org/mailman/listinfo/serusers
>>>>>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070203/7822bd1f/attachment.htm>
More information about the sr-users
mailing list