Announcement

Collapse
No announcement yet.

SQLite load extension

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLite load extension

    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

  • #2
    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.

    Comment


    • #3
      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.

      Comment


      • #4
        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

        Comment


        • #5
          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

          Comment


          • #6
            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


            • #7
              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

              Comment


              • #8
                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

                Comment


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

                  Comment


                  • #10
                    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.

                    Comment

                    Working...
                    X