[Serusers] HELP ser with mysql 4 won't start
Ertugrul Akyurek
akyurek at gmail.com
Mon May 2 03:07:55 CEST 2005
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
More information about the sr-users
mailing list