Data Sources missing after MySQL upgrade

[acceleratebiz]

All of our .rrd files are in the rra directory and when you click on "Data Sources" under Management of the Console, you get "Showing Rows 1 to 30 of 592 [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20...]" and then "No Data Sources." So it knows there are data sources, the rrd files exist but I can't see any graphs. This all started after upgrading from MySQL 3.23 to 5.0.27. Any ideas?

[gandalf]

Please refer to http://forums.cacti.net/viewtopic.php?t=19316 and verify, that your problem is equal to the one shown in the screenshot. Then, pleae follow this thread.
Reinhard

[acceleratebiz]

When I click on Console -> Templates -> Data Templates, I get a full list of templates, so I'm not sure my problem is the same as that guy's. I ran that query you posted in the other thread and it seems to just list the same data templates in the Data Templates webpage.

[acceleratebiz]

Forgot to mention also that the log/cacti.log file shows no errors.

[acceleratebiz]

some more info. The .rrd files seem to be updated, everything looks normal. The issue is I just can't see the graphs! For billing purposes this is very critical for us. Under Graph Management or Data Sources I see "Showing Rows 1 to 30 of 591" but then no Graphs or Data Sources found. Strange.

However, when I go to user management -> admin. And then I go to Graph Permissions (default is ALLOW for everything with no DENYs). There I see the names of all 591 graphs. So the data seems to be collected, devices configured properly and even the graph names exist. Why can't I view the graphs?

[@lecz]

A possible solution is to enclose in brackets any group of more than one tables in all "from" SQL stataments found in the source files.

For example:

Code: Select all

                $graphs = db_fetch_assoc("select
                        graph_templates_graph.local_graph_id,
                        graph_templates_graph.title_cache,
                        graph_templates_graph.height,
                        graph_templates_graph.width
                        from graph_templates_graph,graph_local
                        left join host on host.id=graph_local.host_id
                        ...

will turn into

Code: Select all

                $graphs = db_fetch_assoc("select
                        graph_templates_graph.local_graph_id,
                        graph_templates_graph.title_cache,
                        graph_templates_graph.height,
                        graph_templates_graph.width
                        from (graph_templates_graph,graph_local) <- notice the brackets here
                        left join host on host.id=graph_local.host_id
                        ...

This issue was fixed in newer versions.

Regards,
Alexandru Ciobanu

[TheWitness]

Hmm, have you checked the sql_mode of the server. Review my.cnf and make sure sql_mode is not set. Restart MySQL and you should be all set.

TheWitness

(This is likely where Gandolf sent you anyway)

[acceleratebiz]

Alexandru fixed it above by fixing the query, but upgrading to the latest version fixed it also. Thanks.