[Libreoffice-bugs] [Bug 133056] New: ODBC : sandboxed LibreOffice Vanilla can not access system-installed ODBC driver

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133056

            Bug ID: 133056
           Summary: ODBC : sandboxed LibreOffice Vanilla can not access
                    system-installed ODBC driver
           Product: LibreOffice
           Version: 6.4.3.2 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: iplaw67 at tuta.io

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200515/e684bbb9/attachment-0001.htm>