Some graphs work, some don't :(

[BenyBen]

Hi,
I've been trying to make heads or tails of this...

I created a host using the host template win2k/xp, and it successfully got mounted partition and cpu information. I then created graphs for the Cpus, hd paritions and network interface that cacti found.

The problem is, only the the graph for my network interface has data. The rest DO show up, but with "nan".

I know this isn't an issue with the host, since this information is already being monitored by Nagios.
When I run my cmd.php manually, I get a bunch of errors like this:

36406377984
:...R: expected 2 data source readings (got 0) from text/html
: command not found
sh: line 3: 3838539264:Content-type:: command not found
: command not found
sh: line 5: 36406377984: command not found
update /var/www/html/cacti/rra/webcss6_hdd_total_9.rrd --template hdd_total:hdd_used N:Content-type: text/html

145661448192:Content-type: text/html

Can anyone help me? Thanks

[TheWitness]

Cacti Version please. Please provide additional OS and Software Version information as well.

TheWitness

[BenyBen]

yes, you're right... I was thinking this morning that I should've provided more information.

OS : Red Hat Linux release 9 (Shrike)
Kernel: 2.4.20-8smp
Cacti version : 0.8.5a

requirements:

rrdtool 1.0.42
httpd-2.0.40-21
php-4.2.2-17
php-mysql-4.2.2-17
php-snmp-4.2.2-17
MySQL-server-4.0.20-0
MySQL-client-4.0.20-0
net-snmp-5.0.6-17

[TheWitness]

Is this a new install? How many hosts? How many graphs? How many Data Sources?

TheWitness

[Guest]

This is a new install. Only 2 hosts, Localhost (to which all graphs work fine)
and another host, which partially works (only network graph works).

I tried adding another hosts to make sure it wasn't a problem with this host, but no success there either.

11 graphs
12 data sources

[TheWitness]

Start over, but use Cacti 0.8.6. I can help you much better with that version of the product. Follow the link to obtain. Even though it say's beta, don't believe it. I suggest you do a complete reinstall. Blow away your database and start from scratch.

http://www.raxnet.net/downloads

TheWitness

[BenyBen]

Hi There,
I did as you said. Dropped the current database, and I installed it 0.8.6

Again, same phenomenon, all the graphs for localhost are created, but for other hosts, only the network graph works. The rest are created, but display as NAN


Here's some info:
-I am runing it as root, to make sure there is no permission issue
-cmd.php was not working, but after seeing a suggestion from you to use poller.php in another thread, I have done so.

some outputs from poller.php

PHP Warning: Function registration failed - duplicate name - mysql_listtables in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_listfields in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_db_name in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_dbname in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_tablename in Unknown on line 0
PHP Warning: mysql: Unable to register functions, unable to load in Unknown on line 0
OK u:0.00 s:0.00 r:4.04
OK u:0.00 s:0.00 r:4.04
OK u:0.00 s:0.00 r:5.05
OK u:0.00 s:0.00 r:5.05
X-Powered-By: PHP/4.2.2
Content-type: text/html

09/10/2004 01:33:00 PM - SYSTEM STATS: Time: 5.0685 s, Method: cmd.php, Processes: 1, Threads: N/A, Hosts: 3, Hosts/Process: 3

Maybe there is a problem with SNMP on the client server's end (win2k) though I AM monitoring diskpace on this server with nagios.

Here's the result from a verbose query on "get mounted partitions" if that can help...

+ Running data query [8].
+ Found type = '6 '[script query].
+ Found data query XML file at '/var/www/html/cacti/resource/script_server/host_disk.xml'
+ XML file parsed ok.
+ Executing script for list of indexes '/usr/bin/php -q /var/www/html/cacti/scripts/ss_host_disk.php 10.10.1.68 Com_key_Replaced 1 2 index'
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/ss_host_disk.php 10.10.1.68 Com_key_Replaced 1 2 query index'
+ Found item [hrStorageIndex='1'] index: 1
+ Found item [hrStorageIndex='2'] index: 2
+ Found item [hrStorageIndex='3'] index: 3
+ Found item [hrStorageIndex='4'] index: 4
+ Found item [hrStorageIndex='5'] index: 5
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/ss_host_disk.php 10.10.1.68 Com_key_Replaced 1 2 query description'
+ Found item [hrStorageDescr='A:\'] index: 1
+ Found item [hrStorageDescr='C:\ Label: Serial Number 9c9d23dd'] index: 2
+ Found item [hrStorageDescr='D:\ Label:Data Serial Number c830e0b'] index: 3
+ Found item [hrStorageDescr='E:\'] index: 4
+ Found item [hrStorageDescr='Virtual Memory'] index: 5
+ Executing script query '/usr/bin/php -q /var/www/html/cacti/scripts/ss_host_disk.php 10.10.1.68 Com_key_Replaced 1 2 query sau'
+ Found item [hrStorageAllocationUnits='0 Bytes'] index: 1
+ Found item [hrStorageAllocationUnits='512 Bytes'] index: 2
+ Found item [hrStorageAllocationUnits='4096 Bytes'] index: 3
+ Found item [hrStorageAllocationUnits='0 Bytes'] index: 4
+ Found item [hrStorageAllocationUnits='65536 Bytes'] index: 5
+ Found data query XML file at '/var/www/html/cacti/resource/script_server/host_disk.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_server/host_disk.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/script_server/host_disk.xml'

[TheWitness]

Upgrade your PHP to 4.3.8 CLI and try again. You are correct. You must run poller.php and not cmd.php in 0.8.6. This is very important.

You can run cmd.php from the command line, but your graphs will not update. I am very interested to see your output with 4.3.8.

TheWitness

[BenyBen]

I've been trying that a bit this weekend. I seem to have a problem installing it becasue it cannot find APXS within Apache.

IS APXS required with Cacti?

[TheWitness]

Don't know. I run PHP 5.1 on my development box and 4.3.8 at the office. I have no problems with either. I also am running Apache 2.50

TheWitness

[BenyBen]

Alright, this has been a long time I know, but I finally manage to get some time to spend on this box. I simply upgraded red hat to FC2, with Apache 2 and PHP 5. Now everything works.