Hello,

My pgsql is installed in /local/pkg/pgsql8.0, but configure of pgadmin
can't seem to be persuaded to believe that or anything else for that
matter. Could you hint me what am I doing wrong? (I have pg in fact in
two different locations, one is fresh from CVS the other is 8.0.1, none
is found by the pgadmin's configure).

[serguei@ipecac pgadmin3] % uname -srvpio
Linux 2.6.5-1.358 #1 Sat May 8 09:04:50 EDT 2004 i686 i386 GNU/Linux

pg version: bleeding edge
padmin version: alike

[serguei@ipecac pgadmin3] % ./configure --prefix=/local/pkg/pgadmin3 --enable-debug --with-pgsql=/local/pkg/pgsql8.0/
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking how to run the C preprocessor... gcc -E
checking for egrep... grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking arpa/inet.h usability... yes
checking arpa/inet.h presence... yes
checking for arpa/inet.h... yes
checking netdb.h usability... yes
checking netdb.h presence... yes
checking for netdb.h... yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking for stdlib.h... (cached) yes
checking for stdbool.h that conforms to C99... yes
checking for _Bool... yes
checking for an ANSI C-conforming const... yes
checking for size_t... yes
checking whether time.h and sys/time.h may both be included... yes
checking for working strtod... yes
checking for gethostbyname... yes
checking for inet_ntoa... yes
checking for memmove... yes
checking for memset... yes
checking for strchr... yes
checking for wx-config binary... yes
checking for pgsql include files... yes
checking for pgsql... yes
checking for PQexec in -lpq... no
checking for SSL_connect in -lpq... no
checking libpq-fe.h usability... yes
checking libpq-fe.h presence... yes
checking for libpq-fe.h... yes
checking pgsql in /local/pkg/pgsql8.0/... failed
configure: error: you must specify a valid pgsql installation with --with-pgsql=DIR

Thanks,

--
Serguei A. Mokhov | /~\ The ASCII
Computer Science Department | \ / Ribbon Campaign
Concordia University | X Against HTML
Montreal, Quebec, Canada | / \ Email!

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Here's the culprit:

configure:4912: checking for PQexec in -lpq
configure:4942: gcc -o conftest -Wall -g -O0 -I/local/pkg/pgsql8.0//include -L/local/pkg/pgsql8.0//lib conftest.c -lpq -lssl -lcrypto -lpq >&5
/usr/bin/ld: cannot find -lssl

This is the old -lssl bug. I submitted a fix for this a while back, but I guess it never made it. :-) Try the attached patch and see if fixes your problems. You'll have to re-run bootstrap after applying the patch.

ahp



--- pgadmin3/acinclude.m4 Tue Nov 23 15:31:49 2004
+++ pgadmin3.new/acinclude.m4 Tue Nov 23 15:31:30 2004
@@ -119,14 +119,24 @@
fi
if test "$pg_static_build" = "yes"
then
- LIBS="${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lssl -lcrypto"
+ if test "$pgsql_ssl_libpq" = "yes"
+ then
+ LIBS="${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lssl -lcrypto"
+ else
+ LIBS="${LIBPQ_HOME}/lib/libpq.a -lcrypt $LIBS -lcrypto"
+ fi
else
- LIBS="$LIBS -lssl -lcrypto -lpq"
+ if test "$pgsql_ssl_libpq" = "yes"
+ then
+ LIBS="$LIBS -lssl -lcrypto -lpq"
+ else
+ LIBS="$LIBS -lcrypto -lpq"
+ fi
fi
AC_LANG_SAVE
AC_LANG_C
AC_CHECK_LIB(pq, PQexec, [pgsql_cv_libpq=yes], [pgsql_cv_libpq=no])
- AC_CHECK_LIB(pq, SSL_connect, [pgsql_ssl_libpq=yes], [pgsql_ssl_libpq=np])
+ AC_CHECK_LIB(pq, SSL_connect, [pgsql_ssl_libpq=yes], [pgsql_ssl_libpq=no])
AC_CHECK_HEADER(libpq-fe.h, [pgsql_cv_libpqfe_h=yes], [pgsql_cv_libpqfe_h=no])
AC_LANG_RESTORE
if test "$pgsql_cv_libpq" = "yes" -a "$pgsql_cv_libpqfe_h" = "yes"


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org