Which command do you execute ?
What is the error message ?
Any entries in the influxdd logfile ?
With regard to
you should be able to see which privileges are assigned to the related user/role in the client as well.
Hi
I am very depressed. After restart of my Raspi, again influx does not work, grafana does not work,…it is very frustrating.
After checking I found that the rights of ./var/log/grafana directory were root instead of grafana. How can the rights of the directory change after a restart of Raspi?
After correcting this with **openhabian@openhabian**:**/var/log $** sudo chown -hR grafana:grafana ./grafana/ Grafana is still not working.
But that is not the worse as influx is dead as well. Going again through the process of setting up new admin rights is strange for me. How can it be that the influx admin (or maybe all influx user) settings are gone after a restart of Raspi? I did it anyway, meaning setting up the right users with proper rights in influx. Now I have users, but no influx database. It seems to be gone as well…I dont understand why there is no database anymore…restarting Raspi deletes it? Or is it stored somewhere else?
There seems to be something basically wrong…any idea what that might be?
So I executed and found…
openhabian@openhabian:/ $ cat ./etc/influxdb/influxdb.conf | grep -v "#" | grep -v "^$"
openhabian@openhabian:/ $ service influxdb stop. ——— pwd =openhabian openhabian@openhabian:/ $ sudo vim ./etc/influxdb/influxdb.conf
exit mit :wq!
openhabian@openhabian:/ $ cat ./etc/influxdb/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 = false
[logging]
[subscriber]
[[graphite]]
[[collectd]]
[[opentsdb]]
[[udp]]
[continuous_queries]
[tls]
openhabian@openhabian:/ $ service influxdb start
openhabian@openhabian:/ $ influx
> create user AlexollonAdmin with password 'mypwd' with all privileges
> show users
user admin
---- -----
AlexollonAdmin true
> create user AlexollonOpenhab with password 'mypwd'
> create user AlexollonGrafana2influx with password 'mypwd'
> exit
openhabian@openhabian:/ $ service influxdb restart
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to restart 'influxdb.service'.
Authenticating as: ,,, (openhabian)
Password:
==== AUTHENTICATION COMPLETE ===
openhabian@openhabian:/ $ influx
Connected to http://localhost:8086 version 1.8.10
InfluxDB shell version: 1.8.10
> show users
user admin
---- -----
AlexollonAdmin true
AlexollonOpenhab false
AlexollonGrafana2influx false
> show databases
name: databases
name
----
> exit
openhabian@openhabian:/ $ cd ./var/lib/influxdb/data/
openhabian@openhabian:/var/lib/influxdb/data $ la
total 12K
drwxr-xr-x 2 influxdb influxdb 4.0K Jan 9 13:27 ./
drwxr-xr-x 1 influxdb influxdb 4.0K Jan 9 14:21 ../
openhabian@openhabian:/var/lib/influxdb/data $
openhabian@openhabian:/var/lib/influxdb/meta $ cat meta.db
???ܻ̪?2P
AlexollonAdmin<$2a$10$prFPB2zr8hm9ubsVKEuGrO0DWAPqEyZMnKWVsOaIGlEJfTnHYZwkS2R
AlexollonOpenhab<$2a$10$ui3J0vVL.7mnoB4lAG44V.zmk6JN.N1XotFki/NkYnL8IOUJlQ2Xy2Y
AlexollonGrafana2influx<$2a$10$PvKz2lHIantnmsDu6DxCUu6yneiwTUVohh0q7AtIcVuuEhU9l.fp68@Hopenhabian@openhabian:/var/lib/influxdb/meta $
. go to the influxdb config directory
openhabian@openhabian:/etc/influxdb $ sudo vim influxdb.conf
. change „enable-auth = true“
openhabian@openhabian:/ $ service influxdb restart
openhabian@openhabian:/etc/influxdb $ sudo 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>".
So after I enabled authentication again in the influx config file, and restarted influx - the users are again “gone” - or at least I cannot access them anymore. But this although the meta directory shows them still. I checked the meta files again.
Why is influx after restarting “loosing” the user settings…and not to say also the database…?
I added a grep of the journal…
openhabian@openhabian:/ $ sudo journalctl | grep -i influx
Jan 09 14:05:53 openhabian sudo[9408]: openhabian : TTY=pts/0 ; PWD=/ ; USER=root ; COMMAND=/usr/bin/vim ./etc/influxdb/influxdb.conf
Jan 09 14:34:50 openhabian sudo[15070]: openhabian : TTY=pts/0 ; PWD=/var/lib ; USER=root ; COMMAND=/usr/bin/systemctl status influxdb
Jan 09 14:40:23 openhabian sudo[16198]: openhabian : TTY=pts/0 ; PWD=/etc/influxdb ; USER=root ; COMMAND=/usr/bin/vim influxdb.conf
Jan 09 14:40:32 openhabian influxd-systemd-start.sh[12447]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:40:32 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" b72f9b97-7151-11ec-8407-e45f01610c46 221
…
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:26 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 1ed85848-7152-11ec-84aa-e45f01610c46 129
Jan 09 14:43:26 openhabian polkitd(authority=local)[10042]: Operator of unix-process:16772:457057 successfully authenticated as unix-user:openhabian to gain ONE-SHOT authorization for action org.freedesktop.systemd1.manage-units for system-bus-name::1.65 [systemctl restart influxdb.service] (owned by unix-user:openhabian)
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.534001Z lvl=info msg="Signal received, initializing clean shutdown..." log_id=0YwkrOQW000
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.534093Z lvl=info msg="Waiting for clean shutdown..." log_id=0YwkrOQW000
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: [tcp] 2022/01/09 14:43:26 tcp.Mux: Listener at 127.0.0.1:8088 failed failed to accept a connection, closing all listeners - accept tcp 127.0.0.1:8088: use of closed network connection
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.534386Z lvl=info msg="Listener closed" log_id=0YwkrOQW000 service=snapshot
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.534496Z lvl=info msg="Shutting down monitor service" log_id=0YwkrOQW000 service=monitor
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.534585Z lvl=info msg="Terminating precreation service" log_id=0YwkrOQW000 service=shard-precreation
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.534624Z lvl=info msg="Terminating continuous query service" log_id=0YwkrOQW000 service=continuous_querier
Jan 09 14:43:26 openhabian systemd[1]: Stopping InfluxDB is an open-source, distributed, time series database...
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.535130Z lvl=info msg="Closing retention policy enforcement service" log_id=0YwkrOQW000 service=retention
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.535351Z lvl=info msg="Closed service" log_id=0YwkrOQW000 service=subscriber
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[12447]: ts=2022-01-09T13:43:26.535498Z lvl=info msg="Server shutdown completed" log_id=0YwkrOQW000
Jan 09 14:43:26 openhabian systemd[1]: influxdb.service: Succeeded.
Jan 09 14:43:26 openhabian systemd[1]: Stopped InfluxDB is an open-source, distributed, time series database.
Jan 09 14:43:26 openhabian systemd[1]: influxdb.service: Consumed 2.821s CPU time.
Jan 09 14:43:26 openhabian systemd[1]: Starting InfluxDB is an open-source, distributed, time series database...
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16796]: Merging with configuration at: /etc/influxdb/influxdb.conf
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.641552Z lvl=info msg="InfluxDB starting" log_id=0Ywm72hG000 version=1.8.10 branch=1.8 commit=688e697c51fd
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.642137Z lvl=info msg="Go runtime" log_id=0Ywm72hG000 version=go1.13.8 maxprocs=4
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16813]: Merging with configuration at: /etc/influxdb/influxdb.conf
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16793]: InfluxDB API unavailable after 1 attempts...
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744129Z lvl=info msg="Using data dir" log_id=0Ywm72hG000 service=store path=/var/lib/influxdb/data
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744266Z lvl=info msg="Compaction settings" log_id=0Ywm72hG000 service=store max_concurrent_compactions=2 throughput_bytes_per_second=50331648 throughput_bytes_per_second_burst=50331648
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744356Z lvl=info msg="Open store (start)" log_id=0Ywm72hG000 service=store trace_id=0Ywm7360000 op_name=tsdb_open op_event=start
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744556Z lvl=info msg="Open store (end)" log_id=0Ywm72hG000 service=store trace_id=0Ywm7360000 op_name=tsdb_open op_event=end op_elapsed=0.205ms
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744708Z lvl=info msg="Opened service" log_id=0Ywm72hG000 service=subscriber
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744753Z lvl=info msg="Starting monitor service" log_id=0Ywm72hG000 service=monitor
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744789Z lvl=info msg="Registered diagnostics client" log_id=0Ywm72hG000 service=monitor name=build
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744825Z lvl=info msg="Registered diagnostics client" log_id=0Ywm72hG000 service=monitor name=runtime
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744859Z lvl=info msg="Registered diagnostics client" log_id=0Ywm72hG000 service=monitor name=network
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744903Z lvl=info msg="Registered diagnostics client" log_id=0Ywm72hG000 service=monitor name=system
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744954Z lvl=info msg="Starting precreation service" log_id=0Ywm72hG000 service=shard-precreation check_interval=10m advance_period=30m
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.744996Z lvl=info msg="Starting snapshot service" log_id=0Ywm72hG000 service=snapshot
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.745033Z lvl=info msg="Starting continuous query service" log_id=0Ywm72hG000 service=continuous_querier
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.745098Z lvl=info msg="Starting HTTP service" log_id=0Ywm72hG000 service=httpd authentication=true
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.745134Z lvl=info msg="opened HTTP access log" log_id=0Ywm72hG000 service=httpd path=stderr
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.745165Z lvl=info msg="Auth is enabled but shared-secret is blank. BearerAuthentication is disabled." log_id=0Ywm72hG000 service=httpd
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.746781Z lvl=info msg="Listening on HTTP" log_id=0Ywm72hG000 service=httpd addr=127.0.0.1:8086 https=false
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.746919Z lvl=info msg="Starting retention policy enforcement service" log_id=0Ywm72hG000 service=retention check_interval=30m
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.747474Z lvl=info msg="Listening for signals" log_id=0Ywm72hG000
Jan 09 14:43:26 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:43:26.748148Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0Ywm72hG000
Jan 09 14:43:27 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:27 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 1f828988-7152-11ec-8001-e45f01610c46 134611
Jan 09 14:43:27 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - - [09/Jan/2022:14:43:27 +0100] "GET /health HTTP/1.1" 200 107 "-" "curl/7.74.0" 1fde7743-7152-11ec-8002-e45f01610c46 146
Jan 09 14:43:27 openhabian influxd-systemd-start.sh[16793]: InfluxDB started
Jan 09 14:43:27 openhabian systemd[1]: Started InfluxDB is an open-source, distributed, time series database.
Jan 09 14:43:29 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:29 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 20c95e9e-7152-11ec-8003-e45f01610c46 229
Jan 09 14:43:30 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:30 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 21727629-7152-11ec-8004-e45f01610c46 582
Jan 09 14:43:30 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - - [09/Jan/2022:14:43:30 +0100] "GET /ping HTTP/1.1" 204 0 "-" "InfluxDBShell/1.8.10" 2199aa50-7152-11ec-8005-e45f01610c46 81
Jan 09 14:43:31 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:31 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 220c5758-7152-11ec-8006-e45f01610c46 147
Jan 09 14:43:31 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:31 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 221c8df2-7152-11ec-8007-e45f01610c46 568
Jan 09 14:43:32 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:32 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 22c5e44d-7152-11ec-8008-e45f01610c46 475
Jan 09 14:43:32 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - - [09/Jan/2022:14:43:32 +0100] "POST /query?chunked=true&db=&epoch=ns&q=show+users HTTP/1.1 " 401 55 "-" "InfluxDBShell/1.8.10" 22f652a0-7152-11ec-8009-e45f01610c46 207
Jan 09 14:43:33 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:33 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 235fbd65-7152-11ec-800a-e45f01610c46 191
…
Jan 09 14:43:57 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:57 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 319ce928-7152-11ec-8022-e45f01610c46 226
Jan 09 14:43:58 openhabian sudo[16938]: openhabian : TTY=pts/0 ; PWD=/etc/influxdb ; USER=root ; COMMAND=/usr/bin/influx
Jan 09 14:43:58 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - - [09/Jan/2022:14:43:58 +0100] "GET /ping HTTP/1.1" 204 0 "-" "InfluxDBShell/1.8.10" 31f68a87-7152-11ec-8023-e45f01610c46 43
Jan 09 14:43:58 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:58 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 3236892f-7152-11ec-8024-e45f01610c46 215
Jan 09 14:43:58 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:43:58 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 3246ba8e-7152-11ec-8025-e45f01610c46 284
Jan 09 14:44:00 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:44:00 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 338895a9-7152-11ec-8026-e45f01610c46 171
Jan 09 14:44:00 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:44:00 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 3398bd9d-7152-11ec-8027-e45f01610c46 279
Jan 09 14:44:01 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - - [09/Jan/2022:14:44:01 +0100] "POST /query?chunked=true&db=&epoch=ns&q=show+users HTTP/1.1 " 401 55 "-" "InfluxDBShell/1.8.10" 33d2974d-7152-11ec-8028-e45f01610c46 266
Jan 09 14:44:01 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:44:01 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 343283f8-7152-11ec-8029-e45f01610c46 236
…
Jan 09 14:51:50 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:51:50 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 4b3f8794-7153-11ec-81cd-e45f01610c46 356
Jan 09 14:52:47 openhabian influxd-systemd-start.sh[16794]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:52:47 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 6dc22760-7153-11ec-81fb-e45f01610c46 287
Jan 09 14:52:48 openhabian sudo[18723]: openhabian : TTY=pts/0 ; PWD=/ ; USER=root ; COMMAND=/usr/sbin/service influxdb restart
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.626844Z lvl=info msg="Signal received, initializing clean shutdown..." log_id=0Ywm72hG000
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.626953Z lvl=info msg="Waiting for clean shutdown..." log_id=0Ywm72hG000
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: [tcp] 2022/01/09 14:52:48 tcp.Mux: Listener at 127.0.0.1:8088 failed failed to accept a connection, closing all listeners - accept tcp 127.0.0.1:8088: use of closed network connection
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.627336Z lvl=info msg="Listener closed" log_id=0Ywm72hG000 service=snapshot
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.627462Z lvl=info msg="Shutting down monitor service" log_id=0Ywm72hG000 service=monitor
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.627549Z lvl=info msg="Terminating precreation service" log_id=0Ywm72hG000 service=shard-precreation
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.627614Z lvl=info msg="Terminating continuous query service" log_id=0Ywm72hG000 service=continuous_querier
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.628216Z lvl=info msg="Closing retention policy enforcement service" log_id=0Ywm72hG000 service=retention
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.628436Z lvl=info msg="Closed service" log_id=0Ywm72hG000 service=subscriber
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[16794]: ts=2022-01-09T13:52:48.628551Z lvl=info msg="Server shutdown completed" log_id=0Ywm72hG000
Jan 09 14:52:48 openhabian systemd[1]: Stopping InfluxDB is an open-source, distributed, time series database...
Jan 09 14:52:48 openhabian systemd[1]: influxdb.service: Succeeded.
Jan 09 14:52:48 openhabian systemd[1]: Stopped InfluxDB is an open-source, distributed, time series database.
Jan 09 14:52:48 openhabian systemd[1]: influxdb.service: Consumed 1.711s CPU time.
Jan 09 14:52:48 openhabian systemd[1]: Starting InfluxDB is an open-source, distributed, time series database...
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18731]: Merging with configuration at: /etc/influxdb/influxdb.conf
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.692676Z lvl=info msg="InfluxDB starting" log_id=0YwmeMD0000 version=1.8.10 branch=1.8 commit=688e697c51fd
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.693789Z lvl=info msg="Go runtime" log_id=0YwmeMD0000 version=go1.13.8 maxprocs=4
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18747]: Merging with configuration at: /etc/influxdb/influxdb.conf
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18728]: InfluxDB API unavailable after 1 attempts...
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.795734Z lvl=info msg="Using data dir" log_id=0YwmeMD0000 service=store path=/var/lib/influxdb/data
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.796385Z lvl=info msg="Compaction settings" log_id=0YwmeMD0000 service=store max_concurrent_compactions=2 throughput_bytes_per_second=50331648 throughput_bytes_per_second_burst=50331648
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.796826Z lvl=info msg="Open store (start)" log_id=0YwmeMD0000 service=store trace_id=0YwmeMc0000 op_name=tsdb_open op_event=start
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.797337Z lvl=info msg="Open store (end)" log_id=0YwmeMD0000 service=store trace_id=0YwmeMc0000 op_name=tsdb_open op_event=end op_elapsed=0.518ms
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.798203Z lvl=info msg="Opened service" log_id=0YwmeMD0000 service=subscriber
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.798602Z lvl=info msg="Starting monitor service" log_id=0YwmeMD0000 service=monitor
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.799028Z lvl=info msg="Registered diagnostics client" log_id=0YwmeMD0000 service=monitor name=build
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.799371Z lvl=info msg="Registered diagnostics client" log_id=0YwmeMD0000 service=monitor name=runtime
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.799719Z lvl=info msg="Registered diagnostics client" log_id=0YwmeMD0000 service=monitor name=network
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.800065Z lvl=info msg="Registered diagnostics client" log_id=0YwmeMD0000 service=monitor name=system
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.800433Z lvl=info msg="Starting precreation service" log_id=0YwmeMD0000 service=shard-precreation check_interval=10m advance_period=30m
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.800911Z lvl=info msg="Starting snapshot service" log_id=0YwmeMD0000 service=snapshot
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.801340Z lvl=info msg="Starting continuous query service" log_id=0YwmeMD0000 service=continuous_querier
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.801779Z lvl=info msg="Starting HTTP service" log_id=0YwmeMD0000 service=httpd authentication=true
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.802254Z lvl=info msg="opened HTTP access log" log_id=0YwmeMD0000 service=httpd path=stderr
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.802612Z lvl=info msg="Auth is enabled but shared-secret is blank. BearerAuthentication is disabled." log_id=0YwmeMD0000 service=httpd
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.804140Z lvl=info msg="Listening on HTTP" log_id=0YwmeMD0000 service=httpd addr=127.0.0.1:8086 https=false
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.804686Z lvl=info msg="Starting retention policy enforcement service" log_id=0YwmeMD0000 service=retention check_interval=30m
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.805497Z lvl=info msg="Listening for signals" log_id=0YwmeMD0000
Jan 09 14:52:48 openhabian influxd-systemd-start.sh[18729]: ts=2022-01-09T13:52:48.805588Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0YwmeMD0000
Jan 09 14:52:49 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:52:48 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 6e5bf1d3-7153-11ec-8001-e45f01610c46 129937
Jan 09 14:52:49 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:52:49 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 6e801acb-7153-11ec-8002-e45f01610c46 300
Jan 09 14:52:49 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - - [09/Jan/2022:14:52:49 +0100] "GET /health HTTP/1.1" 200 107 "-" "curl/7.74.0" 6ee0ac01-7153-11ec-8003-e45f01610c46 160
Jan 09 14:52:49 openhabian influxd-systemd-start.sh[18728]: InfluxDB started
Jan 09 14:52:49 openhabian systemd[1]: Started InfluxDB is an open-source, distributed, time series database.
Jan 09 14:52:50 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:52:50 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 6f0a91c0-7153-11ec-8004-e45f01610c46 146
…
Jan 09 14:52:55 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:52:55 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 7248a410-7153-11ec-8009-e45f01610c46 146
Jan 09 14:52:56 openhabian sudo[18793]: openhabian : TTY=pts/0 ; PWD=/ ; USER=root ; COMMAND=/usr/bin/influx
Jan 09 14:52:56 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - - [09/Jan/2022:14:52:56 +0100] "GET /ping HTTP/1.1" 204 0 "-" "InfluxDBShell/1.8.10" 72d2fcaa-7153-11ec-800a-e45f01610c46 42
Jan 09 14:52:58 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:52:58 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" 74458da5-7153-11ec-800f-e45f01610c46 189
…
Jan 09 14:52:59 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - - [09/Jan/2022:14:52:59 +0100] "POST /query?chunked=true&db=&epoch=ns&q=show+users HTTP/1.1 " 401 55 "-" "InfluxDBShell/1.8.10" 74882fa1-7153-11ec-8010-e45f01610c46 203
…
Jan 09 14:55:10 openhabian influxd-systemd-start.sh[18729]: [httpd] 127.0.0.1 - AlexollonOpenhab [09/Jan/2022:14:55:10 +0100] "POST /write?db=dieKucharsOH&rp=autogen&precision=n&consistency=one HTTP/1.1 " 404 49 "-" "okhttp/3.14.9" c2a5e0cc-7153-11ec-808a-e45f01610c46 398
openhabian@openhabian:/ $ ```I would suggest that you:
- disable/turn of ZRAM
- install resp. configure influxdb/grafana and directory rights
- restart the Pi
- check if everything is ok
- enable ZRAM again once rights and content is ok otherwise repeat above configuration steps
Thanks for all responses. I’m still struggling with CLI commands but am now running (so I guess I care less about that!).
I updated to the latest version of grafana (v8.3.3), then set up my grafana to Influxdb connection via Flux as opposed to InfluxQL. From there I was able to authenticate, “with Credentials” using my Influx token.
Thx. I have done so by reinstalling influx and grafana from the openhabian-config. Grafana and Influx work now again, data is stored and shown in Grafana. Strange enough, I had to execute influx -username YourUserNameHere -password YourPasswordHereagain to see the (now again correct) users and database settings. In a next step I will enable ZRAM again and see if it still works.
Out of that (for future installations) the right order is then:
- install openhabian
- disable zram
- install influx&grafana (from openhabian-config)
- do first configurations and check whether all works (functionally but also checking whether influx shows proper user and database settings)
- restart Raspi
- again check whether all still works
- enable zram
- again check whether all still works
Is that the proper order?
Yes, would do it in that sequence.
To use the JavaScript library of @wborn with Grafana v9 it is enough to put
OHG_DEFAULTS["panelPath"] = "/d-solo/";
in openhab-grafana-user-defaults.js
hi,
CAN SOMEONE HELP ME please,
I got this error: "Get “http://192.168.178.68:8086/query?db=openhab&epoch=ms&q=SHOW+measurements”: dial tcp 192.168.178.68:8086: connect: connection refused error performing influxQL query " in grafana when i try to connect to influx db.
I am running openhabian 3x on raspberry pi4, i have installed influxdb and grafana using sudo openahabian-config.
i have retried to many times…
Looks like grafana is not running.
What is the output of
sudo systemctl status grafana-server.service
what does
sudo journalctl -u grafana
show ?
Also have a look to content of the grafana system log: /var/log/grafana/grafana.log
Ok. grafana runs. Whath about influxdb ?
Following command checks if there is a listening process running on port 8086. It also will show the the listening interface.
netstat -tulpn | grep influxd
Influxdb is only listening on localhost (127.0.0.1), i.e it only accepts connections from the same machine. I guess both openHAB and influxdb runs on the same raspberry pi? In that case, change the url in the OH-configuration to http://127.0.0.1:8086
yes that is ok but as @pacive stated the influxdb is only listening on localhost ( 127.0.0.1 ) interface and not on the ethernet interface ( 192.168.178.68 ). Change this part in the data URL in the configuration.
Other possibility would be to make influxdb listen on ethernet interface but that is not recommended and not necessary as long as the client that access influxdb via URL runs on the same host.
ok,
now i have turned on mu raspberry pi but this happens 
:
and i made the change in the setting of openhab and tried in grafana and this error happen: “error reading InfluxDB. Status Code: 403”
so I run the command influxd whith this result:
WHAT I HAVE TO DO NOW? can someone help me out with this please ?
- I wouldn’t start the influxd daemon on the command line with the bare command influxd but by starting the service using systemctl
- as you already did this check the permissions of the influxdb related directories they may belong to a wrong user e.g. root instead of influxdb which would explain the permission problem
- check the with journalctl if there are more details about the errors
i have solved the permission for influxd, giving permissions to everyone to /var/lib/influxdb/meta, as you can see:
but regarding the influxdb i am not able to see the users or databases:
and I think for this reason this error happen in Grafana:
I am new in this field, please can you help me?
I reasume the step I have done : installed openhabian on pi4, installed influxdb and grafana using sudo openhabian-config, created the users and the psw when it promped me out, then I installed the influxdb add on in openhab ui and selected the persistence service in the setting.
and you configured items that are to be persisted ? Does openHAB successfully persist data ?
Better use chown -R influxdb:influxdb /var/lib/influxdb even if chmodding may work.
Opening a directory with 777 does not support privilege separation between processes.