[Freeswitch-users] mod_nibblebill updates

Rogelio Perez rogelio.perez at gmail.com
Tue Apr 26 15:58:04 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/428bd987/attachment.html 


More information about the FreeSWITCH-users mailing list