Re: [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 <http://g.msn.com/8HMAEN/2746??PS=47575> Check out the new MSN Search! ------------------------------------------------------------------------ _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers