Yes, I have red the FAQ but I still see no graphs

[sp4rc]

hello cactiusers,

i have just set up cacti(0.8.6h_p20060108-r2) in conjunction with cactid(0.8.6f_p1) on a gentoo system. I can browse the cacti admin page and I am able to configure devices and graphs. But I dont see any graphs...
I have ran the following command once to create the initial graphics.

Code: Select all

php /var/www/localhost/htdocs/cacti/poller.php

this is my crontab entry:

Code: Select all

*/5 * * * *     root    php /var/www/localhost/htdocs/cacti/poller.php > /dev/null 2>&1

my cacti user is able to logon to the mysql db and has the appropriate rights.

this is what my cacti log looks like

Code: Select all

View Cacti Log File [24 Items] 
 
11/06/2006 08:40:02 PM - SYSTEM STATS: Time:1.0783 Method:cactid Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:35:02 PM - SYSTEM STATS: Time:1.0758 Method:cactid Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:30:03 PM - SYSTEM STATS: Time:1.0499 Method:cactid Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:25:02 PM - SYSTEM STATS: Time:1.0742 Method:cactid Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:24:20 PM - SYSTEM STATS: Time:1.0500 Method:cactid Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:21:55 PM - SYSTEM STATS: Time:1.0334 Method:cactid Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:20:02 PM - SYSTEM STATS: Time:1.0367 Method:cactid Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:19:30 PM - SYSTEM STATS: Time:1.0472 Method:cactid Processes:1 Threads:1 Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:17:52 PM - SYSTEM STATS: Time:1.0459 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:17:51 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled  
11/06/2006 08:15:02 PM - SYSTEM STATS: Time:1.0946 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:15:01 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled  
11/06/2006 08:10:30 PM - SYSTEM STATS: Time:1.0472 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:10:30 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled  
11/06/2006 08:10:23 PM - SYSTEM STATS: Time:1.0760 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:10:22 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled  
11/06/2006 08:10:18 PM - SYSTEM STATS: Time:1.0368 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:10:17 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled  
11/06/2006 08:10:02 PM - SYSTEM STATS: Time:1.0656 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:10:02 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled  
11/06/2006 08:08:16 PM - SYSTEM STATS: Time:1.1108 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:0 RRDsProcessed:0  
11/06/2006 08:08:15 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled  
11/06/2006 06:46:15 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query.id, snmp_query.name, snmp_query.xml_path from (snmp_query,host_snmp_query) where host_snmp_query.snmp_query_id=snmp_query.id and host_snmp_query.host_id= order by snmp_query.name"  
11/06/2006 06:46:15 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select graph_local.graph_template_id from (graph_local,host_graph) where graph_local.graph_template_id=host_graph.graph_template_id and graph_local.host_id=host_graph.host_id and graph_local.host_id= group by graph_local.graph_template_id"  
 

permissions set on the rra folder:

Code: Select all

sszh0032 cacti # ls -la rra
total 8
drwxr-xr-x   2 apache apache 4096 Nov  6 18:11 .
drwxr-xr-x  10 root   root   4096 Nov  6 18:11 ..
-rw-r--r--   2 root   root      0 Nov  6 18:11 .placeholder

Code: Select all

sszh0032 cacti # ls -ld rra
drwxr-xr-x  2 apache apache 4096 Nov  6 18:11 rra

I have also tried changing the permissons on this folder to 777 but without any changes...

I am trying to create graphs from a windows 2000 server with SNMP Informant installed.

Which point in my configuration did have I missed. Is there any way to check that the snmp information gathering works properly?

Any help would be greatly appreciated. Thanks in advance.

Cheersen
Matze

[sp4rc]

This is the output from the Debug Graphic Mode

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Testterminalserver - Traffic" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes per second" \
--slope-mode \
AREA:#00CF00:"Inbound"  \
GPRINT::LAST:"Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
LINE1:#002A97:"Outbound"  \
GPRINT::LAST:"Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s" 

RRDTool Says:

ERROR: parameter '#00CF00' does not represent a number in line AREA:#00CF00:Inbound

[gandalf]

The rrdtool graph doesn't include any DEF statement. The data sources seem to be missing. Are you running rrdtool 1.2.x (try: rrdtool -v from cli)
Reinhard

[gemohler]

The rrdtool graph doesn't include any DEF statement. The data sources seem to be missing. Are you running rrdtool 1.2.x (try: rrdtool -v from cli)
Reinhard

I have the same issues on a FreeBSD box..and I am on 1.2.15 of rrdtool.

[gemohler]

And here is my logfile as I run this by hand..

mail# php /usr/local/share/cacti/poller.php

11/07/2006 12:59:14 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
11/07/2006 12:59:14 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
11/07/2006 12:59:14 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','/usr/local/share/cacti')"
11/07/2006 12:59:14 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
11/07/2006 12:59:14 AM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/local/bin/php, ARGS: -q /usr/local/share/cacti/cmd.php 0 7]
11/07/2006 12:59:14 AM - CMDPHP: Poller[0] ERROR: Invalid Number of Arguments. You must specify 0 or 2 arguments.
11/07/2006 12:59:14 AM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
11/07/2006 12:59:14 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
11/07/2006 12:59:15 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
11/07/2006 12:59:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
11/07/2006 12:59:15 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) limit 10000"
11/07/2006 12:59:15 AM - SYSTEM STATS: Time:1.1923 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:28 RRDsProcessed:0
11/07/2006 12:59:15 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.1923 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:28 RRDsProcessed:0')"
11/07/2006 12:59:15 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
11/07/2006 12:59:15 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"