I am trying to set up persistence on a new installation of openhabian 1.5 on a Rpi4. I had been using MySQL successfully on a Rpi3 for some time, but wasn’t sure what version to use on Rpi4, so downloaded and installed MariaDB and did a status check.
Mine works with a mysql.cfg file the jdbc.cfg didn’t work in my case as well
# the database url like 'jdbc:mysql://<host>:<port>/<database>' (without quotes)
url=jdbc:mysql://127.0.0.1:3306/OpenHABdata
# the database user
user=openhab
# the database password
# inloggen met sudo mysql -u root -p
password=YouCantGuessMyWP
# the reconnection counter
reconnectCnt=3
I’m not sure I fully understand. What persistence do you have installed in PaperUI (or in addons.cfg)? Was the above file a mysql.cfg or jdbc.cfg file? Is your persistence file jdbc.persist or mysql.persist? What jdbc driver did you have in the addons directory? Thanks in advance.
I was stuck on the idea that because I was now using MariaDB, I needed to use jdbc persistence and add the driver in the jbdc documentation for MariaDB. Basically my system is now setup as it was before when I was using Oracle MySQL (and working). I marked your second post as the solution, but it was really a combination of all your answers.
@Charley just a remark: if you use addons.cfg, it will overwrite whatever you do in PaperUI for each of the entries you uncommented. In your case, the persistence entries in addons.cfg will overwrite your selection in PaperUI every time the addons.cfg is reloaded (i.e., during start-up and after each time addons.cfg is saved).