You can send all of your syslog data to a MySQL database using syslog-ng on a linux box. You can then use PHP to display the SQL queries in a table. It’s handy to see what’s going on with your equipment and doesn’t cost a thing!
Configure the MySQL database:
Configure this script to run (There are a few different ways to do it, just make sure it’s running all the time):
Now, configure your network equipment to send syslog to your linux machine:
I’ve also written a simple PHP script to display the syslog info in a table. No real filtering or sorting. I would just teak the SQL query if I wanted to see something differnet. It would be nice to have all the sorting and filtering built into the page, but I’m just not that good with PHP yet.
This is an example that I will work off of for the next project: