Hi,
I checked my MySQL-client package. So I installed MySQL-client-4.0.20-0.i386.rpm. I also had to install the package libmysql12. But, I still have the same problem with the load of mysql module...
I the folder /usr/lib, new files appeared : libmysqlclient_r.so.12@ libmysqlclient_r.so.12.0.0* libmysqlclient.so.10* libmysqlclient.so.12@ libmysqlclient.so.12.0.0*
What 'libmysqlclient' files do you have in your folder /usr/lib and /usr/local/lib/ser/modules/ ??
When I use "/usr/local/sbin/ser -c", the message of the error is a bit different : 0(2570) loading module /usr/local/lib/ser/modules/mysql.so 0(2570) ERROR: load_module: could not open module </usr/local/lib/ser/modules/mysql.so>: /usr/local/lib/ser/modules/mysql.so: undefined symbol: mysql_field_count 0(2570) parse error (14,13-49): failed to load module # ...bla bla... don't mind ERROR: bad config file (1 errors)
Thanks for help Gwen
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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers