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

[Moritz Lennert]

On 19/11/14 19:12, Vaclav Petras wrote:
>
> On Wed, Nov 19, 2014 at 12:59 PM, Markus Neteler <neteler at osgeo.org
> <mailto: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.

Right.

But this depends on the installation, i.e. how sqlite3 was compiled. 
Here in Debian Testing I do not need to activate anything, so I assume 
that it's activated by default.

Moritz