[Serusers] Problems with Mysql - Resend

[ranganathu at canind-inc.com]

 Hi,

I am a newbie to SER. Just today I successfully set up and terminated a
call between users using a SER server running on a P4 MandrakeLinux 10.1
machine. I used the ser.cfg script that came along with the installation.
This, I understand does not allow persistent users. Since I had built my
installation with Mysql modules, I set up mysql to run along with ser by
executing the ser_mysql.sh. It went through fine and I saw that the tables
were all created too.
I modified the ser.cfg file so as to include user authentication through
mysql. My ser.cfg file is found attached herewith. As and when I restart
ser, this is the error message that I get:

-------------

0(7118) loading module /usr/local/lib/ser/modules/mysql.so
0(7118) ERROR: load_module: could not open module
</usr/local/lib/ser/modules/mysql.so>: libmysqlclient.so.10: cannot open
shared object file: No such file or directory
0(7118) parse error (29,13-49): failed to load module
0(7118) loading module /usr/local/lib/ser/modules/sl.so
0(7118) loading module /usr/local/lib/ser/modules/tm.so
0(7118) loading module /usr/local/lib/ser/modules/rr.so
0(7118) loading module /usr/local/lib/ser/modules/maxfwd.so
0(7118) loading module /usr/local/lib/ser/modules/usrloc.so
0(7118) loading module /usr/local/lib/ser/modules/registrar.so
0(7118) loading module /usr/local/lib/ser/modules/auth.so
0(7118) loading module /usr/local/lib/ser/modules/auth_db.so
0(7118) loading module /usr/local/lib/ser/modules/acc.so
0(7118) loading module /usr/local/lib/ser/modules/exec.so
0(7118) loading module /usr/local/lib/ser/modules/group.so
0(7118) loading module /usr/local/lib/ser/modules/msilo.so
0(7118) loading module /usr/local/lib/ser/modules/print.so
0(7118) loading module /usr/local/lib/ser/modules/textops.so
0(7118) loading module /usr/local/lib/ser/modules/uri.so
0(7118) loading module /usr/local/lib/ser/modules/vm.so
0(7118) set_mod_param_regex: usrloc matches module usrloc
0(7118) set_mod_param_regex: found <db_mode> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
0(7118) set_mod_param_regex: auth_db matches module auth_db
0(7118) set_mod_param_regex: found <calculate_ha1> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
0(7118) set_mod_param_regex: auth_db matches module auth_db
0(7118) set_mod_param_regex: found <password_column> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
0(7118) set_mod_param_regex: rr matches module rr
0(7118) set_mod_param_regex: found <enable_full_lr> in module rr
[/usr/local/lib/ser/modules/rr.so]
0(7118) find_export: found <mf_process_maxfwd_header> in module
maxfwd_module [/usr/local/lib/ser/modules/maxfwd.so]
0(7118) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
0(7118) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
0(7118) find_export: found <record_route> in module rr
[/usr/local/lib/ser/modules/rr.so]
0(7118) find_export: found <loose_route> in module rr
[/usr/local/lib/ser/modules/rr.so]
0(7118) find_export: found <t_relay> in module tm
[/usr/local/lib/ser/modules/tm.so]
0(7118) find_export: found <www_authorize> in module auth_db
[/usr/local/lib/ser/modules/auth_db.so]
0(7118) find_export: found <www_challenge> in module auth
[/usr/local/lib/ser/modules/auth.so]
0(7118) find_export: found <save> in module registrar
[/usr/local/lib/ser/modules/registrar.so]
0(7118) find_export: found <lookup> in module registrar
[/usr/local/lib/ser/modules/registrar.so]
0(7118) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
0(7118) find_export: found <t_relay> in module tm
[/usr/local/lib/ser/modules/tm.so]
0(7118) find_export: found <sl_reply_error> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
ERROR: bad config file (1 errors)
0(7118) MSILO: destroy module ...
0(7118) DEBUG: tm_shutdown : start
0(7118) DEBUG: tm_shutdown : empting hash table
0(7118) DEBUG: tm_shutdown: releasing timers
0(7118) DEBUG: tm_shutdown : removing semaphores
0(7118) DEBUG: tm_shutdown : done
0(7118) shm_mem_destroy
0(7118) destroying the shared memory lock
------------------

Is this because I am using a different version of mysql and it cannot find
libmysqlclient.so.10? When I did the compilation I did it so with
libmysqlclient.so.12 and assumed that everything would be taken care of.
Any suggestions would be wonderful.

Thanks,
Ranganath


--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .

-------------- next part --------------
A non-text attachment was scrubbed...
Name: ser.cfg
Type: application/octet-stream
Size: 3570 bytes
Desc: ser.cfg
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050129/10c7fae2/attachment.obj>