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

8 Nov 2007

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 &lt;daniel(a)voice-system.ro&gt;
To: Douglas Garstang &lt;dougmig33(a)yahoo.com&gt;
Cc: users(a)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.

 __________________________________________________
 Do You Yahoo!?
 Tired of spam? Yahoo! Mail has the best spam protection around
 http://mail.yahoo.com
  ------------------------------------------------------------------------
...

 _______________________________________________
 Users mailing list
 Users(a)lists.openser.org
 http://lists.openser.org/cgi-bin/mailman/listinfo/users

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 