Hey guys,
Its me, again. This time I'm wondering what's up with the IPMI feature? I gave my IPMI a hostname in /etc/hosts and set the proper username and password, and it's not showing any data like CPU temperatures.I have a feeling its not even polling anything from the IPMI. I have the Module called ipmi enabled on global and the device itself. The FAQ didn't seem to provide any info related to IPMI usage.
Thanks.
On 28/03/2013 0:09, List User wrote:
Hey guys,
Its me, again. This time I'm wondering what's up with the IPMI feature? I gave my IPMI a hostname in /etc/hosts and set the proper username and password, and it's not showing any data like CPU temperatures.I have a feeling its not even polling anything from the IPMI. I have the Module called ipmi enabled on global and the device itself. The FAQ didn't seem to provide any info related to IPMI usage.
Hi,
Nothing up, works fine for me... ;-)
What does your poller log show?
Tom
Poller log for that device:
---------------------------------------------------------------- Observium Poller v0.13.3.3827
Starting polling run:
dal1.rsgs.net 1 windows Module [ unix-agent ] disabled globally. Using SNMP Agent sysUpTime (69471 seconds) Uptime: 19h 17m 51s
Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) Features: Multiprocessor Serial: IPMI: (146ms) Processor Unknown Processor Type 12% Processor Unknown Processor Type 7% Processor Unknown Processor Type 9% Processor Unknown Processor Type 9% Processor Unknown Processor Type 16% Processor Unknown Processor Type 11% Processor Unknown Processor Type 16% Processor Unknown Processor Type 27% Mempool Virtual Memory: 11.96% Mempool Physical Memory: 20.25% Storage C:\ Label: Serial Number 769c5ccb: 27% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus Port Software Loopback Interface 1(1) Port Disabled. Port WAN Miniport (SSTP)(2) Port Disabled. Port WAN Miniport (L2TP)(3) Port Disabled. Port WAN Miniport (PPTP)(4) Port Disabled. Port WAN Miniport (PPPOE)(5) Port Disabled. Port WAN Miniport (IPv6)(6) Port Disabled. Port WAN Miniport (Network Monitor)(7) Port Disabled. Port WAN Miniport (IP)(8) Port Disabled. Port WAN Miniport (IKEv2)(10) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) Port Microsoft 6to4 Adapter(13) Port Disabled. Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight Filter-0000(18) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight Filter-0000(20) Port Disabled. Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted
OSPF: Processes: Areas: Ports: Neighbours: Mac Accounting:
Entity Physical: Q-BRIDGE-MIB FDB Tables Vlan | MAC | Port (dot1d|ifIndex) | Status ------------------------------------------------------------------------------------------ ping ping_snmp uptime processor mempool storage netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users poller_perf Polled in 8.392 seconds UPDATED!
MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] Update[22/0.01s] Insert[3/0.01s] Delete[0/0s] -----------------------------------------------------------------------------------
Thank you.
On 3/28/2013 7:01 PM, Tom Laermans wrote:
On 28/03/2013 0:09, List User wrote:
Hey guys,
Its me, again. This time I'm wondering what's up with the IPMI feature? I gave my IPMI a hostname in /etc/hosts and set the proper username and password, and it's not showing any data like CPU temperatures.I have a feeling its not even polling anything from the IPMI. I have the Module called ipmi enabled on global and the device itself. The FAQ didn't seem to provide any info related to IPMI usage.
Hi,
Nothing up, works fine for me... ;-)
What does your poller log show?
Tom _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hi,
Looks like the user you're using for IPMI doesn't have access to the sensors. Run the poller with -d, you can see the full ipmitool command we use, and its output as well I believe. Try running the command by hand and see what it outputs.
Tom
On 29/03/2013 3:19, List User wrote:
Poller log for that device:
Observium Poller v0.13.3.3827
Starting polling run:
dal1.rsgs.net 1 windows Module [ unix-agent ] disabled globally. Using SNMP Agent sysUpTime (69471 seconds) Uptime: 19h 17m 51s
Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) Features: Multiprocessor Serial: IPMI: (146ms) Processor Unknown Processor Type 12% Processor Unknown Processor Type 7% Processor Unknown Processor Type 9% Processor Unknown Processor Type 9% Processor Unknown Processor Type 16% Processor Unknown Processor Type 11% Processor Unknown Processor Type 16% Processor Unknown Processor Type 27% Mempool Virtual Memory: 11.96% Mempool Physical Memory: 20.25% Storage C:\ Label: Serial Number 769c5ccb: 27% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus Port Software Loopback Interface 1(1) Port Disabled. Port WAN Miniport (SSTP)(2) Port Disabled. Port WAN Miniport (L2TP)(3) Port Disabled. Port WAN Miniport (PPTP)(4) Port Disabled. Port WAN Miniport (PPPOE)(5) Port Disabled. Port WAN Miniport (IPv6)(6) Port Disabled. Port WAN Miniport (Network Monitor)(7) Port Disabled. Port WAN Miniport (IP)(8) Port Disabled. Port WAN Miniport (IKEv2)(10) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) Port Microsoft 6to4 Adapter(13) Port Disabled. Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight Filter-0000(18) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight Filter-0000(20) Port Disabled. Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted
OSPF: Processes: Areas: Ports: Neighbours: Mac Accounting:
Entity Physical: Q-BRIDGE-MIB FDB Tables Vlan | MAC | Port (dot1d|ifIndex) | Status
ping ping_snmp uptime processor mempool storage netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users poller_perf Polled in 8.392 seconds UPDATED!
MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] Update[22/0.01s] Insert[3/0.01s] Delete[0/0s]
Thank you.
On 3/28/2013 7:01 PM, Tom Laermans wrote:
On 28/03/2013 0:09, List User wrote:
Hey guys,
Its me, again. This time I'm wondering what's up with the IPMI feature? I gave my IPMI a hostname in /etc/hosts and set the proper username and password, and it's not showing any data like CPU temperatures.I have a feeling its not even polling anything from the IPMI. I have the Module called ipmi enabled on global and the device itself. The FAQ didn't seem to provide any info related to IPMI usage.
Hi,
Nothing up, works fine for me... ;-)
What does your poller log show?
Tom _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Hi,
I am getting a similar issue, in that sensors appear to be added and then immediately deleted by the poller script, resulting in nothing added to Observium.
There are lots of SQL insert statements, followed by SQL DELETE statements on the sensors.
I have configured IPMI on a Dell R420 with iDRAC 7. I've tried giving the user 'administrator' privileges but it makes no difference - The debug output shows the ipmitool command is successfully pulling a large table of sensor data in.
Any help would be very much appreciated. Full debug output can be provided if you want to be spammed :)
Cheers Duncan
On Fri, 29 Mar 2013, Tom Laermans wrote:
Hi,
Looks like the user you're using for IPMI doesn't have access to the sensors. Run the poller with -d, you can see the full ipmitool command we use, and its output as well I believe. Try running the command by hand and see what it outputs.
Tom
On 29/03/2013 3:19, List User wrote:
Poller log for that device:
Observium Poller v0.13.3.3827
Starting polling run:
dal1.rsgs.net 1 windows Module [ unix-agent ] disabled globally. Using SNMP Agent sysUpTime (69471 seconds) Uptime: 19h 17m 51s
Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) Features: Multiprocessor Serial: IPMI: (146ms) Processor Unknown Processor Type 12% Processor Unknown Processor Type 7% Processor Unknown Processor Type 9% Processor Unknown Processor Type 9% Processor Unknown Processor Type 16% Processor Unknown Processor Type 11% Processor Unknown Processor Type 16% Processor Unknown Processor Type 27% Mempool Virtual Memory: 11.96% Mempool Physical Memory: 20.25% Storage C:\ Label: Serial Number 769c5ccb: 27% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus Port Software Loopback Interface 1(1) Port Disabled. Port WAN Miniport (SSTP)(2) Port Disabled. Port WAN Miniport (L2TP)(3) Port Disabled. Port WAN Miniport (PPTP)(4) Port Disabled. Port WAN Miniport (PPPOE)(5) Port Disabled. Port WAN Miniport (IPv6)(6) Port Disabled. Port WAN Miniport (Network Monitor)(7) Port Disabled. Port WAN Miniport (IP)(8) Port Disabled. Port WAN Miniport (IKEv2)(10) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) Port Microsoft 6to4 Adapter(13) Port Disabled. Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight Filter-0000(18) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight Filter-0000(20) Port Disabled. Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted
OSPF: Processes: Areas: Ports: Neighbours: Mac Accounting:
Entity Physical: Q-BRIDGE-MIB FDB Tables Vlan | MAC | Port (dot1d|ifIndex) | Status
ping ping_snmp uptime processor mempool storage netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users poller_perf Polled in 8.392 seconds UPDATED!
MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] Update[22/0.01s] Insert[3/0.01s] Delete[0/0s]
Thank you.
On 3/28/2013 7:01 PM, Tom Laermans wrote:
On 28/03/2013 0:09, List User wrote:
Hey guys,
Its me, again. This time I'm wondering what's up with the IPMI feature? I gave my IPMI a hostname in /etc/hosts and set the proper username and password, and it's not showing any data like CPU temperatures.I have a feeling its not even polling anything from the IPMI. I have the Module called ipmi enabled on global and the device itself. The FAQ didn't seem to provide any info related to IPMI usage.
Hi,
Nothing up, works fine for me... ;-)
What does your poller log show?
Tom _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Below is the debug polling log for IPMI
------------------------------------------- including: includes/polling/ipmi.inc.php IPMI: SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_hostname'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_username'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_password'] /usr/bin/ipmitool -H ipmi.dal1.priv -L USER -U <SNIPPED> -P <SNIPPED> sensor 2>/dev/null
(146ms) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] including: includes/polling/sensors.inc.php
SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'current' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'frequency' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'humidity' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'fanspeed' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'power' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'voltage' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'temperature' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'dbm' AND `device_id` = '1'] ----------------------------------------------------------
Thank you.
On 3/29/2013 4:23 PM, Duncan B. wrote:
Hi,
I am getting a similar issue, in that sensors appear to be added and then immediately deleted by the poller script, resulting in nothing added to Observium.
There are lots of SQL insert statements, followed by SQL DELETE statements on the sensors.
I have configured IPMI on a Dell R420 with iDRAC 7. I've tried giving the user 'administrator' privileges but it makes no difference - The debug output shows the ipmitool command is successfully pulling a large table of sensor data in.
Any help would be very much appreciated. Full debug output can be provided if you want to be spammed :)
Cheers Duncan
On Fri, 29 Mar 2013, Tom Laermans wrote:
Hi,
Looks like the user you're using for IPMI doesn't have access to the sensors. Run the poller with -d, you can see the full ipmitool command we use, and its output as well I believe. Try running the command by hand and see what it outputs.
Tom
On 29/03/2013 3:19, List User wrote:
Poller log for that device:
Observium Poller v0.13.3.3827
Starting polling run:
dal1.rsgs.net 1 windows Module [ unix-agent ] disabled globally. Using SNMP Agent sysUpTime (69471 seconds) Uptime: 19h 17m 51s
Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) Features: Multiprocessor Serial: IPMI: (146ms) Processor Unknown Processor Type 12% Processor Unknown Processor Type 7% Processor Unknown Processor Type 9% Processor Unknown Processor Type 9% Processor Unknown Processor Type 16% Processor Unknown Processor Type 11% Processor Unknown Processor Type 16% Processor Unknown Processor Type 27% Mempool Virtual Memory: 11.96% Mempool Physical Memory: 20.25% Storage C:\ Label: Serial Number 769c5ccb: 27% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus Port Software Loopback Interface 1(1) Port Disabled. Port WAN Miniport (SSTP)(2) Port Disabled. Port WAN Miniport (L2TP)(3) Port Disabled. Port WAN Miniport (PPTP)(4) Port Disabled. Port WAN Miniport (PPPOE)(5) Port Disabled. Port WAN Miniport (IPv6)(6) Port Disabled. Port WAN Miniport (Network Monitor)(7) Port Disabled. Port WAN Miniport (IP)(8) Port Disabled. Port WAN Miniport (IKEv2)(10) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) Port Microsoft 6to4 Adapter(13) Port Disabled. Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight Filter-0000(18) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight Filter-0000(20) Port Disabled. Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted
OSPF: Processes: Areas: Ports: Neighbours: Mac Accounting:
Entity Physical: Q-BRIDGE-MIB FDB Tables Vlan | MAC | Port (dot1d|ifIndex) | Status
ping ping_snmp uptime processor mempool storage netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users poller_perf Polled in 8.392 seconds UPDATED!
MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] Update[22/0.01s] Insert[3/0.01s] Delete[0/0s]
Thank you.
On 3/28/2013 7:01 PM, Tom Laermans wrote:
On 28/03/2013 0:09, List User wrote:
Hey guys,
Its me, again. This time I'm wondering what's up with the IPMI feature? I gave my IPMI a hostname in /etc/hosts and set the proper username and password, and it's not showing any data like CPU temperatures.I have a feeling its not even polling anything from the IPMI. I have the Module called ipmi enabled on global and the device itself. The FAQ didn't seem to provide any info related to IPMI usage.
Hi,
Nothing up, works fine for me... ;-)
What does your poller log show?
Tom _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Just an update, when I used my RADIUS login on the IPMI tool, it said Invalid username, so I made a regular account on it and it works fine. (Tested with operator access).
Thank you.
On 3/29/2013 4:42 PM, List User wrote:
Below is the debug polling log for IPMI
including: includes/polling/ipmi.inc.php IPMI: SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_hostname'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_username'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_password'] /usr/bin/ipmitool -H ipmi.dal1.priv -L USER -U <SNIPPED> -P <SNIPPED> sensor 2>/dev/null
(146ms) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] including: includes/polling/sensors.inc.php
SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'current' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'frequency' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'humidity' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'fanspeed' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'power' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'voltage' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'temperature' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'dbm' AND `device_id` = '1']
Thank you.
On 3/29/2013 4:23 PM, Duncan B. wrote:
Hi,
I am getting a similar issue, in that sensors appear to be added and then immediately deleted by the poller script, resulting in nothing added to Observium.
There are lots of SQL insert statements, followed by SQL DELETE statements on the sensors.
I have configured IPMI on a Dell R420 with iDRAC 7. I've tried giving the user 'administrator' privileges but it makes no difference
- The debug output shows the ipmitool command is successfully pulling
a large table of sensor data in.
Any help would be very much appreciated. Full debug output can be provided if you want to be spammed :)
Cheers Duncan
On Fri, 29 Mar 2013, Tom Laermans wrote:
Hi,
Looks like the user you're using for IPMI doesn't have access to the sensors. Run the poller with -d, you can see the full ipmitool command we use, and its output as well I believe. Try running the command by hand and see what it outputs.
Tom
On 29/03/2013 3:19, List User wrote:
Poller log for that device:
Observium Poller v0.13.3.3827
Starting polling run:
dal1.rsgs.net 1 windows Module [ unix-agent ] disabled globally. Using SNMP Agent sysUpTime (69471 seconds) Uptime: 19h 17m 51s
Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) Features: Multiprocessor Serial: IPMI: (146ms) Processor Unknown Processor Type 12% Processor Unknown Processor Type 7% Processor Unknown Processor Type 9% Processor Unknown Processor Type 9% Processor Unknown Processor Type 16% Processor Unknown Processor Type 11% Processor Unknown Processor Type 16% Processor Unknown Processor Type 27% Mempool Virtual Memory: 11.96% Mempool Physical Memory: 20.25% Storage C:\ Label: Serial Number 769c5ccb: 27% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus Port Software Loopback Interface 1(1) Port Disabled. Port WAN Miniport (SSTP)(2) Port Disabled. Port WAN Miniport (L2TP)(3) Port Disabled. Port WAN Miniport (PPTP)(4) Port Disabled. Port WAN Miniport (PPPOE)(5) Port Disabled. Port WAN Miniport (IPv6)(6) Port Disabled. Port WAN Miniport (Network Monitor)(7) Port Disabled. Port WAN Miniport (IP)(8) Port Disabled. Port WAN Miniport (IKEv2)(10) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) Port Microsoft 6to4 Adapter(13) Port Disabled. Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight Filter-0000(18) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight Filter-0000(20) Port Disabled. Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted
OSPF: Processes: Areas: Ports: Neighbours: Mac Accounting:
Entity Physical: Q-BRIDGE-MIB FDB Tables Vlan | MAC | Port (dot1d|ifIndex) | Status
ping ping_snmp uptime processor mempool storage netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users poller_perf Polled in 8.392 seconds UPDATED!
MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] Update[22/0.01s] Insert[3/0.01s] Delete[0/0s]
Thank you.
On 3/28/2013 7:01 PM, Tom Laermans wrote:
On 28/03/2013 0:09, List User wrote:
Hey guys,
Its me, again. This time I'm wondering what's up with the IPMI feature? I gave my IPMI a hostname in /etc/hosts and set the proper username and password, and it's not showing any data like CPU temperatures.I have a feeling its not even polling anything from the IPMI. I have the Module called ipmi enabled on global and the device itself. The FAQ didn't seem to provide any info related to IPMI usage.
Hi,
Nothing up, works fine for me... ;-)
What does your poller log show?
Tom _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Sorry, for the triple post. Same issue as Duncan now...
------------------ 03/29/13 4:56 PM System Sensor Deleted: fanspeed ipmi 6 FAN 4 03/29/13 4:56 PM System Sensor Deleted: fanspeed ipmi 4 FAN 2 03/29/13 4:56 PM System Sensor Deleted: temperature ipmi 1 System Temp 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 16 AVCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 15 VSB 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 14 VBAT 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 13 -12V 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 12 5VCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 11 VDIMM 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 10 12V 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 9 3.3VCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 8 Vcore 03/29/13 4:56 PM System Sensor Added: voltage ipmi 16 AVCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 15 VSB 03/29/13 4:56 PM System Sensor Added: voltage ipmi 14 VBAT 03/29/13 4:56 PM System Sensor Added: voltage ipmi 13 -12V 03/29/13 4:56 PM System Sensor Added: voltage ipmi 12 5VCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 11 VDIMM 03/29/13 4:56 PM System Sensor Added: voltage ipmi 10 12V 03/29/13 4:56 PM System Sensor Added: voltage ipmi 9 3.3VCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 8 Vcore 03/29/13 4:56 PM System Sensor Added: fanspeed ipmi 6 FAN 4 03/29/13 4:56 PM System Sensor Added: fanspeed ipmi 4 FAN 2 03/29/13 4:56 PM System Sensor Added: temperature ipmi 1 System Temp
--------------------------------
Thank you.
On 3/29/2013 4:55 PM, List User wrote:
Just an update, when I used my RADIUS login on the IPMI tool, it said Invalid username, so I made a regular account on it and it works fine. (Tested with operator access).
Thank you.
On 3/29/2013 4:42 PM, List User wrote:
Below is the debug polling log for IPMI
including: includes/polling/ipmi.inc.php IPMI: SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_hostname'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_username'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_password'] /usr/bin/ipmitool -H ipmi.dal1.priv -L USER -U <SNIPPED> -P <SNIPPED> sensor 2>/dev/null
(146ms) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] including: includes/polling/sensors.inc.php
SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'current' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'frequency' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'humidity' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'fanspeed' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'power' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'voltage' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'temperature' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'dbm' AND `device_id` = '1']
Thank you.
On 3/29/2013 4:23 PM, Duncan B. wrote:
Hi,
I am getting a similar issue, in that sensors appear to be added and then immediately deleted by the poller script, resulting in nothing added to Observium.
There are lots of SQL insert statements, followed by SQL DELETE statements on the sensors.
I have configured IPMI on a Dell R420 with iDRAC 7. I've tried giving the user 'administrator' privileges but it makes no difference - The debug output shows the ipmitool command is successfully pulling a large table of sensor data in.
Any help would be very much appreciated. Full debug output can be provided if you want to be spammed :)
Cheers Duncan
On Fri, 29 Mar 2013, Tom Laermans wrote:
Hi,
Looks like the user you're using for IPMI doesn't have access to the sensors. Run the poller with -d, you can see the full ipmitool command we use, and its output as well I believe. Try running the command by hand and see what it outputs.
Tom
On 29/03/2013 3:19, List User wrote:
Poller log for that device:
Observium Poller v0.13.3.3827
Starting polling run:
dal1.rsgs.net 1 windows Module [ unix-agent ] disabled globally. Using SNMP Agent sysUpTime (69471 seconds) Uptime: 19h 17m 51s
Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) Features: Multiprocessor Serial: IPMI: (146ms) Processor Unknown Processor Type 12% Processor Unknown Processor Type 7% Processor Unknown Processor Type 9% Processor Unknown Processor Type 9% Processor Unknown Processor Type 16% Processor Unknown Processor Type 11% Processor Unknown Processor Type 16% Processor Unknown Processor Type 27% Mempool Virtual Memory: 11.96% Mempool Physical Memory: 20.25% Storage C:\ Label: Serial Number 769c5ccb: 27% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus Port Software Loopback Interface 1(1) Port Disabled. Port WAN Miniport (SSTP)(2) Port Disabled. Port WAN Miniport (L2TP)(3) Port Disabled. Port WAN Miniport (PPTP)(4) Port Disabled. Port WAN Miniport (PPPOE)(5) Port Disabled. Port WAN Miniport (IPv6)(6) Port Disabled. Port WAN Miniport (Network Monitor)(7) Port Disabled. Port WAN Miniport (IP)(8) Port Disabled. Port WAN Miniport (IKEv2)(10) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) Port Microsoft 6to4 Adapter(13) Port Disabled. Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight Filter-0000(18) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight Filter-0000(20) Port Disabled. Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted
OSPF: Processes: Areas: Ports: Neighbours: Mac Accounting:
Entity Physical: Q-BRIDGE-MIB FDB Tables Vlan | MAC | Port (dot1d|ifIndex) | Status
ping ping_snmp uptime processor mempool storage netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users poller_perf Polled in 8.392 seconds UPDATED!
MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] Update[22/0.01s] Insert[3/0.01s] Delete[0/0s]
Thank you.
On 3/28/2013 7:01 PM, Tom Laermans wrote:
On 28/03/2013 0:09, List User wrote: > Hey guys, > > Its me, again. This time I'm wondering what's up with the IPMI > feature? I gave my IPMI a hostname in /etc/hosts and set the > proper username and password, and it's not showing any data like > CPU temperatures.I have a feeling its not even polling anything > from the IPMI. I have the Module called ipmi enabled on global > and the device itself. The FAQ didn't seem to provide any info > related to IPMI usage. > Hi,
Nothing up, works fine for me... ;-)
What does your poller log show?
Tom _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Same here. SuperMicro SuperServer 5017C-MTF..
Regards patrick
Am 29.03.2013 21:57, schrieb List User:
Sorry, for the triple post. Same issue as Duncan now...
03/29/13 4:56 PM System Sensor Deleted: fanspeed ipmi 6 FAN 4 03/29/13 4:56 PM System Sensor Deleted: fanspeed ipmi 4 FAN 2 03/29/13 4:56 PM System Sensor Deleted: temperature ipmi 1 System Temp 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 16 AVCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 15 VSB 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 14 VBAT 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 13 -12V 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 12 5VCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 11 VDIMM 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 10 12V 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 9 3.3VCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 8 Vcore 03/29/13 4:56 PM System Sensor Added: voltage ipmi 16 AVCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 15 VSB 03/29/13 4:56 PM System Sensor Added: voltage ipmi 14 VBAT 03/29/13 4:56 PM System Sensor Added: voltage ipmi 13 -12V 03/29/13 4:56 PM System Sensor Added: voltage ipmi 12 5VCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 11 VDIMM 03/29/13 4:56 PM System Sensor Added: voltage ipmi 10 12V 03/29/13 4:56 PM System Sensor Added: voltage ipmi 9 3.3VCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 8 Vcore 03/29/13 4:56 PM System Sensor Added: fanspeed ipmi 6 FAN 4 03/29/13 4:56 PM System Sensor Added: fanspeed ipmi 4 FAN 2 03/29/13 4:56 PM System Sensor Added: temperature ipmi 1 System Temp
Thank you.
On 3/29/2013 4:55 PM, List User wrote:
Just an update, when I used my RADIUS login on the IPMI tool, it said Invalid username, so I made a regular account on it and it works fine. (Tested with operator access).
Thank you.
On 3/29/2013 4:42 PM, List User wrote:
Below is the debug polling log for IPMI
including: includes/polling/ipmi.inc.php IPMI: SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_hostname'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_username'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_password'] /usr/bin/ipmitool -H ipmi.dal1.priv -L USER -U <SNIPPED> -P <SNIPPED> sensor 2>/dev/null
(146ms) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] including: includes/polling/sensors.inc.php
SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'current' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'frequency' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'humidity' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'fanspeed' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'power' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'voltage' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'temperature' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'dbm' AND `device_id` = '1']
Thank you.
On 3/29/2013 4:23 PM, Duncan B. wrote:
Hi,
I am getting a similar issue, in that sensors appear to be added and then immediately deleted by the poller script, resulting in nothing added to Observium.
There are lots of SQL insert statements, followed by SQL DELETE statements on the sensors.
I have configured IPMI on a Dell R420 with iDRAC 7. I've tried giving the user 'administrator' privileges but it makes no difference - The debug output shows the ipmitool command is successfully pulling a large table of sensor data in.
Any help would be very much appreciated. Full debug output can be provided if you want to be spammed :)
Cheers Duncan
On Fri, 29 Mar 2013, Tom Laermans wrote:
Hi,
Looks like the user you're using for IPMI doesn't have access to the sensors. Run the poller with -d, you can see the full ipmitool command we use, and its output as well I believe. Try running the command by hand and see what it outputs.
Tom
On 29/03/2013 3:19, List User wrote:
Poller log for that device:
Observium Poller v0.13.3.3827
Starting polling run:
dal1.rsgs.net 1 windows Module [ unix-agent ] disabled globally. Using SNMP Agent sysUpTime (69471 seconds) Uptime: 19h 17m 51s
Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) Features: Multiprocessor Serial: IPMI: (146ms) Processor Unknown Processor Type 12% Processor Unknown Processor Type 7% Processor Unknown Processor Type 9% Processor Unknown Processor Type 9% Processor Unknown Processor Type 16% Processor Unknown Processor Type 11% Processor Unknown Processor Type 16% Processor Unknown Processor Type 27% Mempool Virtual Memory: 11.96% Mempool Physical Memory: 20.25% Storage C: Label: Serial Number 769c5ccb: 27% Polling Netstats: IP TCP UDP ICMP SNMP HR Stats: Processes Users Polling IP-MIB ipSystemStats Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus Port Software Loopback Interface 1(1) Port Disabled. Port WAN Miniport (SSTP)(2) Port Disabled. Port WAN Miniport (L2TP)(3) Port Disabled. Port WAN Miniport (PPTP)(4) Port Disabled. Port WAN Miniport (PPPOE)(5) Port Disabled. Port WAN Miniport (IPv6)(6) Port Disabled. Port WAN Miniport (Network Monitor)(7) Port Disabled. Port WAN Miniport (IP)(8) Port Disabled. Port WAN Miniport (IKEv2)(10) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) Port Microsoft 6to4 Adapter(13) Port Disabled. Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight Filter-0000(18) Port Disabled. Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight Filter-0000(20) Port Disabled. Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted Port () Port Deleted
OSPF: Processes: Areas: Ports: Neighbours: Mac Accounting:
Entity Physical: Q-BRIDGE-MIB FDB Tables Vlan | MAC | Port (dot1d|ifIndex) | Status
ping ping_snmp uptime processor mempool storage netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users poller_perf Polled in 8.392 seconds UPDATED!
MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] Update[22/0.01s] Insert[3/0.01s] Delete[0/0s]
Thank you.
On 3/28/2013 7:01 PM, Tom Laermans wrote:
> On 28/03/2013 0:09, List User wrote: > >> Hey guys, >> >> Its me, again. This time I'm wondering what's up with the IPMI >> feature? I gave my IPMI a hostname in /etc/hosts and set the >> proper username and password, and it's not showing any data like >> CPU temperatures.I have a feeling its not even polling anything >> from the IPMI. I have the Module called ipmi enabled on global >> and the device itself. The FAQ didn't seem to provide any info >> related to IPMI usage. > Hi, > > Nothing up, works fine for me... ;-) > > What does your poller log show? > > Tom > _______________________________________________ > observium mailing list > observium@observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
Links:
[1] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
r3843 (sid3windr): fix ipmi data polling, add extra debug info
Still doing same behavior of add and delete.
Thank you.
On 3/29/2013 5:25 PM, observium@velder.li wrote:
Same here. SuperMicro SuperServer 5017C-MTF..
Regards patrick
Am 29.03.2013 21:57, schrieb List User:
Sorry, for the triple post. Same issue as Duncan now...
03/29/13 4:56 PM System Sensor Deleted: fanspeed ipmi 6 FAN 4 03/29/13 4:56 PM System Sensor Deleted: fanspeed ipmi 4 FAN 2 03/29/13 4:56 PM System Sensor Deleted: temperature ipmi 1 System Temp 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 16 AVCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 15 VSB 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 14 VBAT 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 13 -12V 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 12 5VCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 11 VDIMM 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 10 12V 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 9 3.3VCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 8 Vcore 03/29/13 4:56 PM System Sensor Added: voltage ipmi 16 AVCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 15 VSB 03/29/13 4:56 PM System Sensor Added: voltage ipmi 14 VBAT 03/29/13 4:56 PM System Sensor Added: voltage ipmi 13 -12V 03/29/13 4:56 PM System Sensor Added: voltage ipmi 12 5VCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 11 VDIMM 03/29/13 4:56 PM System Sensor Added: voltage ipmi 10 12V 03/29/13 4:56 PM System Sensor Added: voltage ipmi 9 3.3VCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 8 Vcore 03/29/13 4:56 PM System Sensor Added: fanspeed ipmi 6 FAN 4 03/29/13 4:56 PM System Sensor Added: fanspeed ipmi 4 FAN 2 03/29/13 4:56 PM System Sensor Added: temperature ipmi 1 System Temp
Thank you.
On 3/29/2013 4:55 PM, List User wrote:
Just an update, when I used my RADIUS login on the IPMI tool, it said Invalid username, so I made a regular account on it and it works fine. (Tested with operator access).
Thank you.
On 3/29/2013 4:42 PM, List User wrote:
Below is the debug polling log for IPMI
including: includes/polling/ipmi.inc.php IPMI: SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_hostname'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_username'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_password'] /usr/bin/ipmitool -H ipmi.dal1.priv -L USER -U <SNIPPED> -P <SNIPPED> sensor 2>/dev/null
(146ms) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] including: includes/polling/sensors.inc.php
SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'current' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'frequency' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'humidity' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'fanspeed' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'power' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'voltage' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'temperature' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'dbm' AND `device_id` = '1']
Thank you.
On 3/29/2013 4:23 PM, Duncan B. wrote:
Hi,
I am getting a similar issue, in that sensors appear to be added and then immediately deleted by the poller script, resulting in nothing added to Observium.
There are lots of SQL insert statements, followed by SQL DELETE statements on the sensors.
I have configured IPMI on a Dell R420 with iDRAC 7. I've tried giving the user 'administrator' privileges but it makes no difference - The debug output shows the ipmitool command is successfully pulling a large table of sensor data in.
Any help would be very much appreciated. Full debug output can be provided if you want to be spammed :)
Cheers Duncan
On Fri, 29 Mar 2013, Tom Laermans wrote:
Hi,
Looks like the user you're using for IPMI doesn't have access to the sensors. Run the poller with -d, you can see the full ipmitool command we use, and its output as well I believe. Try running the command by hand and see what it outputs.
Tom
On 29/03/2013 3:19, List User wrote:
> Poller log for that device: > > ---------------------------------------------------------------- > Observium Poller v0.13.3.3827 > > Starting polling run: > > dal1.rsgs.net 1 windows > Module [ unix-agent ] disabled globally. > Using SNMP Agent sysUpTime (69471 seconds) > Uptime: 19h 17m 51s > > Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) > Features: Multiprocessor Serial: > IPMI: (146ms) > Processor Unknown Processor Type 12% > Processor Unknown Processor Type 7% > Processor Unknown Processor Type 9% > Processor Unknown Processor Type 9% > Processor Unknown Processor Type 16% > Processor Unknown Processor Type 11% > Processor Unknown Processor Type 16% > Processor Unknown Processor Type 27% > Mempool Virtual Memory: 11.96% > Mempool Physical Memory: 20.25% > Storage C: Label: Serial Number 769c5ccb: 27% > Polling Netstats: IP TCP UDP ICMP SNMP > HR Stats: Processes Users > Polling IP-MIB ipSystemStats > Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus > Port Software Loopback Interface 1(1) Port Disabled. > Port WAN Miniport (SSTP)(2) Port Disabled. > Port WAN Miniport (L2TP)(3) Port Disabled. > Port WAN Miniport (PPTP)(4) Port Disabled. > Port WAN Miniport (PPPOE)(5) Port Disabled. > Port WAN Miniport (IPv6)(6) Port Disabled. > Port WAN Miniport (Network Monitor)(7) Port Disabled. > Port WAN Miniport (IP)(8) Port Disabled. > Port WAN Miniport (IKEv2)(10) Port Disabled. > Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == > bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) > Port Microsoft 6to4 Adapter(13) Port Disabled. > Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. > Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == > bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) > Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight > Filter-0000(18) Port Disabled. > Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight > Filter-0000(20) Port Disabled. > Port () Port Deleted > Port () Port Deleted > Port () Port Deleted > Port () Port Deleted > Port () Port Deleted > Port () Port Deleted > Port () Port Deleted > Port () Port Deleted > > OSPF: Processes: Areas: Ports: Neighbours: > Mac Accounting: > > Entity Physical: > Q-BRIDGE-MIB FDB Tables > Vlan | MAC | Port (dot1d|ifIndex) | Status > > ------------------------------------------------------------------------------------------ > ping ping_snmp uptime processor mempool storage netstat_ip > netstat_ip_frag netstat_tcp netstat_udp netstat_icmp > netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes > hr_users poller_perf Polled in 8.392 seconds > UPDATED! > > MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] > Update[22/0.01s] Insert[3/0.01s] Delete[0/0s] > > ----------------------------------------------------------------------------------- > > Thank you. > > On 3/28/2013 7:01 PM, Tom Laermans wrote: > >> On 28/03/2013 0:09, List User wrote: >> >>> Hey guys, >>> >>> Its me, again. This time I'm wondering what's up with the IPMI >>> feature? I gave my IPMI a hostname in /etc/hosts and set the >>> proper username and password, and it's not showing any data >>> like CPU temperatures.I have a feeling its not even polling >>> anything from the IPMI. I have the Module called ipmi enabled >>> on global and the device itself. The FAQ didn't seem to >>> provide any info related to IPMI usage. >> Hi, >> >> Nothing up, works fine for me... ;-) >> >> What does your poller log show? >> >> Tom >> _______________________________________________ >> observium mailing list >> observium@observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1] > > _______________________________________________ > observium mailing list > observium@observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
Links:
[1] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Commit only enable more debugging but I can't see more debug when running poller
On 31.03.2013, at 9:22, List User list@redspeedservers.com wrote:
r3843 (sid3windr): fix ipmi data polling, add extra debug info
Still doing same behavior of add and delete.
Thank you.
On 3/29/2013 5:25 PM, observium@velder.li wrote:
Same here. SuperMicro SuperServer 5017C-MTF..
Regards patrick
Am 29.03.2013 21:57, schrieb List User:
Sorry, for the triple post. Same issue as Duncan now...
03/29/13 4:56 PM System Sensor Deleted: fanspeed ipmi 6 FAN 4 03/29/13 4:56 PM System Sensor Deleted: fanspeed ipmi 4 FAN 2 03/29/13 4:56 PM System Sensor Deleted: temperature ipmi 1 System Temp 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 16 AVCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 15 VSB 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 14 VBAT 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 13 -12V 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 12 5VCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 11 VDIMM 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 10 12V 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 9 3.3VCC 03/29/13 4:56 PM System Sensor Deleted: voltage ipmi 8 Vcore 03/29/13 4:56 PM System Sensor Added: voltage ipmi 16 AVCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 15 VSB 03/29/13 4:56 PM System Sensor Added: voltage ipmi 14 VBAT 03/29/13 4:56 PM System Sensor Added: voltage ipmi 13 -12V 03/29/13 4:56 PM System Sensor Added: voltage ipmi 12 5VCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 11 VDIMM 03/29/13 4:56 PM System Sensor Added: voltage ipmi 10 12V 03/29/13 4:56 PM System Sensor Added: voltage ipmi 9 3.3VCC 03/29/13 4:56 PM System Sensor Added: voltage ipmi 8 Vcore 03/29/13 4:56 PM System Sensor Added: fanspeed ipmi 6 FAN 4 03/29/13 4:56 PM System Sensor Added: fanspeed ipmi 4 FAN 2 03/29/13 4:56 PM System Sensor Added: temperature ipmi 1 System Temp
Thank you.
On 3/29/2013 4:55 PM, List User wrote:
Just an update, when I used my RADIUS login on the IPMI tool, it said Invalid username, so I made a regular account on it and it works fine. (Tested with operator access).
Thank you.
On 3/29/2013 4:42 PM, List User wrote:
Below is the debug polling log for IPMI
including: includes/polling/ipmi.inc.php IPMI: SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_hostname'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_username'] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '1' AND `attrib_type` = 'ipmi_password'] /usr/bin/ipmitool -H ipmi.dal1.priv -L USER -U <SNIPPED> -P <SNIPPED> sensor 2>/dev/null
(146ms) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='' AND S.device_id = D.device_id AND D.device_id = '1' AND S.poller_type = 'ipmi'] including: includes/polling/sensors.inc.php
SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'current' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'frequency' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'humidity' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'fanspeed' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'power' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'voltage' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'temperature' AND `device_id` = '1'] SQL[SELECT *, `sensors`.`sensor_id` AS `sensor_id` FROM `sensors` LEFT JOIN `sensors-state` ON `sensors`.sensor_id = `sensors-state`.sensor_id WHERE `sensor_class` = 'dbm' AND `device_id` = '1']
Thank you.
On 3/29/2013 4:23 PM, Duncan B. wrote:
Hi,
I am getting a similar issue, in that sensors appear to be added and then immediately deleted by the poller script, resulting in nothing added to Observium.
There are lots of SQL insert statements, followed by SQL DELETE statements on the sensors.
I have configured IPMI on a Dell R420 with iDRAC 7. I've tried giving the user 'administrator' privileges but it makes no difference - The debug output shows the ipmitool command is successfully pulling a large table of sensor data in.
Any help would be very much appreciated. Full debug output can be provided if you want to be spammed :)
Cheers Duncan
On Fri, 29 Mar 2013, Tom Laermans wrote:
> Hi, > > Looks like the user you're using for IPMI doesn't have access to the sensors. Run the poller with -d, you can see the full ipmitool command we use, and its output as well I believe. Try running the command by hand and see what it outputs. > > Tom > > On 29/03/2013 3:19, List User wrote: > >> Poller log for that device: >> >> ---------------------------------------------------------------- >> Observium Poller v0.13.3.3827 >> >> Starting polling run: >> >> dal1.rsgs.net 1 windows >> Module [ unix-agent ] disabled globally. >> Using SNMP Agent sysUpTime (69471 seconds) >> Uptime: 19h 17m 51s >> >> Hardware: Intel x64 Version: Server 2008 R2 SP1 (NT 6.1) Features: Multiprocessor Serial: >> IPMI: (146ms) >> Processor Unknown Processor Type 12% >> Processor Unknown Processor Type 7% >> Processor Unknown Processor Type 9% >> Processor Unknown Processor Type 9% >> Processor Unknown Processor Type 16% >> Processor Unknown Processor Type 11% >> Processor Unknown Processor Type 16% >> Processor Unknown Processor Type 27% >> Mempool Virtual Memory: 11.96% >> Mempool Physical Memory: 20.25% >> Storage C: Label: Serial Number 769c5ccb: 27% >> Polling Netstats: IP TCP UDP ICMP SNMP >> HR Stats: Processes Users >> Polling IP-MIB ipSystemStats >> Caching Oids: ifEntry ifXEntry dot3StatsDuplexStatus >> Port Software Loopback Interface 1(1) Port Disabled. >> Port WAN Miniport (SSTP)(2) Port Disabled. >> Port WAN Miniport (L2TP)(3) Port Disabled. >> Port WAN Miniport (PPTP)(4) Port Disabled. >> Port WAN Miniport (PPPOE)(5) Port Disabled. >> Port WAN Miniport (IPv6)(6) Port Disabled. >> Port WAN Miniport (Network Monitor)(7) Port Disabled. >> Port WAN Miniport (IP)(8) Port Disabled. >> Port WAN Miniport (IKEv2)(10) Port Disabled. >> Port Intel(R) 82574L Gigabit Network Connection(11) VLAN == bps(1.89Mbps/10.6Mbps)bytes(3.38MB/19.1MB)pkts(1.91kpps/2.34kpps) >> Port Microsoft 6to4 Adapter(13) Port Disabled. >> Port Teredo Tunneling Pseudo-Interface(14) Port Disabled. >> Port Intel(R) 82579LM Gigabit Network Connection(15) VLAN == bps(0bps/0bps)bytes(0B/0B)pkts(0pps/0pps) >> Port Intel(R) 82579LM Gigabit Network Connection-WFP LightWeight Filter-0000(18) Port Disabled. >> Port Intel(R) 82574L Gigabit Network Connection-WFP LightWeight Filter-0000(20) Port Disabled. >> Port () Port Deleted >> Port () Port Deleted >> Port () Port Deleted >> Port () Port Deleted >> Port () Port Deleted >> Port () Port Deleted >> Port () Port Deleted >> Port () Port Deleted >> >> OSPF: Processes: Areas: Ports: Neighbours: >> Mac Accounting: >> >> Entity Physical: >> Q-BRIDGE-MIB FDB Tables >> Vlan | MAC | Port (dot1d|ifIndex) | Status >> >> ------------------------------------------------------------------------------------------ ping ping_snmp uptime processor mempool storage netstat_ip netstat_ip_frag netstat_tcp netstat_udp netstat_icmp netstat_icmp_info netstat_snmp netstat_snmp_pkt hr_processes hr_users poller_perf Polled in 8.392 seconds >> UPDATED! >> >> MySQL: Cell[0/0s] Row[5/0s] Rows[27/0.01s] Column[0/0s] Update[22/0.01s] Insert[3/0.01s] Delete[0/0s] >> >> ----------------------------------------------------------------------------------- >> Thank you. >> >> On 3/28/2013 7:01 PM, Tom Laermans wrote: >> >>> On 28/03/2013 0:09, List User wrote: >>> >>>> Hey guys, >>>> >>>> Its me, again. This time I'm wondering what's up with the IPMI feature? I gave my IPMI a hostname in /etc/hosts and set the proper username and password, and it's not showing any data like CPU temperatures.I have a feeling its not even polling anything from the IPMI. I have the Module called ipmi enabled on global and the device itself. The FAQ didn't seem to provide any info related to IPMI usage. >>> Hi, >>> >>> Nothing up, works fine for me... ;-) >>> >>> What does your poller log show? >>> >>> Tom >>> _______________________________________________ >>> observium mailing list >>> observium@observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1] >> >> _______________________________________________ >> observium mailing list >> observium@observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1] > > _______________________________________________ > observium mailing list > observium@observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1] _______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [1]
Links:
[1] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (5)
-
Duncan B. -
List User -
Nikolay Shopik -
observium＠velder.li -
Tom Laermans