<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<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 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 class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a 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>
</body>
</html>