<div dir="ltr">Hello,<div><br></div><div><br></div><div>I'm sorry, it was my fault, there was a view subscriber in kamailio scheme and also in the asterisk scheme.<br></div><div><br></div><div>Thank you!</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 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-09 6:52 GMT-03:00 Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</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,<br>
<br>
do you have WITH_ASTERISK defined? If yes, is the asterisk database
having a subscriber table where you keep the usernames and
passwords?<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 09/03/16 09:09, Bruno Henrique Gomes
Gouvêa wrote:<br>
</div>
<blockquote type="cite">
<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" target="_blank">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><a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</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/#%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>
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>
</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></div></div>
</blockquote></div><br></div>