My OS is Mac OS X 10.8. I tried to execute query SELECT load_extension(‘tes.dylib’); to load a SQLite extension. It failed, Error: not authorised
Announcement
Collapse
No announcement yet.
SQLite load extension
Collapse
X
-
You can set the sqliteLoadExtension boolean to YES in
Navicat for SQLite - ~/Library/Preferences/com.prect.NavicatSQLite.plist
** ~/Library is a hidden folder in Mac OS X 10.7 or above.
1. Open the plist file
2. Expand and select the entry "Root" , click "Add Row".
3. Under "Key" column, type in the key name "sqliteLoadExtension" (exclude the double quotes). Under "Type" column, select "Boolean" and set to YES.
4. Save the file.
5. Start Navicat and then try again.
-
For Mac OS X 10.9, please run command in Terminal to edit the plist file:
If you use Navicat Essentials for SQLite, please run:
defaults write ~/Library/Preferences/com.prect.NavicatEssentialsForSQLite.plist sqliteLoadExtension -bool YES
If you use Navicat Premium Essentials, please run:
defaults write ~/Library/Preferences/com.prect.NavicatPremiumEssentials.plist sqliteLoadExtension -bool YES
Comment
Comment