LibreOffice Base to Mariadb connection

[hnimmo]

I am connecting LibreOffice (Version 6) Base to a remote Mariadb (V10).

However it seems that I can only make the connection if the package libreoffice-base-drivers-mysql (6.0.5.2) is installed.
This means that I am unable to install the latest version of Libreoffice (6.1.3.2) without making the connection impossible.

Does anyone know how to connect LibreOffice 6.1.3.2 Base with a remote Mariadb (v10) without using the libreoffice-base-drivers-mysql package?

[tsu2]

I am connecting LibreOffice (Version 6) Base to a remote Mariadb (V10).

However it seems that I can only make the connection if the package libreoffice-base-drivers-mysql (6.0.5.2) is installed.
This means that I am unable to install the latest version of Libreoffice (6.1.3.2) without making the connection impossible.

Does anyone know how to connect LibreOffice 6.1.3.2 Base with a remote Mariadb (v10) without using the libreoffice-base-drivers-mysql package?

I don't understand why you would want to connect Base to a mariadb without using the libreoffice-base-drivers-mysql package.

TSU

[hnimmo]

I don't understand why you would want to connect Base to a mariadb without using the libreoffice-base-drivers-mysql package.

TSU

The only reason is that I am obliged to deinstall LO 6.1.3.2 in order to install the version of LO that is compatible with the available libreoffice-base-drivers-mysql package.

When I get software notifications that new packages (including LO) are available, I am obliged to remember not to install the LO package updates. Since I am not using LO Base/Mysql very often, I spent a couple of hours the other day trying to figure out why my database connection was broken before I could use it. The reason was that I had taken a string of LO updates over time not realising that there was an incompatibility between the available libreoffice-base-drivers-mysql and the current LO packages.

It's not a monster issue, just a bit of a nuisance.

[gogalthorp]

Not sure I understand the problem but you can lock any package you don't want to have updated in Yast-Software management Just right click and select "Protect"

[hnimmo]

Not sure I understand the problem but you can lock any package you don't want to have updated in Yast-Software management Just right click and select "Protect"

You are right. I could protect myself from LO updates, but LO-updates are always welcome

[Knurpht]

Looks like the driver-mysql package no longer gets built by default, it's absent in Tumbleweed. You could ask the maintainer to enable the build for newer versions.

[hnimmo]

Looks like the driver-mysql package no longer gets built by default, it's absent in Tumbleweed. You could ask the maintainer to enable the build for newer versions.

That sounds helpful. How do I make such a request?

[tsu2]

If you can wait for the drivers package to be updated, I recommend you do so.

Else,
You can go "old school" before native drivers were available.

The old way...
The procedure
https://wiki.openoffice.org/wiki/Connect_MySQL_and_Base

Note that the JDBC connector is recommended, the ODBC connector is an alternative that might also work.

TSU

[tsu2]

That sounds helpful. How do I make such a request?

Submit to https://bugzilla.opensuse.org with a "Feature Request" priority.

Edit - Although requesting a package upgrade should normally be a Feature Request,
In this case, I might consider that the importance of this package might warrant at least a "normal" priority.

TSU

[hnimmo]

Submit to https://bugzilla.opensuse.org with a "Feature Request" priority.

Edit - Although requesting a package upgrade should normally be a Feature Request,
In this case, I might consider that the importance of this package might warrant at least a "normal" priority.

TSU

Bug 1119104 submitted.