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

[Peter Hopfgartner]

Does the same happen if you run php from the command line? If yes, could 
yes, install the php53 and the mapserver debuginfo packages and  provide 
a gdb backtrace?

simpy do:

gdb /usr/bin/php

...

run myscript.php

When the script crashed, do:

bt

and send the output?

Peter

On 12/27/2011 09:18 AM, Pavel Iacovlev wrote:
> if I unload the php-mapserver extension (comment it out and restart
> apache) it works fine.
>
> On Tue, Dec 27, 2011 at 10:13 AM, Peter Hopfgartner
> <peter.hopfgartner at r3-gis.com>  wrote:
>> 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
>>


-- 
Peter Hopfgartner
R3 GIS
http://www.r3-gis.com