[SR-Users] Kamailio LCR issue
José Seabra
joseseabra4 at gmail.com
Mon May 26 12:17:11 CEST 2014
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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140526/4230a306/attachment.html>
More information about the sr-users
mailing list