[asterisk-users] Automating blacklists

[Lenz]

Yeah I would use MySQL as well for more or less the same reasons. Using  
MySQL right from the dialplan is not very elegant but it's pretty simple -  
see http://www.voip-info.org/tiki-index.php?page=Asterisk%20cmd%20MYSQL
Thanks
l.



On Thu, 18 Oct 2007 16:49:48 +0200, Brian Hutchinson  
<b.hutchman at gmail.com> wrote:

> I feel more comfortable with MySQL ... just need to learn how to get the
> dialplan to use it.
>
> Also figure out the pro's/con's to MySQL vs AstDB.  If I used MySQL then  
> I
> could put myphpadmin and get a pseudo GUI to manipulate the blacklist
> database for almost no effort so that is another reason for leaning  
> towards
> MySQL.
>
> Thanks for the nudge toward MySQL.
>
>
> On 10/18/07, Lenz <lenz-ml at loway.it> wrote:
>>
>>
>> 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
>>
>> _______________________________________________
>> --Bandwidth and Colocation Provided by http://www.api-digital.com--
>>
>> asterisk-users mailing list
>> To UNSUBSCRIBE or update options visit:
>>    http://lists.digium.com/mailman/listinfo/asterisk-users
>>



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