I have recently set up the influxdb sensor, but I couldn’t get it working. HA throws this error:
simplejson.errors.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
Full error:
Traceback (most recent call last):
File “/usr/src/homeassistant/homeassistant/helpers/entity_platform.py”, line 150, in _async_setup_platform
await asyncio.wait_for(asyncio.shield(task), SLOW_SETUP_MAX_WAIT)
File “/usr/local/lib/python3.7/asyncio/tasks.py”, line 442, in wait_for
return fut.result()
File “/usr/local/lib/python3.7/concurrent/futures/thread.py”, line 57, in run
result = self.fn(*self.args, **self.kwargs)
File “/usr/src/homeassistant/homeassistant/components/influxdb/sensor.py”, line 85, in setup_platform
sensor = InfluxSensor(hass, influx_conf, query)
File “/usr/src/homeassistant/homeassistant/components/influxdb/sensor.py”, line 124, in init
influx.query(“SHOW SERIES LIMIT 1;”)
File “/usr/local/lib/python3.7/site-packages/influxdb/client.py”, line 422, in query
data = response.json()
File “/usr/local/lib/python3.7/site-packages/requests/models.py”, line 897, in json
return complexjson.loads(self.text, **kwargs)
File “/usr/local/lib/python3.7/site-packages/simplejson/init.py”, line 518, in loads
return _default_decoder.decode(s)
File “/usr/local/lib/python3.7/site-packages/simplejson/decoder.py”, line 370, in decode
obj, end = self.raw_decode(s)
File “/usr/local/lib/python3.7/site-packages/simplejson/decoder.py”, line 400, in raw_decode
return self.scan_once(s, idx=_w(s, idx).end())
simplejson.errors.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
Config:
- platform: influxdb
host: 192.168.2.56
port: 443
ssl: true
verify_ssl: false
username: youarenotallowedtoknowthis
password: youarenotallowedtoknowthis
queries:
- name: power usage it systems
database: telegraf_data
where: '"host" = ''srv-ubn-services-1'''
measurement: 'ups'
field: ups_load_perc
group_function: distinct
Thx for the support.