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

Vaclav Petras wenzeslaus at gmail.com
Wed Nov 19 10:12:08 PST 2014

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:
> 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

This probably have to go the C code.

Hope that helps,

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20141119/f7bf1c54/attachment.html>

More information about the grass-dev mailing list