.load fails

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

.load fails

Joop!
Dear Supoport,

*St**ep 1*: Check that the module pcre.so is available.

⋊> /m/f/U/OMT DB development ll
/usr/lib/sqlite3/                                                                                                                                                                                                                                                                                  
13:53:37
total 12K
-rw-r--r-- 1 root root 11K Feb 23  2010 *pcre.so*

*Step 2*: Start SQLite3 in the terminal an load the*module pcre.so*

⋊> /m/f/U/OMT DB development
sqlite3                                                                                                                                                                                                                                                                                               
13:54:00
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> *.load /usr/lib/sqlite3/pcre.so*
*Error: /usr/lib/sqlite3/pcre.so.so: cannot open shared object file: No
such file or directory*

Kind regards,

Peter Ketel

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: .load fails

Clemens Ladisch
Joop! wrote:
>sqlite> .load /usr/lib/sqlite3/pcre.so
>Error: /usr/lib/sqlite3/pcre.so.so: cannot open

sqlite3 always adds ".so".


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: .load fails

Richard Hipp-3
In reply to this post by Joop!
On 12/23/17, Joop! <[hidden email]> wrote:
> sqlite> *.load /usr/lib/sqlite3/pcre.so*
> *Error: /usr/lib/sqlite3/pcre.so.so: cannot open shared object file: No
> such file or directory*
>

What error message do you get if you omit the ".so" at the end of the
shared library name?
--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: .load fails

Richard Hipp-3
On 12/23/17, Richard Hipp <[hidden email]> wrote:
> On 12/23/17, Joop! <[hidden email]> wrote:
>> sqlite> *.load /usr/lib/sqlite3/pcre.so*
>> *Error: /usr/lib/sqlite3/pcre.so.so: cannot open shared object file: No
>> such file or directory*
>>
>
> What error message do you get if you omit the ".so" at the end of the
> shared library name?

Or, apply this patch
(https://www.sqlite.org/src/info/05fee1a21ea398f1) to get a better
error message regardless of whether or not you include the ".so" file
suffix.

--
D. Richard Hipp
[hidden email]
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users