Dell PowerEdge temperature templates

[fletch]

Hi,
One of our Micro$loth WinBloze SQL servers decided to power itself off at some ungodly hour (while I was on call) - I looked into environmental monitoring for it since the we have this on our Solaris DB servers.
These templates and script will pull the 4 separate thermal sensor readings from your Dell PowerEdge 2550 server (probably works on other models but have not tested those yet)

Import the templates and drop the script in your <cacti>/scripts dir
I wrote a CDEF to convert the Celcius to Farenheit - I hope that somes through in my exported templates - if not, it looks like:

CDEF Items Add

Item Item Value
Item #1 Special Data Source: CURRENT_DATA_SOURCE
Item #2 Custom String: .18
Item #3 Operator: *
Item #4 Custom String: 32
Item #5 Operator: +

I found this site useful for background about what else is available via the OpenManage OIDs (fan RPM, voltage for instance - maybe someone has time to do the fan RPM)

http://web.csma.biz/resources.dellpedge.shtml

(I downloaded the openmanage server 4.5 software from support.dell.com - its 190Mb)

Have a good weekend!

[mmartens]

Hi

It seems to work but no graph is created.
and my poller.php hangs.

Please can you provide me with some help?

When ic go to the data source of the server is seems to be ok:

Data Source Debug

c:/rrdtool/rrdtool.exe create \
c:/Inetpub/wwwroot/cacti/rra/thetis_front_135.rrd \
--step 300 \
DS:cpu1:GAUGE:600:0:U \
DS:cpu2:GAUGE:600:0:U \
DS:riser:GAUGE:600:0:U \
DS:front:GAUGE:600:0:U \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \




her is a debug log:

11/08/2005 07:12:49 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php-win.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 0]
11/08/2005 07:12:49 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php-win.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 14 14]
11/08/2005 07:12:49 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_front_135.rrd --template 1131472860:U
11/08/2005 07:12:49 PM - CMDPHP: Poller[0] ERROR: Either there are no items in the cache or polling is disabled
11/08/2005 07:12:50 PM - PHPSVR: Poller[0] DEBUG: SERVER: cmd
11/08/2005 07:12:50 PM - PHPSVR: Poller[0] DEBUG: GETCWD: c:/inetpub/wwwroot/cacti
11/08/2005 07:12:50 PM - PHPSVR: Poller[0] DEBUG: DIRNAM: c:/inetpub/wwwroot/cacti
11/08/2005 07:12:50 PM - PHPSVR: Poller[0] DEBUG: FILENM: c:\Inetpub\wwwroot\cacti\script_server.php
11/08/2005 07:12:50 PM - PHPSVR: Poller[0] PHP Script Server has Started - Parent is cmd
11/08/2005 07:12:50 PM - CMDPHP: Poller[0] PHP Script Server Started Properly
11/08/2005 07:12:50 PM - CMDPHP: Poller[0] Host[14] PING: Host is alive
11/08/2005 07:12:50 PM - CMDPHP: Poller[0] Host[14] SNMP: Host responded to SNMP
11/08/2005 07:12:50 PM - CMDPHP: Poller[0] Host[14] RECACHE: Processing 3 items in the auto reindex cache for 'Thetis'.
11/08/2005 07:12:50 PM - CMDPHP: Poller[0] Host[14] DS[127] SNMP: v1: Thetis, dsname: users, oid: .1.3.6.1.2.1.25.1.5.0, output: 4
11/08/2005 07:12:50 PM - CMDPHP: Poller[0] Host[14] DS[128] SNMP: v1: Thetis, dsname: proc, oid: .1.3.6.1.2.1.25.1.6.0, output: 42
11/08/2005 07:12:50 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'Thetis 14 1:161:500:public:::MD5::[None] get used 2'
11/08/2005 07:12:50 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_proc_128.rrd --template proc 1131473569:42
11/08/2005 07:12:50 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_users_127.rrd --template users 1131473569:4
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get used 2 output 5964087296
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[129] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get used 2, output: 5964087296
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'Thetis 14 1:161:500:public:::MD5::[None] get total 2'
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get total 2 output 73221439488
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[129] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get total 2, output: 73221439488
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'Thetis 14 1:161:500:public:::MD5::[None] get total 4'
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get total 4 output 2611675136
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[130] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get total 4, output: 2611675136
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'Thetis 14 1:161:500:public:::MD5::[None] get used 4'
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get used 4 output 603586560
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[130] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get used 4, output: 603586560
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'Thetis 14 1:161:500:public:::MD5::[None] get total 5'
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get total 5 output 1072889856
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[131] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get total 5, output: 1072889856
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php' SCRIPT: 'ss_host_disk' CMD: 'Thetis 14 1:161:500:public:::MD5::[None] get used 5'
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get used 5 output 482213888
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[131] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_disk.php ss_host_disk Thetis 14 1:161:500:public:::MD5::[None] get used 5, output: 482213888
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'c:\Inetpub\wwwroot\cacti\scripts\ss_host_cpu.php' SCRIPT: 'ss_host_cpu' CMD: 'Thetis 14 1:161:500:public:::MD5::[None] get usage 0'
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_cpu.php ss_host_cpu Thetis 14 1:161:500:public:::MD5::[None] get usage 0 output 1
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[132] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_cpu.php ss_host_cpu Thetis 14 1:161:500:public:::MD5::[None] get usage 0, output: 1
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] DEBUG: INCLUDE: 'c:\Inetpub\wwwroot\cacti\scripts\ss_host_cpu.php' SCRIPT: 'ss_host_cpu' CMD: 'Thetis 14 1:161:500:public:::MD5::[None] get usage 1'
11/08/2005 07:12:51 PM - PHPSVR: Poller[0] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_cpu.php ss_host_cpu Thetis 14 1:161:500:public:::MD5::[None] get usage 1 output 1
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[133] SERVER: c:\Inetpub\wwwroot\cacti\scripts\ss_host_cpu.php ss_host_cpu Thetis 14 1:161:500:public:::MD5::[None] get usage 1, output: 1
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[134] SNMP: v1: Thetis, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.65539, output: 16240157
11/08/2005 07:12:51 PM - CMDPHP: Poller[0] Host[14] DS[134] SNMP: v1: Thetis, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.65539, output: 242822202
11/08/2005 07:12:51 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_cpu_132.rrd --template cpu 1131473569:1
11/08/2005 07:12:51 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_hdd_total_131.rrd --template hdd_used:hdd_total 1131473569:482213888:1072889856
11/08/2005 07:12:51 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_hdd_total_130.rrd --template hdd_used:hdd_total 1131473569:603586560:2611675136
11/08/2005 07:12:51 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_hdd_total_129.rrd --template hdd_total:hdd_used 1131473569:73221439488:5964087296
11/08/2005 07:12:51 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_cpu_133.rrd --template cpu 1131473569:1
11/08/2005 07:12:51 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_traffic_in_134.rrd --template traffic_out:traffic_in 1131473569:16240157:242822202
11/08/2005 07:14:23 PM - CMDPHP: Poller[0] Host[14] DS[135] WARNING: Result from CMD not valid. Partial Result:
11/08/2005 07:14:23 PM - CMDPHP: Poller[0] Host[14] DS[135] CMD: c:\inetpub\wwwroot\cacti\scripts\poweredge2550_thermalstats.csh Thetis, output: U
11/08/2005 07:14:23 PM - CMDPHP: Poller[0] Time: 93.6074 s, Theads: N/A, Hosts: 1
11/08/2005 07:14:23 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\Inetpub\wwwroot\cacti\rra\thetis_front_135.rrd --template 1131473569:U
11/08/2005 07:14:23 PM - SYSTEM STATS: Time:94.1586 Method:cmd.php Processes:2 Threads:N/A Hosts:2 HostsPerProcess:1 DataSources:13 RRDsProcessed:10
11/08/2005 07:14:23 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php-win.exe, ARGS: -q C:/Inetpub/wwwroot/cacti/poller_commands.php]
11/08/2005 07:14:23 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php-win.exe, ARGS: -q C:/Inetpub/wwwroot/cacti/poller_export.php]


Thanks in advance

[remy74]

I have Another message, perhaps I'm too stupid for use your queries..
When I create a Data Queries, with cacti_data_template_poweredge2550_temperature.xml (and data input : Snmp data.. ??) , I try to add Associated Data TEmplates , who's failed:

Warning: Variable passed to each() is not an array or object in /data/cacti/data_queries.php on line 356
...

Any idea ?

thks

[joed]

look at my other post a few days ago

http://forums.cacti.net/viewtopic.php?t=10089

[yablo]

There's no way to monitor temps without having a running SNMP agent on the server to be monitored, is there?