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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org]On Behalf Of Yiannis Martis Sent: Friday, July 08, 2005 9:54 AM To: serusers(a)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!