<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.E-MailFormatvorlage19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE-AT link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hello,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>thanks for this info.. nice to hear that we maybe can fix this problem.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I will keep you up2date if the update solve this problem.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Thanks for your investigation.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Kirill Solomko [mailto:ksolomko@sipwise.com] <br><b>Gesendet:</b> Montag, 6. </span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Juni 2016 09:29<br><b>An:</b> Matthias Hohl <matthias.hohl@telematica.at><br><b>Cc:</b> Spce-user@lists.sipwise.com<br><b>Betreff:</b> Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1 - URGENT<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>One of our developers found a bug in ngcp-panel that causes impact on customer data updates via the API when certain custom email templates exist. <o:p></o:p></span></p><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US>A fix for mr4.3 is incoming this week and that solves the issue when locking a customer via the API fails.<o:p></o:p></span></p><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><span lang=EN-US>On 05 Jun 2016, at 00:28, Kirill Solomko <</span><a href="mailto:ksolomko@sipwise.com"><span lang=EN-US>ksolomko@sipwise.com</span></a><span lang=EN-US>> wrote:<o:p></o:p></span></p></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><div><div><p class=MsoNormal><span lang=EN-US>I am afraid the issue why that particular API call fails in the script is not with the fraud script itself but rather something with the ngcp-panel. Either way I will take a look into that as see how that can be sorted out.<o:p></o:p></span></p><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal><span lang=EN-US>On 04 Jun 2016, at 20:51, Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US>matthias.hohl@telematica.at</span></a><span lang=EN-US>> wrote:<o:p></o:p></span></p></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Hello again,</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>yes you are right, if I lock the customer, the notifications stops BUT there is the next problem:</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If I lock the whole customer “Customer Details > Edit > Status “locked” all subscribers get to status “locked” and lock level “global”.</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>So also inbound calls and webif doesn’t work anymore for this subscriber.</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>If I want to edit the subscriber then, I can’t change the lock level to “outgoing” only as long the status is on “locked”.</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>So I must first set the status for the subscriber back to “active” and then the lock level back to “outgoing”.</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Then the outgoing lock is active and the subscriber can also receive calls.</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>This workaround works fine but it is a workflow nightmare to manually lock a customer/subscriber this way as long the fraud script is not working correctly.</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>But I am sure that you will find fast the solution to fix the fraud script problem<span class=apple-converted-space> </span></span><span lang=EN-US style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>J</span><span lang=EN-US><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks.</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><div><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span class=apple-converted-space><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Kirill Solomko [</span><a href="mailto:ksolomko@sipwise.com"><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>mailto:ksolomko@sipwise.com</span></a><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>]<span class=apple-converted-space> </span><br><b>Gesendet:</b><span class=apple-converted-space> </span>Samstag, 4. </span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Juni 2016 20:27<br><b>An:</b><span class=apple-converted-space> </span>Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>matthias.hohl@telematica.at</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>><br><b>Cc:</b><span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'><br><b>Betreff:</b><span class=apple-converted-space> </span>Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1 - URGENT</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US>Locking a single subscriber is not enough as the script checks and locks the whole customer and until the customer is locked it will keep send out the notifications.<o:p></o:p></span></p></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div><div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal><span lang=EN-US>On 04 Jun 2016, at 20:21, Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>> wrote:<o:p></o:p></span></p></div></div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Hello Kirill,</span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div><div style='margin-left:36.0pt'><div><p class=MsoNormal style='text-indent:-18.0pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>1.)</span><span lang=EN-US style='font-size:7.0pt;color:#1F497D'> <span class=apple-converted-space> </span></span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>my mail templates are valid since 1 year and send out to subcribers and customers without problems. Never had any problems with that before.. so don’t know which “value must be an integer” the error means :/</span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US><image001.png><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div><div style='margin-left:36.0pt'><div><p class=MsoNormal style='text-indent:-18.0pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>2.)</span><span lang=EN-US style='font-size:7.0pt;color:#1F497D'> <span class=apple-converted-space> </span></span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> yah that’s a good feature, that script tries to check the status, if a subscriber is locked or not, but the problem is, that also if I lock the subscriber manually (Edit Master Data and set “lock level to “outgoing”” the script still don’t stop the mail notifications.</span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US><image002.png><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div><div style='margin-left:36.0pt'><div><p class=MsoNormal style='text-indent:-18.0pt'><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>3.)</span><span lang=EN-US style='font-size:7.0pt;color:#1F497D'> <span class=apple-converted-space> </span></span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I also needed to deactivate “sslverify” in config.yml cause otherwise I got this error: </span><span lang=EN-US><o:p></o:p></span></p></div></div><div style='margin-left:70.8pt'><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>root@spce:~# /usr/sbin/ngcp-fraud-daily-lock</span><span lang=EN-US><o:p></o:p></span></p></div></div><div style='margin-left:70.8pt'><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>500 Can't connect to 127.0.0.1:1442 (certificate verify failed) Can't connect to 127.0.0.1:1442 (certificate verify failed)</span><span lang=EN-US><o:p></o:p></span></p></div></div><div style='margin-left:70.8pt'><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>SSL connect attempt failed error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed at /usr/share/perl5/LWP/Protocol/http.pm line 49.</span><span lang=EN-US><o:p></o:p></span></p></div></div><div style='margin-left:70.8pt'><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> So I thought maybe there is a problem with SSL certificate… cause I also don’t know how to fix that error… I added my wildcard certificate also for the restapi but if I enable “sslverify” I got still the same error.</span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Yah it would be very nice if you could verify this problem, cause it is very risky to have no automatic lock enable.</span><span lang=EN-US><o:p></o:p></span></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks!</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><div><div><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span class=apple-converted-space><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Kirill Solomko [</span><a href="mailto:ksolomko@sipwise.com"><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>mailto:ksolomko@sipwise.com</span></a><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>]<span class=apple-converted-space> </span><br><b>Gesendet:</b><span class=apple-converted-space> </span>Samstag, 4. </span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Juni 2016 19:54<br><b>An:</b><span class=apple-converted-space> </span>Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>><br><b>Cc:</b><span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'><br><b>Betreff:</b><span class=apple-converted-space> </span>Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1 - URGENT</span><span lang=EN-US><o:p></o:p></span></p></div></div></div></div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div><div><div><div><p class=MsoNormal><span lang=EN-US>The API access is fine as the fraud script is able to access the data.<o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US>I think there is an issue with the following when the script is trying to lock the customer:<o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div><div><div><div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[PATCH]/api/customers/231 TX=1454D6929806DE10 USER=system DATA={} MSG="" LOG="[{"value":"locked","path":"/status","op":"replace"}]"</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[PATCH 422]/api/customers/231 TX=1454D6929806DE10 USER=system DATA={} MSG="" LOG="{"message":"Validation failed. field='subscriber_email_template', input='4', errors='Value must be an integer'; field='passreset_email_template', input='5', errors='Value must be an integer'; field='invoice_email_template', input='6', errors='Value must be an integer'; field='invoice_template', input='2', errors='Value must be an integer'","code":"422”}"</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:9.0pt;font-family:"Helvetica",sans-serif'>and it causes the fraud detection script to stop processing the customer when an error occurs, therefore it tries over again next time until the customer is locked. It is by design that the warnings and lockings keep abusing the notify email until an action is taken (rather than silently ignore such occurrences).</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:9.0pt;font-family:"Helvetica",sans-serif'>Looks like there is something not right with your email templates, those (subscriber_email_template, passreset_email_template, invoice_email_template) are not used by the script however. I will check that internally and see what can be done there.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US>On 04 Jun 2016, at 12:30, Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>> wrote:<o:p></o:p></span></p></div></div></div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div><div><div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I have a hint, why it is maybe not working:</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I checked your script: “/usr/sbin/ngcp-fraud-daily-lock”</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>And saw that you doing the lock process over the API…</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Mybe there is the problem? That the script is working but the API access is not working?</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>If I check the log files I found this:</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>PANEL-DEBUG.LOG</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.debug) ngcp-panel: DEBUG: ++++++ Root::auto unauthenticated API request</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.debug) ngcp-panel: DEBUG: ++++++ Root::auto API request with system auth</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.debug) ngcp-panel: DEBUG: contract IDs to be locked: 231</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.debug) ngcp-panel: DEBUG: contract IDs 231 locked (0 secs)</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.debug) ngcp-panel: DEBUG: catchup contract 231 contract_balances (now = 2016-06-04 11:15:03)</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.debug) ngcp-panel: DEBUG: lang set by browser or config: i_default</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.debug) ngcp-panel: DEBUG: ++++++ Root::auto unauthenticated API request</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.debug) ngcp-panel: DEBUG: ++++++ Root::auto API request with system auth</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>API.LOG:</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:01 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET 401]/api/customerfraudevents/ TX=1454D6922154D1F0 USER= DATA={ 'interval' => 'day'} MSG="" LOG="Authorization required."</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET]/api/customerfraudevents/ TX=1454D69222D5A590 USER=system DATA={ 'interval' => 'day'} MSG="" LOG=""</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET 200]/api/customerfraudevents/ TX=1454D69222D5A590 USER=system DATA={ 'interval' => 'day'} MSG="" LOG="{ "_embedded" : { "ngcp:customerfraudevents" : { "_links" : { "collection" : { "href" : "/api/customerfraudevents/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/customerfraudevents/231" } }, "id" : 231, "interval" : "day", "interval_cost" : 7060.00011, "interval_limit" : 5000, "interval_lock" : 2, "interval_notify" : "</span><a href="mailto:fraud@telematica.at"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>fraud@telematica.at</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "reseller_id" : 2, "type" : "profile_limit", "use_reseller_rates" : 0 } }, "_links" : { "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "ngcp:customerfraudevents" : { "href" : "/api/customerfraudevents/231" }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/customerfraudevents/?page=1&rows=10" } }, "total_count" : 1}"</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET 401]/api/subscribers/ TX=1454D69281CC8F50 USER= DATA={ 'customer_id' => '231'} MSG="" LOG="Authorization required."</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET]/api/subscribers/ TX=1454D69282DE2660 USER=system DATA={ 'customer_id' => '231'} MSG="" LOG=""</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET 200]/api/subscribers/ TX=1454D69282DE2660 USER=system DATA={ 'customer_id' => '231'} MSG="" LOG="{ "_embedded" : { "ngcp:subscribers" : { "_links" : { "collection" : { "href" : "/api/subscribers/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "ngcp:callforwards" : { "href" : "/api/callforwards/254" }, "ngcp:calls" : { "href" : "/api/calls/?subscriber_id=254" }, "ngcp:customers" : { "href" : "/api/customers/231" }, "ngcp:domains" : { "href" : "/api/domains/1" }, "ngcp:journal" : { "href" : "/api/subscribers/254/journal/" }, "ngcp:reminders" : { "href" : "/api/reminders/?subscriber_id=254" }, "ngcp:subscriberpreferences" : { "href" : "/api/subscriberpreferences/254" }, "ngcp:subscriberprofiles" : { "href" : "/api/subscriberprofiles/1" }, "ngcp:subscriberprofilesets" : { "href" : "/api/subscriberprofilesets/1" }, "ngcp:subscriberregistrations" : { "href" : "/api/subscriberregistrations/?subscriber_id=254" }, "ngcp:voicemailsettings" : { "href" : "/api/voicemailsettings/254" }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/subscribers/254" } }, "administrative" : false, "alias_numbers" : [], "customer_id" : 231, "domain" : "xxxxxxxxxxxxxxxxx" } }, "_links" : { "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "ngcp:subscribers" : { "href" : "/api/subscribers/254" }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/subscribers/?page=1&rows=10" } }, "total_count" : 1}"</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:03 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[PATCH 401]/api/customers/231 TX=1454D69296DE8AB0 USER= DATA={} MSG="" LOG="Authorization required."</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[PATCH]/api/customers/231 TX=1454D6929806DE10 USER=system DATA={} MSG="" LOG="[{"value":"locked","path":"/status","op":"replace"}]"</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[PATCH 422]/api/customers/231 TX=1454D6929806DE10 USER=system DATA={} MSG="" LOG="{"message":"Validation failed. field='subscriber_email_template', input='4', errors='Value must be an integer'; field='passreset_email_template', input='5', errors='Value must be an integer'; field='invoice_email_template', input='6', errors='Value must be an integer'; field='invoice_template', input='2', errors='Value must be an integer'","code":"422"}"</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET 401]/api/emailtemplates/ TX=1454D692A176CAA0 USER= DATA={ 'reseller_id' => '2'} MSG="" LOG="Authorization required."</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET]/api/emailtemplates/ TX=1454D692A29CAD00 USER=system DATA={ 'reseller_id' => '2'} MSG="" LOG=""</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET 200]/api/emailtemplates/ TX=1454D692A29CAD00 USER=system DATA={ 'reseller_id' => '2'} MSG="" LOG="{ "_embedded" : { "ngcp:emailtemplates" : [ { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "ngcp:resellers" : { "href" : "/api/resellers/2" }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/13" } }, "body" : "Hello!\r\n\r\nCustomer # [% customer_id %] has been locked due to exceeding the configured\r\ncredit balance threshold ([% interval_cost %] EUR >= [% interval_limit %] EUR) in the [% type %] [% interval %] settings.\r\n\r\nAffected subscribers:\r\n[% subscribers %]\r\n\r\nPlease contact our support team if you need assistance.\r\nYour Telematica Support Team.\r\n\r\n--\r\nThis is an automatically generated message.", "from_email" : "</span><a href="mailto:support@telematica.at"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>support@telematica.at</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "id" : 13, "name" : "customer_fraud_lock_email", "reseller_id" : 2, "subject" : "Telematica Fraud Protection - Customer # [% customer_id %] locked" }, { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "ngcp:resellers" : { "href" : "/api/resellers/2" }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/14" } }, "body" : "Hello!\r\n\r\nCustomer # [% customer_id %] is currently exceeding the configured credit balance\r\nthreshold ([% interval_cost %] EUR >= [% interval_limit %] EUR) in the [% type %] [% interval %] settings,\r\nbut has not been locked due to configuration.\r\n\r\nAffected subscribers:\r\n[% subscribers %]\r\n\r\nPlease contact our support team if you need assistance.\r\nYour Telematica Support Team.\r\n\r\n--\r\nThis is an automatically generated message.", "from_email" : "</span><a href="mailto:support@telematica.at"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>support@telematica.at</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "id" : 14, "name" : "customer_fraud_warning_email", "reseller_id" : 2, "subject" : "Telematica Fraud Protection - Customer # [% customer_id %] exceeding limit" }, { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "ngcp:resellers" : { "href" : "/api/resellers/2" }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/6" } }, "body" : "Lieber Kunde,\r\n\r\nAnbei finden Sie den Einzelgesprächsnachweis mit der Nummer #[%invoice.serial%] für den Zeitraum von [%invoice.period_start_obj.month_name%], [%invoice.period_start_obj.year%].\r\n\r\nVielen Dank!\r\nIhr Telematica Team.\r\n\r\n-- \r\nDies ist eine automatisierte Nachricht.<span class=apple-converted-space> </span></span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Falls Sie Fragen haben, wenden Sie sich bitte an den Support per Mail unter<span class=apple-converted-space> </span></span><a href="mailto:support@telematica.at"><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>support@telematica.at</span></a><span class=apple-converted-space><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>oder telefonisch an +43 (0)5 056 400", "from_email" : "</span><a href="mailto:buchhaltung@telematica.at"><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>buchhaltung@telematica.at</span></a><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "id" : 6, "name" : "invoice_default_email", "reseller_id" : 2, "subject" : "Telematica: SIP Einzelgesprächsnachweis für [%invoice.period_start_obj.ymd%] bis [%invoice.period_end_obj.ymd%]" }, { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "ngcp:resellers" : { "href" : "/api/resellers/2" }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/5" } }, "body" : "Lieber Kunde, liebe Kundin,\r\n\r\nIhr Kennwort für das Self-Care Portal wurde zurückgesetzt.\r\nBitte klicken Sie auf folgenden Link um ein neues Kennwort festzulegen.\r\nPasswort zurücksetzen: [% url %]\r\n\r\nSie können sich nun wieder mit Ihrem Benutzernamen und Ihrem neu gesetzten Kennwort im Self-Care Portal einloggen.\r\nSelf-Care Portal:<span class=apple-converted-space> </span></span><a href="https://sip.telematica.at/r/n/r/nWir"><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>https://sip.telematica.at\r\n\r\nWir</span></a><span class=apple-converted-space><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>wünschen Ihnen weiterhin viel Spass mit unserem Produkt.\r\n\r\nVielen Dank!\r\nIhr Telematica Team.\r\n\r\n-- \r\nDies ist eine automatisierte Nachricht.<span class=apple-converted-space> </span></span><o:p></o:p></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET 401]/api/emailtemplates/ TX=1454D692ADDA2DA0 USER= DATA={ 'reseller_id' => 'NULL'} MSG="" LOG="Authorization required."</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET]/api/emailtemplates/ TX=1454D692AF1E9480 USER=system DATA={ 'reseller_id' => 'NULL'} MSG="" LOG=""</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Jun 4 11:15:04 spce (local0.info) ngcp-panel: INFO: IP=127.0.0.1 CALLED=API[GET 200]/api/emailtemplates/ TX=1454D692AF1E9480 USER=system DATA={ 'reseller_id' => 'NULL'} MSG="" LOG="{ "_embedded" : { "ngcp:emailtemplates" : [ { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/10" } }, "body" : "Credit threshold warning for: [% domain %]\nThe following contracts are below the configured threshold of [% threshold %]:\n\n[% contracts %]\n\nYour faithful Sipwise system\n\n-- \nThis is an automatically generated message. Do not reply.", "from_email" : "[% adminmail %]", "id" : 10, "name" : "credit_warning_default_email", "reseller_id" : null, "subject" : "Sipwise NGCP credit threshold notification" }, { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/11" } }, "body" : "Customer # [% customer_id %] has been locked due to exceeding the configured\n[% IF interval == \"day\" -%]daily[% ELSIF interval == \"month\" -%]monthly[% END -%] credit balance threshold ([% interval_cost %] >= [% interval_limit %]) in the [% type %] settings.\n\nAffected subscribers:\n[% subscribers %]\n\nYour faithful Sipwise system\n\n-- \nThis is an automatically generated message. Do not reply.", "from_email" : "[% adminmail %]", "id" : 11, "name" : "customer_fraud_lock_default_email", "reseller_id" : null, "subject" : "Customer # [% customer_id %] locked by fraud detection" }, { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/12" } }, "body" : "Customer # [% customer_id %] is currently exceeding the configured\n[% IF interval == \"day\" -%]daily[% ELSIF interval == \"month\" -%]monthly[% END -%] credit balance threshold ([% interval_cost %] >= [% interval_limit %]) in the [% type %] settings,\nbut has not been locked due to configuration.\n\nAffected subscribers:\n[% subscribers %]\n\nYour faithful Sipwise system\n\n-- \nThis is an automatically generated message. Do not reply.", "from_email" : "[% adminmail %]", "id" : 12, "name" : "customer_fraud_warning_default_email", "reseller_id" : null, "subject" : "Customer # [% customer_id %] exceeding fraud detection limit" }, { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/3" } }, "body" : "Dear Customer,\n\nPlease find your invoice #[%invoice.serial%] for [%invoice.period_start_obj.month_name%], [%invoice.period_start_obj.year%] in attachment of this letter.\n\nYour faithful Sipwise system\n\n--\nThis is an automatically generated message. Do not reply.", "from_email" : "</span><a href="mailto:default@sipwise.com"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>default@sipwise.com</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "id" : 3, "name" : "invoice_default_email", "reseller_id" : null, "subject" : "Invoice #[%invoice.serial%] from [%invoice.period_start_obj.ymd%] to [%invoice.period_end_obj.ymd%]" }, { "_links" : { "collection" : { "href" : "/api/emailtemplates/" }, "curies" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/#rel-{rel}</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "name" : "ngcp", "templated" : true }, "profile" : { "href" : "</span><a href="http://purl.org/sipwise/ngcp-api/"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>http://purl.org/sipwise/ngcp-api/</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>" }, "self" : { "href" : "/api/emailtemplates/2" } }, "body" : "Dear Customer,\n\nPlease go to [% url %] to set your password and log into your self-care interface.\n\nYour faithful Sipwise system\n\n-- \nThis is an automatically generated message. Do not reply.", "from_email" : "</span><a href="mailto:default@sipwise.com"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>default@sipwise.com</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>", "id" : 2, "name" : "passreset_</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><div><div><div><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span class=apple-converted-space><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Spce-user [</span><a href="mailto:spce-user-bounces@lists.sipwise.com"><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>mailto:spce-user-bounces@lists.sipwise.com</span></a><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>]<span class=apple-converted-space> </span><b>Im Auftrag von<span class=apple-converted-space> </span></b>Matthias Hohl<br><b>Gesendet:</b><span class=apple-converted-space> </span>Samstag, 4. Juni 2016 11:45<br><b>An:</b><span class=apple-converted-space> </span>'Kirill Solomko' <</span><a href="mailto:ksolomko@sipwise.com"><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>ksolomko@sipwise.com</span></a><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>><br><b>Cc:</b><span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'><br><b>Betreff:</b><span class=apple-converted-space> </span>Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1 - URGENT<br><b>Priorität:</b><span class=apple-converted-space> </span>Hoch</span><o:p></o:p></p></div></div></div></div></div><div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Hello,</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>this fraud protection module in 4.3.1 still DOESN’T work!</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I also use the latest updates.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>The subscriber doesn’t get automatically locked after reaching the fraud limit and the notification mail is send again, everytime the cronjob is running!</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>The Fraud Limit is only set in the billing profile and nothing edited at customer.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Customer settings:</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US><image001.jpg><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Billing Profile Settings:</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US><image002.jpg><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I received the notification mail:</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Customer # 231 has been locked due to exceeding the configured credit balance threshold (70.60 EUR >= 50.00 EUR) in the billing profile day settings.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I checked the subscriber and I saw that there was no lock level activated, and I still receive the notifcations mails now everytime again, when the cronjob runs, until I manually rise up the fraud limit on this customer in the customer settings.<span class=apple-converted-space> </span></span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>So I also can’t deactivate the notification mails. Also if I manually lock the subscriber I still receive the notifications until I raise up the fraud limit in customer settings or billing profile settings to be under the threshold.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>So all is definitely right configurated but your new fraud protection scripts doesn’t lock the subscriber.. I am speaking about that problem now for over 1 month and it doesn’t work.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Everything works fine before I updated to 4.3.1 with fraud protection and now ether subscriber nor customer will be locked any more by reaching the threshold.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>I don’t know why it is working on your fresh installed 4.3.1 version. But I don’t have a fresh installed version, maybe that is the problem, I don’t know.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Please fix this as soon as possible cause this is a very high security risk.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Thanks!</span><o:p></o:p></p></div></div></div><div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div></div><div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div></div><div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div></div><div><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span><o:p></o:p></p></div></div></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><div><div><div><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span class=apple-converted-space><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Spce-user [</span><a href="mailto:spce-user-bounces@lists.sipwise.com"><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>mailto:spce-user-bounces@lists.sipwise.com</span></a><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>]<span class=apple-converted-space> </span><b>Im Auftrag von<span class=apple-converted-space> </span></b>Matthias Hohl<br><b>Gesendet:</b><span class=apple-converted-space> </span>Freitag, 13.<span class=apple-converted-space> </span></span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Mai 2016 16:13<br><b>An:</b><span class=apple-converted-space> </span>'Kirill Solomko' <</span><a href="mailto:ksolomko@sipwise.com"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>ksolomko@sipwise.com</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>><br><b>Cc:</b><span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'><br><b>Betreff:</b><span class=apple-converted-space> </span>Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1</span><span lang=EN-US><o:p></o:p></span></p></div></div></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Hello again,</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Yeah definitely you have the excat same settings, how i did the setup at my side, but at me and the subsriber didn’t get a lock and the notification mail comes again and again and again and again everytime the cronjobs runs until I rise up the fraud limit.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I did no fresh install I just did a upgrade from 4.2.1 to 4.3.1 and did the last update && upgrade last week.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>This is in my billing profile: (lock monthly and daily all outgoing calls by reaching a limit and send mail.)</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US><image003.jpg><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>And this at the customer: (there is just “billing profile default” in every field.)</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US><image004.jpg><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>And if the call limit was reached, I just get the notification mails every time the cronjob runs but the subscriber never get locked.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I will test it today again after the latest update && upgrade. Once with billing profile lock limit and once with customer lock limit.</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Sure, I believe that It will work at your side, but just believe me, it didn’t work at me after an upgrade to 4.3.1 :D</span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><div><div><div><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span class=apple-converted-space><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Kirill Solomko [</span><a href="mailto:ksolomko@sipwise.com"><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>mailto:ksolomko@sipwise.com</span></a><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>]<span class=apple-converted-space> </span><br><b>Gesendet:</b><span class=apple-converted-space> </span>Freitag, 13.<span class=apple-converted-space> </span></span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Mai 2016 15:42<br><b>An:</b><span class=apple-converted-space> </span>Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'>><br><b>Cc:</b><span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif'><br><b>Betreff:</b><span class=apple-converted-space> </span>Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1</span><span lang=EN-US><o:p></o:p></span></p></div></div></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><div><p class=MsoNormal><span lang=EN-US>On 13 May 2016, at 14:40, Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>> wrote:<o:p></o:p></span></p></div></div></div></div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>Hello,<br><br>thanks for the info. I will do the update later today.<br><br>Okay.<br><br>Yah that’s the behavior I doing currently. But normally I have no customer fraud preferences and use always the billing profile defaults. So there is no need now for mixing.<br><br>Is the bug with the automatic lock also fixed? Cause currently I just get the notifications but the lock will not be done automatically, even if it is set "lock outgoing calls" in the billing profile fraud protection. I also tested it with customer fraud protection and also there the settings for lock outgoing calls if limit is reached but also there I just get the notification mail and no lock happened.<o:p></o:p></span></p></div></div></div></div></blockquote><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>I have tested it on a fresh mr4.3.1 CE and it worked just fine.<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>1. In the billing profile I set (customer fraud preferences are untouched):<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>fraud_daily_limit: 10 (means 10 cents)<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>fraud_dailty_lock: “all outgoing calls”<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>fraud_daily_notify: "myemail"<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>2. There are 2 cdrs with source_customer_cost = 1000 each (total: 2000).<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>3. Issued ngcp-fraud-daily-check and got this result (internal debug):<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><div><p class=MsoNormal><span lang=EN-US> id: 3<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> reseller_id: 1<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> interval: day<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> type: profile_limit<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> interval_cost: 2000.000000<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> interval_limit: 10<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> interval_lock: 2<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> interval_notify: “myemail"<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>use_reseller_rates: 0<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>4. And received the following email:<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>————<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>Customer # 3 has been locked due to exceeding the configured<br>daily credit balance threshold (20.00 >= 0.10) in the billing profile settings.<br><br>Affected subscribers:<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><a href="mailto:123456@1.1.1.1"><span lang=EN-US style='color:purple'>123456@1.1.1.1</span></a><span lang=EN-US><o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><a href="mailto:123457@1.1.1.1"><span lang=EN-US style='color:purple'>123457@1.1.1.1</span></a><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US><br>Your faithful Sipwise system<br><br>-- <br>This is an automatically generated message. Do not reply.<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>————<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>5. Status of the customer: "status: locked”<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>6. Status of the related subscribers: "status: locked”<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>7. When I open of the locked subscribers on the ngcp-panel I see <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div style='border:solid #FBEED5 1.0pt;padding:6.0pt 26.0pt 6.0pt 11.0pt;margin-bottom:15.0pt;text-shadow:rgba(255, 255, 255, 0.498039) 0px 1px 0px;border-top-left-radius: 4px;border-top-right-radius: 4px;border-bottom-right-radius: 4px;border-bottom-left-radius: 4px'><div><div><p class=MsoNormal style='background:#FCF8E3'><span lang=EN-US style='font-family:"Arial",sans-serif;color:#C09853'>Subscriber status is <b>locked</b></span><span lang=EN-US><o:p></o:p></span></p></div></div></div><div style='border:solid #FBEED5 1.0pt;padding:6.0pt 26.0pt 6.0pt 11.0pt;margin-bottom:15.0pt;text-shadow:rgba(255, 255, 255, 0.498039) 0px 1px 0px;border-top-left-radius: 4px;border-top-right-radius: 4px;border-bottom-right-radius: 4px;border-bottom-left-radius: 4px'><div><div><p class=MsoNormal style='background:#FCF8E3'><span lang=EN-US style='font-family:"Arial",sans-serif;color:#C09853'>Subscriber is locked for <b>outgoing</b></span><span lang=EN-US><o:p></o:p></span></p></div></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>8. When I issue “ngcp-fraud-daily-check” again it does nothing as the customer is already locked.<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US>9. When I call to any number from the locked subscriber I get “403 Caller Locked” on my phone and in kamalio-proxy.log I can see "Caller locked for outgoing with mode ‘2'"<o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></div><div><div><div><div><p class=MsoNormal>Kind regards,<o:p></o:p></p></div></div></div></div><div><div><div><div><p class=MsoNormal>Kirill<o:p></o:p></p></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'> <o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal style='margin-bottom:12.0pt'><br>Thanks.<br><br>-----Ursprüngliche Nachricht-----<br>Von: Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com"><span style='color:purple'>mailto:spce-user-bounces@lists.sipwise.com</span></a>] Im Auftrag von Kirill Solomko<br>Gesendet: Freitag, 13. <span lang=EN-US>Mai 2016 14:28<br>An:<span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br>Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1<br><br>Hi Matthias,<br><br>The new “interval” email template variable will be available later on today, affected packages: ngcp-billing-tools, db-schema (you have to issue “ngcp-update-db-schema" after the db-schema package upgrade).<br><br>As for the planned change to use “mixed” billing profile / customer fraud preferences, that will not be implemented, at least not in 4.3/4.4.<br>Currently you can either add a customer fraud preference (which takes preference over the billing profile once created) and if you no longer need it there is a “delete” button in the customer fraud preferences where after removal all the values are shown as “billing profile default”.<br><br>Kind regards,<br>Kirill<span class=apple-converted-space> </span><o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US>On 03 May 2016, at 16:45, Kirill Solomko <</span><a href="mailto:ksolomko@sipwise.com"><span lang=EN-US style='color:purple'>ksolomko@sipwise.com</span></a><span lang=EN-US>> wrote:<br><br><br><br><br><o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US>On 03 May 2016, at 15:54, Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>> wrote:<br><br>Hello again :)<br><br>1.) When do you believe this fix is coming?<br>Cause again another customer reached is daily limit and there was no<span class=apple-converted-space> </span><br>lock :/<br><br>Customer # 227 has been locked due to exceeding the configured credit<span class=apple-converted-space> </span><br>balance threshold (73.49 >= 50.00) in the billing profile settings.<br><br>It is currently a bit risky not to lock automatically :/<o:p></o:p></span></p></div></div></div></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US><br>Hi Matthias,<br><br>As I have mentioned before the core logic has not been changed in mr4.3 and such behaviour is also in our previous versions.<br><br>For now you can either override all the 3 customer fraud preferences or use none of them and the billing profile only.<br><br>The incoming improvement will allow to mix up the preferences so the inheritance customer preference -> billing profile will be used.<br><br>ETA: this/next week.<o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US><br>2.) Yah using GUI is good, but then you have to manually set the value back on next month :/ not so workflow friendly.<o:p></o:p></span></p></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US><br>As I have written in the previous reply you you can use "GUI for that and/or the API interface.”, where with our REST API interface you can automate it and well integrate into your own workflow.<br><br></span>Kind regards,<br>Kirill<o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'>thanks<br><br>-----Ursprüngliche Nachricht-----<br>Von: Kirill Solomko [<a href="mailto:ksolomko@sipwise.com"><span style='color:purple'>mailto:ksolomko@sipwise.com</span></a>]<br>Gesendet: Dienstag, 3. <span lang=EN-US>Mai 2016 15:33<br>An: Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>><br>Cc:<span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br>Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1<br><br><br><br><br><o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'>On 03 May 2016, at 15:26, Matthias Hohl <<a href="mailto:matthias.hohl@telematica.at"><span style='color:purple'>matthias.hohl@telematica.at</span></a>> wrote:<br><br>Hello,<br><br><br>-----Ursprüngliche Nachricht-----<br>Von: Kirill Solomko [<a href="mailto:ksolomko@sipwise.com"><span style='color:purple'>mailto:ksolomko@sipwise.com</span></a>]<br>Gesendet: Dienstag, 3. <span lang=EN-US>Mai 2016 13:23<br>An: Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>><br>Cc:<span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br>Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in 4.3.1<br><br>Hi Matthias,<o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US>On 02 May 2016, at 18:31, Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>> wrote:<br><br>Hello Kirill,<br><br>1.) the problem with the amount was just at one customer, another one, which was notified from billing profile monthly limit, was set correct.<br>2.) yah I know it is in cents not in EUR. Thanks for the advice how to change it.<br>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?<br>Yes, that was because you had mixed inheritance (part of the limits were billing profile and part customer based).<o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US><br>No definitely not. The limit was ONLY at the billing profile and NO setting on customer based. It was not one of my test subscriber, it was a totally different one. I got no lock. So something is wrong with the locking module.<o:p></o:p></span></p></div></div></div></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US><br>I think we are talking about the same. As I have mentioned earlier the upcoming “mixed inheritance” fix will address that.<span class=apple-converted-space> </span><o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US> <o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US>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?<br>Yes, if a customer fraud preference is unset/empty, inheritance to a related billing profile will take place. Currently it determines it only based on customer fraud interval limit.<o:p></o:p></span></p></div></div></div></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US> <o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US>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.<br><br>We do not add new features in already released versions, only fixes.<br>I honestly see no reason in that as such limitation may very well go out of control, as if you set this month for a certain lock level but next month you forget to re-enable it if you were about to occasionally.<br>An example: normal practice for mobile operators is to lock you out (for your own good) if you are over a certain sane daily/monthly usage threshold and send a text message or an email in our case.<br>You call your operator and ask them to manually unlock you, or if you are really that talkative request them to manually disable/shift the threshold.<br>I truly appreciate that idea but that feature will less likely be implemented however we will keep that in mind and perhaps morph it into something alike.<o:p></o:p></span></p></div></div></div></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US><br>Yah thats definitly what i wanted to say. the possibility to unlock a customer for the current billing period. Your example is exactly what I mean. If customer is over threshold, the operator can manually unlock for this period to a higher threshold level. If month is over, the old normal threshold level is back active.<o:p></o:p></span></p></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US><br>You should either use GUI for that and/or the API interface. No need for anything extra to accomplish the scenario.<o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'>Kind regards,<br>Kirill<o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'>-----Ursprüngliche Nachricht-----<br>Von: Kirill Solomko [<a href="mailto:ksolomko@sipwise.com"><span style='color:purple'>mailto:ksolomko@sipwise.com</span></a>]<br>Gesendet: Montag, 2. <span lang=EN-US>Mai 2016 16:31<br>An: Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>><br>Cc:<span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br>Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in<span class=apple-converted-space> </span><br>4.3.1<br><br>Hi Matthias,<br><br>I could not reproduce your scenario.<br><br>I have 30 cdrs for customer 5, for 2016-04-22 with 150 cents in sum().<br><br>mysql> select count(id), source_account_id,<br>mysql> date(from_unixtime(start_time)) from cdr group by 2,3;<br>+-----------+-------------------+---------------------------------+<br>| count(id) | source_account_id | date(from_unixtime(start_time)) |<br>+-----------+-------------------+---------------------------------+<br>| 10 | 5 | 2016-04-21 |<br>| 30 | 5 | 2016-04-22 |<br>| 10 | 41 | 2016-04-15 |<br>| 10 | 41 | 2016-04-22 |<br><br>Now the costs:<br><br>select sum(source_customer_cost), source_account_id,<br>date(from_unixtime(start_time)) from cdr group by 2,3;<br>+---------------------------+-------------------+---------------------------------+<br>| sum(source_customer_cost) | source_account_id |<br>| date(from_unixtime(start_time)) |<br>+---------------------------+-------------------+---------------------------------+<br>| 50.000000 | 5 | 2016-04-21 |<br>| 150.000000 | 5 | 2016-04-22 |<br>| 50.000000 | 41 | 2016-04-15 |<br>| 50.000000 | 41 | 2016-04-22<br><br>And customer_id 5 was triggered with the amount of 150 (cents). And the warning I received:<br><br>———————<br>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.<br><br>Affected subscribers:<br>…<br>———————<br><br>Please keep in mind that you enter values in cents (150 = 150 cents) where in the email you see them divided by 100.<br>You can however adjust your template and define it there as “1.50 EUR >= 0.20 EUR”.<br><br>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).<br><br>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.<br><br>Kind regards,<br>Kirill<o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US>On 01 May 2016, at 18:06, Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>> wrote:<br><br>Hello Kirill,<br><br>Any news about the Fraud Check update..?<br><br></span>Thanks<br><br>Von meinem iPhone gesendet<o:p></o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'>Am 26.04.2016 um 20:41 schrieb Matthias Hohl <<a href="mailto:matthias.hohl@telematica.at"><span style='color:purple'>matthias.hohl@telematica.at</span></a>>:<br><br>Hi kirill,<br><br>Oh okay. <span lang=EN-US>Good to know :)<br><br>Then I will wait.<br><br>Any update about the "lock" problem?<br><br></span>Thanks for your time.<br><br><br>-----Ursprüngliche Nachricht-----<br>Von: Kirill Solomko [<a href="mailto:ksolomko@sipwise.com"><span style='color:purple'>mailto:ksolomko@sipwise.com</span></a>]<br>Gesendet: Dienstag, 26. <span lang=EN-US>April 2016 19:34<br>An: Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>><br>Cc:<span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br>Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in<br>4.3.1<br><br>Hi Matthias,<br><br>It is not available yet, it is going to be available as a package<span class=apple-converted-space> </span><br>update nearest days.<br><br>Kind regards,<br>Kirill<o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US>On 26 Apr 2016, at 09:34, Matthias Hohl<span class=apple-converted-space> </span><br><</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>><o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US>wrote:<br><br>Hello,<br><br>i inserted [% interval %] in the mail template but it doesn't work.<br>I can't see the "daily" or "monthly" information in the notification mail.<o:p></o:p></span></p></div></div></div></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US> <o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-US><br>TEMPLATE:<br>Customer # [% customer_id %] has been locked due to exceeding<span class=apple-converted-space> </span><br>the configured credit balance threshold ([% interval_cost %] >=<span class=apple-converted-space> </span><br>[% interval_limit %]) in the [% type %] [% interval %] settings.<br><br>MAIL:<br>Customer # 6 has been locked due to exceeding the configured<span class=apple-converted-space> </span><br>credit balance threshold (178.59 >= 20.00) in the customer settings.<br><br><br><br></span>-----Ursprüngliche Nachricht-----<br>Von: Kirill Solomko [<a href="mailto:ksolomko@sipwise.com"><span style='color:purple'>mailto:ksolomko@sipwise.com</span></a>]<br>Gesendet: Montag, 25. <span lang=EN-US>April 2016 23:40<br>An: Matthias Hohl <</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>><br>Cc:<span class=apple-converted-space> </span></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br>Betreff: Re: [Spce-user] NGCP-FRAUD Protection doesn't work in<br>4.3.1<br><br>Hi Matthias,<br><br>Inline replies as following:<o:p></o:p></span></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><p class=MsoNormal><span lang=EN-US>On 25 Apr 2016, at 19:05, Matthias Hohl<span class=apple-converted-space> </span><br><</span><a href="mailto:matthias.hohl@telematica.at"><span lang=EN-US style='color:purple'>matthias.hohl@telematica.at</span></a><span lang=EN-US>><o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US>wrote:<br><br>3. Bug:<br><br>I also see that in the notifcation mail doesn't split between "daily"<span class=apple-converted-space> </span><br>or<o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US>"monthly" limit exceeded.<br><br>The variable will be exposed to the email templates as [%<span class=apple-converted-space> </span><br>interval %]<br><br>Kind regards,<br>Kirill<o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US><br>_______________________________________________<br>Spce-user mailing list<br></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br></span><a href="https://lists.sipwise.com/listinfo/spce-user"><span lang=EN-US style='color:purple'>https://lists.sipwise.com/listinfo/spce-user</span></a><span lang=EN-US><o:p></o:p></span></p></div></div></div></blockquote></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US> <o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US><br>_______________________________________________<br>Spce-user mailing list<br></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br></span><a href="https://lists.sipwise.com/listinfo/spce-user"><span lang=EN-US style='color:purple'>https://lists.sipwise.com/listinfo/spce-user</span></a><span lang=EN-US><o:p></o:p></span></p></div></div></div></blockquote><div><div><div><p class=MsoNormal><span lang=EN-US><br>_______________________________________________<br>Spce-user mailing list<br></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US style='color:purple'>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br></span><a href="https://lists.sipwise.com/listinfo/spce-user"><span lang=EN-US style='color:purple'>https://lists.sipwise.com/listinfo/spce-user</span></a><span lang=EN-US><o:p></o:p></span></p></div></div></div></div></blockquote></div></div></div></blockquote></div></div></div></div></blockquote></div></div></div></div></blockquote></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US>_______________________________________________<br>Spce-user mailing list<br></span><a href="mailto:Spce-user@lists.sipwise.com"><span lang=EN-US>Spce-user@lists.sipwise.com</span></a><span lang=EN-US><br></span><a href="https://lists.sipwise.com/listinfo/spce-user"><span lang=EN-US>https://lists.sipwise.com/listinfo/spce-user</span></a><span lang=EN-US><o:p></o:p></span></p></div></blockquote></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></div></div></body></html>