[Serusers] Re: SERWEB+SER - sr-users

22 Apr 2004

      www.google.com
acc +mysql :host mail.iptel.org
have'nt testet it.. but I know that you are not the first one who has
had that problem.
-atle
* gaillac harry gaillacharry@yahoo.fr [040422 17:06]:
...
your're right
"DEFS+=-DSQL_ACC" in the modules/acc/Makefile.
Where Could I find that information?
Regards
Le jeu 22/04/2004 ?? 16:45, Atle Samuelsen a ??crit :
...
If I dont rember TOO wrong, I think there is a option you have forgot'n
in the Makefile for the acc.module that says if it uses a database or
not.

Atle

gaillac harry gaillacharry@yahoo.fr [040422 16:29]:

...
Here is my ser.cfg.SER don't start because of acc module 
anybody could help me to solved this problem before an other ?
ser -c =>
 0(6238) set_mod_param_regex: parameter <db_url> not found in module
<acc>
 0(6238) parse error (96,60-61): Can't set module parameter
 0(6238) set_mod_param_regex: parameter <db_missed_flag> not found in
module <acc>
 0(6238) parse error (97,36-37): Can't set module parameter
 0(6238) parse error (195,63-64): unknown command, missing loadmodule?
ERROR: bad config file (3 errors)
regards
#
# $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=no	# (cmd line: -E)
/* Uncomment these lines to enter debugging mode 
debug=9
fork=yes
log_stderror=yes
*/
check_via=no	# (cmd. line: -v)
dns=no           # (cmd. line: -r)
rev_dns=no      # (cmd. line: -R)
port=5060
listen=192.168.0.1
children=4
fifo="/tmp/ser_fifo"
fifo_mode=0666
#alias="example.com"
# ------------------ module:wq 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/domain.so"
loadmodule "/usr/lib/ser/modules/usrloc.so"
loadmodule "/usr/lib/ser/modules/registrar.so"
loadmodule "/usr/lib/ser/modules/msilo.so"
loadmodule "/usr/lib/ser/modules/vm.so"
loadmodule "/usr/lib/ser/modules/acc.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"
# ----------------- 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
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
modparam("usrloc", "db_mode", 1)
#modparam("usrloc", "use_domain", 1)
# --register params--
modparam("registrar", "use_domain", 1)
# -- 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)
# --domain module--
modparam("usrloc", "db_url", "mysql://ser:heslo@localhost/ser")
modparam("domain", "db_mode", 1)
modparam("domain", "domain_table", "domain")
modparam("domain", "domain_col", "domain")
# --msilo params--
modparam("msilo", "registrar", "sip:registrar@example.com")
modparam("msilo", "db_url", "mysql://ser:heslo@localhost/ser")
# --vm params--
modparam("voicemail", "db_url", "mysql://ser:heslo@localhost/ser")
# --acc params--
modparam("acc", "log_level", 1)
modparam("acc", "log_flag", 2)
modparam("acc", "log_missed_flag", 2)
modparam("acc", "log_fmt", "fimos")
modparam("acc", "db_url", "mysql://ser:heslo@localhost/ser")
modparam("acc", "db_missed_flag", 2)
# -------------------------  request routing logic -------------------
# main routing logic
route{
# 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;
   };
# 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 (is_from_local()) {
if (method=="REGISTER") {

# Uncomment this if you want to use digest authentication
   		if (!www_authorize("", "subscriber")) {
   			www_challenge("", "0");
   			break;
   		};
	save("location");
	m_dump();
	break;
};

# native SIP destinations are handled using our USRLOC DB
lookup("aliases");
if (!lookup("location")) {

if (method == "MESSAGE") {
    		if (!t_newtran()) {
        			sl_reply_error();
        			break;
    			};

    	if (m_store("0")) {
        		t_reply("202", "Accepted for Later Delivery");
        			break;
    			};

  			 t_reply("503", "Service Unavailable");
    			break;
				};
	};

 			if ((method=="INVITE" || method=="ACK") && t_newtran() ) {
      		t_reply("404", "Not Found");
		route(3);
	  	break;
    			};

};
setflag(2);
        # forward to current uri now; use stateful forwarding; that
        # works reliably even if we forward from TCP to UDP
        t_on_failure("1");	
   # 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();
   };
}
route[3] {
# non-Voip -- just send "off-line"
   		 if (!(method=="INVITE" || method=="ACK" || method=="CANCEL")) {
        		sl_send_reply("404", "Not Found");
        		break;
    		};
    		if (t_newtran()) {
         		t_reply("404", "Not Found");
            		acc_db_request("404 missed call", "missed_calls");
		};

}