[Serusers] could not open module mysql.so

g.billoudet at arwen-tech.fr g.billoudet at arwen-tech.fr
Thu Sep 9 11:32:28 CEST 2004


It's me once again...

I found an error in my ser.cfg (in the request routing logic paragraph)...
I used to have 10 errors, I now have only 1 error : the module mysql still
can't be loaded...

Thanks in advance :-) Gwen

Here is the "ser -c" result :

 0(2813) loading module /usr/local/lib/ser/modules/mysql.so
 0(2813) 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(2813) parse error (14,13-49): failed to load module
 0(2813) loading module /usr/local/lib/ser/modules/sl.so
 0(2813) loading module /usr/local/lib/ser/modules/tm.so
 0(2813) loading module /usr/local/lib/ser/modules/rr.so
 0(2813) loading module /usr/local/lib/ser/modules/maxfwd.so
 0(2813) loading module /usr/local/lib/ser/modules/usrloc.so
 0(2813) loading module /usr/local/lib/ser/modules/registrar.so
 0(2813) loading module /usr/local/lib/ser/modules/auth.so
 0(2813) loading module /usr/local/lib/ser/modules/auth_db.so
 0(2813) set_mod_param_regex: usrloc matches module usrloc
 0(2813) set_mod_param_regex: found <db_mode> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(2813) set_mod_param_regex: usrloc matches module usrloc
 0(2813) set_mod_param_regex: found <db_url> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(2813) set_mod_param_regex: auth_db matches module auth_db
 0(2813) set_mod_param_regex: found <calculate_ha1> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
 0(2813) set_mod_param_regex: auth_db matches module auth_db
 0(2813) set_mod_param_regex: found <password_column> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
 0(2813) set_mod_param_regex: rr matches module rr
 0(2813) set_mod_param_regex: found <enable_full_lr> in module rr
[/usr/local/lib/ser/modules/rr.so]
 0(2813) find_export: found <mf_process_maxfwd_header> in module
maxfwd_module [/usr/local/lib/ser/modules/maxfwd.so]
 0(2813) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
 0(2813) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
 0(2813) find_export: found <record_route> in module rr
[/usr/local/lib/ser/modules/rr.so]
 0(2813) find_export: found <loose_route> in module rr
[/usr/local/lib/ser/modules/rr.so]
 0(2813) find_export: found <t_relay> in module tm
[/usr/local/lib/ser/modules/tm.so]
 0(2813) find_export: found <www_authorize> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
 0(2813) find_export: found <www_challenge> in module auth
[/usr/local/lib/ser/modules/auth.so]
 0(2813) find_export: found <save> in module registrar
[/usr/local/lib/ser/modules/registrar.so]
 0(2813) find_export: found <lookup> in module registrar
[/usr/local/lib/ser/modules/registrar.so]
 0(2813) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
 0(2813) find_export: found <t_relay> in module tm
[/usr/local/lib/ser/modules/tm.so]
 0(2813) find_export: found <sl_reply_error> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
ERROR: bad config file (1 errors)
 0(2813) DEBUG: tm_shutdown : start
 0(2813) DEBUG: tm_shutdown : empting hash table
 0(2813) DEBUG: tm_shutdown: releasing timers
 0(2813) DEBUG: tm_shutdown : removing semaphores
 0(2813) DEBUG: tm_shutdown : done
 0(2813) shm_mem_destroy
 0(2813) destroying the shared memory lock






> 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
>
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>





More information about the sr-users mailing list