Unauthorized to open sqlite database

thadguidry · October 23, 2024, 1:35am

Yes, we are aware of the unnotarized application warning, and this should be eventually fixed. You can track the issue

OpenRefine 3.8.2 Mac Application Not Notarized Correctly

opened 11:27PM - 09 Jul 24 UTC

Type: Bug Platform: macOS packaging

Hi: Thanks for developing and making OpenRefine available to the community. … There is an OpenRefine 3.8.2 Mac application that is not notarized correctly. The app or component was signed with an Apple-issued Developer ID certificate but does not appear to be notarized. Since the exceptions described above for the Developer ID status are not met, macOS will not allow this code to run (unless it is found to be notarized when Gatekeeper runs). To verify if a Mac application is notarized, you can use the spctl command in Terminal. Here is the command: ``` spctl -a -v /path/to/application.app ``` For example, executing the command with OpenRefine 3.8.2 outputs... ``` spctl -a -v /Volumes/OpenRefine/OpenRefine.app /Volumes/OpenRefine/OpenRefine.app: rejected source=Unnotarized Developer ID ``` Additional context Here is some interesting general information to checkout and share with your macOS developer on resolving Gatekeeper problems on macOS. Resolving Gatekeeper Problems | Apple Developer Forums: The post titled "Resolving Gatekeeper Problems" on the Apple Developer Forums, written by Quinn "The Eskimo!" from Developer Technical Support at Apple is a comprehensive guide addressing common issues related to Gatekeeper on macOS. Gatekeeper is a security feature designed to ensure that only trusted software runs on a user's Mac, and the post focuses on helping developers troubleshoot and resolve issues that may arise in this context. The post identifies four common Gatekeeper problems that developers may encounter: App blocked by a dangling load command path. Broken code signature. Lack of notarization. Command-line tool blocked by Gatekeeper. For each of these issues, the post provides detailed steps and guidance on how developers can resolve them. The emphasis is on the importance of passing Gatekeeper checks to maintain customer trust and avoid potential loss of customers. Key points covered in the post include: • Verification of Code Signature: Developers are advised to use the codesign tool to verify that their code is signed correctly. The post provides examples of command-line usage to check for issues such as missing or invalid sealed resources. • Notarization Issues: Gatekeeper requires that apps be notarized, and the post guides developers on how to identify and resolve notarization problems. It includes information on checking system logs for specific entries related to notarization issues. • Hash Mismatch: In cases where there's a hash mismatch, the post provides guidance based on the file type (e.g., zip archive, signed disk image, installer package) and recommends specific actions to address the problem. • Command-line Tool Blocking Bug: A known bug in macOS is acknowledged, where double-clicking a command-line tool in Finder may lead to it being blocked by Gatekeeper. Workarounds, such as embedding the tool in an application or using an installer package, are suggested. Throughout the post, there are references to Apple's documentation and resources related to code signing and notarization, providing developers with additional information for a deeper understanding. https://forums.developer.apple.com/forums/thread/706379

Additional context from other users recently:

Topic		Replies	Views
I am receiving a error:Unauthorized message when trying to test and connect to a SQLite database file Support and Helpdesk	7	77	December 10, 2024
Unauthorized to open MySQL database Support and Helpdesk	3	46	November 26, 2024
Problem opening a file Support and Helpdesk	2	280	December 7, 2022
After adding rows and editing a cell, project failing to load Support and Helpdesk	12	103	April 18, 2025
Installing OpenRefien on MacOs Ventura Support and Helpdesk	2	248	September 9, 2024

Unauthorized to open sqlite database

Related topics