Data Source Import Script for NON-CACTI created RRD's

[o019676]

My first attemp at a contribution.

BACKUP YOUR CACTI DATABASE FIRST!!!!
THIS IS BETA CODE FOR NOW!!!!!
TREAT IT AS SO!!!

Feel free to email me any changes you might want or bugs in the script.
I will update accordingly and repost!!

webwillow@thewebwillow.com
donald.t.gullett@jpmchase.com

standby for a add_graph script for adding graphs for these as well!!

Make a data template for your RRD's that you want to mass import.
YOU MUST HAVE A DATA TEMPLATE FIRST...VERY IMPORTANT!!

BIG NOTE!! you can only make one data source per host per data template, i made this part so that i dont accidently create the data source twice. and so i can do a mass import and if the datasource for that host and template is already created, it will skip on to the next one. I run the script every morning.

download this script (bash script)

gunzip -dc <filename>|tar xvf -

chmod 755 add_datasource.sh

edit the global file and add your configuration (i.e. where mysql is etc)
i use nagios with this and other scripts to import nagios hosts that use the global file, remove those if you wish, shouldnt hurt it if you leave them there.

use the -h or --help option to get how to use the script.
./add_datasource.sh --list
note the number of the data template you want
./add_datasource.sh --hostlist
note the number of the host you want
note the location of your rrd file
./add_datasource.sh -D <data template number> -H <hostid> --rdd <rrd file>

example:

./add_datasource.sh -D 61 -H 111 -rrd /usr/local/nagios/nagiosgraph/rrd/gti0l012_ROOT_disk.rrd

also can be used to list host id numbers, data template id's and existing data source id's with the correct option

so far works great for me!!!

[o019676]

NOTE: ALWAYS BACKUP YOUR CACTI DATABASE BEFORE USING THIS SCRIPT!!!!!!!

THIS IS BETA SCRIPT AND SHOULD BE USED AS SO!!!!!!

Attached file has an addition script to the above posted file.

Use one file to add the datasource and the other to add the graph to the datasource.

You must have a data template and a graph template created in cacti itself for the adds to work.

Also make sure that you make the data template correctly with the template pointing to the datasource cdef's (i think thats the correct way to say it).

The script dredges the mysql database for the templates to properly add the datasource and the graphs properly.

I just ran 10 test of adding over 1000 graphs that are attached to nagios created RRD's via nagiosgraph with a seperate script which i will provide later. I would include it here as well but some finishing touches and much needed input from other users are need before i post the code with the nagios script.

Always use -h or --help with this script on the command line to get help on the use.

Just like the other script, you must provide a graph template number, host id, and a datasource it.

try using --list --datsourcelist or --hostlist to get the info you need.

GOOD LUCK!!!!

Working great for me so far!

[o019676]

Had to edit the above global file.

same contents with slight change to the global file.

cant upload files with internal passwords...whoops

[ruben]

I haven't gotten around to play with your scripts yet. But I do want to thank you in advance for the effort.
The last few days I spend most my time on creating and auto-updating a 'large' sum of RRD files (8 Class C subnets, 1 RRD per IP). Since I didn't feel like creating 2000+ data sources and yet another 2000+ graphs, these scripts will most likely be of much help to me.

[o019676]

Just wondering if i could get some feedback from anyone else who has used it?

[ruben]

[fiksve]

Exactly what I needed! This is a great tool for us who dont use the cacti poller system, but rely on specialized mechanisms to generate the rrds -- Thanks!