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