<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div class="" style=""><span class="" style="">Dear.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;" class=""><span class="" style=""><br class="" style=""></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: transparent; font-style: normal;" class=""><span class="" style="">I need someone to help me</span></div><div class="" style=""><br class="" style=""><br class="" style=""></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: HelveticaNeue,
Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;" class=""> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;" class=""> <div dir="ltr" class="" style=""> <font size="2" face="Arial" class="" style=""> On Wednesday, September 10, 2014 5:24 PM, FERNANDO VILLARROEL <fvillarroel@yahoo.com> wrote:<br class="" style=""> </font> </div> <br class="" style=""><br class="" style=""> <div class="" style=""><div id="yiv5262253401" class="" style=""><div class="" style=""><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt;" class=""><div class="" style="display:table;width:auto;word-wrap:break-word;background-color:inherit;padding-top:12px;padding-left:0px;"><div id="yiv5262253401" class="" style=""><div class="" style=""><div style="font-size:12pt;" class=""><div
class="" style="">Dear all.</div><div class="" style=""><br class="" style=""></div><div class="" style="background-color:transparent;">I am trying to use the both modules, but i have problems:</div><div class="" style="background-color:transparent;"><br class="" style=""></div><div class="" style="background-color:transparent;">Always the balance decreases and when i cancel the call the destination number ringing anyway.</div><div class="" style="background-color:transparent;"><span class="" style="background-color:transparent;font-size:12pt;">Also if the customer does not have balance, to try to make a call this goes smoothly</span></div><div class="" style="background-color:transparent;font-size:12pt;"><span class="" style="background-color:transparent;font-size:12pt;">in other words the calls always comes. </span><br class="" style=""></div><div class="" style="background-color:transparent;"><br class="" style=""></div><div class=""
style="background-color:transparent;">The log <a rel="nofollow" target="_blank" href="http://pastebin.freeswitch.org/23267" class="" style="color:rgb(25, 106, 212);font-size:12pt;">http://pastebin.freeswitch.org/23267</a></div><div class="" style="background-color:transparent;"><br class="" style=""></div><div class="" style="background-color:transparent;">My lcr.conf.xml</div><div class="" style="background-color:transparent;"><br class="" style=""></div><div class="" style="background-color:transparent;"><configuration name="lcr.conf" description="LCR Configuration"></div><div class="" style="background-color:transparent;"> <settings></div><div class="" style="background-color:transparent;"> <!--<param name="odbc-dsn" value="freeswitch-mysql:freeswitch:Fr33Sw1tch"/>--></div><div class="" style="background-color:transparent;"> <param name="odbc-dsn"
value="freeswitch:freeswitch:vmo123"/></div><div class="" style="background-color:transparent;"> </settings></div><div class="" style="background-color:transparent;"> <profiles></div><div class="" style="background-color:transparent;"> <profile name="default"></div><div class="" style="background-color:transparent;"> <param name="id" value="0"/></div><div class="" style="background-color:transparent;"> <param
name="order_by" value="rate,quality,reliability"/></div><div class="" style="background-color:transparent;"> </profile></div><div class="" style="background-color:transparent;"> <profile name="qual_rel"></div><div class="" style="background-color:transparent;"> <param name="id" value="1"/></div><div class="" style="background-color:transparent;"> <param name="order_by" value="quality,reliability"/></div><div class="" style="background-color:transparent;"> </profile></div><div class="" style="background-color:transparent;"> <profile name="rel_qual"></div><div class="" style="background-color:transparent;"> <param name="id" value="2"/></div><div class="" style="background-color:transparent;"> <param name="order_by" value="reliability,quality"/></div><div class=""
style="background-color:transparent;"> </profile></div><div class="" style="background-color:transparent;"><br class="" style=""></div><div class="" style="background-color:transparent;"><br class="" style=""></div><div class="" style="background-color:transparent;"> <profile name="pg_prefix2"></div><div class="" style="background-color:transparent;"><span class="" style="background-color:transparent;font-size:12pt;"> <param name="order_by" value="rate,quality,reliability"/></span><br class="" style=""></div><div class="" style="background-color:transparent;"> <param name="export_fields" value="nibble_account,nibble_rate,lowbal_amt,nobal_amt"/></div><div class="" style="background-color:transparent;"> <param name="custom_sql" value="</div><div class="" style="background-color:transparent;">
SELECT l.digits AS lcr_digits,</div><div class="" style="background-color:transparent;"> c.id AS lcr_carrierid_field,</div><div class="" style="background-color:transparent;"> c.carrier_name AS lcr_carrier_name,</div><div class="" style="background-color:transparent;"> l.${lcr_rate_field} as lcr_rate_field,</div><div class="" style="background-color:transparent;"> cg.prefix AS lcr_gw_prefix, cg.suffix AS lcr_gw_suffix,</div><div class="" style="background-color:transparent;"> l.lead_strip AS lcr_lead_strip, l.trail_strip AS lcr_trail_strip,</div><div class="" style="background-color:transparent;"> l.prefix AS lcr_prefix,
l.suffix AS lcr_suffix,</div><div class="" style="background-color:transparent;"> a.id AS nibble_account,</div><div class="" style="background-color:transparent;"> l.${lcr_rate_field} AS nibble_rate,</div><div class="" style="background-color:transparent;"> a.warn_limit AS lowbal_amt,</div><div class="" style=""><div class="" style=""> a.nobal_limit AS nobal_amt,</div><div class="" style=""> a.id_tarifa AS tarifa </div><div class="" style=""> FROM lcr l</div><div class="" style=""> JOIN carriers c ON l.carrier_id=c.id</div><div class="" style=""> JOIN carrier_gateway cg ON
c.id=cg.carrier_id</div><div class="" style=""> JOIN auth_user a ON a.id = ${accountcode} </div><div class="" style=""> JOIN tarifas t ON t.id = a.id_tarifa </div><div class="" style=""> WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1'</div><div class="" style=""> AND l.digits @> '${lcr_query_digits}'</div><div class="" style=""> AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end</div><div class="" style=""> ORDER BY digits DESC, ${lcr_rate_field}, random();</div><div class="" style=""> "/></div><div class="" style=""> </profile> </div><div class="" style=""> </profiles></div><div class="" style=""></configuration></div><div class=""
style=""><br class="" style=""></div><div class="" style=""><span class="" style="font-size:12pt;">My Dialplan:</span><br class="" style=""></div><div class="" style=""><br class="" style=""></div><div class="" style=""><div class="" style=""> <extension name="tests"></div><div class="" style=""> <condition field="destination_number" expression="^([23]\d{3})$"></div><div class="" style=""><span class="" style="font-size:12pt;"> <action application="lcr" data="$1 pg_prefix2"/></span><br class="" style=""></div></div><div class="" style=""><div class="" style=""> <span class="" style="font-size:12pt;"> <action application="bridge" data="${lcr_auto_route}"/></span></div><div class="" style=""><div class="" style=""> </condition></div><div class="" style=""> </extension></div><div class=""
style=""><br class="" style=""></div><div class="" style=""><br class="" style=""></div><div class="" style="">What i doing wrong i am follow <a rel="nofollow" target="_blank" href="http://wiki.freeswitch.org/wiki/Mod_lcr#Integrating_with_mod_nibblebill" class="" style="background-color:rgb(255, 255, 255);color:rgb(25, 106, 212);font-size:12pt;">http://wiki.freeswitch.org/wiki/Mod_lcr#Integrating_with_mod_nibblebill</a></div><div class="" style=""> </div><div class="" style=""> </div></div><div class="" style="">I appreciate some help.</div><div class="" style=""><br class="" style=""></div><div class="" style="">regards</div><div class="" style=""><br class="" style=""></div></div></div></div></div></div></div><div class="" style=""><br class="" style=""></div></div></div></div><br class="" style=""><br class="" style=""></div> </div> </div> </div> </div></body></html>