[SR-Users] SIP Autentication Failed

Fri Mar 11 01:46:40 CET 2016

Hello,

I'm sorry, it was my fault, there was a view  subscriber in kamailio scheme
and also in the asterisk scheme.

Thank you!

--------------------------------------------

Bruno H. G. Gouvêa

CEO - CiberCloud LTDA
http://cibercloud.com.br
http://ligou.me

---
 Bruno H. G. Gouvêa

 Tel.: (31)99554646
---

2016-03-09 6:52 GMT-03:00 Daniel-Constantin Mierla <miconda at gmail.com>:

> Hello,
>
> do you have WITH_ASTERISK defined? If yes, is the asterisk database having
> a subscriber table where you keep the usernames and passwords?
>
> Cheers,
> Daniel
>
>
> On 09/03/16 09:09, Bruno Henrique Gomes Gouvêa wrote:
>
> Hello,
>
> Params here:
>
> # ----- auth_db params -----
> #!ifdef WITH_AUTH modparam("auth_db", "calculate_ha1", yes)
> modparam("auth_db", "load_credentials", "")
> #!ifdef WITH_ASTERISK
> # subscriber table is actually a view in DBASTURL
> modparam("auth_db", "use_domain", 1)
> modparam("auth_db", "db_url", DBASTURL)
> modparam("auth_db", "version_table", 0) #!else
> modparam("auth_db", "db_url", DBURL) modparam("auth_db",
> "password_column", "password") modparam("auth_db", "use_domain",
> MULTIDOMAIN)
> #!endif
>
> Call auth function:
>
> if (!auth_check("$fd", "subscriber", "0")) {
> auth_challenge("$fd", "0")
>
> Thank you
> Em 9 de mar de 2016 03:56, "Daniel-Constantin Mierla" <miconda at gmail.com>
> escreveu:
>
>> Hello,
>>
>> 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?
>>
>> Cheers,
>> Daniel
>>
>> On 08/03/16 20:33, Bruno Henrique Gomes Gouvêa wrote:
>>
>> Hello,
>>
>>
>> Record in subscriber table, i cant see any problem:
>>
>> +-----------------------------+---------------------+---------------+------+
>> | username                       | domain                   | ha1| ha1b |
>>
>> +-----------------------------+---------------------+---------------+------+
>> |101_pabx999999.ligou.me|pabx999999.ligou.me|xyz|NULL|
>>
>>
>> Thank you.
>>
>> --------------------------------------------
>>
>> Bruno H. G. Gouvêa
>>
>> CEO - CiberCloud LTDA
>> http://cibercloud.com.br
>> http://ligou.me
>>
>>
>> ---
>>  Bruno H. G. Gouvêa
>>
>>
>>  Tel.: (31)99554646
>> ---
>>
>>
>> 2016-03-08 12:36 GMT-03:00 Daniel-Constantin Mierla < <miconda at gmail.com>
>> miconda at gmail.com>:
>>
>>> Hello,
>>>
>>> On 08/03/16 09:27, Bruno Henrique Gomes Gouvêa wrote:
>>>
>>> Hello,
>>>
>>> Here new debug:
>>>
>>> Mar  8 03:25:10 p /usr/sbin/kamailio[1681]: ERROR: *** cfgtrace:
>>> c=[//etc/kamailio/kamailio.cfg] l=946 a=25 n=xlog
>>> Mar  8 03:25:10 p /usr/sbin/kamailio[1681]: ERROR: <script>: ====
>>> handling REGISTER (MmQwNzk0ZGFlNjhkYzRkNWY5ZjNhNTk3MGRjZTk2MzE.) for
>>> authorization: Digest username="101_pabx999999.ligou.me",realm="
>>> pabx999999.ligou.me",nonce="Vt6NklbejGavaQRaSAso12UuHhzekp65",uri="sip:
>>> pabx999999.ligou.me
>>> ;transport=UDP",response="09b0c6dbd9776505fd9592b224234033",algorithm=MD5
>>> Mar  8 03:25:10 p /usr/sbin/kamailio[1681]: ERROR: *** cfgtrace:
>>> c=[//etc/kamailio/kamailio.cfg] l=954 a=16 n=if
>>> Mar  8 03:25:10 p /usr/sbin/kamailio[1681]: ERROR: *** cfgtrace:
>>> c=[//etc/kamailio/kamailio.cfg] l=947 a=27 n=auth_check
>>> Mar  8 03:25:10 p /usr/sbin/kamailio[1681]: DEBUG: auth_db
>>> [authorize.c:486]: auth_check(): realm [pabx999999.ligou.me] table
>>> [subscriber] flags [0]
>>> Mar  8 03:25:10 p /usr/sbin/kamailio[1681]: DEBUG: auth [api.c:96]:
>>> pre_auth(): auth: digest-algo: MD5 parsed value: 1
>>> 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
>>> 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
>>> 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
>>> 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
>>> 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
>>> 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]
>>> 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
>>> Mar  8 03:25:10 p /usr/sbin/kamailio[1681]: DEBUG: auth_db
>>> [authorize.c:184]: get_ha1(): no result for user '
>>> 101_pabx999999.ligou.me at pabx999999.ligou.me'
>>>
>>>
>>> the last log message is now relevant, respectively:
>>>
>>> Mar  8 03:25:10 p /usr/sbin/kamailio[1681]: DEBUG: auth_db
>>> [authorize.c:184]: get_ha1(): no result for user '
>>> 101_pabx999999.ligou.me at pabx999999.ligou.me'
>>>
>>> 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)?
>>>
>>> Cheers,
>>> Daniel
>>>
>>> --
>>> Daniel-Constantin Mierlahttp://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>>> Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
>>>
>>>
>>
>> --
>> Daniel-Constantin Mierlahttp://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
>> Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
>>
>>
> --
> Daniel-Constantin Mierlahttp://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
> Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160310/4b1d6d7d/attachment.html>