Software·43,939 discussions

Linking MYSQL and Libre BASE with SSH

Tags: Networking

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.

Topic

While I have used MySQL many times.

In reply to Linking MYSQL and Libre BASE with SSH

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.

While I have used MySQL many times.

In reply to Linking MYSQL and Libre BASE with SSH

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.

[Author]

Replies