<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
value 1 must be without double quotes around it.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 28/04/14 20:55, arun Jayaprakash
wrote:<br>
</div>
<blockquote
cite="mid:1398711336.27464.YahooMailNeo@web161606.mail.bf1.yahoo.com"
type="cite">
<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 <a class="moz-txt-link-rfc2396E" href="mailto:miconda@gmail.com"><miconda@gmail.com></a><br>
<b><span style="font-weight: bold;">To:</span></b> arun
Jayaprakash <a class="moz-txt-link-rfc2396E" href="mailto:jayaprakasharun@yahoo.com"><jayaprakasharun@yahoo.com></a>; Kamailio
(SER) - Users Mailing List
<a class="moz-txt-link-rfc2396E" href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a> <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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" rel="nofollow" shape="rect" class="yiv8718817260moz-txt-link-freetext" target="_blank" href="http://www.asipto.com/">http://www.asipto.com</a>
<a moz-do-not-send="true" rel="nofollow" shape="rect" class="yiv8718817260moz-txt-link-freetext" target="_blank" href="http://twitter.com/#%21/miconda">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" 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>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>