Upgrade to No New Data on Graphs

[mpj]

OK, almost holiday time, great time to upgrade hardware & software.

Old system: a working cacti 0.8.6d

New system:
OpenSuse 10.0
mysql 4.1.13
rrdtool 1.2.11
net-snmp 5.2.1
cacti 0.8.6g with patches

I backed up the cacti database using mysqldump on the old system. I restored it to the new system. I made sure, with phpMyAdmin, that the user and password were the same.

I installed 0.8.6g files in the proper virtual host, and modified the permissions/ownership as instructed on the files.

My first visit to the web site went as expected and the upgrade of the DB was reported to be a "Success."

Now, the problem: There is no new data being added to the graphs. Verbose queries from the edit device screens are not showing and rows. New devices will not populate graphs at all. This is true for remote linux hosts or windows hosts. Even the localhost graphs are not getting new data.

If I su to the cactiuser and manually run the cron command, there do not appear to be any errors. It is very impressive that it runs in about 1/10th the time as the old system, but since I am not at least displaying any data, I am not sure I am actually getting any data.

I have checked the SNMP services on the remote hosts; I have checked & rewritten the snmpd.conf on the local system.

A snmpwalk at the command prompt seems to work.

One round of DEBUG logging attached.

TIA,

--MPJ

[gandalf]

Your log shows, that snmp queries are getting results, perl does fine either. But php script_server is doing weird. Please "su" to your cacti user and run the script server from command line (see docs on how to do that).
Reinhard

[mpj]

OK, set logging to DEBUG again; su'd cactiuser & executed:

/usr/bin/php /WWWSites/cacti/poller.php > cacti/log/Output.txt

--MPJ

[gandalf]

Sorry, that's not what I requested. To be more precise, please follow the instruction on debugging a script_server script as documented in http://www.cacti.net/downloads/docs/htm ... erver.html. Please take an arbitrary script_sever script (one that fails in cacti.log), they often are called ss_<something>.php. su to cactiuser when running the script_server.
Reinhard

[mpj]

OK, so now that we have determined that I have no idea what we are doing or talking about, here is my next best attempt result:

I su'd to cactiuser; executed /usr/bin/php server_script.php; received Warning messages below; attempted an ss_host_cpu command line I found in the log file; received nothing (I assume this is why the graphs have no new data); quit; and received more warnings.

cactiuser@IT2:/WWWSites/cacti> /usr/bin/php script_server.php

Warning: session_start(): open(/var/lib/php/sess_3f5c090b84b3c3a623bd84fa2bfb6ede, O_RDWR) failed: Permission denied (13) in /WWWSites/cacti/include/config.php on line 89

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /WWWSites/cacti/include/config.php:89) in /WWWSites/cacti/include/config.php on line 89

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /WWWSites/cacti/include/config.php:89) in /WWWSites/cacti/include/config.php on line 89
PHP Script Server has Started - Parent is cmd
?
WARNING: Function does not exist
ss_host_cpu SRVD11.dal.halff.ad 22 2:161:500:Halffnet:::MD5::[None] get usage 0
WARNING: Function does not exist
exit
WARNING: Function does not exist
quit
PHP Script Server Shutdown request received, exiting

Warning: Unknown(): open(/var/lib/php/sess_3f5c090b84b3c3a623bd84fa2bfb6ede, O_RDWR) failed: Permission denied (13) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php) in Unknown on line 0

I hope that is what was wanted. If not then I need coaching to re-write the instructions in Chapter 12 for inclusion in a Troubleshooting chapter.

--MPJ

[gandalf]

This may be due to a php session problem. Please search/google for that or see http://forums.cacti.net/about10145.html
Reinhard

[mpj]

OK, made /var/lib/php world writable and got rid of the session errors. Still no new data.

Manual script server yields:

cactiuser@IT2:/WWWSites/cacti> /usr/bin/php script_server.php
PHP Script Server has Started - Parent is cmd
/WWWSites/cacti/scripts/ss_host_cpu.php ss_host_cpu SRVD31.dal.halff.ad 12 2:161:500:Halffnet:::MD5::[None] get usage 3

Warning: main(/wwwsites/cacti/scripts/ss_host_cpu.php): failed to open stream: No such file or directory in /WWWSites/cacti/script_server.php on line 130

Warning: main(): Failed opening '/wwwsites/cacti/scripts/ss_host_cpu.php' for inclusion (include_path='/usr/share/php') in /WWWSites/cacti/script_server.php on line 130
WARNING: Function does not exist
quit
PHP Script Server Shutdown request received, exiting

It does bug me a bit that the case-sensitivity seems to be lost in the Failed opening error message.

TIA,

--MPJ
[/quote]

[gandalf]

It does bug me a bit that the case-sensitivity seems to be lost in the Failed opening error message.

TIA,

--MPJ

I remember someone complaining about something similar. It was resolved changing the path names...
Reinhard

[mpj]

Well, I would call that a bug. Case-INsensitivity is not a good thing in *nix.

I changed the virtual host location from /WWWSites to /wwwsites; had to install cacti from scratch to reset the file locations in the database, but now when manually running the script_server, I get a number for an answer and no warnings:

cactiuser@IT2:/wwwsites/cacti> /usr/bin/php script_server.php
PHP Script Server has Started - Parent is cmd
/wwwsites/cacti/scripts/ss_host_cpu.php ss_host_cpu SRVD31.dal.halff.ad 12 2:161:500:Halffnet:::MD5::[None] get usage 3
36
quit
PHP Script Server Shutdown request received, exiting

Ouch! You must use all lower-case in your *nix pathing. I look forward to a new release that might fix this in all scripts.

--MPJ