[ELGIS] /usr/lib64/libspatialite.so.2: undefined symbol:
sqlite3_clear_bindings in Unknown on line 0
Peter Hopfgartner
peter.hopfgartner at r3-gis.com
Tue Dec 27 04:29:46 EST 2011
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?
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 <mailto: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 <mailto: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
>> <mailto: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
>> <mailto: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
>> <mailto: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
>> <mailto: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 <mailto: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 <http://www.r3-gis.com>
>> >>>>> mail : peter.hopfgartner at r3-gis.com
>> <mailto:peter.hopfgartner at r3-gis.com>
>> >>>>> phone: +39 0473 494949 <tel:%2B39%200473%20494949>
>> >>>>> fax : +39 0473 069902 <tel:%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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/el/attachments/20111227/166fdd19/attachment-0001.html
More information about the el
mailing list