[Serusers] Help - acc.so problem

[Winston]

Hi all,

I am trying to setup the call accounting for SER 0.8.12 in RH 9 with MySQL.

However,I compiled the modules for SER and I am currently facing a problem
with the compiled version acc.so. The SER application cannot be started
properly. 

The error is as below:

Jul 16 23:37:37 himalayas ser: Listening on
Jul 16 23:37:37 himalayas ser:               202.8.42.211
[202.8.42.211]:5060
Jul 16 23:37:37 himalayas ser: Aliases: himalayas.homelinux.com:*
Jul 16 23:37:37 himalayas ser: ser startup succeeded
Jul 16 23:37:37 himalayas /usr/local/sbin/ser[2098]: connect_db(): Too many
connections
Jul 16 23:37:37 himalayas /usr/local/sbin/ser[2098]: db_init(): Error while
trying to connect database
Jul 16 23:37:37 himalayas /usr/local/sbin/ser[2098]: auth_db:init_child():
Unable to connect database
Jul 16 23:37:37 himalayas /usr/local/sbin/ser[2098]: init_mod_child(): Error
while initializing module auth_db
Jul 16 23:37:37 himalayas /usr/local/sbin/ser[2098]: tcp_main: error in
init_child


When I used the acc.so from the RPM package, it is running ok. 

I am trying to configure MySQL with call accounting. 

My ser.cfg as below:


# Uncomment this if you want to use SQL database
loadmodule "/usr/local/lib/ser/modules/mysql.so"
loadmodule "/usr/local/lib/ser/modules/exec.so"
loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/acc.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"
loadmodule "/usr/local/lib/ser/modules/uri.so"
loadmodule "/usr/local/lib/ser/modules/textops.so"
loadmodule "/usr/local/lib/ser/modules/group.so"
loadmodule "/usr/lib/ser/modules/nathelper.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",   0)

# Uncomment this if you want to use SQL database
# for persistent storage and comment the previous line
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "timer_interval", 10)

modparam("auth_db|uri|usrloc|group", "db_url",
"sql://ser:heslo@localhost/ser")

# -- registrar params --
# We will you flag 6 to mark NATed contacts
modparam("registrar", "nat_flag", 6)

# Enable NAT pinging (interval 30s to accommodate freebsd libalias
# (nat) default udp timeout (60)
modparam("nathelper", "natping_interval", 30)
# Ping only contacts that are known to be behind NAT
# feature to come in next SER version
# modparam("nathelper", "ping_nated_only", 1)


# -- 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)

# -- acc params --
# set the reporting log level
modparam("acc", "log_level", 1)
# number of flag, which will be used for accounting; if a message is
# labeled with this flag, its completion status will be reported
modparam("acc", "log_flag", 1 )
#modparam("acc", "db_url", "sql://ser:heslo@localhost/ser")
#modparam("acc", "db_flag", 2)


Please help to enlighten me. 

Thank you very much.

Best regards

Winston


-----Original Message-----
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] On
Behalf Of Michael Przybylski
Sent: Friday, July 16, 2004 8:24 AM
To: serusers at lists.iptel.org
Subject: [Serusers] cookbook for MySQL accounting?

Hello,

	Is there anybody out there who can share with me a cookbook for
getting MySQL call accounting to work in SER.
	The acc.so documentation isn't terribly clear about how to get
this working.

Best regards,
Mike Przybylski

_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers