I’m trying to setup persistence by using a mariadb database. The database is on a remote raspberry server.
I have been solving one problem after the other and now I can state the following:
For testing (and also my personal understanding) I have removed the firewall from the database server and installed mysql-client on the openhab server. Now I can connect from the openhab server via
mysql -u username -h ip-adress-db-server -p
to the mysql database server on the remote server.
However Openhab is still giving me errors:
java.io.FileNotFoundException: /var/lib/openhab2/cache/org.eclipse.osgi/219/0/.cp/lib/mysql-connector-java-8.0.13.jar (No such file or directory)
My first question would be:
What addon should I install via paper UI:
JDBC Persistence MYSQL
JDBC Persistence MariaDB
If I have the correct addon(currently MSQL Persistence), how do I solve my problem?