Hello Khaled, Yes, the ACC will generate the cdr record after the local route triggering.
But if you want to push some additional info to the CDR, I advice you to use the extra_db accounting (see http://www.opensips.org/html/docs/modules/1.9.x/acc.html#ACC-extra-id) for the PDD value. Best regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 06/12/2013 06:26 PM, M.Khaled W Chehab wrote: > > Hello Bogdan, > > > > I am using cdr flag and I think that what is causing this problem, > since the update is done before the acc module insert the record. > > And I don't want to use acc start/stop ,is there a way to set a delay > timer after acc_db_request("200 Dialog Timeout", "acc"); > > Or let the acc module insert the invite when call is connected ( 200 ok ) > > > > > > Regards > > > > > > *From:*Bogdan-Andrei Iancu [mailto:[email protected]] > *Sent:* Wednesday, June 12, 2013 1:19 PM > *To:* OpenSIPS users mailling list > *Cc:* M.Khaled W Chehab > *Subject:* Re: [OpenSIPS-Users] AVP on local route > > > > 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] <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
