Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-406

EXCEL iODBC Sandbox problem

Details

    Description

      COMMENT today!
      Please help! Excel is a sandboxed program & I need to import iODBC data! Tried all solutions, won't work. Also affects OpenSSL 1.1.
      RUNNING Excel for Mac (365)
      On mac os 12 (montrey) (since this MacBook can't run MacOS 13 or 14)
      Error on Excel:
      {{[iODBC][Driver Manager]dlopen(/Library/MariaDB/MariaDB-Connector-ODBC/libmaodbc.dylib, 0x0006): Library not loaded: '/usr/local/opt/openssl@1.1/lib/libssl.1.1.dylib'
      Referenced from: '/Library/MariaDB/MariaDB-Connector-ODBC/libmaodbc.dylib'
      Reason: tried: '/usr/local/opt/openssl@1.1/lib/libssl.1.1.dylib' (file system sandbox blocked open()), '/usr/local/lib/libssl.1.1.dylib' (no such file), '/usr/lib/libssl.1.1.dylib' (no such file)}}
      Note the curly brackets are issue, not included with the source error

      Attachments

        Issue Links

          is part of

          Bug - A problem which impairs or prevents the functions of the product. ODBC-227 MariaDB ODBC connector does not load in macOS Excel 2019

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            Lawrin Lawrin Novitsky added a comment -

            Thank you for your report.
            Is the file physically there? /usr/local/lib/libssl.1.1.dylib I mean. Because it says "No such file"
            This is openssl library that is used for encryption. Due to licensing issues we cannot bundle and distribute it. You can install it using Homebrew.
            I am not completely sure if that helps with sandbox, though.

            Lawrin Lawrin Novitsky added a comment - Thank you for your report. Is the file physically there? /usr/local/lib/libssl.1.1.dylib I mean. Because it says "No such file" This is openssl library that is used for encryption. Due to licensing issues we cannot bundle and distribute it. You can install it using Homebrew. I am not completely sure if that helps with sandbox, though.
            aldenian Alden Graham added a comment -

            I copied the dylib file. Same thing. Need solution

            aldenian Alden Graham added a comment - I copied the dylib file. Same thing. Need solution
            Lawrin Lawrin Novitsky added a comment -

            Do you mean that you've installed openssl and /usr/local/opt/openssl@1.1/lib/libssl.1.1.dylib is in place now?

            Lawrin Lawrin Novitsky added a comment - Do you mean that you've installed openssl and /usr/local/opt/openssl@1.1/lib/libssl.1.1.dylib is in place now?

            People

              Lawrin Lawrin Novitsky
              aldenian Alden Graham
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.