Ok, thank you very much for your support.<br><br><div class="gmail_quote">On Tue, Dec 27, 2011 at 11:38 AM, Peter Hopfgartner <span dir="ltr">&lt;<a href="mailto:peter.hopfgartner@r3-gis.com">peter.hopfgartner@r3-gis.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>

  
    
  
  <div text="#000000" bgcolor="#ffffff">
    I would start with rebuilding the mapserver packages (they all come
    from a single src.rpm).<span class="HOEnZb"><font color="#888888"><br>
    <br>
    Peter</font></span><div><div class="h5"><br>
    <br>
    On 12/27/2011 10:32 AM, Pavel Iacovlev wrote:
    <blockquote type="cite">Do I rebuilt only php-mapserver package, or any other
      packages too ?<br>
      <br>
      <div class="gmail_quote">On Tue, Dec 27, 2011 at 11:29 AM, Peter
        Hopfgartner <span dir="ltr">&lt;<a href="mailto:peter.hopfgartner@r3-gis.com" target="_blank">peter.hopfgartner@r3-gis.com</a>&gt;</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"> Personally, I do not
            have any clue what&#39;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&#39;s happening.<br>
            Could you rebuild the mapserver packages on your machine?
            It&#39;s really easy, just google for &quot;rebuild rpm&quot;, e.g.: <a href="http://wiki.centos.org/HowTos/RebuildSRPM" target="_blank">http://wiki.centos.org/HowTos/RebuildSRPM</a>.<span><font color="#888888"><br>

                <br>
                Peter</font></span>
            <div>
              <div><br>
                <br>
                <br>
                On 12/27/2011 10:04 AM, Pavel Iacovlev wrote:
                <blockquote type="cite">Removed 122 32bit packages.
                  <div><br>
                  </div>
                  <div>Still crashes: <a href="http://pastie.org/3078492" target="_blank">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">&lt;<a href="mailto:peter.hopfgartner@r3-gis.com" target="_blank">peter.hopfgartner@r3-gis.com</a>&gt;</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 href="http://wiki.centos.org/FAQ/General" target="_blank">http://wiki.centos.org/FAQ/General</a>
                          <div>
                            <div><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">&lt;<a href="mailto:iacovlev.pavel@gmail.com" target="_blank">iacovlev.pavel@gmail.com</a>&gt;</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>&lt;<a href="mailto:peter.hopfgartner@r3-gis.com" target="_blank">peter.hopfgartner@r3-gis.com</a>&gt;


                                        wrote:<br>
                                        &gt; On 12/27/2011 09:34 AM,
                                        Pavel Iacovlev wrote:<br>
                                        &gt;&gt;<br>
                                        &gt;&gt; The program being
                                        debugged has been started
                                        already.Start it from the<br>
                                        &gt;&gt; beginning? (y or n)
                                        Starting program: /usr/bin/php
                                        crash.phpwarning:<br>
                                        &gt;&gt; no loadable sections
                                        found in added symbol-file
                                        system-supplied DSO at<br>
                                        &gt;&gt; 0x2aaaaaaab000[Thread
                                        debugging using libthread_db
                                        enabled]<br>
                                        &gt;&gt; Program received signal
                                        SIGSEGV, Segmentation
                                        fault.0x000000384482d6b0<br>
                                        &gt;&gt; in SSL_pending () from
                                        /lib64/libssl.so.6<br>
                                        &gt;<br>
                                        &gt;<br>
                                        &gt; Does anybody know what&#39;s
                                        the part of SSL in this? I have
                                        two things I can<br>
                                        &gt; not grasp:<br>
                                        &gt;<br>
                                        &gt; The PostgreSQL connection
                                        does not seem to require
                                        SSL-encryption. Why does<br>
                                        &gt; it hand on SSL_pending () ?<br>
                                        &gt;<br>
                                        &gt; Then, could it be that
                                        there is a conflict of different
                                        SSL-libs? Which<br>
                                        &gt; SSL-implementation do you
                                        have on your system? I do have:<br>
                                        &gt;<br>
                                        &gt; [root@rpm-devel ~]# rpm -qa
                                        | grep -i ssl<br>
                                        &gt; openssl-devel-0.9.8e-20.el5<br>
                                        &gt; openssl-0.9.8e-20.el5<br>
                                        &gt;<br>
                                        &gt; Peter<br>
                                        &gt;<br>
                                        &gt;&gt; On Tue, Dec 27, 2011 at
                                        10:25 AM, Peter Hopfgartner<br>
                                        &gt;&gt; &lt;<a href="mailto:peter.hopfgartner@r3-gis.com" target="_blank">peter.hopfgartner@r3-gis.com</a>&gt;


                                         wrote:<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; Does the same
                                        happen if you run php from the
                                        command line? If yes, could<br>
                                        &gt;&gt;&gt; yes, install the
                                        php53 and the mapserver
                                        debuginfo packages and  provide<br>
                                        &gt;&gt;&gt; a<br>
                                        &gt;&gt;&gt; gdb backtrace?<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; simpy do:<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; gdb /usr/bin/php<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; ...<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; run myscript.php<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; When the script
                                        crashed, do:<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; bt<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; and send the
                                        output?<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; Peter<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; On 12/27/2011 09:18
                                        AM, Pavel Iacovlev wrote:<br>
                                        &gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt; if I unload the
                                        php-mapserver extension (comment
                                        it out and restart<br>
                                        &gt;&gt;&gt;&gt; apache) it
                                        works fine.<br>
                                        &gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt; On Tue, Dec 27,
                                        2011 at 10:13 AM, Peter
                                        Hopfgartner<br>
                                        &gt;&gt;&gt;&gt; &lt;<a href="mailto:peter.hopfgartner@r3-gis.com" target="_blank">peter.hopfgartner@r3-gis.com</a>&gt;


                                           wrote:<br>
                                        &gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt; On
                                        12/26/2011 06:04 PM, Pavel
                                        Iacovlev wrote:<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; Sorry
                                        to bring attention to this
                                        thread again, but I still cant
                                        get<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;
                                        php-mapserver working properly
                                        in ELGIS 5 stable.<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; My
                                        steps are:<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;  *
                                        Install a fresh CentOS 5
                                        distribution<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;   * Add
                                        the ELGIS 5 repo<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;   *
                                        Enable elgis-plus  in
                                        /etc/yum.repos.d/elgis.repo
                                        (thats because<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;
                                        php-mapserver does on work with
                                        just elgis due to  spatialite
                                        errors)<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;   *
                                        Install php-mapserver<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; After
                                        this php runs fine, with no
                                        errors about spatialite, BUT
                                        then I<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; try to
                                        connect to the database apache
                                        crashes with the following<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;
                                        message: [Tue Dec 13 11:49:53
                                        2011] [notice] child pid 6502
                                        exit<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; signal
                                        Segmentation fault (11)<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; The php
                                        script to reproduce is rather
                                        simple:<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;
                                        &lt;?php<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; $conn =
                                        pg_connect(&quot;dbname=gis
                                        username=user password=pass<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;
                                        host=localhost&quot;);<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt; Does this
                                        only happen when php-mapscript
                                        is installed? Could you try to<br>
                                        &gt;&gt;&gt;&gt;&gt; remove
                                        php-mapscript and see what
                                        happens?<br>
                                        &gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt; Peter<br>
                                        &gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; Any
                                        ideas how to get php-mapserver
                                        working on CentOS 5 ?<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; On Fri,
                                        Dec 16, 2011 at 2:34 PM, Pavel
                                        Iacovlev<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt; &lt;<a href="mailto:iacovlev.pavel@gmail.com" target="_blank">iacovlev.pavel@gmail.com</a>&gt;


                                             wrote:<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        Just a reminder, this problem is
                                        still not fixed, and
                                        php-mapscript<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        does not work at all after
                                        installing from elgis repo.<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        adding elgis-plus repo and
                                        updating fixes the problem.<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt; On
                                        Tue, Oct 11, 2011 at 11:30 AM,
                                        Mathieu Baudier&lt;<a href="mailto:mbaudier@argeo.org" target="_blank">mbaudier@argeo.org</a>&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                         wrote:<br>
&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;

                                        [root@localhost etc]# rpm -qa |
                                        grep sqlite<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;

                                        sqlite-3.3.6-5<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;

                                        python-sqlite-1.1.7-1.2.1<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;

                                        sqlite-3.3.6-5<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        There is a known issue with
                                        libspatialite/sqlite in ELGIS5:<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        libspatialite, although in ELGIS
                                        (non Plus), has been built by<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        mistake<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        against the sqlite from ELGIS
                                        Plus:<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        <a href="http://trac.osgeo.org/el/ticket/7" target="_blank">http://trac.osgeo.org/el/ticket/7</a><br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        Until a fix is available, a
                                        workaround is to install sqlite
                                        from<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        ELGIS<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        Plus (just enable elgis-plus in
                                        the elgis.repo file and it will
                                        be<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        updated).<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        Although I have never
                                        experienced any issue with this
                                        updated<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        version<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        of sqlite, please note that this
                                        is quite an important component
                                        of<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        the base OS since many software
                                        rely on it (e.g. yum).<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        I will try to fix this when I do
                                        a batch of updates for ELGIS5.<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        Unfortunately we may have to
                                        disable libspatialite support in
                                        GDAL<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        because of that.<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        I&#39;m sorry for the inconvenience.<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        Cheers,<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;
                                        Mathieu<br>
                                        &gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;&gt;&gt; --<br>
                                        &gt;&gt;&gt;&gt;&gt; Dott. Peter
                                        Hopfgartner<br>
                                        &gt;&gt;&gt;&gt;&gt; R3 GIS Srl
                                        - GmbH<br>
                                        &gt;&gt;&gt;&gt;&gt; Via Johann
                                        Kravogl-Str. 2<br>
                                        &gt;&gt;&gt;&gt;&gt; I-39012
                                        Meran/Merano (BZ)<br>
                                        &gt;&gt;&gt;&gt;&gt; web  : <a href="http://www.r3-gis.com" target="_blank">www.r3-gis.com</a><br>
                                        &gt;&gt;&gt;&gt;&gt; mail : <a href="mailto:peter.hopfgartner@r3-gis.com" target="_blank">peter.hopfgartner@r3-gis.com</a><br>
                                        &gt;&gt;&gt;&gt;&gt; phone: <a href="tel:%2B39%200473%20494949" value="+390473494949" target="_blank">+39 0473
                                          494949</a><br>
                                        &gt;&gt;&gt;&gt;&gt; fax  : <a href="tel:%2B39%200473%20069902" value="+390473069902" target="_blank">+39 0473
                                          069902</a><br>
                                        &gt;&gt;&gt;&gt;&gt;<br>
                                        &gt;&gt;&gt;<br>
                                        &gt;&gt;&gt; --<br>
                                        &gt;&gt;&gt; Peter Hopfgartner<br>
                                        &gt;&gt;&gt; R3 GIS<br>
                                        &gt;&gt;&gt; <a href="http://www.r3-gis.com" target="_blank">http://www.r3-gis.com</a><br>
                                        &gt;<br>
                                        &gt;<br>
                                        &gt;<br>
                                        &gt; --<br>
                                        &gt; Peter Hopfgartner<br>
                                        &gt; R3 GIS<br>
                                        &gt; <a 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 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>-- <br>
                  Peter Hopfgartner<br>
                  R3 GIS<br>
                  <a href="http://www.r3-gis.com" target="_blank">http://www.r3-gis.com</a> </div>
              </div>
            </div>
          </div>
        </blockquote>
      </div>
      <br>
    </blockquote>
    <br>
    <br>
    <div>-- <br>
      Peter Hopfgartner<br>
      R3 GIS<br>
      <a href="http://www.r3-gis.com" target="_blank">http://www.r3-gis.com</a>
    </div>
  </div></div></div>

</blockquote></div><br>