Blank Graphs (view the debug output)

[ajones]

Hi

Please excuse me if I appear disorganized. I am new to cacti & its forum.
This posting is intended to follow on from my earlier post with more info.

I have the problem of all my graphs being displayed blank.

here are the files Currently In use:

cacti-cactid-0.8.6f-1.zip
rrdtool-cygwin-1.2.12.zip
mysql-4.1.14-win32.zip

Also My Paths

c:/net-snmp/bin/snmpwalk.exe

c:/net-snmp/bin/snmpget.exe

c:/rrdtool/rrdtool.exe

c:/php/php-win.exe

c:/inetpub/wwwroot/cacti/log/cacti.log

c:/cactid/cactid.exe

In the Cacti Web App I went into the settings
then > Poller Specific Logging
then > Poller Logging Level
select > DEBUG

Here is the debug output:

C:\>php C:\Inetpub\wwwroot\cacti\poller.php
01/11/2006 05:04:22 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php-win.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 16]
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
01/11/2006 05:04:24 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\cisco_as_5300_2_5min_cpu_19.rrd --template 5min
_cpu 1137013462:18
01/11/2006 05:04:24 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\cisco_as_5300_1_5min_cpu_18.rrd --template 5min
_cpu 1137013462:41
01/11/2006 05:04:24 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_15.rrd --temp
late traffic_in:traffic_out 1137013462:0:5680560
01/11/2006 05:04:24 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_14.rrd --temp
late traffic_out:traffic_in 1137013462:0:0
01/11/2006 05:04:24 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_13.rrd --temp
late traffic_in:traffic_out 1137013462:0:0
OK u:0.03 s:0.06 r:2.05
01/11/2006 05:04:24 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_17.rrd --temp
late traffic_in:traffic_out 1137013462:624662440:2191618657
01/11/2006 05:04:24 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_20.rrd --temp
late traffic_in:traffic_out 1137013462:3375107314:1774088377
01/11/2006 05:04:24 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_21.rrd --temp
late traffic_in:traffic_out 1137013462:3960306866:2959021791
OK u:0.03 s:0.12 r:2.13
OK u:0.03 s:0.17 r:2.20- SYSTEM STATS: Time:2.2921 Method:cmd.php Processes:1 Th
OK u:0.03 s:0.22 r:2.24sPerProcess:11 DataSources:16 RRDsProcessed:9
OK u:0.03 s:0.25 r:2.28
OK u:0.03 s:0.28 r:2.33
OK u:0.03 s:0.33 r:2.38
OK u:0.03 s:0.38 r:2.43
OK u:0.03 s:0.42 r:2.48
01/11/2006 05:04:25 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php-win.exe, ARGS: -q C:/Inetpub/wwwroot/cacti/poller_commands.ph
p]
01/11/2006 05:04:25 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php-win.exe, ARGS: -q C:/Inetpub/wwwroot/cacti/poller_export.php]


C:\>

Thanks for any help.



Adrian

[BSOD2600]

1) keep posts to the same topic

2) Since you're using rrdtool 1.2, you MUST define a RRDTool Default Font Path.

3) Turn the polling level in cacti to debug (Settings | Polling level) for one cycle and paste the output of the actual log file (./cacti/log/cacti.log). If it contains WEBLOG entries, then don't bother posting since they just clutter up the log. Turn off WEBEVENTS logging and try again.

[ajones]

I added and Saved the following 'RRDTool Default Font Path' in cacti:
c:/winnt/fonts (attached)

My log file at 'C:\Inetpub\wwwroot\cacti\log\cacti.log' has been 0 KB (empty) from the start until now so I double-checked the securities on the 'log' folder and the actual file. (attached)

On the file I checked 'Allow inheritable permissions from parent to propagate to this object' so the security is displayed the same as for the folder.

I would have added IUSR but I don't see one. (I don't know anything really about why/when there will be an IUSR account. I thought it would be there once IIS is on!?)

OK so the graphs are still blank.

Here is the debug from the command prompt (again)

C:\>php C:\Inetpub\wwwroot\cacti\poller.php
01/12/2006 09:07:21 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php-win.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 16]
Waiting on 1/1 pollers.
Waiting on 1/1 pollers.
01/12/2006 09:07:23 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\cisco_as_5300_2_5min_cpu_19.rrd --template 5min
_cpu 1137071241:0
01/12/2006 09:07:23 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\cisco_as_5300_1_5min_cpu_18.rrd --template 5min
_cpu 1137071241:40
01/12/2006 09:07:23 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_15.rrd --temp
late traffic_in:traffic_out 1137071241:0:6027180
01/12/2006 09:07:23 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_14.rrd --temp
late traffic_out:traffic_in 1137071241:0:0
01/12/2006 09:07:23 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_13.rrd --temp
late traffic_in:traffic_out 1137071241:0:0
01/12/2006 09:07:23 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_16.rrd --temp
late traffic_in:traffic_out 1137071241:0:6027180
01/12/2006 09:07:23 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_17.rrd --temp
late traffic_in:traffic_out 1137071241:1045184269:2454903122
OK u:0.05 s:0.03 r:2.17
01/12/2006 09:07:23 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe upd
ate C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_21.rrd --temp
late traffic_in:traffic_out 1137071241:4285662293:1246795716
01/12/2006 09:07:23 AM - SYSTEM STATS: Time:2.6693 Method:cmd.php Processes:1 Th
reads:N/A Hosts:11 HostsPerProcess:11 DataSources:16 RRDsProcessed:9
OK u:0.05 s:0.06 r:2.22
OK u:0.05 s:0.16 r:2.30
OK u:0.05 s:0.23 r:2.39
OK u:0.05 s:0.33 r:2.48
OK u:0.05 s:0.41 r:2.56
OK u:0.05 s:0.45 r:2.61
OK u:0.05 s:0.50 r:2.65
OK u:0.05 s:0.55 r:2.70
01/12/2006 09:07:24 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php-win.exe, ARGS: -q C:/Inetpub/wwwroot/cacti/poller_commands.ph
p]
01/12/2006 09:07:24 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Proces
s [CMD: c:/php/php-win.exe, ARGS: -q C:/Inetpub/wwwroot/cacti/poller_export.php]


C:\>

[thisted]

Your font path has to be to an actual TTF font, not just to the folder.

[ajones]

Thanks again then. I changed Default Font Path to:

c:/winnt/fonts/arial.ttf

OK So that's good news. First time I've seen labels & stuff on the graph.
(attahced)

But the actual graph though. Haven't seen that.

Also I was looking at the settings for 'Default RRDTool Fonts' as per attached. Can I fill those spaces with 'c:/winnt/fonts/arial.ttf' as well?

Any idea why the log file is empty?

Really Appreciated

Adrian

[ajones]

Hi

Thought I might add that these divices' status reads 'up'

[ajones]

I have determined that my .rrd files are not being updated every 5 minutes.

I checked the scheduled Task that I created and I can't imagine what could be missing if anything.

When I run "php C:\Inetpub\wwwroot\cacti\poller.php" at the command prompt, the .rrd files are updated.

Whats else should I check?

[BSOD2600]

You have a user security problem. make sure your IIS_USR has modify rights on the rrd and log folders.

Read the install guide in my signature.

[ajones]

Thanks again.

I'm really trying to check everything here.

(1) I googled but have not found an install guide in your signature. I assume its easy to find but I have not been diligent enough.

I installed using: http://www.cacti.net/downloads/docs/htm ... ndows.html

(2) Please clue me in on this IIS_USR thing. I may very well be lost.

I attached the image showing the last user I added to the securities tab of these folders. This is what I'm thinking is the IIS_USR.

Pls correct me if I am wrong.

It does not seem to have made any difference.

(3) My Cacti.log file is still empty and .rrd files are not being updated every 5 minutes.

I expect this will be the case until I coorect the permissions issue on the folders

Adrian

[BSOD2600]

1) My signature.... as in the stuff you see below each one of my posts. Here is my guide http://bsod2600.home.comcast.net/install_windows.html

2) You do not want to give IIS_USR full control over anything. It's a major security risk. Also give the user running the scheduled task modify rights to the rrd and log folders. If you're on windows 2003, you'll also need to give IIS_WPG modify rights to the rrd and log folders.

[ajones]

OK thanks a lot Mediator.

(1) Good news is that the graphs are showing up. The error was a fairly silly one on my part:

At the Scheduled Task properites I did not set the correct administrator password.

There is a good reason for that (I dont want u to think I'm a total idiot) but I wont go into details.

Well all the while following error was being logged in the file at C:\WINNT\SchedLgU.Txt every 5 minutes:

The attempt to log on to the account associated with the task failed, therefore, the task did not run.
The specific error is:
0x8007052e: Logon failure: unknown user name or bad password.
Verify that the task's Run-as name and password are valid and try again.

Anyhow the rrd files are now being updated.

I went to reduce IIS_USR permissions on the folders, but when I click on 'Modify', 'Full Control' becomes automatically checked. So I'll have to leave it as it was until I learn something new.

(2) Bad news is that the file cacti.log is still empty even though It has the same permissions as the rra folder.

Can you say if this requires a different user's permission?

I made sure the cacti settings are in "DEBUG" mode, and I ran the
following command at the CLI: php C:\Inetpub\wwwroot\cacti\poller.php

All those plenty statements appear on CLI but nothing in the cacti.log file.

Well I'm really pleased that the graphs are showing and I know your help sped up the trouble-shooting process thoroughly - thanks again.

I'll look forward to any advice on getting the log file to be updated

[BSOD2600]

1) Do you see any data in your graphs now?
2) So you have IIS_USR, IIS_WPG and the user running the scheduled task, all have 'modify' rights to the /cacti/log and /cacti/rrd folders? If there is a blank cacti.log file, delete it too.

[ajones]

Alas...

I deleted the empty cacti.log file and now its being updated with the polling. Solved that problem.

Of interest though, I was trying to set the correct properties on the folders. I got them Modify rights for the IUSR_<machine name> and IWAM_<machine name> account (attached).

I never found any IIS_USR nor IIS_WPG accounts and I wonder if you can say whether they are the same thing.

I googled [IIS_USR IUSR IWAM] and there is only one result which is of no use.

So In effect my problems with the graphs are completeely solved to the best of my knowledge.

Much thanks again & congtrats on a job well done.

Below is my cacti.log file. I edited out some info with x's (hope thats ok).

01/13/2006 09:21:00 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php-win.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 16]
01/13/2006 09:21:01 AM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
01/13/2006 09:21:01 AM - PHPSVR: Poller[0] DEBUG: GETCWD: c:/inetpub/wwwroot/cacti
01/13/2006 09:21:01 AM - PHPSVR: Poller[0] DEBUG: DIRNAM: c:/inetpub/wwwroot/cacti
01/13/2006 09:21:01 AM - PHPSVR: Poller[0] DEBUG: FILENM: c:\Inetpub\wwwroot\cacti\script_server.php
01/13/2006 09:21:01 AM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
01/13/2006 09:21:01 AM - CMDPHP: Poller[0] PHP Script Server Started Properly
01/13/2006 09:21:01 AM - CMDPHP: Poller[0] Host[7] SNMP: Host responded to SNMP
01/13/2006 09:21:01 AM - CMDPHP: Poller[0] Host[7] RECACHE: Processing 1 items in the auto reindex cache for 'x.x.x.136'.
01/13/2006 09:21:01 AM - CMDPHP: Poller[0] Host[7] DS[19] SNMP: v1: x.x.x.136, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, output: 0
01/13/2006 09:21:01 AM - CMDPHP: Poller[0] Host[9] SNMP: Host responded to SNMP
01/13/2006 09:21:01 AM - CMDPHP: Poller[0] Host[9] DS[18] SNMP: v1: x.x.x.135, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, output: 42
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] SNMP: Host responded to SNMP
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] RECACHE: Processing 1 items in the auto reindex cache for 'x.x.x.1'.
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[13] SNMP: v1: x.x.x.1, dsname: traffic_in, oid: .x.x.x.x.x.1.2.2.1.10.2, output: 0
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[13] SNMP: v1: x.x.x.1, dsname: traffic_out, oid: .x.x.x.x.x.1.2.2.1.16.2, output: 0
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[14] SNMP: v1: x.x.x.1, dsname: traffic_out, oid: .x.x.x.x.x.1.2.2.1.16.3, output: 0
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[14] SNMP: v1: x.x.x.1, dsname: traffic_in, oid: .x.x.x.x.x.1.2.2.1.10.3, output: 0
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[15] SNMP: v1: x.x.x.1, dsname: traffic_in, oid: .x.x.x.x.x.1.2.2.1.10.12, output: 0
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[15] SNMP: v1: x.x.x.1, dsname: traffic_out, oid: .x.x.x.x.x.1.2.2.1.16.12, output: 6550500
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[16] SNMP: v1: x.x.x.1, dsname: traffic_in, oid: .x.x.x.x.x.1.2.2.1.10.13, output: 0
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[16] SNMP: v1: x.x.x.1, dsname: traffic_out, oid: .x.x.x.x.x.1.2.2.1.16.13, output: 6550500
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[17] SNMP: v1: x.x.x.1, dsname: traffic_in, oid: .x.x.x.x.x.1.2.2.1.10.15, output: 1351138355
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[17] SNMP: v1: x.x.x.1, dsname: traffic_out, oid: .x.x.x.x.x.1.2.2.1.16.15, output: 2716490495
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[20] SNMP: v1: x.x.x.1, dsname: traffic_in, oid: .x.x.x.x.x.1.2.2.1.10.16, output: 2894065971
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[20] SNMP: v1: x.x.x.1, dsname: traffic_out, oid: .x.x.x.x.x.1.2.2.1.16.16, output: 1211998530
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[21] SNMP: v1: x.x.x.1, dsname: traffic_in, oid: .x.x.x.x.x.1.2.2.1.10.17, output: 2330247861
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Host[16] DS[21] SNMP: v1: x.x.x.1, dsname: traffic_out, oid: .x.x.x.x.x.1.2.2.1.16.17, output: 472231965
01/13/2006 09:21:02 AM - PHPSVR: Poller[0] DEBUG: PHP Script Server Shutdown request received, exiting
01/13/2006 09:21:02 AM - CMDPHP: Poller[0] Time: 0.8123 s, Theads: N/A, Hosts: 10
01/13/2006 09:21:02 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\cisco_as_5300_2_5min_cpu_19.rrd --template 5min_cpu 1137158461:0
01/13/2006 09:21:02 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\cisco_as_5300_1_5min_cpu_18.rrd --template 5min_cpu 1137158461:42
01/13/2006 09:21:02 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_13.rrd --template traffic_in:traffic_out 1137158461:0:0
01/13/2006 09:21:03 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_14.rrd --template traffic_out:traffic_in 1137158461:0:0
01/13/2006 09:21:03 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_15.rrd --template traffic_in:traffic_out 1137158461:0:6550500
01/13/2006 09:21:03 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_16.rrd --template traffic_in:traffic_out 1137158461:0:6550500
01/13/2006 09:21:03 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_17.rrd --template traffic_in:traffic_out 1137158461:1351138355:2716490495
01/13/2006 09:21:03 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_20.rrd --template traffic_in:traffic_out 1137158461:2894065971:1211998530
01/13/2006 09:21:03 AM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update C:\Inetpub\wwwroot\cacti\rra\gateway_cisco_7200_vxr_traffic_in_21.rrd --template traffic_in:traffic_out 1137158461:2330247861:472231965
01/13/2006 09:21:03 AM - SYSTEM STATS: Time:2.3479 Method:cmd.php Processes:1 Threads:N/A Hosts:11 HostsPerProcess:11 DataSources:16 RRDsProcessed:9
01/13/2006 09:21:03 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php-win.exe, ARGS: -q C:/Inetpub/wwwroot/cacti/poller_commands.php]
01/13/2006 09:21:03 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php-win.exe, ARGS: -q C:/Inetpub/wwwroot/cacti/poller_export.php]

[ajones]

Yes there is data on the graph (attached).

This began when I provided the correct password to the scheduled task that I created.

It was an authentication issue as I described before

Adrian