[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:38:46 EST 2011
I would start with rebuilding the mapserver packages (they all come from
a single src.rpm).
Peter
On 12/27/2011 10:32 AM, Pavel Iacovlev wrote:
> Do I rebuilt only php-mapserver package, or any other packages too ?
>
> On Tue, Dec 27, 2011 at 11:29 AM, Peter Hopfgartner
> <peter.hopfgartner at r3-gis.com <mailto:peter.hopfgartner at r3-gis.com>>
> 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?
> 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
>
>
--
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/8b1aa175/attachment-0001.html
More information about the el
mailing list