[Freeswitch-users] nibblebill custom_sql_save

[David Villasmil]

Hello,

Thanks for replying!

It was not set, but i understood from the wiki that if you don't want any
rounding, you dont't set it.

I set it to "10", i want the user to be charged tvery 10 seconds, you
nibblebil is charging 10 DOLLARS!
I must be getting something wrong...


Here's my nibblebill.conf.xml.

(BTW, the two highlighted lines, is it possible to do that? I want the
custom SQLs to use channel variables, is it possible?)


    <section name="configuration">
        <configuration name="nibblebill.conf" description="Nibble Billing">
            <settings>
                <param name="db_username" value="myroot" />
                <param name="db_password" value="mypass" />
                <param name="odbc-dsn" value="odbc://viking" />
                <param name="db_table" value="sip_users" />
                <param name="db_column_cash" value="balance" />
                <param name="db_column_account" value="id" />
                *<param name="custom_sql_lookup" value="SELECT
${variable_card_db_column_cash} AS nibble_balance FROM
${variable_card_db_table} WHERE
${variable_card_db_column_account}=${nibble_account};" />*
*                <param name="custom_sql_save" value="UPDATE
${variable_card_db_table} SET
${variable_card_db_column_cash}=${variable_card_db_column_cash}-${nibble_increment}
WHERE ${variable_card_db_column_account}=${nibble_account};" />*
                <param name="global_heartbeat" value="10" />
                <param name="lowbal_amt" value="0" />
                <param name="lowbal_action" value="play ding" />
                <param name="nobal_amt" value="0" />
                <param name="nobal_action" value="hangup" />
                <param name="percall_max_amt" value="100" />
                <param name="percall_action" value="hangup" />
            </settings>
        </configuration>
    </section>

Here's the dialplan:

    <section name="dialplan">
        <context name="route_call">
            <extension name="routeCall">
                <condition field="destination_number" expression="^.*">
                    <action application="set"
data="continue_on_fail=NO_ROUTE_DESTINATION,UNALLOCATED_NUMBER,407" />
                    <action application="set" data="sip_from_user=1002" />
                    <action application="set" data="sip_auth_username=1002"
/>
                    <action application="set" data="sip_req_user=1002" />
                    <action application="set"
data="hangup_after_bridge=true" />
                    <action application="set" data="nibble_rate=0.0500" />
                    <action application="nibblebill" data="heartbeat 10" />
                    <action application="set"
data="card_db_table=cards_table" />
                    <action application="set"
data="card_db_column_cash=balance" />
                    <action application="set"
data="card_db_column_account=pin" />
                    <action application="set" data="nibble_account=12345" />
                    <action application="set"
data="gw=${distributor(TEST_ROUTE)}" />
                    <action application="limit" data="hash $${domain}
$${domain} ${sip_auth_username} 1 !NORMAL_TEMPORARY_FAILURE" />
                    <action application="export"
data="execute_on_answer=nibblebill adjust -0.1000" />
                    <action application="bridge"
data="{enable_heartbeat_events=10,nibble_rate=0.0500,nibble_account=12345}sofia/gateway/${gw}/0013058883456"
/>
                </condition>
            </extension>
        </context>
    </section>


Thanks for your help!


David



On Wed, Feb 20, 2013 at 2:23 PM, Muhammad Shahzad <shaheryarkh at gmail.com>wrote:

> Did you set nibble_increment variable? e.g.
>
> <variable name="nibble_increment" value="30" />
>
> Here is its details,
>
> http://wiki.freeswitch.org/wiki/Mod_nibblebill#Nibble_Method_.28Default.29
>
> Thank you.
>
>
> On Wed, Feb 20, 2013 at 2:10 PM, David Villasmil <
> david.villasmil.work at gmail.com> wrote:
>
>> Anyone about this?
>>
>> Thanks
>>
>>
>> On Mon, Feb 18, 2013 at 2:07 PM, David Villasmil <
>> david.villasmil.work at gmail.com> wrote:
>>
>>> Hello guys,
>>>
>>> I have the following config for nibbebill:
>>>
>>>                 <param name="custom_sql_lookup" value="SELECT
>>> ${card_db_column_cash} AS nibble_balance FROM ${card_db_table} WHERE
>>> ${card_db_column_account}=${nibble_account};" />
>>>                 <param name="custom_sql_save" value="UPDATE
>>> ${card_db_table} SET
>>> ${card_db_column_cash}=${card_db_column_cash}-${nibble_increment} WHERE
>>> ${card_db_column_account}=${nibble_account};" />
>>>
>>> I see this on the log, which is obviously failing:
>>>
>>>
>>>  [UPDATE cards_table SET balance=balance- WHERE pin=12345;]
>>>
>>> is ${nibble_increment} not the correct variable to use? It looks like it
>>> is empty!
>>>
>>> Thanks!
>>>
>>> David
>>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>
>
> --
> Muhammad Shahzad
> -----------------------------------
> CISCO Rich Media Communication Specialist (CRMCS)
> CISCO Certified Network Associate (CCNA)
> Cell: +49 176 99 83 10 85
> MSN: shari_786pk at hotmail.com
> Email: shaheryarkh at googlemail.com
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130221/7ec39569/attachment-0001.html