I feel more comfortable with MySQL ... just need to learn how to get the dialplan to use it.<br><br>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.
<br><br>Thanks for the nudge toward MySQL.<br><br><br><div><span class="gmail_quote">On 10/18/07, <b class="gmail_sendername">Lenz</b> <<a href="mailto:lenz-ml@loway.it">lenz-ml@loway.it</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>It's not technically complex to do - you can probably use the astdb for<br>that, or store all incoming numbers with timestamp in MySQL and run<br>something like:<br><br>SELECT count(*) > 5 AS blacklisted<br> FROM incoming_calls
<br>WHERE callerid = "12345"<br>AND timestamp > DATE_SUB( NOW(), INTERVAL 15 MINUTE )<br><br>you should be very well aware of the risks that can stem from such a<br>program - in case of bugs, or anomalous situations, you might end up
<br>blacklisting somebody who actually needs to call in.<br><br>I hope this helps<br>l.<br><br><br><br><br><br><br><br><br><br><br>On Thu, 18 Oct 2007 15:02:11 +0200, Brian Hutchinson<br><<a href="mailto:b.hutchman@gmail.com">
b.hutchman@gmail.com</a>> wrote:<br><br>> Hi,<br>><br>> I've been reading all I can on Google (and Asterisk TFOT book) looking<br>> for<br>> ideas on how to implement an automated blacklist feature.<br>
><br>> I would like to automatically blacklist a incoming number based on<br>> timestamp<br>> and count information.<br>><br>> For example, if I get a prank call from the same number 5 times within 15<br>
> minutes, I want my dialplan to automatically blacklist this number.<br>><br>> Should I be looking at AGI to do something like this?<br>><br>> Thanks for any ideas or pointers!<br><br><br><br>--<br>Loway Research - Home of QueueMetrics
<br><a href="http://queuemetrics.com">http://queuemetrics.com</a><br><br>_______________________________________________<br>--Bandwidth and Colocation Provided by <a href="http://www.api-digital.com--">http://www.api-digital.com--
</a><br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote>
</div><br>