I show you database data and kamcmd commands output.
mysql> select * from lcr_rule_target;
+----+--------+---------+-------+----------+--------+
| id | lcr_id | rule_id | gw_id | priority | weight |
+----+--------+---------+-------+----------+--------+
| 1 | 1 | 1 | 1 | 1 | 1 |
| 2 | 1 | 2 | 1 | 1 | 1 |
| 3 | 2 | 2 | 2 | 1 | 1 |
+----+--------+---------+-------+----------+--------+
3 rows in set (0.00 sec)
mysql> select * from lcr_rule;
+----+--------+-----------+----------+-------------+---------+---------+
| id | lcr_id | prefix | from_uri | request_uri | stopper | enabled |
+----+--------+-----------+----------+-------------+---------+---------+
| 1 | 1 | 6 | NULL | NULL | 1 | 1 |
| 2 | 1 | DIDNUMBER | NULL | NULL | 1 | 1 |
| 3 | 2 | DIDNUMBER | NULL | NULL | 1 | 1 |
+----+--------+-----------+----------+-------------+---------+---------+
3 rows in set (0.00 sec)
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 | Carrier_Prueba | 172.x.x.x | NULL | 5060 | NULL | 1 | 1 | 0 | NULL | NULL | 1 | NULL |
| 5 | 2 | Proveedor_1 | 172.x.x.x | NULL | 5060 | NULL | 1 | 1 | 0 | NULL | NULL | 0 | NULL |
+----+--------+----------------+--------------+----------+------+--------+------------+-----------+-------+--------+------+-------+---------+
2 rows in set (0.00 sec)
mysql>
root@kamailio:~# kamcmd lcr.reload
root@kamailio:~# kamcmd lcr.dump_rules
{
lcr_id: 1
rule_id: 2
prefix: DIDNUMBER
from_uri:
request_uri:
stopper: 1
}
{
gw_index: 1
priority: 1
weight: 1
}
{
lcr_id: 1
rule_id: 1
prefix: 6
from_uri:
request_uri:
stopper: 1
}
{
gw_index: 1
priority: 1
weight: 1
}
9
1
root@kamailio:~# kamcmd lcr.dump_gws
{
lcr_id: 1
gw_id: 1
gw_index: 1
gw_name: Carrier_Prueba
scheme: sip:
ip_addr: 172.x.x.x
hostname:
port: 5060
params:
transport: ;transport=udp
strip: 0
prefix:
tag:
flags: 1
state: 0
defunct_until: 0