<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
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?<br>
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.<br>
Could you rebuild the mapserver packages on your machine? It's
really easy, just google for "rebuild rpm", e.g.:
<a class="moz-txt-link-freetext" href="http://wiki.centos.org/HowTos/RebuildSRPM">http://wiki.centos.org/HowTos/RebuildSRPM</a>.<br>
<br>
Peter<br>
<br>
<br>
On 12/27/2011 10:04 AM, Pavel Iacovlev wrote:
<blockquote
cite="mid:CAHWp1L_T2EDp30R47BT=60SGvqaE7eq=5hCZpDdqvvrQk-WWUQ@mail.gmail.com"
type="cite">Removed 122 32bit packages.
<div><br>
</div>
<div>Still crashes: <a moz-do-not-send="true"
href="http://pastie.org/3078492">http://pastie.org/3078492</a></div>
<div><br>
<div class="gmail_quote">On Tue, Dec 27, 2011 at 10:57 AM, Peter
Hopfgartner <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:peter.hopfgartner@r3-gis.com">peter.hopfgartner@r3-gis.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff"> 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:<br>
<br>
yum remove glibc.i686<br>
<br>
or follow the approach in the official FAQ:<br>
<br>
<a moz-do-not-send="true"
href="http://wiki.centos.org/FAQ/General"
target="_blank">http://wiki.centos.org/FAQ/General</a>
<div>
<div class="h5"><br>
<br>
<br>
<br>
On 12/27/2011 09:53 AM, Pavel Iacovlev wrote:
<blockquote type="cite">
<pre style="word-wrap: break-word; white-space: pre-wrap;">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</pre>
<br>
<div class="gmail_quote">On Tue, Dec 27, 2011 at
10:52 AM, Pavel Iacovlev <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:iacovlev.pavel@gmail.com"
target="_blank">iacovlev.pavel@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt
0pt 0pt 0.8ex; border-left: 1px solid rgb(204,
204, 204); padding-left: 1ex;">
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<br>
On Tue, Dec 27, 2011 at 10:50 AM, Peter
Hopfgartner<br>
<div>
<div><<a moz-do-not-send="true"
href="mailto:peter.hopfgartner@r3-gis.com"
target="_blank">peter.hopfgartner@r3-gis.com</a>>
wrote:<br>
> On 12/27/2011 09:34 AM, Pavel Iacovlev
wrote:<br>
>><br>
>> The program being debugged has been
started already.Start it from the<br>
>> beginning? (y or n) Starting
program: /usr/bin/php crash.phpwarning:<br>
>> no loadable sections found in added
symbol-file system-supplied DSO at<br>
>> 0x2aaaaaaab000[Thread debugging
using libthread_db enabled]<br>
>> Program received signal SIGSEGV,
Segmentation fault.0x000000384482d6b0<br>
>> in SSL_pending () from
/lib64/libssl.so.6<br>
><br>
><br>
> Does anybody know what's the part of
SSL in this? I have two things I can<br>
> not grasp:<br>
><br>
> The PostgreSQL connection does not seem
to require SSL-encryption. Why does<br>
> it hand on SSL_pending () ?<br>
><br>
> Then, could it be that there is a
conflict of different SSL-libs? Which<br>
> SSL-implementation do you have on your
system? I do have:<br>
><br>
> [root@rpm-devel ~]# rpm -qa | grep -i
ssl<br>
> openssl-devel-0.9.8e-20.el5<br>
> openssl-0.9.8e-20.el5<br>
><br>
> Peter<br>
><br>
>> On Tue, Dec 27, 2011 at 10:25 AM,
Peter Hopfgartner<br>
>> <<a moz-do-not-send="true"
href="mailto:peter.hopfgartner@r3-gis.com"
target="_blank">peter.hopfgartner@r3-gis.com</a>>
wrote:<br>
>>><br>
>>> Does the same happen if you run
php from the command line? If yes, could<br>
>>> yes, install the php53 and the
mapserver debuginfo packages and provide<br>
>>> a<br>
>>> gdb backtrace?<br>
>>><br>
>>> simpy do:<br>
>>><br>
>>> gdb /usr/bin/php<br>
>>><br>
>>> ...<br>
>>><br>
>>> run myscript.php<br>
>>><br>
>>> When the script crashed, do:<br>
>>><br>
>>> bt<br>
>>><br>
>>> and send the output?<br>
>>><br>
>>> Peter<br>
>>><br>
>>><br>
>>> On 12/27/2011 09:18 AM, Pavel
Iacovlev wrote:<br>
>>>><br>
>>>> if I unload the
php-mapserver extension (comment it out and
restart<br>
>>>> apache) it works fine.<br>
>>>><br>
>>>> On Tue, Dec 27, 2011 at
10:13 AM, Peter Hopfgartner<br>
>>>> <<a
moz-do-not-send="true"
href="mailto:peter.hopfgartner@r3-gis.com"
target="_blank">peter.hopfgartner@r3-gis.com</a>>
wrote:<br>
>>>>><br>
>>>>> On 12/26/2011 06:04 PM,
Pavel Iacovlev wrote:<br>
>>>>>><br>
>>>>>> Sorry to bring
attention to this thread again, but I still
cant get<br>
>>>>>> php-mapserver
working properly in ELGIS 5 stable.<br>
>>>>>> My steps are:<br>
>>>>>> * Install a fresh
CentOS 5 distribution<br>
>>>>>> * Add the ELGIS 5
repo<br>
>>>>>> * Enable
elgis-plus in /etc/yum.repos.d/elgis.repo
(thats because<br>
>>>>>> php-mapserver does
on work with just elgis due to spatialite
errors)<br>
>>>>>> * Install
php-mapserver<br>
>>>>>><br>
>>>>>> After this php runs
fine, with no errors about spatialite, BUT
then I<br>
>>>>>> try to connect to
the database apache crashes with the
following<br>
>>>>>> message: [Tue Dec
13 11:49:53 2011] [notice] child pid 6502
exit<br>
>>>>>> signal Segmentation
fault (11)<br>
>>>>>><br>
>>>>>> The php script to
reproduce is rather simple:<br>
>>>>>> <?php<br>
>>>>>> $conn =
pg_connect("dbname=gis username=user
password=pass<br>
>>>>>> host=localhost");<br>
>>>>>><br>
>>>>> Does this only happen
when php-mapscript is installed? Could you
try to<br>
>>>>> remove php-mapscript
and see what happens?<br>
>>>>><br>
>>>>> Peter<br>
>>>>><br>
>>>>><br>
>>>>>> Any ideas how to
get php-mapserver working on CentOS 5 ?<br>
>>>>>><br>
>>>>>> On Fri, Dec 16,
2011 at 2:34 PM, Pavel Iacovlev<br>
>>>>>> <<a
moz-do-not-send="true"
href="mailto:iacovlev.pavel@gmail.com"
target="_blank">iacovlev.pavel@gmail.com</a>>
wrote:<br>
>>>>>>><br>
>>>>>>> Just a
reminder, this problem is still not fixed,
and php-mapscript<br>
>>>>>>> does not work
at all after installing from elgis repo.<br>
>>>>>>><br>
>>>>>>> adding
elgis-plus repo and updating fixes the
problem.<br>
>>>>>>><br>
>>>>>>> On Tue, Oct 11,
2011 at 11:30 AM, Mathieu Baudier<<a
moz-do-not-send="true"
href="mailto:mbaudier@argeo.org"
target="_blank">mbaudier@argeo.org</a>><br>
>>>>>>> wrote:<br>
>>>>>>>>><br>
>>>>>>>>>
[root@localhost etc]# rpm -qa | grep sqlite<br>
>>>>>>>>>
sqlite-3.3.6-5<br>
>>>>>>>>>
python-sqlite-1.1.7-1.2.1<br>
>>>>>>>>>
sqlite-3.3.6-5<br>
>>>>>>>><br>
>>>>>>>> There is a
known issue with libspatialite/sqlite in
ELGIS5:<br>
>>>>>>>>
libspatialite, although in ELGIS (non Plus),
has been built by<br>
>>>>>>>> mistake<br>
>>>>>>>> against the
sqlite from ELGIS Plus:<br>
>>>>>>>> <a
moz-do-not-send="true"
href="http://trac.osgeo.org/el/ticket/7"
target="_blank">http://trac.osgeo.org/el/ticket/7</a><br>
>>>>>>>><br>
>>>>>>>> Until a fix
is available, a workaround is to install
sqlite from<br>
>>>>>>>> ELGIS<br>
>>>>>>>> Plus (just
enable elgis-plus in the elgis.repo file and
it will be<br>
>>>>>>>> updated).<br>
>>>>>>>><br>
>>>>>>>> Although I
have never experienced any issue with this
updated<br>
>>>>>>>> version<br>
>>>>>>>> of sqlite,
please note that this is quite an important
component of<br>
>>>>>>>> the base OS
since many software rely on it (e.g. yum).<br>
>>>>>>>><br>
>>>>>>>> I will try
to fix this when I do a batch of updates for
ELGIS5.<br>
>>>>>>>>
Unfortunately we may have to disable
libspatialite support in GDAL<br>
>>>>>>>> because of
that.<br>
>>>>>>>><br>
>>>>>>>> I'm sorry
for the inconvenience.<br>
>>>>>>>><br>
>>>>>>>> Cheers,<br>
>>>>>>>><br>
>>>>>>>> Mathieu<br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>> --<br>
>>>>> Dott. Peter Hopfgartner<br>
>>>>> R3 GIS Srl - GmbH<br>
>>>>> Via Johann Kravogl-Str.
2<br>
>>>>> I-39012 Meran/Merano
(BZ)<br>
>>>>> web : <a
moz-do-not-send="true"
href="http://www.r3-gis.com"
target="_blank">www.r3-gis.com</a><br>
>>>>> mail : <a
moz-do-not-send="true"
href="mailto:peter.hopfgartner@r3-gis.com"
target="_blank">peter.hopfgartner@r3-gis.com</a><br>
>>>>> phone: <a
moz-do-not-send="true"
href="tel:%2B39%200473%20494949"
value="+390473494949" target="_blank">+39
0473 494949</a><br>
>>>>> fax : <a
moz-do-not-send="true"
href="tel:%2B39%200473%20069902"
value="+390473069902" target="_blank">+39
0473 069902</a><br>
>>>>><br>
>>><br>
>>> --<br>
>>> Peter Hopfgartner<br>
>>> R3 GIS<br>
>>> <a moz-do-not-send="true"
href="http://www.r3-gis.com"
target="_blank">http://www.r3-gis.com</a><br>
><br>
><br>
><br>
> --<br>
> Peter Hopfgartner<br>
> R3 GIS<br>
> <a moz-do-not-send="true"
href="http://www.r3-gis.com"
target="_blank">http://www.r3-gis.com</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
<br>
<br>
<div>-- <br>
Peter Hopfgartner<br>
R3 GIS<br>
<a moz-do-not-send="true"
href="http://www.r3-gis.com" target="_blank">http://www.r3-gis.com</a>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
Peter Hopfgartner<br>
R3 GIS<br>
<a class="moz-txt-link-freetext" href="http://www.r3-gis.com">http://www.r3-gis.com</a>
</div>
</body>
</html>