SQLite Forum

LOAD_EXTENSION: Error: error during initialization:

LOAD_EXTENSION: Error: error during initialization:

(1) By 6kEs4Majrd on 2021-07-10 23:08:17 [link] [source]


I downloaded regexp.c from above, and compileded it like this on macOS.

gcc -I /usr/local/opt/sqlite/include -fPIC -dynamiclib /tmp/regexp.c -o /usr/local/opt/sqlite/lib/regexp.dylib

Then I got the following error when I try to load it in an sqlite3 session. Does anybody know how to load it properly?

$ LD_LIBRARY_PATH=/usr/local/opt/sqlite/lib sqlite3
SQLite version 3.36.0 2021-06-18 18:36:39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT LOAD_EXTENSION('regexp');
Error: error during initialization:

(2) By anonymous on 2021-07-11 16:24:36 in reply to 1 [source]

Do you have the same problem loading the extension using .load regexp.dylib? It's possible the load_extension() SQL function is disabled depending on the value of SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION.