you need to edit modules/acc/Makefile and enable sql accounting if you want it.
 
Btw, .8.12 is pretty old, you should upgrade to .8.14 if you want to use the 8.x series. Or upgrade to 9.3, though doing so will probably break stuff, its not fully compatible.
-----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.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!