No graphs are displayed

gnore · Joined: 27 Jul 2008 Posts: 5

Hi,

i've installed cacti with cacti manual.

- Windows XP
- running poller.php as a scheduled task every 5 minutes

I don't get any graphs of devices i've created. The SNMP connect should be ok because i got these infomation after device creation:

SNMP Information
System: Enterasys Networks, Inc. B2G124-48 Rev 04.01.02.0007
Uptime: 533426500 (61 days, 17 hours, 44 minutes)
Hostname: ******
Location: *****
Contact: *******

In the cacti log file I can find the following:

07/31/2008 10:01:42 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 400 seconds have passed since the last poll!
07/31/2008 10:01:42 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '400', Max Runtime '298', Poller Runs: '1'
07/31/2008 10:00:01 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
07/31/2008 09:55:02 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 596 seconds have passed since the last poll!
07/31/2008 09:55:02 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '596', Max Runtime '298', Poller Runs: '1'
07/31/2008 09:45:06 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 601 seconds have passed since the last poll!
07/31/2008 09:45:06 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '601', Max Runtime '298', Poller Runs: '1'
07/31/2008 09:35:05 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 604 seconds have passed since the last poll!
07/31/2008 09:35:05 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '604', Max Runtime '298', Poller Runs: '1'
07/31/2008 09:30:01 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
07/31/2008 09:25:01 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 599 seconds have passed since the last poll!
07/31/2008 09:25:01 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '599', Max Runtime '298', Poller Runs: '1'
07/31/2008 09:15:02 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 600 seconds have passed since the last poll!
07/31/2008 09:15:02 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '600', Max Runtime '298', Poller Runs: '1'
07/31/2008 09:05:02 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 600 seconds have passed since the last poll!
07/31/2008 09:05:02 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '600', Max Runtime '298', Poller Runs: '1'
07/31/2008 08:55:02 AM - POLLER: Poller[0] WARNING: Scheduled Task is out of sync with the Poller Interval! The Poller Interval is '300' seconds, with a maximum of a '300' second Scheduled Task, but 597 seconds have passed since the last poll!
07/31/2008 08:55:02 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '597', Max Runtime '298', Poller Runs: '1'
07/31/2008 08:50:04 AM - SYSTEM STATS: Time:298.4456 Method:cmd.php Processes:1 Threads:N/A Hosts:7 HostsPerProcess:7 DataSources:2 RRDsProcessed:0

... and so on.

Has anyone an idea, where I can also also look for error logs ?
Or may be there is a failure with poller.php ?

Thanks for your help.

BSOD2600 · Posted: Fri Aug 01, 2008 12:30 am Post subject:

you sure its scheduled every 5 min? The poller seems to be executing every 10 min (per the log file). The cacti.log file DOES contain errors, which you already seen/posted. Changing the logging level to debug will reveal more details about what is going on.

gnore · Joined: 27 Jul 2008 Posts: 5

Here are some samples of the debug logs:

08/05/2008 09:42:27 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/05/2008 09:42:27 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/05/2008 09:42:27 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
08/05/2008 09:42:27 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
08/05/2008 09:42:27 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/05/2008 09:40:49 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
08/05/2008 09:40:49 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
08/05/2008 09:40:49 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='1' and user_auth_realm.realm_id='15'"
08/05/2008 09:40:49 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='0'"
08/05/2008 09:40:49 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
08/05/2008 09:40:04 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
08/05/2008 09:40:04 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:298.1451 Method:cmd.php Processes:1 Threads:N/A Hosts:7 HostsPerProcess:7 DataSources:2 RRDsProcessed:0')"
08/05/2008 09:40:04 AM - SYSTEM STATS: Time:298.1451 Method:cmd.php Processes:1 Threads:N/A Hosts:7 HostsPerProcess:7 DataSources:2 RRDsProcessed:0
08/05/2008 09:40:04 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.
08/05/2008 09:35:06 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/progra~1/php/php.exe, ARGS: -q c:/programme/apache software foundation/apache2.2/htdocs/cacti/cmd.php 0 10]
08/05/2008 09:35:05 AM - POLLER: Poller[0] NOTE: Poller Int: '300', Scheduled Task Int: '300', Time Since Last: '603', Max Runtime '298', Poller Runs: '1'
08/05/2008 09:30:01 AM - SYSTEM STATS: Time:298.9551 Method:cmd.php Processes:1 Threads:N/A Hosts:7 HostsPerProcess:7 DataSources:2 RRDsProcessed:0
08/05/2008 09:30:01 AM - POLLER: Poller[0] Maximum runtime of 298 seconds exceeded. Exiting.

BSOD2600 · Posted: Tue Aug 05, 2008 5:25 pm Post subject:

You didn't follow the installation guide. You installed php and apache in paths which contain spaces. This is not allowed.

gnore · Joined: 27 Jul 2008 Posts: 5

Thanks for the info, now i've installed apache and php new. Now the paths not contain spaces.
cacti is running, i created a new device. the snmp connect seems also be fine, because i got main snmp data on creation of device. i created a graph (if-utilization of switch) ... but one our later no graph is showing - i got a "red cross". (same problem)
In cacti log i got now only "CMDPHP: Poller[0] DEBUG: SQL " messages - are they necessary for further trouble shooting ?

BSOD2600 · Posted: Wed Aug 06, 2008 8:49 pm Post subject:

typically one doesnt care about the debug sql messages. Although other entries in the log file will possibly tell you why your graphs are blank (no data collected, rrdfiles not created, device down, etc).

When you turn on graph debugging, what is the error which rrdtool reports?

gnore · Joined: 27 Jul 2008 Posts: 5

When I turn on graph debugging I got the following:

RRDTool Command:

C:/Programme/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="switch - Traffic - |query_ifName|" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
DEF:a="C\:/Programme/Apache/Apache2.2/htdocs/cacti/rra/switch_traffic_in_8.rrd":traffic_in:AVERAGE \
DEF:b="C\:/Programme/Apache/Apache2.2/htdocs/cacti/rra/switch_traffic_in_8.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s"

RRDTool Says:

ERROR: opening 'C:/Programme/Apache/Apache2.2/htdocs/cacti/rra/switch_traffic_in_8.rrd': No such file or directory

BSOD2600 · Posted: Thu Aug 07, 2008 9:13 pm Post subject:

Alright, so have you followed the troubleshooting steps in that README post?