[Serusers] MySQL accounting does not work in ser 0.8.12

[Chris St Denis]

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 at iptel.org [mailto:serusers-bounces at lists.iptel.org]On
Behalf Of Yiannis Martis
  Sent: Friday, July 08, 2005 9:54 AM
  To: serusers at 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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20050708/30c76783/attachment.htm>