openHAB 2.4 and influxdb

Tags: #<Tag:0x00007f6167e963d8>
  • Platform information:
    • Hardware: _CPUArchitecture/RAM/storage_raspberry 3+
    • OS: what OS is used and which version
    • Java Runtime Environment: which java platform is used and what version
    • openHAB version:openhabian 2.4
  • Issue of the topic: please be detailed explaining your issue
  • Please post configurations (if applicable):
    • Items configuration related to the issue
    • Sitemap configuration related to the issue
    • Rules code related to the issue
    • Services configuration related to the issue
  • If logs where generated please post these here using code fences:

Hello, after a new one after passing 2.4 and SSD, there was a problem with influxdb binding. Everything is nice installed and the service works, but you can not add anything to the base, so you do not have data to read it. The logs appear

019-01-29 20:16:00.135 [ERROR] [org.influxdb.impl.BatchProcessor ] - Batch could not be sent. Data will be lost

retrofit.RetrofitError: Connection refused (Connection refused)

at retrofit.RetrofitError.networkError(RetrofitError.java:27) ~[276:org.openhab.persistence.influxdb:1.13.0]

at retrofit.RestAdapter$RestHandler.invokeRequest(RestAdapter.java:395) ~[276:org.openhab.persistence.influxdb:1.13.0]

at retrofit.RestAdapter$RestHandler.invoke(RestAdapter.java:240) ~[276:org.openhab.persistence.influxdb:1.13.0]

at org.influxdb.impl.$Proxy177.writePoints(Unknown Source) ~[276:org.openhab.persistence.influxdb:1.13.0]

at org.influxdb.impl.InfluxDBImpl.write(InfluxDBImpl.java:151) ~[276:org.openhab.persistence.influxdb:1.13.0]

at org.influxdb.impl.BatchProcessor.write(BatchProcessor.java:171) [276:org.openhab.persistence.influxdb:1.13.0]

at org.influxdb.impl.BatchProcessor$1.run(BatchProcessor.java:144) [276:org.openhab.persistence.influxdb:1.13.0]

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:?]

at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:?]

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:?]

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:?]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:?]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:?]

at java.lang.Thread.run(Thread.java:748) [?:?]

Caused by: java.net.ConnectException: Connection refused (Connection refused)

at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:?]

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:?]

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:?]

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:?]

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:?]

at java.net.Socket.connect(Socket.java:589) ~[?:?]

at com.squareup.okhttp.internal.Platform.connectSocket(Platform.java:100) ~[?:?]

at com.squareup.okhttp.internal.http.SocketConnector.connectRawSocket(SocketConnector.java:160) ~[?:?]

at com.squareup.okhttp.internal.http.SocketConnector.connectCleartext(SocketConnector.java:67) ~[?:?]

at com.squareup.okhttp.Connection.connect(Connection.java:152) ~[?:?]

at com.squareup.okhttp.Connection.connectAndSetOwner(Connection.java:185) ~[?:?]

at com.squareup.okhttp.OkHttpClient$1.connectAndSetOwner(OkHttpClient.java:128) ~[?:?]

at com.squareup.okhttp.internal.http.HttpEngine.nextConnection(HttpEngine.java:341) ~[?:?]

at com.squareup.okhttp.internal.http.HttpEngine.connect(HttpEngine.java:330) ~[?:?]

at com.squareup.okhttp.internal.http.HttpEngine.sendRequest(HttpEngine.java:248) ~[?:?]

at com.squareup.okhttp.Call.getResponse(Call.java:273) ~[?:?]

at com.squareup.okhttp.Call$ApplicationInterceptorChain.proceed(Call.java:230) ~[?:?]

at com.squareup.okhttp.Call.getResponseWithInterceptorChain(Call.java:201) ~[?:?]

at com.squareup.okhttp.Call.execute(Call.java:81) ~[?:?]

at retrofit.client.OkClient.execute(OkClient.java:53) ~[?:?]

at retrofit.RestAdapter$RestHandler.invokeRequest(RestAdapter.java:326) ~[?:?]

Now, in Putty, when I issue the command: influx, the influx shell will report, but if I want to do another comedy, eg create a base:

Blockquote
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>”.

Do you have any idea? Because I do not know.

This all looks like a problem with your InfluxDB. Perhaps it got corrupted. Perhaps it lost the openhab database. But both OH and your manual login are showing problems.

Instalation influx is new. I installed the openhabian menu
I have log with putty:

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 Mon 2019-01-28 18:17:09 CET; 1 day 2h ago
Docs: https://docs.influxdata.com/influxdb/
Main PID: 477 (influxd)
CGroup: /system.slice/influxdb.service
└─477 /usr/bin/influxd -config /etc/influxdb/influxdb.conf

Jan 29 19:45:43 openHABianPi influxd[477]: ts=2019-01-29T18:45:43.085086Z lvl=info msg=“Retention policy deletion check (start)” log_id=0DHNHkh0
Jan 29 19:45:43 openHABianPi influxd[477]: ts=2019-01-29T18:45:43.085390Z lvl=info msg=“Retention policy deletion check (end)” log_id=0DHNHkh000
Jan 29 20:15:43 openHABianPi influxd[477]: ts=2019-01-29T19:15:43.085074Z lvl=info msg=“Retention policy deletion check (start)” log_id=0DHNHkh0
Jan 29 20:15:43 openHABianPi influxd[477]: ts=2019-01-29T19:15:43.085386Z lvl=info msg=“Retention policy deletion check (end)” log_id=0DHNHkh000
Jan 29 20:22:26 openHABianPi influxd[477]: [httpd] 127.0.0.1 - - [29/Jan/2019:20:22:26 +0100] “GET /ping HTTP/1.1” 204 0 “-” "InfluxDBShell/1.7.
Jan 29 20:22:53 openHABianPi influxd[477]: [httpd] 127.0.0.1 - - [29/Jan/2019:20:22:53 +0100] "POST /query?chunked=true&db=&epoch=ns&q=CREATE+DA
Jan 29 20:23:03 openHABianPi influxd[477]: [httpd] 127.0.0.1 - - [29/Jan/2019:20:23:03 +0100] "POST /query?chunked=true&db=&epoch=ns&q=ERR%3A+un
Jan 29 20:23:03 openHABianPi influxd[477]: [httpd] 127.0.0.1 - - [29/Jan/2019:20:23:03 +0100] "POST /query?chunked=true&db=&epoch=ns&q=Warning%3
Jan 29 20:23:03 openHABianPi influxd[477]: [httpd] 127.0.0.1 - - [29/Jan/2019:20:23:03 +0100] "POST /query?chunked=true&db=&epoch=ns&q=Please+se
Jan 29 20:23:33 openHABianPi influxd[477]: [httpd] 127.0.0.1 - - [29/Jan/2019:20:23:33 +0100] "POST /query?chunked=true&db=&epoch=ns&q=CREATE+DA