twitter |   ||  email | PGP --> harshal @

r00tst1llsabout m3

generating stats with your firewall | part - 3

there are two more shell scripts that i created to keep updating the database. i created them because my database was sqlite. i will remove kernellog data after 1 month but i still want to retain the monthly counts. therefore i created scancounts table. what this will do is at the beginning of the month it will remove all the entries of the previous month and insert the final total of that month in scancount table. see the script

download shell script and save as .sh

the second one runs every hour. this is an update script to scancount table. i named it

download shell script and save as .sh

thats brings us to the end. this is purely based on shell scripts, kernel logs and sqlite. there are no other programs installed. my website has analyt1cs section which i created using php pages. you can do the same you can start mining the data in sql scripts and create meaningful reports. this is just a humble attempt to create reports without installing a ton of software. ofcourse the reports are not that great but surely workable. i have made code public, so that intelligent folks can take a look and correct me where i am wrong.