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

Reply via email to