[ODBC-406] EXCEL iODBC Sandbox problem Created: 2023-12-03  Updated: 2023-12-05

Status: Open
Project: MariaDB Connector/ODBC
Component/s: Documentation, General
Affects Version/s: 3.1.19
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Alden Graham Assignee: Lawrin Novitsky
Resolution: Unresolved Votes: 0
Labels: excel, iodbc, odbc, sandbox
Environment:

Intel Core i5
Mac OS Montrey

Issue Links:
PartOf
is part of ODBC-227 MariaDB ODBC connector does not load ... Open

 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

 Comments   
Comment by Lawrin Novitsky [ 2023-12-04 ]

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.

Comment by Alden Graham [ 2023-12-04 ]

I copied the dylib file. Same thing. Need solution

Comment by Lawrin Novitsky [ 2023-12-05 ]

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

Generated at Thu Feb 08 03:28:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.