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



Don't just search. Find. MSN Search Check out the new MSN Search!