[Spce-user] Fraud limit wrong calculation

Jon Bonilla (Manwe) manwe at sipdoc.net
Wed Nov 30 17:23:11 EST 2016

Hi all

I'm having a problem with a 3.8.8 setup lately. I'm receiving fraud limit mails
regarding accounts being locked. Example:


Account ID 29 has been locked due to exceeding the configured
credit balance threshold (158.40 >= 150.00 ) in the billing profile

Affected subscribers:
    ab0115 at domain.com (external ID '0442A')
    ab0116 at domain.com (external ID '0442B') 


But if I check the curren balance of account 29:

mysql> select sum(source_customer_cost)/100 from cdr where source_account_id=29
mysql> and update_time > "2016-11-01 00:00:00";
| sum(source_customer_cost)/100 |
|                 85.9175357000 |

The ngcp-panel also shows same amount as the db.

150 was the daily limit and 600 is the monthly one.

any hints?


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 833 bytes
Desc: Firma digital OpenPGP
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20161130/a5643fd7/attachment.sig>

More information about the Spce-user mailing list