[ELGIS] /usr/lib64/libspatialite.so.2: undefined symbol: sqlite3_clear_bindings in Unknown on line 0

[Peter Hopfgartner]

On 12/26/2011 06:04 PM, Pavel Iacovlev wrote:
> Sorry to bring attention to this thread again, but I still cant get
> php-mapserver working properly in ELGIS 5 stable.
> My steps are:
>   * Install a fresh CentOS 5 distribution
>    * Add the ELGIS 5 repo
>    * Enable elgis-plus  in /etc/yum.repos.d/elgis.repo (thats because
> php-mapserver does on work with just elgis due to  spatialite errors)
>    * Install php-mapserver
>
> After this php runs fine, with no errors about spatialite, BUT then I
> try to connect to the database apache crashes with the following
> message: [Tue Dec 13 11:49:53 2011] [notice] child pid 6502 exit
> signal Segmentation fault (11)
>
> The php script to reproduce is rather simple:
> <?php
> $conn = pg_connect("dbname=gis username=user password=pass host=localhost");
>
Does this only happen when php-mapscript is installed? Could you try to 
remove php-mapscript and see what happens?

Peter

> Any ideas how to get php-mapserver working on CentOS 5 ?
>
> On Fri, Dec 16, 2011 at 2:34 PM, Pavel Iacovlev
> <iacovlev.pavel at gmail.com>  wrote:
>> Just a reminder, this problem is still not fixed, and php-mapscript
>> does not work at all after installing from elgis repo.
>>
>> adding elgis-plus repo and updating fixes the problem.
>>
>> On Tue, Oct 11, 2011 at 11:30 AM, Mathieu Baudier<mbaudier at argeo.org>  wrote:
>>>> [root at localhost etc]# rpm -qa | grep sqlite
>>>> sqlite-3.3.6-5
>>>> python-sqlite-1.1.7-1.2.1
>>>> sqlite-3.3.6-5
>>> There is a known issue with libspatialite/sqlite in ELGIS5:
>>> libspatialite, although in ELGIS (non Plus), has been built by mistake
>>> against the sqlite from ELGIS Plus:
>>> http://trac.osgeo.org/el/ticket/7
>>>
>>> Until a fix is available, a workaround is to install sqlite from ELGIS
>>> Plus (just enable elgis-plus in the elgis.repo file and it will be
>>> updated).
>>>
>>> Although I have never experienced any issue with this updated version
>>> of sqlite, please note that this is quite an important component of
>>> the base OS since many software rely on it (e.g. yum).
>>>
>>> I will try to fix this when I do a batch of updates for ELGIS5.
>>> Unfortunately we may have to disable libspatialite support in GDAL
>>> because of that.
>>>
>>> I'm sorry for the inconvenience.
>>>
>>> Cheers,
>>>
>>> Mathieu


-- 
Dott. Peter Hopfgartner
R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
web  : www.r3-gis.com
mail : peter.hopfgartner at r3-gis.com
phone: +39 0473 494949
fax  : +39 0473 069902

ATTENZIONE! Le informazioni contenute nella presente e-mail e nei documenti eventualmente allegati sono confidenziali. La loro diffusione, distribuzione e/o riproduzione da parte di terzi, senza autorizzazione del mittente è vietata e può violare il D. Lgs. 196/2003. In caso di ricezione per errore, Vogliate immediatamente informare il mittente del messaggio e distruggere la e-mail.
ACHTUNG! Die in dieser Nachricht oder in den beigelegten Dokumenten beinhalteten Informationen sind streng vertraulich. Ihre Verbreitung und/oder ihre Wiedergabe durch Dritte ist ohne Erlaubnis des Absenders verboten und verstößt gegen das Legislativdekret 196/2003. Sollten Sie diese Mitteilung irrtümlicherweise erhalten haben, bitten wir Sie uns umgehend zu informieren und anschließend die Mitteilung zu vernichten.
WARNING! This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden and could be against the law (D. Lgs. 196/2003)