In the file you have downloaded, there is the following statement:
Note: You cannot use these functions from the sqlite3 program, you
must write your own program using the sqlite3 API, and call
sqlite3_enable_load_extension. See "Security Considerations" in
http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions.
When I try your load from the command line, I get a similar
(but not the same) error.
sqlite> SELECT load_extension('./libsqlitefunctions.so');
SQL error: ./libsqlitefunctions.so: undefined symbol: sqrt
and I certainly have a sqrt function and use these extensions
without problems. So I guess it's a symptom of the security feature
in sqlite that prohibits loading extensions.
On the chance that log is not defined for your environment.
I recommend you change the line
#define HAVE_LOG10 1
to
#define HAVE_LOG10 0
and try again.
Liam
On Thu, Jun 12, 2008 at 8:26 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote:
> В сообщении от Friday 06 June 2008 03:51:38 P Kishor написал(а):
>> http://sqlite.org/contrib/download/extension-functions.c?get=22
>
> $ wget http://sqlite.org/contrib/download/extension-functions.c?get=22
> $ mv extension-functions.c?get=22 extension-functions.c
> $ gcc -fPIC -shared extension-functions.c -o libsqlitefunctions.so
> $ sqlite3 :memory:
> SQLite version 3.5.9
> Enter ".help" for instructions
> sqlite> SELECT load_extension('./libsqlitefunctions.so');
> SQL error: ./libsqlitefunctions.so: undefined symbol: log
>
> What can I do?
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
