Where to update "<path_rra>"

[HQuest]

After an update to cacti 1.2.25 and stepping away from the lab system for two days, noticed none of the graphs have been updated any longer. I have the habit of uncompressing the tar file and creating a symlink to the new cacti, pointing to the new install and saving the old for a few days, "just because". I also decided, this time, to move the rra/ folder from inside the cacti/ folder to a parallel to the cacti install, with another symlink, so I never have to keep moving folders again - just a simple symlink.

That was in my mind. Reality was a little different. After fiddling for a while, I found many references at table poller_item, including pointing to previous cacti versions such as 1.2.21 that I don't even have on disk for a long time - with zero error logs recorded so far, explaining why some of my graphs were blank for so long while I fought the SNMP processes and gave up to retry another day.

Did an export, fixed the paths, dropped and imported the table and all looks good now, but I'm afraid next time I add a new poller, things will go sideways at next upgrade.

That said, how can I ensure, preferably via web GUI, that the new poller will be using whatever <path_rra> value I want to and not a generic, cacti-generated <path_rra> that can be anything from the symlink and the current cacti-1.2.25 version? And what is the correct way to upgrade the local cacti install in between versions, keeping old and new for a few weeks, and without fiddling with the database?

Thanks!

[Osiris]

config.php.

[HQuest]

config.php.

Looks straightforward enough. Is this documented anywhere?

[TheWitness]

Check the config.php.dist file. Should be documented in there. On the docs site. Maybe not.

[Mohammedejaz]

I am too facing the same problem. The graphs are blank and do not display the current graphs. following the upgrade from one machine to another of Cact 1.1.6 to 1.2.5


when i ran the manually php cmd.php script, some error.

Total[130.8869] Device[278] DS[11831] TT[14.34] SCRIPT: perl /var/www/html/cacti/scripts/linux_memory.pl 'SwapFree:', output: 16523260
Total[130.9052] Device[278] DS[11832] TT[17.99] SCRIPT: perl /var/www/html/cacti/scripts/loadavg_multi.pl, output: 1min:0.07 5min:0.07 10min:0.07
Total[130.9205] Device[278] DS[11833] TT[14.99] SCRIPT: perl /var/www/html/cacti/scripts/unix_users.pl '', output: 1
Total[130.9581] Device[278] DS[11834] TT[37.26] SCRIPT: perl /var/www/html/cacti/scripts/unix_processes.pl, output: 322
Total[130.9583] Device[278] Writing 5 items to Poller Output Table
Total[130.9602] Device[278] Time[0.11] Items[5] Errors[0]

dont know how to solve it .. please assist

[TheWitness]

Likely a permission problem. If you are on a RHEL variant:

Code: Select all

cd /var/www/html
chown -R apache:apache cacti

Also,

Code: Select all

mysql -A cacti
SELECT rrd_path FROM poller_item;
quit;

Make sure the paths are accurate. If they are not what you expect, go to Console > Utilities > System Utilities > Repopulate Poller Cache

Then run the SQL query above again. Any time you change the $config['rra_path'], you have to repopulate the poller cache.

[Mohammedejaz]

SELECT rrd_path FROM poller_item; since we are an ISP we have huge rrd files. I am sending you the portion of that. Plotting the graphs for the new one is not an issue see below snippet.


/var/www/html/cacti/rra/scacti_mem_buffers_11830.rrd |
| /var/www/html/cacti/rra/scacti_mem_swap_11831.rrd |
| /var/www/html/cacti/rra/scacti_load_1min_11832.rrd |
| /var/www/html/cacti/rra/scacti_users_11833.rrd |
| /var/www/html/cacti/rra/scacti_proc_11834.rrd |
| /var/www/html/cacti/rra/test_khobar_mall_traffic_in_11835.rrd |
| /var/www/html/cacti/rra/test_khobar_mall_traffic_in_11835.rrd |
+-----------------------------------------------------------------------------------+
9666 rows in set (0.014 sec)

MariaDB [cacti]>
The migration RRD files from old 1.16 to 1.2.5 are listed below. I can see that those rrd files available,
Followed this steps for convertion.
# for i in `find -name "*.rrd"`; do rrdtool dump $i > /tmp/xml/$i.xml; done
Copy and extract the files to the right remote directory.
Restore the RRD files from the XML files.
# for i in `find -name "*.xml"`; do rrdtool restore $i `echo $i |sed s/.xml//g`; done


Migrated graphs also seen complete history of the graphs as well, but not the current one graphs are plotting.
The only modification is that, as you are aware, the old server version uses in /usr/share/cact/rra. Wheras is new server in /var/www/html/rra
I also tried changing the path from /var/www/html/cacti/rra to /usr/share/cacti/rra. But no luck..

root@scacti rra]# ls -l pop*

-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_dammam_traffic_in_6071.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_dammam_traffic_in_6074.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_dammam_traffic_in_6075.rrd
-rw-rw-r--. 1 apache apache 47992 Oct 19 16:34 pop_rtr_-_khobar_mall_5min_cpu_7426.rrd
-rw-rw-r--. 1 apache apache 47992 Oct 19 16:34 pop_rtr_-_khobar_mall_cisco_temperature_5228.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar_mall_traffic_in_10711.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar_mall_traffic_in_10712.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar_mall_traffic_in_10713.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar_mall_traffic_in_11575.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar-mall_traffic_in_3980.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar_mall_traffic_in_6904.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar_mall_traffic_in_7437.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar_mall_traffic_in_7438.rrd
-rw-rw-r--. 1 apache apache 94816 Oct 19 16:34 pop_rtr_-_khobar_mall_traffic_in_7452.rrd

[Osiris]

What's in your cacti log?

[Mohammedejaz]

2023-10-20 10:30:39 - POLLER: Poller[1] PID[809403] Device[124] DS[10712] TT[9.39] SNMP: v2: 212.107.111.209, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.46, output: U
2023-10-20 10:30:39 - POLLER: Poller[1] PID[809403] Device[124] DS[10712] TT[8.27] SNMP: v2: 212.107.111.209, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.46, output: U
2023-10-20 10:30:39 - POLLER: Poller[1] PID[809403] Device[124] DS[10713] TT[8.31] SNMP: v2: 212.107.111.209, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.47, output: 0
2023-10-20 10:30:39 - POLLER: Poller[1] PID[809403] Device[124] DS[10713] TT[8.26] SNMP: v2: 212.107.111.209, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.47, output: 990
2023-10-20 10:30:39 - POLLER: Poller[1] PID[809403] Device[124] DS[11575] TT[9.24] SNMP: v2: 212.107.111.209, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.28, output: U
2023-10-20 10:30:39 - POLLER: Poller[1] PID[809403] Device[124] DS[11575] TT[11.21] SNMP: v2: 212.107.111.209, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.28, output: U

i do not see any error, but above are the few last logs, still graphs are blank.

[Osiris]

Look for SYSTEM STATS: is you don't find it, your poller is not running. Also, it looks like you have an issue with the SNMP agent on the monitored host. For beginners, I recommend a one line snmpd.conf file:

Code: Select all

rocommunity public

[Mohammedejaz]

few logs bellow , snmp is fine. we are getting the values when we ran snmp as manual, i do not understand what went wrong. please assist.

root@scacti log]# snmpwalk -c cacti -v2c 212.107.111.212 1.3.6.1.2.1.31.1.1.1.7
IF-MIB::ifHCInUcastPkts.1 = Counter64: 0
IF-MIB::ifHCInUcastPkts.2 = Counter64: 0
IF-MIB::ifHCInUcastPkts.3 = Counter64: 138474262306
IF-MIB::ifHCInUcastPkts.4 = Counter64: 0
IF-MIB::ifHCInUcastPkts.5 = Counter64: 128653715260
IF-MIB::ifHCInUcastPkts.6 = Counter64: 0
IF-MIB::ifHCInUcastPkts.7 = Counter64: 446332734
IF-MIB::ifHCInUcastPkts.8 = Counter64: 1437012338
IF-MIB::ifHCInUcastPkts.9 = Counter64: 0
IF-MIB::ifHCInUcastPkts.10 = Counter64: 0
IF-MIB::ifHCInUcastPkts.11 = Counter64: 0
IF-MIB::ifHCInUcastPkts.12 = Counter64: 0
IF-MIB::ifHCInUcastPkts.14 = Counter64: 0
IF-MIB::ifHCInUcastPkts.15 = Counter64: 0
IF-MIB::ifHCInUcastPkts.16 = Counter64: 0
IF-MIB::ifHCInUcastPkts.17 = Counter64: 6449572980
IF-MIB::ifHCInUcastPkts.21 = Counter64: 10679226416
IF-MIB::ifHCInUcastPkts.22 = Counter64: 0
IF-MIB::ifHCInUcastPkts.23 = Counter64: 106250
IF-MIB::ifHCInUcastPkts.27 = Counter64: 103229800635
IF-MIB::ifHCInUcastPkts.28 = Counter64: 3202727489
IF-MIB::ifHCInUcastPkts.31 = Counter64: 41199990
IF-MIB::ifHCInUcastPkts.33 = Counter64: 0

below logs from cacti.log wheras i do not see "system state" what you mentioned below.
2023-10-23 00:00:37 - POLLER: Poller[1] PID[1842094] Device[126] STATUS: Device '212.107.111.212' is UP.
2023-10-23 00:00:37 - POLLER: Poller[1] PID[1842097] Device[126] STATUS: Device '212.107.111.212' is UP.
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842094] Device[126] DS[625] TT[16.68] SNMP: v2: 212.107.111.212, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.75, output: U
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842094] Device[126] DS[625] TT[16.64] SNMP: v2: 212.107.111.212, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.75, output: U
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842097] Device[126] DS[625] TT[16.48] SNMP: v2: 212.107.111.212, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.75, output: U
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842094] Device[126] DS[1622] TT[16.69] SNMP: v2: 212.107.111.212, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.112, output: 67115257848455
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842097] Device[126] DS[625] TT[17.44] SNMP: v2: 212.107.111.212, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.75, output: U
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842094] Device[126] DS[1622] TT[16.35] SNMP: v2: 212.107.111.212, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.112, output: 47245470192578
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842097] Device[126] DS[1622] TT[16.27] SNMP: v2: 212.107.111.212, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.112, output: 67115257848455
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842094] Device[126] DS[2187] TT[15.94] SNMP: v2: 212.107.111.212, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.4, output: 0
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842097] Device[126] DS[1622] TT[16.03] SNMP: v2: 212.107.111.212, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.112, output: 47245470192578
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842094] Device[126] DS[2187] TT[16.41] SNMP: v2: 212.107.111.212, dsname: traffic_out, oid: .1.3.6.1.2.1.31.1.1.1.10.4, output: 0
2023-10-23 00:00:38 - POLLER: Poller[1] PID[1842097] Device[126] DS[2187] TT[17.8] SNMP: v2: 212.107.111.212, dsname: traffic_in, oid: .1.3.6.1.2.1.31.1.1.1.6.4, output: 0

[Mohammedejaz]

anyone has this issue earlier and it was solved. it looks to me new version of cacti has some bug.

is there any way i can official paid support.

[macan]

below logs from cacti.log wheras i do not see "system state" what you mentioned below.

Logs -> In log filter set Type = Stats and you will see something like:
2023-10-24 10:51:31 - SYSTEM STATS: Time:90.8809 Method:spine Processes:2 Threads:5 Hosts:380 HostsPerProcess:190 DataSources:17695 RRDsProcessed:0
2023-10-24 10:47:16 - SYSTEM STATS: Time:136.0803 Method:spine Processes:2 Threads:5 Hosts:380 HostsPerProcess:190 DataSources:17695 RRDsProcessed:0

[Mohammedejaz]

thank you for your email.
yes i ran poller.php file manaully i donot see such statment in my logs. am attaching the log for your kind perusal
thanks alot in advacne..
am in very critical situation as you know existing version is vulnerable.

[HQuest]

While it seems your issue was different from the issue I started on this topic, what I would do is to move the rra files away to another folder, and let cacti regenerate them from the ground up.

As soon as it polls your devices for a few minutes and you confirm the system is working as intended, you could then attempt to import the historical data into the newer files. Maybe at a point in time your rra files structure got changed, and while everything is correct from a snmp and cacti perspective, your graphs aren’t being plotted because of that.

Good luck.