[Freeswitch-users] mod_lcr config

[Sergey Okhapkin]

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();
>