<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
What version are you using?<br>
<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 09/12/13 12:17, jay binks wrote:<br>
</div>
<blockquote
cite="mid:CAO47HpcM_n=MBWUJikFEWjXMnayQOLsywR8kDgECnf7MGfHo3Q@mail.gmail.com"
type="cite">
<div dir="ltr"><br clear="all">
<div>So when Im trying to use is_subscriber & <span
style="color:rgb(0,0,0);font-family:Helvetica,Arial;font-size:12px;text-align:justify">load_credentials
together, It seems I have either hit a bug or just a bad
config ( but I dont think its the latter )</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Helvetica,Arial;font-size:12px;text-align:justify"><br>
</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Helvetica,Arial;font-size:12px;text-align:justify">My
symptom is that only the field on the far right of
"load_credentials" ever returns the correct value, the other
fields are always null.</span></div>
<div><span
style="color:rgb(0,0,0);font-family:Helvetica,Arial;font-size:12px;text-align:justify"><br>
</span></div>
<div><span
style="font-size:12.222222328186035px;color:rgb(0,0,0);font-family:Helvetica,Arial;text-align:justify">My
config has this setting :</span><br>
</div>
<div style="text-align:justify"><font color="#000000"
face="Helvetica, Arial"><span
style="font-size:12.222222328186035px"> modparam("auth_db",
"load_credentials", "field1;field2")</span></font></div>
<div style="text-align:justify"><font color="#000000"
face="Helvetica, Arial"><span
style="font-size:12.222222328186035px"><br>
</span></font></div>
<div style="text-align:justify"><font color="#000000"
face="Helvetica, Arial"><span
style="font-size:12.222222328186035px">and I can see the
following debug when running kamailio -ddddd</span></font></div>
<div><br>
</div>
<div>
<div> 0(14174) DEBUG: auth_db [authdb_mod.c:291]:
w_is_subscriber(): uri [sip: <a moz-do-not-send="true"
href="mailto:1112@192.168.173.5">1112@192.168.173.5</a>]
table [subscriber] flags [1]</div>
<div> 0(14174) DEBUG: db_cassandra [dbcassa_base.cpp:807]:
db_cassa_query(): query table=subscriber</div>
<div> 0(14174) DEBUG: db_cassandra [dbcassa_table.c:461]:
dbcassa_db_get_table(): found dbname=kamailio,
table=subscriber</div>
<div> 0(14174) DEBUG: db_cassandra [dbcassa_base.cpp:351]:
cassa_constr_key(): query col = username</div>
<div> 0(14174) DEBUG: db_cassandra [dbcassa_base.cpp:351]:
cassa_constr_key(): query col = domain</div>
<div> 0(14174) DEBUG: db_cassandra [dbcassa_base.cpp:376]:
cassa_constr_key(): key = 1112 192.168.173.5</div>
<div> 0(14174) DEBUG: db_cassandra [dbcassa_base.cpp:499]:
cassa_translate_query(): Query col: <span
style="color:rgb(0,0,0);font-family:Helvetica,Arial;font-size:12.222222328186035px;text-align:justify">field2</span></div>
<div> 0(14174) DEBUG: db_cassandra [dbcassa_base.cpp:499]:
cassa_translate_query(): Query col: <span
style="color:rgb(0,0,0);font-family:Helvetica,Arial;font-size:12.222222328186035px;text-align:justify">field1</span>;<span
style="color:rgb(0,0,0);font-family:Helvetica,Arial;font-size:12.222222328186035px;text-align:justify"> field2</span></div>
<div> 0(14174) DEBUG: db_cassandra [dbcassa_base.cpp:501]:
cassa_translate_query(): get 2 columns</div>
<div> 0(14174) DEBUG: <core> [db_res.c:118]:
db_new_result(): allocate 56 bytes for result set at
0x7fc6ce770e78</div>
</div>
<div><br>
</div>
<div>if I had to put money on where the bug is, I would look in <span
style="color:rgb(0,0,0);white-space:pre-wrap">parse_aaa_pvs
in </span><font color="#000000"><span
style="white-space:pre-wrap">authdb_mod.c </span></font></div>
<div><font color="#000000"><span style="white-space:pre-wrap">however,
an initial glance revealed nothing glaring, also this file
was last changed in </span></font><i
style="font-size:13px;color:rgb(0,0,0);font-family:sans-serif;background-color:rgb(246,246,240)">2013-01-20
( and that was only a move from modules_k )</i></div>
<div><br>
</div>
<div>SURELY I cant be the only person wanting to use this for
more than one field ?</div>
<div>This code looks like its almost the same as when first
committed in August 2011 ....</div>
<div><br>
</div>
<div>Id love someone to see if they can confirm this and point
me in the right direction ( if this is my fault ) or lets get
this fixed, if its a bug :)</div>
<div><br>
</div>
<div>-- </div>
Sincerely<br>
<br>
Jay
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" 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>
<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>