<p dir="ltr">Hello, </p>
<p dir="ltr">Params here:</p>
<p dir="ltr"># ----- auth_db params ----- <br>
#!ifdef WITH_AUTH modparam("auth_db", "calculate_ha1", yes) <br>
modparam("auth_db", "load_credentials", "") <br>
#!ifdef WITH_ASTERISK <br>
# subscriber table is actually a view in DBASTURL<br>
modparam("auth_db", "use_domain", 1) <br>
modparam("auth_db", "db_url", DBASTURL) <br>
modparam("auth_db", "version_table", 0) #!else <br>
modparam("auth_db", "db_url", DBURL) modparam("auth_db", "password_column", "password") modparam("auth_db", "use_domain", MULTIDOMAIN) <br>
#!endif</p>
<p dir="ltr">Call auth function:</p>
<p dir="ltr">if (!auth_check("$fd", "subscriber", "0")) { <br>
auth_challenge("$fd", "0")</p>
<p dir="ltr">Thank you</p>
<div class="gmail_quote">Em 9 de mar de 2016 03:56, "Daniel-Constantin Mierla" <<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>> escreveu:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
apparently it is ok in database table -- can you send here the
modparams for auth_db module and the piece of config how you execute
the auth_check() function?<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div>On 08/03/16 20:33, Bruno Henrique Gomes
Gouvêa wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div style="font-size:12.8px">Hello,</div>
<div style="font-size:12.8px"><br>
</div>
<div style="font-size:12.8px"><br>
</div>
<div style="font-size:12.8px">Record in subscriber table, i cant
see any problem:</div>
<div style="font-size:12.8px">+-----------------------------+---------------------+---------------+------+</div>
<div style="font-size:12.8px">| username |
domain | ha1| ha1b |</div>
<div style="font-size:12.8px">+-----------------------------+---------------------+---------------+------+</div>
<div style="font-size:12.8px"><span style="font-size:12.8px">|</span><a href="http://101_pabx999999.ligou.me/" style="font-size:12.8px" target="_blank">101_pabx999999.ligou.me</a><span style="font-size:12.8px">|</span><a href="http://pabx999999.ligou.me/" style="font-size:12.8px" target="_blank">pabx999999.ligou.me</a><span style="font-size:12.8px">|</span><span style="font-size:12.8px">xyz</span><span style="font-size:12.8px">|NULL|</span><br>
</div>
<div style="font-size:12.8px"><span style="font-size:12.8px"><br>
</span></div>
<div style="font-size:12.8px"><span style="font-size:12.8px"><br>
</span></div>
<div style="font-size:12.8px"><span style="font-size:12.8px">Thank
you.</span></div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div>
<div dir="ltr">
<div>
<div dir="ltr" style="font-size:12.8000001907349px">
<div>--------------------------------------------</div>
<div><br>
</div>
<div>Bruno H. G. Gouvêa</div>
<div><br>
</div>
<div>CEO - CiberCloud LTDA</div>
<div><a href="http://cibercloud.com.br/" style="color:rgb(17,85,204)" target="_blank">http://cibercloud.com.br</a></div>
<div><a href="http://ligou.me/" style="color:rgb(17,85,204)" target="_blank">http://ligou.me</a><br>
</div>
<div><br>
</div>
</div>
<div style="font-size:12.8000001907349px"><br clear="all">
<div>--- <br>
Bruno H. G. Gouvêa<br>
<br>
<br>
Tel.: <a href="tel:%2831%2999554646" value="+553199554646" style="color:rgb(17,85,204)" target="_blank">(31)99554646</a><br>
---</div>
</div>
<br>
</div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">2016-03-08 12:36 GMT-03:00
Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank"><a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a></a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Hello,<span><br>
<br>
<div>On 08/03/16 09:27, Bruno Henrique Gomes Gouvêa
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hello,
<div><br>
</div>
<div>Here new debug:</div>
<div><br>
</div>
<div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
ERROR: *** cfgtrace:
c=[//etc/kamailio/kamailio.cfg] l=946 a=25
n=xlog</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
ERROR: <script>: ==== handling REGISTER
(MmQwNzk0ZGFlNjhkYzRkNWY5ZjNhNTk3MGRjZTk2MzE.)
for authorization: Digest username="<a href="http://101_pabx999999.ligou.me" target="_blank">101_pabx999999.ligou.me</a>",realm="<a href="http://pabx999999.ligou.me" target="_blank">pabx999999.ligou.me</a>",nonce="Vt6NklbejGavaQRaSAso12UuHhzekp65",uri="sip:<a href="http://pabx999999.ligou.me" target="_blank">pabx999999.ligou.me</a>;transport=UDP",response="09b0c6dbd9776505fd9592b224234033",algorithm=MD5</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
ERROR: *** cfgtrace:
c=[//etc/kamailio/kamailio.cfg] l=954 a=16 n=if</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
ERROR: *** cfgtrace:
c=[//etc/kamailio/kamailio.cfg] l=947 a=27
n=auth_check</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: auth_db [authorize.c:486]: auth_check():
realm [<a href="http://pabx999999.ligou.me" target="_blank">pabx999999.ligou.me</a>] table
[subscriber] flags [0]</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: auth [api.c:96]: pre_auth(): auth:
digest-algo: MD5 parsed value: 1</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: <core> [db_res.c:118]:
db_new_result(): allocate 56 bytes for result
set at 0x7fa80fa86148</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: db_unixodbc [res.c:63]:
db_unixodbc_get_columns(): 1 columns returned
from the query</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: <core> [db_res.c:155]:
db_allocate_columns(): allocate 8 bytes for
result names at 0x7fa80fa730a0</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: <core> [db_res.c:165]:
db_allocate_columns(): allocate 4 bytes for
result types at 0x7fa80fa72de8</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: db_unixodbc [res.c:80]:
db_unixodbc_get_columns(): allocate 16 bytes for
RES_NAMES[0] at 0x7fa80fa84400</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: db_unixodbc [res.c:100]:
db_unixodbc_get_columns():
RES_NAMES(0x7fa80fa84400)[0]=[ha1]</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: db_unixodbc [res.c:139]:
db_unixodbc_get_columns(): use DB1_STRING result
type</div>
<div>Mar 8 03:25:10 p /usr/sbin/kamailio[1681]:
DEBUG: auth_db [authorize.c:184]: get_ha1(): no
result for user '<a href="mailto:101_pabx999999.ligou.me@pabx999999.ligou.me" target="_blank">101_pabx999999.ligou.me@pabx999999.ligou.me</a>'</div>
</div>
</div>
</blockquote>
<br>
</span> the last log message is now relevant,
respectively:<span><br>
<br>
Mar 8 03:25:10 p /usr/sbin/kamailio[1681]: DEBUG:
auth_db [authorize.c:184]: get_ha1(): no result for user
'<a href="mailto:101_pabx999999.ligou.me@pabx999999.ligou.me" target="_blank">101_pabx999999.ligou.me@pabx999999.ligou.me</a>'<br>
<br>
</span> Meaning that the record for that user was not
found in subscriber table. Can you share the record in
subscriber table for this user (replace the password
fields with xyz)?<br>
<br>
Cheers,<br>
Daniel<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><span>
<a href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a></span>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
</div>
</blockquote></div>