[Serusers] MySQL accounting does not work in ser 0.8.12

Iqbal iqbal at gigo.co.uk
Fri Jul 8 19:02:17 CEST 2005


have u compiled ser to allow mysql accounting or radius, if u r nt sure 
read www.onsip.org

Iqbal

Yiannis Martis wrote:

>
> 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 at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>  
>




More information about the sr-users mailing list