ACCOUNT-1
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: INFO: <script>: AUTH: (IP:<REPLACED:PHONE-IP>:1301) sip:34@<REPLACED:realm-1>:5060: |----- REGISTER -----> check subsciber <REPLACED:realm-1>
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: auth_db [authorize.c:487]: auth_check(): realm [<REPLACED:realm-1>] table [subscriber] flags [1]
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: auth [api.c:84]: pre_auth(): auth: digest-algo: MD5 parsed value: 1
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_val.c:163]: db_postgres_val2str(): PQescapeStringConn: in: 2 chars, out: 2 chars
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_val.c:163]: db_postgres_val2str(): PQescapeStringConn: in: 17 chars, out: 17 chars
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_dbase.c:272]: db_postgres_submit_query(): sending query ok: 0x7fd79be095f0 (2) - [select ha1 from subscriber where username='34' AND domain='<REPLACED:realm-1>']
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: <core> [db_res.c:116]: db_new_result(): allocate 56 bytes for result set at 0x7fd79be06878
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_dbase.c:552]: db_postgres_store_result(): 0x7fd79be095f0 PQresultStatus(PGRES_TUPLES_OK) PQgetResult(0x26f0bd0)
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_res.c:108]: db_postgres_get_columns(): 1 columns returned from the query
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: <core> [db_res.c:154]: db_allocate_columns(): allocate 8 bytes for result names at 0x7fd79bdf94a8
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: <core> [db_res.c:165]: db_allocate_columns(): allocate 4 bytes for result types at 0x7fd79bdf51a8
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_res.c:126]: db_postgres_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7fd79be097b0
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_res.c:133]: db_postgres_get_columns(): RES_NAMES(0x7fd79be097b0)[0]=[ha1]
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_res.c:166]: db_postgres_get_columns(): use DB1_STRING result type
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_res.c:222]: db_postgres_convert_rows(): allocate for 1 columns 8 bytes in row buffer at 0x7fd79bde8b70
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: <core> [db_res.c:184]: db_allocate_rows(): allocate 16 bytes for rows at 0x7fd79be08b40
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_res.c:243]: db_postgres_convert_rows(): PQgetvalue(0x7fd79be095f0,0,0)=[<REPLACED:ha1>]
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_res.c:252]: db_postgres_convert_rows(): [0][0] Column[ha1]=[<REPLACED:ha1>]
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: <core> [db_row.c:117]: db_allocate_row(): allocate 32 bytes for row values at 0x7fd79be06928
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: <core> [db_val.c:118]: db_str2val(): converting STRING [<REPLACED:ha1>]
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: <core> [db_val.c:128]: db_str2val(): allocate 33 bytes memory for STRING at 0x7fd79be069a8
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: db_postgres [km_res.c:267]: db_postgres_convert_rows(): freeing row buffer at 0x7fd79bde8b70
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: auth [api.c:199]: auth_check_response(): check_response: Our result = '<REPLACED:nounce>'
Mar 22 16:13:48 kamailio /usr/sbin/kamailio[14138]: DEBUG: auth [api.c:206]: auth_check_response(): check_response: Authorization is OK


ACCOUNT-2
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: INFO: <script>: AUTH: (IP:<REPLACED:PHONE-IP>:1301) sip:34@<REPLACED:realm-2>:5060: |----- REGISTER -----> check subsciber <REPLACED:realm-2>
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: auth_db [authorize.c:487]: auth_check(): realm [<REPLACED:realm-2>] table [subscriber] flags [1]
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: auth [api.c:84]: pre_auth(): auth: digest-algo: MD5 parsed value: 1
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_val.c:163]: db_postgres_val2str(): PQescapeStringConn: in: 2 chars, out: 2 chars
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_val.c:163]: db_postgres_val2str(): PQescapeStringConn: in: 22 chars, out: 22 chars
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_dbase.c:272]: db_postgres_submit_query(): sending query ok: 0x7fd79be095f0 (2) - [select ha1 from subscriber where username='34' AND domain='<REPLACED:realm-2>']
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: <core> [db_res.c:116]: db_new_result(): allocate 56 bytes for result set at 0x7fd79be07ef0
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_dbase.c:552]: db_postgres_store_result(): 0x7fd79be095f0 PQresultStatus(PGRES_TUPLES_OK) PQgetResult(0x26f0bd0)
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_res.c:108]: db_postgres_get_columns(): 1 columns returned from the query
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: <core> [db_res.c:154]: db_allocate_columns(): allocate 8 bytes for result names at 0x7fd79bdf94a8
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: <core> [db_res.c:165]: db_allocate_columns(): allocate 4 bytes for result types at 0x7fd79bdf51a8
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_res.c:126]: db_postgres_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7fd79be097b0
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_res.c:133]: db_postgres_get_columns(): RES_NAMES(0x7fd79be097b0)[0]=[ha1]
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_res.c:166]: db_postgres_get_columns(): use DB1_STRING result type
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_res.c:222]: db_postgres_convert_rows(): allocate for 1 columns 8 bytes in row buffer at 0x7fd79bde8b70
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: <core> [db_res.c:184]: db_allocate_rows(): allocate 16 bytes for rows at 0x7fd79be08b40
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_res.c:243]: db_postgres_convert_rows(): PQgetvalue(0x7fd79be095f0,0,0)=[<REPLACED:ha1-2>]
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_res.c:252]: db_postgres_convert_rows(): [0][0] Column[ha1]=[<REPLACED:ha1-2>]
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: <core> [db_row.c:117]: db_allocate_row(): allocate 32 bytes for row values at 0x7fd79be069b0
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: <core> [db_val.c:118]: db_str2val(): converting STRING [<REPLACED:ha1-2>]
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: <core> [db_val.c:128]: db_str2val(): allocate 33 bytes memory for STRING at 0x7fd79be07d88
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: db_postgres [km_res.c:267]: db_postgres_convert_rows(): freeing row buffer at 0x7fd79bde8b70
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: auth [api.c:199]: auth_check_response(): check_response: Our result = '<REPLACED:nounce-2>'
Mar 22 16:13:49 kamailio /usr/sbin/kamailio[14136]: DEBUG: auth [api.c:209]: auth_check_response(): check_response: Authorization failed---------