Mysql Native Connector for LO 5.4

users
#1

Hello,
I have been using LO-Base with all the available connectors to MySQL databases for years
(as a relatively happy customer!). Now I am having trouble using JDBC in my client-server
environment together with LO 5.4.1. Is there a native connector (64-bit, Linux-Mint 18.2)?
Thanks for the good work and regards from Salzburg
H. Stoellinger

#2

Hi H. Stoellinger,

you could try this one:
https://extensions.libreoffice.org/extensions/mysql-native-connector

Works here with LO 5.4.1.2 on OpenSUSE.

Regards

Robert

#3

Greetings,
For what it's worth, I am using 32-bit Linux LO 5.3.4.2 with the Oracle mysql-connector-java 5.1.42 driver and mariadb 10.0.30 and it works fine. Mariadb has their own connector-java driver, but since I have something that works, I have not bothered to investigate it. The so-called LO "native" driver has been promised for years and as far as I can tell, it is still a myth.

HTH.
Girvin Herr

#4

Hi Heinrich,

environment together with LO 5.4.1. Is there a native connector (64-bit,
Linux-Mint 18.2)?

The distro provided version of the native connector for Linux Mint 18.2
only works with 5.1.6.x I believe ?

Of course, there is no native connector for any of the snap/PPA versions
of LibreOffice nor I suppose for the 5.4.x version of LibreOffice from
the TDF download site. The only place to find such a native connector
would be the extensions website...

Alex

#5

Hello,
Thanks for your answers! I have found and solved my problem...
When I installed Debian 9, MariaDB was automatically instaalled. It seems that the structure of
the confg-files has changed between MySQL 5.5 and MariaDB 10. The new config-file specified
localhost for the bind-address parameter. Changing it such that the server also listens to "normal"
TCP-IP connections has done the trick.
I will keep on using JDBC till a viable native connector becomes available.
Regards
H. Stoellinger