Hi Cami, I'm rewatching my logfiles and rebuilding my whitelist and blacklist dnsnames entries.
While i was doing that, i was thinking of maybe an easy way of monitoring policyd accept/blocking of messages, basically for getting this information and throwing at some Cacti/RRDTool graphic. I noticed i wouldnt be able to do that easy: i would have to grep log, count things ...... it's possible, but it would have high cost, because i deal with some BIG logfiles ... even rotating them daily, they get pretty big. Grepping them every 5 minutes wouldnt be nice for I/O. And i dont want that :) So, i was thinking of maybe getting policyd a new feature .... a statistics table that would hold basically two columns: one for the action name (whitelist_dnsname, blacklist_dnsname, greylist=new, greylist=update, blacklist_helo, throttle actions and all the others) and other column for an integer/big-integer counter, that would always receive +1 when that action happens. That could be done in a single query: update statistics_table set count=count+1 when action_name='something'. With this table, which i dont think would be that hard to implement, some easy perl/PHP script could be written for grabbing the information and making some monitoring graphs build VERY easily. Updating tables always have some I/O cost ..... but as this being a very small table, even we have 40-50 actions, i doubt it would increase I/O in a noticable way. But of course, this can be easily be a configurable option. What do you think on that ??? -- Atenciosamente / Sincerily, Leonardo Rodrigues Solutti Tecnologia http://www.solutti.com.br Minha armadilha de SPAM, NÃO mandem email [EMAIL PROTECTED] My SPAMTRAP, do not email it ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ policyd-users mailing list policyd-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/policyd-users