[prev in list] [next in list] [prev in thread] [next in thread]
List: sr-dev
Subject: [sr-dev] [kamailio/kamailio] Function sql_xquery returns 1 for empty query result. (Issue #3163)
From: admin-toneca <notifications () github ! com>
Date: 2022-06-24 17:23:25
Message-ID: kamailio/kamailio/issues/3163 () github ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
### Description
Function sql_xquery returns 1 for empty query result.
#### Reproduction
Table sbc_uacreg is empty
modparam("sqlops", "sqlcon", "con=>mysql://kamailio:pass@172.31.1.237/fs")
if (sql_xquery("con", "SELECT * FROM sbc_uacreg WHERE l_uuid = \
'$hdr(X-Gateway)'", "ra") == 1) { xlog("(PSTN) SELECT * FROM sbc_uacreg WHERE l_uuid \
= '$hdr(X-Gateway)' =============================================================================\n");
$var(register) = "1";
}
#### Log Messages
```
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_query.c:72]: \
db_do_submit_query(): submitted query: SELECT * FROM sbc_uacreg WHERE l_uuid = \
'GwProdIpAuth', result 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:119]: db_new_result(): \
allocate 56 bytes for result set at 0x7fa7c2c91170
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:67]: \
db_mysql_get_columns(): 16 columns returned from the query
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:156]: \
db_allocate_columns(): allocate 128 bytes for result names at \
0x7fa7c2c91288
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:167]: \
db_allocate_columns(): allocate 64 bytes for result types at \
0x7fa7c2c91370
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[0] at \
0x7fa7c2c91418
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91418)[0]=[id]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: \
db_mysql_get_columns(): use DB1_INT result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[1] at \
0x7fa7c2c91490
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91490)[1]=[l_uuid]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[2] at \
0x7fa7c2c91508
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91508)[2]=[l_username]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[3] at \
0x7fa7c2c91580
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91580)[3]=[l_domain]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[4] at \
0x7fa7c2c915f8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c915f8)[4]=[r_username]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[5] at \
0x7fa7c2c91670
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91670)[5]=[r_domain]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[6] at \
0x7fa7c2c916e8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c916e8)[6]=[realm]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[7] at \
0x7fa7c2c91760
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91760)[7]=[auth_username]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[8] at \
0x7fa7c2c917d8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c917d8)[8]=[auth_password]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[9] at \
0x7fa7c2c91850
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91850)[9]=[auth_ha1]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[10] at \
0x7fa7c2cbe3c8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe3c8)[10]=[auth_proxy]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[11] at \
0x7fa7c2cbe440
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe440)[11]=[expires]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: \
db_mysql_get_columns(): use DB1_INT result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[12] at \
0x7fa7c2cbe4b8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe4b8)[12]=[flags]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: \
db_mysql_get_columns(): use DB1_INT result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[13] at \
0x7fa7c2cbe530
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe530)[13]=[reg_delay]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: \
db_mysql_get_columns(): use DB1_INT result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[14] at \
0x7fa7c2cbe5a8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe5a8)[14]=[contact_addr]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[15] at \
0x7fa7c2cbe620
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe620)[15]=[socket]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:181]: \
db_mysql_convert_rows(): no rows returned from the query
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} sqlops [sql_api.c:494]: \
sql_exec_xquery(): no result after query
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:79]: db_free_columns(): \
freeing 16 columns
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[0] at 0x7fa7c2c91418
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[1] at 0x7fa7c2c91490
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[2] at 0x7fa7c2c91508
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[3] at 0x7fa7c2c91580
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[4] at 0x7fa7c2c915f8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[5] at 0x7fa7c2c91670
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[6] at 0x7fa7c2c916e8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[7] at 0x7fa7c2c91760
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[8] at 0x7fa7c2c917d8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[9] at 0x7fa7c2c91850
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[10] at 0x7fa7c2cbe3c8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[11] at 0x7fa7c2cbe440
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[12] at 0x7fa7c2cbe4b8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[13] at 0x7fa7c2cbe530
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[14] at 0x7fa7c2cbe5a8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: db_free_columns(): \
freeing RES_NAMES[15] at 0x7fa7c2cbe620
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:96]: db_free_columns(): \
freeing result names at 0x7fa7c2c91288
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:101]: \
db_free_columns(): freeing result types at 0x7fa7c2c91370
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:138]: db_free_result(): \
freeing result set at 0x7fa7c2c91170
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: exec: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} *** cfgtrace:dbg_cfg_trace(): \
request_route=[PSTN] c=[/usr/local/etc/kamailio/kamailio.cfg] l=1155 \
a=25 n=xlog
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Via] type 1
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Max-Forwards] type 8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [From] type 4
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [To] type 3
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Call-ID] type 6
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [CSeq] type 5
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Contact] type 7
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [User-Agent] type 28
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Allow] type 21
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Supported] type 17
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Allow-Events] type 39
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Content-Type] type 11
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Content-Disposition] \
type 30
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [Content-Length] type 12
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [core/parser/parse_hname2.c:301]: \
parse_sip_header_name(): parsed header name [X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: ERROR: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <script>: (PSTN) SELECT * FROM \
sbc_uacreg WHERE l_uuid = 'GwProdIpAuth' \
============================================================================= ```
### Additional Information
* **Kamailio Version** - output of `kamailio -v`
```
version: kamailio 5.7.0-dev0 (x86_64/linux) 0d9380
flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, \
USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, \
DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, \
USE_NAPTR, USE_DST_BLOCKLIST, HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED \
ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE \
65535, DEFAULT PKG_SIZE 8MB poll method support: poll, epoll_lt, epoll_et, sigio_rt, \
select.
id: 0d9380
compiled on 14:06:32 May 26 2022 with gcc 11.2.0
```
* **Operating System**:
<!--
Details about the operating system, the type: Linux (e.g.,: Debian 8.4, Ubuntu 16.04, \
CentOS 7.1, ...), MacOS, xBSD, Solaris, ...; Kernel details (output of `lsb_release \
-a` and `uname -a`)
-->
```
Distributor ID: Ubuntu
Description: Ubuntu 22.04 LTS
Release: 22.04
Codename: jammy
Linux ip-172-31-3-158 5.15.0-1011-aws #14-Ubuntu SMP Wed Jun 1 20:54:22 UTC 2022 \
x86_64 x86_64 x86_64 GNU/Linux
```
--
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/3163
You are receiving this because you are subscribed to this thread.
Message ID: <kamailio/kamailio/issues/3163@github.com>
[Attachment #5 (text/html)]
<p></p>
<h3 dir="auto">Description</h3>
<p dir="auto">Function sql_xquery returns 1 for empty query result.</p>
<h4 dir="auto">Reproduction</h4>
<p dir="auto">Table sbc_uacreg is empty<br>
modparam("sqlops", "sqlcon", "con=>mysql://kamailio:pass@172.31.1.237/fs")</p>
<pre class="notranslate"><code class="notranslate"> if (sql_xquery("con", "SELECT \
* FROM sbc_uacreg WHERE l_uuid = '$hdr(X-Gateway)'", "ra") == 1) {
xlog("(PSTN) SELECT * FROM sbc_uacreg WHERE l_uuid = '$hdr(X-Gateway)' \
=============================================================================\n"); \
$var(register) = "1"; }
</code></pre>
<h4 dir="auto">Log Messages</h4>
<pre class="notranslate"><code class="notranslate">Jun 24 17:14:52 ip-172-31-3-158 \
/usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 INVITE \
00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_query.c:72]: \
db_do_submit_query(): submitted query: SELECT * FROM sbc_uacreg WHERE l_uuid = \
'GwProdIpAuth', result 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:119]: \
db_new_result(): allocate 56 bytes for result set at 0x7fa7c2c91170
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:67]: \
db_mysql_get_columns(): 16 columns returned from the query
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:156]: \
db_allocate_columns(): allocate 128 bytes for result names at \
0x7fa7c2c91288
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:167]: \
db_allocate_columns(): allocate 64 bytes for result types at \
0x7fa7c2c91370
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[0] at \
0x7fa7c2c91418
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91418)[0]=[id]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: \
db_mysql_get_columns(): use DB1_INT result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[1] at \
0x7fa7c2c91490
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91490)[1]=[l_uuid]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[2] at \
0x7fa7c2c91508
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91508)[2]=[l_username]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[3] at \
0x7fa7c2c91580
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91580)[3]=[l_domain]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[4] at \
0x7fa7c2c915f8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c915f8)[4]=[r_username]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[5] at \
0x7fa7c2c91670
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91670)[5]=[r_domain]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[6] at \
0x7fa7c2c916e8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c916e8)[6]=[realm]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[7] at \
0x7fa7c2c91760
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91760)[7]=[auth_username]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[8] at \
0x7fa7c2c917d8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c917d8)[8]=[auth_password]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[9] at \
0x7fa7c2c91850
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2c91850)[9]=[auth_ha1]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[10] at \
0x7fa7c2cbe3c8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe3c8)[10]=[auth_proxy]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[11] at \
0x7fa7c2cbe440
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe440)[11]=[expires]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: \
db_mysql_get_columns(): use DB1_INT result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[12] at \
0x7fa7c2cbe4b8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe4b8)[12]=[flags]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: \
db_mysql_get_columns(): use DB1_INT result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[13] at \
0x7fa7c2cbe530
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe530)[13]=[reg_delay]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:105]: \
db_mysql_get_columns(): use DB1_INT result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[14] at \
0x7fa7c2cbe5a8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe5a8)[14]=[contact_addr]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:84]: \
db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[15] at \
0x7fa7c2cbe620
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:91]: \
db_mysql_get_columns(): RES_NAMES(0x7fa7c2cbe620)[15]=[socket]
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:148]: \
db_mysql_get_columns(): use DB1_STRING result type
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} db_mysql [km_res.c:181]: \
db_mysql_convert_rows(): no rows returned from the query
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} sqlops [sql_api.c:494]: \
sql_exec_xquery(): no result after query
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:79]: \
db_free_columns(): freeing 16 columns
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[0] at 0x7fa7c2c91418
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[1] at 0x7fa7c2c91490
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[2] at 0x7fa7c2c91508
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[3] at 0x7fa7c2c91580
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[4] at 0x7fa7c2c915f8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[5] at 0x7fa7c2c91670
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[6] at 0x7fa7c2c916e8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[7] at 0x7fa7c2c91760
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[8] at 0x7fa7c2c917d8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[9] at 0x7fa7c2c91850
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[10] at 0x7fa7c2cbe3c8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[11] at 0x7fa7c2cbe440
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[12] at 0x7fa7c2cbe4b8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[13] at 0x7fa7c2cbe530
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[14] at 0x7fa7c2cbe5a8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:83]: \
db_free_columns(): freeing RES_NAMES[15] at 0x7fa7c2cbe620
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:96]: \
db_free_columns(): freeing result names at 0x7fa7c2c91288
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:101]: \
db_free_columns(): freeing result types at 0x7fa7c2c91370
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> [db_res.c:138]: \
db_free_result(): freeing result set at 0x7fa7c2c91170
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: exec: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} *** cfgtrace:dbg_cfg_trace(): \
request_route=[PSTN] c=[/usr/local/etc/kamailio/kamailio.cfg] l=1155 \
a=25 n=xlog
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Via] \
type 1
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[Max-Forwards] type 8
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [From] \
type 4
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [To] \
type 3
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[Call-ID] type 6
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [CSeq] \
type 5
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[Contact] type 7
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[User-Agent] type 28
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name [Allow] \
type 21
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[Supported] type 17
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[Allow-Events] type 39
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[Content-Type] type 11
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[Content-Disposition] type 30
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[Content-Length] type 12
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: DEBUG: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <core> \
[core/parser/parse_hname2.c:301]: parse_sip_header_name(): parsed header name \
[X-Gateway] type 0
Jun 24 17:14:52 ip-172-31-3-158 /usr/local/sbin/kamailio[49325]: ERROR: {1 53491654 \
INVITE 00a98cb1-6e84-123b-fca2-069c0e3bf50e} <script>: (PSTN) SELECT * FROM \
sbc_uacreg WHERE l_uuid = 'GwProdIpAuth' \
============================================================================= \
</code></pre> <h3 dir="auto">Additional Information</h3>
<ul dir="auto">
<li><strong>Kamailio Version</strong> - output of <code class="notranslate">kamailio \
-v</code></li> </ul>
<pre class="notranslate"><code class="notranslate">version: kamailio 5.7.0-dev0 \
(x86_64/linux) 0d9380
flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, \
USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, \
DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, \
USE_NAPTR, USE_DST_BLOCKLIST, HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED \
ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE \
65535, DEFAULT PKG_SIZE 8MB poll method support: poll, epoll_lt, epoll_et, sigio_rt, \
select.
id: 0d9380
compiled on 14:06:32 May 26 2022 with gcc 11.2.0
</code></pre>
<ul dir="auto">
<li><strong>Operating System</strong>:</li>
</ul>
<pre class="notranslate"><code class="notranslate">Distributor ID: Ubuntu
Description: Ubuntu 22.04 LTS
Release: 22.04
Codename: jammy
Linux ip-172-31-3-158 5.15.0-1011-aws #14-Ubuntu SMP Wed Jun 1 20:54:22 UTC 2022 \
x86_64 x86_64 x86_64 GNU/Linux
</code></pre>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br \
/>Reply to this email directly, <a \
href="https://github.com/kamailio/kamailio/issues/3163">view it on GitHub</a>, or <a \
href="https://github.com/notifications/unsubscribe-auth/ABO7UZIEF7WQYFKL42PT6DLVQXVI3ANCNFSM5ZYPREVQ">unsubscribe</a>.<br \
/>You are receiving this because you are subscribed to this thread.<img \
src="https://github.com/notifications/beacon/ABO7UZLMLKH6PFRUOCNXVDTVQXVI3A5CNFSM5ZYPREV2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4TEIH4TA.gif" \
height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: \
none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; \
max-width: 0; max-height: 0; mso-hide: all">Message ID: \
<span><kamailio/kamailio/issues/3163</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/kamailio/kamailio/issues/3163",
"url": "https://github.com/kamailio/kamailio/issues/3163",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>
_______________________________________________
Kamailio (SER) - Development Mailing List
sr-dev@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-dev
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic