Need Help On Cacti;

hasan_sust · Post by **hasan_sust** » Mon Jul 20, 2009 4:47 am

Hi there

I need some help regarding Cacti.

1. I want to back up cacti data on daily basis with 5 minutes interval. For that case, I need to know the table name, which stores the values updated with 5 minutes interval. Also mention the procedure plz.

If it is not possible,

I have to convert .rrd files to .csv files in daily basis with 5 minutes interval. Instruct me how to do this. As I am new to cacti, So please give me instructions in details.

If any other method exists, please include.

Regards
Hasan

Post by **rony** » Mon Jul 20, 2009 6:22 am

Statistical data is stored in the RRDtool files and configuration data is stored in the mysql database.

You best bet is to backup the RRDtool files.

I you insist on getting the data out of the RRDtool files, then I would point you at the RRDTool documentation on for the RRDtool dump feature.

hasan_sust · Post by **hasan_sust** » Mon Jul 20, 2009 9:07 pm

Thanks for ur reply.

I have some more queries.

As I mentioned in previous post that, I have to backup cacti database daily basis. with 5 minutes interval. I need to automate the process.

In this context, what should be solution steps do you mention please.

More clearly, Should I have to made backup on rra/ directory under cacti within 5 minutes interval or after end of the day?

Secondly Which tools are required to convert these .rrd files to .csv files.

Finally I want to automate the process. Please reply.

Regards
Hasan

BSOD2600 · Post by **BSOD2600** » Mon Jul 20, 2009 10:59 pm

You want to backup every 5 minutes? ummm why? Anyways, use standard procedures to backup a MySQL database which is currently in use (google it). You'll also want to back up the files in your Cacti folder, especially the rrd files.

As rony already suggested, you use 'rrdtool dump' to convert rrd data xml, then you can do whatever you want with it.

As for automating the process, a simple script to execute the various things above using whatever language you want.

hasan_sust · Post by **hasan_sust** » Mon Jul 20, 2009 11:39 pm

I have to prepare reports daily basis, weekly basis on 5 minutes interval. If I am looking for last months data, using csv export from front end, csv files contains data for 24 hour interval.

I don't know the table in cacti mysql database, which contain the data updates within 5 minutes interval. please mention the table name.

If it is not possible, then there may be way to convert .rrd files to .csv?

Please mention in details. I google it for last 10 ~ 12 days. But Didn't get any specific solution.

Thanks in advance.

Br
Hasan

Post by **gandalf** » Thu Jul 23, 2009 8:17 pm

For reports, please see the REPORTIT plugin.
Reinhard

Post by **gandalf** » Sun Jul 26, 2009 10:40 am

Last post splitted off to Plugin Forum
Reinhard

Need Help On Cacti;

Need Help On Cacti;

Who is online