[OpenSIPS-Users] Adding extra information into the acc table based on dr_rules

[Gordon Sims]

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:p4ssw0rd@10.0.9.23/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 <bogdan at opensips.org>
Reply-To:  OpenSIPS users mailling list <users at lists.opensips.org>
Date:  Sun, 8 Jun 2014 17:45:35 +0300
To:  OpenSIPS users mailling list <users at lists.opensips.org>, Gordon Sims
<gsims94 at gmail.com>
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
> Users at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/use
> rs
>  
 
 
_______________________________________________ Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140608/4169d9f4/attachment-0001.htm>