<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2716.2200" name=GENERATOR></HEAD>
<BODY>
<DIV>
<P><FONT size=2>Hey All,</FONT></P>
<P><FONT size=2>I am trying to get all missed calls to post to the MySQL
database. However, I am getting the following error when starting </FONT></P>
<P><FONT size=2>up SER.</FONT></P>
<P><FONT face=Arial size=2></FONT> </P>
<P><FONT size=2>0(1748) set_mod_param_regex: parameter <db_flag> not found
in </FONT><FONT size=2>module <acc></FONT></P>
<P><FONT size=2>0(1748) parse error (54,29-30): Can't set module
parameter</FONT></P>
<P><FONT size=2>0(1748) set_mod_param_regex: parameter <db_url> not found
in </FONT><FONT size=2>module <acc></FONT></P>
<P><FONT size=2>0(1748) parse error (55,59-60): Can't set module
parameter</FONT></P>
<P><FONT size=2>0(1748) set_mod_param_regex: parameter <db_missed_flag>
not found<SPAN class=323312021-12122003> </SPAN>in module <acc></FONT></P>
<P><FONT size=2>0(1748) parse error (56,36-37): Can't set module
parameter</FONT></P>
<P><FONT size=2>ERROR: bad config file (3 errors)</FONT></P>
<P><FONT size=2></FONT> </P>
<P><FONT size=2>I've tried recompiling the "acc" module (the original was from
the Solaris package for SER 0.8.12).</FONT></P>
<P><FONT size=2>Anyone know why I am getting these errors? My config is
basically<SPAN class=323312021-12122003> </SPAN>copied directly from the acc
module examples.</FONT></P>
<P><FONT size=2>I have also attached my ser.cfg file below.</FONT></P>
<P><FONT size=2>Thanks for your help!</FONT></P>
<P><SPAN class=323312021-12122003><FONT size=2>Darren Sessions</FONT></SPAN></P>
<P><FONT size=2>----</FONT></P>
<P><FONT size=2>#</FONT></P>
<P><FONT size=2># $Id: pstn.cfg,v 1.2 2003/06/03 03:18:12 jiri Exp $</FONT></P>
<P><FONT size=2>#</FONT></P>
<P><FONT size=2># example: ser configured as PSTN gateway guard; PSTN gateway is
</FONT></P>
<P><FONT size=2>located</FONT></P>
<P><FONT size=2># at 192.168.0.10</FONT></P>
<P><FONT size=2>#</FONT></P>
<P><FONT size=2># ----------- global configuration parameters
---------------------</FONT></P>
<P><FONT size=2>---</FONT></P>
<P><FONT size=2>debug=3 # debug level (cmd line: -dddddddddd)</FONT></P>
<P><FONT size=2>fork=yes</FONT></P>
<P><FONT size=2>log_stderror=yes # (cmd line: -E)</FONT></P>
<P><FONT size=2>dns=yes</FONT></P>
<P><FONT size=2>rev_dns=yes</FONT></P>
<P><FONT size=2>check_via=no</FONT></P>
<P><FONT size=2>fifo="/tmp/ser_fifo"</FONT></P>
<P><FONT size=2># ------------------ module loading
-------------------------------</FONT></P>
<P><FONT size=2>---</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/sl.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/tm.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/rr.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/maxfwd.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/usrloc.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/registrar.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/uri.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/group.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/mysql.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/acc.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/auth.so"</FONT></P>
<P><FONT size=2>loadmodule "/usr/local/lib/ser/modules/auth_db.so"</FONT></P>
<P><FONT size=2>#loadmodule "/usr/local/lib/ser/modules/textops.so"</FONT></P>
<P><FONT size=2>#loadmodule "/usr/local/lib/ser/modules/vm.so"</FONT></P>
<P><FONT size=2># ----------------- setting module-specific parameters
------------</FONT></P>
<P><FONT size=2>---</FONT></P>
<P><FONT size=2>modparam("auth_db",
"db_url","mysql://ser:heslo@localhost/ser")</FONT></P>
<P><FONT size=2>modparam("auth_db", "calculate_ha1", yes)</FONT></P>
<P><FONT size=2>modparam("auth_db", "password_column", "password")</FONT></P>
<P><FONT size=2>modparam("usrloc", "db_mode", 2)</FONT></P>
<P><FONT size=2># -- acc params --</FONT></P>
<P><FONT size=2>modparam("acc", "log_level", 1)</FONT></P>
<P><FONT size=2># that is the flag for which we will account -- don't forget
to</FONT></P>
<P><FONT size=2># set the same one :-)</FONT></P>
<P><FONT size=2>#modparam("acc", "db_flag", 1)</FONT></P>
<P><FONT size=2>modparam("acc",
"db_url","mysql://ser:heslo@localhost/ser")</FONT></P>
<P><FONT size=2>modparam("acc", "db_missed_flag", 3)</FONT></P>
<P><FONT size=2>modparam("tm", "fr_inv_timer", 20)</FONT></P>
<P><FONT size=2>#modparam("tm", "fr_inv_timer", 20)</FONT></P>
<P><FONT size=2>#modparam("tm", "fr_inv_timer", 20></FONT></P>
<P><FONT size=2>modparam("group", "db_url",
"mysql://ser:heslo@localhost/ser")</FONT></P>
<P><FONT size=2># ------------------------- request routing logic
----------------</FONT></P>
<P><FONT size=2>---</FONT></P>
<P><FONT size=2># main routing logic</FONT></P>
<P><FONT size=2>alias="ion.dom"</FONT></P>
<P><FONT size=2>alias="63.86.212.154"</FONT></P>
<P><FONT size=2>route {</FONT></P>
<P><FONT size=2>if (!mf_process_maxfwd_header("10")) {</FONT></P>
<P><FONT size=2>log("LOG: Too many hops\n");</FONT></P>
<P><FONT size=2>sl_send_reply("483", "Alas Too Many Hops");</FONT></P>
<P><FONT size=2>break;</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2>if (!(method=="REGISTER")) record_route();</FONT></P>
<P><FONT size=2>if (loose_route()) {</FONT></P>
<P><FONT size=2>t_relay();</FONT></P>
<P><FONT size=2>break;</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2># if (!uri==myself) {</FONT></P>
<P><FONT size=2># t_relay();</FONT></P>
<P><FONT size=2># break;</FONT></P>
<P><FONT size=2># };</FONT></P>
<P><FONT size=2>if (method == "REGISTER") {</FONT></P>
<P><FONT size=2>if (!save("location")) {</FONT></P>
<P><FONT size=2>sl_reply_error();</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2>break;</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2># does the user wish redirection on no availability? </FONT></P>
<P><FONT size=2>(i.e., is he</FONT></P>
<P><FONT size=2># in the voicemail group?) -- determine it now and store
</FONT></P>
<P><FONT size=2>it in</FONT></P>
<P><FONT size=2># flag 4, before we rewrite the flag using UsrLoc</FONT></P>
<P><FONT size=2>if (is_user_in("Request-URI", "voicemail")) {</FONT></P>
<P><FONT size=2>setflag(4);</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2># native SIP destinations are handled using our USRLOC
DB</FONT></P>
<P><FONT size=2>if (!lookup("location")) {</FONT></P>
<P><FONT size=2># handle user which was not found</FONT></P>
<P><FONT size=2>route(4);</FONT></P>
<P><FONT size=2>break;</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2># if user is on-line and is in voicemail group, enable
</FONT></P>
<P><FONT size=2>redirection</FONT></P>
<P><FONT size=2>if (method == "INVITE" && isflagset(4)) {</FONT></P>
<P><FONT size=2>t_on_failure("1");</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2>setflag(3);</FONT></P>
<P><FONT size=2>t_relay();</FONT></P>
<P><FONT size=2>}</FONT></P>
<P><FONT size=2># ------------- handling of unavailable user
------------------</FONT></P>
<P><FONT size=2>route[4] {</FONT></P>
<P><FONT size=2># non-Voip -- just send "off-line"</FONT></P>
<P><FONT size=2>if (!(method == "INVITE" || method == "ACK" || method
</FONT></P>
<P><FONT size=2>== "CANCEL")) {</FONT></P>
<P><FONT size=2>sl_send_reply("404", "Not Found");</FONT></P>
<P><FONT size=2>break;</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2># not voicemail subscriber</FONT></P>
<P><FONT size=2>if (!isflagset(4)) {</FONT></P>
<P><FONT size=2>if (uri=~"^sip:1.*") {</FONT></P>
<P><FONT size=2>rewritehostport("<SPAN class=323312021-12122003>1</SPAN>.<SPAN
class=323312021-12122003>1.1.7</SPAN>:5060"); </FONT></P>
<P><FONT size=2>t_relay_to_udp("<SPAN class=323312021-12122003>1.1.1</SPAN>.7",
"5060");</FONT></P>
<P><FONT size=2>break;</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2>if (uri=~"^sip:011.*") {</FONT></P>
<P><FONT size=2>rewritehostport("<SPAN
class=323312021-12122003>1.1.1.</SPAN>6:5060");</FONT></P>
<P><FONT size=2>t_relay_to_udp("<SPAN class=323312021-12122003>1.1.1.</SPAN>6",
"5060");</FONT></P>
<P><FONT size=2>break;</FONT></P>
<P><FONT size=2>};</FONT></P>
<P><FONT size=2>}</FONT></P>
<P><FONT size=2># forward to voicemail now</FONT></P>
<P><FONT size=2>setflag(3);</FONT></P>
<P><FONT size=2>rewritehostport("<SPAN
class=323312021-12122003>1.1.1.</SPAN>8:5060");</FONT></P>
<P><FONT size=2>t_relay_to_udp("<SPAN class=323312021-12122003>1.1.1.</SPAN>8",
"5060");</FONT></P>
<P><FONT size=2>}</FONT></P>
<P><FONT size=2># if forwarding downstream did not succeed, try voicemail
running</FONT></P>
<P><FONT size=2># at bat.iptel.org:5060</FONT></P>
<P><FONT size=2>failure_route[1] {</FONT></P>
<P><FONT size=2>setflag(3);</FONT></P>
<P><FONT size=2>revert_uri();</FONT></P>
<P><FONT size=2>rewritehostport("<SPAN
class=323312021-12122003>1.1.1.</SPAN>8:5060");</FONT></P>
<P><FONT size=2>append_branch();</FONT></P>
<P><FONT size=2>t_relay_to_udp("<SPAN class=323312021-12122003>1.1.1.</SPAN>8",
"5060");</FONT></P>
<P><FONT size=2>}</FONT></P></DIV></BODY></HTML>