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 <[EMAIL PROTECTED]> 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 > <[EMAIL PROTECTED]> 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 >
_______________________________________________ --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