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.
Douglas.
----- Original Message ---- From: Daniel-Constantin Mierla daniel@voice-system.ro To: Douglas Garstang dougmig33@yahoo.com Cc: users@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
I am specifying the table in the query, I don't understand why that's
the
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.
------------------------------------------------------------------------
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Douglas Garstang wrote:
You'd have to patch the openser source code in order to write avps in the reply route. Since version 1.2, there is a TM parameter for that:
modparam("tm", "onreply_avp_mode", 1)
as described in
http://www.openser.org/docs/modules/1.3.x/tm.html#AEN304
/Christian
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: