hi,
we are facing following problem while using SER with mysql data base. The
problem statements are as follows:
0(0) find_mod_export: found <db_update> in module mysql
[/export/home/mins/SER/lib/ser/modules/mysql.so]
0(0) get_connection(): Connection not found in the pool
0(0) release_connection(): Removing connection from the pool
0(0) get_connection(): Connection not found in the pool
0(0) release_connection(): Removing connection from the pool
0(0) fixing /export/home/mins/SER/lib/ser/modules/maxfwd.so
mf_process_maxfwd_header
0(0) fixing /export/home/mins/SER/lib/ser/modules/sl.so sl_send_reply
0(0) fixing /export/home/mins/SER/lib/ser/modules/sl.so sl_send_reply
0(0) fixing /export/home/mins/SER/lib/ser/modules/rr.so record_route
0(0) fixing /export/home/mins/SER/lib/ser/modules/rr.so loose_route
0(0) fixing /export/home/mins/SER/lib/ser/modules/tm.so t_relay
0(0) fixing /export/home/mins/SER/lib/ser/modules/registrar.so lookup
0(0) fixing /export/home/mins/SER/lib/ser/modules/registrar.so lookup
0(0) fixing /export/home/mins/SER/lib/ser/modules/sl.so sl_send_reply
0(0) fixing /export/home/mins/SER/lib/ser/modules/tm.so t_relay
0(0) fixing /export/home/mins/SER/lib/ser/modules/sl.so sl_reply_error
0(0) fixing /export/home/mins/SER/lib/ser/modules/sl.so sl_send_reply
0(0) fixing /export/home/mins/SER/lib/ser/modules/auth_db.so
www_authorize
0(0) get_connection(): Connection not found in the pool
0(0) release_connection(): Removing connection from the pool
0(0) fixing /export/home/mins/SER/lib/ser/modules/auth.so www_challenge
0(0) fixing /export/home/mins/SER/lib/ser/modules/uri_db.so check_to
0(0) fixing /export/home/mins/SER/lib/ser/modules/sl.so sl_send_reply
0(0) fixing /export/home/mins/SER/lib/ser/modules/auth.so
consume_credentials
0(0) fixing /export/home/mins/SER/lib/ser/modules/registrar.so save
0(0) fixing /export/home/mins/SER/lib/ser/modules/sl.so sl_reply_error
0(0) fixing /export/home/mins/SER/lib/ser/modules/auth_db.so
proxy_authorize
0(0) get_connection(): Connection not found in the pool
0(0) release_connection(): Removing connection from the pool
0(0) fixing /export/home/mins/SER/lib/ser/modules/auth.so proxy_challenge
0(0) fixing /export/home/mins/SER/lib/ser/modules/auth.so
consume_credentials
0(0) fixing /export/home/mins/SER/lib/ser/modules/registrar.so lookup
0(0) fixing /export/home/mins/SER/lib/ser/modules/registrar.so lookup
0(0) fixing /export/home/mins/SER/lib/ser/modules/sl.so sl_send_reply
0(0) INFO: udp_init: SO_RCVBUF is initially 65536
0(0) DEBUG: udp_init: trying SO_RCVBUF: 131072
0(0) DEBUG: setting SO_RCVBUF; set=131072,verify=131072
0(0) DEBUG: udp_init: trying SO_RCVBUF: 262144
0(0) DEBUG: setting SO_RCVBUF; set=262144,verify=262144
0(0) INFO: udp_init: SO_RCVBUF is finally 262144
0(0) ERROR: tcp_init: bind(5, e83bc, 16) on 10.128.16.254: Address
already in use
0(0) DEBUG: tm_shutdown : start
0(0) DEBUG: unlink_timer_lists : emptying DELETE list
0(0) DEBUG: tm_shutdown : emptying hash table
0(0) DEBUG: tm_shutdown : releasing timers
0(0) DEBUG: tm_shutdown : removing semaphores
0(0) DEBUG: tm_shutdown : destroying tmcb lists
0(0) DEBUG: tm_shutdown : done
0(20185) shm_mem_destroy
0(20185) destroying the shared memory lock
The ser.cfg file used is attached with the mail.
Plz sugest me some solution for mentioned problem...
thanx 'n' regds,
Parminder Nayyar
#
# $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
#
# simple quick-start config script
#
# ----------- global configuration parameters ------------------------
#
# Uncomment these lines to enter debugging mode
#
debug=9
fork=yes
log_stderror=yes
listen=10.128.16.254
port=7060
children=4
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
fifo="/tmp/ser_fifo"
fifo_db_url="mysql://ser:[EMAIL PROTECTED]/ser"
# ------------------ module loading ----------------------------------
loadmodule "/export/home/mins/SER/lib/ser/modules/mysql.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/sl.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/tm.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/rr.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/maxfwd.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/usrloc.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/registrar.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/auth.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/auth_db.so"
loadmodule "/export/home/mins/SER/lib/ser/modules/uri_db.so"
# ----------------- setting module-specific parameters ---------------
modparam("auth_db|usrloc", "db_url", "mysql://ser:[EMAIL PROTECTED]/ser")
modparam("auth_db", "calculate_ha1", 1)
modparam("auth_db", "password_column", "password")
modparam("usrloc", "db_mode", 0)
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
#
if(method!="REGISTER") {
record_route();
};
#
# loose-route processing
#
if (loose_route()) {
t_relay();
break;
};
# Call Type Processing Section
if(uri!=myself) {
route(1);
break;
};
if(method=="ACK") {
route(1);
break;
} else if(method == "INVITE") {
route(3);
break;
} else if(method == "REGISTER") {
route(2);
break;
};
lookup("aliases");
if(uri!=myself) {
route(1);
break;
};
if( !lookup("location")) {
sl_send_reply("404", "User Not Found");
break;
};
route(1);
}
# -----------------------------------------------------------------
# Default Message Handler
# -----------------------------------------------------------------
route[1] {
if (!t_relay()) {
sl_reply_error();
};
}
# -----------------------------------------------------------------
# REGISTER Message Handler
# ----------------------------------------------------------------
route[2] {
sl_send_reply("100", "Trying");
if (!www_authorize("","subscriber")) {
www_challenge("","0");
break;
};
if (!check_to()) {
sl_send_reply("401", "Unauthorized");
break;
};
consume_credentials();
if (!save("location")) {
sl_reply_error();
};
}
# -----------------------------------------------------------------
# INVITE Message Handler
# -----------------------------------------------------------------
route[3] {
if (!proxy_authorize("","subscriber")) {
proxy_challenge("","0");
break;
}
# else if (!check_from()) {
# sl_send_reply("403", "Use From=ID");
# break;
# };
consume_credentials();
lookup("aliases");
if (uri!=myself) {
route(1);
break;
};
if (!lookup("location")) {
sl_send_reply("404", "User Not Found");
break;
};
route(1);
}
_______________________________________________
Users mailing list
Users@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
