Fellow friends in PHP,
I turn to you in great frustration regarding my search for a general-purpose log file analyzer.
You're probably saying "why are you posting about log analysis here, idiot."
Well, because since it appears that I cannot find a log analysis product that fits my needs, I'm tempted to write a PHP script that does fit my log analysis needs and I want your feed back on if there is a better way to go about this madness.
Here's what my ideal log analyzer would do:
-Apache: report all information about who is accessing my web server (IP, time, browser, OS, etc). Also report on any errors. For this information I can look to AWstats, Webalizer, etc. But there's a lot more information I want reported. Keep reading.
-MySQL: report who is accessing the database, time of access, queries used, any errors, etc.
-PHP: report any errors that might have occurred.
-SSH: report who is accessing the SSH server, time of access, IP the server was accessed from, etc.
-IPtables: report on successful and denied requests, scans, attacks, etc.
-System logs: report on any operating system errors, etc.
It would be ideal if such a program could generate one master report, each section of the report containing information about a different log file. I'm developing an administrator webpage for my website where I can edit my database and hopefully setup my theoretical log analyzer to generate a master report on the criteria above, at the click of a button. That's where the PHP script comes into play - it IS the log analyzer
Please tell me such a product exists. If not, what magnitude of a project are we talking here?
Again, if there's a better way to go about all of this, please, do tell. All feedback is welcomed.
Thanks,
Nick
