<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div><div class="" role="gridcell" tabindex="0" style="display: table; width: auto; word-wrap: break-word; word-break: break-word; padding-top: 12px; padding-left: 0px;"><div id="yiv1905292133" class=""><div class=""><div class=""><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">Dear all.</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">I am trying to use the both modules, but i have problems:</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">Always the balance decreases and when i cancel the call the destination number ringing anyway.</span></div><div class=""><span class="" style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">Also if the customer does not have balance, to try to make a call this goes smoothly</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><span class="">in other words the calls always comes. </span><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">The log <a rel="nofollow" target="_blank" href="http://pastebin.freeswitch.org/23267" class="">http://pastebin.freeswitch.org/23267</a></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">My lcr.conf.xml</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><configuration name="lcr.conf" description="LCR Configuration"></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <settings></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <!--<param name="odbc-dsn" value="freeswitch-mysql:freeswitch:Fr33Sw1tch"/>--></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="odbc-dsn" value="freeswitch:freeswitch:vmo123"/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </settings></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <profiles></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <profile name="default"></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="id" value="0"/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="order_by" value="rate,quality,reliability"/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </profile></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <profile name="qual_rel"></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="id" value="1"/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="order_by" value="quality,reliability"/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </profile></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <profile name="rel_qual"></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="id" value="2"/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="order_by" value="reliability,quality"/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </profile></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <profile name="pg_prefix2"></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><span class=""> <param name="order_by" value="rate,quality,reliability"/></span><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="export_fields" value="nibble_account,nibble_rate,lowbal_amt,nobal_amt"/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <param name="custom_sql" value="</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> SELECT l.digits AS lcr_digits,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> c.id AS lcr_carrierid_field,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> c.carrier_name AS lcr_carrier_name,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> l.${lcr_rate_field} as lcr_rate_field,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> cg.prefix AS lcr_gw_prefix, cg.suffix AS lcr_gw_suffix,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> l.lead_strip AS lcr_lead_strip, l.trail_strip AS lcr_trail_strip,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> l.prefix AS lcr_prefix, l.suffix AS lcr_suffix,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> a.id AS nibble_account,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> l.${lcr_rate_field} AS nibble_rate,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> a.warn_limit AS lowbal_amt,</span></div><div class=""><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> a.nobal_limit AS nobal_amt,</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> a.id_tarifa AS tarifa </span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> FROM lcr l</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> JOIN carriers c ON l.carrier_id=c.id</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> JOIN carrier_gateway cg ON c.id=cg.carrier_id</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> JOIN auth_user a ON a.id = ${accountcode} </span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> JOIN tarifas t ON t.id = a.id_tarifa </span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1'</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> AND l.digits @> '${lcr_query_digits}'</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> ORDER BY digits DESC, ${lcr_rate_field}, random();</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> "/></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </profile> </span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </profiles></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"></configuration></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><span class="">My Dialplan:</span><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <extension name="tests"></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <condition field="destination_number" expression="^([23]\d{3})$"></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><span class=""> <action application="lcr" data="$1 pg_prefix2"/></span><br class=""></span></div></div><div class=""><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> <span class=""> <action application="bridge" data="${lcr_auto_route}"/></span></span></div><div class=""><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </condition></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </extension></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">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="">http://wiki.freeswitch.org/wiki/Mod_lcr#Integrating_with_mod_nibblebill</a></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"> </span></div></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">I appreciate some help.</span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);"><br class=""></span></div><div class=""><span style="-webkit-text-size-adjust: auto; background-color: rgba(255, 255, 255, 0);">regards</span></div><div class=""><br class=""></div></div></div></div></div></div></div><br><span style="-webkit-text-size-adjust: auto;">Enviado desde mi iPhone</span></div></body></html>