[Freeswitch-users] mod_lcr problem

Rupa Schomaker rupa at rupa.com
Sat Jan 30 07:03:48 PST 2010 

Can you give me the first few lines of their rate table?

Is it:

NPANXXLATA = prefix
OCN = rate for same ocn
INTER = rate for interlata
INTRA = rate for intralata

or something else?

On Fri, Jan 29, 2010 at 10:42 PM, Mouncif Benniane <mouncifbb at gmail.com> wrote:
> 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
>>
>
>
> _______________________________________________
> 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

More information about the FreeSWITCH-users mailing list