Not sure if I understand the new set up in 0.46 correctly, but when I follow the example of the HP ILO component page both the Inlet temperature and the CPU fanspeed remain empty. Do I need to fill something in the value template part? I also get an error in the log regarding the server health see below. Is that related with the sensors remaining empty? I am using a MySQL database for my Home Assistant install.
2017-06-05 21:35:46 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.DataError) (1406, “Data too long for column ‘state’ at row 1”) [SQL: ‘INSERT INTO states (domain, entity_id, state, attributes, event_id, last_changed, last_updated, created) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)’] [parameters: (‘sensor’, ‘sensor.hp_ilo_server_health’, “{‘health_at_a_glance’: {‘bios_hardware’: {‘status’: ‘OK’}, ‘fans’: {‘status’: ‘OK’}, ‘processor’: {‘status’: ‘OK’}, ‘storage’: {‘status’: ‘OK’}, 'mem … (4862 characters truncated) … ', ‘label’: ‘08-Supercap Max’, ‘location’: ‘System’, ‘caution’: ‘N/A’, ‘status’: ‘Not Installed’}}, ‘storage_discovery_status’: ‘Discovery Complete’}”, ‘{“friendly_name”: “HP ILO Server Health”}’, None, datetime.datetime(2017, 6, 5, 19, 35, 15, 54689, tzinfo=), datetime.datetime(2017, 6, 5, 19, 35, 15, 54689, tzinfo=), datetime.datetime(2017, 6, 5, 19, 35, 46, 292805))]
{‘health_at_a_glance’: {‘bios_hardware’: {‘status’: ‘OK’}, ‘fans’: {‘status’: ‘OK’}, ‘processor’: {‘status’: ‘OK’}, ‘storage’: {‘status’: ‘OK’}, ‘memory’: {‘status’: ‘OK’}, ‘temperature’: {‘status’: ‘OK’}, ‘power_supplies’: {‘status’: ‘OK’}, ‘network’: {‘status’: ‘OK’}}, ‘nic_information’: {‘NIC Port 2’: {‘port_description’: ‘iLO 4’, ‘location’: ‘Embedded’, ‘mac_address’: ‘a0:1d:48:c7:18:df’, ‘network_port’: ‘Port 2’, ‘ip_address’: ‘Unknown’, ‘status’: ‘Disabled’}, ‘NIC Port 0’: {‘port_description’: 'NIC ', ‘location’: ‘Embedded’, ‘mac_address’: ‘a0:1d:48:c7:18:dd’, ‘network_port’: ‘Port 0’, ‘ip_address’: ‘N/A’, ‘status’: ‘Unknown’}, ‘NIC Port 1’: {‘port_description’: ‘iLO 4’, ‘location’: ‘Embedded’, ‘mac_address’: ‘a0:1d:48:c7:18:de’, ‘network_port’: ‘Port 1’, ‘ip_address’: ‘192.168.1.6’, ‘status’: ‘OK’}}, ‘vrm’: None, ‘storage’: None, ‘memory’: {‘memory_details’: {‘CPU_1’: {‘socket 2’: {‘socket’: 2, ‘type’: ‘DIMM DDR3’, ‘size’: ‘8192 MB’, ‘ranks’: 2, ‘hp_smart_memory’: ‘No’, ‘frequency’: ‘1600 MHz’, ‘technology’: ‘UDIMM’, ‘minimum_voltage’: ‘1.50 v’, ‘part’: {‘number’: ‘N/A’}, ‘status’: ‘Good, In Use’}, ‘socket 1’: {‘socket’: 1, ‘type’: ‘DIMM DDR3’, ‘size’: ‘8192 MB’, ‘ranks’: 2, ‘hp_smart_memory’: ‘No’, ‘frequency’: ‘1600 MHz’, ‘technology’: ‘UDIMM’, ‘minimum_voltage’: ‘1.50 v’, ‘part’: {‘number’: ‘N/A’}, ‘status’: ‘Good, In Use’}}}, ‘advanced_memory_protection’: {‘available_amp_modes’: ‘Advanced ECC’, ‘amp_mode_status’: ‘Advanced ECC’, ‘configured_amp_mode’: ‘Advanced ECC’}, ‘memory_details_summary’: {‘cpu_1’: {‘total_memory_size’: ‘16 GB’, ‘operating_frequency’: ‘1333 MHz’, ‘number_of_sockets’: 2, ‘operating_voltage’: ‘1.50 v’}}}, ‘processors’: {‘Proc 1’: {‘memory_technology’: ‘64-bit Capable’, ‘label’: ‘Proc 1’, ‘name’: ’ Intel(R) Celeron(R) CPU G1610T @ 2.30GHz ', ‘internal_l2_cache’: ‘512 KB’, ‘internal_l3_cache’: ‘2048 KB’, ‘internal_l1_cache’: ‘64 KB’, ‘speed’: ‘2300 MHz’, ‘execution_technology’: ‘2/2 cores; 2 threads’, ‘status’: ‘OK’}}, ‘power_supplies’: {‘Power Supply 1’: {‘pds’: ‘No’, ‘capacity’: ‘0 Watts’, ‘present’: ‘Yes’, ‘serial_number’: ’ ', ‘label’: ‘Power Supply 1’, ‘model’: ’ ', ‘firmware_version’: ‘N/A’, ‘spare’: ‘Unknown’, ‘hotplug_capable’: ‘No’, ‘status’: ‘Good, In Use’}}, ‘power_supply_summary’: {‘present_power_reading’: ‘0 Watts’, ‘power_management_controller_firmware_version’: ‘N/A’, ‘high_efficiency_mode’: ‘N/A’, ‘hp_power_discovery_services_redundancy_status’: ‘N/A’}, ‘fans’: {‘Fan 1’: {‘zone’: ‘System’, ‘speed’: (25, ‘Percentage’), ‘label’: ‘Fan 1’, ‘status’: ‘OK’}}, ‘firmware_information’: {‘Server Platform Services (SPS) Firmware’: ‘2.2.0.31.2’, ‘Redundant System ROM’: ‘J06 07/16/2015’, ‘Intelligent Platform Abstraction Data’: ‘0.00’, ‘System ROM’: ‘J06 11/02/2015’, ‘System ROM Bootblock’: ‘02/04/2012’, ‘iLO’: ‘2.50 Sep 23 2016’, ‘Intelligent Provisioning’: ‘1.61.45’, ‘System Programmable Logic Device’: ‘Version 0x06’}, ‘temperature’: {‘12-Sys Exhaust’: {‘currentreading’: (46, ‘Celsius’), ‘critical’: (73, ‘Celsius’), ‘label’: ‘12-Sys Exhaust’, ‘location’: ‘Chassis’, ‘caution’: (68, ‘Celsius’), ‘status’: ‘OK’}, ‘02-CPU’: {‘currentreading’: (40, ‘Celsius’), ‘critical’: ‘N/A’, ‘label’: ‘02-CPU’, ‘location’: ‘CPU’, ‘caution’: (70, ‘Celsius’), ‘status’: ‘OK’}, ‘04-HD Max’: {‘currentreading’: ‘N/A’, ‘critical’: ‘N/A’, ‘label’: ‘04-HD Max’, ‘location’: ‘System’, ‘caution’: ‘N/A’, ‘status’: ‘Not Installed’}, ‘11-PCI 1 Zone’: {‘currentreading’: (41, ‘Celsius’), ‘critical’: (69, ‘Celsius’), ‘label’: ‘11-PCI 1 Zone’, ‘location’: ‘I/O Board’, ‘caution’: (64, ‘Celsius’), ‘status’: ‘OK’}, ‘06-Chipset Zone’: {‘currentreading’: (46, ‘Celsius’), ‘critical’: (73, ‘Celsius’), ‘label’: ‘06-Chipset Zone’, ‘location’: ‘System’, ‘caution’: (68, ‘Celsius’), ‘status’: ‘OK’}, ‘09-iLO Zone’: {‘currentreading’: (48, ‘Celsius’), ‘critical’: (77, ‘Celsius’), ‘label’: ‘09-iLO Zone’, ‘location’: ‘System’, ‘caution’: (72, ‘Celsius’), ‘status’: ‘OK’}, ‘10-PCI 1’: {‘currentreading’: ‘N/A’, ‘critical’: ‘N/A’, ‘label’: ‘10-PCI 1’, ‘location’: ‘I/O Board’, ‘caution’: ‘N/A’, ‘status’: ‘Not Installed’}, ‘13-LOM’: {‘currentreading’: ‘N/A’, ‘critical’: ‘N/A’, ‘label’: ‘13-LOM’, ‘location’: ‘System’, ‘caution’: ‘N/A’, ‘status’: ‘Not Installed’}, ‘01-Inlet Ambient’: {‘currentreading’: (28, ‘Celsius’), ‘critical’: (46, ‘Celsius’), ‘label’: ‘01-Inlet Ambient’, ‘location’: ‘Ambient’, ‘caution’: (42, ‘Celsius’), ‘status’: ‘OK’}, ‘03-P1 DIMM 1-2’: {‘currentreading’: (38, ‘Celsius’), ‘critical’: ‘N/A’, ‘label’: ‘03-P1 DIMM 1-2’, ‘location’: ‘Memory’, ‘caution’: (87, ‘Celsius’), ‘status’: ‘OK’}, ‘05-Chipset’: {‘currentreading’: (60, ‘Celsius’), ‘critical’: ‘N/A’, ‘label’: ‘05-Chipset’, ‘location’: ‘System’, ‘caution’: (105, ‘Celsius’), ‘status’: ‘OK’}, ‘07-VR P1 Zone’: {‘currentreading’: (49, ‘Celsius’), ‘critical’: (93, ‘Celsius’), ‘label’: ‘07-VR P1 Zone’, ‘location’: ‘System’, ‘caution’: (88, ‘Celsius’), ‘status’: ‘OK’}, ‘08-Supercap Max’: {‘currentreading’: ‘N/A’, ‘critical’: ‘N/A’, ‘label’: ‘08-Supercap Max’, ‘location’: ‘System’, ‘caution’: ‘N/A’, ‘status’: ‘Not Installed’}}, ‘storage_discovery_status’: ‘Discovery Complete’}
