<html><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:10pt"><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt;"><span>Hi,</span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 13px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 13px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span>I'm using the xhttp_pi module to query the kamailio user registration table "location". Per the defined clause_cols operators in the module, it doesn't seem possible to achieve a query equivalent to a SQL "contains" or "like".</span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 13px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span>An exact match is required to query
the record; e.g., </span><span style="font-size: 13px; background-color: transparent;">http://xxxxxxx/location/QueryContacts?cmd=on&0=sip:8675309@a.b.c.d:5060;transport=udp. Is my understanding correct that there is no way to match on an regular expression? My end goal is to be able to query for a user's AOR and expiration status based on a search string (e.g. 8675309) via a webservice. Can anyone share a better method to do this? Perhaps </span>asynchronously? All<span style="background-color: transparent;"> feedback is appreciated. </span></div><div style="background-color: transparent;"><br></div><div style="font-size: 13px; background-color: transparent;">Sample contact field:</div><div style="font-size: 13px; background-color: transparent;"><span></span></div><div style="background-color: transparent;"><font size="2">sip:8675309@a.b.c.d:5060;transport=udp</font></div><div style="font-family: verdana, helvetica, sans-serif;
font-size: 13px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 13px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span>Sample Framework:</span></div><div style="background-color: transparent;"><font size="2"><cmd><cmd_name>QueryContacts</cmd_name></font></div><div style="background-color: transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span><db_table_id>location</db_table_id></font></div><div style="background-color: transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span><cmd_type>DB1_QUERY</cmd_type></font></div><div style="background-color: transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span><clause_cols></font></div><div style="background-color:
transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span><col><field>contact</field><operator>=</operator></col></font></div><div style="background-color: transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span></clause_cols></font></div><div style="background-color: transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span><query_cols></font></div><div style="background-color: transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span><col><field>username</field></col></font></div><div style="background-color: transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span><col><field>contact</field></col></font></div><div style="background-color: transparent;"><font size="2"><span
class="Apple-tab-span" style="white-space:pre"> </span><col><field>expires</field></col></font></div><div style="background-color: transparent;"><font size="2"><span class="Apple-tab-span" style="white-space:pre"> </span></query_cols></font></div><div style="background-color: transparent;"><font size="2"><span></span></font></div><div style="background-color: transparent;"><font size="2"></cmd></font></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt;"><br></div><div style="font-family: verdana, helvetica, sans-serif; font-size: 13px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">Thanks,</div><div style="font-family: verdana, helvetica, sans-serif; font-size: 13px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">Simpson</div><div style="background-color: transparent;"><br></div> <div style="font-family: verdana, helvetica, sans-serif;
font-size: 10pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> "sr-users-request@lists.sip-router.org" <sr-users-request@lists.sip-router.org><br> <b><span style="font-weight: bold;">To:</span></b> sr-users@lists.sip-router.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, June 27, 2013 5:00 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> sr-users Digest, Vol 97, Issue 104<br> </font> </div> <div class="y_msg_container"><br>Send sr-users mailing list submissions to<br> <a ymailto="mailto:sr-users@lists.sip-router.org" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>or, via email, send a message with subject or body 'help' to<br> <a ymailto="mailto:sr-users-request@lists.sip-router.org" href="mailto:sr-users-request@lists.sip-router.org">sr-users-request@lists.sip-router.org</a><br><br>You can reach the person managing the list at<br> <a ymailto="mailto:sr-users-owner@lists.sip-router.org" href="mailto:sr-users-owner@lists.sip-router.org">sr-users-owner@lists.sip-router.org</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of sr-users digest..."<br><br><br>Today's Topics:<br><br> 1. kamailio loadbalancer with TLS problem forwarding INVITE back<br> to UA (Allen Zhang)<br> 2. Re: dialplan not working (Victor V.
Kustov)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Thu, 27 Jun 2013 00:34:00 +0000<br>From: Allen Zhang <<a ymailto="mailto:Allen.Zhang@imgtec.com" href="mailto:Allen.Zhang@imgtec.com">Allen.Zhang@imgtec.com</a>><br>To: "<a ymailto="mailto:sr-users@lists.sip-router.org" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>" <<a ymailto="mailto:sr-users@lists.sip-router.org" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>><br>Cc: Shane Harrison <<a ymailto="mailto:Shane.Harrison@imgtec.com" href="mailto:Shane.Harrison@imgtec.com">Shane.Harrison@imgtec.com</a>><br>Subject: [SR-Users] kamailio loadbalancer with TLS problem forwarding<br> INVITE back to UA<br>Message-ID:<br> <<a ymailto="mailto:04588C075527D74CABD19E7C320BCB1C013BE6F6@WEMAIL01.we.imgtec.org"
href="mailto:04588C075527D74CABD19E7C320BCB1C013BE6F6@WEMAIL01.we.imgtec.org">04588C075527D74CABD19E7C320BCB1C013BE6F6@WEMAIL01.we.imgtec.org</a>><br>Content-Type: text/plain; charset="us-ascii"<br><br>Hi,<br><br>Our set up:<br><br>UA1 ----- ------ Proxy1<br> \ /<br> Loadbalancer (dispatcher
module)<br> / \<br>UA2----- ------ Proxy2<br><br>Both proxies have registrar module loaded and share the same database.<br>REGISTERs work fine.<br>The problem is this:<br> TLS
TCP<br>UA1 ----------------------> LB --------------------> Proxy<br> INVITE(to UA2) INVITE(to UA2)<br><br> TLS TCP<br>UA1 <------------- LB <------------- Proxy<br> 100 Trying<br><br> TLS TCP<br>UA1 <------------- LB <----------------------- Proxy<br>
INVITE(to UA2)<br><br> TLS TCP<br>UA1 <----------------------- LB <----------------------- Proxy<br> 100 Trying<br><br>All above worked fine. Below is what's expected but never happened:<br><br> TLS TCP<br>UA2 <----------------------- LB <----------------------- Proxy<br> INVITE(to
UA2)<br><br>We'd like the LB to reuse the TLS connection initiated by UA2. But LB can't find an open connection and tries to start a new TLS connection. The new connection fails.<br>UAs are not behind NAT at the moment but will be in the future.<br><br>Tried this approaches on LB:<br><br>route(ADD_CONTACT_ALIAS);<br>If (not from proxy)<br> t_relay();<br>else<br> do load balancing<br><br>No luck.<br><br>Any help is appreciated.<br><br>Regards,<br><br>Allen<br><br><br><br><br><br><br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.sip-router.org/pipermail/sr-users/attachments/20130627/a7a97d93/attachment-0001.html"
target="_blank">http://lists.sip-router.org/pipermail/sr-users/attachments/20130627/a7a97d93/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 2<br>Date: Thu, 27 Jun 2013 13:39:41 +0400<br>From: "Victor V. Kustov" <<a ymailto="mailto:coyote@bks.tv" href="mailto:coyote@bks.tv">coyote@bks.tv</a>><br>To: "Kamailio \(SER\) - Users Mailing List"<br> <<a ymailto="mailto:sr-users@lists.sip-router.org" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>><br>Subject: Re: [SR-Users] dialplan not working<br>Message-ID: <<a ymailto="mailto:20130627133941.7ae9b458@bkstv" href="mailto:20130627133941.7ae9b458@bkstv">20130627133941.7ae9b458@bkstv</a>><br>Content-Type: text/plain; charset=US-ASCII<br><br>Hi all!<br><br>I don't see in a doc, but mi dp_translate work correctly this way:<br><br>incorrect:<br><br>>kamcmd> mi dp_translate 1
9999999999<br><br>correct:<br><br>kamcmd> mi dp_translate 1 s:9999999999<br><br>seems need change documentation <br><br><br>--<br> WBR, Victor<br> JID: <a ymailto="mailto:coyote@bks.tv" href="mailto:coyote@bks.tv">coyote@bks.tv</a><br> JID: <a ymailto="mailto:coyote@bryansktel.ru" href="mailto:coyote@bryansktel.ru">coyote@bryansktel.ru</a><br> I use FREE operation system: 3.9.6-calculate GNU/Linux<br><br><br><br>------------------------------<br><br>_______________________________________________<br>sr-users mailing list<br><a ymailto="mailto:sr-users@lists.sip-router.org" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br><br><br>End of sr-users Digest, Vol 97, Issue 104<br>*****************************************<br><br><br></div> </div> </div>
</div></body></html>