I have followed the setup instructions on the wiki on mod_lcr but I have not been able to get it to work. Any advise or updated instructions Below is the output when I try a test on fs_cli. freeswitch@internal> lcr 45345 No Routes To Display 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:1328 data passed to lcr is [45345] freeswitch@internal> 2010-09-06 22:51:06.107080 [WARNING] mod_lcr.c:1370 Using default CID [18005551212] 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:780 intra routing [state:0 lata:0] so rate field is [rate] 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:796 we have an event 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:820 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 (45345, 4534, 453, 45, 4) AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC, rate, quality DESC, reliability DESC, rand();
What is the result returned by belowmentioned sql query if you execute it manually? I bet it will return no results. On Monday 06 September 2010, Nigel Kent wrote:
I have followed the setup instructions on the wiki on mod_lcr but I have not been able to get it to work. Any advise or updated instructions
Below is the output when I try a test on fs_cli.
freeswitch@internal> lcr 45345 No Routes To Display
2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:1328 data passed to lcr is [45345] freeswitch@internal> 2010-09-06 22:51:06.107080 [WARNING] mod_lcr.c:1370 Using default CID [18005551212] 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:780 intra routing [state:0 lata:0] so rate field is [rate] 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:796 we have an event 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:820 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 (45345, 4534, 453, 45, 4) AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC, rate, quality DESC, reliability DESC, rand();
Check the database actually contains entries and that all the enable flags are enabled. :) If you still can't see why it's not working pastebin a database dump and we'll probably be able to see the cause. -Steve On 7 September 2010 00:29, Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote:
What is the result returned by belowmentioned sql query if you execute it manually? I bet it will return no results.
On Monday 06 September 2010, Nigel Kent wrote:
I have followed the setup instructions on the wiki on mod_lcr but I have not been able to get it to work. Any advise or updated instructions
Below is the output when I try a test on fs_cli.
freeswitch@internal> lcr 45345 No Routes To Display
2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:1328 data passed to lcr is [45345] freeswitch@internal> 2010-09-06 22:51:06.107080 [WARNING] mod_lcr.c:1370 Using default CID [18005551212] 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:780 intra routing [state:0 lata:0] so rate field is [rate] 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:796 we have an event 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:820 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 (45345, 4534, 453, 45, 4) AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC, rate, quality DESC, reliability DESC, rand();
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
yes, my table did not update properly --- On Tue, 7/9/10, Steven Ayre <steveayre@gmail.com> wrote: From: Steven Ayre <steveayre@gmail.com> Subject: Re: [Freeswitch-users] mod_lcr config To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org> Date: Tuesday, 7 September, 2010, 9:59 Check the database actually contains entries and that all the enable flags are enabled. :) If you still can't see why it's not working pastebin a database dump and we'll probably be able to see the cause. -Steve On 7 September 2010 00:29, Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote: What is the result returned by belowmentioned sql query if you execute it manually? I bet it will return no results. On Monday 06 September 2010, Nigel Kent wrote:
I have followed the setup instructions on the wiki on mod_lcr but I have
not been able to get it to work. Any advise or updated instructions
Below is the output when I try a test on fs_cli.
freeswitch@internal> lcr 45345
No Routes To Display
2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:1328 data passed to lcr is
[45345] freeswitch@internal> 2010-09-06 22:51:06.107080 [WARNING]
mod_lcr.c:1370 Using default CID [18005551212] 2010-09-06 22:51:06.107080
[DEBUG] mod_lcr.c:780 intra routing [state:0 lata:0] so rate field is
[rate] 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:796 we have an event
2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:820 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 (45345, 4534, 453, 45, 4) AND
CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC,
rate, quality DESC, reliability DESC, rand();
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org -----Inline Attachment Follows----- _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (3)
-
Nigel Kent
-
Sergey Okhapkin
-
Steven Ayre