[Freeswitch-users] mod_lcr problem
Mouncif Benniane
mouncifbb at gmail.com
Fri Jan 29 20:42:04 PST 2010
Also the Provider has presented the rates in this format?
NPANXXLATA OCN INTER INTRA
On Fri, Jan 29, 2010 at 11:30 PM, Mouncif Benniane <mouncifbb at gmail.com>wrote:
> Tried it and it's not giving me intralata instead I get interstate, does
> the npa_nxx_company_ocn table needs to be used in this case?, also do I have
> to have the rate field in lcr table?
>
>
> lcr 617642 default 6176421212
>
> | Digit Match | Carrier | Rate | Codec | CID Regexp | Dialstring
> |
> | 617642 | carrier1 | 0.00500 | | |
> [lcr_carrier=carrier1,lcr_rate=0.00500]sofia/gateway/carrier1/1617642 |
>
>
> 2010-01-29 23:29:45.003307 [DEBUG] mod_lcr.c:1329 data passed to lcr is
> [617642 default 6176421212]
> 2010-01-29 23:29:45.003307 [DEBUG] mod_lcr.c:1365 Set Caller ID to
> [6176421212]
> 2010-01-29 23:29:45.003307 [DEBUG] mod_lcr.c:786 intra routing [state:0
> lata:0] so rate field is [rate]
> 2010-01-29 23:29:45.003307 [DEBUG] mod_lcr.c:802 we have an event
> 2010-01-29 23:29:45.003307 [DEBUG] mod_lcr.c:826 SQL: SELECT l.digits,
> c.carrier_name, l.rate, cg.prefix AS gw_prefix, cg.suffix AS gw_suffix,
> l.lead_strip, l.trail_strip, l.prefix, l.suffix , cg.codec , l.cid FROM lcr
> l JOIN carriers c ON l.carrier_id=c.id JOIN carrier_gateway cg ON c.id=cg.carrier_id
> WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1' AND digits IN
> (617642, 61764, 6176, 617, 61, 6) AND CURRENT_TIMESTAMP BETWEEN date_start
> AND date_end ORDER BY digits DESC, rate, rand();
> 2010-01-29 23:29:45.003307 [DEBUG] mod_lcr.c:307 Returning Dialstring
> [lcr_carrier=carrier1,lcr_rate=0.00500]sofia/gateway/carrier1/1617642
> 2010-01-29 23:29:45.003307 [DEBUG] mod_lcr.c:615 Adding carrier1 to head of
> list
> 2010-01-29 23:29:45.003307 [DEBUG] mod_lcr.c:307 Returning Dialstring
> [lcr_carrier=carrier1,lcr_rate=0.00500]sofia/gateway/carrier1/1617642
>
>
> Thank you Rupa!
>
>
> On Fri, Jan 29, 2010 at 7:37 PM, Rupa Schomaker <rupa at rupa.com> wrote:
>
>> turn console logging up to debug and redo the lcr lookup. The sql
>> statements along with status info will show up. This should give
>> enough information to debug what is happening.
>>
>> I'm assuming the npanxx table is actually populated and not just existing?
>>
>> When doing the lookup from the cli you have to tell lcr what CID to
>> use (remember, it is relative to the src/dest number). I'm pretty
>> sure you get something on the console log when you don't specify a CID
>> when using the commandline. Anyway:
>>
>> lcr 617642 default 6176421212
>>
>> should give you intralata.
>>
>> Note that the definition of intralata doesn't mean "local" for some
>> providers. Some providers define local to "same ratecenter" which is
>> even more restrictive.
>>
>> On Fri, Jan 29, 2010 at 4:43 PM, Mouncif Benniane <mouncifbb at gmail.com>
>> wrote:
>> > i can't make use of mod_lcr using Intra/Interstate rating, I am using
>> > svn: FreeSWITCH Version 1.0.trunk (16517)
>> >
>> > lcr mysql table structure:
>> > CREATE TABLE `lcr` (
>> > `id` INT(11) NOT NULL AUTO_INCREMENT,
>> > `digits` VARCHAR(15) DEFAULT NULL,
>> > `rate` FLOAT(11,5) DEFAULT NULL,
>> > `intrastate_rate` FLOAT(11,5) DEFAULT NULL,
>> > `intralata_rate` FLOAT(11,5) DEFAULT NULL,
>> > `carrier_id` INT(11) NOT NULL,
>> > `lead_strip` INT(11) NOT NULL,
>> > `trail_strip` INT(11) NOT NULL,
>> > `prefix` VARCHAR(16) NOT NULL,
>> > `suffix` VARCHAR(16) NOT NULL,
>> > `lcr_profile` VARCHAR(32) DEFAULT NULL,
>> > `date_start` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00',
>> > `date_end` DATETIME NOT NULL DEFAULT '2030-12-31 00:00:00',
>> > `quality` FLOAT(10,6) NOT NULL,
>> > `reliability` FLOAT(10,6) NOT NULL,
>> > `cid` VARCHAR(32) NOT NULL DEFAULT '',
>> > `enabled` TINYINT(1) NOT NULL DEFAULT '1',
>> > PRIMARY KEY (`id`),
>> > KEY `carrier_id` (`carrier_id`),
>> > KEY `digits` (`digits`),
>> > KEY `lcr_profile` (`lcr_profile`),
>> > KEY `digits_profile_cid_rate` USING BTREE (`digits`),
>> > CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`) REFERENCES
>> `carriers`
>> > (`id`) ON DELETE CASCADE ON UPDATE CASCADE
>> > ) ENGINE=INNODB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1
>> >
>> >
>> > lcr_admin show profiles
>> > Name: default
>> > custom sql: SELECT l.digits, c.carrier_name, l.${lcr_rate_field},
>> > cg.prefix AS gw_prefix, cg.suffix AS gw_suffix, l.lead_strip,
>> l.trail_strip,
>> > l.prefix, l.suffix , cg.codec , l.cid FROM lcr l JOIN carriers c ON
>> > l.carrier_id=c.id JOIN carrier_gateway cg ON c.id=cg.carrier_id WHERE
>> > c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1' AND digits IN
>> > (${lcr_query_expanded_digits}) AND CURRENT_TIMESTAMP BETWEEN date_start
>> AND
>> > date_end ORDER BY digits DESC, ${lcr_rate_field}, quality DESC,
>> > reliability DESC, rand();
>> > has %: false
>> > has vars: true
>> > has intrastate: true
>> > has intralata: true
>> > has npanxx: true
>> > Reorder rate: enabled
>> > Info in headers: disabled
>> > Quote IN() List: disabled
>> >
>> >
>> >
>> > lcr 617642 default returns rate from the rate field table and not
>> > intra/inter state fields rates.
>> >
>> > Any ideas? thanks!
>> >
>> >
>> >
>> >
>> > _______________________________________________
>> > FreeSWITCH-users mailing list
>> > FreeSWITCH-users at lists.freeswitch.org
>> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> > UNSUBSCRIBE:
>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>> > http://www.freeswitch.org
>> >
>> >
>>
>>
>>
>> --
>> -Rupa
>>
>> _______________________________________________
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100129/09a0903f/attachment-0002.html
More information about the FreeSWITCH-users
mailing list