[ELGIS] RE: GDAL python bindings and libspatialite
Adrian Bartel (AR)
bartelar at telkom.co.za
Wed Aug 24 05:04:58 EDT 2011
I haven't set up rpmbuild yet, but doesn't look like libspatialite
would build against the stock sqlite.
Just tried a regular build:
$ tar xfz libspatialite-2.4.0.tar.gz
$ cd libspatialite-2.4.0
$ ./configure --disable-static --disable-geocallbacks
-- snip --
checking sqlite3.h usability... yes
checking sqlite3.h presence... yes
checking for sqlite3.h... yes
checking sqlite3ext.h usability... no
checking sqlite3ext.h presence... no
checking for sqlite3ext.h... no
configure: error: cannot find sqlite3ext.h, bailing out
Adrian
-----Original Message-----
From: el-bounces at lists.osgeo.org [mailto:el-bounces at lists.osgeo.org]
On Behalf Of Adrian Bartel (AR)
Sent: 24 August 2011 09:47 AM
To: Hatzopoulos, Nikolaos; Mathieu Baudier
Cc: el at lists.osgeo.org
Subject: RE: [ELGIS] RE: GDAL python bindings and libspatialite
sqlite-3.5.9-2.el5.elgis would work, but that's from the elgis-plus
repo.
I haven't yet tried, but I suspect that libspatialite won't build
against the stock SL5 sqlite-3.3.6-5 - I tried compiling and linking a
simple C program using sqlite3_clear_bindings and it also failed.
Adrian
-----Original Message-----
From: el-bounces at lists.osgeo.org [mailto:el-bounces at lists.osgeo.org]
On Behalf Of Hatzopoulos, Nikolaos
Sent: 24 August 2011 09:30 AM
To: Mathieu Baudier
Cc: el at lists.osgeo.org
Subject: RE: [ELGIS] RE: GDAL python bindings and libspatialite
And I think actually you don't need sqlite-devel you need the sqlite
package from elgis repo
can you compile it against centos sqlite? or there are problems with
spatialite library?
--Nikos
________________________________________
From: el-bounces at lists.osgeo.org [el-bounces at lists.osgeo.org] on
behalf of Hatzopoulos, Nikolaos [hatzopou at chapman.edu]
Sent: Wednesday, August 24, 2011 12:09 AM
To: Mathieu Baudier
Cc: el at lists.osgeo.org
Subject: RE: [ELGIS] RE: GDAL python bindings and libspatialite
yum install sqlite-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons: mirror.stanford.edu
* base: centos.mirror.freedomvoice.com
* contrib: mirror.stanford.edu
* epel: mirror.hmc.edu
* extras: centos.hostrack.net
* updates: linux.mirrors.es.net
Setting up Install Process
Resolving Dependencies
There are unfinished transactions remaining. You might consider
running yum-complete-transaction first to finish them.
The program yum-complete-transaction is found in the yum-utils
package.
--> Running transaction check
---> Package sqlite-devel.i386 0:3.5.9-2.el5.elgis set to be updated
--> Processing Dependency: sqlite = 3.5.9-2.el5.elgis for package:
--> sqlite-devel
---> Package sqlite-devel.x86_64 0:3.5.9-2.el5.elgis set to be updated
--> Running transaction check
---> Package sqlite.i386 0:3.5.9-2.el5.elgis set to be updated Package
---> sqlite.x86_64 0:3.5.9-2.el5.elgis set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
======================================================================
==========
Package Arch Version Repository
Size
======================================================================
==========
Installing:
sqlite-devel i386 3.5.9-2.el5.elgis elgis-plus
84 k
Updating:
sqlite-devel x86_64 3.5.9-2.el5.elgis elgis-plus
84 k
Updating for dependencies:
sqlite i386 3.5.9-2.el5.elgis elgis-plus
231 k
sqlite x86_64 3.5.9-2.el5.elgis elgis-plus
226 k
Transaction Summary
======================================================================
==========
Install 1 Package(s)
Upgrade 3 Package(s)
Total download size: 625 k
Is this ok [y/N]: y
Downloading Packages:
(1/4): sqlite-devel-3.5.9-2.el5.elgis.x86_64.rpm | 84 kB
00:00
(2/4): sqlite-devel-3.5.9-2.el5.elgis.i386.rpm | 84 kB
00:00
(3/4): sqlite-3.5.9-2.el5.elgis.x86_64.rpm | 226 kB
00:01
(4/4): sqlite-3.5.9-2.el5.elgis.i386.rpm | 231 kB
00:01
----------------------------------------------------------------------
----------
Total 137 kB/s | 625 kB
00:04
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : sqlite
1/7
Updating : sqlite
2/7
Installing : sqlite-devel
3/7
Updating : sqlite-devel
4/7
Cleanup : sqlite-devel
5/7
Cleanup : sqlite
6/7
Cleanup : sqlite
7/7
Installed:
sqlite-devel.i386 0:3.5.9-2.el5.elgis
Updated:
sqlite-devel.x86_64 0:3.5.9-2.el5.elgis
Dependency Updated:
sqlite.i386 0:3.5.9-2.el5.elgis sqlite.x86_64
0:3.5.9-2.el5.elgis
Complete!
[root at buster2 ~]# python
Python 2.4.3 (#1, May 5 2011, 16:39:10) [GCC 4.1.2 20080704 (Red Hat
4.1.2-50)] on linux2 Type "help", "copyright", "credits" or "license"
for more information.
>>> from osgeo import gdal
>>> quit
'Use Ctrl-D (i.e. EOF) to exit.'
>>>
Which means you must use the elgis sqlite and not the one from the
centos distribution
--Nikos
________________________________________
From: el-bounces at lists.osgeo.org [el-bounces at lists.osgeo.org] on
behalf of Hatzopoulos, Nikolaos [hatzopou at chapman.edu]
Sent: Tuesday, August 23, 2011 11:59 PM
To: Mathieu Baudier
Cc: el at lists.osgeo.org
Subject: RE: [ELGIS] RE: GDAL python bindings and libspatialite
I installed sqlite-devel
and it is working
--Nikos
________________________________________
From: el-bounces at lists.osgeo.org [el-bounces at lists.osgeo.org] on
behalf of Hatzopoulos, Nikolaos [hatzopou at chapman.edu]
Sent: Tuesday, August 23, 2011 11:54 PM
To: Mathieu Baudier
Cc: el at lists.osgeo.org
Subject: RE: [ELGIS] RE: GDAL python bindings and libspatialite
mine fails :)
python
Python 2.4.3 (#1, May 5 2011, 16:39:10) [GCC 4.1.2 20080704 (Red Hat
4.1.2-50)] on linux2 Type "help", "copyright", "credits" or "license"
for more information.
>>> from osgeo import gdal
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib64/python2.4/site-packages/osgeo/__init__.py", line
24, in ?
import _gdal
ImportError: /usr/lib64/libspatialite.so.2: undefined symbol:
sqlite3_clear_bindings
________________________________________
From: Mathieu Baudier [mbaudier at argeo.org]
Sent: Tuesday, August 23, 2011 11:50 PM
To: Hatzopoulos, Nikolaos
Cc: Adrian Bartel (AR); el at lists.osgeo.org
Subject: Re: [ELGIS] RE: GDAL python bindings and libspatialite
> if you hit python
> and you are in python mode
>
> enter:
> from osgeo import gdal
Should this fail ?
[mbaudier at alma ~]$ python
Python 2.4.3 (#1, May 5 2011, 16:39:10) [GCC 4.1.2 20080704 (Red Hat
4.1.2-50)] on linux2 Type "help", "copyright", "credits" or "license"
for more information.
>>> from osgeo import gdal
>>> print "test"
test
>>>
[mbaudier at alma ~]$
_______________________________________________
el mailing list
el at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/el
_______________________________________________
el mailing list
el at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/el
_______________________________________________
el mailing list
el at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/el
_______________________________________________
el mailing list
el at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/el
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail is subject to the Telkom SA electronic communication legal
notice, available at :
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________
el mailing list
el at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/el
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail is subject to the Telkom SA electronic communication legal notice, available at :
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
More information about the el
mailing list