[SR-Users] dbtext why is my user not recognised

[jaflong jaflong]

I started agian using

cd /usr/local/sbin/
./kamdbctl create


then

cd /usr/local/sbin/
./kamctrl
add user1 user1


 1(11480) DEBUG: db_text [dbt_lib.c:289]: dbt_db_get_table(): cache or mtime succeeded for [subscriber]
 1(11480) DEBUG: db_text [dbt_base.c:232]: dbt_query(): new res with 1 cols
 1(11480) DEBUG: db_text [dbt_res.c:69]: dbt_result_new(): new res with 1 cols
 1(11480) DEBUG: <core> [db_res.c:118]: db_new_result(): allocate 56 bytes for result set at 0x7f5691274ef8
 1(11480) DEBUG: <core> [db_res.c:156]: db_allocate_columns(): allocate 8 bytes for result names at 0x7f5691266be0
 1(11480) DEBUG: <core> [db_res.c:167]: db_allocate_columns(): allocate 4 bytes for result types at 0x7f5691266c68
 1(11480) DEBUG: db_text [dbt_api.c:80]: dbt_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7f5691273d78 1(11480) DEBUG: auth_db [authorize.c:196]: get_ha1(): no result for user 'user1@'
 1(11480) DEBUG: <core> [db_res.c:81]: db_free_columns(): freeing 1 columns
 1(11480) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[0] at 0x7f5691273d78
 1(11480) DEBUG: <core> [db_res.c:94]: db_free_columns(): freeing result names at 0x7f5691266be0
 1(11480) DEBUG: <core> [db_res.c:99]: db_free_columns(): freeing result types at 0x7f5691266c68
 1(11480) DEBUG: <core> [db_res.c:136]: db_free_result(): freeing result set at 0x7f5691274ef8
 1(11480) exec: *** cfgtrace:request_route=[AUTH] c=[/usr/local/etc/kamailio/kamailio.cfg] l=498 a=26 n=auth_challenge
 1(11480) DEBUG: auth [challenge.c:127]: get_challenge_hf(): build_challenge_hf: realm='10.1.1.1'
 1(11480) DEBUG: auth [challenge.c:269]: get_challenge_hf(): auth: 'WWW-Authenticate: Digest realm="10.1.1.1", nonce="VVn9M1VZ/AcGIj0QNJ3dGrPP3Zs73rle"


still user cannot be found



18.05.2015, 16:33, "jaflong jaflong" <jaflong at yandex.com>:
> cat > /usr/local/etc/kamailio/dbtext/subscriber
>
> username(str) password(str) ha1(str) domain(str) ha1b(str)
> user1:user1:xxx:10.1.1.1:xxx
>
> 9350) DEBUG: auth_db [authorize.c:498]: auth_check(): realm [10.31.8.1] table [subscriber] flags [1]
>  2(9350) DEBUG: auth [api.c:96]: pre_auth(): auth: digest-algo: MD5 parsed value: 1
>  2(9350) DEBUG: db_text [dbt_file.c:102]: dbt_load_file(): request for table [subscriber]
>  2(9350) DEBUG: db_text [dbt_file.c:109]: dbt_load_file(): db is [/usr/local/etc/kamailio/dbtext]
>  2(9350) DEBUG: db_text [dbt_file.c:124]: dbt_load_file(): loading file [/usr/local/etc/kamailio/dbtext/subscriber]
>  2(9350) DEBUG: db_text [dbt_tb.c:187]: dbt_table_new(): mtime is 1431951381
>  2(9350) DEBUG: db_text [dbt_file.c:480]: dbt_load_file(): error at row=0 col=0 c=
>
>  2(9350) ERROR: db_text [dbt_lib.c:307]: dbt_db_get_table(): could not load database from file [subscriber] 2(9350) ERROR: db_text [dbt_base.c:200]: dbt_query(): table subscriber does not exist!
>  2(9350) ERROR: auth_db [authorize.c:187]: get_ha1(): failed to query database
>  2(9350) exec: *** cfgtrace:request_route=[AUTH] c=[/usr/local/etc/kamailio/kamailio.cfg] l=498 a=26 n=auth_challenge
>  2(9350) DEBUG: auth [challenge.c:127]: get_challenge_hf(): build_challenge_hf: realm='10.31.8.1'
>  2(9350) DEBUG: auth [challenge.c:269]: get_challenge_hf(): auth: 'Proxy-Authenticate: Digest realm="10.31.8.1", nonce="VVnqGlVZ6O4l1T62BGADuI2p8uAnUYeu"
>
> regards
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users