[Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1
Matthias Hohl
matthias.hohl at telematica.at
Mon May 2 12:31:45 EDT 2016
Hello Kirill,
1.) the problem with the amount was just at one customer, another one, which was notified from billing profile monthly limit, was set correct.
2.) yah I know it is in cents not in EUR. Thanks for the advice how to change it.
3.) on last day I had the problem, that a customer exceeded the monthly limit and I got the notifications but no lock... the setting is set right. is this still included in the bugfix?
5.) so is it then possible to just set the limit in customer settings and the mail address will be used from billing profile setting? Like it works currently for the daily limit?
6.) if you update the script, it is maybe also possible to include a checkbox for "lock limit just for current month", and next month there is standard lock level? Would be nice feature, to top up the limit for the current month only.
-----Ursprüngliche Nachricht-----
Von: Kirill Solomko [mailto:ksolomko at sipwise.com]
Gesendet: Montag, 2. Mai 2016 16:31
An: Matthias Hohl <matthias.hohl at telematica.at>
Cc: Spce-user at lists.sipwise.com
Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1
Hi Matthias,
I could not reproduce your scenario.
I have 30 cdrs for customer 5, for 2016-04-22 with 150 cents in sum().
mysql> select count(id), source_account_id,
mysql> date(from_unixtime(start_time)) from cdr group by 2,3;
+-----------+-------------------+---------------------------------+
| count(id) | source_account_id | date(from_unixtime(start_time)) |
+-----------+-------------------+---------------------------------+
| 10 | 5 | 2016-04-21 |
| 30 | 5 | 2016-04-22 |
| 10 | 41 | 2016-04-15 |
| 10 | 41 | 2016-04-22 |
Now the costs:
select sum(source_customer_cost), source_account_id, date(from_unixtime(start_time)) from cdr group by 2,3;
+---------------------------+-------------------+---------------------------------+
| sum(source_customer_cost) | source_account_id |
| date(from_unixtime(start_time)) |
+---------------------------+-------------------+---------------------------------+
| 50.000000 | 5 | 2016-04-21 |
| 150.000000 | 5 | 2016-04-22 |
| 50.000000 | 41 | 2016-04-15 |
| 50.000000 | 41 | 2016-04-22
And customer_id 5 was triggered with the amount of 150 (cents). And the warning I received:
———————
Customer # 5 is currently exceeding the configured credit balance threshold (1.50 >= 0.20) in the customer settings, but has not been locked due to configuration.
Affected subscribers:
…
———————
Please keep in mind that you enter values in cents (150 = 150 cents) where in the email you see them divided by 100.
You can however adjust your template and define it there as “1.50 EUR >= 0.20 EUR”.
Also please bear in mind that in the billing profiles there is a checkbox “use reseller rates”, which means that if it is checked then the reseller defined fees will be used in the calculation (source_reseller_cost instead of source_customer_cost).
As for the new template value [% interval %] it will be available with next package update nearest days and also addressed “inheritance” minor fix when the “limit” value is not set in the customer fraud preferences but the other values are.
Kind regards,
Kirill
> On 01 May 2016, at 18:06, Matthias Hohl <matthias.hohl at telematica.at> wrote:
>
> Hello Kirill,
>
> Any news about the Fraud Check update..?
>
> Thanks
>
> Von meinem iPhone gesendet
>
>> Am 26.04.2016 um 20:41 schrieb Matthias Hohl <matthias.hohl at telematica.at>:
>>
>> Hi kirill,
>>
>> Oh okay. Good to know :)
>>
>> Then I will wait.
>>
>> Any update about the "lock" problem?
>>
>> Thanks for your time.
>>
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Kirill Solomko [mailto:ksolomko at sipwise.com]
>> Gesendet: Dienstag, 26. April 2016 19:34
>> An: Matthias Hohl <matthias.hohl at telematica.at>
>> Cc: Spce-user at lists.sipwise.com
>> Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1
>>
>> Hi Matthias,
>>
>> It is not available yet, it is going to be available as a package
>> update nearest days.
>>
>> Kind regards,
>> Kirill
>>
>>>> On 26 Apr 2016, at 09:34, Matthias Hohl
>>>> <matthias.hohl at telematica.at>
>>> wrote:
>>>
>>> Hello,
>>>
>>> i inserted [% interval %] in the mail template but it doesn't work.
>>> I can't see the "daily" or "monthly" information in the notification mail.
>>
>>>
>>> TEMPLATE:
>>> Customer # [% customer_id %] has been locked due to exceeding the
>>> configured credit balance threshold ([% interval_cost %] >= [%
>>> interval_limit %]) in the [% type %] [% interval %] settings.
>>>
>>> MAIL:
>>> Customer # 6 has been locked due to exceeding the configured credit
>>> balance threshold (178.59 >= 20.00) in the customer settings.
>>>
>>>
>>>
>>> -----Ursprüngliche Nachricht-----
>>> Von: Kirill Solomko [mailto:ksolomko at sipwise.com]
>>> Gesendet: Montag, 25. April 2016 23:40
>>> An: Matthias Hohl <matthias.hohl at telematica.at>
>>> Cc: Spce-user at lists.sipwise.com
>>> Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1
>>>
>>> Hi Matthias,
>>>
>>> Inline replies as following:
>>>
>>>>> On 25 Apr 2016, at 19:05, Matthias Hohl
>>>>> <matthias.hohl at telematica.at>
>>>> wrote:
>>>>
>>>> 3. Bug:
>>>>
>>>> I also see that in the notifcation mail doesn't split between "daily"
>>>> or
>>> "monthly" limit exceeded.
>>>
>>> The variable will be exposed to the email templates as [% interval
>>> %]
>>>
>>> Kind regards,
>>> Kirill
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/listinfo/spce-user
More information about the Spce-user
mailing list