<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body 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 class="moz-cite-prefix">On 08/03/16 20:33, Bruno Henrique Gomes
Gouvêa wrote:<br>
</div>
<blockquote
cite="mid:CAFBSE6suGEkouRK+Op5y83JsUxnaOeOF8h5-1ZR+P3Z_X7UOcQ@mail.gmail.com"
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
moz-do-not-send="true"
href="http://101_pabx999999.ligou.me/" target="_blank"
style="font-size:12.8px">101_pabx999999.ligou.me</a><span
style="font-size:12.8px">|</span><a moz-do-not-send="true"
href="http://pabx999999.ligou.me/" target="_blank"
style="font-size:12.8px">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 class="gmail_signature">
<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 moz-do-not-send="true"
href="http://cibercloud.com.br/"
style="color:rgb(17,85,204)" target="_blank">http://cibercloud.com.br</a></div>
<div><a moz-do-not-send="true" 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 moz-do-not-send="true"
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
moz-do-not-send="true" href="mailto:miconda@gmail.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:miconda@gmail.com">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 class=""><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
moz-do-not-send="true"
href="http://101_pabx999999.ligou.me"
target="_blank">101_pabx999999.ligou.me</a>",realm="<a
moz-do-not-send="true"
href="http://pabx999999.ligou.me"
target="_blank">pabx999999.ligou.me</a>",nonce="Vt6NklbejGavaQRaSAso12UuHhzekp65",uri="sip:<a
moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 class=""><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 moz-do-not-send="true"
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 moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><span class="">
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" 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 moz-do-not-send="true" href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
</div>
</blockquote>
</div>
<br>
</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>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>