Description: ODBC driver installations for some commonly notarized packages, e.g. mysql ODBC connector, generally occur in /usr/local on a macOS system. Using LO VANILLA Version : 6.4.3.5 Build ID : 4db9852e73d9e9d662fc8a2783bace79addf1805 Threads CPU : 8; OS : Mac OS X 10.15.4; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded When attempting to create an ODBC-based access to a database, e.g. mysql/mariadb server, using the wizard, or when attempting to access a previously created ODBC-driver connected ODB file, an error of the following is produced : Impossible d'établir la connexion à la source de données « myDSN ». Statut SQL: 00000 [iODBC][Driver Manager]dlopen(/usr/local/mysql-connector-odbc-8.0.20-macos10.15-x86-64bit/lib/libmyodbc8w.so, 6): no suitable image found. Did find: file system sandbox blocked open() of '/usr/local/mysql-connector-odbc-8.0.20-macos10.15-x86-64bit/lib/l The whole setup/access thing appears to work well, however, with TDF Version: 7.0.0.0.alpha1 Build ID: 6a03b2a54143a9bc0c6d4c7f1... CPU threads: 8; OS: Mac OS X 10.15.4; UI render: default; VCL: osx; Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded It also works correctly in : TDF Version : 6.4.3.2 Build ID : 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 Threads CPU : 8; OS : Mac OS X 10.15.4; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded Steps to Reproduce: See above. The minimum requirement is to have a validly defined ODBC DSN, and correspondingly configured ODBC driver, with a datasource accessible via the ODBC driver, in order to test the ODB creation wizard. Actual Results: ODBC access fails from LO Vanilla to a driver located outside the sandboxed app. Expected Results: LO Vanilla should be able to access a datasource via an ODBC driver. Reproducible: Always User Profile Reset: No Additional Info: LO VANILLA Version : 6.4.3.5 Build ID : 4db9852e73d9e9d662fc8a2783bace79addf1805 Threads CPU : 8; OS : Mac OS X 10.15.4; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded
But ... LibO Vanilla *cannot* make use of any database functions, isn't that the case? See bug #101956 https://bugs.documentfoundation.org/show_bug.cgi?id=101956 See also this Q&A from AskLibO: https://ask.libreoffice.org/en/question/201635/libreoffice-requires-oracles-jdk-on-mac-os-x/ So long as Vanilla LibO must omit support for Java, this will be the case — or am I missing something obvious? https://wiki.documentfoundation.org/LibreOffice_Vanilla_for_Mac#Limitations
(In reply to David from comment #1) > But ... LibO Vanilla *cannot* make use of any database functions, isn't that > the case? See bug #101956 > No, LibreOffice Vanilla does not make use of any functions that require Java functionality. Database functionality with other DB engines that don't require any JVM are supposed to function, including any ODBC access.
> Database functionality with other DB engines that don't require any JVM are > supposed to function, including any ODBC access. Interesting, and thanks for reply. I use LibO on both Linux and Mac (usually Vanilla, in latter case) and have never been able to use any db functions of any kind on Mac, long a source of dismay. I'll follow progress of this bug with interest!
Clearly, no one is interested in even looking at this to confirm, let alone fixing it.
There, now it's set to NEW.
See also https://bugs.documentfoundation.org/show_bug.cgi?id=138990#c9
Also reproducible with LibreOffice from macOS appstore: Version: 7.3.6.2 / LibreOffice Community Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
This bug is still reproducible with Version: 7.4.3.2 / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded [iODBC][Driver Manager]dlopen(/usr/local/mysql-connector-odbc-8.0.31-macos12-arm64/lib/libmyodbc8w.so, 0x0006): tried: '/usr/local/mysql-connector-odbc-8.0.31-macos12-arm64/lib/libmyodbc8w.so' (file system sandbox blocked open()), '/System/Volumes/Preboot