11 Mar
2016
11 Mar
'16
1:46 a.m.
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(a)gmail.com>om>:
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(a)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(a)gmail.com>
miconda(a)gmail.com>gt;:
--
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
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(a)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(a)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