<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi again.<br>
<br>
I have tested, and I can asume it works like I supposed. The fraud
only compares de free cash you have assigned to the account, if I
haven't make any mistake in my configuration.<br>
<br>
Anyway, I have realized it doesn't send any email if you set
"Fraud Lock" to none. I have modified the query I talked about in
my last mail. The condition I changed is this:<br>
<br>
<small>p.fraud_interval_lock<br>
OR p.fraud_interval_notify<br>
</small>And I have changed for it:<br>
<small>p.fraud_interval_lock<br>
OR p.fraud_interval_notify<>''<br>
<br>
</small>It seems to work better now. Any improvements?<br>
<br>
El 10/07/2012 13:32, Mario Contreras escribió:<br>
</div>
<blockquote cite="mid:4FFC12EB.4030107@innovasur.es" type="cite">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<div class="moz-cite-prefix">Thanks for the quick answer, Jon.<br>
<br>
I haveseen this query in the script:<br>
<br>
<small>SELECT c.id, p.fraud_interval_lock,
p.fraud_interval_notify,<br>
b.cash_balance_interval, p.fraud_interval_limit<br>
FROM contracts c, billing_profiles p,
contract_balances b<br>
WHERE p.id = (SELECT m.billing_profile_id<br>
FROM billing_mappings m<br>
WHERE ( m.start_date IS NULL<br>
OR m.start_date <= now())<br>
AND ( m.end_date IS NULL<br>
OR m.end_date >= now())<br>
AND m.contract_id = c.id<br>
ORDER BY m.start_date desc limit 1)<br>
AND b.contract_id = c.id<br>
AND b.start <= now()<br>
AND b.end >= now()<br>
AND c.status = 'active'<br>
AND p.fraud_interval_limit > 0<br>
AND ( p.fraud_interval_lock<br>
OR p.fraud_interval_notify)<br>
AND b.cash_balance_interval >=
p.fraud_interval_limit</small><br>
<br>
If I understand correctly, the value cash_balance interval
depends on the free cash you give to your customers every
billing interval. So, it doesn't work if you configure to zero
the interval free cash? Maybe my configuration is wrong, beacuse
for all my contracts the cash_balance_interal is equal to zero.
However, in one of my billing profiles I have selected free
time, and both free_time_balance and free_time_balance_interval
have the correct values.<br>
<br>
Am I doing anything wrong? Thanks again!<br>
<br>
<br>
El 10/07/2012 12:58, Jon Bonilla escribió:<br>
</div>
<blockquote cite="mid:20120710125842.645d8c0d@quenya" type="cite">
<pre wrap="">El Tue, 10 Jul 2012 12:36:26 +0200
Mario Contreras <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:mario.contreras@innovasur.es"><mario.contreras@innovasur.es></a> escribió:
</pre>
<blockquote type="cite">
<pre wrap="">Hi all,
When it's called the script that check the frauds configured in the
billing profiles? I have a subscriber that has exceded in 150 € the
limit, but rateomat has been stopped a few hours. Anyway, I have already
activated rateomat but I haven't received any notification and the
subscriber can make calls (I think so, I don't know where look for if
it's or not blocked).
So, in summary, where can i consult if a subscriber is blocked? And, how
rateomat acts to notify the fraud?
</pre>
</blockquote>
<pre wrap="">
rate-o-mat does not take care in the fraud checking. It just rates. It's a cron
job. You can find it in /etc/cron.d/
The script itself is /usr/sbin/ngcp-fraud-auto-lock You can call it manually or
check the code.
The status of the subscriber can be checked via soap/xmlrpc and in the
www-admin interface.
_______________________________________________
Spce-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.sipwise.com/listinfo/spce-user">http://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
<br>
</blockquote>
<br>
<br>
</body>
</html>