[GRASS-dev] Fwd: [osgeo4w] #305: python/sqlite: "sqlite3-rtree-geometry-callback" not found in "C:\OSGeo4W\apps\Python27\DLLs\sqlite3.dll"

[Benjamin Ducke]

Windows goes by two rules (in this order, if I remember
correctly):

1. Pick up the DLL from the directory in which the
.exe that is linked against it resides.

2. Pick it up from the first directory that is one
of the system's executable directories (such as
C:\Windows\Win32), i.e. listed in the PATH env var.

There is no global directory for dynamic libraries,
such as "/usr/lib" on Linux, and no dedicated dyamic
linker path, such as "LD_LIBRARY_PATH", either.

Welcome to "DLL hell" ...

Ben

On 10/28/2012 09:04 PM, Markus Neteler wrote:
> Glynn, Soeren, all:
>
> any idea how GRASS 7 decides which sqlite3.dll to pick up?
>
> thanks
> Markus
>
>
> ---------- Forwarded message ----------
> From: OSGeo4W <trac_osgeo4w at osgeo.org>
> Date: Sun, Oct 28, 2012 at 6:03 PM
> Subject: Re: [osgeo4w] #305: python/sqlite:
> "sqlite3-rtree-geometry-callback" not found in
> "C:\OSGeo4W\apps\Python27\DLLs\sqlite3.dll"
> To:
> Cc: osgeo4w-trac at lists.osgeo.org
>
>
> #305: python/sqlite: "sqlite3-rtree-geometry-callback" not found in
> "C:\OSGeo4W\apps\Python27\DLLs\sqlite3.dll"
> ---------------------+------------------------------------------------------
> Reporter:  hellik    |       Owner:  brushtyler
>      Type:  defect    |      Status:  new
> Priority:  critical  |   Component:  Package
>   Version:  1.0       |    Keywords:  python,sqlite
> ---------------------+------------------------------------------------------
>
> Comment(by brushtyler):
>
> Replying to [comment:29 esseffe]:
>> Sorry, but I'm completely unable to understand why SpatiaLite is
>>   supposed to be anyway related to this topic.
>
>   spatialite is not related at all, as well as the sqlite3 in \bin (the one
>   I built).
>
>   I'm still writing that the problem is that grass7-dev uses the wrong
>   sqlite3.dll, the one shipped with python.
>
>   We have to choose if replace (or better remove) that DLL, otherwise the
>   grass7-dev code has to be changed to use the sqlite3.dll in \bin (passing
>   the full path to ctypes when loading the sqlite3.dll library).
>
>   I would prefer to remove the duplication.
>
>   AFAICS in the .vcprops files of the python source package, the
>   Python27\DLLs\sqlite3.dll is compiled using default settings (for that
>   reason it doesn't contain the sqlite3_rtree_geometry_callback function).
>
> --
> Ticket URL: <https://trac.osgeo.org/osgeo4w/ticket/305#comment:30>
> OSGeo4W <http://trac.osgeo.org/osgeo4w>
> OSGeo4W is the Windows installer and package environment for the OSGeo stack.
> _______________________________________________
> grass-dev mailing list
> grass-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-dev
>



-- 
Benjamin Ducke
{*} Geospatial Consultant
{*} GIS Developer

   benducke at fastmail.fm