pgsql 7.2.2: problem compiling on Sol 8 Solved

I'm trying to compile PGSQL 7.2.2 to run with PHP and Apache on Solaris
8. The compilation appears to go OK, but, when I load Apache, I get

Syntax error on line 237 of /etc/apache/httpd.conf:
Cannot load /usr/apache/libexec/libphp4.so into server: ld.so.1:
/usr/apache/bin/httpd: fatal: libgcc_s.so.1: open failed: No such file
or directory
/usr/apache/bin/apachectl start: httpd could not be started

I pinned this down to

ldd /usr/local/pgsql/lib/libpq.so.2
libgcc_s.so.1 => (file not found)

I am using gcc 3.1.1, which is installed in a non-default location. My
command sequence is:

setenv LD_LIBRARY_PATH
/nerc/packages/gcc/3.1.1/lib:/nerc/packages/gcc/3.1.1/lib/sparcv9
setenv LDFLAGS "-L/nerc/packages/gcc/3.1.1/lib
-R/nerc/packages/gcc/3.1.1/lib"
configure --quiet --with-libraries=/nerc/packages/gcc/3.1.1/lib
--with-includes=/nerc/packages/gcc/3.1.1/lib
gmake

then, as root, gmake install

I see from browsing the email lists that this problem has been
encountered before, May 2001 was the earliest reference, but have not
been able to find a solution.

Can anybody help? Reply to me directly, I will summarise.

I also tried 7.1.3; this gave me

heaptuple.c:760: `MAXIMUM_ALIGNOF' undeclared (first use in this
function)
gmake[4]: *** [heaptuple.o] Error 1
gmake[4]: Leaving directory
`/local1/dick1/apache/postgresql-7.1.3/src/backend/access/common'
gmake[3]: *** [common-recursive] Error 2
gmake[3]: Leaving directory
`/local1/dick1/apache/postgresql-7.1.3/src/backend/access'
gmake[2]: *** [access-recursive] Error 2
gmake[2]: Leaving directory
`/local1/dick1/apache/postgresql-7.1.3/src/backend'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/local1/dick1/apache/postgresql-7.1.3/src'
gmake: *** [all] Error 2

thanks in advance, Dick

--
Richard Gillman
iTSS UNIX Systems Group, Maclean Building, Wallingford OX10 8BB
Tel: 01491 - 692 339

I've had some of the same problems with Pgsql 7.2. I managed to get around
some of them with help from Peter Kurpis of GCC list (search for previous
posts on the subject from me on this list).

But, I haven't been able to get createlang working. Think I might just wait
till 7.3 comes out.

> I'm trying to compile PGSQL 7.2.2 to run with PHP and Apache on Solaris
> 8. The compilation appears to go OK, but, when I load Apache, I get
>
> Syntax error on line 237 of /etc/apache/httpd.conf:
> Cannot load /usr/apache/libexec/libphp4.so into server: ld.so.1:
> /usr/apache/bin/httpd: fatal: libgcc_s.so.1: open failed: No such file
> or directory
> /usr/apache/bin/apachectl start: httpd could not be started
>
> I pinned this down to
>
> ldd /usr/local/pgsql/lib/libpq.so.2
> libgcc_s.so.1 => (file not found)
>
>
> I am using gcc 3.1.1, which is installed in a non-default location. My
> command sequence is:
>
> setenv LD_LIBRARY_PATH
> /nerc/packages/gcc/3.1.1/lib:/nerc/packages/gcc/3.1.1/lib/sparcv9
> setenv LDFLAGS "-L/nerc/packages/gcc/3.1.1/lib
> -R/nerc/packages/gcc/3.1.1/lib"
> configure --quiet --with-libraries=/nerc/packages/gcc/3.1.1/lib
> --with-includes=/nerc/packages/gcc/3.1.1/lib
> gmake
>
> then, as root, gmake install
>
> I see from browsing the email lists that this problem has been
> encountered before, May 2001 was the earliest reference, but have not
> been able to find a solution.
>
> Can anybody help? Reply to me directly, I will summarise.
>
> I also tried 7.1.3; this gave me
>
> heaptuple.c:760: `MAXIMUM_ALIGNOF' undeclared (first use in this
> function)
> gmake[4]: *** [heaptuple.o] Error 1
> gmake[4]: Leaving directory
> `/local1/dick1/apache/postgresql-7.1.3/src/backend/access/common'
> gmake[3]: *** [common-recursive] Error 2
> gmake[3]: Leaving directory
> `/local1/dick1/apache/postgresql-7.1.3/src/backend/access'
> gmake[2]: *** [access-recursive] Error 2
> gmake[2]: Leaving directory
> `/local1/dick1/apache/postgresql-7.1.3/src/backend'
> gmake[1]: *** [all] Error 2
> gmake[1]: Leaving directory `/local1/dick1/apache/postgresql-7.1.3/src'
> gmake: *** [all] Error 2
>
> thanks in advance, Dick

--
Randy Perry
sysTame
Mac Consulting/Sales

http://www.systame.com/

Folks,

Yesterday, I polled this list for help with a problem I had re compiling
pgsql for use with Apache and PHP. The problem's symptoms were that
Apache was failing to load because PHP could not find libgcc_s.so.1,
which, in turn, was because libpq.so.2 could not find libgcc_s.so.1.
This was because gcc on our systems is mounted in a non-standard
location (we tend to work in large clusters, with any add-on software
mounted on a central server, then automounted out to the individual
workstations.)

The sequence is: setenv, add gcc and libraries to path (setup) gmake
distclean (start from a clean sheet), configure, edit src/Makefile.port
to hand-carve-in the libraries, gmake, (as root) add gmake to path,
gmake install, test. In detail:

new window, clean sheet

cd /local1/dick1/apache/postgresql-7.2.2
setup gcc
setenv LDFLAGS "-L/nerc/packages/gcc/3.1.1/lib
-R/nerc/packages/gcc/3.1.1/lib"
gmake distclean
configure --quiet --with-libraries=/nerc/packages/gcc/3.1.1/lib
--with-includes=/nerc/packages/gcc/3.1.1/lib
vi src/Makefile.port

#ifeq ($(with_gnu_ld), yes)
#export_dynamic = -Wl,-E
#rpath = -Wl,-rpath,$(libdir)
#else
#rpath = -R$(libdir)
#endif
rpath = -L/usr/local/pgsql/lib -L/usr/local/lib -L/usr/local/ssl/lib
-L/nerc/packages/gcc/3.1.1/lib -Wl -R/usr/local/pgsql/lib -Wl
-R/usr/local/lib -Wl -R/usr/local/ssl/lib -Wl
-R/nerc/packages/gcc/3.1.1/lib
shlib_symbolic = -Wl,-Bsymbolic

gmake

as root, new window, no baggage

# PATH=/usr/sbin:/usr/bin:/nerc/packages/utilities/bin
# export PATH
# gmake

# ldd /usr/local/pgsql/lib/libpq.so.2
libresolv.so.2 => /usr/lib/libresolv.so.2
libnsl.so.1 => /usr/lib/libnsl.so.1
libsocket.so.1 => /usr/lib/libsocket.so.1
libgcc_s.so.1 =>
/nerc/packages/gcc/3.1.1/lib/libgcc_s.so.1
libdl.so.1 => /usr/lib/libdl.so.1
libc.so.1 => /usr/lib/libc.so.1
libmp.so.2 => /usr/lib/libmp.so.2
/usr/platform/SUNW,Sun-Blade-100/lib/libc_psr.so.1

Eureka, libpq now sees libgcc_s.so.1

Now to see if it works.

My thanks to Randall Perry, and his input from Peter Kurpis.

....Dick

Richard Gillman wrote:
>
> I'm trying to compile PGSQL 7.2.2 to run with PHP and Apache on Solaris
> 8. The compilation appears to go OK, but, when I load Apache, I get
>
> Syntax error on line 237 of /etc/apache/httpd.conf:
> Cannot load /usr/apache/libexec/libphp4.so into server: ld.so.1:
> /usr/apache/bin/httpd: fatal: libgcc_s.so.1: open failed: No such file
> or directory
> /usr/apache/bin/apachectl start: httpd could not be started
>
> I pinned this down to
>
> ldd /usr/local/pgsql/lib/libpq.so.2
> libgcc_s.so.1 => (file not found)
>
> I am using gcc 3.1.1, which is installed in a non-default location. My
> command sequence is:
>
> setenv LD_LIBRARY_PATH
> /nerc/packages/gcc/3.1.1/lib:/nerc/packages/gcc/3.1.1/lib/sparcv9
> setenv LDFLAGS "-L/nerc/packages/gcc/3.1.1/lib
> -R/nerc/packages/gcc/3.1.1/lib"
> configure --quiet --with-libraries=/nerc/packages/gcc/3.1.1/lib
> --with-includes=/nerc/packages/gcc/3.1.1/lib
> gmake
>
> then, as root, gmake install
>
> I see from browsing the email lists that this problem has been
> encountered before, May 2001 was the earliest reference, but have not
> been able to find a solution.
>
> thanks in advance, Dick
>
> --
> Richard Gillman
> iTSS UNIX Systems Group, Maclean Building, Wallingford OX10 8BB
> Tel: 01491 - 692 339
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Richard Gillman
iTSS UNIX Systems Group, Maclean Building, Wallingford OX10 8BB
Tel: 01491 - 692 339