Hi. Does anyone could help me. --- On Mon, 6/11/12, FERNANDO VILLARROEL <fvillarroel@yahoo.com> wrote:
From: FERNANDO VILLARROEL <fvillarroel@yahoo.com> Subject: [Freeswitch-users] application set variable problem To: freeswitch-users@lists.freeswitch.org Date: Monday, June 11, 2012, 12:52 PM Hi All.
i am using mod_lcr
<action application="lcr" data="$1 pg_prefix2"/> <action application="set" data="nibble_account=${accountcode}"/> <action application="set" data="nibble_rate=${lcr_rate_1}"/> <action application="set" data="foo=11"/> <action application="set" data="accounts_tarifa=${tarifa}"/>
My custom SQL:
<param name="custom_sql" value=" SELECT l.digits AS lcr_digits, c.carrier_name AS lcr_carrier_name, l.${lcr_rate_field} as lcr_rate_field, cg.prefix AS lcr_gw_prefix, cg.suffix AS lcr_gw_suffix, l.lead_strip AS lcr_lead_strip, l.trail_strip AS lcr_trail_strip, l.prefix AS lcr_prefix, l.suffix AS lcr_suffix, a.id AS nibble_account, l.${lcr_rate_field} AS nibble_rate, a.warn_limit AS lowbal_amt, a.nobal_limit AS nobal_amt, a.id_tarifa AS tarifa FROM lcr l JOIN carriers c ON l.carrier_id=c.id JOIN carrier_gateway cg ON c.id=cg.carrier_id JOIN accounts a ON a.id = '${accountcode}' JOIN tarifas t ON a.id_tarifa = t.id WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1' AND l.digits @> '${lcr_query_digits}' AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC, ${lcr_rate_field}, random();
Log :
2012-06-11 11:33:52.336613 [DEBUG] mod_lcr.c:940 SQL: SELECT l.digits AS lcr_digits, c.carrier_name AS lcr_carrier_name, l.rate as lcr_rate_field, cg.prefix AS lcr_gw_prefix, cg.suffix AS lcr_gw_suffix, l.lead_strip AS lcr_lead_strip, l.trail_strip AS lcr_trail_strip, l.prefix AS lcr_prefix, l.suffix AS lcr_suffix, a.id AS nibble_account, l.rate AS nibble_rate, a.warn_limit AS lowbal_amt, a.nobal_limit AS nobal_amt, a.id_tarifa AS tarifa FROM lcr l JOIN carriers c ON l.carrier_id=c.id JOIN carrier_gateway cg ON c.id=cg.carrier_id JOIN accounts a ON a.id = '1004' JOIN tarifas t ON a.id_tarifa = t.id WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1' AND l.digits @> '1006' AND CURRENT_TIMESTAMP BETWEEN date_start AND date_end ORDER BY digits DESC, rate, random(); 2012-06-11 11:33:52.356514 [DEBUG] mod_lcr.c:338 Returning Dialstring [lcr_carrier=carrier2,lcr_rate=0.14000,nibble_account=1004,nibble_rate=0.14000,lowbal_amt=0,nobal_amt=0,tarifa=1]user/gateway/0006 2012-06-11 11:33:52.356514 [DEBUG] mod_lcr.c:677 Adding carrier2 to head of list 2012-06-11 11:33:52.356514 [DEBUG] mod_lcr.c:338 Returning Dialstring [lcr_carrier=carrier1,lcr_rate=0.15000,nibble_account=1004,nibble_rate=0.15000,lowbal_amt=0,nobal_amt=0,tarifa=1]user/1006 2012-06-11 11:33:52.356514 [DEBUG] mod_lcr.c:705 Adding carrier1 to end of list EXECUTE sofia/internal/1004@192.168.1.108 set(nibble_account=1004) 2012-06-11 11:33:52.356514 [DEBUG] mod_dptools.c:1294 sofia/internal/1004@192.168.1.108 SET [nibble_account]=[1004] EXECUTE sofia/internal/1004@192.168.1.108 set(nibble_rate=0.14000) 2012-06-11 11:33:52.356514 [DEBUG] mod_dptools.c:1294 sofia/internal/1004@192.168.1.108 SET [nibble_rate]=[0.14000] EXECUTE sofia/internal/1004@192.168.1.108 set(foo=11) 2012-06-11 11:33:52.356514 [DEBUG] mod_dptools.c:1294 sofia/internal/1004@192.168.1.108 SET [foo]=[11] EXECUTE sofia/internal/1004@192.168.1.108 set(accounts_tarifa=) 2012-06-11 11:33:52.356514 [DEBUG] mod_dptools.c:1294 sofia/internal/1004@192.168.1.108 SET [accounts_tarifa]=[UNDEF]
My accounts_tarifa variable is UNDEF
What i am doing wrong?
Regard
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
Join Us At ClueCon - Aug 7-9, 2012
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org