Ca anyone help me with ser 0.8.12 accounting?
I have installed rpm distro of ser 0.8.12 but mysql accounting does not work. Ser will not start!
Can anyone please help me? Here's my ser.cfg part specific to accounting
# -------------------GLOBAL CONFIGURATION PARAMETERS ------------------------#
#############################################################################
debug=3 # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=no # (cmd line: -E)
listen=XX.XX.XX.XX
listen=127.0.0.1
alias=XXXXXXXXXXXXX.com
alias=xx.xx.xx.xx.xx
alias=xxxxxxxxxxxxx.com
alias=xxxxxxxxxxxxxl.com
/* Uncomment these lines to enter debugging mode
#debug=7
#fork=no
#log_stderror=yes
*/
dns=no # (cmd. line: -r)
rev_dns=no # (cmd. line: -R)
port=5060
children=4
check_via=yes # (cmd. line: -v)
syn_branch=yes
sip_warning=yes
fifo="/tmp/ser_fifo"
fifo_mode=0666
server_signature=yes
reply_to_via=no
#uid="nobody"
#gid="nobody"
#mhomed=0
# -----------------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"
# 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"
loadmodule "/usr/lib/ser/modules/acc.so"
loadmodule "/usr/lib/ser/modules/exec.so"
loadmodule "/usr/lib/ser/modules/group.so"
loadmodule "/usr/lib/ser/modules/print.so"
loadmodule "/usr/lib/ser/modules/textops.so"
loadmodule "/usr/lib/ser/modules/uri.so"
# ----------------- SETTING MODULE-SPECIFIC PARAMETERS ------------------#
##########################################################################
# ------------- tm params -------------------------
modparam("tm", "fr_timer", 12)
modparam("tm", "fr_inv_timer", 24)
# -------------- rr params ------------------------
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)
# -------------- accounting params ----------------
modparam("acc", "log_missed_flag", 3)
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", 1)
#modparam("acc", "db_url", "sql://ser:XXXXXXXXX@localhost/ser")
#modparam("acc", "db_flag", 1)
#modparam("acc", "failed_transactions", 1)
# -------------- 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)
#database location
modparam("usrloc", "db_url", "sql://ser:XXXXXXXX6@localhost/ser")
# -------------- auth params ----------------------
#database location
modparam("auth_db", "db_url", "sql://ser:XXXXXXXXXXX@localhost/ser")
# 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