<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div style="RIGHT: auto"><SPAN style="RIGHT: auto">Hi Bogdan,</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">Thanks a lot for the tip , so I'll straigt away do a avp_query instead of calling check_from / check_to() ? , yea I saw the query in the debug,</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">Just wondering if it'll be hitting db badly. Anyway I'll go with this approach and come back with my performance stats. <VAR id=yui-ie-cursor></VAR></SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">Thanks again ! :)</SPAN></div>
<div><BR></div>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 10pt">
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV dir=ltr><FONT size=2 face=Arial>
<DIV style="BORDER-BOTTOM: #ccc 1px solid; BORDER-LEFT: #ccc 1px solid; PADDING-BOTTOM: 0px; LINE-HEIGHT: 0; MARGIN: 5px 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; HEIGHT: 0px; FONT-SIZE: 0px; BORDER-TOP: #ccc 1px solid; BORDER-RIGHT: #ccc 1px solid; PADDING-TOP: 0px" class=hr contentEditable=false readonly="true"></DIV><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Bogdan-Andrei Iancu <bogdan@opensips.org><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Pasan Meemaduma <pasandev@ymail.com>; OpenSIPS users mailling list <users@lists.opensips.org> <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Friday, 9 March 2012, 23:03<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [OpenSIPS-Users] can realm change before calling check_from() /check_to() with uri table ?<BR></FONT></DIV><BR>
<DIV id=yiv1290078809>
<DIV>Hi Pasan,<BR><BR>There is no way to disable the domain checking when using this function. A simpler approach will be to perform a raw query directly from the script (anyway the module is doing one) :<BR> avp_db_query("select username from uri where username=$au and uri_user=$fu", "$avp(uri) );<BR> if ($rc<0) { does not exist }<BR><BR>Regards,<BR>Bogdan<BR><BR>On 03/08/2012 01:17 PM, Pasan Meemaduma wrote:
<BLOCKQUOTE type="cite">
<DIV style="BACKGROUND-COLOR: rgb(255,255,255); FONT-FAMILY: times new roman, new york, times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 10pt">
<DIV><SPAN class=yiv1290078809tab></SPAN>Hi Guys,</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>I'm just stuck in with something with uri table. <BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>I have different DNS entries and people use server IP as well therefore I have to have duplicate entries in uri table if I need</DIV>
<DIV>to alias `From` user. This increase db load . <BR></DIV>
<DIV><BR></DIV>
<DIV>Is there way that we can turn off realm checking in check_from () when modparam("uri_db", "use_uri_table", 1) ?</DIV>
<DIV><BR></DIV>
<DIV>Or else is there a way I can replace realm part of a Digest Header to a common string so that I can have single entry in uri table ?<BR></DIV>
<DIV><BR></DIV>
<DIV>If I don't have both entires as below , If the Customer uses IP or DNS the check_from check_to fail :(</DIV>
<DIV><BR></DIV>+----+----------+---------------+----------+---------------------+<BR>
<DIV>| id | username | domain | uri_user | last_modified |<BR>+----+----------+---------------+----------+---------------------+<BR>| 1 | 1001 | 192.168.102.5 | 1001 | 2012-01-09 17:21:42 |<BR>| 4 | 1001 | voip.somewhere.com | 1001 | 2012-01-09 17:36:32 |<BR>+----+----------+---------------+----------+---------------------+<BR></DIV>
<DIV><BR></DIV>
<DIV>I tried using replace_all(re,txt) but it didn't work.</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>any suggestions would be appreciated</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>Regards,</DIV>
<DIV>Pasan<BR></DIV></DIV><PRE><FIELDSET class=yiv1290078809mimeAttachmentHeader></FIELDSET>
_______________________________________________
Users mailing list
<A class=yiv1290078809moz-txt-link-abbreviated href="mailto:Users@lists.opensips.org" rel=nofollow target=_blank ymailto="mailto:Users@lists.opensips.org">Users@lists.opensips.org</A>
<A class=yiv1290078809moz-txt-link-freetext href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel=nofollow target=_blank>http://lists.opensips.org/cgi-bin/mailman/listinfo/users</A>
</PRE></BLOCKQUOTE><BR><BR><PRE class=yiv1290078809moz-signature>--
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<A class=yiv1290078809moz-txt-link-freetext href="http://www.opensips-solutions.com/" rel=nofollow target=_blank>http://www.opensips-solutions.com</A></PRE></DIV></DIV><BR><BR></DIV></DIV></div></body></html>