Hi Jayesh, Jayesh Nambiar wrote: > Hi All, > Just an update to this post. > If I use my own sip_code column and add values in those column using > the PV $rs, it works good. I use a t_on_reply in the branch route and > store the response codes in a avp variable when the codes are 4XX or > 2XX. So when there are two attempts for a single call this avp stores > both response codes and inserts appropriate rows in the columns as > desired. There is no need to use an on_reply branch for accessing the reply codes - you can do it from failure route (when detecting the failure of the GW), via $([<reply>rs) (see http://www.opensips.org/Resources/DocsCoreVar16).
> Is there a way to just ask opensips to not enter the sip_code values > in the acc table?* *Because i do not want two columns indicating the > same thing. Or is there some way to let opensips know that sip_code > column is also part of multi_leg_info? So that it maintains the final > response code of each INVITE transaction to properly insert into the > acc table. The sip_code is part of the fix, hardcoded, mandatory part of the ACC set - you cannot take it out. Regards, Bogdan > > --- Jayesh > > > Hello, > I have a scenario: > Before routing a call to the PSTN, I fetch multiple IPs from DB in > a single > AVP, for eg. i fetch two IP addresses to which I need to forward > the calls > according to some LCR algorithm. I route the calls to specific IP > address > using the AVP indexes. If routing to first index value fails, I do a > failover to second one. Now here when the call on first IP address > fails and > it connects on second, I get two rows inserted in "ACC" table for > the INVITE > as I have multi-leg info enabled. Up till here everything is good. > The problem here is, the SIP Code column shows 200 on both rows. > Basically > the SIP code column always inserts the last response code in all > the rows. > Is there a way where I can segregate the SIP Codes. What I need is > the row > where call failed, the sip_code should be the failed response > code(403, 404, > 503 etc) as received and the row where call connected the sip_code > should be > 200. Is this doable? > > Is there a way I can use the PV $rs in some way and manipulate the > values in > sip_code column of acc based on call leg? > Any help is highly appreciated. Thanks in advance. > > --- Jayesh > > ------------------------------------------------------------------------ > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- Bogdan-Andrei Iancu OpenSIPS Bootcamp 15 - 19 November 2010, Edison, New Jersey, USA www.voice-system.ro _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
