Correct, I’ve copy/pasted directly from the documentation. Seems like my formatting disappeared from my post.
Regarding port I haven’t changed the standard port. I’ve tried to include “database: home_assistant”, but with no luck. I’ve also tried to use “localhost” or “192.168.1.5” instead of “127.0.0.1”, but also with no luck.
Is there a way to debug why it won’t run? The “invalid config” is not so helpful.
I run Hassio manually installed on RPi in docker, needed to find InfluxDB docker container name and put it as host, also needed to manually create database called “home_assistant” in Chronograf (port 8888)
Great, I will try that! The username and password, is that for the home_assistant database when you created that? I created mine without user and pass, if I remember right.
Database host is not accessible due to '401: {“error”:“authorization failed”}
', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE
I’ve soon tried what feels like everything. influxdb says this in the logs:
user already exists
ERR: user already exists
Warning: It is possible this error is due to not setting a database.
Please set a database with the command "use <database>".
So I go to my influxdb via the pre-installed Chronograf, type in: use home_assistant
And I get:
"received status code 400 from server: err: error parsing query: found USE, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1"
The log in HA says:
Database host is not accessible due to '401: {"error":"authorization failed"}
', please check your entries in the configuration file (host, port, etc.) and verify that the database exists and is READ/WRITE
How do I make sure that the database i selected/in use, and that read and write is permitted?
Sorry for resurrecting a dead post but… I’ve tried everything I can think of to solve this same issue. I’ve created new DBs, new users, run queries to supposedly set permissions but still nothing.