Error With Graph

[Steph_The_French]

Hi everybody,
How are u ?

I'm french so I apologize for having a very bad english.

Actually i have installed cacti on a linux system.

OS : Linux - Fedora Core 3
MySQL Version : 4.1.16
Apache Version : 2.0.55
Cacti version : 0.8.6h

Since the beginning I have the same problem ==> No graph.

I have tried to find the problem for 7 days ... So i decide to see you.


extract of cacti.log

Code: Select all

01/31/2006 03:53:28 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=62limit 0,1"

01/31/2006 04:01:38 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=61limit 0,1"

02/01/2006 10:31:10 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=61limit 0,1"

02/01/2006 10:31:15 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=61limit 0,1"

02/01/2006 10:36:17 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=61limit 0,1"

02/01/2006 10:41:18 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=61limit 0,1"

02/01/2006 10:46:19 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=61limit 0,1"

rrdtool report in cacti

Code: Select all

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Processes" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="processes" \
DEF:a="/usr/local/apache2/www/cacti/rra/localhost_proc_84.rrd":proc:AVERAGE \
AREA:a#F51D30:"Running Processes"  \
GPRINT:a:LAST:"Current\:%8.0lf"  \
GPRINT:a:AVERAGE:"Average\:%8.0lf"  \
GPRINT:a:MAX:"Maximum\:%8.0lf" 

I have verified permissions on directory and files.

I really don't know ...

Thanks to help me.

[BSOD2600]

Try installing the patches for cacti.

[TheWitness]

BSOD,

Go back to sleep!

TheWitness

[Steph_The_French]

Try installing the patches for cacti.

I try to install 3 of 4 patches but there is no movement.

thanks to help me

[TheWitness]

Instead of patchiing, goto the following directory and replace the files:

http://www.cacti.net/downloads/patches/ ... re-patched

TheWitness

[Steph_The_French]

Instead of patchiing, goto the following directory and replace the files:

http://www.cacti.net/downloads/patches/ ... re-patched

TheWitness

I have replace the files but there is again no effect.

Thanks TheWitness

[TheWitness]

Stef,

Here are some checks I would like you to run:

1) Turn logging to DEBUG
2) Open a shell and cd to the cacti web root
3) Run "php <path_cacti>/cmd.php, post results
4) Run php poller.php, post results
5) Goto Graph Management in Cacti, edit one of the problematic graphs
6) Within Graph Management, select "debug" in the upper right hand corner, post graphic.

Thanks,

TheWitness

[Steph_The_French]

Stef,

Here are some checks I would like you to run:

1) Turn logging to DEBUG
2) Open a shell and cd to the cacti web root

Turn Logging to debug ??

3) Run "php <path_cacti>/cmd.php, post results

Code: Select all

 
02/02/2006 02:49:36 PM - CMDPHP: POLLER[0] Time : 0.2551s, Theads: N/A, Hosts: 3

4) Run php poller.php, post results

The process bugs so I have did a screen shot, I did a Ctrl+C command to stop the process.

5) Goto Graph Management in Cacti, edit one of the problematic graphs
6) Within Graph Management, select "debug" in the upper right hand corner, post graphic.

I give you too the rrdtool report

Code: Select all

/usr/local/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Load Average" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--units-exponent=0 \
--vertical-label="processes in the run queue" \
DEF:a="/usr/local/apache2/www/cacti/rra/localhost_load_1min_5.rrd":load_1min:AVERAGE \
DEF:b="/usr/local/apache2/www/cacti/rra/localhost_load_1min_5.rrd":load_5min:AVERAGE \
DEF:c="/usr/local/apache2/www/cacti/rra/localhost_load_1min_5.rrd":load_15min:AVERAGE \
CDEF:cdefg=TIME,1138889147,GT,a,a,UN,0,a,IF,IF,TIME,1138889147,GT,b,b,UN,0,b,IF,IF,TIME,1138889147,GT,c,c,UN,0,c,IF,IF,+,+ \
AREA:a#EACC00:"1 Minute Average"  \
GPRINT:a:LAST:" Current\:%8.2lf\n"  \
STACK:b#EA8F00:"5 Minute Average"  \
GPRINT:b:LAST:" Current\:%8.2lf\n"  \
STACK:c#FF0000:"15 Minute Average"  \
GPRINT:c:LAST:"Current\:%8.2lf\n"  \
LINE1:cdefg#000000:"" 

Thanks,

TheWitness

Thanks a lot

[Steph_The_French]

Hello

After reinstall rrdtool graphs appear.

Thanks a lot ...

I think your project is very interesting, and if I can, I would help you, how can I help you ?

[Steph_The_French]

I don't understand why but the bug comes back today.

I think that was a rrdtool bugs but ...

Thanks

----------------

I have found the problem this is the rrdtool.

So let's work

[TheWitness]

I believe that your poller user does not have RWX to the "<path_cacti>/rra" and "<path_cacti>/log" directories. When you ran manually, the RRD files were created because you likely have elevated privileges (say root) and the poller does not.

TheWitness

[Steph_The_French]

Thx TheWItness,

How can I resolve my problem ?

[TheWitness]

chmod -R 777 <path_cacti> is the easiest. I'm not too unix savvy, so I can provide better clarity.

TheWitness

[fmangeant]

Hi

either change the owner of the files in the log/ and rra/ directories (for example, chown cactiuser log/* rra/*), or change the permissions of these files (chmod 777 log/* rra/*, but it's a bad idea).

[TheWitness]

I like fmangeant's answer better!!!

TheWitness