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 > [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
