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

What is not clear to you ? You need to uncomment SQL related lines in the Makefile of acc module, recompile the module and then use db_flag and db_missed flag in your configuration file.

Jan.

On 15-07 17:23, Michael Przybylski wrote:

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