[Serusers] HELP ser with mysql 4 won't start
Edgardo O. Gonzales II
edgardo.g at pacific.net.ph
Tue May 3 00:44:57 CEST 2005
If you installed mysql. it means that ser can find the module required so
that ser can communicate with mysql.
Did you use source .. maybe its better for you to use a suse package ..
or if you want, customize mysql installation or ser so that path defined
for libmysqlclient will be set properly.
This happened to me once and what I did is I installed a mysql debian package
and also compile my ser as debian package ..
hope this will help.
thanks,
ed
At 09:07 AM 5/2/2005, Ertugrul Akyurek wrote:
>Hi all
>
>I am a newbee to linux but I have to install and run ser. I did it
>before with mysql 3.23 that comes with FC 3 and ser ver. was 8.1.14
>
>Now I am on suse 9.1, sql 4 and I tried 8.1.14, 8.8, 8.9 and 9.0.
>
>I don't know which one now, but one of these asked for
>libmysqlclien.so.10 but I had 12 so I symlinked 10 to 12 with ln -s
>libmysqlclien.so.12 libmysqlclien.so.10
>
>Now I am trying 8.1.14 and here is my conf file:
>
>#
># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
>#
># simple quick-start config script
>#
>
># ----------- global configuration parameters ------------------------
>
>debug=7 # debug level (cmd line: -dddddddddd)
>fork=no
>log_stderror=yes # (cmd line: -E)
>
>/* Uncomment these lines to enter debugging mode
>debug=7
>fork=no
>log_stderror=yes
>*/
>
>check_via=no # (cmd. line: -v)
>dns=no # (cmd. line: -r)
>rev_dns=no # (cmd. line: -R)
>#port=5060
>#children=4
>fifo="/tmp/ser_fifo"
>
># ------------------ module loading ----------------------------------
>
># Uncomment this if you want to use SQL database
>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"
>
># Uncomment this if you want digest authentication
># mysql.so must be loaded !
>loadmodule "/usr/local/lib/ser/modules/auth.so"
>loadmodule "/usr/local/lib/ser/modules/auth_db.so"
>
># ----------------- setting module-specific parameters ---------------
>
># -- usrloc params --
>
>modparam("usrloc", "db_mode", 2)
>
># Uncomment this if you want to use SQL database
># for persistent storage and comment the previous line
>#modparam("usrloc", "db_mode", 2)
>
># -- auth params --
># Uncomment if you are using auth module
>#
>modparam("auth_db", "calculate_ha1", yes)
>#
># If you set "calculate_ha1" parameter to yes (which true in this config),
># uncomment also the following parameter)
>#
>modparam("auth_db", "password_column", "password")
>
># -- rr params --
># add value to ;lr param to make some broken UAs happy
>modparam("rr", "enable_full_lr", 1)
>
># ------------------------- request routing logic -------------------
>
># main routing logic
>
>route{
>
> # initial sanity checks -- messages with
> # max_forwards==0, or excessively long requests
> if (!mf_process_maxfwd_header("10")) {
> sl_send_reply("483","Too Many Hops");
> break;
> };
> if ( msg:len > max_len ) {
> sl_send_reply("513", "Message too big");
> break;
> };
>
> # we record-route all messages -- to make sure that
> # subsequent messages will go through our proxy; that's
> # particularly good if upstream and downstream entities
> # use different transport protocol
> record_route();
> # loose-route processing
> if (loose_route()) {
> t_relay();
> break;
> };
>
> # if the request is for other domain use UsrLoc
> # (in case, it does not work, use the following command
> # with proper names and addresses in it)
> if (uri==myself) {
>
> if (method=="REGISTER") {
>
># Uncomment this if you want to use digest authentication
> if (!www_authorize("my_ip", "subscriber")) {
> www_challenge("my_ip", "0");
> break;
> };
>
> save("location");
> break;
> };
>
> # native SIP destinations are handled using our USRLOC DB
> if (!lookup("location")) {
> sl_send_reply("404", "Not Found");
> break;
> };
> };
> # forward to current uri now; use stateful forwarding; that
> # works reliably even if we forward from TCP to UDP
> if (!t_relay()) {
> sl_reply_error();
> };
>
>}
>_______________________________________________________________
>
>And here is what I get (the important part I believe):
>
>Listening on
> 160.75.114.107 [160.75.114.107]:5060
>Aliases: konak:5060 konak.vadi:5060
>WARNING: no fork mode
> 0(11307) DEBUG: init_mod: mysql
> 0(11307) mysql - initializing
> 0(11307) DEBUG: init_mod: sl_module
>stateless - initializing
> 0(11307) DEBUG: register_fifo_cmd: new command (sl_stats) registered
> 0(11307) DEBUG: MD5 calculated: 35f101c4519482cd72086674c284d714
> 0(11307) DEBUG: init_mod: tm
> 0(11307) TM - initializing...
> 0(11307) Call-ID initialization: '7f7e7deb'
> 0(11307) DEBUG: register_fifo_cmd: new command (t_uac_dlg) registered
> 0(11307) DEBUG: register_fifo_cmd: new command (t_uac_cancel) registered
> 0(11307) DEBUG: register_fifo_cmd: new command (t_hash) registered
> 0(11307) DEBUG: lock_initialize: lock initialization started
> 0(11307) DEBUG: register_fifo_cmd: new command (t_stats) registered
> 0(11307) DEBUG: MD5 calculated: 16de7e07c182837aae8ddf6ca34bb96f
> 0(11307) DEBUG: MD5 calculated: 9b4e6e19c32016239a80d97510abe487
> 0(11307) DEBUG: init_mod: rr
> 0(11307) rr - initializing
> 0(11307) DEBUG: init_mod: maxfwd_module
>Maxfwd module- initializing
> 0(11307) DEBUG: init_mod: usrloc
> 0(11307) usrloc - initializing
> 0(11307) DEBUG: register_fifo_cmd: new command (ul_stats) registered
> 0(11307) DEBUG: register_fifo_cmd: new command (ul_rm) registered
> 0(11307) DEBUG: register_fifo_cmd: new command (ul_rm_contact) registered
> 0(11307) DEBUG: register_fifo_cmd: new command (ul_dump) registered
> 0(11307) DEBUG: register_fifo_cmd: new command (ul_flush) registered
> 0(11307) DEBUG: register_fifo_cmd: new command (ul_add) registered
> 0(11307) DEBUG: register_fifo_cmd: new command (ul_show_contact) registered
> 0(11307) find_export: found <db_use_table> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_init> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_close> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_query> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_raw_query> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_free_query> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_insert> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_delete> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_update> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) mod_init(): Database connection opened successfuly
> 0(11307) DEBUG: init_mod: registrar
> 0(11307) registrar - initializing
> 0(11307) find_export: found <sl_send_reply> in module sl_module
>[/usr/local/lib/ser/modules/sl.so]
> 0(11307) find_export: found <ul_bind_usrloc> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_register_udomain> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_get_all_ucontacts> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_insert_urecord> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_delete_urecord> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_get_urecord> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_lock_udomain> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_unlock_udomain> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_release_urecord> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_insert_ucontact> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_delete_ucontact> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_get_ucontact> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) find_export: found <ul_update_ucontact> in module usrloc
>[/usr/local/lib/ser/modules/usrloc.so]
> 0(11307) DEBUG: init_mod: auth
> 0(11307) auth module - initializing
> 0(11307) find_export: found <sl_send_reply> in module sl_module
>[/usr/local/lib/ser/modules/sl.so]
> 0(11307) DEBUG: init_mod: auth_db
> 0(11307) auth_db module - initializing
> 0(11307) find_export: found <db_use_table> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_init> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_close> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_query> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_raw_query> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_free_query> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_insert> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_delete> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <db_update> in module mysql
>[/usr/local/lib/ser/modules/mysql.so]
> 0(11307) find_export: found <pre_auth> in module auth
>[/usr/local/lib/ser/modules/auth.so]
> 0(11307) find_export: found <post_auth> in module auth
>[/usr/local/lib/ser/modules/auth.so]
> 0(11307) find_export: found <sl_send_reply> in module sl_module
>[/usr/local/lib/ser/modules/sl.so]
> 0(0) fixing /usr/local/lib/ser/modules/maxfwd.so mf_process_maxfwd_header
> 0(0) fixing /usr/local/lib/ser/modules/sl.so sl_send_reply
> 0(0) fixing /usr/local/lib/ser/modules/sl.so sl_send_reply
> 0(0) fixing /usr/local/lib/ser/modules/rr.so record_route
> 0(0) fixing /usr/local/lib/ser/modules/rr.so loose_route
> 0(0) fixing /usr/local/lib/ser/modules/tm.so t_relay
> 0(0) fixing /usr/local/lib/ser/modules/auth_db.so www_authorize
> 0(0) fixing /usr/local/lib/ser/modules/auth.so www_challenge
> 0(0) fixing /usr/local/lib/ser/modules/registrar.so save
> 0(0) query="select
>username,contact,expires,q,callid,cseq,replicate,state,flags,user_agent
>from location "
> 0(0) preload_udomain(): Table is empty
> 0(0) fixing /usr/local/lib/ser/modules/registrar.so lookup
> 0(0) fixing /usr/local/lib/ser/modules/sl.so sl_send_reply
> 0(0) fixing /usr/local/lib/ser/modules/tm.so t_relay
> 0(0) fixing /usr/local/lib/ser/modules/sl.so sl_reply_error
> 0(0) INFO: udp_init: SO_RCVBUF is initially 111616
> 0(0) DEBUG: udp_init: trying SO_RCVBUF: 223232
> 0(0) DEBUG: setting SO_RCVBUF; set=223232,verify=223232
> 0(0) DEBUG: udp_init: trying SO_RCVBUF: 225280
> 0(0) DEBUG: setting SO_RCVBUF; set=225280,verify=223232
> 0(0) DEBUG: setting SO_RCVBUF has no effect
> 0(0) INFO: udp_init: SO_RCVBUF is finally 223232
> 1(11309) DBG: open_uac_fifo: opening fifo...
> 1(11309) DEBUG: FIFO created @ /tmp/ser_fifo
> 1(11309) DEBUG: fifo /tmp/ser_fifo opened, mode=432
> 1(11309) DEBUG: init_mod_child (-1): tm
> 1(11309) DEBUG: callid: '7f7e7deb-11309 at 160.75.114.107'
> 1(11309) DEBUG: init_mod_child (-1): usrloc
> 1(11309) DEBUG: init_mod_child (-1): auth_db
> 1(11309) connect_db(): No enough memory
> 1(11309) db_init(): Error while trying to connect database
> 1(11309) auth_db:init_child(): Unable to connect database
> 1(11309) init_mod_child(): Error while initializing module auth_db
> 1(11309) timer: init_child failed
> 1(11309) INFO: signal 15 received
> 1(11309) Memory status (pkg):
> 1(11309) fm_status (0x80d9840):
> 1(11309) heap size= 1047440
> 1(11309) dumping free list:
> 1(11309) hash = 1 fragments no.: 3,
> bucket size: 8 - 8 (first 8)
> 1(11309) hash = 2 fragments no.: 1,
> bucket size: 16 - 16 (first 16)
> 1(11309) hash = 3 fragments no.: 1,
> bucket size: 24 - 24 (first 24)
> 1(11309) hash = 5 fragments no.: 2,
> bucket size: 40 - 40 (first 40)
> 1(11309) hash = 24 fragments no.: 1,
> bucket size: 192 - 192 (first 192)
> 1(11309) hash = 265 fragments no.: 1,
> bucket size: 524288 - 1048576 (first 0)
> 1(11309) TOTAL: 9 free fragments = 336 free bytes
> 1(11309) -----------------------------
> 2(11310) INFO: SIGCHLD received: we do not worry about grand-children
> 2(11310) INFO: fifo process starting: 11310
> 2(11310) DEBUG: init_mod_child (-2): tm
> 2(11310) DEBUG: callid: '7f7e7deb-11310 at 160.75.114.107'
> 2(11310) DEBUG: init_mod_child (-2): usrloc
> 2(11310) DEBUG: init_mod_child (-2): auth_db
> 2(11310) connect_db(): No enough memory
> 2(11310) db_init(): Error while trying to connect database
> 2(11310) auth_db:init_child(): Unable to connect database
> 2(11310) init_mod_child(): Error while initializing module auth_db
> 2(11310) ERROR: open_uac_fifo: init_child failed
> 2(11310) opening fifo server failed
> 2(11310) INFO: signal 15 received
> 2(11310) Memory status (pkg):
> 2(11310) fm_status (0x80d9840):
> 2(11310) heap size= 1047440
> 2(11310) dumping free list:
> 2(11310) hash = 1 fragments no.: 3,
> bucket size: 8 - 8 (first 8)
> 2(11310) hash = 2 fragments no.: 1,
> bucket size: 16 - 16 (first 16)
> 2(11310) hash = 3 fragments no.: 1,
> bucket size: 24 - 24 (first 24)
> 2(11310) hash = 5 fragments no.: 2,
> bucket size: 40 - 40 (first 40)
> 2(11310) hash = 24 fragments no.: 1,
> bucket size: 192 - 192 (first 192)
> 2(11310) hash = 265 fragments no.: 1,
> bucket size: 524288 - 1048576 (first 0)
> 2(11310) TOTAL: 9 free fragments = 336 free bytes
> 2(11310) -----------------------------
> 2(11310) INFO: SIGCHLD received: we do not worry about grand-children
>
>
>
>
> 2(11310) INFO: signal 2 received
> 2(11310) Memory status (pkg):
> 2(11310) fm_status (0x80d9840):
> 2(11310) heap size= 1047440
> 2(11310) dumping free list:
> 2(11310) hash = 1 fragments no.: 3,
> bucket size: 8 - 8 (first 8)
> 2(11310) hash = 3 fragments no.: 1,
> bucket size: 24 - 24 (first 24)
> 2(11310) hash = 5 fragments no.: 2,
> bucket size: 40 - 40 (first 40)
> 2(11310) hash = 24 fragments no.: 1,
> bucket size: 192 - 192 (first 192)
> 2(11310) hash = 265 fragments no.: 1,
> bucket size: 524288 - 1048576 (first 0)
> 2(11310) TOTAL: 8 free fragments = 320 free bytes
> 2(11310) -----------------------------
>
>
>
>
>I am sure I have enough memory, I actually can't even make any meaning
>of this error message.
>
>When I start ser in normal mode (not debug) it says it is listening
>and serctl moni is cycling all well, but the server doesn't seem to
>run then either.
>
>
>Please at least offer me something to try. So far I had many problems
>with this but I overcame them one by one but I am totally desperate
>against this one.
>
>And please don't forget that I am a newbee at linux
>
>Thanx already
>
>Ertugrul
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
More information about the sr-users
mailing list