I have a set of SQLite databases. I would like to open any one of them, specify a SELECT query, and analyze the results, but when I try to test or connect to the databases I get error:Unauthorized. I am using OpenRefine 3.8.2 on my Macintosh, and the attached image illustrates how I am trying to create the connection to a database file on my Desktop. I can't open a SQLite database.
Do you get a better or different error when you click on the Test button for the connection?
You might also look at running OpenRefine through your terminal on Mac, so that you get console logging and reply back with additional errors or a Java stacktrace that you see: OpenRefine User Manual - Installing - Logs
Other than that, with the error:Unauthorized, I think the error itself is coming perhaps from the Mac filesystem call, and perhaps that path to the Database file doesn't have the right permissions for read?
I tested with my test file on my Windows system and it works fine with OpenRefine 3.9.0-SNAPSHOT and 3.8.0 test.zip (517 Bytes)
@tfmorris While testing a few things for this reported issue, I did find an issue with our database access code. SQLite connections remain open and are not properly closed after use (so a SQLite file will remain locked on the filesystem and inaccessible; i.e. you can't move it or compress it, etc.).
On my two Macintosh computers -- one at home and one at work -- I am now able to create a new project by opening an SQLite database and submitting a query, but only after I launch OpenRefine from the terminal. When I launch OpenRefine from the Finder, I get the "unauthorized" error. Go figure.
Other than that, with the error:Unauthorized, I think the error
itself is coming perhaps from the Mac filesystem call, and
perhaps that path to the Database file doesn't have the right
permissions for read?
Doesn't have permission to read? That's possible.
Recently, say in the past year, it is not uncommon for me to download an application from the 'Net, launch it, and then try to open a file. When I do so, Mac OS often comes back with something like, "Do you want to give Application permission to read from the Desktop?" In this case, maybe OpenRefine needs to be authorized in some way by the Macintosh operating system.
