[Serusers] could not open module mysql.so

[Zeus Ng]

Gwen,

The libmysqlclient.so.10 is part of the mysql client library, not SER. If
you install the mysql client from package, it will be under /usr/lib. It
looks like you have not install the mysql client properly.

Zeus

> -----Original Message-----
> From: serusers-bounces at lists.iptel.org 
> [mailto:serusers-bounces at lists.iptel.org] On Behalf Of 
> g.billoudet at arwen-tech.fr
> Sent: Thursday, 9 September 2004 7:19 PM
> To: serusers at lists.iptel.org
> Subject: [Serusers] could not open module mysql.so
> 
> 
> 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
>