InfluxDB+Grafana persistence and graphing

Alexollon · January 7, 2022, 2:33pm

And show databases yields:

> show databases
name: databases
name
----

Wolfgang_S · January 7, 2022, 2:37pm

Perfect.
That means there is no user at all defined in influxdb ( the list below the headline is empty ).
And there is also no database defined yet ( besides the headline nothing is being shown ).

This means create the database and the admin and the grafana user first.
Commands are described in very first post of this thread.
This also could/should be done by running the openhabian install procedure for influxdb.
As there is no influxdb right now you also cannot already have data collected yet - at least not in influxdb.

Alexollon · January 7, 2022, 2:54pm

Hmm, I started openhabian-config and executed the installation of influx&grafana again. It failed. I tried it 3 times. I started openhabian-config once from the root and once from ./home/openhabian

InfluxDB installation seemed to work, but not Grafana.


openhabian@openhabian:~ $ openhabian-config 
2022-01-07_15:39:18_CET [openHABian] Checking for root privileges... 
This script must be run as root. Did you mean 'sudo openhabian-config'?
More info: https://www.openhab.org/docs/installation/openhabian.html
openhabian@openhabian:~ $ sudo openhabian-config 
[sudo] password for openhabian: 
2022-01-07_15:39:28_CET [openHABian] Checking for root privileges... OK
2022-01-07_15:39:28_CET [openHABian] Loading configuration file '/etc/openhabian.conf'... OK
2022-01-07_15:39:28_CET [openHABian] openHABian configuration tool version: [openHAB3]{2021-12-02T09:19:37-07:00}(bb960d8)
2022-01-07_15:39:28_CET [openHABian] Checking for changes in origin branch openHAB3... OK
2022-01-07_15:39:30_CET [openHABian] Switching to branch openHAB3... OK
2022-01-07_15:39:30_CET [openHABian] Adding slightly tuned bash configuration files to system... OK
2022-01-07_15:39:37_CET [openHABian] Updating Linux package information... OK
2022-01-07_15:39:38_CET [openHABian] Beginning setup of InfluxDB and Grafana... OK
2022-01-07_15:39:39_CET [openHABian] Configuring InfluxDB... OK
2022-01-07_15:42:28_CET [openHABian] Configuring Grafana... OK
2022-01-07_15:43:32_CET [openHABian] Installing InfluxDB... OK
2022-01-07_15:43:35_CET [openHABian] Setting up new InfluxDB installation... OK
2022-01-07_15:43:36_CET [openHABian] Installing Grafana.. FAILED
2022-01-07_15:45:02_CET [openHABian] Updating Linux package information... OK
2022-01-07_15:45:02_CET [openHABian] Beginning setup of InfluxDB and Grafana... OK
2022-01-07_15:45:03_CET [openHABian] Configuring InfluxDB... OK
2022-01-07_15:46:23_CET [openHABian] Configuring Grafana... OK
2022-01-07_15:46:39_CET [openHABian] Setting up new InfluxDB installation... OK
2022-01-07_15:46:40_CET [openHABian] Installing Grafana.. FAILED
2022-01-07_15:48:16_CET [openHABian] Checking for default openHABian username:password combination... OK
2022-01-07_15:48:16_CET [openHABian] We hope you got what you came for! See you again soon ;)
openhabian@openhabian:~ $ pwd
/home/openhabian
openhabian@openhabian:~ $ cd..
openhabian@openhabian:/home $ cd..
openhabian@openhabian:/ $ sudo openhabian-config 
2022-01-07_15:48:37_CET [openHABian] Checking for root privileges... OK
2022-01-07_15:48:38_CET [openHABian] Loading configuration file '/etc/openhabian.conf'... OK
2022-01-07_15:48:38_CET [openHABian] openHABian configuration tool version: [openHAB3]{2021-12-02T09:19:37-07:00}(bb960d8)
2022-01-07_15:48:38_CET [openHABian] Checking for changes in origin branch openHAB3... OK
2022-01-07_15:48:40_CET [openHABian] Switching to branch openHAB3... OK
2022-01-07_15:48:40_CET [openHABian] Adding slightly tuned bash configuration files to system... OK
2022-01-07_15:48:47_CET [openHABian] Updating Linux package information... OK
2022-01-07_15:48:47_CET [openHABian] Beginning setup of InfluxDB and Grafana... OK
2022-01-07_15:48:48_CET [openHABian] Configuring InfluxDB... OK
2022-01-07_15:50:09_CET [openHABian] Configuring Grafana... OK
2022-01-07_15:50:17_CET [openHABian] Installing InfluxDB... OK
2022-01-07_15:50:20_CET [openHABian] Setting up new InfluxDB installation... OK
2022-01-07_15:50:21_CET [openHABian] Installing Grafana.. FAILED
2022-01-07_15:52:15_CET [openHABian] Checking for default openHABian username:password combination... OK
2022-01-07_15:52:15_CET [openHABian] We hope you got what you came for! See you again soon ;)
openhabian@openhabian:/ $

I used my own (and 3 different usernames) when being asked to enter the various usernames.

Alexollon · January 7, 2022, 3:36pm

I ran the installation in maximum debug mode: influx seemingly was successfully installed. but on Grafana an access to localhost:3000 is refused…???

curl: (7) Failed to connect to localhost port 3000: Connection refused

The last part of the debugging info:

...
Check if InfluxDB is running... 
+ cond_redirect curl --retry 6 --retry-connrefused --user myNameAdmin:12345678 --insecure http://localhost:8086/query
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl --retry 6 --retry-connrefused --user myNameAdmin:12345678 --insecure http://localhost:8086/query \033[39;49;00m'

$ curl --retry 6 --retry-connrefused --user myNameAdmin:12345678 --insecure http://localhost:8086/query 
+ curl --retry 6 --retry-connrefused --user myNameAdmin:12345678 --insecure http://localhost:8086/query
{"error":"missing required parameter \"q\""}
+ return 0
+ echo OK
OK
+ return 0
+ echo OK
OK
+ influxDBAddress=http://localhost:8086
+ [[ -n myNameAdmin ]]
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2022-01-07_16:17:49_CET [openHABian] Setting up new InfluxDB installation... '
2022-01-07_16:17:49_CET [openHABian] Setting up new InfluxDB installation... + cond_echo 'Creating InfluxDB database myNameOH'
+ [[ -z '' ]]
+ echo -e '\033[33;01mCreating InfluxDB database myNameOH\033[39;49;00m'
Creating InfluxDB database myNameOH
+ cond_redirect curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=CREATE DATABASE myNameOH'
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=CREATE DATABASE myNameOH \033[39;49;00m'

$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=CREATE DATABASE myNameOH 
+ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=CREATE DATABASE myNameOH'
{"results":[{"statement_id":0}]}
+ return 0
+ cond_echo 'Creating InfluxDB user myNameOpenhab'
+ [[ -z '' ]]
+ echo -e '\033[33;01mCreating InfluxDB user myNameOpenhab\033[39;49;00m'
Creating InfluxDB user myNameOpenhab
+ cond_redirect curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=CREATE USER myNameOpenhab WITH PASSWORD '\''12345678'\'''
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=CREATE USER myNameOpenhab WITH PASSWORD '\''12345678'\'' \033[39;49;00m'

$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=CREATE USER myNameOpenhab WITH PASSWORD '12345678' 
+ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=CREATE USER myNameOpenhab WITH PASSWORD '\''12345678'\'''
{"results":[{"statement_id":0}]}
+ return 0
+ cond_redirect curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=SET PASSWORD FOR myNameOpenhab = '\''12345678'\'''
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=SET PASSWORD FOR myNameOpenhab = '\''12345678'\'' \033[39;49;00m'

$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=SET PASSWORD FOR myNameOpenhab = '12345678' 
+ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=SET PASSWORD FOR myNameOpenhab = '\''12345678'\'''
{"results":[{"statement_id":0}]}
+ return 0
+ cond_redirect curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=GRANT ALL ON myNameOH TO myNameOpenhab'
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=GRANT ALL ON myNameOH TO myNameOpenhab \033[39;49;00m'

$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=GRANT ALL ON myNameOH TO myNameOpenhab 
+ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=GRANT ALL ON myNameOH TO myNameOpenhab'
{"results":[{"statement_id":0}]}
+ return 0
+ cond_echo 'Creating InfluxDB user myNameGrafana2influx'
+ [[ -z '' ]]
+ echo -e '\033[33;01mCreating InfluxDB user myNameGrafana2influx\033[39;49;00m'
Creating InfluxDB user myNameGrafana2influx
+ cond_redirect curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=CREATE USER myNameGrafana2influx WITH PASSWORD '\''12345678'\'''
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=CREATE USER myNameGrafana2influx WITH PASSWORD '\''12345678'\'' \033[39;49;00m'

$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=CREATE USER myNameGrafana2influx WITH PASSWORD '12345678' 
+ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=CREATE USER myNameGrafana2influx WITH PASSWORD '\''12345678'\'''
{"results":[{"statement_id":0}]}
+ return 0
+ cond_redirect curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=SET PASSWORD FOR myNameGrafana2influx = '\''12345678'\'''
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=SET PASSWORD FOR myNameGrafana2influx = '\''12345678'\'' \033[39;49;00m'

$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=SET PASSWORD FOR myNameGrafana2influx = '12345678' 
+ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=SET PASSWORD FOR myNameGrafana2influx = '\''12345678'\'''
{"results":[{"statement_id":0}]}
+ return 0
+ cond_redirect curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=GRANT READ ON myNameOH TO myNameGrafana2influx'
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=GRANT READ ON myNameOH TO myNameGrafana2influx \033[39;49;00m'

$ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode q=GRANT READ ON myNameOH TO myNameGrafana2influx 
+ curl --user myNameAdmin:12345678 --insecure http://localhost:8086/query --data-urlencode 'q=GRANT READ ON myNameOH TO myNameGrafana2influx'
{"results":[{"statement_id":0}]}
+ return 0
+ echo OK
OK
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2022-01-07_16:17:50_CET [openHABian] Installing Grafana.. '
2022-01-07_16:17:50_CET [openHABian] Installing Grafana.. + cond_redirect grafana_install 12345678
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ grafana_install 12345678 \033[39;49;00m'

$ grafana_install 12345678 
+ grafana_install 12345678
+ local adminPassword=12345678
+ local keyName=grafana
+ grafana_is_installed
+ dpkg -s grafana
+ [[ -s /etc/grafana/grafana.ini ]]
+ return 0
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2022-01-07_16:17:50_CET [openHABian] Setting up Grafana service... '
2022-01-07_16:17:50_CET [openHABian] Setting up Grafana service... + cond_redirect zram_dependency install grafana-server
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ zram_dependency install grafana-server \033[39;49;00m'

$ zram_dependency install grafana-server 
+ zram_dependency install grafana-server
+ local zramServiceConfig=/etc/systemd/system/zram-config.service
+ local install=yes
+ [[ -f /etc/ztab ]]
+ [[ install == \i\n\s\t\a\l\l ]]
+ shift 1
+ [[ grafana-server == \r\e\m\o\v\e ]]
+ for arg in "$@"
+ [[ yes == \y\e\s ]]
+ grep -qs grafana-server.service /etc/systemd/system/zram-config.service
+ [[ yes == \n\o ]]
+ cond_redirect systemctl -q daemon-reload
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ systemctl -q daemon-reload \033[39;49;00m'

$ systemctl -q daemon-reload 
+ systemctl -q daemon-reload
+ return 0
+ return 0
+ zram_is_installed
+ [[ -s /etc/ztab ]]
+ [[ -d /opt/zram ]]
+ return 0
+ mkdir -p /opt/zram/log.bind/grafana /var/log/grafana
+ cond_redirect systemctl enable --now grafana-server.service
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ systemctl enable --now grafana-server.service \033[39;49;00m'

$ systemctl enable --now grafana-server.service 
+ systemctl enable --now grafana-server.service
Synchronizing state of grafana-server.service with SysV service script with /lib/systemd/systemd-sysv-install.
Executing: /lib/systemd/systemd-sysv-install enable grafana-server
+ return 0
+ echo OK
OK
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2022-01-07_16:17:52_CET [openHABian] Setting up Grafana... '
2022-01-07_16:17:52_CET [openHABian] Setting up Grafana... + cond_echo '\nWait for Grafana to start... '
+ [[ -z '' ]]
+ echo -e '\033[33;01m\nWait for Grafana to start... \033[39;49;00m'

Wait for Grafana to start... 
+ cond_redirect curl -4 --retry 6 --retry-connrefused --insecure --head http://localhost:3000
+ [[ -n '' ]]
+ echo -e '\n\033[90;01m$ curl -4 --retry 6 --retry-connrefused --insecure --head http://localhost:3000 \033[39;49;00m'

$ curl -4 --retry 6 --retry-connrefused --insecure --head http://localhost:3000 
+ curl -4 --retry 6 --retry-connrefused --insecure --head http://localhost:3000
curl: (7) Failed to connect to localhost port 3000: Connection refused
Warning: Problem : connection refused. Will retry in 1 seconds. 6 retries 
Warning: left.
curl: (7) Failed to connect to localhost port 3000: Connection refused
Warning: Problem : connection refused. Will retry in 2 seconds. 5 retries 
Warning: left.
curl: (7) Failed to connect to localhost port 3000: Connection refused
Warning: Problem : connection refused. Will retry in 4 seconds. 4 retries 
Warning: left.
curl: (7) Failed to connect to localhost port 3000: Connection refused
Warning: Problem : connection refused. Will retry in 8 seconds. 3 retries 
Warning: left.
curl: (7) Failed to connect to localhost port 3000: Connection refused
Warning: Problem : connection refused. Will retry in 16 seconds. 2 retries 
Warning: left.
curl: (7) Failed to connect to localhost port 3000: Connection refused
Warning: Problem : connection refused. Will retry in 32 seconds. 1 retries 
Warning: left.
curl: (7) Failed to connect to localhost port 3000: Connection refused
+ return 7
+ echo 'FAILED (wait for Grafana to start)'
FAILED (wait for Grafana to start)
+ return 1
+ return 1
+ echo FAILED
FAILED
+ return 1
+ '[' 1 -ne 0 ']'
+ whiptail --msgbox 'There was an error or interruption during the execution of:\n  "20 | Optional Components"\n\nPlease try again. If the error persists, please read /opt/openhabian/docs/openhabian-DEBUG.md or https://github.com/openhab/openhabian/blob/main/docs/openhabian-DEBUG.md how to proceed.' 14 80
+ return 0
+ true
+ show_main_menu
+ local choice
+ local version
+++ get_git_revision
+++ local branch
+++ local commitDate
+++ local shorthash
++++ git -C /opt/openhabian rev-parse --abbrev-ref HEAD
+++ branch=openHAB3
++++ git -C /opt/openhabian log --pretty=format:%aI -n 1
+++ commitDate=2021-12-02T09:19:37-07:00
++++ git -C /opt/openhabian log --pretty=format:%h -n 1
+++ shorthash=bb960d8
+++ echo '[openHAB3]{2021-12-02T09:19:37-07:00}(bb960d8)'
++ whiptail --title 'openHABian Configuration Tool — [openHAB3]{2021-12-02T09:19:37-07:00}(bb960d8)' --menu 'Setup Options' 19 116 12 --cancel-button Exit --ok-button Execute '00 | About openHABian' 'Information about the openHABian project and this tool' '' '' '01 | Select Branch' 'Select the openHABian config tool version ("branch") to run' '02 | Upgrade System' 'Update all installed software packages (incl. openHAB) to their latest version' '03 | Install openHAB' 'Install or upgrade to openHAB 3' '04 | Import config' 'Import an openHAB 3 configuration from file or URL' '' '' '10 | Apply Improvements' 'Apply the latest improvements to the basic openHABian setup ►' '20 | Optional Components' 'Choose from a set of optional software components ►' '30 | System Settings' 'A range of system and hardware related configuration steps ►' '40 | openHAB Related' 'Switch the installed openHAB version or apply tweaks ►' '50 | Backup/Restore' 'Manage backups and restore your system ►'
+ choice=
+ RET=1
+ '[' 1 -eq 1 ']'
+ return 255
+ system_check_default_password
+ is_pi
+ is_pifour
+ [[ '' == \p\i\4 ]]
+ grep -q '^Revision\s*:\s*[ 123][0-9a-fA-F][0-9a-fA-F][0-9a-fA-F]11[0-9a-fA-F]$' /proc/cpuinfo
+ return 0
+ return 0
+ local algo
+ local defaultPassword
+ local defaultUser
+ local generatedPassword
+ local introText
+ local originalPassword
+ local salt
+ is_pi
+ is_pifour
+ [[ '' == \p\i\4 ]]
+ grep -q '^Revision\s*:\s*[ 123][0-9a-fA-F][0-9a-fA-F][0-9a-fA-F]11[0-9a-fA-F]$' /proc/cpuinfo
+ return 0
+ return 0
+ id -u pi
+ is_pi
+ is_pifour
+ [[ '' == \p\i\4 ]]
+ grep -q '^Revision\s*:\s*[ 123][0-9a-fA-F][0-9a-fA-F][0-9a-fA-F]11[0-9a-fA-F]$' /proc/cpuinfo
+ return 0
+ return 0
+ defaultUser=openhabian
+ defaultPassword=openhabian
++ grep -w openhabian /etc/shadow
++ cut -d: -f2
+ originalPassword='$y$j9T$WDuhwaGgLhKT5f09ID/5n/$TKRPXY0Z9qeY0CRH8Ez7X72VKuFEV/N/uVXAylXxNID'
++ echo '$y$j9T$WDuhwaGgLhKT5f09ID/5n/$TKRPXY0Z9qeY0CRH8Ez7X72VKuFEV/N/uVXAylXxNID'
++ cut '-d$' -f2
+ algo=y
+ introText='The default password was detected on your system! That is a serious security concern. Bad guys or malicious programs in your subnet are able to gain root access!\n\nPlease set a strong password by typing the command '\''passwd openhabian'\''!'
++ echo '$y$j9T$WDuhwaGgLhKT5f09ID/5n/$TKRPXY0Z9qeY0CRH8Ez7X72VKuFEV/N/uVXAylXxNID'
++ cut '-d$' -f3
+ salt=j9T
+ export algo defaultPassword salt
++ perl -le 'print crypt("$ENV{defaultPassword}","\$$ENV{algo}\$$ENV{salt}\$")'
+ generatedPassword='$y$j9T$$1DJdHt2WNxWqFR3sUxwYKh.KdyI9MF4X/A9710MJGjA'
++ timestamp
++ date +%F_%T_%Z
+ echo -n '2022-01-07_16:19:49_CET [openHABian] Checking for default openHABian username:password combination... '
2022-01-07_16:19:49_CET [openHABian] Checking for default openHABian username:password combination... ++ id -u openhabian
+ [[ -n 1000 ]]
+ [[ $y$j9T$$1DJdHt2WNxWqFR3sUxwYKh.KdyI9MF4X/A9710MJGjA == \$\y\$\j\9\T\$\W\D\u\h\w\a\G\g\L\h\K\T\5\f\0\9\I\D\/\5\n\/\$\T\K\R\P\X\Y\0\Z\9\q\e\Y\0\C\R\H\8\E\z\7\X\7\2\V\K\u\F\E\V\/\N\/\u\V\X\A\y\l\X\x\N\I\D ]]
+ echo OK
OK
++ timestamp
++ date +%F_%T_%Z
+ echo -e '2022-01-07_16:19:49_CET [openHABian] We hope you got what you came for! See you again soon ;)'
2022-01-07_16:19:49_CET [openHABian] We hope you got what you came for! See you again soon ;)

Alexollon · January 7, 2022, 4:05pm

Now I found another interesting issue: the config files of influxDB WERE NOT changed with the reinstatement. they hold obsolete information!
openhab is NOT the username I used in the installation process, but myNameAdmin…
that means to me that there is some rights issue - however I wonder why the installation process says that influxDB was correctly setup. BTW, the influxDB now indeed works again, but grafana not.

BTW, I “grepped” for the DBname to find config files that hold any such information…so it should be fairly accurate.

openhabian@openhabian:/ $ cat ./srv/openhab-conf/services/influxdb.cfg
url=http://localhost:8086
user=openhab
password=myoldpwd
db= myoldDB
retentionPolicy=autogen
openhabian@openhabian:/ $ cat ./srv/openhab-userdata/config/org/openhab/influxdb.config
:org.apache.felix.configadmin.revision:=L"16"
db="myoldDB"
password="myoldpwd"
retentionPolicy="autogen"
service.pid="org.openhab.influxdb"
url="http://localhost:8086"
user="openhab"
openhabian@openhabian:/ $

And, I can also not access influx via the web interface http://192.168.178.111:8086 .

Wolfgang_S · January 7, 2022, 4:38pm

The debug log shows that the installation of influxdb, create users, db went ok.
Grafana, as you already stated, seems to have a problem.

Check if grafana is running and on which port it is running:

sudo netstat -tulpn |grep -i grafana

Grafana seems not to be up and / or listening on port 3000.
There must be something in the log files e.g. /var/log/granfana/grafana.log

Check if journalctl shows a granfana related message:

sudo journalctl | grep -i grafana

Could be that there is a problem with permissions to create a pid file or to create a log file.
In that case check permissions of /var/log/grafana directory.
But journalctl should give a hint in that case.

Alexollon · January 7, 2022, 5:01pm

There is a bigger issue. I restarted the Raspi (before I stopped openhab, influx) and again there is no influx working. So the problem we thought is solved, is actually not.

jfyi: auth-enabled = false in the influxdb config.

show users in influx again shows no admin users. how can that be? I only restarted the Raspi…

I installed now influx&grafana once again via openhabian-config…

no show userss shows:

user             admin
----             -----
AlexollonAdmin   true
AlexollonOpenhab false
AlexollonGrafana false

I ran the 2 commands…here is the outcome. There is a “permission denied” error on /var/log/grafana/grafana.log.

**openhabian@openhabian**:**/ $** sudo netstat -tulpn |grep -i grafana

**openhabian@openhabian**:**/ $** sudo journalctl | grep -i grafana

Jan 07 17:41:19 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:41:31 openhabian **grafana**-server[856]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:31 openhabian **grafana**-server[856]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:31 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:41:31 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:41:31 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 1.

Jan 07 17:41:31 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:41:31 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:41:32 openhabian **grafana**-server[1114]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:32 openhabian **grafana**-server[1114]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:32 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:41:32 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:41:32 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 2.

Jan 07 17:41:32 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:41:32 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:41:32 openhabian **grafana**-server[1135]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:32 openhabian **grafana**-server[1135]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:32 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:41:32 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:41:33 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 3.

Jan 07 17:41:33 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:41:33 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:41:33 openhabian **grafana**-server[1188]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:33 openhabian **grafana**-server[1188]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:33 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:41:33 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:41:33 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 4.

Jan 07 17:41:33 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:41:33 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:41:34 openhabian **grafana**-server[1228]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:34 openhabian **grafana**-server[1228]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:34 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:41:34 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:41:34 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 5.

Jan 07 17:41:34 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:41:34 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:41:34 openhabian **grafana**-server[1261]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:34 openhabian **grafana**-server[1261]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:41:34 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:41:34 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:41:34 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 6.

Jan 07 17:41:34 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:41:34 openhabian systemd[1]: **grafana**-server.service: Start request repeated too quickly.

Jan 07 17:41:34 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:41:34 openhabian systemd[1]: Failed to start **Grafana** instance.

Jan 07 17:52:44 openhabian influxd-systemd-start.sh[5502]: ts=2022-01-07T16:52:44.103758Z lvl=info msg="Executing query" log_id=0YuN9HeW000 service=query query="CREATE USER Alexollon**Grafana** WITH PASSWORD [REDACTED]"

Jan 07 17:52:44 openhabian influxd-systemd-start.sh[5502]: [httpd] 127.0.0.1 - AlexollonAdmin [07/Jan/2022:17:52:44 +0100] "POST /query HTTP/1.1 {'q': 'CREATE USER Alexollon**Grafana** WITH PASSWORD '12345678''}" 200 33 "-" "curl/7.74.0" 3bf3d97e-6fda-11ec-8009-e45f01610c46 128411

Jan 07 17:52:44 openhabian influxd-systemd-start.sh[5502]: ts=2022-01-07T16:52:44.255562Z lvl=info msg="Executing query" log_id=0YuN9HeW000 service=query query="SET PASSWORD FOR Alexollon**Grafana** = [REDACTED]"

Jan 07 17:52:44 openhabian influxd-systemd-start.sh[5502]: [httpd] 127.0.0.1 - AlexollonAdmin [07/Jan/2022:17:52:44 +0100] "POST /query HTTP/1.1 {'q': 'SET PASSWORD FOR Alexollon**Grafana** = '12345678''}" 200 33 "-" "curl/7.74.0" 3c0b0656-6fda-11ec-800a-e45f01610c46 132079

Jan 07 17:52:44 openhabian influxd-systemd-start.sh[5502]: ts=2022-01-07T16:52:44.412772Z lvl=info msg="Executing query" log_id=0YuN9HeW000 service=query query="GRANT READ ON dieKuchars TO Alexollon**Grafana**"

Jan 07 17:52:44 openhabian influxd-systemd-start.sh[5502]: [httpd] 127.0.0.1 - AlexollonAdmin [07/Jan/2022:17:52:44 +0100] "POST /query HTTP/1.1 {'q': 'GRANT READ ON dieKuchars TO Alexollon**Grafana**'}" 200 33 "-" "curl/7.74.0" 3c2300d8-6fda-11ec-800b-e45f01610c46 2233

Jan 07 17:52:47 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:52:47 openhabian **grafana**-server[5646]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:47 openhabian **grafana**-server[5646]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:47 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:52:47 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:52:47 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 1.

Jan 07 17:52:47 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:52:47 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:52:48 openhabian **grafana**-server[5665]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:48 openhabian **grafana**-server[5665]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:48 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:52:48 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:52:48 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 2.

Jan 07 17:52:48 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:52:48 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:52:48 openhabian **grafana**-server[5675]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:48 openhabian **grafana**-server[5675]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:48 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:52:48 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:52:48 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 3.

Jan 07 17:52:48 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:52:48 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:52:49 openhabian **grafana**-server[5689]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:49 openhabian **grafana**-server[5689]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:49 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:52:49 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:52:49 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 4.

Jan 07 17:52:49 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:52:49 openhabian systemd[1]: Started **Grafana** instance.

Jan 07 17:52:49 openhabian **grafana**-server[5700]: Failed to start **grafana**. error: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:49 openhabian **grafana**-server[5700]: failed to initialize file handler: open /var/log/**grafana**/**grafana**.log: permission denied

Jan 07 17:52:49 openhabian systemd[1]: **grafana**-server.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 17:52:49 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:52:49 openhabian systemd[1]: **grafana**-server.service: Scheduled restart job, restart counter is at 5.

Jan 07 17:52:49 openhabian systemd[1]: Stopped **Grafana** instance.

Jan 07 17:52:49 openhabian systemd[1]: **grafana**-server.service: Start request repeated too quickly.

Jan 07 17:52:49 openhabian systemd[1]: **grafana**-server.service: Failed with result 'exit-code'.

Jan 07 17:52:49 openhabian systemd[1]: Failed to start **Grafana** instance.

**openhabian@openhabian**:**/ $**

So I checked rights on this directory:

openhabian@openhabian:/var/log $ la
total 9.5M
drwxr-xr-x   1 root    root            4.0K Jan  7 17:17 ./
drwxr-xr-x  11 root    root            4.0K Jan  5 15:22 ../
-rw-rw-r--   1 root    root             18K Jan  5 15:20 alternatives.log
drwxrwxr-x   2 root    root            4.0K Jan  5 15:21 apt/
-rw-rw----   1 root    adm              18K Jan  7 17:58 auth.log
-rw-rw-r--   1 root    root               0 Oct 30 13:29 bootstrap.log
-rw-rw----   1 root    utmp               0 Oct 30 13:29 btmp
-rw-rw----   1 root    adm             3.6M Jan  7 18:02 daemon.log
-rw-rw----   1 root    adm              25K Jan  7 17:51 debug
-rw-rw-r--   1 root    root            110K Jan  5 15:21 dpkg.log
-rw-rw-r--   1 root    root             24K Jan  5 15:21 faillog
-rw-rw-r--   1 root    root             484 Jan  5 15:16 fontconfig.log
drwxr-xr-x   2 root    root            4.0K Jan  5 16:01 grafana/
drwxr-sr-x+  1 root    systemd-journal 4.0K Oct 30 13:29 journal/
-rw-rw----   1 root    adm             585K Jan  7 17:17 kern.log
-rw-rw-r--   1 root    utmp            286K Jan  7 17:41 lastlog
-rw-rw----   1 root    adm             551K Jan  7 17:17 messages
drwxrwxr-x   1 openhab openhabian      4.0K Jan  7 17:41 openhab/
drwx------   2 root    root            4.0K Oct 30 13:29 private/
drwxrwxr-x   3 root    root            4.0K Oct 30 13:13 runit/
drwxr-x---   1 root    root            4.0K Jan  7 17:44 samba/
-rw-rw----   1 root    adm             4.2M Jan  7 18:02 syslog
drwxrwxr-x   2 root    root            4.0K Feb  2  2021 sysstat/
drwxrwxr-x   2 root    root            4.0K Jan  5 15:15 unattended-upgrades/
-rw-rw----   1 root    adm             8.1K Jan  7 17:17 user.log
-rw-rw-r--   1 root    utmp             13K Jan  7 17:41 wtmp
lrwxrwxrwx   1 root    root              32 Jan  5 15:21 zram-config -> /usr/local/share/zram-config/log/

But my main problem remains: InfluxDB does not work after restarting the Raspi.

Wolfgang_S · January 7, 2022, 5:08pm

the dir needs to be owned by grafana:grafana
so this is the reason why grafana does not start.

The above and

could be caused by ZRAM.
ZRAM is a “mirror” for a set of directories in memory.
The explanation would be that the install was done in ZRAM and checked in ZRAM but not saved back to the SD card. When Pi is booted again data is copied again from SD card back to ZRAM. In case it was missing on SD it is missing in ZRAM, too.
In such cases I disable ZRAM. Make sure that the installation first works without using ZRAM and then make sure that ZRAM is enabled again.

Alexollon · January 7, 2022, 6:02pm

Well, the good thing is: Grafana works again, however I dont know how to change the database…but that is a minor issue.

Bigger is that persistence again does not work, ie no data is shown in graphs of openhab web interface. There is no error anymore, users in influx look good. Still, does not work.

I give up now. I need to do a full reinstall.

Still I learnt a lot (and saved a lot of learnings for the future) - thank you Wolfgang!

one last question: I did a backup of the openhabian config out of the config tool as I dont want to enter all the THINGS and ITEMS data again. But I am worried that I will take the problems with me. Does this config data also include influx and Grafana config files or just the openhab configuration stuff?

Wolfgang_S · January 7, 2022, 6:15pm

Yes and no.
Those part of the configuration for influxdb and grafana that is stored under /etc/grafana resp. /etc/influxdb/ is not part of the backup that is created with “openhab-cli backup”
But the part that is configured within openhab is part of the backup e.g. in files ( path within the zip file ):

./userdata/config/org/openhab/core/ui/tiles.config
./conf/services/runtime.cfg
./conf/services/influxdb.cfg

Alexollon · January 7, 2022, 7:20pm

Thx a lot Wolfgang. Then I will try to import the settings from the backup, but before that make a copy of the influxdb.cfg file. the others I assume are not relevant (but I will look at them first).

DaveL · January 7, 2022, 11:35pm

I’m running OH on an Ubuntu 20.04 LTS server system. And I’m so much hating InfluxDB setup…
Installed and running v 2.1.1, but no commands will be accepted at the CLI. For example, an attempt to create an InfluxDB org:

root@server:~# influx org create -n openhab-org

Is met with the response

Error: failed to create org "openhab-org": 401 Unauthorized: unauthorized access

I receive this response for any command and unable (or am unaware how) to in any way edit my configuration. The InfluxDB documentation is horrible to comprehend and the community support is thin to non-existent. Any and all help, please!

pacive · January 8, 2022, 7:16am

I find that for influxdb 2 the web UI is by far the easiest way to configure it. Can be reached at http://<IP-adress>:8086

Alexollon · January 8, 2022, 9:26am

Good morning Influx fans:)

Another day, another question…

I did a full new clean installation of OH3.2 and influx on Raspberry Pi4b. all standard per openhabian-config.
I configured persistance in openhabian:8080 to influx and it is working as well. Data is recorded properly and I can access it in Grafana (also this installation was successful).

two questions tough:

1. Why can I not access influx via openhabian:8086 although it is like this configured - see the influxdb.cfg file

openhabian@openhabian:/etc/influxdb $ cat influxdb.conf | grep -v "#" | grep -v "^$"
[meta]
  dir = "/var/lib/influxdb/meta"
[data]
  dir = "/var/lib/influxdb/data"
  wal-dir = "/var/lib/influxdb/wal"
  series-id-set-cache-size = 100
[coordinator]
[retention]
[shard-precreation]
[monitor]
  store-enabled = false
[http]
  enabled = true
  bind-address = "localhost:8086"
  auth-enabled = true
[logging]
[subscriber]
[[graphite]]
[[collectd]]
[[opentsdb]]
[[udp]]
[continuous_queries]
[tls]

1. second question: when I execute the following commands I dont see the influx users and databases.

openhabian@openhabian:/ $ influx
Connected to http://localhost:8086 version 1.8.10
InfluxDB shell version: 1.8.10
> show users
ERR: unable to parse authentication credentials
Warning: It is possible this error is due to not setting a database.
Please set a database with the command "use <database>".
> show databases
ERR: unable to parse authentication credentials
Warning: It is possible this error is due to not setting a database.
Please set a database with the command "use <database>".
>

More infos:

sudo systemctl status influxdb

● influxdb.service - InfluxDB is an open-source, distributed, time series database
     Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset: enabled)
     Active: active (running) since Fri 2022-01-07 21:06:42 CET; 13h ago
       Docs: https://docs.influxdata.com/influxdb/
   Main PID: 5595 (influxd)
      Tasks: 14 (limit: 4915)
        CPU: 3min 3.908s
     CGroup: /system.slice/influxdb.service
             └─5595 /usr/bin/influxd -config /etc/influxdb/influxdb.conf

Jan 08 10:20:13 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:13 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:13 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:13 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:14 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:14 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:15 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:15 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:16 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:16 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:17 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:17 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:17 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:17 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:18 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:18 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:18 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:18 +0100] "POST /write?db=dieKucharsOH>
Jan 08 10:20:19 openhabian influxd-systemd-start.sh[5595]: [httpd] 127.0.0.1 - AlexollonOpenhab [08/Jan/2022:10:20:19 +0100] "POST /write?db=dieKucharsOH

Setup tech info:

runtimeInfo:
  version: 3.2.0
  buildString: Release Build
locale: de-AT
systemInfo:
  configFolder: /etc/openhab
  userdataFolder: /var/lib/openhab
  logFolder: /var/log/openhab
  javaVersion: 11.0.13
  javaVendor: Azul Systems, Inc.
  javaVendorVersion: Zulu11.52+13-CA
  osName: Linux
  osVersion: 5.10.63-v7l+
  osArchitecture: arm
  availableProcessors: 4
  freeMemory: 58586424
  totalMemory: 194904064
bindings:
  - coronastats
  - fronius
  - hue
  - netatmo
  - network
  - systeminfo
clientInfo:
  device:
    ios: false
    android: false
    androidChrome: false
    desktop: true
    iphone: false
    ipod: false
    ipad: false
    edge: false
    ie: false
    firefox: false
    macos: true
    windows: false
    cordova: false
    phonegap: false
    electron: false
    nwjs: false
    webView: false
    webview: false
    standalone: false
    os: macos
    pixelRatio: 2
    prefersColorScheme: light
  isSecureContext: false
  locationbarVisible: true
  menubarVisible: true
  navigator:
    cookieEnabled: true
    deviceMemory: N/A
    hardwareConcurrency: N/A
    language: de-DE
    languages:
      - de-DE
    onLine: true
    platform: MacIntel
  screen:
    width: 2560
    height: 1440
    colorDepth: 24
  support:
    touch: false
    pointerEvents: true
    observer: true
    passiveListener: true
    gestures: false
    intersectionObserver: true
  themeOptions:
    dark: light
    filled: true
    pageTransitionAnimation: default
    bars: filled
    homeNavbar: default
    homeBackground: default
    expandableCardAnimation: default
  userAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15
    (KHTML, like Gecko) Version/15.1 Safari/605.1.15
timestamp: 2022-01-08T09:23:34.014Z

Wolfgang_S · January 8, 2022, 4:28pm

this is because authentication is enabled.
If authentication is enabled and user/passwords are set then you need to authenticate first:

influx -username YourUserNameHere -password YourPasswordHere

Wolfgang_S · January 8, 2022, 4:32pm

Looks like authentication is enabled.
You first need to logon with username/password

 influx -username YourAdminAccount -password YourAdminsPassword

If an admin account is not already set. Disable authentication. Restart influxdb.
Connect to influx. Create an admin account. Set an admin account’s password. Enable authentication. Restart influxdb again.

DaveL · January 8, 2022, 8:37pm

Hi @Wolfgang_S, thank you for the response. I’m using V2, which according to documentation does not use authentication but uses tokens. Now it happens that I need to use a token to get OH to write to the Influxdb bucket (and some OH documentation suggests I do not) so that may be an issue.
Your login suggestion unfortunately does not work; it is not the correct syntax (for example “-username” is not recognized, correct would be “-n”; your suggestion is for V1?). So I still cannot make any edits within the CLI…

Wolfgang_S · January 8, 2022, 9:17pm

You’re right. That answer is based on knowledge about influxdb v1. Sorry, for that.
Did you try ( see Install InfluxDB | InfluxDB OSS v2 Documentation )

influx setup

You will be asked to enter:

username
password
repeat the password
organization name
bucket name
retention period

Running

influx auth list

will show the configured token and other information.

DaveL · January 9, 2022, 2:28am

I’ve already run

influx setup

and I can see those values through the API (browser, /api/v2/authorizations). But I still cannot make any edits through the CLI. It almost seems like a folders permission issue but it is likely a lack of admin access, which I cannot seem to grant.

pacive · January 9, 2022, 6:43am

Have you done this step?

Or have you tried the web UI? It’s really easy to create users and tokens that way.