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@voice-system.ro To: Douglas Garstang dougmig33@yahoo.com Cc: users@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@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
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@voice-system.ro To: Douglas Garstang dougmig33@yahoo.com Cc: users@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@lists.openser.org mailto:Users@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
-
Daniel-Constantin Mierla -
Douglas Garstang