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@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@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@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@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