<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">yes, my table did not update properly<br><br>--- On <b>Tue, 7/9/10, Steven Ayre <i><steveayre@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Steven Ayre <steveayre@gmail.com><br>Subject: Re: [Freeswitch-users] mod_lcr config<br>To: "FreeSWITCH Users Help" <freeswitch-users@lists.freeswitch.org><br>Date: Tuesday, 7 September, 2010, 9:59<br><br><div id="yiv635748628">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="yiv635748628gmail_quote">On 7 September 2010 00:29, Sergey Okhapkin <span dir="ltr"><<a rel="nofollow" ymailto="mailto:sos@sokhapkin.dyndns.org" target="_blank" href="/mc/compose?to=sos@sokhapkin.dyndns.org">sos@sokhapkin.dyndns.org</a>></span> wrote:<br><blockquote class="yiv635748628gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; 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="yiv635748628h5"><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 rel="nofollow" target="_blank" href="http://c.id">c.id</a> JOIN carrier_gateway cg ON<br>
> <a rel="nofollow" target="_blank" href="http://c.id">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="yiv635748628h5">_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a rel="nofollow" ymailto="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" href="/mc/compose?to=FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a rel="nofollow" target="_blank" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a rel="nofollow" target="_blank" href="http://www.freeswitch.org">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>FreeSWITCH-users mailing list<br><a ymailto="mailto:FreeSWITCH-users@lists.freeswitch.org" href="/mc/compose?to=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></blockquote></td></tr></table><br>