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

[Peter Hopfgartner]

On 12/27/2011 09:34 AM, Pavel Iacovlev wrote:
> The program being debugged has been started already.Start it from the
> beginning? (y or n) Starting program: /usr/bin/php crash.phpwarning:
> no loadable sections found in added symbol-file system-supplied DSO at
> 0x2aaaaaaab000[Thread debugging using libthread_db enabled]
> Program received signal SIGSEGV, Segmentation fault.0x000000384482d6b0
> in SSL_pending () from /lib64/libssl.so.6

Does anybody know what's the part of SSL in this? I have two things I 
can not grasp:

The PostgreSQL connection does not seem to require SSL-encryption. Why 
does it hand on SSL_pending () ?

Then, could it be that there is a conflict of different SSL-libs? Which 
SSL-implementation do you have on your system? I do have:

[root at rpm-devel ~]# rpm -qa | grep -i ssl
openssl-devel-0.9.8e-20.el5
openssl-0.9.8e-20.el5

Peter
> On Tue, Dec 27, 2011 at 10:25 AM, Peter Hopfgartner
> <peter.hopfgartner at r3-gis.com>  wrote:
>> 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


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