Man thanks for your comprehensive explanation. I tried the command with and without subshell - nothing works. I followed exactly the steps you mentioned. Here is the result:
____ ____ ___ ____ / / / / | / __ )
/ __ \/ __ \/ _ \/ __ \/ /_/ / /| | / __ |
/ /_/ / /_/ / __/ / / / __ / ___ |/ /_/ /
\____/ .___/\___/_/ /_/_/ /_/_/ |_/_____/
/_/ 2.3.0
Release Build
Hit '<tab>' for a list of available commands
and '[cmd] --help' for help on a specific command.
Hit '<ctrl-d>' or type 'system:shutdown' or 'logout' to shutdown openHAB.
openhab> log:set DEBUG org.openhab.persistence.influxdb
Error executing command: Unrecognized configuration
openhab> feature:list | grep flux
openhab-persistence-influxdb │ 1.12.0 │ x │ Star ted │ openhab-addons-2.3.0 │ InfluxDB (v 1.0) Persistence
openhab> feature:info openhab-persistence-influxdb
Feature openhab-persistence-influxdb 1.12.0
Description:
InfluxDB (v 1.0) Persistence
Feature has no configuration
Feature configuration files:
${openhab.conf}/services/influxdb.cfg
Feature depends on:
openhab-runtime-base 0.0.0
openhab-runtime-compat1x 0.0.0
Feature contains followed bundles:
mvn:org.openhab.persistence/org.openhab.persistence.influxdb/1.12.0 start-level=80
Feature has no conditionals.
openhab> log:set DEBUG org.openhab.persistence.influxdb
Error executing command: Unrecognized configuration
openhab> log:list
Error executing command: Unrecognized configuration
openhab> log:list
Error executing command: Unrecognized configuration
openhab>
No idea what I can do else …
I wish you a merry Christmas - Ulrich
No, I didn’t touch that file. But it is empty, except 2 comment lines. I just re-installed openhab and looked again to that file. Last modified date is today - so far ok. But it remained empty. What should it contain?
Here is the file:
I have seen after re-installation that all bindings, items etc. still work (of course, I have stored addons, conf and userdata before in a backup…). It means, re-installation doesn’t overwrite or clear any user data. Is it worth to delete ALL files of the openhab directory manually and then build up everything from scratch?
There should be a file /var/lib/openhab2/etc/org.ops4j.pax.logging.cfg.dpkg-old or /var/lib/openhab2/etc/org.ops4j.pax.logging.cfg.dpkg-dist which should contain the complete configuration. please rename the files or copy the correct file:
cd /var/lib/openhab2/etc
sudo mv org.ops4j.pax.logging.cfg org.ops4j.pax.logging.cfg.old
sudo mv org.ops4j.pax.logging.cfg.dpkg-[dist|old] org.ops4j.pax.logging.cfg
or take mine:
# Common pattern layout for appenders
#log4j2.pattern = %d{ISO8601} | %-5p | %-16t | %-32c{1} | %X{bundle.id} - %X{bundle.name} - %X{bundle.version} | %m%n
# Root logger
log4j2.rootLogger.level = WARN
log4j2.rootLogger.appenderRefs = out, osgi
log4j2.rootLogger.appenderRef.out.ref = LOGFILE
log4j2.rootLogger.appenderRef.osgi.ref = OSGI
# Karaf Shell logger
log4j2.logger.shell.name = org.apache.karaf.shell.support
log4j2.logger.shell.level = OFF
log4j2.logger.shell.appenderRefs = stdout
log4j2.logger.shell.appenderRef.stdout.ref = STDOUT
# Security audit logger
log4j2.logger.audit.name = org.apache.karaf.jaas.modules.audit
log4j2.logger.audit.level = INFO
log4j2.logger.audit.additivity = false
log4j2.logger.audit.appenderRefs = audit
log4j2.logger.audit.appenderRef.audit.ref = AUDIT
# openHAB specific logger configuration
log4j2.logger.openhab.name = org.openhab
log4j2.logger.openhab.level = INFO
log4j2.logger.smarthome.name = org.eclipse.smarthome
log4j2.logger.smarthome.level = INFO
log4j2.logger.smarthomeItemStateEvent.name = smarthome.event.ItemStateEvent
log4j2.logger.smarthomeItemStateEvent.level = ERROR
log4j2.logger.smarthomeItemAddedEvent.name = smarthome.event.ItemAddedEvent
log4j2.logger.smarthomeItemAddedEvent.level = ERROR
log4j2.logger.smarthomeItemRemovedEvent.name = smarthome.event.ItemRemovedEvent
log4j2.logger.smarthomeItemRemovedEvent.level = ERROR
log4j2.logger.smarthomeThingStatusInfoEvent.name = smarthome.event.ThingStatusInfoEvent
log4j2.logger.smarthomeThingStatusInfoEvent.level = ERROR
log4j2.logger.smarthomeThingAddedEvent.name = smarthome.event.ThingAddedEvent
log4j2.logger.smarthomeThingAddedEvent.level = ERROR
log4j2.logger.smarthomeThingRemovedEvent.name = smarthome.event.ThingRemovedEvent
log4j2.logger.smarthomeThingRemovedEvent.level = ERROR
log4j2.logger.smarthomeInboxUpdatedEvent.name = smarthome.event.InboxUpdatedEvent
log4j2.logger.smarthomeInboxUpdatedEvent.level = ERROR
log4j2.logger.events.name = smarthome.event
log4j2.logger.events.level = INFO
log4j2.logger.events.additivity = false
log4j2.logger.events.appenderRefs = event
log4j2.logger.events.appenderRef.event.ref = EVENT
log4j2.logger.events.appenderRef.osgi.ref = OSGI
log4j2.logger.jupnp.name = org.jupnp
log4j2.logger.jupnp.level = ERROR
log4j2.logger.jmdns.name = javax.jmdns
log4j2.logger.jmdns.level = ERROR
# This suppresses all Maven download issues from the log when doing feature installations
# as we are logging errors ourselves in a nicer way anyhow.
log4j2.logger.paxurl.name = org.ops4j.pax.url.mvn.internal.AetherBasedResolver
log4j2.logger.paxurl.level = ERROR
# Filters known issues of pax-web (issue link to be added here).
# Can be removed once the issues are resolved in an upcoming version.
log4j2.logger.paxweb.name = org.ops4j.pax.web.pax-web-runtime
log4j2.logger.paxweb.level = OFF
# Filters known issues of lsp4j, see
# https://github.com/eclipse/smarthome/issues/4639
# https://github.com/eclipse/smarthome/issues/4629
# https://github.com/eclipse/smarthome/issues/4643
# Can be removed once the issues are resolved in an upcoming version.
log4j2.logger.lsp4j.name = org.eclipse.lsp4j
log4j2.logger.lsp4j.level = OFF
# Filters known issues of KarServiceImpl, see
# https://github.com/openhab/openhab-distro/issues/519#issuecomment-351944506
# Can be removed once the issues are resolved in an upcoming version.
log4j2.logger.karservice.name = org.apache.karaf.kar.internal.KarServiceImpl
log4j2.logger.karservice.level = ERROR
# Filters warnings about small thread pools.
# The thread pool is kept small intentionally for supporting resource constrained hardware.
log4j2.logger.threadpoolbudget.name = org.eclipse.jetty.util.thread.ThreadPoolBudget
log4j2.logger.threadpoolbudget.level = ERROR
# Appenders configuration
# Console appender not used by default (see log4j2.rootLogger.appenderRefs)
log4j2.appender.console.type = Console
log4j2.appender.console.name = STDOUT
log4j2.appender.console.layout.type = PatternLayout
log4j2.appender.console.layout.pattern = %d{HH:mm:ss.SSS} [%-5.5p] [%-36.36c] - %m%n
# Rolling file appender
log4j2.appender.out.type = RollingRandomAccessFile
log4j2.appender.out.name = LOGFILE
log4j2.appender.out.fileName = ${openhab.logdir}/openhab.log
log4j2.appender.out.filePattern = ${openhab.logdir}/openhab.log.%i
log4j2.appender.out.immediateFlush = true
log4j2.appender.out.append = true
log4j2.appender.out.layout.type = PatternLayout
log4j2.appender.out.layout.pattern = %d{yyyy-MM-dd HH:mm:ss.SSS} [%-5.5p] [%-36.36c] - %m%n
log4j2.appender.out.policies.type = Policies
log4j2.appender.out.policies.size.type = SizeBasedTriggeringPolicy
log4j2.appender.out.policies.size.size = 16MB
# Event log appender
log4j2.appender.event.type = RollingRandomAccessFile
log4j2.appender.event.name = EVENT
log4j2.appender.event.fileName = ${openhab.logdir}/events.log
log4j2.appender.event.filePattern = ${openhab.logdir}/events.log.%i
log4j2.appender.event.immediateFlush = true
log4j2.appender.event.append = true
log4j2.appender.event.layout.type = PatternLayout
log4j2.appender.event.layout.pattern = %d{yyyy-MM-dd HH:mm:ss.SSS} [%-26.26c] - %m%n
log4j2.appender.event.policies.type = Policies
log4j2.appender.event.policies.size.type = SizeBasedTriggeringPolicy
log4j2.appender.event.policies.size.size = 16MB
# Audit file appender
log4j2.appender.audit.type = RollingRandomAccessFile
log4j2.appender.audit.name = AUDIT
log4j2.appender.audit.fileName = ${openhab.logdir}/audit.log
log4j2.appender.audit.filePattern = ${openhab.logdir}/audit.log.%i
log4j2.appender.audit.append = true
log4j2.appender.audit.layout.type = PatternLayout
log4j2.appender.audit.layout.pattern = %d{yyyy-MM-dd HH:mm:ss.SSS} [%-5.5p] [%-36.36c] - %m%n
log4j2.appender.audit.policies.type = Policies
log4j2.appender.audit.policies.size.type = SizeBasedTriggeringPolicy
log4j2.appender.audit.policies.size.size = 8MB
# OSGi appender
log4j2.appender.osgi.type = PaxOsgi
log4j2.appender.osgi.name = OSGI
log4j2.appender.osgi.filter = *
first of all: A Happy New Year to you.
Thanks for the config file. It works! Obviously, openhab cannot connect to Influxdb. Here are the relevant log lines after an openhab restart:
2019-01-02 11:28:48.641 [ERROR] [.internal.InfluxDBPersistenceService] - database connection failed
retrofit.RetrofitError: Connection refused (Connection refused)
at retrofit.RetrofitError.networkError(RetrofitError.java:27) ~[241:org.openhab.persistence.influxdb:1.12.0]
at retrofit.RestAdapter$RestHandler.invokeRequest(RestAdapter.java:395) [241:org.openhab.persistence.influxdb:1.12.0]
at retrofit.RestAdapter$RestHandler.invoke(RestAdapter.java:240) [241:org.openhab.persistence.influxdb:1.12.0]
at org.influxdb.impl.$Proxy152.ping(Unknown Source) [241:org.openhab.persistence.influxdb:1.12.0]
at org.influxdb.impl.InfluxDBImpl.ping(InfluxDBImpl.java:114) [241:org.openhab.persistence.influxdb:1.12.0]
at org.openhab.persistence.influxdb.internal.InfluxDBPersistenceService.checkConnection(InfluxDBPersistenceService.java:172) [241:org.openhab.persistence.influxdb:1.12.0]
at org.openhab.persistence.influxdb.internal.InfluxDBPersistenceService.activate(InfluxDBPersistenceService.java:145) [241:org.openhab.persistence.influxdb:1.12.0]
and a whole bunch of “at”-lines more.
I checked username and password both in openhab and influxdb - ok. Influxdb knows my database named openhab.
HEUREKA - I’VE GOT IT !!!
I changed the URL by “localhost:8086”. The reason is most probably that the Synology has two URL’S - in my case. 38 and .27 When installing programs it is not every time clear which URL is chosen. Up to now it made no difference for all programs I have running on my server - I can reach them anyway. In this special case - combing openhab and Influx - it seems to play a role.
Anyway - many, many thanks for your help I really learned a lot about openhab
Hi @Udo_Hartmann
I have a simular problem. i just installed a fresh openhab 2.4, used openhabian-config to install influxdb and grafana… I believe everything is set up correctly. But I get no data in grafana. And I cant tell if it´s openhab, influxdb or grafana doing something wrong.
I took a copy of your org.ops4j.pax.logging.cfg above… But I get no errors or anything…
I have turned on DEBUG logging for influxdb in Karaf:
Just an idea to locate the error source: Go to Cronograf (localhost:3004), chose Queries and type
SELECT <your_persistent_item> FROM <your_database>.
If Cronograf starts searching something it means influxdb knows your item, i.e. it runs and is connected to openhab.
Any hints in openhab.log when restarting openhab? (this is what I’ve learned from Udo…)
I didn’t click the Basic Auth checkbox in Grafana but I am not sure whether it makes a difference.
I don’t know which version of influxdb you use. Chronograf (sorry for misspelling) is the WebUI of influxdb. I have version 1.7.2, running on a Synology docker. With raspi I have no experience. Try port 3004.
Thx… I cant even install the damn thing!
Got the file allright, (version 1.7.5) for armhf (using an Rpi 3B+)… But have no idea how to install it. And the docs are useless for this situation, heck not even updated…
Gave up this Chronograf… I´m too stupid for Linux… The file I got was a zip file, not a deb file… It´s only available for 64bit, (no arm support)…
