[Freeswitch-users] mod_lcr problem

[Mouncif Benniane]

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




*lc**r 617642  default*  returns rate from the rate field table and not
intra/inter state fields rates.


Any ideas? thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100129/46f38ef9/attachment-0002.html