[asterisk-users] Automating blacklists

[Brian Hutchinson]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20071018/ba622ec4/attachment.htm