I have done something similar for a traffic/monitoring support site. I have everything in a mysql db. I did this in order to create a administration site for RRDs. I can automatically scan routers and Xedia APs and register their OIDs. Afterwards someone can choose to create real datasources from the ones I found on the routers that I scanned. Or he can specify an other OID or a command to get data from. Then he can group them into rrds (where he can specify whatever options needed for RRDs) and collecting begins. I also integrated the graphs part into mysql. They can be defined in the database and there's a separate db where you can create users and categories in order to show them on your web-site. Because we are a Frame-Relay provider I have added some features such as CIR overruns calculations and so on to the web-site and the db, but it can be used just to draw a red line on the graphs. All of this is done in perl and php. No C. Perhaps I should rewrite the collecting part in C. Yet, it doesn't touches any parts of rrdtool. I guess this is an other approach. Anyhow it's under development (the parts I mentioned before are working) and given the fact that I'm a Cisco engineer my time for this very limited.
Best regards, Cristian Caramida ----- Original Message ----- From: Don Kukral <[EMAIL PROTECTED]> To: rrd-developers <[EMAIL PROTECTED]> Sent: Wednesday, November 29, 2000 5:36 AM Subject: [rrd-developers] MySQL Integration > > Hello, I'm trying to allow rrdtool to get it's source information from > a MySQL database (or any other database for that matter). I was just > curious if anyone else would find this useful and if there are any > suggestions on implementing this. > > Right now the plan is to create an rrd_fetch_mysql.c module and then > modify rrd_graph.c to use the fetch method there based on the > datasource. I'm trying to be as non-intrusive to rrdtool as possible. > Any suggestions on other approaches to this would be greatly welcomed. > > Thanks, > Don Kukral > > -- > Unsubscribe mailto:[EMAIL PROTECTED] > Help mailto:[EMAIL PROTECTED] > Archive http://www.ee.ethz.ch/~slist/rrd-developers > WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi -- Unsubscribe mailto:[EMAIL PROTECTED] Help mailto:[EMAIL PROTECTED] Archive http://www.ee.ethz.ch/~slist/rrd-developers WebAdmin http://www.ee.ethz.ch/~slist/lsg2.cgi
