New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Cannot run load data local infile query #245
Comments
Sequel Ace is sandboxed (required by the App Store) and cannot access files in your filesystem unless you manually give access to them. |
Ahh, perhaps we are not connecting with allow infile set to true? |
Yes, that is probably it. I'll take a look when I'm back at my computer in an hour or two. |
I think the question becomes if this is something we should allow only when a specific preference is enabled as opposed to always? It seems that allowing infile could be perhaps a minor security vulnerability? Perhaps in the connection settings we could let users enable certain things? Like infile support |
Reproduced.
On 5.7:
|
So we can enable I think the best option would be to use the very-recently-added Related note: I suck at UI in Xcode; if someone could add the required UI change, I could finish the PR to use the selected folder while connecting, and upgrade libmysqlclient. |
One very impressed user here. Kudos to all of you! |
We have a WIP PR for this but someone would need to tinker/finish it out before we'd merge it through |
Reopening until 2.2.0 is actually released |
Description
A query with "load data local infile" works as expected in Sequel Pro (build 5446) but in Sequel Ace I get "The used command is not allowed with this MySQL version". They use same DB, connection configuration etc.
Steps To Reproduce
Expected Behaviour
Data is loaded into table
ps_product_temp
Is Issue Present in Latest Beta?
Additionally tested in 2.1.4-beta1, build 2068
Additional Context
The text was updated successfully, but these errors were encountered: