[Serusers] could not open module mysql.so

[g.billoudet at arwen-tech.fr]

Hi,

I have a problem opening the module mysql. I have no idea where it could
come from... Here are some informations about my configuration :

In my folder /usr/local/lib/ser/modules, I have the 2 shared libraries
libmysqlclient.so.10 and mysql.so

I had to copy the libmysqlclient.so.10 file in the following folder
because SER complained the file didn't exist... : /usr/lib/


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Here is my ser.cfg :

# ----------- global configuration parameters
debug=7
fork=no
log_stderror=yes
check_via=no    # (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
fifo="/tmp/ser_fifo"

# ------------------ module loading
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"

# ----------------- setting module-specific parameters
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
modparam("auth_db", "calculate_ha1", yes)
modparam("auth_db", "password_column", "password")
modparam("rr", "enable_full_lr", 1)

# -------------------------  request routing logic
# Well... not necessary I think...


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<


Here is the result of the command usr/local/sbin/ser -c :

 0(2781) loading module /usr/local/lib/ser/modules/mysql.so
 0(2781) ERROR: load_module: could not open module
</usr/local/lib/ser/modules/mysql.so>: /usr/lib/libmysqlclient.so.10:
undefined symbol: mysql_field_count
 0(2781) parse error (14,13-49): failed to load module
 0(2781) loading module /usr/local/lib/ser/modules/sl.so
 0(2781) loading module /usr/local/lib/ser/modules/tm.so
 0(2781) loading module /usr/local/lib/ser/modules/rr.so
 0(2781) loading module /usr/local/lib/ser/modules/maxfwd.so
 0(2781) loading module /usr/local/lib/ser/modules/usrloc.so
 0(2781) loading module /usr/local/lib/ser/modules/registrar.so
 0(2781) loading module /usr/local/lib/ser/modules/auth.so
 0(2781) loading module /usr/local/lib/ser/modules/auth_db.so
 0(2781) set_mod_param_regex: usrloc matches module usrloc
 0(2781) set_mod_param_regex: found <db_mode> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(2781) set_mod_param_regex: usrloc matches module usrloc
 0(2781) set_mod_param_regex: found <db_url> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(2781) set_mod_param_regex: auth_db matches module auth_db
 0(2781) set_mod_param_regex: found <calculate_ha1> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
 0(2781) set_mod_param_regex: auth_db matches module auth_db
 0(2781) set_mod_param_regex: found <password_column> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
 0(2781) set_mod_param_regex: rr matches module rr
 0(2781) set_mod_param_regex: found <enable_full_lr> in module rr
[/usr/local/lib/ser/modules/rr.so]
 0(2781) find_export: found <mf_process_maxfwd_header> in module
maxfwd_module [/usr/local/lib/ser/modules/maxfwd.so]
 0(2781) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
 0(2781) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
 0(2781) find_export: found <record_route> in module rr
[/usr/local/lib/ser/modules/rr.so]
 0(2781) find_export: found <loose_route> in module rr
[/usr/local/lib/ser/modules/rr.so]
 0(2781) find_export: found <t_relay> in module tm
[/usr/local/lib/ser/modules/tm.so]
 0(2781) parse error (51,16-20): parse error
 0(2781) parse error (51,16-20): bad command
 0(2781) parse error (51,20-21): bad command
 0(2781) parse error (51,20-21): bad command
 0(2781) parse error (51,23-24): bad command
 0(2781) parse error (51,23-24): bad command
 0(2781) parse error (51,25-26): bad command
 0(2781) find_export: found <www_authorize> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
 0(2781) find_export: found <www_challenge> in module auth
[/usr/local/lib/ser/modules/auth.so]
 0(2781) find_export: found <save> in module registrar
[/usr/local/lib/ser/modules/registrar.so]
 0(2781) find_export: found <lookup> in module registrar
[/usr/local/lib/ser/modules/registrar.so]
 0(2781) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
 0(2781) parse error (65,3-4): parse error
 0(2781) parse error (65,3-4):
ERROR: bad config file (10 errors)
 0(2781) DEBUG: tm_shutdown : start
 0(2781) DEBUG: tm_shutdown : empting hash table
 0(2781) DEBUG: tm_shutdown: releasing timers
 0(2781) DEBUG: tm_shutdown : removing semaphores
 0(2781) DEBUG: tm_shutdown : done
 0(2781) shm_mem_destroy
 0(2781) destroying the shared memory lock

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Please, help me, I am stuck here for more than 2 weeks ;-(

Thanks in advance
Gwen