Inbound/Outbound Data Source the same after changing templat

[tomate]

Hello guys,

I found something weird : When I change a graph template (from "Traffic bits/sec, total bandwidth" to "Traffic bits/sec, 95th percentile"), Inbound Data Source and Outbound Data Source are the same and are traffic_in

I have to manualy change Outbound Data Source to traffic_out for every graph
that would'nt be a pb except I have hundreds of graphes

Maybe can I use a command line in mysql to change that ?
Or anything else ???

thanx

[gandalf]

As a start: see table graph_templates_item, the column is task_item_id. But IMHO, the update sql would be a bit tricky (if any)
Reinhard

[tomate]

As a start: see table graph_templates_item, the column is task_item_id. But IMHO, the update sql would be a bit tricky (if any)
Reinhard

what can i do with this column ?

the problem is the same when I make changes in a bulk or one by one :/

[gandalf]

Thze task item id refers to the data source being graphed. If you can find out, what data source should be presented, you may update this in the table. But finding out isn't that easy, as I said ...
Reinhard

[tomate]

Yes i will check this out
But i don't think it is the solution.
I think there is something happening when I use the function that changes the graph type, but i can't figure out why

[tomate]

here what's happening when i change the graph type :


Here the graph I want to change (in graph managment) :






Here when I have modified the type (as you can see, something in the graph has to be added) :






and the result is "outbound data source" = "inbound data source" :

[gandalf]

Will ask a dev. I don't know that much about this procedure
Reinhard

[tomate]

thx

[raX]

I am currently aware of this behavior. The problem here is that the 95th percentile and the regular bit/sec graph templates have a different number of items so when you change from one to the other the selected data source items do not align correctly. Keep in mind that the data source item dropdowns are not templated, so Cacti does not change the values of these fields when a template changes.

Having a "change template" feature is nice, but it is really only useful for changing between graph templates that are more or less identical. Anything more than that and it is almost worth creating a new graph from scratch and hooking up the existing data sources to it.

Perhaps there is a better way to handle this procedure that I am overlooking. I am always open to suggestions on how we could better handle this in 0.9.

-Ian

[tomate]

ok thx

I think indeed the best way is to create new graphs from scratch

[thomasw]

Hello All,

today I found out that a lot of my graphs lost their outbound datasource item, which is connected to the inbound one. All graphs showing up wrong data on that. It seems that this happens during update from 0.8.6.h to 0.8.6j.

Has anyone an idea on how to fix this for thousands of graphs?
Any input is highly welcome.

thanks in advance,

tom

[TheWitness]

Any chance on updating to 0.8.7a?

TheWitness

[thomasw]

Hello,

sorry for the late reply.

I tried the update from 0.8.6.j to 0.8.7a without success on the given issue. Any ideas on howto recreate the association from inbound graph to inbound ds and outbound graph to outbound ds via database?

Any help is highly welcome!

thanks in advance,

tom

ps: i have done the upgrade on a different machine (copied db and rra`s). the prod machine still has the issue.

[amentges]

just to throw my two cents in, I am having the exact same issues, and I have also updated to 0.8.7a without success on the issue

[mattmann72]

I have the same problem.

I cannot find where in the database to reconnect the Graph to the data source. Can someone please explain how this all glues together?