Re: [Serusers] HELP ser with mysql 4 won't start

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: &#39;7f7e7deb-11309(a)160.75.114.107&#39; 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: &#39;7f7e7deb-11310(a)160.75.114.107&#39; 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(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers