[GRASS-dev] How to calculate log() in v.db.update with SQLite backend?

[Vaclav Petras]

On Wed, Nov 19, 2014 at 12:59 PM, Markus Neteler <neteler at osgeo.org> wrote:

>
> DBMI-SQLite driver error:
> Error in sqlite3_step():
> not authorized
>
> ERROR: Error while executing: 'SELECT
>
>  load_extension('/home/neteler/software/sqlite_extensions/libsqlitefunctions.so')'
> Traceback (most recent call last):
> ...
> Process ended with non-zero return code 1. See errors in the (error)
> output.
>
> No idea what's disliked here in:
>
> SELECT
> load_extension('/home/neteler/software/sqlite_extensions/libsqlitefunctions.so');
> UPDATE meuse_voronoi SET logzinc=log(zinc);
>
> Any hints?


Loading user defined function is not considered completely safe, so it is
disabled by default. I think this is not an issue for GRASS GIS.

You have to enable it somehow. It seems that enable_load_extension() is the
way.

This probably have to go the C code.

Hope that helps,
Vaclav

https://www.sqlite.org/c3ref/load_extension.html
https://www.sqlite.org/c3ref/enable_load_extension.html
https://www.sqlite.org/loadext.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20141119/f7bf1c54/attachment.html>