[Serusers] could not open module mysql.so

g.billoudet at arwen-tech.fr g.billoudet at arwen-tech.fr
Thu Sep 9 16:46:03 CEST 2004


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




More information about the sr-users mailing list