Hi guys, I got in the setup via „sudo openhabian-config“ a error in the installation. Now I tried via the manual steps to find the issue. It seems to be a authentification problem. Connected to http://localhost:8086 version 1.7.9 InfluxDB shell version: 1.7.9 > CREATE DATABASE openhab_db ERR: un…

[image] knaxman: > use openhab_db WARN: error authorizing query: create admin user first or disable authentication Using database openhab_db > CREATE USER admin WITH PASSWORD '1234' WITH ALL PRIVILEGES > use openhab_db WARN: authorization failed Using database openhab_db Looks like somehow th…

You did login first with. auth ? If you do not then for use openhab_db you will get ERR: unable to parse authentication credentials DB does not exist!

InfluxDB requires you to create the admin user first if HTTP authentication is enabled (default). Your first command should be: CREATE USER admin WITH PASSWORD '<password>' WITH ALL PRIVILEGES Only then can you interact with the system and create databases and other users. See the InfluxDB docume…

openhabian should have worked for you to set this up. What was the error you saw when you tried with it?

[image] knaxman: CREATE DATABASE openhab_db Thanks for your help. I tried your this but get following results. Seems like the admin exists but not with the right priviliges. [09:58:26] openhabian@openhab:~$ influx Connected to http://localhost:8086 version 1.7.9 InfluxDB shell version: 1.7.9…

Is there a possibility to get the log-file from the initial installation? Or if not; how do I uninstall it in the right way so I can install influx again with openhab-config?

@jswim788 I removed completle the grafana installation via sudo apt-get remove --auto-remove grafana sudo apt-get purge --auto-remove grafana now I installed again via openhab-config, enclosed you see the error as I got it the first time on apretty clean installation. (openhabian) $ systemctl da…

I’m not an expert on openhabian, but I can see that it is trying to run the code below. For some reason the curl command can’t connect in order to create the admin user. I can think of 2 possible reasons: The sleep wasn’t long enough The InfluxDB service didn’t start for some reason What do you…

I assume this means connection refused? @noppes123 above in post 3 does show how you can create the admin user manually if needed from the InfluxDB cli. Not sure that is the problem when using openhabian, though. You can also try the curl command manually to see what it does (fill in the passwor…

From the openhabian-config output it is obvious that the InfluxDB daemon fails to start. The most common reasons are port already in use (as @jswim788 already mentioned), and access rights. Since the setup is done with openHABian, the 2nd option is unlikely. The first option can easily be checked wi…

openHAB Community

[SOLVED] Error setting up InfluxDB+Grafana

Add-ons Persistence Services

noppes123 (Ron) February 4, 2020, 10:20pm 5

I wasn’t sure if openHABian already creates the admin user…
In that case see this post…