[XML] successor to apachestats 0.4

Post by **gandalf** » Thu Feb 16, 2006 3:21 pm

Hmm, weird. I hoped that sth would not be update but new. So please delete the wrong Graphs and all referenced Data Sources and try to re-create. Tell us your findings.
Reinhard

jmeyerdo · Post by **jmeyerdo** » Fri Feb 17, 2006 2:20 am

Hello!

Thank you for your further tipp.
I deleted the graph - but there is no datasource to delete. Maybe this is the problem?

I created a new graph and get the same error:

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Apache Statistics - Hits / s" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="Hits/sec" \
AREA:#AAABA1:"Hits/sec"  \
GPRINT::LAST:"Current\:%8.2lf %s"  \
GPRINT::AVERAGE:"Average\:%8.2lf %s"  \
GPRINT::MAX:"Maximum\:%8.2lf %s\n"  \
COMMENT:"                            Represents the number of hits per second\n"  \
COMMENT:"                                 ApacheStats v0.4 - Rolf Poser\n" 
RRDTool Says:

ERROR: can't parse '#AAABA1:Hits/sec'

There is still no Data Source in list.

Kind regards, Jens

Post by **gandalf** » Mon Feb 20, 2006 1:06 pm

jmeyerdo wrote:Hello!

Thank you for your answer.
I re-imported (without deletion - is this ok?) the xml-template.
FInd output attached to this post.

Kind regards (from Dortmund), Jens

Hi, Jens.
Nice to talk english to you when you're no more than 50 km away from me...

I had a more precise look at your previous post and noticed that there's sth weird with the XML you're using. My original post does contain at least two more Graph Templates. So please have a look at your XML file and tell me whether you find sth like

Code: Select all

<name>WebServer - Apache Statistics - CPU Load</name>
and
<name>WebServer - Apache Statistics - Thread Scoreboard</name>

in there. Both are part of my XML file but not shown in your Import Log.
Definitively, in your last post the DEFs are still missing, be it due to the missing Data Sources or ...
Reinhard

jmeyerdo · Post by **jmeyerdo** » Tue Feb 21, 2006 2:03 am

Hello (hallo nach Münster

)!

Thank you for your answer: You are right, the two Graph-templates were missing. Hmm, perhaps I mixed up old and actual version of apache-stats with my several installation-/debug-attempts.

I reinstalled your perl-skript and your xml-templates again (everything was updating, no new entries) and everything works fine now.

Thank you for your help and have a nice day!
Kind regards, Jens

azel · Post by **azel** » Mon May 01, 2006 7:48 am

Hi I'm trying to get this script to work.
But to make things more complicated, i can't access my Apache via localhost, due to some strange redirect issues on my default website. But created a new device so its no trouble at all (hopefully!?).

Oke, callling the perl script from shell seems to work:

Code: Select all

[root@www ~]# /home/www/cacti/scripts/ws_apachestats.pl www.azel56.net
apache_total_hits:165 apache_total_kbytes:90335 apache_busy_workers:2 apache_idl
e_workers:7 thread_O:247 threadC:0 threadD:0 threadG:0 threadI:0 threadK:0 threa
dL:0 threadR:0 threadS:0 threadW:2 thread_W:7 apache_cpuload:.582229[root@www ~]

Calling the PHP Script on the other hand gives me some wierd output:

Code: Select all

[root@www ~]# /home/www/cacti/poller.php www.azel56.net
Use of uninitialized value in concatenation (.) or string at /home/www/cacti/scripts/ws_apachestats.pl line 63.
Use of uninitialized value in concatenation (.) or string at /home/www/cacti/scripts/ws_apachestats.pl line 65.
Use of uninitialized value in concatenation (.) or string at /home/www/cacti/scripts/ws_apachestats.pl line 67.
Use of uninitialized value in concatenation (.) or string at /home/www/cacti/scripts/ws_apachestats.pl line 69.
Use of uninitialized value in split at /home/www/cacti/scripts/ws_apachestats.pl line 89. 
[...repeats 5 times...]
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.00
OK u:0.00 s:0.01 r:0.01
OK u:0.00 s:0.01 r:0.01
OK u:0.00 s:0.01 r:0.01
OK u:0.00 s:0.01 r:0.01
OK u:0.00 s:0.01 r:0.01
OK u:0.00 s:0.01 r:0.01
05/01/2006 02:26:17 PM - SYSTEM STATS: Time:3.0722 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:35 RRDsProcessed:23

As a result of this, i can't see any graph, just a link.
Ah well, maybe I should add that domain/server-status?auto gives me a result:

Code: Select all

Total Accesses: 157
Total kBytes: 76717
CPULoad: .630316
Uptime: 2751
ReqPerSec: .0570702
BytesPerSec: 28556.2
BytesPerReq: 500371
BusyWorkers: 2
IdleWorkers: 7
Scoreboard: ___W___W_..........................................................................................................................................

So it's obviously not a problem of my webserver.

Do you have any ideas what i did wrong? Do you need any logs or screenshots?

Thx in advance
azel

Post by **gandalf** » Mon May 01, 2006 10:24 am

azel wrote: Oke, callling the perl script from shell seems to work:

Code: Select all

[root@www ~]# /home/www/cacti/scripts/ws_apachestats.pl www.azel56.net
apache_total_hits:165 apache_total_kbytes:90335 apache_busy_workers:2 apache_idl
e_workers:7 thread_O:247 threadC:0 threadD:0 threadG:0 threadI:0 threadK:0 threa
dL:0 threadR:0 threadS:0 threadW:2 thread_W:7 apache_cpuload:.582229[root@www ~]

Fine, well done.

Calling the PHP Script on the other hand gives me some wierd output:

Code: Select all

[root@www ~]# /home/www/cacti/poller.php www.azel56.net[/quote]You're not supposed to run this. The poller does not need any parameter. For debugging purpose, please switch [b]Settings->Logging Level[/b] to DEBUg for one polling cycle and check log/cacti.log afterwards. There, you should find your URL and the results. If in doubt, please post, appending this snippet of the log
Reinhard

azel · Post by **azel** » Thu May 04, 2006 5:23 pm

hi reinhard,
i tried that log thingie you suggested.
i figured out, that the new device doesn't respond to snmp (it's accessed via it's fqdn) so it appears as "down"

The reason is my firewall/ids. It blocks this snmp connection attempt on the way in, so i don't think that there is a way to monitor my webserver without permitting this traffic. And I don't want to permit this.
Do i really need snmp for every new device?

Post by **gandalf** » Fri May 05, 2006 9:47 am

azel wrote:hi reinhard,
i tried that log thingie you suggested.
i figured out, that the new device doesn't respond to snmp (it's accessed via it's fqdn) so it appears as "down"

The reason is my firewall/ids. It blocks this snmp connection attempt on the way in, so i don't think that there is a way to monitor my webserver without permitting this traffic. And I don't want to permit this.
Do i really need snmp for every new device?

For that http stuff, SNMP is not needed. To suppress Downed Host Detection for this, simply leave the Devices community string empty
Reinhard

azel · Post by **azel** » Fri May 05, 2006 3:19 pm

To suppress Downed Host Detection for this, simply leave the Devices community string empty

yep, that did the trick

thx

//edit: all graphs are working, except the apache CPU-Load graph. Will check it tomorrow

raintonr · Post by **raintonr** » Fri May 19, 2006 3:51 pm

azel wrote: //edit: all graphs are working, except the apache CPU-Load graph. Will check it tomorrow

I'm finding this too, which is weird. The output I see is:

Code: Select all

apache_total_hits:396 apache_total_kbytes:454 apache_busy_workers:1 apache_idle_workers:8 thread_O:247 threadC:0 threadD:0 threadG:0 threadI:0 threadK:0 threadL:0 threadR:0 threadS:0 threadW:1 thread_W:8 apache_cpuload:.188748

And all are graphed correctly aside from cpuload. There's nothing telltail in the poller log, any ideas?

Post by **gandalf** » Sun May 21, 2006 3:44 am

Please post a screenshot of the failing cpu graph. Then, please select the graph, click the wrench and post the whole rrdtool graph statement
Reinhard

websat · Post by **websat** » Fri Jun 02, 2006 1:41 pm

Hi
I installed the script, the graphs are created, but no data on them, i think the problem is from the server-status, i have apache 2.2.2 + php 5.1.4.

server-status:

Apache Server Status for localhost

Server Version: Apache/2.2.2 (Win32) PHP/5.1.4
Server Built: Apr 29 2006 18:32:31

Current Time: Friday, 02-Jun-2006 20:40:23 Paris, Madrid
Restart Time: Friday, 02-Jun-2006 17:52:19 Paris, Madrid
Parent Server Generation: 12
Server uptime: 2 hours 48 minutes 3 seconds
Total accesses: 835 - Total Traffic: 5.0 MB
.0828 requests/sec - 516 B/second - 6.1 kB/request
1 requests currently being processed, 249 idle workers

server-status?auto:

Total Accesses: 836
Total kBytes: 5087
Uptime: 10098
ReqPerSec: .0827887
BytesPerSec: 515.853
BytesPerReq: 6230.97
BusyWorkers: 1
IdleWorkers: 249
Scoreboard: _________

if someone can help me...

Post by **gandalf** » Fri Jun 02, 2006 2:30 pm

Please switch Settings -> Logging Level to DEBUG for one polling cycle and watch ./log/cacti.log for values retrieved for the web server and post them
Reinhard

websat · Post by **websat** » Fri Jun 02, 2006 2:50 pm

thanks for your help:

06/02/2006 09:44:34 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
06/02/2006 09:44:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
06/02/2006 09:44:34 PM - 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'"
06/02/2006 09:44:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/02/2006 09:44:34 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
06/02/2006 09:43:15 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=1"
06/02/2006 09:43:15 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=1"
06/02/2006 09:43:15 PM - 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'"
06/02/2006 09:43:15 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
06/02/2006 09:43:15 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_export','ExportTime:10.4792 TotalGraphs:80')"
06/02/2006 09:40:13 PM - EXPORT STATS: ExportTime:10.4792 TotalGraphs:80
06/02/2006 09:40:13 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph D:\wwwroot\graphs-cacti/graph_17_4.png --imgformat=PNG --start=-33053184 --end=-86400 --title="Localhost - |query_dskDeviceDisk| Stats" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="" --slope-mode DEF:a="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskReadTime:AVERAGE DEF:b="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskWriteTim:AVERAGE DEF:c="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskReadQueueLen:AVERAGE DEF:d="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskWriteQueueLe:AVERAGE LINE2:a#00FF00:"Percent Read Time" GPRINT

LAST:" Current\:%8.0lf" GPRINT

AVERAGE:"Average\:%8.0lf" GPRINT

MAX:"Maximum\:%8.0lf\n" LINE2:b#FF0000:"Percent Write Time" GPRINT

LAST:"Current\:%8.0lf" GPRINT

AVERAGE:"Average\:%8.0lf" GPRINT

MAX:"Maximum\:%8.0lf\n" LINE1:c#35962B:"Avg Read Queue" GPRINT:c:LAST:" Current\:%8.0lf" GPRINT:c:AVERAGE:"Average\:%8.0lf" GPRINT:c:MAX:"Maximum\:%8.0lf\n" LINE1:d#750F7D:"Avg Write Queue" GPRINT:d:LAST:" Current\:%8.0lf" GPRINT:d:AVERAGE:"Average\:%8.0lf" GPRINT:d:MAX:"Maximum\:%8.0lf\n"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=17 order by graph_templates_item.sequence"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=17"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=4"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "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=17 limit 0,1"
06/02/2006 09:40:13 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph D:\wwwroot\graphs-cacti/graph_17_3.png --imgformat=PNG --start=-2678400 --end=-7200 --title="Localhost - |query_dskDeviceDisk| Stats" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="" --slope-mode DEF:a="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskReadTime:AVERAGE DEF:b="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskWriteTim:AVERAGE DEF:c="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskReadQueueLen:AVERAGE DEF:d="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskWriteQueueLe:AVERAGE LINE2:a#00FF00:"Percent Read Time" GPRINT

LAST:" Current\:%8.0lf" GPRINT

AVERAGE:"Average\:%8.0lf" GPRINT

MAX:"Maximum\:%8.0lf\n" LINE2:b#FF0000:"Percent Write Time" GPRINT

LAST:"Current\:%8.0lf" GPRINT

AVERAGE:"Average\:%8.0lf" GPRINT

MAX:"Maximum\:%8.0lf\n" LINE1:c#35962B:"Avg Read Queue" GPRINT:c:LAST:" Current\:%8.0lf" GPRINT:c:AVERAGE:"Average\:%8.0lf" GPRINT:c:MAX:"Maximum\:%8.0lf\n" LINE1:d#750F7D:"Avg Write Queue" GPRINT:d:LAST:" Current\:%8.0lf" GPRINT:d:AVERAGE:"Average\:%8.0lf" GPRINT:d:MAX:"Maximum\:%8.0lf\n"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=17 order by graph_templates_item.sequence"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=17"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=3"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "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=17 limit 0,1"
06/02/2006 09:40:13 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph D:\wwwroot\graphs-cacti/graph_17_2.png --imgformat=PNG --start=-604800 --end=-1800 --title="Localhost - |query_dskDeviceDisk| Stats" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="" --slope-mode DEF:a="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskReadTime:AVERAGE DEF:b="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskWriteTim:AVERAGE DEF:c="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskReadQueueLen:AVERAGE DEF:d="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskWriteQueueLe:AVERAGE LINE2:a#00FF00:"Percent Read Time" GPRINT

LAST:" Current\:%8.0lf" GPRINT

AVERAGE:"Average\:%8.0lf" GPRINT

MAX:"Maximum\:%8.0lf\n" LINE2:b#FF0000:"Percent Write Time" GPRINT

LAST:"Current\:%8.0lf" GPRINT

AVERAGE:"Average\:%8.0lf" GPRINT

MAX:"Maximum\:%8.0lf\n" LINE1:c#35962B:"Avg Read Queue" GPRINT:c:LAST:" Current\:%8.0lf" GPRINT:c:AVERAGE:"Average\:%8.0lf" GPRINT:c:MAX:"Maximum\:%8.0lf\n" LINE1:d#750F7D:"Avg Write Queue" GPRINT:d:LAST:" Current\:%8.0lf" GPRINT:d:AVERAGE:"Average\:%8.0lf" GPRINT:d:MAX:"Maximum\:%8.0lf\n"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=17 order by graph_templates_item.sequence"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=17"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=2"
06/02/2006 09:40:13 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "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=17 limit 0,1"
06/02/2006 09:40:12 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph D:\wwwroot\graphs-cacti/graph_17_1.png --imgformat=PNG --start=-86400 --end=-300 --title="Localhost - |query_dskDeviceDisk| Stats" --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="" --slope-mode DEF:a="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskReadTime:AVERAGE DEF:b="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskWriteTim:AVERAGE DEF:c="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskReadQueueLen:AVERAGE DEF:d="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskWriteQueueLe:AVERAGE LINE2:a#00FF00:"Percent Read Time" GPRINT

LAST:" Current\:%8.0lf" GPRINT

AVERAGE:"Average\:%8.0lf" GPRINT

MAX:"Maximum\:%8.0lf\n" LINE2:b#FF0000:"Percent Write Time" GPRINT

LAST:"Current\:%8.0lf" GPRINT

AVERAGE:"Average\:%8.0lf" GPRINT

MAX:"Maximum\:%8.0lf\n" LINE1:c#35962B:"Avg Read Queue" GPRINT:c:LAST:" Current\:%8.0lf" GPRINT:c:AVERAGE:"Average\:%8.0lf" GPRINT:c:MAX:"Maximum\:%8.0lf\n" LINE1:d#750F7D:"Avg Write Queue" GPRINT:d:LAST:" Current\:%8.0lf" GPRINT:d:AVERAGE:"Average\:%8.0lf" GPRINT:d:MAX:"Maximum\:%8.0lf\n"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=17 order by graph_templates_item.sequence"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=17"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select timespan,rows,steps from rra where id=1"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "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=17 limit 0,1"
06/02/2006 09:40:12 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph D:\wwwroot\graphs-cacti/thumb_17.png --imgformat=PNG --start=-86400 --end=-300 --title="Localhost - |query_dskDeviceDisk| Stats" --base=1000 --height=100 --width=300 --alt-autoscale-max --lower-limit=0 --no-legend --vertical-label="" --slope-mode DEF:a="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskReadTime:AVERAGE DEF:b="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":PercentDiskWriteTim:AVERAGE DEF:c="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskReadQueueLen:AVERAGE DEF:d="D\:/wwwroot/cacti/rra/localhost_percentdiskwritetim_21.rrd":AvgDiskWriteQueueLe:AVERAGE LINE2:a#00FF00:"" LINE2:b#FF0000:"" LINE1:c#35962B:"" LINE1:d#750F7D:""
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=21"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=17 order by graph_templates_item.sequence"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=17"
06/02/2006 09:40:12 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "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=17 limit 0,1"
06/02/2006 09:40:12 PM - WEBLOG: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe graph D:\wwwroot\graphs-cacti/graph_10_4.png --imgformat=PNG --start=-33053184 --end=-86400 --title="Localhost - Used Space - Virtual Memory" --rigid --base=1024 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="bytes" --slope-mode DEF:a="D\:/wwwroot/cacti/rra/localhost_hdd_total_13.rrd":hdd_total:AVERAGE DEF:b="D\:/wwwroot/cacti/rra/localhost_hdd_total_13.rrd":hdd_used:AVERAGE AREA:a#002A97:"Total" GPRINT

LAST:"Current\:%8.2lf %s" GPRINT