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@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Michael Przybylski Sent: Friday, July 16, 2004 8:24 AM To: serusers@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers