Hi Gordon,
Note that $var(rule_attrs_pvar) is populated only after do_routing() is
done successful and only if passed as parameter on the right position
(see the function prototype). Do you have something like that in your
script ?
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 08.06.2014 22:23, Gordon Sims wrote:
Hello Bogdan-Andrei,
I've looked over the link and tried to piece it into the config.
Unfortunately I could not get it to log to the database.
Here is the opensips.cfg file:
#### ACCounting module
loadmodule "acc.so"
/* what special events should be accounted ? */
modparam("acc", "early_media", 0)
modparam("acc", "report_cancels", 0)
/* by default we do not adjust the direct of the sequential requests.
if you enable this parameter, be sure the enable "append_fromtag"
in "rr" module */
modparam("acc", "detect_direction", 0)
modparam("acc", "cdr_flag", "ACC_CDR")
#modparam("acc", "failed_transaction_flag", "ACC_FAILED")
/* account triggers (flags) */
modparam("acc", "db_flag", "ACC_DO")
modparam("acc", "db_url",
"mysql://randomuser:[email protected]/sip_gate") # CUSTOMIZE ME
modparam("acc", "db_extra", "from_uri=$fU; to_uri=$tU;
attrs=$var(rule_attrs_pvar)") #Extra data
...
route{
if (method == "INVITE") {
create_dialog();
setflag(ACC_CDR);
setflag(ACC_DO); # do accounting ...
record_route();
xlog("INBOUND
CALL,$dd,$ru,$ci,$fn,$fu,$var(rule_attrs_pvar)");
route(10);
exit;
}
I also tried to put it into the xlog to see if I could find it in
there and no such luck. I know I'm obviously doing something wrong,
but not sure what. At this point I'm gong cross eyed looking at the code.
If you have any additional advice, would be much appreciated.
Thanks,
Gordon
From: Bogdan-Andrei Iancu <[email protected]
<mailto:[email protected]>>
Reply-To: OpenSIPS users mailling list <[email protected]
<mailto:[email protected]>>
Date: Sun, 8 Jun 2014 17:45:35 +0300
To: OpenSIPS users mailling list <[email protected]
<mailto:[email protected]>>, Gordon Sims <[email protected]
<mailto:[email protected]>>
Subject: Re: [OpenSIPS-Users] Adding extra information into the acc
table based on dr_rules
Hi Gordon,
Instead of adding a new column to the dr_rules, I suggest to use the
"attrs" column of that table. It is not used by the actual routing
engine, its only purpose is to allow the user to attach custom data to
the rules. So add your ID into the attrs columns - when the rule is
match, the attrs value will be available into script into a variable
(see
http://www.opensips.org/html/docs/modules/1.11.x/drouting.html#id294716,
rule_attrs_pvar parameter).
Once you loaded into a variable, via db_extra you can push it to the
acc table.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 08.06.2014 15:35, Gordon Sims wrote:
First off, I would like to thank Razvan for my cdr accounting issue
and using db_extra. Was exactly what I was looking for.
Now I'm getting stumped on adding in extra information into the acc
table. I've added in another field to both my dr_rules and acc
tables called account_id (int 6). What I would like to do is when
the call comes in, based on the destination, is to take the
account_id information from the dr_rules table and insert that same
value into the acc table. I've looked at avpops module, but not
finding anything definitive that would do what I've looking for. I
hope I'm not the only one that is trying to do this. I'm looking for
a working example on how to accomplish this one.
Thanks in advance,
Gordon
_______________________________________________
Users mailing list
[email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
