HI,
Since few days, HOme assistant can’t connect with influxdb component in my HA log i have that :
`
17-01-12 16:54:14 homeassistant.loader: Loaded influxdb from homeassistant.components.influxdb
17-01-12 16:57:19 homeassistant.bootstrap: Setting up influxdb
17-01-12 16:57:37 homeassistant.bootstrap: Error during setup of component influxdb
File “/usr/local/lib/python3.4/dist-packages/homeassistant/components/influxdb.py”, line 85, in setup
influx.query(“select * from /.*/ LIMIT 1;”)
File “/home/debian/.homeassistant/deps/influxdb/client.py”, line 336, in query
File “/home/debian/.homeassistant/deps/influxdb/client.py”, line 252, in request
File “/home/debian/.homeassistant/deps/influxdb/client.py”, line 245, in request
I logged on my server and InfluxDB works fine, i try a connection and request home_assistant db ! everythings works fine but HA refuses to connect to influxdb.
in my syslog i have that
Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."°C" WHERE entity_id = 'tempchambre_temperature' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [httpd] ::1 - admin [12/Jan/2017:19:40:42 +0100] "GET /query?db=home_assistant&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22%C2%B0C%22+WHERE+%22entity_id%22+%3D+%27tempchambre_temperature%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29 HTTP/1.1" 200 586 "http://gan0.fr.cr:3000/dashboard/db/new-dashboard" "Mozilla/5.0 (Linux; Android 7.0; ONEPLUS A3003 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36" 9f1b1840-d8f6-11e6-8012-000000000000 22664 Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."°C" WHERE entity_id = 'tempsdb_temperature' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."°C" WHERE entity_id = 'tempext_temperature' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [httpd] ::1 - admin [12/Jan/2017:19:40:42 +0100] "GET /query?db=home_assistant&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22%C2%B0C%22+WHERE+%22entity_id%22+%3D+%27tempsdb_temperature%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29 HTTP/1.1" 200 634 "http://gan0.fr.cr:3000/dashboard/db/new-dashboard" "Mozilla/5.0 (Linux; Android 7.0; ONEPLUS A3003 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36" 9f1f0459-d8f6-11e6-8013-000000000000 28670 Jan 12 19:40:42 pine64 influxd[424]: [httpd] ::1 - admin [12/Jan/2017:19:40:42 +0100] "GET /query?db=home_assistant&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22%C2%B0C%22+WHERE+%22entity_id%22+%3D+%27tempext_temperature%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29 HTTP/1.1" 200 613 "http://gan0.fr.cr:3000/dashboard/db/new-dashboard" "Mozilla/5.0 (Linux; Android 7.0; ONEPLUS A3003 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36" 9f211fce-d8f6-11e6-8014-000000000000 25830 Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."°C" WHERE entity_id = 'tempetage_temperature' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."°C" WHERE entity_id = 'salon_temperature' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."%" WHERE entity_id = 'cpu_use' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [httpd] ::1 - admin [12/Jan/2017:19:40:42 +0100] "GET /query?db=home_assistant&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22%C2%B0C%22+WHERE+%22entity_id%22+%3D+%27salon_temperature%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29 HTTP/1.1" 200 643 "http://gan0.fr.cr:3000/dashboard/db/new-dashboard" "Mozilla/5.0 (Linux; Android 7.0; ONEPLUS A3003 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36" 9f4c6dca-d8f6-11e6-8016-000000000000 24961 Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen.mbar WHERE entity_id = 'owm_pressure' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [httpd] ::1 - admin [12/Jan/2017:19:40:42 +0100] "GET /query?db=home_assistant&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22%C2%B0C%22+WHERE+%22entity_id%22+%3D+%27tempetage_temperature%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29 HTTP/1.1" 200 838 "http://gan0.fr.cr:3000/dashboard/db/new-dashboard" "Mozilla/5.0 (Linux; Android 7.0; ONEPLUS A3003 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36" 9f4a1d85-d8f6-11e6-8015-000000000000 57026 Jan 12 19:40:42 pine64 influxd[424]: [httpd] ::1 - admin [12/Jan/2017:19:40:42 +0100] "GET /query?db=home_assistant&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22mbar%22+WHERE+%22entity_id%22+%3D+%27owm_pressure%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29 HTTP/1.1" 200 530 "http://gan0.fr.cr:3000/dashboard/db/new-dashboard" "Mozilla/5.0 (Linux; Android 7.0; ONEPLUS A3003 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36" 9f4fa2b5-d8f6-11e6-8018-000000000000 28799 Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."%" WHERE entity_id = 'cpupi' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."%" WHERE entity_id = 'tempchambre_humidity' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."%" WHERE entity_id = 'tempsdb_humidity' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [query] 2017/01/12 19:40:42 SELECT mean(value) FROM home_assistant.autogen."%" WHERE entity_id = 'tempetage_humidity' AND time > now() - 4d GROUP BY time(1h) Jan 12 19:40:42 pine64 influxd[424]: [httpd] ::1 - admin [12/Jan/2017:19:40:42 +0100] "GET /query?db=home_assistant&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22%25%22+WHERE+%22entity_id%22+%3D+%27cpu_use%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29%3BSELECT+mean%28%22value%22%29+FROM+%22%25%22+WHERE+%22entity_id%22+%3D+%27cpupi%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29 HTTP/1.1" 200 1441 "http://gan0.fr.cr:3000/dashboard/db/new-dashboard" "Mozilla/5.0 (Linux; Android 7.0; ONEPLUS A3003 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36" 9f4dc6be-d8f6-11e6-8017-000000000000 81990 Jan 12 19:40:42 pine64 influxd[424]: [httpd] ::1 - admin [12/Jan/2017:19:40:42 +0100] "GET /query?db=home_assistant&epoch=ms&q=SELECT+mean%28%22value%22%29+FROM+%22%25%22+WHERE+%22entity_id%22+%3D+%27tempchambre_humidity%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29%3BSELECT+mean%28%22value%22%29+FROM+%22%25%22+WHERE+%22entity_id%22+%3D+%27tempsdb_humidity%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29%3BSELECT+mean%28%22value%22%29+FROM+%22%25%22+WHERE+%22entity_id%22+%3D+%27tempetage_humidity%27+AND+time+%3E+now%28%29+-+96h+GROUP+BY+time%281h%29+fill%28null%29 HTTP/1.1" 200 1310 "http://gan0.fr.cr:3000/dashboard/db/new-dashboard" "Mozilla/5.0 (Linux; Android 7.0; ONEPLUS A3003 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.91 Mobile Safari/537.36" 9f5439cd-d8f6-11e6-8019-000000000000 66709 Jan 12 19:47:23 pine64 influxd[424]: [retention] 2017/01/12 19:47:23 retention policy shard deletion check commencing Jan 12 20:17:23 pine64 influxd[424]: [retention] 2017/01/12 20:17:23 retention policy shard deletion check commencing Jan 12 20:47:23 pine64 influxd[424]: [retention] 2017/01/12 20:47:23 retention policy shard deletion check commencing Jan 12 20:54:10 pine64 influxd[424]: [httpd] ::1 - - [12/Jan/2017:20:54:10 +0100] "GET /ping HTTP/1.1" 204 0 "-" "InfluxDBShell/1.1.0" e26aa68c-d900-11e6-801a-000000000000 181 Jan 12 20:54:10 pine64 influxd[424]: [query] 2017/01/12 20:54:10 SHOW DIAGNOSTICS FOR 'registration' Jan 12 20:54:10 pine64 influxd[424]: [httpd] ::1 - - [12/Jan/2017:20:54:10 +0100] "POST /query?chunked=true&db=&epoch=ns&q=SHOW+DIAGNOSTICS+for+%27registration%27 HTTP/1.1" 200 51 "-" "InfluxDBShell/1.1.0" e26b524c-d900-11e6-801b-000000000000 19324 Jan 12 20:54:21 pine64 influxd[424]: [httpd] ::1 - - [12/Jan/2017:20:54:21 +0100] "POST /query?chunked=true&db=&epoch=ns&q=show+database HTTP/1.1" 400 187 "-" "InfluxDBShell/1.1.0" e91352e7-d900-11e6-801c-000000000000 11108 Jan 12 20:54:22 pine64 influxd[424]: [query] 2017/01/12 20:54:22 SHOW DATABASES Jan 12 20:54:22 pine64 influxd[424]: [httpd] ::1 - - [12/Jan/2017:20:54:22 +0100] "POST /query?chunked=true&db=&epoch=ns&q=show+databases HTTP/1.1" 200 122 "-" "InfluxDBShell/1.1.0" e9eeb9df-d900-11e6-801d-000000000000 7998 Jan 12 20:54:32 pine64 influxd[424]: [httpd] ::1 - - [12/Jan/2017:20:54:32 +0100] "POST /query?chunked=true&db=&epoch=ns&q=select+%2A+from+home_assistant HTTP/1.1" 200 83 "-" "InfluxDBShell/1.1.0" ef6f9e0c-d900-11e6-801e-000000000000 7358 Jan 12 20:54:36 pine64 influxd[424]: [query] 2017/01/12 20:54:36 SHOW DATABASES Jan 12 20:54:36 pine64 influxd[424]: [httpd] ::1 - - [12/Jan/2017:20:54:36 +0100] "POST /query?db=&epoch=ns&q=SHOW+DATABASES HTTP/1.1" 200 117 "-" "InfluxDBShell/1.1.0" f1cd378a-d900-11e6-801f-000000000000 10207 Jan 12 20:54:54 pine64 influxd[424]: [httpd] ::1 - - [12/Jan/2017:20:54:54 +0100] "POST /query?chunked=true&db=home_assistant&epoch=ns&q=select+%2A+from+home_assistant.autogen.%22%25%22+WHERE+entity_id+%3D+%27cpupi%27+AND+time+%3E+now%28%29+-+4d+GROUP+BY+time%281h%29 HTTP/1.1" 400 103 "-" "InfluxDBShell/1.1.0" fd093e21-d900-11e6-8020-000000000000 6845 Jan 12 20:55:03 pine64 influxd[424]: [query] 2017/01/12 20:55:03 SELECT * FROM home_assistant.autogen."%" WHERE entity_id = 'cpupi' Jan 12 20:55:04 pine64 influxd[424]: [httpd] ::1 - - [12/Jan/2017:20:55:03 +0100] "POST /query?chunked=true&db=home_assistant&epoch=ns&q=select+%2A+from+home_assistant.autogen.%22%25%22+WHERE+entity_id+%3D+%27cpupi%27 HTTP/1.1" 200 58975 "-" "InfluxDBShell/1.1.0" 01e38353-d901-11e6-8021-000000000000 1749070
I use influxdb with grafana for many month now …the problem appeared suddently …
If someone has an idea to help me, that will be nice