<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="UTF-8" text="#000000"
bgcolor="#ffffff">
On 12/27/2011 11:29 AM, Peter Hopfgartner wrote:
<blockquote cite="mid:4EF9900A.80501@r3-gis.com" type="cite">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
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>
</blockquote>
<br>
Maybe Pavel has a hostssl ... line in his pg_hba.conf, or ssl
enabled in postgresql.conf??<br>
<br>
<blockquote cite="mid:4EF9900A.80501@r3-gis.com" type="cite"> 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
moz-do-not-send="true" 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 moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.r3-gis.com">http://www.r3-gis.com</a> </div>
<br>
<br>
This mail was received via Mail-SeCure System.<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
el mailing list
<a class="moz-txt-link-abbreviated" href="mailto:el@lists.osgeo.org">el@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/el">http://lists.osgeo.org/mailman/listinfo/el</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>