External graph instanciation

[MisterG]

Hi,

I am coding some perl scripts to update RRD files and Cacti objects. The scripts create the device, data template, grah template and data sources.

The last update fails : I cannot link an instantiated graph to its data sources.

Can you tell me where to look in the source code to find the right SQL queries?

Mat

[BSOD2600]

For starters, turn on graph debugging to find out why the graph won't render.

[MisterG]

The graph_templates_item is not completely updated.

Can you confirm my algorithm ?

Code: Select all

foreach datasource
    get its graph_local_id
    foreach "SELECT * FROM graph_templates_item WHERE graph_template_id=<gt_id> AND local_graph_id=0"
        create the graph_template_item
    done
done

[BSOD2600]

You do know cacti comes with scripts for the creation of all that stuff, right? \cacti\cli\ directory.

[Hyperlord]

I don't get the problem anyway ...

[MisterG]

I used add_graphs.php but I need to define RRD files' path. I use one RRD file per datasource.

For example :

• load 1 : /var/www/html/cacti/rra/myhost/load/load1.rrd
  load 5 : /var/www/html/cacti/rra/myhost/load/load5.rrd
  load 15 : /var/www/html/cacti/rra/myhost/load/load15.rrd

I would need to update manually either.

Is it possible to specify each datasource path ?

[BSOD2600]

Is it possible to specify each datasource path ?

Nope.

[MisterG]

I can use add_graphs.php to create the data sources and the graph. Then I update "the data_source_path" in "data_template_data".