<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><span>Hello Daniel, </span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span>When I set the use_domain parameter </span></div><div style="background-color: transparent;"><br></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;">modparam("avpops","domain_column","domain")</div><div style="background-color:
transparent;"><span></span></div><div style="background-color: transparent;">modparam("avpops","use_domain","1")</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span>I get the following error:</span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="background-color: transparent;"> ERROR: <core> [modparam.c:152]: set_mod_param_regex(): set_mod_param_regex: parameter <use_domain> of type <1> not found in module <avpops></div><div style="background-color:
transparent;"><span></span></div><div style="background-color: transparent;">Apr 28 18:45:48 ip-172-10-30-4 kamailio: : <core> [cfg.y:3570]: yyerror_at(): parse error in config file /usr/local/etc/kamailio//kamailio.cfg, line 510, column 35: Can't set module parameter</div><div style="background-color: transparent;"><br></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;">Can you let me know what needs to be done, thank you.</div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;"><br></div><div style="background-color: transparent; color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; font-style: normal;">Arun</div><div style="font-family: 'times new roman', 'new york', times, serif;
font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <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> Daniel-Constantin Mierla <miconda@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> arun Jayaprakash <jayaprakasharun@yahoo.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Monday, April 28, 2014 3:29 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [SR-Users] avp_db_load() & fetch attribute ....<br> </font> </div> <div
class="y_msg_container"><br><div id="yiv8718817260"><div>
Hello,<br clear="none">
<br clear="none">
have you set use_domain parameter?<br clear="none">
<br clear="none">
<a rel="nofollow" shape="rect" class="yiv8718817260moz-txt-link-freetext" target="_blank" href="http://kamailio.org/docs/modules/stable/modules/avpops.html#avpops.p.use_domain">http://kamailio.org/docs/modules/stable/modules/avpops.html#avpops.p.use_domain</a><br clear="none">
<br clear="none">
Then you can use the '/uri' flag for first parameter of
avp_db_load().<br clear="none">
<br clear="none">
Cheers,<br clear="none">
Daniel<br clear="none">
<br clear="none">
<div class="yiv8718817260yqt5059307068" id="yiv8718817260yqt53585"><div class="yiv8718817260moz-cite-prefix">On 28/04/14 00:12, arun Jayaprakash
wrote:<br clear="none">
</div>
<blockquote type="cite">
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;">
<div>Can someone let me know how I can fetch an attribute
depending on the value of two columns. For eg, in my
usr_preference table I have 3 columns; </div>
<div><br clear="none">
</div>
<div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;">username, domain,
attribute. </div>
<div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><br clear="none">
</div>
<div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;">I need to fetch the
attribute if the username = $ru and domain= $rd. Can someone
let me know how this can be done, thanks.</div>
<div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><br clear="none">
</div>
<div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;">Arun</div>
</div>
<br clear="none">
<fieldset class="yiv8718817260mimeAttachmentHeader"></fieldset>
<br clear="none">
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a rel="nofollow" shape="rect" class="yiv8718817260moz-txt-link-abbreviated" ymailto="mailto:sr-users@lists.sip-router.org" target="_blank" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a rel="nofollow" shape="rect" class="yiv8718817260moz-txt-link-freetext" target="_blank" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote></div>
<br clear="none">
<pre class="yiv8718817260moz-signature">--
Daniel-Constantin Mierla - <a rel="nofollow" shape="rect" class="yiv8718817260moz-txt-link-freetext" target="_blank" href="http://www.asipto.com/">http://www.asipto.com</a>
<a rel="nofollow" shape="rect" class="yiv8718817260moz-txt-link-freetext" target="_blank" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a rel="nofollow" shape="rect" class="yiv8718817260moz-txt-link-freetext" target="_blank" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</div></div><br><br></div> </div> </div> </div></body></html>