Re: Ubuntu natty and SSL connections

On 05/16/2011 08:59 PM, Andreas Neumann wrote:
> That's the funny think: configure told me that OpenSSL support is
> present in PostgreSQL - still it is disabled.
>
> Here is the configure output:
>
> ------------------------------------
> checking build system type... x86_64-unknown-linux-gnu
> checking host system type... x86_64-unknown-linux-gnu
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build environment is sane... yes
> checking for a thread-safe mkdir -p... /bin/mkdir -p
> checking for gawk... gawk
> checking whether make sets $(MAKE)... yes
> checking how to create a ustar tar archive... gnutar
> checking for gcc... gcc
> checking whether the C compiler works... yes
> checking for C compiler default output file name... a.out
> checking for suffix of executables...
> checking whether we are cross compiling... no
> 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 ISO C89... 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 for ranlib... ranlib
> checking whether to use precompiled headers... yes
> checking how to run the C preprocessor... gcc -E
> checking for grep that handles long lines and -e... /bin/grep
> checking for egrep... /bin/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 SSL_library_init in -lssl... yes
> checking for krb5_sendauth in -lkrb5... yes
> checking for PQexec in -lpq... yes
> checking for PQconninfoParse in -lpq... yes
> checking for SSL_connect in -lpq... yes
> checking for krb5_free_principal in -lpq... yes
> checking libpq-fe.h usability... yes
> checking libpq-fe.h presence... yes
> checking for libpq-fe.h... yes
> checking PostgreSQL in /usr/local/pgsql... ok
> checking for PQgetOutResult in -lpq... no
> checking wxWidgets version... ok
> checking wxWidgets in /usr... ok
> checking libxml2 in /usr... ok
> checking libxml2 version... ok
> checking libxslt in /usr... ok
> configure: creating ./config.status
> config.status: creating Makefile
> config.status: creating branding/Makefile
> config.status: creating i18n/Makefile
> config.status: creating pgadmin/Makefile
> config.status: creating pkg/Makefile
> config.status: creating pkg/debian/Makefile
> config.status: creating pkg/mac/Makefile
> config.status: creating pkg/mandrake/Makefile
> config.status: creating pkg/redhat/Makefile
> config.status: creating pkg/slackware/Makefile
> config.status: creating pkg/src/Makefile
> config.status: creating pkg/suse/Makefile
> config.status: creating pkg/win32/Makefile
> config.status: creating xtra/Makefile
> config.status: creating xtra/pgscript/Makefile
> config.status: creating xtra/pgscript/lib/Makefile
> config.status: creating xtra/pgscript/bin/Makefile
> config.status: creating xtra/pgscript/test/Makefile
> config.status: creating xtra/wx-build/Makefile
> config.status: creating config.h
> config.status: config.h is unchanged
> config.status: executing depfiles commands
>
> PostgreSQL directory: /usr/local/pgsql
> PostgreSQL pg_config binary: /usr/local/pgsql/bin/pg_config
> PostgreSQL version: PostgreSQL 9.0.4
>
> PostgreSQL PQconninfoParse support: Present
> PostgreSQL SSL support: Present
>
> wxWidgets directory: /usr
> wxWidgets wx-config binary: /usr/bin/wx-config
> wxWidgets version: wxWidgets 2.8.11
>
> libxml2 directory: /usr
> libxml2 xml2-config binary: /usr/bin/xml2-config
> libxml2 version: libxml2 2.7.8
>
> libxslt directory: /usr
> libxslt xslt-config binary: /usr/bin/xslt-config
> libxslt version: libxslt 1.1.26
>
> Building a debug version of pgAdmin: No
> Statically linking pgAdmin: No
> Building a Mac OS X appbundle: No
>
> pgAdmin configuration is now complete. You can now compile and
> install pgAdmin using 'make; make install'.
>
> ------------------------------------------------
>
> Here is the output of pg_config:
>
> ---------------------------------------
> BINDIR = /usr/local/pgsql/bin
> DOCDIR = /usr/local/pgsql/share/doc
> HTMLDIR = /usr/local/pgsql/share/doc
> INCLUDEDIR = /usr/local/pgsql/include
> PKGINCLUDEDIR = /usr/local/pgsql/include
> INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
> LIBDIR = /usr/local/pgsql/lib
> PKGLIBDIR = /usr/local/pgsql/lib
> LOCALEDIR = /usr/local/pgsql/share/locale
> MANDIR = /usr/local/pgsql/share/man
> SHAREDIR = /usr/local/pgsql/share
> SYSCONFDIR = /usr/local/pgsql/etc
> PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk
> CONFIGURE = '--with-libxml' '--with-libxslt' '--with-openssl'
> '--with-perl' '--with-python'
> CC = gcc
> CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2
> CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
> CFLAGS_SL = -fpic
> LDFLAGS = -Wl,--as-needed
> -Wl,-rpath,'/usr/local/pgsql/lib',--enable-new-dtags
> LDFLAGS_EX =
> LDFLAGS_SL =
> LIBS = -lpgport -lxslt -lxml2 -lssl -lcrypto -lz -lreadline -lcrypt -ldl
> -lm
> VERSION = PostgreSQL 9.0.4
> ---------------------------------------------
>
> Do you have any other ideas what may have gone wrong with my compile?
>

When you compile, do you have the -DSSL switch on the gcc lines?

--
Guillaume
http://www.postgresql.fr
http://dalibo.com