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@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@OgoBoo sip_router]# killall ser
[root@OgoBoo sip_router]# grep "mysql" /usr/local/etc/ser/ser.cfg
loadmodule "/usr/local/lib/ser/modules/mysql.so"
[root@OgoBoo sip_router]# cat /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant Update 2)
[root@OgoBoo sip_router]# ser
Listening on
             udp: 192.168.0.1 [192.168.0.1]:5080
Aliases:

[root@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@OgoBoo sip_router]#

[root@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@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@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers



              
_______________________________________________
Serusers mailing list
Serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers