[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 &lt;gaillacharry(a)yahoo.fr&gt; [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 &lt;gaillacharry(a)yahoo.fr&gt; [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");
 > 
 >     		};
 > }
 > 
 > 
 >   