Trying to connect a mySQL database to LibreOffice BASE with the native connector, two approaches failed: 1. Connector for "Versions > 4.1, Extension for Linux" from http://extensions.libreoffice.org/extension-center/mysql-native-connector". Latest while opening the database the second time, an error message "Unable to load the libmysqlcppconn.so library / SQL-Status 08001" is shown. The file "libmysqlcppconn.so.7.1.1.7" is existing on my computer in /usr/lib/. 2. As an alternative, I installed the "mySQL-Connector extension for LibreOffice" libreoffice-mysql-connector 1.0.2+LibO5.1.2-0u as shown in the repository. This results into a complete crash of LibreOffice while connecting. It's possible to connect the same mySQL / BASE - system using the JDBC-connector.
Michael : 1) did you remove the Extension site connector completely before trying to use the one provided by the distro ? 2) the Extensions site connector was built against a different version of libmysqlcppconn than the one provided by Ubuntu 16.04. As the connector builds are version specific for this library, it is not surprising that it failed to work correctly. 3) If, after thoroughly removing the Extension site connector and installing the distrib provided connector it still doesn't work (crash/error message, etc) then you should report that problem to Ubuntu. Setting to NEEDINFO, but if it turns out that the problem is distro specific then this will become NOTOURBUG
Alex: thanks for replying. (In reply to Alex Thurgood from comment #1) > 1) did you remove the Extension site connector completely before trying to > use the one provided by the distro ? Yes, it has been deleted first, not only de-activated. > 2) the Extensions site connector was built against a different version of > libmysqlcppconn than the one provided by Ubuntu 16.04. As the connector > builds are version specific for this library, it is not surprising that it > failed to work correctly. OK, but I did not find any more actual native connector; do you have a proposal? The one from the distro is version 1.0.2+LibO5.1.2-0ubuntu1, crashes completely. The downloaded one is newer version 1.0.4_3 looses connection with second access. > 3) If, after thoroughly removing the Extension site connector and installing > the distrib provided connector it still doesn't work (crash/error message, > etc) then you should report that problem to Ubuntu. There is a bug, ref. https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1577316 I can't log-in ther to participate. Thanks and regards Michael
Michael : the Ubuntu launchpad bug report indicates that an update to the latest version of LO 5.1.3 fixes the crashing issue when using the mysql connector extenion. This would not appear to be a TDF LO bug, but a distrib specific bug. Closing this report as NOTOURBUG.