Graphs not showing data after server migration and Cacti upgrade

[somerandomguy]

HI all,

I'm in the process of trialing a server migration and upgrade for Cacti.

Our current environment is:
CentOS release 5.4
PHP 5.1.6
Cacti 0.8.8h
MySQL 5.0.77
RRDtool 1.2.27

New environment is:
CentOS Linux release 8.2.2004 (Core)
PHP 7.2.24
Cacti 1.2.14
MariaDB 10.3.17
RRDtool 1.7.0
Selinux is in permissive mode for the time being.
I used the cacti and cacti-spine packages from the EPEL repo.

I performed a migration using similar steps as shown on the website below.
https://blog.renu.ac.ug/index.php/2017/ ... o-another/

After the installation successfully completed an upgrade from 0.8.8h to 1.2.14. I noticed my graphs aren't showing any data. Looking at the attached image the Data Source Troubleshooter is showing an RRD mismatch. I'm confused as the file exists and is readable.

Any thoughts or advice would be greatly appreciated.


:::::UPDATE:::::

Doh, I forgot to add my database credentials to the Spine config file (/etc/spine.conf). After fixing the Spine config issue, Cacti was reporting 'The table 'poller_output' is full'. To resolve this I increased the size for the max_heap_table_size parameter.

[TheWitness]

That'll do it. I was recently having a problem with a dual setup, and realized first that I did not setup the main poller connection information, then it continued to have problems. After that, I realized I was using spine 1.1.x and not 1.2.x. Fixed that, and it was working. Sometimes you have good days and other times bad days.

[eltonharier]

Ensure that the RRD files have the correct permissions for the web server user (often Apache or Nginx). The web server needs read access to the RRD files. You can use the chown and chmod commands to adjust the ownership and permissions if necessary.

chown apache:apache /path/to/rrd/files/*.rrd
chmod 644 /path/to/rrd/files/*.rrd

Confirm that the RRD files are not corrupted. You can use the rrdtool info command to check the RRD file information. For example:
rrdtool info /path/to/rrd/files/some_graph.rrd

If there are any issues with the RRD files, you might need to recreate them or restore them from a backup.
In the Cacti web interface, navigate to "Console" -> "Data Sources" and ensure that the data sources after lead enrichment associated with your graphs are configured correctly. Confirm that the data sources are pointing to the correct RRD files.

[TheWitness]

Apache and Nginx need R/W access if you are using Boost. Keep that in mind.