Hello.
I’m new on OpenHAB.
I had a logging persistence before and it worked well.
Now I like to use sqlite via JDBC Persistence Service to store my sensors values.
I followed the official guideline: https://github.com/openhab/openhab/wiki/JDBC-Persistence
But without success until now. Even there are not errors from OpenHAB, I can not find any database file.
Here is my config:
In Addon folder:
org.openhab.binding.homematic-1.8.3.jar*
sqlite-jdbc-3.8.11.2.jar*
org.openhab.action.homematic-1.8.3.jar*
org.openhab.persistence.jdbc-1.8.3.jar*
In openhab.cfg
persistence:default=jdbc
jdbc:url=jdbc:sqlite:./logs/Home.db
jdbc:tableUseRealItemNames=true
In jdbc.persist
// persistence strategies have a name and a definition and are referred to in the “Items” section
Strategies {
everyMinute : "0 * * * * ?"
every5Minutes : "0 0/5 * * * ?"
every10Minutes : "0 0/10 * * * ?"
everyHour : "0 0 * * * ?"
everyDay : “0 0 0 * * ?”
// if no strategy is specified for an item entry below, the default list will be used
default = everyChange
}
/*
- Each line in this section defines for which item(s) which strategy(ies) should be applied.
- You can list single items, use “" for all items or "groupitem” for all members of a group
- item (excl. the group item itself).
/
Items {
// persist all items once a day and on every change and restore them from the db at startup
// gTempHumidity -> “TemperaturFeuchtigkeit” : strategy = every10Minutes, restoreOnStartup
gTempHumidity* : strategy = every10Minutes, restoreOnStartup
}
Here is the startup log:2016-12-04 20:26:33.234 [INFO ] [.o.core.internal.CoreActivator] - openHAB runtime has been started (v1.8.3).
2016-12-04 20:26:34.638 [INFO ] [o.o.i.s.i.DiscoveryServiceImpl] - mDNS service has been started
2016-12-04 20:26:34.672 [INFO ] [o.o.i.s.i.DiscoveryServiceImpl] - Service Discovery initialization completed (bound to address: xxxxx).
2016-12-04 20:26:36.954 [INFO ] [penhab.io.rest.RESTApplication] - Started REST API at /rest
2016-12-04 20:26:44.161 [INFO ] [c.internal.ModelRepositoryImpl] - Loading model 'Haus.sitemap’
2016-12-04 20:26:44.313 [INFO ] [c.internal.ModelRepositoryImpl] - Loading model 'jdbc.persist’
2016-12-04 20:26:44.359 [INFO ] [c.internal.ModelRepositoryImpl] - Loading model 'Haus.items’
2016-12-04 20:26:45.271 [INFO ] [.o.u.w.i.servlet.WebAppServlet] - Started Classic UI at /classicui/openhab.app
2016-12-04 20:26:48.325 [INFO ] [o.o.b.h.i.bus.HomematicBinding] - HomematicConfig[host=…
2016-12-04 20:26:48.327 [INFO ] [.b.h.i.c.HomematicCommunicator] - Starting Homematic communicator
2016-12-04 20:26:48.373 [ERROR] [p.j.internal.JdbcConfiguration] - JDBC::updateConfig: SQL user is missing - please configure the jdbc:user parameter in openhab.cfg
2016-12-04 20:26:48.376 [ERROR] [p.j.internal.JdbcConfiguration] - JDBC::updateConfig: SQL password is missing. Attempting to connect without password. To specify a password configure the jdbc:password parameter in openhab.cfg.
2016-12-04 20:26:48.377 [WARN ] [p.j.internal.JdbcConfiguration] - JDBC::updateConfig: try to load JDBC-driverClass: 'org.sqlite.JDBC’
2016-12-04 20:26:48.381 [WARN ] [o.o.p.jdbc.internal.JdbcMapper] - JDBC::openConnection: setupDataSource.
2016-12-04 20:26:48.385 [INFO ] [.b.h.i.c.HomematicCommunicator] - Homematic ServerId[xxxxxx]
2016-12-04 20:26:48.394 [INFO ] [o.o.b.h.i.c.client.CcuClient ] - Starting CcuClient
2016-12-04 20:26:48.422 [INFO ] [b.h.i.communicator.StateHolder] - Loading Homematic datapoints
2016-12-04 20:26:49.882 [INFO ] [b.h.i.communicator.StateHolder] - Finished loading 300 Homematic datapoints
2016-12-04 20:26:49.883 [INFO ] [b.h.i.communicator.StateHolder] - Loading Homematic Server variables
2016-12-04 20:26:49.911 [INFO ] [b.h.i.communicator.StateHolder] - Finished loading 2 Homematic server variables
2016-12-04 20:26:49.916 [INFO ] [b.h.i.c.s.BinRpcCallbackServer] - Starting BinRpcCallbackServer at port xxxx
2016-12-04 20:26:50.112 [INFO ] [.o.b.h.i.c.client.BinRpcClient] - Interface BidCos-Wired not available, disabling support.
2016-12-04 20:26:50.113 [INFO ] [.o.b.h.i.c.client.BinRpcClient] - Interface CUxD not available, disabling support.
2016-12-04 20:26:50.113 [INFO ] [.b.h.i.c.HomematicCommunicator] - Scheduling one datapoint reload job in one minute
2016-12-04 20:26:50.114 [INFO ] [.service.AbstractActiveService] - Homematic server connection tracker has been started
