Hello, should I open a bug for this on github or how do I need to proceed ?
BR, Op di 31 mrt. 2020 om 19:23 schreef johan <[email protected]>: > 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
