Cacti and Apache scripte

[specki]

Hello,
I have a problem with apachastat 0.4. He simply draws no graphs of Apache script.

Code: Select all

RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-10 \
--title='Server1 - Apache Statistics - Hits / s' \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label='Hits/sec' \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/usr/share/cacti/rra/1/129.rrd":apache_total_hits:AVERAGE \
DEF:b="/usr/share/cacti/rra/1/129.rrd":apache_total_hits:MAX \
AREA:a#AAABA1FF:"Hits/sec"  \
GPRINT:a:LAST:"Current\:%8.2lf %s"  \
GPRINT:a:AVERAGE:"Average\:%8.2lf %s"  \
GPRINT:a:MAX:"Maximum\:%8.2lf %s\n"  \
COMMENT:"                            Represents the number of hits per second\n"  \
LINE1:b#000000FF:"Max\n"  \
COMMENT:"                                 ApacheStats v0.4 - Rolf Poser\n" 
RRDTool Says:
OK

and when i start the script manual than come:

Code: Select all

./ws_apachestats.pl linux-idgn
apache_total_hits:11 apache_total_kbytes:3 apache_busy_workers:1 apache_idle_workers:5 thread_O:144 threadC:0 threadD:0 threadG:0 threadI:0 threadK:0 threadL:0 threadR:0 threadS:0 threadW:1 thread_W:5 apache_cpuload:.000364564

[gandalf]

You already followed 2nd link of my sig for debugging?
R.

[specki]

no, now I will do it and then report


edit.

Code: Select all

06/15/2011 10:35:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (161, '', '2011-06-15 10:35:02', 'apache_total_hits:7 apache_total_kbytes:1 apache_busy_workers:2 apache_idle_workers:3 thread_O:145 threadC:0 threadD:0 threadG:0 threadI:0 threadK:0 threadL:0 threadR:0 threadS:0 threadW:2 thread_W:3')'

The error came as a grad