Re: Ubuntu natty and SSL connections

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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?

Thanks,
Andreas

On 05/16/2011 09:50 AM, Guillaume Lelarge wrote:
> Hi,
> 
> Le 05/15/2011 11:35 PM, Andreas Neumann a écrit :
>> [...]
>> I am running into issues with Ubuntu Natty (64bit) and SSL connections.
>> I first tried the version 1.12.2 which comes as a binary with Ubuntu.
>> The Combobox to select SSL is greyed out. Then I compiled 1.12.3 from
>> source, but SSL is still greyed out. The openssl package is installed -
>> is there another library or package I am missing?
>>
>> pg_config reports that SSL should be supported:
>>
>> CONFIGURE = '--with-libxml' '--with-libxslt' '--with-openssl'
>> '--with-perl' '--with-python'
>> LIBS = -lpgport -lxslt -lxml2 -lssl -lcrypto -lz -lreadline -lcrypt -ldl -lm
>>
>> $LD_LIBRARY_PATH is also set to /usr/local/pgsql/lib
>>
>> Thank you if you have any additional idea what I could try,
>>
> 
> It seems that configure thinks SSL support is missing. At the end of
> configure, you have some informations. You have a line which starts with
> "PostgreSQL SSL support". I bet it says no support.
> 
> 

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJN0XP/AAoJELiCsGDopvBCe/8IAKGSWF/6EEEDeqZO51EfpPGf
nZQoh2XJegxBiQGVh8bUsK3zAh98sKo554cXCvJBhxTLE2xJT2qCLvHyW5kuiSXs
Cj2vHojSwMWKoHIK1nluZ3AW/j3MnwMjezrBfF3MeKz2AShO5KpOskFqwXWV+lRz
KEQnSnt9sCXkU3TKIw1qy6u6ORpaLCPb32BBfSIaCkSl6FNKkBpQaOdHWHs1rDZh
I8CFHd/Woek17xeS/S5a1Hp3w8Jbbbij8UtGNXbi1A4JA15xPu+oOgXvzYRFhu0B
fhEcKgeCBDBqBdNnVaIIXJGWKsADa3nX/gQb+HHeL5eh/xI5/aqkZgekmUkxiyo=
=CXJX
-----END PGP SIGNATURE-----