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