Description: Trying to load an ODB file into LO Vanilla. Open ODB file that is configured to connect to a mysql instance over the native mysql connector. The main ODB window opens, and the ID/pwd is requested. Enter the required connection IDs. Error message displayed: Impossible d'établir la connexion à la source de données « mydbconnection ». Statut SQL: HY000 Impossible d'établir une connexion à la source de données externe. Aucun pilote SDBC n'a été trouvé pour l'URL 'sdbc:mysql:mysqlc:127.0.0.1:3306/mydb'. Une connexion pour l'URL suivant était requise « sdbc:mysql:mysqlc:127.0.0.1:3306/mydb ». Steps to Reproduce: See above Actual Results: No connection to data source is made within ODB file. Expected Results: The datasource should be loaded, and MetaData retrieved to allow display of the tables. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.3.2 Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded
Given the response in bug 138946, LO Vanilla deliberately doesn't integrate all of the code to support the mysql native connector, which means that the behaviour reported is not a bug. As direct mysql/mariadb access is our daily necessity at work, I have no need for a version of LO that doesn't support such an access.
Setting to RFE then.
*** Bug 141830 has been marked as a duplicate of this bug. ***
I don't know where the various restrictions are coming from, but perhaps it's worth thinking about what's needed so an LO version in the Mac app store can have working database support.
Still reproducible in Version: 7.2.0.4 / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Mac OS X 11.5.2; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
AFAIR the Mysql connector library is not helpfully licensed, and so not compiled in. connectivity/source/drivers/mysqlc/mysqlc_general.h: #include <config_lgpl.h> I forget what we did to try to address that; it's possible that the code was re-written to target the mariadb C library directly but ... Lionel or Tomi would know I expect.
@Michael : my understanding was that the mariadb connector library was built by default these days, at least on Linux and Windows. I've decided to mark this as a bug, rather than a RFE. If LibreOffice Vanilla/Community installed through the app store is going to bear the same name as the TDF version, should it not at least offer the same functionality? All of the links on the About dialog point to LibreOffice.org website pages. This means that the user of LibreOffice Vanilla thinks that this product is the same as the LibreOffice product available for download from the LibreOffice project download page. Clearly, as this bug report shows, that is not the case. If there is a distinction to be made in LO-Vanilla over LO-TDF, due to it being provided by Collabora, then perhaps the About dialog should be amended here too to point out those differences.
(In reply to Michael Meeks from comment #6) > AFAIR the Mysql connector library is not helpfully licensed, and so not > compiled in. > > connectivity/source/drivers/mysqlc/mysqlc_general.h: > > #include <config_lgpl.h> > > I forget what we did to try to address that; it's possible that the code was > re-written to target the mariadb C library directly Yes, it was. So we switched from dependency on a GPL (+ exceptions) library (the MySQL C++ connector) to a dependency on an LGPL library only (the MariaDB C library). Is LGPL not allowed in the Collabora builds?
Dear Alex Thurgood, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Bug present (same error message) in Collabora Productivity Version: 23.05.6.3 (AARCH64) Build ID: 93b0363b27a67dae4836d417bb53178ef4e11344 CPU threads: 8; OS: Mac OS X 14.1.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
Bug not present in Version: 7.5.9.2 (AARCH64) / LibreOffice Community Build ID: cdeefe45c17511d326101eed8008ac4092f278a9 CPU threads: 8; OS: Mac OS X 14.1.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded