issue in updating rrd file after upgrading version 1.2.18 to 1.2.27

[Soumik]

Hi Team,

We upgraded from 1.2.18 to 1.2.27. Now rrd files are not updating.
i ran below command to start the rrd file. but it did not work.
./spine -R -V 3 -S

below is setup of cacti folders.
[root@abcd html]# pwd
/var/www/html
[root@abcd html]# ls -lrt
total 82940
drwxrwxr-x 18 apache apache 4096 Jul 4 2021 cacti-1.2.18_old_bak_20240705
-rw-r--r-- 1 root root 38226048 Jun 7 14:53 cacti-1.2.18.tar.gz
-rw-r--r-- 1 root root 46689007 Jul 5 14:13 cacti-1.2.27.tar.gz
lrwxrwxrwx 1 root root 26 Jul 5 14:58 cacti -> /var/www/html/cacti-1.2.27
drwxrwxr-x 19 apache apache 4096 Jul 5 15:28 cacti-1.2.27
[root@grwcactiacc01 html]#

i am getting idea, why it is redirecting to old directory. /var/www/html/cacti-1.2.18/scripts/

Now new Directory is /var/www/html/cacti-1.2.27/scripts/


Now I am getting below Errors from logs .
[root@grwcactiacc01 log]# tail -5f cacti_stderr.log
Can't open perl script "/var/www/html/cacti-1.2.18/scripts/unix_processes.pl": No such file or directory
Can't open perl script "/var/www/html/cacti-1.2.18/scripts/loadavg_multi.pl": No such file or directory
Can't open perl script "/var/www/html/cacti-1.2.18/scripts/unix_users.pl": No such file or directory
Can't open perl script "/var/www/html/cacti-1.2.18/scripts/linux_memory.pl": No such file or directory
Can't open perl script "/var/www/html/cacti-1.2.18/scripts/linux_memory.pl": No such file or directory

[root@grwcactiacc01 log]# tail -f cacti.log
2024-07-05 16:18:03 - SYSTEM STATS: Time:1.2168 Method:spine Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:14 RRDsProcessed:0
2024-07-05 16:19:03 - SYSTEM STATS: Time:1.2170 Method:spine Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:14 RRDsProcessed:0
2024-07-05 16:19:03 - SYSTEM MAINT STATS: Time:0.01
2024-07-05 16:20:01 - SPINE: Poller[1] PID[3865490] PT[140658668992064] Device[1] DS[1] ERROR: Empty result [localhost]: 'perl /var/www/html/cacti-1.2.18/scripts/unix_processes.pl'
2024-07-05 16:20:01 - SPINE: Poller[1] PID[3865490] PT[140658668992064] Device[1] DS[2] ERROR: Empty result [localhost]: 'perl /var/www/html/cacti-1.2.18/scripts/loadavg_multi.pl'
2024-07-05 16:20:01 - SPINE: Poller[1] PID[3865490] PT[140658668992064] Device[1] DS[3] ERROR: Empty result [localhost]: 'perl /var/www/html/cacti-1.2.18/scripts/unix_users.pl '''
2024-07-05 16:20:01 - SPINE: Poller[1] PID[3865490] PT[140658668992064] Device[1] DS[4] ERROR: Empty result [localhost]: 'perl /var/www/html/cacti-1.2.18/scripts/linux_memory.pl 'MemFree:''
2024-07-05 16:20:01 - SPINE: Poller[1] PID[3865490] PT[140658668992064] Device[1] DS[5] ERROR: Empty result [localhost]: 'perl /var/www/html/cacti-1.2.18/scripts/linux_memory.pl 'SwapFree:''
2024-07-05 16:20:02 - POLLER: Poller[1] PID[3865484] WARNING: Invalid output! MULTI DS[2] Encountered Expected[load_15min:value load_1min:value load_5min:value]
2024-07-05 16:20:03 - SYSTEM STATS: Time:2.2293 Method:spine Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:9 RRDsProcessed:0
^C

tail -20f debug.log
PHP Warning: PHP Startup: Unable to load dynamic library 'mysql.so' (tried: /usr/lib64/php/modules/mysql.so (/usr/lib64/php/modules/mysql.so: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/mysql.so.so (/usr/lib64/php/modules/mysql.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: Module "snmp" is already loaded in Unknown on line 0
DEBUG: Checking if Boost is ready to run.
DEBUG: Last Runtime was 2024-07-05 16:05:03 (1720188303).
DEBUG: Next Runtime is 2024-07-05 16:35:03 (1720190103).
DEBUG: Records Found:27, Max Threshold:50000.


output of Spine
[root@grwcactiacc01 bin]# ./spine -R -V 3 -S
SPINE: Using spine config file [../etc/spine.conf]
Version 1.2.27 starting
Total[0.1330] No Device 0 Poller Items found.
Total[0.1547] Device[5] INFO: SNMP Device Alive, Time:0.0161 ms
Total[0.1705] Device[5] HT[1] DQ[13] Legacy Uptime Result: 507046809, Is Numeric: 1
Total[0.1860] Device[5] HT[1] DQ[13] Extended Uptime Result: 507046800, Is Numeric: 1
Total[0.1860] Device[5] HT[1] DQ[13] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 507040900 < output: 507046800)
Total[0.1860] Device[5] HT[1] DQ[15] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 507040900 < output: 507046800)
Total[0.1865] Device[5] HT[1] NOTE: There are '4' Polling Items for this Device
Total[0.2037] Device[5] HT[1] DS[12] TT[17.14] SNMP: v2: 94.105.31.94, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.22276, value: 11964516
Total[0.2038] Device[5] HT[1] DS[12] TT[17.16] SNMP: v2: 94.105.31.94, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.22276, value: 11444054
Total[0.2038] Device[5] HT[1] DS[16] TT[17.16] SNMP: v2: 94.105.31.94, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.9904, value: 13998989
Total[0.2038] Device[5] HT[1] DS[16] TT[17.17] SNMP: v2: 94.105.31.94, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.9904, value: 13998989
Total[0.2038] Device[5] HT[1] Updating Poller Items for Next Poll
Total[0.2073] Device[5] HT[1] Total Time: 0.069 Seconds
Total[0.2657] Device[6] INFO: SNMP Device Alive, Time:0.0458 ms
Total[0.2956] Device[6] HT[1] DQ[13] Legacy Uptime Result: 960533401, Is Numeric: 1
Total[0.3256] Device[6] HT[1] DQ[13] Extended Uptime Result: 960533300, Is Numeric: 1
Total[0.3256] Device[6] HT[1] DQ[13] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 960527500 < output: 960533300)
Total[0.3257] Device[6] HT[1] DQ[15] RECACHE OID: .1.3.6.1.2.1.1.3.0, (assert: 960527500 < output: 960533300)
Total[0.3262] Device[6] HT[1] NOTE: There are '3' Polling Items for this Device
Total[0.3958] Device[6] HT[1] DS[9] TT[69.46] SNMP: v2: 94.105.33.168, dsname: 5min_cpu, oid: .1.3.6.1.4.1.13191.10.3.3.1.2.1.0, value: 24
Total[0.3958] Device[6] HT[1] DS[17] TT[69.49] SNMP: v2: 94.105.33.168, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.402657280, value: 557437872
Total[0.3958] Device[6] HT[1] DS[17] TT[69.49] SNMP: v2: 94.105.33.168, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.402657280, value: 549357468
Total[0.3959] Device[6] HT[1] Updating Poller Items for Next Poll
Total[0.3989] Device[6] HT[1] Total Time: 0.18 Seconds
Total[0.4116] Device[1] HT[1] Updating Poller Items for Next Poll
Total[0.4135] Device[1] HT[1] Total Time: 0.0028 Seconds
Total[0.9128] Time: 0.9127 s, Threads: 1, Devices: 3
[root@grwcactiacc01 bin]#

[macan]

Utilities -> System utilities -> view poller cache - are here wrong path? Try rebuild poller cache here.

You have to solve your php problem too:
PHP Warning: PHP Startup: Unable to load dynamic library 'mysql.so' (tried: /usr/lib64/php/modules/mysql.so (/usr/lib64/php/modules/mysql.so: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/mysql.so.so (/usr/lib64/php/modules/mysql.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: Module "snmp" is already loaded in Unknown on line 0

Try to deinstall and reinstall modules php_mysql, php_snmp

[Soumik]

I did uninstall & reinstall php_snmp & php_mysql.
but still below ERROR is coming.

[root@grwcactiacc01 log]# tail -f debug.log
DEBUG: Checking if Boost is ready to run.
DEBUG: Last Runtime was 2024-07-10 15:17:03 (1720617423).
DEBUG: Next Runtime is 2024-07-10 15:47:03 (1720619223).
DEBUG: Records Found:118, Max Threshold:50000.
PHP Warning: PHP Startup: Unable to load dynamic library 'mysql.so' (tried: /usr/lib64/php/modules/mysql.so (/usr/lib64/php/modules/mysql.so: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/mysql.so.so (/usr/lib64/php/modules/mysql.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: Module "snmp" is already loaded in Unknown on line 0
DEBUG: Checking if Boost is ready to run.
DEBUG: Last Runtime was 2024-07-10 15:17:03 (1720617423).
DEBUG: Next Runtime is 2024-07-10 15:47:03 (1720619223).
DEBUG: Records Found:118, Max Threshold:50000.

[macan]

You have to solve your php problem first. Maybe try any support of your OS. It isn't cacti issue