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

Tue Dec 27 06:51:54 EST 2011

ssl = off

On Tue, Dec 27, 2011 at 1:11 PM, Micha Silver <micha at arava.co.il> wrote:

> **
> On 12/27/2011 11:29 AM, Peter Hopfgartner wrote:
>
> Personally, I do not have any clue what's happening. As said before, I
> wonder if it is normal, that pg_connect invokes SSL_pending(), even if no
> SSL connection is requested. Does anybody have a clue?
>
>
> Maybe Pavel has a hostssl ... line in his pg_hba.conf, or ssl enabled in
> postgresql.conf??
>
>  Does anybody else have this problem? PostgreSQL + PHP + MapServer is one
> of our standard stacks that we run on a number of production servers and I
> never encountered this problen. So the task, now, is really to isolate the
> anomaly, to understand what's happening.
> Could you rebuild the mapserver packages on your machine? It's really
> easy, just google for "rebuild rpm", e.g.:
> http://wiki.centos.org/HowTos/RebuildSRPM.
>
> Peter
>
>
> On 12/27/2011 10:04 AM, Pavel Iacovlev wrote:
>
> Removed 122 32bit packages.
>
>  Still crashes: http://pastie.org/3078492
>
> On Tue, Dec 27, 2011 at 10:57 AM, Peter Hopfgartner <
> peter.hopfgartner at r3-gis.com> wrote:
>
>>  I guess, you have both 32 bit and 64 bit libs installed. Do you need the
>> 32 bit flavour? You can remove 32 bit libs by either:
>>
>> yum remove glibc.i686
>>
>> or follow the approach in the official FAQ:
>>
>> http://wiki.centos.org/FAQ/General
>>
>>
>>
>>
>> On 12/27/2011 09:53 AM, Pavel Iacovlev wrote:
>>
>> mod_ssl-2.2.3-53.el5.centos.3
>> openssl-0.9.8e-20.el5
>> perl-Net-SSLeay-1.30-4.fc6
>> perl-IO-Socket-SSL-1.01-1.fc6
>> openssl-0.9.8e-20.el5
>>
>>
>> On Tue, Dec 27, 2011 at 10:52 AM, Pavel Iacovlev <
>> iacovlev.pavel at gmail.com> wrote:
>>
>>>
>>> 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 <%2B39%200473%20494949>
>>> >>>>> fax  : +39 0473 069902 <%2B39%200473%20069902>
>>> >>>>>
>>> >>>
>>> >>> --
>>> >>> Peter Hopfgartner
>>> >>> R3 GIS
>>> >>> http://www.r3-gis.com
>>> >
>>> >
>>> >
>>> > --
>>> > Peter Hopfgartner
>>> > R3 GIS
>>> > http://www.r3-gis.com
>>>
>>
>>
>>
>> --
>> Peter Hopfgartner
>> R3 GIS
>> http://www.r3-gis.com
>>
>
>
>
> --
> Peter Hopfgartner
> R3 GIS
> http://www.r3-gis.com
>
>
> This mail was received via Mail-SeCure System.
>
>
> _______________________________________________
> el mailing listel at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/el
>
>
> This mail was received via Mail-SeCure System.
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/el/attachments/20111227/c3ed4f82/attachment-0001.html