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

[Pavel Iacovlev]

mod_ssl-2.2.3-53.el5.centos.3openssl-0.9.8e-20.el5perl-Net-SSLeay-1.30-4.fc6perl-IO-Socket-SSL-1.01-1.fc6openssl-0.9.8e-20.el5
On Tue, Dec 27, 2011 at 10:50 AM, Peter Hopfgartner
<peter.hopfgartner at r3-gis.com> wrote:
> 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