Thread: compiling on debian does not find a valid PostgreSQL 8.4+ installati
Hi, in order to check an updated Italian translation, I would like to compile pgadmin3 on my Debian box. This is what happens: giuseppe@scarafaggio:~/src/cvs/pgadmin3$ ./configure --prefix=/usr/local/pgadmin3-1.14 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 PQexec in -lpq... no checking for PQconninfoParse in -lpq... no checking for krb5_free_principal in -lpq... no checking libpq-fe.h usability... yes checking libpq-fe.h presence... yes checking for libpq-fe.h... yes checking PostgreSQL in /usr... failed configure: error: you must specify a valid PostgreSQL 8.4+ installation with --with-pgsql=DIR I really do not understand what the problem is. I do have all packages for 8.4 and 9.0 installed, as shown here: Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Nome Versione Descrizione +++-===============================-===============================-============================================================================== ii postgresql-8.4 8.4.8-2 object-relational SQL database, version 8.4 server ii postgresql-9.0 9.0.4-1+b1 object-relational SQL database, version 9.0 server ii postgresql-client-8.4 8.4.8-2 front-end programs for PostgreSQL 8.4 ii postgresql-client-9.0 9.0.4-1+b1 front-end programs for PostgreSQL 9.0 ii postgresql-client-common 119 manager for multiple PostgreSQL client versions ii postgresql-common 119 PostgreSQL database-cluster manager ii postgresql-contrib 9.0.4-1 additional facilities for PostgreSQL (supported version) ii postgresql-contrib-8.4 8.4.8-2 additional facilities for PostgreSQL ii postgresql-contrib-9.0 9.0.4-1+b1 additional facilities for PostgreSQL ii postgresql-doc 9.0.4-1 documentation for the PostgreSQL database managementsystem ii postgresql-doc-9.0 9.0.4-1 documentation for the PostgreSQL database managementsystem Do you have any idea and what should I do? Thanks, Giuseppe
Hi, On Tue, 2011-08-16 at 07:31 +0200, Giuseppe Sacco wrote: > configure: error: you must specify a valid PostgreSQL 8.4+ > installation with --with-pgsql=DIR > > I really do not understand what the problem is. Message says it all: You need to add -with-pgsql=/path/to/postgresql/installation . I don't remember the path though. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati
From
Guillaume Lelarge
Date:
On Tue, 2011-08-16 at 09:00 +0300, Devrim GÜNDÜZ wrote: > Hi, > > On Tue, 2011-08-16 at 07:31 +0200, Giuseppe Sacco wrote: > > configure: error: you must specify a valid PostgreSQL 8.4+ > > installation with --with-pgsql=DIR > > > > I really do not understand what the problem is. > > Message says it all: You need to add > -with-pgsql=/path/to/postgresql/installation . I don't remember the path > though. > /usr/lib/postgresql/<version>/bin (so, for 8.4, it would be /usr/lib/postgresql/8.4/bin). I also noticed the OP doesn't have the -devel package. Not sure it's required, but I wouldn't be surprised if it is. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Il giorno mar, 16/08/2011 alle 09.00 +0300, Devrim GÜNDÜZ ha scritto: > Hi, > > On Tue, 2011-08-16 at 07:31 +0200, Giuseppe Sacco wrote: > > configure: error: you must specify a valid PostgreSQL 8.4+ > > installation with --with-pgsql=DIR > > > > I really do not understand what the problem is. > > Message says it all: You need to add > -with-pgsql=/path/to/postgresql/installation . I don't remember the path > though. How do I recognize that directory? I think it should be /usr/lib/postgresql/8.4 but this does not work. This is the content of /usr/lib/postgresql/8.4 (and 9.0 directory contains almost the same commands and libraries for postgresql 9.0): /usr/lib/postgresql/8.4/lib/dict_snowball.so /usr/lib/postgresql/8.4/lib/utf8_and_win.so /usr/lib/postgresql/8.4/lib/utf8_and_iso8859.so /usr/lib/postgresql/8.4/lib/ascii_and_mic.so /usr/lib/postgresql/8.4/lib/utf8_and_euc_kr.so /usr/lib/postgresql/8.4/lib/utf8_and_ascii.so /usr/lib/postgresql/8.4/lib/utf8_and_gbk.so /usr/lib/postgresql/8.4/lib/utf8_and_euc_jp.so /usr/lib/postgresql/8.4/lib/utf8_and_uhc.so /usr/lib/postgresql/8.4/lib/utf8_and_euc_cn.so /usr/lib/postgresql/8.4/lib/utf8_and_sjis.so /usr/lib/postgresql/8.4/lib/utf8_and_gb18030.so /usr/lib/postgresql/8.4/lib/tsearch2.so /usr/lib/postgresql/8.4/lib/utf8_and_euc_tw.so /usr/lib/postgresql/8.4/lib/utf8_and_cyrillic.so /usr/lib/postgresql/8.4/lib/plpgsql.so /usr/lib/postgresql/8.4/lib/latin_and_mic.so /usr/lib/postgresql/8.4/lib/utf8_and_johab.so /usr/lib/postgresql/8.4/lib/euc_cn_and_mic.so /usr/lib/postgresql/8.4/lib/latin2_and_win1250.so /usr/lib/postgresql/8.4/lib/euc_jp_and_sjis.so /usr/lib/postgresql/8.4/lib/utf8_and_iso8859_1.so /usr/lib/postgresql/8.4/lib/euc_kr_and_mic.so /usr/lib/postgresql/8.4/lib/euc_jis_2004_and_shift_jis_2004.so /usr/lib/postgresql/8.4/lib/cyrillic_and_mic.so /usr/lib/postgresql/8.4/lib/utf8_and_big5.so /usr/lib/postgresql/8.4/lib/euc_tw_and_big5.so /usr/lib/postgresql/8.4/lib/utf8_and_euc_jis_2004.so /usr/lib/postgresql/8.4/lib/utf8_and_shift_jis_2004.so /usr/lib/postgresql/8.4/bin /usr/lib/postgresql/8.4/bin/postgres /usr/lib/postgresql/8.4/bin/pg_controldata /usr/lib/postgresql/8.4/bin/initdb /usr/lib/postgresql/8.4/bin/pg_resetxlog /usr/lib/postgresql/8.4/bin/pg_ctl Please note that pg_config and other common commands are elsewhere: $ ls -1 /usr/bin/pg_* /usr/bin/pg_config /usr/bin/pg_config.libpq-dev /usr/bin/pg_createcluster /usr/bin/pg_ctlcluster /usr/bin/pg_dropcluster /usr/bin/pg_dump /usr/bin/pg_dumpall /usr/bin/pg_lsclusters /usr/bin/pg_restore /usr/bin/pg_upgradecluster Thanks, Giuseppe
Il giorno mar, 16/08/2011 alle 09.00 +0200, Guillaume Lelarge ha scritto: [...] > /usr/lib/postgresql/<version>/bin (so, for 8.4, it would > be /usr/lib/postgresql/8.4/bin). > > I also noticed the OP doesn't have the -devel package. Not sure it's > required, but I wouldn't be surprised if it is. I do get the same error: [...] checking for memmove... yes checking for memset... yes checking for strchr... yes configure: error: Could not find your PostgreSQL installation in /usr/lib/postgresql/8.4/bin thanks, Giuseppe
Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati
From
Guillaume Lelarge
Date:
On Tue, 2011-08-16 at 09:04 +0200, Giuseppe Sacco wrote: > Il giorno mar, 16/08/2011 alle 09.00 +0300, Devrim GÜNDÜZ ha scritto: > > Hi, > > > > On Tue, 2011-08-16 at 07:31 +0200, Giuseppe Sacco wrote: > > > configure: error: you must specify a valid PostgreSQL 8.4+ > > > installation with --with-pgsql=DIR > > > > > > I really do not understand what the problem is. > > > > Message says it all: You need to add > > -with-pgsql=/path/to/postgresql/installation . I don't remember the path > > though. > > How do I recognize that directory? I think it should > be /usr/lib/postgresql/8.4 but this does not work. > It is. If it does not work, what error message do you have? > This is the content of /usr/lib/postgresql/8.4 (and 9.0 directory > contains almost the same commands and libraries for postgresql 9.0): > > /usr/lib/postgresql/8.4/lib/dict_snowball.so > /usr/lib/postgresql/8.4/lib/utf8_and_win.so > /usr/lib/postgresql/8.4/lib/utf8_and_iso8859.so > /usr/lib/postgresql/8.4/lib/ascii_and_mic.so > /usr/lib/postgresql/8.4/lib/utf8_and_euc_kr.so > /usr/lib/postgresql/8.4/lib/utf8_and_ascii.so > /usr/lib/postgresql/8.4/lib/utf8_and_gbk.so > /usr/lib/postgresql/8.4/lib/utf8_and_euc_jp.so > /usr/lib/postgresql/8.4/lib/utf8_and_uhc.so > /usr/lib/postgresql/8.4/lib/utf8_and_euc_cn.so > /usr/lib/postgresql/8.4/lib/utf8_and_sjis.so > /usr/lib/postgresql/8.4/lib/utf8_and_gb18030.so > /usr/lib/postgresql/8.4/lib/tsearch2.so > /usr/lib/postgresql/8.4/lib/utf8_and_euc_tw.so > /usr/lib/postgresql/8.4/lib/utf8_and_cyrillic.so > /usr/lib/postgresql/8.4/lib/plpgsql.so > /usr/lib/postgresql/8.4/lib/latin_and_mic.so > /usr/lib/postgresql/8.4/lib/utf8_and_johab.so > /usr/lib/postgresql/8.4/lib/euc_cn_and_mic.so > /usr/lib/postgresql/8.4/lib/latin2_and_win1250.so > /usr/lib/postgresql/8.4/lib/euc_jp_and_sjis.so > /usr/lib/postgresql/8.4/lib/utf8_and_iso8859_1.so > /usr/lib/postgresql/8.4/lib/euc_kr_and_mic.so > /usr/lib/postgresql/8.4/lib/euc_jis_2004_and_shift_jis_2004.so > /usr/lib/postgresql/8.4/lib/cyrillic_and_mic.so > /usr/lib/postgresql/8.4/lib/utf8_and_big5.so > /usr/lib/postgresql/8.4/lib/euc_tw_and_big5.so > /usr/lib/postgresql/8.4/lib/utf8_and_euc_jis_2004.so > /usr/lib/postgresql/8.4/lib/utf8_and_shift_jis_2004.so > /usr/lib/postgresql/8.4/bin > /usr/lib/postgresql/8.4/bin/postgres > /usr/lib/postgresql/8.4/bin/pg_controldata > /usr/lib/postgresql/8.4/bin/initdb > /usr/lib/postgresql/8.4/bin/pg_resetxlog > /usr/lib/postgresql/8.4/bin/pg_ctl > > Please note that pg_config and other common commands are elsewhere: > > $ ls -1 /usr/bin/pg_* > /usr/bin/pg_config > /usr/bin/pg_config.libpq-dev > /usr/bin/pg_createcluster > /usr/bin/pg_ctlcluster > /usr/bin/pg_dropcluster > /usr/bin/pg_dump > /usr/bin/pg_dumpall > /usr/bin/pg_lsclusters > /usr/bin/pg_restore > /usr/bin/pg_upgradecluster > No. Those are wrappers, not the real command. For example: guillaume@somewhere:~$ ll /usr/bin/psql lrwxrwxrwx 1 root root 37 jan 2 2011 /usr/bin/psql -> ../share/postgresql-common/pg_wrapper -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati
From
Guillaume Lelarge
Date:
On Tue, 2011-08-16 at 09:05 +0200, Giuseppe Sacco wrote: > Il giorno mar, 16/08/2011 alle 09.00 +0200, Guillaume Lelarge ha > scritto: > [...] > > /usr/lib/postgresql/<version>/bin (so, for 8.4, it would > > be /usr/lib/postgresql/8.4/bin). > > > > I also noticed the OP doesn't have the -devel package. Not sure it's > > required, but I wouldn't be surprised if it is. > > I do get the same error: > > [...] > checking for memmove... yes > checking for memset... yes > checking for strchr... yes > configure: error: Could not find your PostgreSQL installation > in /usr/lib/postgresql/8.4/bin > Did you install the -devel package? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha scritto: > On Tue, 2011-08-16 at 09:05 +0200, Giuseppe Sacco wrote: [...] > Did you install the -devel package? there is no such package: $ apt-cache search postgresql | grep -- -devel $ Thanks again, Giuseppe
Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha scritto: [...] > > How do I recognize that directory? I think it should > > be /usr/lib/postgresql/8.4 but this does not work. > > > > It is. If it does not work, what error message do you have? $ ./configure --prefix=/usr/local/pgadmin3-1.14 --with-pgsql=/usr/lib/postgresql/8.4/bin checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu [...] checking for memmove... yes checking for memset... yes checking for strchr... yes configure: error: Could not find your PostgreSQL installation in /usr/lib/postgresql/8.4/bin [...] > > $ ls -1 /usr/bin/pg_* > > /usr/bin/pg_config > > /usr/bin/pg_config.libpq-dev > > /usr/bin/pg_createcluster > > /usr/bin/pg_ctlcluster > > /usr/bin/pg_dropcluster > > /usr/bin/pg_dump > > /usr/bin/pg_dumpall > > /usr/bin/pg_lsclusters > > /usr/bin/pg_restore > > /usr/bin/pg_upgradecluster > > > > No. Those are wrappers, not the real command. For example: > > guillaume@somewhere:~$ ll /usr/bin/psql > lrwxrwxrwx 1 root root 37 jan 2 2011 /usr/bin/psql > -> ../share/postgresql-common/pg_wrapper some of them are linl to pg_wrapper, some aren't. For instance pg_config isn't: $ ls -l /usr/bin/pg_* -rwxr-xr-x 1 root root 1123 29 mag 19.18 /usr/bin/pg_config -rwxr-xr-x 1 root root 26008 4 mag 03.00 /usr/bin/pg_config.libpq-dev -rwxr-xr-x 1 root root 22799 8 ago 13.27 /usr/bin/pg_createcluster -rwxr-xr-x 1 root root 15488 24 ott 2010 /usr/bin/pg_ctlcluster -rwxr-xr-x 1 root root 4013 5 ago 2010 /usr/bin/pg_dropcluster lrwxrwxrwx 1 root root 37 8 ago 15.35 /usr/bin/pg_dump -> ../share/postgresql-common/pg_wrapper lrwxrwxrwx 1 root root 37 8 ago 15.35 /usr/bin/pg_dumpall -> ../share/postgresql-common/pg_wrapper -rwxr-xr-x 1 root root 1858 5 ago 2010 /usr/bin/pg_lsclusters lrwxrwxrwx 1 root root 37 8 ago 15.35 /usr/bin/pg_restore -> ../share/postgresql-common/pg_wrapper -rwxr-xr-x 1 root root 23356 4 ago 18.02 /usr/bin/pg_upgradecluster Bye, Giuseppe
Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati
From
Guillaume Lelarge
Date:
On Tue, 2011-08-16 at 09:17 +0200, Giuseppe Sacco wrote: > Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha > scritto: > [...] > > > How do I recognize that directory? I think it should > > > be /usr/lib/postgresql/8.4 but this does not work. > > > > > > > It is. If it does not work, what error message do you have? > > $ ./configure --prefix=/usr/local/pgadmin3-1.14 > --with-pgsql=/usr/lib/postgresql/8.4/bin > checking build system type... i686-pc-linux-gnu > checking host system type... i686-pc-linux-gnu > [...] > checking for memmove... yes > checking for memset... yes > checking for strchr... yes > configure: error: Could not find your PostgreSQL installation in /usr/lib/postgresql/8.4/bin > Yeah, I was wrong, it should be /usr/lib/postgresql/8.4, not /usr/lib/postgresql/8.4/bin. > [...] > > > $ ls -1 /usr/bin/pg_* > > > /usr/bin/pg_config > > > /usr/bin/pg_config.libpq-dev > > > /usr/bin/pg_createcluster > > > /usr/bin/pg_ctlcluster > > > /usr/bin/pg_dropcluster > > > /usr/bin/pg_dump > > > /usr/bin/pg_dumpall > > > /usr/bin/pg_lsclusters > > > /usr/bin/pg_restore > > > /usr/bin/pg_upgradecluster > > > > > > > No. Those are wrappers, not the real command. For example: > > > > guillaume@somewhere:~$ ll /usr/bin/psql > > lrwxrwxrwx 1 root root 37 jan 2 2011 /usr/bin/psql > > -> ../share/postgresql-common/pg_wrapper > > some of them are linl to pg_wrapper, some aren't. For instance pg_config > isn't: > $ ls -l /usr/bin/pg_* > -rwxr-xr-x 1 root root 1123 29 mag 19.18 /usr/bin/pg_config > -rwxr-xr-x 1 root root 26008 4 mag 03.00 /usr/bin/pg_config.libpq-dev > -rwxr-xr-x 1 root root 22799 8 ago 13.27 /usr/bin/pg_createcluster > -rwxr-xr-x 1 root root 15488 24 ott 2010 /usr/bin/pg_ctlcluster > -rwxr-xr-x 1 root root 4013 5 ago 2010 /usr/bin/pg_dropcluster > lrwxrwxrwx 1 root root 37 8 ago 15.35 /usr/bin/pg_dump -> ../share/postgresql-common/pg_wrapper > lrwxrwxrwx 1 root root 37 8 ago 15.35 /usr/bin/pg_dumpall -> ../share/postgresql-common/pg_wrapper > -rwxr-xr-x 1 root root 1858 5 ago 2010 /usr/bin/pg_lsclusters > lrwxrwxrwx 1 root root 37 8 ago 15.35 /usr/bin/pg_restore -> ../share/postgresql-common/pg_wrapper > -rwxr-xr-x 1 root root 23356 4 ago 18.02 /usr/bin/pg_upgradecluster > Really strange that pg_config is not a wrapper there. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati
From
Guillaume Lelarge
Date:
On Tue, 2011-08-16 at 09:14 +0200, Giuseppe Sacco wrote: > Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha > scritto: > > On Tue, 2011-08-16 at 09:05 +0200, Giuseppe Sacco wrote: > [...] > > Did you install the -devel package? > > there is no such package: > $ apt-cache search postgresql | grep -- -devel > $ > Sorry, I meant libpq-dev. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Il giorno mar, 16/08/2011 alle 09.32 +0200, Guillaume Lelarge ha scritto: > On Tue, 2011-08-16 at 09:14 +0200, Giuseppe Sacco wrote: > > Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha > > scritto: > > > On Tue, 2011-08-16 at 09:05 +0200, Giuseppe Sacco wrote: > > [...] > > > Did you install the -devel package? > > > > there is no such package: > > $ apt-cache search postgresql | grep -- -devel > > $ > > > > Sorry, I meant libpq-dev. Sure, libpq-dev is installed, but I still get the error. Just to recap: List of installed packages: ii libpq-dev 9.0.4-1+b1 header files for libpq5 (PostgreSQL library) ii libpq5 9.0.4-1+b1 PostgreSQL C client library ii postgresql-8.4 8.4.8-2 object-relational SQL database, version8.4 server ii postgresql-9.0 9.0.4-1+b1 object-relational SQL database, version9.0 server ii postgresql-client-8.4 8.4.8-2 front-end programs for PostgreSQL 8.4 ii postgresql-client-9.0 9.0.4-1+b1 front-end programs for PostgreSQL 9.0 ii postgresql-client-common 119 manager for multiple PostgreSQL clientversions ii postgresql-common 119 PostgreSQL database-cluster manager ii postgresql-contrib 9.0.4-1 additional facilities for PostgreSQL(supported version) ii postgresql-contrib-8.4 8.4.8-2 additional facilities for PostgreSQL ii postgresql-contrib-9.0 9.0.4-1+b1 additional facilities for PostgreSQL The configure command, that fail, is: $ ./configure --prefix=/usr/local/pgadmin3-1.14 --with-pgsql=/usr/lib/postgresql/8.4 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 for memmove... yes checking for memset... yes checking for strchr... yes configure: error: Could not find your PostgreSQL installation in /usr/lib/postgresql/8.4 Please note that it stop after strchr. If I do not specify --with-pgsql it goes a little bit further an change error message: checking for memmove... yes checking for memset... yes checking for strchr... yes checking for SSL_library_init in -lssl... no checking for krb5_sendauth in -lkrb5... yes checking for PQexec in -lpq... no checking for PQconninfoParse in -lpq... no checking for krb5_free_principal in -lpq... no checking libpq-fe.h usability... yes checking libpq-fe.h presence... yes checking for libpq-fe.h... yes checking PostgreSQL in /usr... failed configure: error: you must specify a valid PostgreSQL 8.4+ installation with --with-pgsql=DIR So, I do think the first error is wrong and should probably be somethig related to SSL. The second is probably looking for something different. Bye, Giuseppe
Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati
From
Guillaume Lelarge
Date:
On Tue, 2011-08-16 at 11:58 +0200, Giuseppe Sacco wrote:
> Il giorno mar, 16/08/2011 alle 09.32 +0200, Guillaume Lelarge ha
> scritto:
> > On Tue, 2011-08-16 at 09:14 +0200, Giuseppe Sacco wrote:
> > > Il giorno mar, 16/08/2011 alle 09.09 +0200, Guillaume Lelarge ha
> > > scritto:
> > > > On Tue, 2011-08-16 at 09:05 +0200, Giuseppe Sacco wrote:
> > > [...]
> > > > Did you install the -devel package?
> > >
> > > there is no such package:
> > > $ apt-cache search postgresql | grep -- -devel
> > > $
> > >
> >
> > Sorry, I meant libpq-dev.
>
> Sure, libpq-dev is installed, but I still get the error. Just to recap:
>
> List of installed packages:
> ii libpq-dev 9.0.4-1+b1 header files for libpq5
(PostgreSQLlibrary)
> ii libpq5 9.0.4-1+b1 PostgreSQL C client library
> ii postgresql-8.4 8.4.8-2 object-relational SQL database,
version8.4 server
> ii postgresql-9.0 9.0.4-1+b1 object-relational SQL database,
version9.0 server
> ii postgresql-client-8.4 8.4.8-2 front-end programs for PostgreSQL
8.4
> ii postgresql-client-9.0 9.0.4-1+b1 front-end programs for PostgreSQL
9.0
> ii postgresql-client-common 119 manager for multiple PostgreSQL
clientversions
> ii postgresql-common 119 PostgreSQL database-cluster
manager
> ii postgresql-contrib 9.0.4-1 additional facilities for
PostgreSQL(supported version)
> ii postgresql-contrib-8.4 8.4.8-2 additional facilities for
PostgreSQL
> ii postgresql-contrib-9.0 9.0.4-1+b1 additional facilities for
PostgreSQL
>
>
> The configure command, that fail, is:
> $ ./configure --prefix=/usr/local/pgadmin3-1.14 --with-pgsql=/usr/lib/postgresql/8.4
> 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 for memmove... yes
> checking for memset... yes
> checking for strchr... yes
> configure: error: Could not find your PostgreSQL installation in /usr/lib/postgresql/8.4
>
> Please note that it stop after strchr. If I do not specify --with-pgsql
> it goes a little bit further an change error message:
>
> checking for memmove... yes
> checking for memset... yes
> checking for strchr... yes
> checking for SSL_library_init in -lssl... no
> checking for krb5_sendauth in -lkrb5... yes
> checking for PQexec in -lpq... no
> checking for PQconninfoParse in -lpq... no
> checking for krb5_free_principal in -lpq... no
> checking libpq-fe.h usability... yes
> checking libpq-fe.h presence... yes
> checking for libpq-fe.h... yes
> checking PostgreSQL in /usr... failed
> configure: error: you must specify a valid PostgreSQL 8.4+ installation with --with-pgsql=DIR
>
> So, I do think the first error is wrong and should probably be somethig
> related to SSL. The second is probably looking for something different.
>
OK, now that I got some time to install debian 6 on a VM, here are my
steps to compile pgAdmin:
# install PostgreSQL and its -dev package (-contrib is not required)
aptitude install postgresql-8.4 \ postgresql-client-8.4 \ postgresql-contrib-8.4 \
postgresql-server-dev-8.4
# install the build tools
aptitude install gcc g++ make git autoconf
# install the required libraries (wxWidgets, libxml, and libxslt)
aptitude install libwxgtk2.8-0 libwxgtk2.8-dev libxml2-dev libxslt-dev
# get the source
git clone git://git.postgresql.org/git/pgadmin3.git
# configure
./configure --prefix=/usr/local/pgadmin3-1.14
I didn't continue further as the configure step was your issue. I guess
your issue is that you don't have the postgresql-server-dev-8.4 (or
postgresql-server-dev-9.0).
Hope it helps you to solve your issues.
--
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Hi Guillaume,
thanks for spending your time on this topic. I was really missing both
packages postgresql-server-dev-{8.4,9.0}, but even after installing
them, I still get the same error:
$ ./configure --prefix=/usr/local/pgadmin3-1.14
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 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 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... no
checking for krb5_sendauth in -lkrb5... yes
checking for PQexec in -lpq... no
checking for PQconninfoParse in -lpq... no
checking for krb5_free_principal in -lpq... no
checking libpq-fe.h usability... yes
checking libpq-fe.h presence... yes
checking for libpq-fe.h... yes
checking PostgreSQL in /usr... failed
configure: error: you must specify a valid PostgreSQL 8.4+ installation with --with-pgsql=DIR
I read that you tried on debian 6, while I am compiling in unstable. I
prefer unstable since current unstable will be the next stable realease,
the first one that will ship with pgadmin 1.14.
I did not have much time for finding a solution. I will try to work it
out today or tomorrow.
Bye,
Giuseppe
On Wed, Aug 24, 2011 at 9:19 AM, Giuseppe Sacco
<giuseppe@eppesuigoccas.homedns.org> wrote:
> Hi Guillaume,
> thanks for spending your time on this topic. I was really missing both
> packages postgresql-server-dev-{8.4,9.0}, but even after installing
> them, I still get the same error:
...
> I read that you tried on debian 6, while I am compiling in unstable. I
> prefer unstable since current unstable will be the next stable realease,
> the first one that will ship with pgadmin 1.14.
>
> I did not have much time for finding a solution. I will try to work it
> out today or tomorrow.
There are almost certainly some clues in config.log...
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Il giorno mer, 24/08/2011 alle 09.26 +0100, Dave Page ha scritto: [...] > > I did not have much time for finding a solution. I will try to work it > > out today or tomorrow. > > There are almost certainly some clues in config.log... Config log show something about ssl: it seems libpq is detected but not usable since configure cannot compile with it. libpq require ssl, and I have openssl 1.0.0d instead of older version. From error messages it seems libpq cannot work with this version of openssl. Is this true at all? Thanks, Giuseppe
On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org> wrote: > Il giorno mer, 24/08/2011 alle 09.26 +0100, Dave Page ha scritto: > [...] >> > I did not have much time for finding a solution. I will try to work it >> > out today or tomorrow. >> >> There are almost certainly some clues in config.log... > > Config log show something about ssl: it seems libpq is detected but not > usable since configure cannot compile with it. libpq require ssl, and I > have openssl 1.0.0d instead of older version. From error messages it > seems libpq cannot work with this version of openssl. Is this true at > all? Doubtful, unless the Debian package is horribly broken. What's the error? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Il giorno mer, 24/08/2011 alle 10.04 +0100, Dave Page ha scritto:
> On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco
[...]
> > Config log show something about ssl: it seems libpq is detected but not
> > usable since configure cannot compile with it. libpq require ssl, and I
> > have openssl 1.0.0d instead of older version. From error messages it
> > seems libpq cannot work with this version of openssl. Is this true at
> > all?
>
> Doubtful, unless the Debian package is horribly broken. What's the error?
$ ls -l /usr/lib/libssl*
-rw-r--r-- 1 root root 431786 13 giu 14.03 /usr/lib/libssl.a
lrwxrwxrwx 1 root root 15 13 giu 14.03 /usr/lib/libssl.so -> libssl.so.1.0.0
-rw-r--r-- 1 root root 302608 6 apr 20.01 /usr/lib/libssl.so.0.9.8
-rw-r--r-- 1 root root 312588 13 giu 14.03 /usr/lib/libssl.so.1.0.0
$ dpkg -S /usr/lib/libssl.so.1.0.0
libssl1.0.0: /usr/lib/libssl.so.1.0.0
$ dpkg -l libssl-dev libssl0.9.8 libssl1.0.0 openssl
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Nome Versione Descrizione
+++-==========================-==========================-====================================================================
ii libssl-dev 1.0.0d-3 SSL development libraries, header files and documentation
ii libssl0.9.8 0.9.8o-7 SSL shared libraries
ii libssl1.0.0 1.0.0d-3 SSL shared libraries
ii openssl 1.0.0d-3 Secure Socket Layer (SSL) binary and related cryptographic
tools
So I do have both libssl installed. The default one is 1.0.0d. include files are from 1.0.0d.
This is the part of ssl check in config.log. Later on, when checking for
lipq, the list of errors is almost the same. I think (at least a few of)
these errors could be solved linking with libcrypto.so as well.
configure:5403: checking for SSL_library_init in -lssl
configure:5428: gcc -o conftest -g -O2 conftest.c -lssl >&5
/usr/lib/libssl.so: undefined reference to `BIO_pop@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CipherInit_ex@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BUF_memdup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_CTX_copy@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_shift@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_get_ex_new_index@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_rc2_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `DH_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_encrypt_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_VERIFY_PARAM_get_depth@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `PEM_read_bio_PrivateKey@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_get_ex_data@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_get_subject_name@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_peek@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `PEM_ASN1_write_bio@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ERR_load_strings@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_get_digestbyname@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_assign@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_GROUP_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_f_buffer@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_flags@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `DH_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RAND_pseudo_bytes@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_verify@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `i2d_ASN1_OCTET_STRING@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_set@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ERR_clear_error@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_num@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OBJ_NAME_add@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DigestInit@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_VERIFY_PARAM_set_trust@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `lh_delete@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_find@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_clear_flags@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_VERIFY_PARAM_set_purpose@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_EncryptInit_ex@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OBJ_nid2sn@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_up_ref@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_verify@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ERR_peek_error@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BN_num_bits@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_sha384@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_CTX_get_ex_new_index@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_set_flags@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_dup_ex_data@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_CTX_cleanup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_set_public_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DigestUpdate@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_private_decrypt@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_decrypt_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_add_cipher@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_VERIFY_PARAM_set1@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BUF_MEM_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_EncryptFinal@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_copy_parameters@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_zero@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_sort@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_missing_parameters@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_asn1_find_str@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `i2d_ASN1_INTEGER@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_free_ex_data@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_ecdsa@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_POINT_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BN_CTX_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_verify_cert_error_string@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `DHparams_dup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_s_file@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `HMAC_Update@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BN_bin2bn@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DigestSignInit@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `PEM_ASN1_write@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ECDSA_sign@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_camellia_128_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ASN1_const_check_infinite_end@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_int_ctrl@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_encrypt@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_s_mem@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_sha512@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `HMAC_CTX_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_dup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_aes_256_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CIPHER_CTX_cleanup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_size@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BUF_MEM_grow@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_sign_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BN_dup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DigestFinal_ex@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OBJ_bsearch_@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_seed_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_rc4@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_des_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_METHOD_get_field_type@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OPENSSL_DIR_end@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_find@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ECDH_compute_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_CTX_destroy@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_RSAPrivateKey_bio@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_CTX_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_CTX_set_verify_cb@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_puts@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_mem_ctrl@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_next@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `HMAC_Final@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_add_lock@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `i2d_X509_NAME@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `i2d_OCSP_RESPID@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ERR_peek_last_error@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DigestInit_ex@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_s_connect@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `DH_generate_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_CTX_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `PEM_ASN1_read_bio@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `COMP_CTX_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_set_ex_data@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `i2d_X509@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_NAME_cmp@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `lh_doall_arg@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_iterator@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_X509_EXTENSIONS@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ENGINE_get_ssl_client_cert_function@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_CTX_md@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `i2d_X509_EXTENSIONS@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CIPHER_iv_length@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_method_type@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_new_ex_data@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DigestSignFinal@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ERR_add_error_data@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_get0_group@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_GROUP_get_degree@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RAND_add@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CIPHER_flags@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_GROUP_get_curve_name@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_sha224@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_aes_192_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `COMP_zlib@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_copy_next_retry@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ERR_func_error_string@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `asn1_const_Finish@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_find_type@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_set_group@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_decrypt@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_insert@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_load_locations@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ERR_put_error@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `asn1_GetSequence@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_snprintf@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_public_encrypt@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_up_ref@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BUF_MEM_grow_clean@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_dss1@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSAPrivateKey_dup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OPENSSL_cleanse@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ERR_load_crypto_strings@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ASN1_INTEGER_get@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `asn1_add_error@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ASN1_get_object@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_test_flags@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `PEM_read_bio_RSAPrivateKey@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ASN1_object_size@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_pop_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_VerifyFinal@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_EXTENSION_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pitem_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DecryptUpdate@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_dup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_certificate_type@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BUF_strndup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_read@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `lh_num_items@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BUF_strdup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `DH_size@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `lh_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_CTX_set_default@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ENGINE_load_ssl_client_cert@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OBJ_nid2ln@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_size@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `DH_compute_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ENGINE_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_POINT_copy@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_sign@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BN_CTX_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `PEM_read_bio_X509_AUX@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_asn1_get0_info@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pqueue_pop@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_GROUP_new_by_curve_name@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_push@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_get_retry_reason@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_sign@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_CTX_cleanup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_type@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OPENSSL_DIR_read@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `pitem_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_VERIFY_PARAM_inherit@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `COMP_expand_block@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `HMAC_CTX_cleanup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_POINT_oct2point@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `lh_retrieve@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_value@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `PEM_ASN1_read@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ASN1_INTEGER_set@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `DSA_sign@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `HMAC_Init_ex@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_size@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_set_default_paths@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_PrivateKey_bio@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DecryptFinal@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_ASN1_OCTET_STRING@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_write@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_s_socket@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_set_cmp_func@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_PrivateKey@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_callback_ctrl@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_check_purpose@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_CTX_set_ex_data@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_des_ede3_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_malloc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `lh_insert@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_DecryptInit_ex@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_printf@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_ASN1_INTEGER@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_push@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_verify_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_VERIFY_PARAM_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ASN1_put_object@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CIPHER_CTX_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_Digest@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_CTX_get0_param@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RAND_bytes@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_OCSP_RESPID@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_VERIFY_PARAM_set_depth@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ECDSA_verify@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BN_bn2bin@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CIPHER_CTX_cipher@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_free_all@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_CTX_init@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_enc_null@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_get0_public_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_POINT_point2oct@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_bits@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_Cipher@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_generate_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_dump_indent@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_RSAPrivateKey@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BUF_MEM_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CIPHER_CTX_iv_length@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_CTX_create@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_get0_private_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_SignFinal@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_POINT_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `ENGINE_finish@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `CRYPTO_lock@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_add_digest@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_aes_128_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_ctrl@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OCSP_RESPID_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BN_clear_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_VERIFY_PARAM_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_CTX_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_verify_cert@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_camellia_256_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_sha256@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `lh_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_new_mac_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_rc2_40_cbc@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `COMP_compress_block@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_MD_CTX_copy_ex@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CIPHER_block_size@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `sk_new_null@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_NAME_dup@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OBJ_obj2nid@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `BIO_new@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EC_KEY_set_private_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_get_pubkey@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `RSA_size@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_get_cipherbyname@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_CTX_ctrl@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_EncryptUpdate@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_X509_bio@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_STORE_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `COMP_CTX_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_NAME_free@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_sha1@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_CIPHER_key_length@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_X509@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `d2i_X509_NAME@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_PKEY_derive_set_peer@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `PEM_read_bio_X509@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `OpenSSLDie@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `DSA_verify@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `X509_check_private_key@OPENSSL_1.0.0'
/usr/lib/libssl.so: undefined reference to `EVP_md5@OPENSSL_1.0.0'
collect2: ld returned 1 exit status
configure:5428: $? = 1
configure: failed program was:
| /* confdefs.h */
| #define PACKAGE_NAME "pgadmin3"
| #define PACKAGE_TARNAME "pgadmin3"
| #define PACKAGE_VERSION "1.15.0-dev"
| #define PACKAGE_STRING "pgadmin3 1.15.0-dev"
| #define PACKAGE_BUGREPORT "pgadmin-support@postgresql.org"
| #define PACKAGE_URL ""
| #define PACKAGE "pgadmin3"
| #define VERSION "1.15.0-dev"
| #define STDC_HEADERS 1
| #define HAVE_SYS_TYPES_H 1
| #define HAVE_SYS_STAT_H 1
| #define HAVE_STDLIB_H 1
| #define HAVE_STRING_H 1
| #define HAVE_MEMORY_H 1
| #define HAVE_STRINGS_H 1
| #define HAVE_INTTYPES_H 1
| #define HAVE_STDINT_H 1
| #define HAVE_UNISTD_H 1
| #define HAVE_ARPA_INET_H 1
| #define HAVE_NETDB_H 1
| #define HAVE_NETINET_IN_H 1
| #define HAVE_STDLIB_H 1
| #define HAVE__BOOL 1
| #define HAVE_STDBOOL_H 1
| #define TIME_WITH_SYS_TIME 1
| #define HAVE_GETHOSTBYNAME 1
| #define HAVE_INET_NTOA 1
| #define HAVE_MEMMOVE 1
| #define HAVE_MEMSET 1
| #define HAVE_STRCHR 1
| /* end confdefs.h. */
|
| /* Override any GCC internal prototype to avoid an error.
| Use char because int might match the return type of a GCC
| builtin and then its argument prototype would still apply. */
| #ifdef __cplusplus
| extern "C"
| #endif
| char SSL_library_init ();
| int
| main ()
| {
| return SSL_library_init ();
| ;
| return 0;
| }
configure:5437: result: no
On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org> wrote: > Il giorno mer, 24/08/2011 alle 10.04 +0100, Dave Page ha scritto: >> On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco > [...] >> > Config log show something about ssl: it seems libpq is detected but not >> > usable since configure cannot compile with it. libpq require ssl, and I >> > have openssl 1.0.0d instead of older version. From error messages it >> > seems libpq cannot work with this version of openssl. Is this true at >> > all? >> >> Doubtful, unless the Debian package is horribly broken. What's the error? > > $ ls -l /usr/lib/libssl* > -rw-r--r-- 1 root root 431786 13 giu 14.03 /usr/lib/libssl.a > lrwxrwxrwx 1 root root 15 13 giu 14.03 /usr/lib/libssl.so -> libssl.so.1.0.0 > -rw-r--r-- 1 root root 302608 6 apr 20.01 /usr/lib/libssl.so.0.9.8 > -rw-r--r-- 1 root root 312588 13 giu 14.03 /usr/lib/libssl.so.1.0.0 > $ dpkg -S /usr/lib/libssl.so.1.0.0 > libssl1.0.0: /usr/lib/libssl.so.1.0.0 > $ dpkg -l libssl-dev libssl0.9.8 libssl1.0.0 openssl > Desired=Unknown/Install/Remove/Purge/Hold > | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend > |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) > ||/ Nome Versione Descrizione > +++-==========================-==========================-==================================================================== > ii libssl-dev 1.0.0d-3 SSL development libraries, header files and documentation > ii libssl0.9.8 0.9.8o-7 SSL shared libraries > ii libssl1.0.0 1.0.0d-3 SSL shared libraries > ii openssl 1.0.0d-3 Secure Socket Layer (SSL) binary and related cryptographic tools > > So I do have both libssl installed. The default one is 1.0.0d. include files are from 1.0.0d. > > This is the part of ssl check in config.log. Later on, when checking for > lipq, the list of errors is almost the same. I think (at least a few of) > these errors could be solved linking with libcrypto.so as well. > > configure:5403: checking for SSL_library_init in -lssl > configure:5428: gcc -o conftest -g -O2 conftest.c -lssl >&5 > /usr/lib/libssl.so: undefined reference to `BIO_pop@OPENSSL_1.0.0' > /usr/lib/libssl.so: undefined reference to `EVP_CipherInit_ex@OPENSSL_1.0.0' <snip> What version of SSL is your libpq compiled against? You can use 'ldd' to find out. On squeeze, PG 8.4 appears to use 0.9.8. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati
From
Guillaume Lelarge
Date:
On Wed, 2011-08-24 at 10:19 +0200, Giuseppe Sacco wrote:
> Hi Guillaume,
> thanks for spending your time on this topic. I was really missing both
> packages postgresql-server-dev-{8.4,9.0}, but even after installing
> them, I still get the same error:
>
> $ ./configure --prefix=/usr/local/pgadmin3-1.14
> 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 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 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... no
> checking for krb5_sendauth in -lkrb5... yes
> checking for PQexec in -lpq... no
> checking for PQconninfoParse in -lpq... no
> checking for krb5_free_principal in -lpq... no
> checking libpq-fe.h usability... yes
> checking libpq-fe.h presence... yes
> checking for libpq-fe.h... yes
> checking PostgreSQL in /usr... failed
> configure: error: you must specify a valid PostgreSQL 8.4+ installation with --with-pgsql=DIR
>
> I read that you tried on debian 6, while I am compiling in unstable. I
> prefer unstable since current unstable will be the next stable realease,
> the first one that will ship with pgadmin 1.14.
>
So I moved to unstable (change /etc/apt/sources.list, then aptitude
update, aptitude full-upgrade).
No issues whatsoever.
I also installed postgresql-9.0, recloned the git, get the
REL-1_14_0_PATCHES branch, try with the 1.14RC1 package on
postgresql.org. Everything works out of the box with a simple
"./configure --prefix=/whatever" command.
I don't see what else I can do. There must be something weird on your
side.
--
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Re: compiling on debian does not find a valid PostgreSQL 8.4+ installati
From
Guillaume Lelarge
Date:
On Wed, 2011-08-24 at 11:00 +0100, Dave Page wrote: > On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco > <giuseppe@eppesuigoccas.homedns.org> wrote: > > Il giorno mer, 24/08/2011 alle 10.04 +0100, Dave Page ha scritto: > >> On Wed, Aug 24, 2011 at 9:54 AM, Giuseppe Sacco > > [...] > >> > Config log show something about ssl: it seems libpq is detected but not > >> > usable since configure cannot compile with it. libpq require ssl, and I > >> > have openssl 1.0.0d instead of older version. From error messages it > >> > seems libpq cannot work with this version of openssl. Is this true at > >> > all? > >> > >> Doubtful, unless the Debian package is horribly broken. What's the error? > > > > $ ls -l /usr/lib/libssl* > > -rw-r--r-- 1 root root 431786 13 giu 14.03 /usr/lib/libssl.a > > lrwxrwxrwx 1 root root 15 13 giu 14.03 /usr/lib/libssl.so -> libssl.so.1.0.0 > > -rw-r--r-- 1 root root 302608 6 apr 20.01 /usr/lib/libssl.so.0.9.8 > > -rw-r--r-- 1 root root 312588 13 giu 14.03 /usr/lib/libssl.so.1.0.0 Same as mine. > > $ dpkg -S /usr/lib/libssl.so.1.0.0 > > libssl1.0.0: /usr/lib/libssl.so.1.0.0 > > $ dpkg -l libssl-dev libssl0.9.8 libssl1.0.0 openssl > > Desired=Unknown/Install/Remove/Purge/Hold > > | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend > > |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) > > ||/ Nome Versione Descrizione > > +++-==========================-==========================-==================================================================== > > ii libssl-dev 1.0.0d-3 SSL development libraries, header files and documentation > > ii libssl0.9.8 0.9.8o-7 SSL shared libraries > > ii libssl1.0.0 1.0.0d-3 SSL shared libraries > > ii openssl 1.0.0d-3 Secure Socket Layer (SSL) binary and related cryptographictools > > Same as mine. > > So I do have both libssl installed. The default one is 1.0.0d. include files are from 1.0.0d. > > > > This is the part of ssl check in config.log. Later on, when checking for > > lipq, the list of errors is almost the same. I think (at least a few of) > > these errors could be solved linking with libcrypto.so as well. > > > > configure:5403: checking for SSL_library_init in -lssl > > configure:5428: gcc -o conftest -g -O2 conftest.c -lssl >&5 > > /usr/lib/libssl.so: undefined reference to `BIO_pop@OPENSSL_1.0.0' > > /usr/lib/libssl.so: undefined reference to `EVP_CipherInit_ex@OPENSSL_1.0.0' > > <snip> > > What version of SSL is your libpq compiled against? You can use 'ldd' > to find out. On squeeze, PG 8.4 appears to use 0.9.8. > FYI, mine is: root@debian:~# ldd /usr/lib/libpq.so.5.4 | grep ssllibssl.so.1.0.0 => /usr/lib/libssl.so.1.0.0 (0x00007f511f911000) And ldd on libssl gives me this: root@debian:~# ldd /usr/lib/libssl.so.1.0.0linux-vdso.so.1 => (0x00007fffcf3ff000)libcrypto.so.1.0.0 => /usr/lib/libcrypto.so.1.0.0(0x00007ffccd12a000)libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007ffcccf26000)libz.so.1=> /usr/lib/libz.so.1 (0x00007ffcccd0e000)libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007ffccc98a000)/lib64/ld-linux-x86-64.so.2(0x00007ffccd756000) -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Il giorno mer, 24/08/2011 alle 11.00 +0100, Dave Page ha scritto: > On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco [...] > > configure:5403: checking for SSL_library_init in -lssl > > configure:5428: gcc -o conftest -g -O2 conftest.c -lssl >&5 > > /usr/lib/libssl.so: undefined reference to `BIO_pop@OPENSSL_1.0.0' > > /usr/lib/libssl.so: undefined reference to `EVP_CipherInit_ex@OPENSSL_1.0.0' > > <snip> > > What version of SSL is your libpq compiled against? You can use 'ldd' > to find out. On squeeze, PG 8.4 appears to use 0.9.8. $ ldd /usr/lib/libpq.so.5.4linux-gate.so.1 => (0xb7819000)libssl.so.1.0.0 => /usr/lib/i686/cmov/libssl.so.1.0.0 (0xb7780000)libcrypto.so.1.0.0=> /usr/lib/i686/cmov/libcrypto.so.1.0.0 (0xb75d2000)libkrb5.so.3 => /usr/lib/i386-linux-gnu/libkrb5.so.3(0xb7505000)libcom_err.so.2 => /lib/libcom_err.so.2 (0xb7501000)libgssapi_krb5.so.2 =>/usr/lib/i386-linux-gnu/libgssapi_krb5.so.2 (0xb74c3000)libldap_r-2.4.so.2 => /usr/lib/i386-linux-gnu/libldap_r-2.4.so.2(0xb7473000)libpthread.so.0 => /lib/i386-linux-gnu/i686/cmov/libpthread.so.0 (0xb745a000)libc.so.6=> /lib/i386-linux-gnu/i686/cmov/libc.so.6 (0xb72ff000)libdl.so.2 => /lib/i386-linux-gnu/i686/cmov/libdl.so.2(0xb72fb000)libz.so.1 => /usr/lib/libz.so.1 (0xb72e7000)libk5crypto.so.3 => /usr/lib/i386-linux-gnu/libk5crypto.so.3(0xb72bf000)libkrb5support.so.0 => /usr/lib/i386-linux-gnu/libkrb5support.so.0 (0xb72b7000)libkeyutils.so.1=> /lib/i386-linux-gnu/libkeyutils.so.1 (0xb72b2000)libresolv.so.2 => /lib/i386-linux-gnu/i686/cmov/libresolv.so.2(0xb729e000)/lib/ld-linux.so.2 (0xb781a000)liblber-2.4.so.2 => /usr/lib/i386-linux-gnu/liblber-2.4.so.2(0xb7290000)libsasl2.so.2 => /usr/lib/i386-linux-gnu/libsasl2.so.2 (0xb7274000)libgnutls.so.26=> /usr/lib/i386-linux-gnu/libgnutls.so.26 (0xb71ab000)libgcrypt.so.11 => /lib/i386-linux-gnu/libgcrypt.so.11(0xb712a000)libtasn1.so.3 => /usr/lib/i386-linux-gnu/libtasn1.so.3 (0xb7119000)libgpg-error.so.0=> /lib/libgpg-error.so.0 (0xb7115000) Bye, Giuseppe
Il giorno mer, 24/08/2011 alle 12.15 +0200, Guillaume Lelarge ha scritto: [...] > And ldd on libssl gives me this: > root@debian:~# ldd /usr/lib/libssl.so.1.0.0 > linux-vdso.so.1 => (0x00007fffcf3ff000) > libcrypto.so.1.0.0 => /usr/lib/libcrypto.so.1.0.0 (0x00007ffccd12a000) > libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007ffcccf26000) > libz.so.1 => /usr/lib/libz.so.1 (0x00007ffcccd0e000) > libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007ffccc98a000) > /lib64/ld-linux-x86-64.so.2 (0x00007ffccd756000) mine is different, but only because this is a 32bit system: $ ldd /usr/lib/libssl.so.1.0.0linux-gate.so.1 => (0xb78b1000)libcrypto.so.1.0.0 => /usr/lib/i686/cmov/libcrypto.so.1.0.0(0xb7694000)libdl.so.2 => /lib/i386-linux-gnu/i686/cmov/libdl.so.2 (0xb7690000)libz.so.1=> /usr/lib/libz.so.1 (0xb767b000)libc.so.6 => /lib/i386-linux-gnu/i686/cmov/libc.so.6 (0xb7521000)/lib/ld-linux.so.2(0xb78b2000)
On Wed, Aug 24, 2011 at 11:18 AM, Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org> wrote: > Il giorno mer, 24/08/2011 alle 11.00 +0100, Dave Page ha scritto: >> On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco > [...] >> > configure:5403: checking for SSL_library_init in -lssl >> > configure:5428: gcc -o conftest -g -O2 conftest.c -lssl >&5 >> > /usr/lib/libssl.so: undefined reference to `BIO_pop@OPENSSL_1.0.0' >> > /usr/lib/libssl.so: undefined reference to `EVP_CipherInit_ex@OPENSSL_1.0.0' >> >> <snip> >> >> What version of SSL is your libpq compiled against? You can use 'ldd' >> to find out. On squeeze, PG 8.4 appears to use 0.9.8. > > $ ldd /usr/lib/libpq.so.5.4 > linux-gate.so.1 => (0xb7819000) > libssl.so.1.0.0 => /usr/lib/i686/cmov/libssl.so.1.0.0 (0xb7780000) > libcrypto.so.1.0.0 => /usr/lib/i686/cmov/libcrypto.so.1.0.0 (0xb75d2000) > libkrb5.so.3 => /usr/lib/i386-linux-gnu/libkrb5.so.3 (0xb7505000) > libcom_err.so.2 => /lib/libcom_err.so.2 (0xb7501000) > libgssapi_krb5.so.2 => /usr/lib/i386-linux-gnu/libgssapi_krb5.so.2 (0xb74c3000) > libldap_r-2.4.so.2 => /usr/lib/i386-linux-gnu/libldap_r-2.4.so.2 (0xb7473000) > libpthread.so.0 => /lib/i386-linux-gnu/i686/cmov/libpthread.so.0 (0xb745a000) > libc.so.6 => /lib/i386-linux-gnu/i686/cmov/libc.so.6 (0xb72ff000) > libdl.so.2 => /lib/i386-linux-gnu/i686/cmov/libdl.so.2 (0xb72fb000) > libz.so.1 => /usr/lib/libz.so.1 (0xb72e7000) > libk5crypto.so.3 => /usr/lib/i386-linux-gnu/libk5crypto.so.3 (0xb72bf000) > libkrb5support.so.0 => /usr/lib/i386-linux-gnu/libkrb5support.so.0 (0xb72b7000) > libkeyutils.so.1 => /lib/i386-linux-gnu/libkeyutils.so.1 (0xb72b2000) > libresolv.so.2 => /lib/i386-linux-gnu/i686/cmov/libresolv.so.2 (0xb729e000) > /lib/ld-linux.so.2 (0xb781a000) > liblber-2.4.so.2 => /usr/lib/i386-linux-gnu/liblber-2.4.so.2 (0xb7290000) > libsasl2.so.2 => /usr/lib/i386-linux-gnu/libsasl2.so.2 (0xb7274000) > libgnutls.so.26 => /usr/lib/i386-linux-gnu/libgnutls.so.26 (0xb71ab000) > libgcrypt.so.11 => /lib/i386-linux-gnu/libgcrypt.so.11 (0xb712a000) > libtasn1.so.3 => /usr/lib/i386-linux-gnu/libtasn1.so.3 (0xb7119000) > libgpg-error.so.0 => /lib/libgpg-error.so.0 (0xb7115000) What's with the weird paths? I'd expect most of that lot to come from /usr/lib or /lib. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Giuseppe,
What is the output of 'ldd /usr/lib/i686/cmov/libcrypto.so.1.0.0'?
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
On Wed, Aug 24, 2011 at 3:54 PM, Dave Page <dpage@pgadmin.org> wrote:
On Wed, Aug 24, 2011 at 11:18 AM, Giuseppe Sacco<giuseppe@eppesuigoccas.homedns.org> wrote:What's with the weird paths? I'd expect most of that lot to come from> Il giorno mer, 24/08/2011 alle 11.00 +0100, Dave Page ha scritto:
>> On Wed, Aug 24, 2011 at 10:40 AM, Giuseppe Sacco
> [...]
>> > configure:5403: checking for SSL_library_init in -lssl
>> > configure:5428: gcc -o conftest -g -O2 conftest.c -lssl >&5
>> > /usr/lib/libssl.so: undefined reference to `BIO_pop@OPENSSL_1.0.0'
>> > /usr/lib/libssl.so: undefined reference to `EVP_CipherInit_ex@OPENSSL_1.0.0'
>>
>> <snip>
>>
>> What version of SSL is your libpq compiled against? You can use 'ldd'
>> to find out. On squeeze, PG 8.4 appears to use 0.9.8.
>
> $ ldd /usr/lib/libpq.so.5.4
> linux-gate.so.1 => (0xb7819000)
> libssl.so.1.0.0 => /usr/lib/i686/cmov/libssl.so.1.0.0 (0xb7780000)
> libcrypto.so.1.0.0 => /usr/lib/i686/cmov/libcrypto.so.1.0.0 (0xb75d2000)
> libkrb5.so.3 => /usr/lib/i386-linux-gnu/libkrb5.so.3 (0xb7505000)
> libcom_err.so.2 => /lib/libcom_err.so.2 (0xb7501000)
> libgssapi_krb5.so.2 => /usr/lib/i386-linux-gnu/libgssapi_krb5.so.2 (0xb74c3000)
> libldap_r-2.4.so.2 => /usr/lib/i386-linux-gnu/libldap_r-2.4.so.2 (0xb7473000)
> libpthread.so.0 => /lib/i386-linux-gnu/i686/cmov/libpthread.so.0 (0xb745a000)
> libc.so.6 => /lib/i386-linux-gnu/i686/cmov/libc.so.6 (0xb72ff000)
> libdl.so.2 => /lib/i386-linux-gnu/i686/cmov/libdl.so.2 (0xb72fb000)
> libz.so.1 => /usr/lib/libz.so.1 (0xb72e7000)
> libk5crypto.so.3 => /usr/lib/i386-linux-gnu/libk5crypto.so.3 (0xb72bf000)
> libkrb5support.so.0 => /usr/lib/i386-linux-gnu/libkrb5support.so.0 (0xb72b7000)
> libkeyutils.so.1 => /lib/i386-linux-gnu/libkeyutils.so.1 (0xb72b2000)
> libresolv.so.2 => /lib/i386-linux-gnu/i686/cmov/libresolv.so.2 (0xb729e000)
> /lib/ld-linux.so.2 (0xb781a000)
> liblber-2.4.so.2 => /usr/lib/i386-linux-gnu/liblber-2.4.so.2 (0xb7290000)
> libsasl2.so.2 => /usr/lib/i386-linux-gnu/libsasl2.so.2 (0xb7274000)
> libgnutls.so.26 => /usr/lib/i386-linux-gnu/libgnutls.so.26 (0xb71ab000)
> libgcrypt.so.11 => /lib/i386-linux-gnu/libgcrypt.so.11 (0xb712a000)
> libtasn1.so.3 => /usr/lib/i386-linux-gnu/libtasn1.so.3 (0xb7119000)
> libgpg-error.so.0 => /lib/libgpg-error.so.0 (0xb7115000)
/usr/lib or /lib.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
Il giorno mer, 24/08/2011 alle 11.24 +0100, Dave Page ha scritto: > On Wed, Aug 24, 2011 at 11:18 AM, Giuseppe Sacco [...] > > liblber-2.4.so.2 => /usr/lib/i386-linux-gnu/liblber-2.4.so.2 (0xb7290000) > > libsasl2.so.2 => /usr/lib/i386-linux-gnu/libsasl2.so.2 (0xb7274000) > > libgnutls.so.26 => /usr/lib/i386-linux-gnu/libgnutls.so.26 (0xb71ab000) > > libgcrypt.so.11 => /lib/i386-linux-gnu/libgcrypt.so.11 (0xb712a000) > > libtasn1.so.3 => /usr/lib/i386-linux-gnu/libtasn1.so.3 (0xb7119000) > > libgpg-error.so.0 => /lib/libgpg-error.so.0 (0xb7115000) > > What's with the weird paths? I'd expect most of that lot to come from > /usr/lib or /lib. I suspect this is because new Debian will have multiarch support. You may have the same library for different architectures installed at the same time. The loader will find the correct one. More information here: http://wiki.debian.org/Multiarch Bye, Giuseppe
Il giorno mer, 24/08/2011 alle 16.00 +0530, Ashesh Vashi ha scritto: > Giuseppe, > What is the output of 'ldd /usr/lib/i686/cmov/libcrypto.so.1.0.0'? $ ldd /usr/lib/i686/cmov/libcrypto.so.1.0.0linux-gate.so.1 => (0xb7720000)libdl.so.2 => /lib/i386-linux-gnu/i686/cmov/libdl.so.2(0xb754c000)libz.so.1 => /usr/lib/libz.so.1 (0xb7538000)libc.so.6 => /lib/i386-linux-gnu/i686/cmov/libc.so.6(0xb73dd000)/lib/ld-linux.so.2 (0xb7721000)
thanks Guillaume, after installing postgresql-server-dev-8.4 libwxgtk2.8-0 libwxgtk2.8-dev libxml2-dev libxslt-dev I justran ./configure and I got to intall pgAdmin III 1.8.4 thanks again! <br /><hr align="left" width="300" /> View this messagein context: <a href="http://postgresql.1045698.n5.nabble.com/compiling-on-debian-does-not-find-a-valid-PostgreSQL-8-4-installati-tp4703362p5746792.html">Re: compilingon debian does not find a valid PostgreSQL 8.4+ installati</a><br /> Sent from the <a href="http://postgresql.1045698.n5.nabble.com/PostgreSQL-pgadmin-support-f2191615.html">PostgreSQL- pgadmin support mailinglist archive</a> at Nabble.com.<br />