Secure connection (TLS?) between mariadb and LO Base

[Davash]

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:

Using TLS/SSL with MariaDB Connector/J

I am currently using “org.mariadb.jdbc.Driver” to connect LO Base version 7.1.3.2 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!

[Ratslinger]

Hello,

This may be of some help although it is for SSL on MySQL.

LibreOffice 6.x Base MySql connection using JDBC and SSL

[Longi]

Índice

It is a Wizard extension to create a new Mariadb database from the Base frontend

[Davash]

Thanks for the comments so far. The wizard looks very useful and something that would ideally be rolled into Libreoffice in the future but doesn’t address setting up a TLS connection.

The 6.x SSL connection or MySQL looks potentially helpful. When I get a chance and have a few hours to spare and report back.