[asterisk-users] Automating blacklists

[Lenz]

It's not technically complex to do - you can probably use the astdb for  
that, or store all incoming numbers with timestamp in MySQL and run  
something like:

SELECT count(*) > 5 AS blacklisted
 FROM incoming_calls
WHERE callerid = "12345"
AND timestamp > DATE_SUB( NOW(), INTERVAL 15 MINUTE )

you should be very well aware of the risks that can stem from such a  
program - in case of bugs, or anomalous situations, you might end up  
blacklisting somebody who actually needs to call in.

I hope this helps
l.










On Thu, 18 Oct 2007 15:02:11 +0200, Brian Hutchinson  
<b.hutchman at gmail.com> wrote:

> Hi,
>
> I've been reading all I can on Google (and Asterisk TFOT book) looking  
> for
> ideas on how to implement an automated blacklist feature.
>
> I would like to automatically blacklist a incoming number based on  
> timestamp
> and count information.
>
> For example, if I get a prank call from the same number 5 times within 15
> minutes, I want my dialplan to automatically blacklist this number.
>
> Should I be looking at AGI to do something like this?
>
> Thanks for any ideas or pointers!



-- 
Loway Research - Home of QueueMetrics
http://queuemetrics.com