Can anyone explain or point to an existing guide on how to establish a secure connection between LO Base and mariadb.
I would like to run mariadb on a virtual server and have a secure connection between my laptop running Ubuntu and LO Base connecting to the server.
I have found this information on maradb and TLS:
I am currently using “org.mariadb.jdbc.Driver” to connect LO Base version 126.96.36.199 on Ubuntu 21.04 to a mariadb on an ubuntu server 21.04 on my lan.
I have the mariadb-java-client.jar installed.
To create a new database connection I have gone: File → New → Database → Connect to an existing database → Mysql → Next → ‘Connect using JDBC’. Then I filled in the database name, the server, and the port number and used the org.mariadb.jdbc.driver.
The current configuration is great except I am pretty sure communication between LO Base and the mariadb server is clear text including my password.
I am guessing the next step would be to follow the above mariadb link instruction and create a user with the “REQUIRE SSL” enabled in the mariadb configuration.
It starts to get a bit complex so I was wondering if there is some already created step by step instruction that works with LO Base and mariadb.
At least let me know if I am barking up the wrong tree. Many thanks!