[Freeswitch-users] mod_nibblebill updates
Rogelio Perez
rogelio.perez at gmail.com
Tue Apr 26 08:37:39 MSD 2011
Hello, I'm using mod_nibblebill to bill my calls only for leg b and heartbeats set to 'off'.
After the hangup I see 3 different MySQL updates from nibblebill instead of just one.
This is my dial plan:
<extension name="TEST">
<condition field="destination_number" expression="^(1\d+)$">
<action application="set" data="dialed_extension=$1"/>
<action application="export" data="dialed_extension=$1"/>
<action application="set" data="hangup_after_bridge=true"/>
<action application="set" data="continue_on_fail=true"/>
<action application="bridge" data="{nibble_rate=5,nibble_account=13}sofia/gateway/xxxxxxx/$1"/>
<action application="hangup"/>
</condition>
</extension>
...this is the MySQL log:
68080 Query select 1
68080 Query UPDATE web_account SET balance=balance-0.343372 WHERE id='13'
68080 Query select 1
68080 Query SELECT balance AS nibble_balance FROM web_account WHERE id='13'
68080 Query select 1
68080 Query UPDATE web_account SET balance=balance-0.001177 WHERE id='13'
68080 Query select 1
68080 Query SELECT balance AS nibble_balance FROM web_account WHERE id='13'
68080 Query select 1
68080 Query UPDATE web_account SET balance=balance-0.001197 WHERE id='13'
68080 Query select 1
68080 Query SELECT balance AS nibble_balance FROM web_account WHERE id='13'
...and here's the FS log: http://pastebin.freeswitch.org/16175
The xml_cdr is saved after the second update, so the nibble_total_billed is different than the real total value debited from the account balance.
Is this normal?
Shouldn't nibblebill just do one update after the hangup?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110426/bcabd5ed/attachment.html
More information about the FreeSWITCH-users
mailing list