Here is what we will cover in this blogtorial:
- Installing and configuring MySQL - This will house the database and the necessary tables to organize the logs.
- Installing httpd/apache and PHP libraries - This will be the webserver to house the Syslog-ng web GUI front-end (phpsyslog-ng)
- Installing phpsyslog-ng - This will be the web based GUI to view the logs.
- Installing syslog-ng - This will be the app collecting the logs and sending it to MySQL.
Grab some chips, salsa and your favorite beer or a glass of wine because it is going to be a long one but in the end you should have a robust centralized log management system.