[Freeswitch-users] mod_lcr config

[Nigel Kent]

yes, my table did not update properly

--- On Tue, 7/9/10, Steven Ayre <steveayre at gmail.com> wrote:

From: Steven Ayre <steveayre at gmail.com>
Subject: Re: [Freeswitch-users] mod_lcr config
To: "FreeSWITCH Users Help" <freeswitch-users at 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 at 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 at 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 at 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 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




-----Inline Attachment Follows-----

_______________________________________________
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/20100907/41ac2f65/attachment.html