Hello there,


I'm configuring the LCR module, with more than one lcr instance, for example each instance id will have atleast 1 diferent gateway,
well the issue here is that if i configure another gateways with diferent LCR_ID and then run kamcmd lcr.reload then kamcmd lcr.dump_gws i only see the gateways that belongs to the instance 1,  should it show me the all gateways  for each lcr instance correct?

I'm using kamailio-4.0.4

please have a look at my lcr configuration example and the kamailio logs:


Mysql:
mysql> select * from lcr_gw;
+----+--------+---------+-------------+-------------+------+--------+------------+-----------+-------+--------+------+-------+---------+
| id | lcr_id | gw_name | ip_addr     | hostname    | port | params | uri_scheme | transport | strip | prefix | tag  | flags | defunct |
+----+--------+---------+-------------+-------------+------+--------+------------+-----------+-------+--------+------+-------+---------+
|  1 |      1 | teste1  | 192.168.1.1 | 192.168.1.1 | 5060 | NULL   |          1 |         1 |  NULL | NULL   | NULL |     0 |    NULL |
|  2 |      2 | teste2  | 192.168.1.2 | 192.168.1.2 | 5060 | NULL   |          1 |         1 |  NULL | NULL   | NULL |     0 |    NULL |
+----+--------+---------+-------------+-------------+------+--------+------------+-----------+-------+--------+------+-------+---------+
2 rows in set (0.01 sec)

mysql> select * from lcr_rule;
+----+--------+--------+----------+-------------+---------+---------+
| id | lcr_id | prefix | from_uri | request_uri | stopper | enabled |
+----+--------+--------+----------+-------------+---------+---------+
|  1 |      1 | NULL   | NULL     | 256*        |       0 |       1 |
|  2 |      2 | NULL   | NULL     | 236*        |       0 |       1 |
+----+--------+--------+----------+-------------+---------+---------+
2 rows in set (0.00 sec)

mysql> select * from lcr_rule_target;
+----+--------+---------+-------+----------+--------+
| id | lcr_id | rule_id | gw_id | priority | weight |
+----+--------+---------+-------+----------+--------+
|  1 |      1 |       1 |     1 |        1 |     10 |
|  2 |      2 |       2 |     2 |        1 |     10 |
+----+--------+---------+-------+----------+--------+
2 rows in set (0.00 sec)

kamcd lcr.dump_gws

kamcmd lcr.dump_gws
12(3267) DEBUG: ctl [../../io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x7ffb90811c00, 9, 3, 0x1ca0880), fd_no=1
12(3267) DEBUG: ctl [io_listener.c:453]: handle_new_connect(): handle_stream read: new connection (1) on /tmp/kamailio_ctl
{
lcr_id: 1
gw_id: 1
gw_index: 1
gw_name: teste1
scheme: sip
ip_addr: 192.168.1.1
hostname: 192.168.1.1
port: 5060
params: 
transport: UDP
strip: 0
prefix: 
tag: 
flags: 0
defunct_until: 0
}
12(3267) DEBUG: ctl [io_listener.c:506]: handle_stream_read(): handle_stream read: eof on /tmp/kamailio_ctl
12(3267) DEBUG: ctl [../../io_wait.h:617]: io_watch_del(): DBG: io_watch_del (0x7ffb90811c00, 9, -1, 0x10) fd_no=2 called




kamcmd lcr.reload logs:


kamcmd lcr.reload
12(3267) DEBUG: ctl [../../io_wait.h:390]: io_watch_add(): DBG: io_watch_add(0x7ffb90811c00, 9, 3, 0x1ca0880), fd_no=1
12(3267) DEBUG: ctl [io_listener.c:453]: handle_new_connect(): handle_stream read: new connection (1) on /tmp/kamailio_ctl
12(3267) DEBUG: <core> [db.c:318]: db_do_init2(): connection 0x7ffb95b50ff0 not found in pool
12(3267) DEBUG: db_mysql [km_my_con.c:94]: db_mysql_new_connection(): opening connection: mysql://xxxx:xxxx@localhost/kamailio
12(3267) DEBUG: db_mysql [km_my_con.c:121]: db_mysql_new_connection(): connection type is Localhost via UNIX socket
12(3267) DEBUG: db_mysql [km_my_con.c:122]: db_mysql_new_connection(): protocol version is 10
12(3267) DEBUG: db_mysql [km_my_con.c:123]: db_mysql_new_connection(): server version is 5.1.69
12(3267) DEBUG: <core> [db_res.c:118]: db_new_result(): allocate 56 bytes for result set at 0x7ffb95b51160
12(3267) DEBUG: db_mysql [km_res.c:68]: db_mysql_get_columns(): 6 columns returned from the query
12(3267) DEBUG: <core> [db_res.c:155]: db_allocate_columns(): allocate 48 bytes for result names at 0x7ffb95b4e3b0
12(3267) DEBUG: <core> [db_res.c:165]: db_allocate_columns(): allocate 24 bytes for result types at 0x7ffb95b51240
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7ffb95b51280
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51280)[0]=[id]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[1] at 0x7ffb95b512b0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b512b0)[1]=[prefix]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[2] at 0x7ffb95b512e0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b512e0)[2]=[from_uri]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[3] at 0x7ffb95b51310
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51310)[3]=[stopper]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[4] at 0x7ffb95b511c0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b511c0)[4]=[enabled]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[5] at 0x7ffb95b51340
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51340)[5]=[request_uri]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_dbase.c:358]: db_mysql_fetch_result(): converting row 0 of 1 count 1
12(3267) DEBUG: <core> [db_row.c:119]: db_allocate_row(): allocate 192 bytes for row values at 0x7ffb95b49280
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [1]
12(3267) DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value12(3267) DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [0]
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [1]
12(3267) DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [256*]
12(3267) DEBUG: lcr [lcr_mod.c:1238]: reload_tables(): loading, cycle 0 with <1> rows
12(3267) DEBUG: lcr [hash.c:89]: rule_hash_table_insert(): inserted rule_id <1>, prefix <>, from_uri <>, request_uri <256*>, stopper <0>, into index <0>
12(3267) DEBUG: lcr [hash.c:104]: rule_hash_table_insert(): inserted rule_id <1> addr <0x7ffb8dbd5480> into rule_id hash table index <1>
12(3267) DEBUG: <core> [db_res.c:54]: db_free_rows(): freeing 1 rows
12(3267) DEBUG: <core> [db_row.c:97]: db_free_row(): freeing row values at 0x7ffb95b49280
12(3267) DEBUG: <core> [db_res.c:62]: db_free_rows(): freeing rows at 0x7ffb95b513a0
12(3267) DEBUG: <core> [db_res.c:81]: db_free_columns(): freeing 6 columns
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[0] at 0x7ffb95b51280
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[1] at 0x7ffb95b512b0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[2] at 0x7ffb95b512e0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[3] at 0x7ffb95b51310
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[4] at 0x7ffb95b511c0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[5] at 0x7ffb95b51340
12(3267) DEBUG: <core> [db_res.c:94]: db_free_columns(): freeing result names at 0x7ffb95b4e3b0
12(3267) DEBUG: <core> [db_res.c:99]: db_free_columns(): freeing result types at 0x7ffb95b51240
12(3267) DEBUG: <core> [db_res.c:136]: db_free_result(): freeing result set at 0x7ffb95b51160
12(3267) DEBUG: <core> [db_res.c:118]: db_new_result(): allocate 56 bytes for result set at 0x7ffb95b51160
12(3267) DEBUG: db_mysql [km_res.c:68]: db_mysql_get_columns(): 13 columns returned from the query
12(3267) DEBUG: <core> [db_res.c:155]: db_allocate_columns(): allocate 104 bytes for result names at 0x7ffb95b49280
12(3267) DEBUG: <core> [db_res.c:165]: db_allocate_columns(): allocate 52 bytes for result types at 0x7ffb95b49360
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7ffb95b511c0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b511c0)[0]=[gw_name]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[1] at 0x7ffb95b51310
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51310)[1]=[ip_addr]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[2] at 0x7ffb95b512e0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b512e0)[2]=[port]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[3] at 0x7ffb95b512b0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b512b0)[3]=[uri_scheme]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[4] at 0x7ffb95b51280
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51280)[4]=[transport]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[5] at 0x7ffb95b51370
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51370)[5]=[params]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[6] at 0x7ffb95b513a0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b513a0)[6]=[hostname]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[7] at 0x7ffb95b493c0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b493c0)[7]=[strip]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[8] at 0x7ffb95b493f0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b493f0)[8]=[prefix]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[9] at 0x7ffb95b49420
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b49420)[9]=[tag]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[10] at 0x7ffb95b49450
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b49450)[10]=[flags]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[11] at 0x7ffb95b49480
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b49480)[11]=[defunct]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[12] at 0x7ffb95b51240
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51240)[12]=[id]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: <core> [db_res.c:184]: db_allocate_rows(): allocate 16 bytes for rows at 0x7ffb95b4e3b0
12(3267) DEBUG: <core> [db_row.c:119]: db_allocate_row(): allocate 416 bytes for row values at 0x7ffb95b494b0
12(3267) DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [teste1]
12(3267) DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [192.168.1.1]
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [5060]
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [1]
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [1]
12(3267) DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value12(3267) DEBUG: <core> [db_val.c:117]: db_str2val(): converting STRING [192.168.1.1]
12(3267) DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value12(3267) DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value12(3267) DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [0]
12(3267) DEBUG: <core> [db_val.c:56]: db_str2val(): converting NULL value12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [1]
12(3267) DEBUG: lcr [lcr_mod.c:836]: insert_gw(): inserted gw <1, teste1, 192.168.1.1, 5060, 192.168.1.1> at index 1
12(3267) DEBUG: <core> [db_res.c:81]: db_free_columns(): freeing 13 columns
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[0] at 0x7ffb95b511c0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[1] at 0x7ffb95b51310
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[2] at 0x7ffb95b512e0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[3] at 0x7ffb95b512b0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[4] at 0x7ffb95b51280
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[5] at 0x7ffb95b51370
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[6] at 0x7ffb95b513a0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[7] at 0x7ffb95b493c0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[8] at 0x7ffb95b493f0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[9] at 0x7ffb95b49420
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[10] at 0x7ffb95b49450
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[11] at 0x7ffb95b49480
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[12] at 0x7ffb95b51240
12(3267) DEBUG: <core> [db_res.c:94]: db_free_columns(): freeing result names at 0x7ffb95b49280
12(3267) DEBUG: <core> [db_res.c:99]: db_free_columns(): freeing result types at 0x7ffb95b49360
12(3267) DEBUG: <core> [db_res.c:54]: db_free_rows(): freeing 1 rows
12(3267) DEBUG: <core> [db_row.c:97]: db_free_row(): freeing row values at 0x7ffb95b494b0
12(3267) DEBUG: <core> [db_res.c:62]: db_free_rows(): freeing rows at 0x7ffb95b4e3b0
12(3267) DEBUG: <core> [db_res.c:136]: db_free_result(): freeing result set at 0x7ffb95b51160
12(3267) DEBUG: <core> [db_res.c:118]: db_new_result(): allocate 56 bytes for result set at 0x7ffb95b51160
12(3267) DEBUG: db_mysql [km_res.c:68]: db_mysql_get_columns(): 13 columns returned from the query
12(3267) DEBUG: <core> [db_res.c:155]: db_allocate_columns(): allocate 104 bytes for result names at 0x7ffb95b49280
12(3267) DEBUG: <core> [db_res.c:165]: db_allocate_columns(): allocate 52 bytes for result types at 0x7ffb95b49360
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7ffb95b49450
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b49450)[0]=[gw_name]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[1] at 0x7ffb95b49420
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b49420)[1]=[ip_addr]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[2] at 0x7ffb95b493f0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b493f0)[2]=[port]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[3] at 0x7ffb95b493c0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b493c0)[3]=[uri_scheme]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[4] at 0x7ffb95b513a0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b513a0)[4]=[transport]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[5] at 0x7ffb95b51370
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51370)[5]=[params]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[6] at 0x7ffb95b51280
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51280)[6]=[hostname]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[7] at 0x7ffb95b512b0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b512b0)[7]=[strip]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[8] at 0x7ffb95b512e0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b512e0)[8]=[prefix]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[9] at 0x7ffb95b51310
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51310)[9]=[tag]
12(3267) DEBUG: db_mysql [km_res.c:136]: db_mysql_get_columns(): use DB1_STRING result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[10] at 0x7ffb95b511c0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b511c0)[10]=[flags]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[11] at 0x7ffb95b51340
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51340)[11]=[defunct]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[12] at 0x7ffb95b51240
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51240)[12]=[id]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:169]: db_mysql_convert_rows(): no rows returned from the query
12(3267) DEBUG: <core> [db_res.c:81]: db_free_columns(): freeing 13 columns
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[0] at 0x7ffb95b49450
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[1] at 0x7ffb95b49420
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[2] at 0x7ffb95b493f0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[3] at 0x7ffb95b493c0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[4] at 0x7ffb95b513a0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[5] at 0x7ffb95b51370
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[6] at 0x7ffb95b51280
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[7] at 0x7ffb95b512b0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[8] at 0x7ffb95b512e0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[9] at 0x7ffb95b51310
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[10] at 0x7ffb95b511c0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[11] at 0x7ffb95b51340
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[12] at 0x7ffb95b51240
12(3267) DEBUG: <core> [db_res.c:94]: db_free_columns(): freeing result names at 0x7ffb95b49280
12(3267) DEBUG: <core> [db_res.c:99]: db_free_columns(): freeing result types at 0x7ffb95b49360
12(3267) DEBUG: <core> [db_res.c:136]: db_free_result(): freeing result set at 0x7ffb95b51160
12(3267) DEBUG: <core> [db_res.c:118]: db_new_result(): allocate 56 bytes for result set at 0x7ffb95b51160
12(3267) DEBUG: db_mysql [km_res.c:68]: db_mysql_get_columns(): 4 columns returned from the query
12(3267) DEBUG: <core> [db_res.c:155]: db_allocate_columns(): allocate 32 bytes for result names at 0x7ffb95b51240
12(3267) DEBUG: <core> [db_res.c:165]: db_allocate_columns(): allocate 16 bytes for result types at 0x7ffb95b511c0
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[0] at 0x7ffb95b51310
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51310)[0]=[rule_id]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[1] at 0x7ffb95b512e0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b512e0)[1]=[gw_id]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[2] at 0x7ffb95b512b0
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b512b0)[2]=[priority]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_res.c:85]: db_mysql_get_columns(): allocate 16 bytes for RES_NAMES[3] at 0x7ffb95b51280
12(3267) DEBUG: db_mysql [km_res.c:92]: db_mysql_get_columns(): RES_NAMES(0x7ffb95b51280)[3]=[weight]
12(3267) DEBUG: db_mysql [km_res.c:100]: db_mysql_get_columns(): use DB1_INT result type
12(3267) DEBUG: db_mysql [km_dbase.c:358]: db_mysql_fetch_result(): converting row 0 of 1 count 1
12(3267) DEBUG: <core> [db_row.c:119]: db_allocate_row(): allocate 128 bytes for row values at 0x7ffb95b49280
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [1]
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [1]
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [1]
12(3267) DEBUG: <core> [db_val.c:73]: db_str2val(): converting INT [10]
12(3267) DEBUG: lcr [lcr_mod.c:1450]: reload_tables(): loading, cycle 0 with <1> rows
12(3267) DEBUG: lcr [hash.c:160]: rule_hash_table_insert_target(): found rule with id <1> and addr <0x7ffb8dbd5480>
12(3267) DEBUG: <core> [db_res.c:54]: db_free_rows(): freeing 1 rows
12(3267) DEBUG: <core> [db_row.c:97]: db_free_row(): freeing row values at 0x7ffb95b49280
12(3267) DEBUG: <core> [db_res.c:62]: db_free_rows(): freeing rows at 0x7ffb95b51370
12(3267) DEBUG: <core> [db_res.c:81]: db_free_columns(): freeing 4 columns
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[0] at 0x7ffb95b51310
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[1] at 0x7ffb95b512e0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[2] at 0x7ffb95b512b0
12(3267) DEBUG: <core> [db_res.c:85]: db_free_columns(): freeing RES_NAMES[3] at 0x7ffb95b51280
12(3267) DEBUG: <core> [db_res.c:94]: db_free_columns(): freeing result names at 0x7ffb95b51240
12(3267) DEBUG: <core> [db_res.c:99]: db_free_columns(): freeing result types at 0x7ffb95b511c0
12(3267) DEBUG: <core> [db_res.c:136]: db_free_result(): freeing result set at 0x7ffb95b51160
12(3267) DEBUG: <core> [db_pool.c:102]: pool_remove(): removing connection from the pool
[root@seabra kamailio]# 12(3267) DEBUG: ctl [io_listener.c:506]: handle_stream_read(): handle_stream read: eof on /tmp/kamailio_ctl
12(3267) DEBUG: ctl [../../io_wait.h:617]: io_watch_del(): DBG: io_watch_del (0x7ffb90811c00, 9, -1, 0x10) fd_no=2 called

Thank you

Best Regards

--
Cumprimentos
José Seabra