Very new here - Need mysql reporting tool for Centos

[james corona]

Greetings.

i have an issue that I have been trying to solve, but cannot find a solution:

I am running an IDS with a mysql database (EasyIDS)

I need a tool to make a report with charts and whatnot of the database, so that I can send this on a daily basis to our client.. Snorby does it, but I was not able to find out how.

Are there any programs for CentOS that have this ability? I already have sendmail set up, and can send email from the server. I just have no way to generate reports into a PDF, and then email them out, just like snorby does..

If anyone has any good ideas, I could really use it.. Lol.. I have been racking my brain for 2 weeks to get this working and stable, and now the only step in the process that I have left are these daily graphical reports about the IDS

thanks in advance :D