Check the database actually contains entries and that all the enable flags are enabled. :)<br><br>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.<br>
<br>-Steve<br><br><br><div class="gmail_quote">On 7 September 2010 00:29, Sergey Okhapkin <span dir="ltr"><<a href="mailto:sos@sokhapkin.dyndns.org">sos@sokhapkin.dyndns.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
What is the result returned by belowmentioned sql query if you execute it<br>
manually? I bet it will return no results.<br>
<div><div></div><div class="h5"><br>
On Monday 06 September 2010, Nigel Kent wrote:<br>
> I have followed the setup instructions on the wiki on mod_lcr but I have<br>
> not been able to get it to work. Any advise or updated instructions<br>
><br>
> Below is the output when I try a test on fs_cli.<br>
><br>
><br>
> freeswitch@internal> lcr 45345<br>
> No Routes To Display<br>
><br>
> 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:1328 data passed to lcr is<br>
> [45345] freeswitch@internal> 2010-09-06 22:51:06.107080 [WARNING]<br>
> mod_lcr.c:1370 Using default CID [18005551212] 2010-09-06 22:51:06.107080<br>
> [DEBUG] mod_lcr.c:780 intra routing [state:0 lata:0] so rate field is<br>
> [rate] 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:796 we have an event<br>
> 2010-09-06 22:51:06.107080 [DEBUG] mod_lcr.c:820 SQL: SELECT l.digits,<br>
> c.carrier_name, l.rate, cg.prefix AS gw_prefix, cg.suffix AS gw_suffix,<br>
> l.lead_strip, l.trail_strip, l.prefix, l.suffix , cg.codec , l.cid FROM<br>
> lcr l JOIN carriers c ON l.carrier_id=<a href="http://c.id" target="_blank">c.id</a> JOIN carrier_gateway cg ON<br>
> <a href="http://c.id" target="_blank">c.id</a>=cg.carrier_id WHERE c.enabled = '1' AND cg.enabled = '1' AND<br>
> l.enabled = '1' AND digits IN (45345, 4534, 453, 45, 4) AND<br>
> CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC,<br>
> rate, quality DESC, reliability DESC, rand();<br>
><br>
<br>
<br>
</div></div><div><div></div><div class="h5">_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br>