[Serusers] acc module + database

[Darren Sessions]

Hey All,

I am trying to get all missed calls to post to the MySQL database. However,
I am getting the following error when starting 

up SER.

 

0(1748) set_mod_param_regex: parameter <db_flag> not found in module <acc>

0(1748) parse error (54,29-30): Can't set module parameter

0(1748) set_mod_param_regex: parameter <db_url> not found in module <acc>

0(1748) parse error (55,59-60): Can't set module parameter

0(1748) set_mod_param_regex: parameter <db_missed_flag> not found in module
<acc>

0(1748) parse error (56,36-37): Can't set module parameter

ERROR: bad config file (3 errors)

 

I've tried recompiling the "acc" module (the original was from the Solaris
package for SER 0.8.12).

Anyone know why I am getting these errors? My config is basically copied
directly from the acc module examples.

I have also attached my ser.cfg file below.

Thanks for your help!

Darren Sessions

----

#

# $Id: pstn.cfg,v 1.2 2003/06/03 03:18:12 jiri Exp $

#

# example: ser configured as PSTN gateway guard; PSTN gateway is 

located

# at 192.168.0.10

#

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

---

debug=3 # debug level (cmd line: -dddddddddd)

fork=yes

log_stderror=yes # (cmd line: -E)

dns=yes

rev_dns=yes

check_via=no

fifo="/tmp/ser_fifo"

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

---

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/uri.so"

loadmodule "/usr/local/lib/ser/modules/group.so"

loadmodule "/usr/local/lib/ser/modules/mysql.so"

loadmodule "/usr/local/lib/ser/modules/acc.so"

loadmodule "/usr/local/lib/ser/modules/auth.so"

loadmodule "/usr/local/lib/ser/modules/auth_db.so"

#loadmodule "/usr/local/lib/ser/modules/textops.so"

#loadmodule "/usr/local/lib/ser/modules/vm.so"

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

---

modparam("auth_db", "db_url","mysql://ser:heslo@localhost/ser")

modparam("auth_db", "calculate_ha1", yes)

modparam("auth_db", "password_column", "password")

modparam("usrloc", "db_mode", 2)

# -- acc params --

modparam("acc", "log_level", 1)

# that is the flag for which we will account -- don't forget to

# set the same one :-)

#modparam("acc", "db_flag", 1)

modparam("acc", "db_url","mysql://ser:heslo@localhost/ser")

modparam("acc", "db_missed_flag", 3)

modparam("tm", "fr_inv_timer", 20)

#modparam("tm", "fr_inv_timer", 20)

#modparam("tm", "fr_inv_timer", 20>

modparam("group", "db_url", "mysql://ser:heslo@localhost/ser")

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

---

# main routing logic

alias="ion.dom"

alias="63.86.212.154"

route {

if (!mf_process_maxfwd_header("10")) {

log("LOG: Too many hops\n");

sl_send_reply("483", "Alas Too Many Hops");

break;

};

if (!(method=="REGISTER")) record_route();

if (loose_route()) {

t_relay();

break;

};

# if (!uri==myself) {

# t_relay();

# break;

# };

if (method == "REGISTER") {

if (!save("location")) {

sl_reply_error();

};

break;

};

# does the user wish redirection on no availability? 

(i.e., is he

# in the voicemail group?) -- determine it now and store 

it in

# flag 4, before we rewrite the flag using UsrLoc

if (is_user_in("Request-URI", "voicemail")) {

setflag(4);

};

# native SIP destinations are handled using our USRLOC DB

if (!lookup("location")) {

# handle user which was not found

route(4);

break;

};

# if user is on-line and is in voicemail group, enable 

redirection

if (method == "INVITE" && isflagset(4)) {

t_on_failure("1");

};

setflag(3);

t_relay();

}

# ------------- handling of unavailable user ------------------

route[4] {

# non-Voip -- just send "off-line"

if (!(method == "INVITE" || method == "ACK" || method 

== "CANCEL")) {

sl_send_reply("404", "Not Found");

break;

};

# not voicemail subscriber

if (!isflagset(4)) {

if (uri=~"^sip:1.*") {

rewritehostport("1.1.1.7:5060"); 

t_relay_to_udp("1.1.1.7", "5060");

break;

};

if (uri=~"^sip:011.*") {

rewritehostport("1.1.1.6:5060");

t_relay_to_udp("1.1.1.6", "5060");

break;

};

}

# forward to voicemail now

setflag(3);

rewritehostport("1.1.1.8:5060");

t_relay_to_udp("1.1.1.8", "5060");

}

# if forwarding downstream did not succeed, try voicemail running

# at bat.iptel.org:5060

failure_route[1] {

setflag(3);

revert_uri();

rewritehostport("1.1.1.8:5060");

append_branch();

t_relay_to_udp("1.1.1.8", "5060");

}

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20031212/c1a5510d/attachment.htm>