-----Original Message-----
From: serusers-bounces@lists.iptel.org [mailto:serusers-bounces@lists.iptel.org]On Behalf Of Yiannis Martis
Sent: Friday, July 08, 2005 9:54 AM
To: serusers@lists.iptel.org
Subject: [Serusers] MySQL accounting does not work in ser 0.8.12
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.1alias=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=4check_via=yes # (cmd. line: -v)
syn_branch=yes
sip_warning=yes
fifo="/tmp/ser_fifo"
fifo_mode=0666server_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!