[Serusers] db_url not working

kumar gokhare kumargs at localhost.localdomain
Fri May 27 09:40:21 CEST 2005


hello fellows,
everytime i get this message while running ser,i am new to ser,so plz help me 
out n mail me if you can find a way out of this 
mail to : kumargs84 at yahoo.co.in

0(15400) set_mod_param_regex: parameter <db_url> not found in module <acc>
 0(15400) parse error (76,60-61): Can't set module parameter
ERROR: bad config file (1 errors)

here's my ser.cfg file,

#
# $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
#
# simple quick-start config script
#

# ----------- global configuration parameters ------------------------

debug=3         # debug level (cmd line: -dddddddddd)
fork=yes
log_stderror=yes # (cmd line: -E)

#Uncomment these lines to enter debugging mode 

debug=3
log_stderror=yes
listen=127.0.0.1
check_via=no # (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
port=5060
children=4
fifo="/tmp/ser_fifo"

# ------------------ module loading ----------------------------------

# Uncomment this if you want to use SQL database
loadmodule "/usr/local/lib/ser/modules/mysql.so"

loadmodule "/usr/local/lib/ser/modules/sl.so"
loadmodule "/usr/local/lib/ser/modules/tm.so"
loadmodule "/usr/local/lib/ser/modules/rr.so"
loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
loadmodule "/usr/local/lib/ser/modules/usrloc.so"
loadmodule "/usr/local/lib/ser/modules/registrar.so"
loadmodule "/usr/local/lib/ser/modules/acc.so"

# Uncomment this if you want digest authentication
# mysql.so must be loaded !
loadmodule "/usr/local/lib/ser/modules/auth.so"
loadmodule "/usr/local/lib/ser/modules/auth_db.so"


# ----------------- setting module-specific parameters ---------------

# -- usrloc params --

#modparam("usrloc", "db_mode",   0)

# Uncomment this if you want to use SQL database 
# for persistent storage and comment the previous line

#---usrloc param's---
modparam("usrloc", "db_mode", 2)
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")

# -- auth params --
# 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")


# -- rr params --
# add value to ;lr param to make some broken UAs happy
modparam("rr", "enable_full_lr", 1)


#---acc param's ---
modparam("acc", "log_level", 2)
modparam("acc", "log_flag", 2)
modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser")
#modparam("acc", "db_flag", 2)


# -------------------------  request routing logic -------------------

# main routing logic

route{

# if (method=="REGISTER") {
#         setflag(1);
#                setflag(2);
#                log(1, "REGISTER received\n");
#        } else {
#                log(1, "non-REGISTER received\n");
#        };
#        if (uri=~"sip:.*[@:]voip.brujula.net") {
#                log(1, "request for voip.brujula.net received\n");
#        } else {
#                log(1, "request for other domain received\n");
#        };


 # initial sanity checks -- messages with
 # max_forwards==0, or excessively long requests
 if (!mf_process_maxfwd_header("10")) {
  sl_send_reply("483","Too Many Hops");
  break;
 };
 if ( msg:len > max_len ) {
  sl_send_reply("513", "Message too big");
  break;
 };

 #  Process record-routing
 if (loose_route()) {
   t_relay(); 
   break; 
        };

        # labeled all transaction for accounting
        setflag(1);

        # record-route INVITES to make sure BYEs will visit our server too
        if (method=="INVITE") 
  record_route();

        # forward the request statefuly now; (we need *stateful* forwarding,
        # because the stateful mode correlates requests with replies and
        # drops retranmissions; otherwise, we would have to report on
        # every single message received)
        if (!t_relay()) {
                sl_reply_error(); 
                break; 
        };
 
 # we record-route all messages -- to make sure that
 # subsequent messages will go through our proxy; that's
 # particularly good if upstream and downstream entities
 # use different transport protocol
 record_route(); 
 # loose-route processing
 if (loose_route()) {
  t_relay();
  break;
 };

 # if the request is for other domain use UsrLoc
 # (in case, it does not work, use the following command
 # with proper names and addresses in it)
 if (uri==myself) {

  if (method=="REGISTER") {

 # Uncomment this if you want to use digest authentication
   setflag(1);
                 setflag(2);
   log(1,"REGISTER : Authenticating user\n");

   if (!www_authorize("voip.brujula.net","subscriber")) {
    log(1,"REGISTER : Challenging user\n");
    www_challenge("voip.brujula.net", "0");
    break;
   };

   save("location");
   break;
  };

  # native SIP destinations are handled using our USRLOC DB
  if (!lookup("location")) {
   sl_send_reply("404", "Not Found");
   break;
  };
 };
 # forward to current uri now; use stateful forwarding; that
 # works reliably even if we forward from TCP to UDP
 if (!t_relay()) {
  sl_reply_error();
 };

}




More information about the sr-users mailing list