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'
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?