[Serusers] Problem with SER modules, mediaproxy.so and domain.so

Tue Nov 14 06:26:03 CET 2006

Hello,

I am totally confused, Installed ser rpm on FC5, with all the modules,
If I start ser with out mediaproxy.so and domain.so modules every thing 
works great.
But When I add these two mosules I start getting in problem and it does 
not start.
Here is the error,

1(0) DEBUG: init_mod_child (-1): tm
 1(0) DEBUG: callid: '74fe3fe7-0 at xxx.xxx.xxx.xxx'
 1(0) DEBUG: init_mod_child (-1): usrloc
 1(0) get_connection(): Connection not found in the pool
 2(0) INFO: fifo process starting: 11768
 2(0) DEBUG: init_mod_child (-2): tm
 2(0) DEBUG: callid: '74fe3fe7-0 at xxx.xxx.xxx.xxx'
 2(0) DEBUG: init_mod_child (-2): usrloc
 2(0) get_connection(): Connection not found in the pool
 0(11766) DEBUG: init_mod_child (1): tm
 0(11766) DEBUG: callid: '74fe3fe7-11766 at xxx.xxx.xxx.xxx'
 0(11766) DEBUG: init_mod_child (1): usrloc
 0(11766) get_connection(): Connection not found in the pool
 1(11767) DEBUG: init_mod_child (-1): auth_db
 0(11766) DEBUG: init_mod_child (1): auth_db
 1(11767) get_connection(): Connection found in the pool
 0(11766) get_connection(): Connection found in the pool
 1(11767) DEBUG: init_mod_child (-1): uri_db
 0(11766) DEBUG: init_mod_child (1): uri_db
 1(11767) get_connection(): Connection found in the pool
 0(11766) get_connection(): Connection found in the pool
 1(11767) DEBUG: init_mod_child (-1): domain
 0(11766)  1(11767) DEBUG: init_mod_child (1): domain
DEBUG: init_mod_child (-1): nathelper
 0(11766) get_connection(): Connection not found in the pool
 1(11767) DEBUG: init_mod_child (-1): avpops
 1(11767) get_connection(): Connection found in the pool
 1(11767) DEBUG: init_mod_child (-1): permissions
 2(11768) DEBUG: init_mod_child (-2): auth_db
 2(11768) get_connection(): Connection found in the pool
 2(11768) DEBUG: init_mod_child (-2): uri_db
 2(11768) get_connection(): Connection found in the pool
 2(11768) DEBUG: init_mod_child (-2): domain
 2(11768) DEBUG: init_mod_child (-2): nathelper
 2(11768) DEBUG: init_mod_child (-2): avpops
 2(11768) get_connection(): Connection found in the pool
 2(11768) DEBUG: init_mod_child (-2): permissions
 2(11768) get_connection(): Connection found in the pool
*
 0(11766) new_connection(): Access denied for user 'serro'@'localhost' 
(using password: YES)

I have not idea why it is using serror at localhost to connect to db. I 
will post my config files (ser.cfg and serctl) below.

* 0(11766) db_init(): Could not create a connection
* 0(11766) ERROR:domain_db_init: cannot initialize database connection
 0(11766) ERROR: domain:child_init(): Unable to connect to the database
 0(11766) init_mod_child(): Error while initializing module domain
 0(11766) main_dontfork: init_child failed
 2(11768) INFO: signal 15 received
 2(11768) Memory status (pkg):*
 2(11768)  1(11767) INFO: signal 15 received
 1(11767) Memory status (pkg):
 1(11767) fm_status (0x811c800):
 1(11767)  heap size= 1048576

Top part of ser.cfg file

[root@ ser]# more ser.cfg
#
# $Id: ser.cfg,v 1.25.2.1 2005/02/18 14:30:44 andrei Exp $
#
# simple quick-start config script
#

# ----------- global configuration parameters ------------------------

debug=5         # debug level (cmd line: -dddddddddd)
#fork=yes
#log_stderror=no        # (cmd line: -E)

/* Uncomment these lines to enter debugging mode
fork=no
log_stderror=yes
*/

#listen=192.168.2.201
listen=209.XXX.XXX.XXX

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"
a

fifo_db_url="mysql://username:password@host/ser_db"

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database

loadmodule "/usr/lib/ser/modules/mysql.so"
loadmodule "/usr/lib/ser/modules/sl.so"
loadmodule "/usr/lib/ser/modules/tm.so"
loadmodule "/usr/lib/ser/modules/rr.so"
loadmodule "/usr/lib/ser/modules/maxfwd.so"
loadmodule "/usr/lib/ser/modules/usrloc.so"
loadmodule "/usr/lib/ser/modules/registrar.so"
loadmodule "/usr/lib/ser/modules/auth.so"
loadmodule "/usr/lib/ser/modules/auth_db.so"
loadmodule "/usr/lib/ser/modules/uri_db.so"
loadmodule "/usr/lib/ser/modules/uri.so"
loadmodule "/usr/lib/ser/modules/domain.so"
loadmodule "/usr/lib/ser/modules/mediaproxy.so"
loadmodule "/usr/lib/ser/modules/nathelper.so"
loadmodule "/usr/lib/ser/modules/textops.so"
loadmodule "/usr/lib/ser/modules/avpops.so"
loadmodule "/usr/lib/ser/modules/permissions.so"
#loadmodule "/usr/lib/ser/modules/domain.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
#loadmodule "/usr/lib/ser/modules/auth.so"
#loadmodule "/usr/lib/ser/modules/auth_db.so"

# ----------------- setting module-specific parameters ---------------

modparam("auth_db|permissions|uri_db|usrloc", "db_url", 
"mysql://username:password@host/ser_db")

modparam("auth_db", "calculate_ha1", 0)
modparam("auth_db", "password_column", "password")
modparam("nathelper", "rtpproxy_disable", 1)
modparam("nathelper", "natping_interval", 0)
modparam("mediaproxy","natping_interval", 30)
modparam("mediaproxy","mediaproxy_socket", "/var/run/mediaproxy.sock")
modparam("mediaproxy","sip_asymmetrics","/etc/ser/sip-clients")
modparam("mediaproxy","rtp_asymmetrics","/etc/ser/rtp-clients")

modparam("usrloc", "db_mode", 2)

modparam("registrar", "nat_flag", 6)

modparam("rr", "enable_full_lr", 1)

modparam("tm", "fr_inv_timer", 27)
modparam("tm", "fr_inv_timer_avp", "inv_timeout")

modparam("permissions", "db_mode", 1)
modparam("permissions", "trusted_table", "trusted")

modparam("avpops", "avp_url", "mysql://username:password@host/ser_db")
modparam("avpops", "avp_table", "usr_preferences")

# main routing logic

route {

SERCTL file

# configuration for starting/stopping ser
PID_FILE=/var/run/ser.pid
SYSLOG=1 # 0=output to console, 1=output to syslog
STARTOPTIONS= # for example -dddd
DIR=`dirname $0`
SERBIN=$DIR/ser
AWK=awk

# ser's FIFO server
if [ -z "$SER_FIFO" ]; then
        SER_FIFO=/tmp/ser_fifo
fi
# period in which stats are reprinted
if [ -z "$WATCH_PERIOD" ] ; then
        WATCH_PERIOD=2
fi

# SQL config
if [ -z "$SQL_DB" ] ; then
        SQL_DB=ser_DB
fi
if [ -z "$SQL_HOST" ] ; then
        SQL_HOST=SER_HOST //not localhost
fi
if [ -z "$SQL_USER" ] ; then
        SQL_USER=username
fi

# the read-only user for whom password may be stored here
if [ -z "$RO_USER" ] ; then
        RO_USER=usename
fi
if [ -z "$RO_PW" ] ; then
        RO_PW=password
fi

# binaries
GENHA1='gen_ha1'
MYSQL='mysql'
SER='sr'
LAST_LINE='tail -1'

# ACL name verification
VERIFY_ACL=1
ACL_GROUPS="local ld int voicemail free-pstn prepaid"

VERSION='$Revision: 1.83.2.2 $'

NOTE: If I dont add mediaproxy.so and domain.so then everything works 
lgreate

Ser verision
[root@ ser]# rpm -qa | grep ser-
ser-serweb-0.9.6-6.fc5   ///This also did not work, problem with 
classkit and runkit extension. If any one could make it work on FC5 with 
PHP 5.1, Please share.

ser-mysql-0.9.6-6.fc5
ser-0.9.6-6.fc5

I am tired like dead, Any idea will be help.

Thank you,
-JK

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20061113/1a48fe33/attachment.htm>