No graph (data)

[HP-L]

Hi everybody,

I want to explain my problem of my best, I working on a VMware, with a mandriva as OS.
I haven't graphique or only a little, and without data,(eg:im1) and my host are doesn't all up status .... (eg:img2)



I have all path in cacti, and all query extern at cacti are succes, maybe a probleme with my base SQL ...

I hope to find a help in despite of my poor english, see you soon
Thanks.
There are this error in cacti.log :

Code: Select all

05/10/2007 11:54:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=43 and data_template_rrd.local_data_id=138"  
05/10/2007 11:54:49 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=43 and data_template_rrd.local_data_id=137"  

[gandalf]

Find some basic help at the second link of my signature. Please post your findings step-by-step
Reinhard

[HP-L]

I will to try an answer step by step

An extract of my cacti.log :

Code: Select all

05/10/2007 12:43:02 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
05/10/2007 12:43:04 PM - CMDPHP: Poller[0] WARNING: sockets support not enabled in PHP, falling back to SNMP ping
05/10/2007 12:43:08 PM - CMDPHP: Poller[0] Host[2] DS[26] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:08 PM - CMDPHP: Poller[0] Host[2] DS[27] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:09 PM - CMDPHP: Poller[0] Host[2] DS[28] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:10 PM - CMDPHP: Poller[0] Host[2] DS[48] WARNING: Result from SNMP not valid.  Partial Result:
05/10/2007 12:43:10 PM - CMDPHP: Poller[0] Host[2] DS[48] WARNING: Result from SNMP not valid.  Partial Result:
05/10/2007 12:43:11 PM - CMDPHP: Poller[0] Host[2] DS[113] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:11 PM - CMDPHP: Poller[0] Host[2] DS[114] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:11 PM - CMDPHP: Poller[0] Host[2] DS[115] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:12 PM - CMDPHP: Poller[0] Host[2] DS[116] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:12 PM - CMDPHP: Poller[0] Host[2] DS[117] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:13 PM - CMDPHP: Poller[0] Host[2] DS[118] WARNING: Result from SNMP not valid.  Partial Result: No Such Object avail
05/10/2007 12:43:13 PM - SYSTEM STATS: Time:12.3376 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:21 RRDsProces
sed:18
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=125"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=126"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=129"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=128"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=136"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=137"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=138"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=130"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=133"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=134"
05/10/2007 01:54:04 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select   snmp_query_graph_rrd.snmp_field_name,   data_template_rrd.id as d
ata_template_rrd_id   from (snmp_query_graph_rrd,data_template_rrd)   where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_
data_template_rrd_id   and snmp_query_graph_rrd.snmp_query_graph_id=   and snmp_query_graph_rrd.data_template_id=43   and data_template_rrd.lo
cal_data_id=135"

Then I have a big problem I haven't cactiuser, I working on a image by "my" compagny. This image have got Nagios & Cacti normaly I have only at configure. Nagios it's ok but cacti look's have a few problem and i have a little experience in software for don't say nothing. I m student and must be my prouve but i desperate ...

We say me the link into php & poller.php isn't creat so

Code: Select all

[root@nagiosAPHP etc]# php /usr/local/www/cacti/poller.php 
OK u:0.00 s:0.04 r:2.03 
OK u:0.00 s:0.04 r:2.03 
OK u:0.00 s:0.04 r:3.07 
OK u:0.00 s:0.04 r:3.07 
OK u:0.00 s:0.04 r:3.08 
OK u:0.00 s:0.04 r:3.08 
OK u:0.00 s:0.05 r:5.11 
OK u:0.00 s:0.05 r:6.12 
OK u:0.00 s:0.06 r:6.13 
OK u:0.00 s:0.06 r:7.14 
OK u:0.00 s:0.06 r:7.14 
OK u:0.00 s:0.06 r:7.14 
sh: -c: line 0: syntax error near unexpected token `(' 
sh: -c: line 0: `/usr/bin/snmpget -O fntev -c 'public' -v 2c -t 1 -r 3 X.X.X.112:161 

.1.3.6.1.2.1.2.2.1.10..1.3.6.1.2.1.2.2.1.2.65539 Intel(R) Advanced Network Services Virtual Adapter' 
OK u:0.00 s:0.06 r:8.16 
sh: -c: line 0: syntax error near unexpected token `(' 
sh: -c: line 0: `/usr/bin/snmpget -O fntev -c 'public' -v 2c -t 1 -r 3 X.X.X.112:161 

.1.3.6.1.2.1.2.2.1.16..1.3.6.1.2.1.2.2.1.2.65539 Intel(R) Advanced Network Services Virtual Adapter' 
OK u:0.00 s:0.06 r:9.18 
OK u:0.00 s:0.07 r:9.18 
OK u:0.00 s:0.07 r:9.19 
OK u:0.01 s:0.07 r:10.20 
OK u:0.01 s:0.08 r:10.20 
OK u:0.01 s:0.08 r:11.22 
OK u:0.01 s:0.08 r:11.22 
05/10/2007 12:43:13 PM - SYSTEM STATS: Time:12.3376 Method:cmd.php Processes:1 Threads:N/A Hosts:5 HostsPerProcess:5 DataSources:21 

RRDsProcessed:18 

I can see two problem but I haven't idea
If anybody have an answer or an idea ...
[/code]

[gandalf]

I will to try an answer step by step

An extract of my cacti.log :

Code: Select all

and snmp_query_graph_rrd.snmp_query_graph_id=  

This one prevents graphs from being shown. The database may be corrupt. Please try to run a mysql repair on it.
Reinhard

[HP-L]

Hi, thanks you I have watch my base sql they're are a problem on PRIMARY KEY but I haven't idea ... thanks
I thinks all setting when I will free ... without use this image ..