Software

Question

Linking MYSQL and Libre BASE with SSH

By BigIslandDigger ·
On a Ubuntu server (and for clients) I am using Libre BASE as the GUI and will have many clients using this GUI to link into a MYSQL database which will store the data, forms, reports, etc. Clients are using Ubuntu and MYSQL server is hosted on Ubuntu server.

I want to use a SSH tunnel to link the Libre BASE program client to the MYSQL server, over the internet eventually but at first I will use localhost to get to it working to prove its viable.

Does anyone know of someone who has done this linkage using SSH?

The 'built in' linkage choices, which originate from Libre BASE, are ODBC and JDBC, but we'd prefer SSH for its more robust and 'generic' security.
Thread display: Collapse - | Expand +

All Answers

Collapse -

While I have used MySQL many times.

by rproffitt Moderator In reply to Linking MYSQL and Libre B ...

Not in this setup. I suggest you try the Libre Office forums after you try the next two suggestions.

1. https://www.techrepublic.com/article/how-to-connect-libreoffice-base-to-a-remote-mysql-database/
2. https://ask.libreoffice.org/t/connection-to-mysql-via-ssh-tunnel/59057/5

Item 2 notes what I recall. That is, the tunnel is not done in your Libre Office system. You do that outside of Libre. For that I'd use Ubuntu network forums.

Related Discussions

Related Forums