[ELGIS] RE: GDAL python bindings and libspatialite

Adrian Bartel (AR) bartelar at telkom.co.za
Wed Aug 24 03:47:13 EDT 2011


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



More information about the el mailing list