Hi guys when I call do_routing in opensips 3.1. I have :
Mar 31 16:52:25 hendrix /data/opensips/sbin/opensips[20886]:
callid=hxj~vmgW54: route[drouting]: let's find the group for drouting
based on fU 33757936420
Mar 31 16:52:25 hendrix /data/opensips/sbin/opensips[20886]:
DBG:core:pv_printf: final buffer length 102
Mar 31 16:52:25 hendrix /data/opensips/sbin/opensips[20886]:
callid=hxj~vmgW54: route[drouting]: fU 33757936420 does not start with
32460, we put var(group) 1 to 1
Mar 31 16:52:25 hendrix /data/opensips/sbin/opensips[20886]:
DBG:drouting:do_routing: empty routing table
Mar 31 16:52:25 hendrix /data/opensips/sbin/opensips[20886]:
DBG:core:pv_printf: final buffer length 51
Mar 31 16:52:25 hendrix /data/opensips/sbin/opensips[20886]:
callid=hxj~vmgW54: route[drouting]: drouting failed
script part :
xlog("callid=$ci: route[drouting]: let's find the group for
drouting based on fU $fU");
$var(group)="";
if($fU=~"32460.*")
{
$var(group)=2;
xlog("callid=$ci: route[drouting]: fU $fU starts with 32460, we
put var(group) $var(group) to 2");
}
else
{
$var(group)=1;
xlog("callid=$ci: route[drouting]: fU $fU does not start with
32460, we put var(group) $var(group) to 1");
}
if(!do_routing($(var(group){s.int}),,,$var(rule),$var(gw)))
{
xlog("callid=$ci: route[drouting]: drouting failed");
sl_send_reply(500,"no routes!!!");
exit;
}
olddb :
select * from dr_rules;
+--------+---------+--------+---------+----------+---------+--------+----------------+-------------+
| ruleid | groupid | prefix | timerec | priority | routeid | gwlist |
attrs | description |
+--------+---------+--------+---------+----------+---------+--------+----------------+-------------+
| 4 | 1 | | | 0 | | 32 |
BICS | |
| 7 | 2 | | | 0 | | 32460 |
Belgian mobile | |
+--------+---------+--------+---------+----------+---------+--------+----------------+-------------+
select * from dr_rules;
+--------+---------+--------+---------+----------+---------+--------+----------------+-------------+
| ruleid | groupid | prefix | timerec | priority | routeid | gwlist |
attrs | description |
+--------+---------+--------+---------+----------+---------+--------+----------------+-------------+
| 4 | 1 | | | 0 | | 32 | A
| |
| 7 | 2 | | | 0 | | 32460 | B
| |
+--------+---------+--------+---------+----------+---------+--------+----------------+-------------+
2 rows in set (0.01 sec)
lect * from dr_gateways
-> ;
+----+-------+------+----------------------+-------+------------+-------+------------+-------+--------+----------------------------------+
| id | gwid | type | address | strip | pri_prefix | attrs
| probe_mode | state | socket | description |
+----+-------+------+----------------------+-------+------------+-------+------------+-------+--------+----------------------------------+
| 1 | 32 | 2 | 192.168.174.251:5060 | 0 | | |
0 | 0 | | A |
| 5 | -1 | 1 | 192.168.174.254:5060 | 1 | | |
0 | 0 | | Inbound from B |
| 7 | 32460 | 1 | 192.168.174.253:5060 | 0 | | |
0 | 0 | | C|
+----+-------+------+----------------------+-------+------------+-------+------------+-------+--------+----------------------------------+
3 rows in set (0.00 sec)
select * from dr_groups;
+----+----------+------------------------+---------+------------------------------+
| id | username | domain | groupid |
description |
+----+----------+------------------------+---------+------------------------------+
| 3 | 1 | abcc| 1 | Default group for |
| 5 | 1 | yourdomain.net | 2 | BICS
mobile |
+----+----------+------------------------+---------+------------------------------+
2 rows in set (0.00 sec)
new db :
dr_rules;
+--------+---------+--------+---------+----------+---------+--------+----------+--------------+----------------+-------------+
| ruleid | groupid | prefix | timerec | priority | routeid | gwlist |
sort_alg | sort_profile | attrs | description |
+--------+---------+--------+---------+----------+---------+--------+----------+--------------+----------------+-------------+
| 4 | 1 | | | 0 | | 32 |
N | 0 | A | |
| 7 | 2 | | | 0 | | 32460 |
N | 0 | B | |
+--------+---------+--------+---------+----------+---------+--------+----------+--------------+----------------+-------------+
2 rows in set (0.00 sec)
select * from dr_gateways;
+----+-------+------+----------------------+-------+------------+-------+------------+-------+--------+----------------------------------+
| id | gwid | type | address | strip | pri_prefix | attrs
| probe_mode | state | socket | description |
+----+-------+------+----------------------+-------+------------+-------+------------+-------+--------+----------------------------------+
| 1 | 32 | 2 | 192.168.174.251:5060 | 0 | | |
0 | 0 | | A |
| 5 | -1 | 1 | 192.168.174.254:5060 | 1 | | |
0 | 0 | | Inbound from B |
| 7 | 32460 | 1 | 192.168.174.253:5060 | 0 | | |
0 | 0 | | C|
+----+-------+------+----------------------+-------+------------+-------+------------+-------+--------+----------------------------------+
3 rows in set (0.00 sec)
select * from dr_groups;
+----+----------+------------------------+---------+------------------------------+
| id | username | domain | groupid |
description |
+----+----------+------------------------+---------+------------------------------+
| 3 | 1 | abc | 1 | Default
group for |
| 5 | 1 | yourdomain.net | 2 | BICS
mobile |
+----+----------+------------------------+---------+------------------------------+
2 rows in set (0.00 sec)
select * from dr_carriers;
Empty set (0.00 sec)
select * from dr_partitions;
Empty set (0.00 sec)
so dr_rules has changed.
can somebody please point out what is wrong with my datafill ?
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
