SQLite load extension

[navicat]

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

[mayho]

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.

[momofarm]

I have similar issue, and try the above solution but with no luck.

It still respond a "not authorised" error to me, and the plist file seems like will be rewritten everytime I open it.

[mayho]

Could you please provide the following information?
1. Your Navicat version number? e.g. 11.0.16
2. Your OS version, e.g. Mac OS X 10.9

[momofarm]

1. Your Navicat version number? e.g. 11.0.16

version 11.0.16 essential

2. Your OS version, e.g. Mac OS X 10.9
10.9.2


thank you

[mayho]

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

[Peter Lavache]

I'm having this problem now with 11.2.14 on macos 10.12.1

I tried the commands without luck and then I went to edit the plist file and I wasn't seeing any of what was stated above.

Any help would be appreciated

Thanks

[mayho]

Hi Peter,

For Navicat for SQLite App Store version, please run:

defaults write ~/Library/Containers/com.prect.NavicatSQLite/Data/Library/Preferences/com.prect.NavicatSQLite.plist sqliteLoadExtension -bool YES

[programuotojasgf]

How to load extensions in windows (windows 10 if it makes a difference) ?

[mayho]

We are sorry that Navicat Windows and Linux version do not support your mentioned feature. Your request has been forwarded to our development team. Thanks for your advice.