[SR-Users] SIP Autentication Failed

[Bruno Henrique Gomes Gouvêa]

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>:
>
>> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160309/eefa9bd9/attachment.html>