9 Mar
2016
9 Mar
'16
4:52 a.m.
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@gmail.com mailto:miconda@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 <http://101_pabx999999.ligou.me/>|pabx999999.ligou.me <http://pabx999999.ligou.me/>|xyz|NULL| Thank you. -------------------------------------------- Bruno H. G. Gouvêa CEO - CiberCloud LTDA http://cibercloud.com.br <http://cibercloud.com.br/> http://ligou.me <http://ligou.me/> --- Bruno H. G. Gouvêa Tel.: (31)99554646 <tel:%2831%2999554646> --- 2016-03-08 12:36 GMT-03:00 Daniel-Constantin Mierla <miconda@gmail.com <mailto:miconda@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 <http://101_pabx999999.ligou.me>",realm="pabx999999.ligou.me <http://pabx999999.ligou.me>",nonce="Vt6NklbejGavaQRaSAso12UuHhzekp65",uri="sip:pabx999999.ligou.me <http://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 <http://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@pabx999999.ligou.me <mailto:101_pabx999999.ligou.me@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@pabx999999.ligou.me <mailto:101_pabx999999.ligou.me@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 Mierla http://www.asipto.comhttp://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com-- Daniel-Constantin Mierla http://www.asipto.com http://twitter.com/#!/miconda <http://twitter.com/#%21/miconda> - http://www.linkedin.com/in/miconda Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com
--
Daniel-Constantin Mierla
http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com