[OpenSER-Users] Storing SIP Response Codes with avpops?

Daniel-Constantin Mierla daniel at voice-system.ro
Fri Nov 9 11:39:05 CET 2007


On 11/09/07 10:24, Bogdan-Andrei Iancu wrote:
> Hi Douglas,
>
> $rs is not available in failure route - this PV points to some info 
> specific to a reply, but in failure route you are processing a requests.
>
> If you want to get the code of the reply that triggered the failure 
> route, use the PV exported by TM "T_reply_code":
>    http://www.openser.org/docs/modules/1.2.x/tm.html#AEN539
>
> regards,
> bogdan
>
> Douglas Garstang wrote:
>> Daniel,
>>
>> I found that I was able to do this, and openser accepts it, and 
>> inserts a database record...
>> avp_db_query("insert into sip_responses (response_code, 
>> response_reason) values ('$rs','abc')");
>>
>> That is in a failure block. However, in the failure block, $rs is 0. 
>> I tried putting the avp_db_query into the reply block, and openser 
>> tells me that avp_db_query isn't allowed in the reply block, SO I 
>> then tried putting this:
>>
>> avp_write("$rs","$avp(result)");
>>
>> into the reply block, and openser tells me that avp_write can't be 
>> used in a reply block.
>>
>> Argh!
>>
>> I just want to get a sip response code for the call and put it into 
>> the database.
>>
>> I'm using version 1.1.
You have to use at least 1.2 to get access to above features, 1.1 is 
quite old by now, and flexibility you want was added in more recent 
releases.

Daniel



>>
>> Douglas.
>>
>>
>> ----- Original Message ----
>> From: Daniel-Constantin Mierla <daniel at voice-system.ro>
>> To: Douglas Garstang <dougmig33 at yahoo.com>
>> Cc: users at lists.openser.org
>> Sent: Thursday, November 8, 2007 1:30:50 PM
>> Subject: Re: [OpenSER-Users] Storing SIP Response Codes with avpops?
>>
>> What version are you using? I just tested with trunk version and all ok?
>>
>> For the other issue, just set:
>> modparam("avpops", "avp_table", "usr_preferences")
>>
>> Daniel
>>
>>
>> On 11/08/07 23:20, Douglas Garstang wrote:
>> > Thanks, but when I try that, I get the following error from openser:
>> >
>> > Nov  7 23:17:32 localhost openser[7035]: ERROR:xl_parse_spec: bad pvar
>> > name "rr{s.escape.common})') "
>> > Nov  7 23:17:32 localhost openser[7035]:
>> > ERROR:avpops:fixup_db_query_avp: wrong format[insert into
>> > sip_responses (response_code, response_reason) values ('$rs',
>> > '$(rr{s.escape.common})') ]
>> > Nov  7 23:17:32 localhost openser[7035]: ERROR: fix_actions: fixing
>> > failed (code=-1) at cfg line 139
>> >
>> > OpenSER also complains that i need to specify an avp table, but since
>> > I am specifying the table in the query, I don't understand why that's
>> > required.
>> >
>> > Douglas.
>> >
>> >
>> > ----- Original Message ----
>> > From: Daniel-Constantin Mierla <daniel at voice-system.ro 
>> <mailto:daniel at voice-system.ro>>
>> > To: Douglas Garstang <dougmig33 at yahoo.com 
>> <mailto:dougmig33 at yahoo.com>>
>> > Cc: users at lists.openser.org <mailto:users at lists.openser.org>
>> > Sent: Thursday, November 8, 2007 11:57:35 AM
>> > Subject: Re: [OpenSER-Users] Storing SIP Response Codes with avpops?
>> >
>> > Hello,
>> >
>> > On 11/08/07 21:40, Douglas Garstang wrote:
>> > > All,
>> > >
>> > > I'd like to store SIP response codes in mysql using avpops. Is this
>> > > possible?
>> > >
>> > > I tried to do this a few years ago and couldn't find any
>> > > documentation. Unfortunately, I still can't find any.
>> > >
>> > > Can someone post an example? All I can find online is reference
>> > > documentation for avpops.
>> > >
>> > > I'd really like to see a full example with the modparams defining 
>> the
>> > > table structure, and how I would use avp_write and avp_db_store to
>> > > write the $rr response code.
>> > the easiest way is to use avp_db_query(), you can give as parameter 
>> any
>> > sql query. In your case, you can use in onreply_route:
>> >
>> > avp_db_query("insert into sip_responses (response_code, 
>> response_reason)
>> > values ('$rs', '$(rr{s.escape.common})') ");
>> >
>> > You need to create the table sip_responses, with the two string 
>> columns.
>> >
>> > Daniel
>> >
>> > >
>> > > Thanks.
>> > > Douglas.
>> > >
>
>




More information about the Users mailing list