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