Cacti v1.2.23 Many graphs - graph titles not updating

[ciela2]

graph_templates_graph.title in cacti db not updating with latest query information.

I see this in the cacti db. Also when I pull up a graph from Management > Graphs > select graph, the graph title at the very top of the page has the current query results.:

<router-name> 601 xe-7/0/2-->|query_ifAlias| |query_ifIP| bits/s (this is correct)

But the .png image of the graph has older query results and the title in the RRDtool command is incorrect as well.

--title='router-name 601 xe-7/0/2-->router2-name_xe-7/0/1 |query_ifIP| bits/s' \ (this is old)

I have rerun/reindexed the queries, but this did not help.
Reapply suggested names does not work either.

If anyone knows how to fix this - please advise.
Thanks for any help

[Osiris]

There was a slight change in behavior that has not been to date rectified you have to periodically reapply suggested names from the cli. I do mine through Cron

[ciela2]

Ok thanks - I'll try the cli script - reapply suggested names doesn't work in the gui.

Will update if this works.
Appreciate it.

[ciela2]

I ran this from the cli directory:
php poller_graphs_reapply_names.php --host-id=all --debug

But the graph titles are still wrong.
Glancing at the reapply names script - it's applying the value in graph_templates.graph: title_cache - but this value is wrong/out of date. Looks like the title_cache is not getting updated with new indexed values. I have reloaded the queries a number of times from the device page & the device > create graphs page.

Let me know if there's anything I can check for why this would be or how to update the title_cache.

Thanks.

[Osiris]

You should re-index the devices and they will pick up the new suggested names this is normally automatic.

[ciela2]

Thanks for the response Osiris.

I've reindexed one of the hosts from the web interface and also tried running the cli script:

php poller_reindex_hosts.php --id=68 --force --debug.

But still the graph titles in the graph.png files and in Graph Management table list and in the legends under the graphs in the graph trees do not change.

Please let me know if there's anything else I can try.
Thank you

[TheWitness]

Check to see if they are orphans, there is a checkbox/selection for that. Also run the "Re-apply Suggested Names" from the GUI or the CLI. If the names are wrong, and they don't change, then, if they are not orphans, I would be curious to know what is happening.

In the latest Cacti, when the Graph looses association with it's index, the name will not change to 'Blah - |query_something|' like it used to. If you edit the Data Source, you should see the ifIndex and values all filled out as you expect them too. If now, you might have to do a cleanup. There were a few Cacti releases between 1.2.15 and 1.2.19 where problems occurred for some installs.

[ciela2]

If I click the Orphaned graph box - no graphs are listed.

Nothing happens when I attempt to re-apply suggested names, even though the name that comes up as the suggested name is correct. The existing incorrect graph title stays the same.

Here is a title I know is out of date/incorrect:
juniper router-1-May2023 601 xe-7/0/2-->router-2 xe-7/0/1 |query_ifIP| bits/s This is out of date

Re-applying suggested Names:
"Reapply Suggested Names
Click 'Continue' to re-apply suggested naming to the following Graph(s).

juniper router-1-May2023 601 xe-7/0/2-->|query_ifAlias| |query_ifIP| bits/s (Down)" This is the correct title

It looks to me like the title_cache field isn't getting modified.
Unfortunately haven't kept track of the revisions this Cacti instance has been on, but I believe 1.2.19 was one of them

Thanks for the response, please let me know what else I can look at or try.

[TheWitness]

Basically the Graph has lost it Index association. Edit the Data Templates one at a time and fix them.

[ciela2]

Here's the data source entry for one of the graphs with a outdated title:

Screen Shot 2023-08-15 at 2.38.44 PM.png (43.1 KiB) Viewed 1075 times

The entries look correct to me. In our case ifDescr = ifName = same value.
Sorry to say but I've never understood those Custom Data fields. Are they determined by the SNMP query?<index_order>ifDescr:ifName:ifHwAddr:ifIndex</index_order> ? or something else.

Thanks for responses, hope to get this fixed even If I have to manually edit every entry.

I'm able to execute MySQL commands on the cacti database, please let me know if something can be determined that way.

[Osiris]

Have you checked the poller cache? Are the entries there?

[ciela2]

Thanks Osiris - looking at the poller cache. I only see the normal traffic SNMP queries.

Should I be seeing something else when applying suggested names?

Thanks.

[TheWitness]

So, this is not our standard interface graph. I would edit that Data Query and see if the suggested names for the various graphs are intact. For the standard interface graphs it should look like the image below. If you don't see something like that, it may benefit to re-import the Data Query from the original source. Cacti 1.2.25 should be out soon too. It should be a good upgrade. I'm not sure anything in the 1.2.23 range had any issues but there were some in the 1.2.16-1.2.19 time range.

[ciela2]

Thanks so much for your answer & example TheWitness.
We did not have "Suggested Values" for our Juniper traffic graphs to cover all of the conditions.
After adding them & reindexing all of our devices and Reapplying suggested names to the graphs, I thought I'd have the problem solved...

Unfortunately on our production Cacti server (still on version 0.8.8h) a significant number of older/long running graphs still do not get updated titles. The graph titles still have "[query_ifIP|" & "|query_ifAlias|" in the titles instead of being taken out of the titles. These older graphs have probably been through a number of older Cacti versions. But I'm struggling to try to come up with an explanation for why they won't update. Or what to do about it.

This issue arose after I wrote a script to keep our production Cacti server (0.8.8h) and our dev Cacti server (1.2.23 w/automation) in sync by comparing the graph titles between them. Did not expect to hit so many roadblocks.

Please share any thoughts or suggestions on why older graph titles will not take suggested names.
Thanks.

[TheWitness]

Upgrade the old Cacti would be the best thing to do if you want support from the forum. I don't even think in the language of the old Cacti 0.8.x tool. I don't get paid for my time here either. It is what it is. I'm helping keep the lights on. Cacti does work after all.