[Freeswitch-users] nibblebill sql requests

[David Ponzone]

AFAIR, they are not unnecessary.

David Ponzone  Direction Technique
email: david.ponzone at ipeva.fr
tel:      01 74 03 18 97
gsm:   06 66 98 76 34

Service Client IPeva
tel:      0811 46 26 26
www.ipeva.fr  -   www.ipeva-studio.com

Ce message et toutes les pièces jointes sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation ou diffusion non autorisée est interdite. Tout message électronique est susceptible d'altération. IPeva décline toute responsabilité au titre de ce message s'il a été altéré, déformé ou falsifié. Si vous n'êtes pas destinataire de ce message, merci de le détruire immédiatement et d'avertir l'expéditeur.




Le 08/02/2011 à 17:11, Madovsky a écrit :

> after hangup,
> nibblebill makes unnecessary duplicated SQL requests :
>  
> 2011-02-08 11:06:36.894238 [DEBUG] mod_sofia.c:457 Channel sofia/internal/9999999999999 at domain.com hanging up, cause: NORMAL_CLEARING
> 2011-02-08 11:06:37.018489 [DEBUG] mod_nibblebill.c:433 Attempting to bill at $0.03864 per minute to account 9999999999999
> 2011-02-08 11:06:37.018489 [INFO] mod_nibblebill.c:485 Beginning new billing on 461772290 at 12.34.56.78
> 2011-02-08 11:06:37.018489 [DEBUG] mod_nibblebill.c:491 1 seconds passed since last bill time of 2011-02-08 11:06:35
> 2011-02-08 11:06:37.018489 [DEBUG] mod_nibblebill.c:498 Billing $0.000874 to 9999999999999 (Call: 461772290 at 12.34.56.78 / 0.000000 so far)
> 2011-02-08 11:06:37.018489 [DEBUG] mod_nibblebill.c:321 Doing update query
> [UPDATE accounts SET cash=cash-0.000874 WHERE id='9999999999999']
> 2011-02-08 11:06:37.074740 [DEBUG] mod_nibblebill.c:366 Doing lookup query
> [SELECT cash AS nibble_balance FROM accounts WHERE id='9999999999999']
> 2011-02-08 11:06:37.082844 [DEBUG] mod_nibblebill.c:376 Retrieved current balance for account 9999999999999 (balance = 9.579666)
> 2011-02-08 11:06:37.082844 [DEBUG] switch_core_state_machine.c:46 sofia/internal/9999999999999 at domain.com Standard HANGUP, cause: NORMAL_CLEARING
> 2011-02-08 11:06:37.082844 [DEBUG] switch_core_state_machine.c:557 (sofia/internal/9999999999999 at domain.com) State HANGUP going to sleep
> 2011-02-08 11:06:37.082844 [DEBUG] switch_core_state_machine.c:351 (sofia/internal/9999999999999 at domain.com) State Change CS_HANGUP -> CS_REPORTING
> 2011-02-08 11:06:37.082844 [DEBUG] switch_core_session.c:1116 Send signal sofia/internal/9999999999999 at domain.com [BREAK]
> 2011-02-08 11:06:37.082844 [DEBUG] switch_core_state_machine.c:320 (sofia/internal/9999999999999 at domain.com) Running State Change CS_REPORTING
> 2011-02-08 11:06:37.082844 [DEBUG] switch_core_state_machine.c:617 (sofia/internal/9999999999999 at domain.com) State REPORTING
> 2011-02-08 11:06:37.082844 [DEBUG] mod_nibblebill.c:433 Attempting to bill at $0.03864 per minute to account 9999999999999
> 2011-02-08 11:06:37.082844 [DEBUG] mod_nibblebill.c:491 0 seconds passed since last bill time of 2011-02-08 11:06:37
> 2011-02-08 11:06:37.082844 [DEBUG] mod_nibblebill.c:498 Billing $0.000041 to 9999999999999 (Call: 461772290 at 12.34.56.78 / 0.000874 so far)
> 2011-02-08 11:06:37.082844 [DEBUG] mod_nibblebill.c:321 Doing update query
> [UPDATE accounts SET cash=cash-0.000041 WHERE id='9999999999999']
> 2011-02-08 11:06:37.133170 [DEBUG] mod_nibblebill.c:366 Doing lookup query
> [SELECT cash AS nibble_balance FROM accounts WHERE id='9999999999999']
> 2011-02-08 11:06:37.201557 [DEBUG] mod_nibblebill.c:376 Retrieved current balance for account 9999999999999 (balance = 9.579625)
> 
> How to avoid duplicate SQL requests with nibblebill ?
> 
> Thanks
> 
> _______________________________________________
> 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/20110208/1812211d/attachment.html