[OpenSIPS-Users] AVP on local route

[Bogdan-Andrei Iancu]

Hello Khaled,

What kind of accounting are you using in script ? Based on CDR flag ?
Based on ACC flag (start/stop) ? or manual accounting (with functions) ?

Maybe the record you are trying to update in local route does not exist
in ACC table yet (depending on the accounting method you are using).

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com


On 06/03/2013 02:27 PM, M.Khaled W Chehab wrote:
>
> Hi,
>
>  
>
> The   execution for the avp_db_query is not working fine  in local
> route after the  acc_db_request  ,
>
>  
>
> As I print the query using xlog(" and   insert t it to myql ,the query
> executed normally which means I have no problem in the mysql query  .
>
>  
>
> My question: how can update the record in the acc table  after
> acc_db_request("200 Dialog Timeout", "
>
>  
>
>  
>
> local_route {
>
>             if (is_method("BYE")  && $DLG_dir=="UPSTREAM") {
>
>                          xlog("L_INFO", "--Debug Customer
> ID:$avp(Cusid)/IP:$si---------Reply:
> $T_reply_code------Source:$rd\nDialed:$fU\n:");
>
>  
>
>                         acc_db_request("200 Dialog Timeout", "acc");
>
>  
>
> avp_db_query("UPDATE `opensips`.`acc` SET `pdd`='$var(pdd)' WHERE
> `CALLID` ='$ci' and `method`='INVITE'" );
>
>  
>
>  
>
> BTW: I cant find the acc record for the call unless  the call  ended
> ,and in my case I set the  acc_db_request("200 Dialog Timeout  then
> call avp_db_query(   is  that should insert the call in the acc to
> update it later
>
>  
>
> Regards
>
> ,.
>
>  
>
>
> _______________________________________________
> 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/20130612/34c6bb8e/attachment.htm>