[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon - need to specify full path to libiodbc/libiodbcinst dylibs for signed app
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Julien Nabet changed: What|Removed |Added CC||cl...@documentfoundation.or ||g --- Comment #14 from Julien Nabet --- Christian: thought you might be interested in this one since it concerns macOS signing part (see https://bugs.documentfoundation.org/show_bug.cgi?id=138990#c6). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon - need to specify full path to libiodbc/libiodbcinst dylibs for signed app
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #13 from Alex Thurgood --- Also present in version 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon - need to specify full path to libiodbc/libiodbcinst dylibs for signed app
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Sierk Bornemann changed: What|Removed |Added Blocks||42082 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=42082 [Bug 42082] [META] Make LibreOffice shine and glow on macOS -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon - need to specify full path to libiodbc/libiodbcinst dylibs for signed app
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #12 from faulknernolan --- This is a challenging and competitive game. Fall Guys is a multiplayer racing game that can have up to 60 players per match. You must overcome several hurdles to reach the finish line and be the last lucky survivor. https://fallguys.onl -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon - need to specify full path to libiodbc/libiodbcinst dylibs for signed app
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #11 from Alex Thurgood --- Bug also present in Version: 7.3.0.1 / LibreOffice Community Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d CPU threads: 8; OS: Mac OS X 12.1; UI render: Skia/Metal; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded LibreOffice for Apple Arm M1 aarch_64 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon - need to specify full path to libiodbc/libiodbcinst dylibs for signed app
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #10 from Alex Thurgood --- Bug still present on Version: 7.2.5.2 / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 8; OS: Mac OS X 12.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon - need to specify full path to libiodbc/libiodbcinst dylibs for signed app
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Alex Thurgood changed: What|Removed |Added Summary|ODBC - LO, LO Vanilla, |ODBC - LO, LO Vanilla, |Collabora Office fail to|Collabora Office fail to |retrieve ODBC datasources |retrieve ODBC datasources |on M1 Apple Silicon |on M1 Apple Silicon - need ||to specify full path to ||libiodbc/libiodbcinst ||dylibs for signed app ||bundle -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #9 from Alex Thurgood --- Further exchange with ActualTechnologies support : LibreOffice has chosen to use the dlopen() call to load the libiodbc.dylib (without specifying a path to the library). You are correct that Apple used to include libiodbc.dylib in the /usr/lib directory, but no longer does so. One limitation of the dlopen() function is that its behavior depends on whether the application (LibreOffice) is signed or not. From the dlopen() man page: > Note: If the main executable is a set[ug]id binary or codesigned with > entitlements, then all environment variables are ignored, and only a full > path can be used. When the app is unsigned, dlopen() will by default look in both /usr/lib and /usr/local/lib for the library. If the app is signed, it will only look in /usr/lib - the only place that securely contains libraries provided by Apple. The long term solution would be for LibreOffice to modify the call to dlopen() so that it specifies a full path to /usr/local/lib/libiodbc.dylib, and gracefully handles the condition when that library is not present. ODBC providers like ActualTech can then install libiodbc.dylib in the /usr/local/lib directory without any problems (we can't install anything in /usr/lib because of the "System Integrity Protection" (SIP) process). Our workaround for now for customers who need ODBC in LibreOffice is to install libiodbc.dylib (and its companion libiodbcinst.dylib) in /usr/local/lib, and remove the code signing from LibreOffice. We only offer this when customers request a solution. If you are not comfortable with the workaround, then you should definitely not do it. I personally believe the risk is low (much less risky than disabling SIP, for example), but I don't blame anyone for being cautious in today's world. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #8 from Alex Thurgood --- I'm actually wondering whether the "bug" referred to by ActualTechnologies isn't actually due to Apple's shift to stub libraries in the library cache : https://developer.apple.com/forums/thread/655588 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #7 from Stephan Bergmann --- (In reply to Julien Nabet from comment #5) > (In reply to Alex Thurgood from comment #4) > > (In reply to Julien Nabet from comment #3) > > > > > > > Does it correspond to what you installed? > > > > Surely that would only be true if the LO app bundle was built specifically > > for M1? > > > > > > The actual release of LO is x86_64 so should work with x86_64 components > > under Rosetta ? > > I'm adding Stephan in cc just to be sure but I suppose you must be right. Yes, apparently in a process all binary code must be either x86-64 (executed via Rosetta) or Aarch64 (executed natively). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #6 from Alex Thurgood --- I've been exchanging with ActualTechnologies (ODBC driver for macOS) on this. Their take on this is that it is a bug with BigSur: "After an in-depth investigation, we have discovered that Big Sur has a bug that causes LibreOffice to fail to load the ODBC libraries. The work around is to remove the "code signing" from the LibreOffice application, which will allow it to load the libraries on Big Sur. "Code signing" is an important part of an application when it is first installed, which ensures that the application was downloaded from a reputable source. However, once the LibreOffice application has been successfully installed, the "code signing" can be safely removed since it doesn't serve a purpose at that point. We have created a simple utility that will remove the code signing from your installed LibreOffice application, which will allow you to use ODBC. Please download and launch the "LibreOffice Unsigner" available from our website: http://www.actualtech.com/downloads/libreoffice_unsigner.dmg Once you have completed the installation, restart LibreOffice. You should then be able to use ODBC data sources. Please let me know if you have any questions or encounter any issues." -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Julien Nabet changed: What|Removed |Added CC||sberg...@redhat.com --- Comment #5 from Julien Nabet --- (In reply to Alex Thurgood from comment #4) > (In reply to Julien Nabet from comment #3) > > > > Does it correspond to what you installed? > > Surely that would only be true if the LO app bundle was built specifically > for M1? > > > The actual release of LO is x86_64 so should work with x86_64 components > under Rosetta ? I'm adding Stephan in cc just to be sure but I suppose you must be right. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #4 from Alex Thurgood --- (In reply to Julien Nabet from comment #3) > Does it correspond to what you installed? Surely that would only be true if the LO app bundle was built specifically for M1? The actual release of LO is x86_64 so should work with x86_64 components under Rosetta ? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #3 from Julien Nabet --- Alex: searching about your error message, I saw this: https://blog.devart.com/iodbc-driver-manager-for-apple-silicon-m1.html "...ODBC drivers for Mac require the iODBC driver manager, but it appears that the current version only supports the x64-86 Intel architecture. After seeing numerous complaints about using ODBC drivers from users of the new Macs, we decided to build iODBC for the x64-86 and arm64 architectures from the source code of v.3.52.14 and share it with the ODBC community...". Does it correspond to what you installed? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 --- Comment #2 from Alex Thurgood --- Problem still present with Version: 7.1.2.2 / LibreOffice Community Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4 CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Aron Budea changed: What|Removed |Added CC||t...@iki.fi Whiteboard| QA:needsComment| Keywords||notBibisectable -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Alex Thurgood changed: What|Removed |Added Whiteboard| QA:needsComment| --- Comment #1 from Alex Thurgood --- Give that I'm already a member of LO-QA, I think we can remove the QA:needscomment tag. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Alex Thurgood changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||3056 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Alex Thurgood changed: What|Removed |Added Priority|medium |high Severity|normal |major Keywords||regression -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138990] ODBC - LO, LO Vanilla, Collabora Office fail to retrieve ODBC datasources on M1 Apple Silicon
https://bugs.documentfoundation.org/show_bug.cgi?id=138990 Alex Thurgood changed: What|Removed |Added Summary|ODBC - LO, LO Vanilla, |ODBC - LO, LO Vanilla, |Collabora Office fail to|Collabora Office fail to |retrieve ODBC datasources |retrieve ODBC datasources ||on M1 Apple Silicon -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs