Обсуждение: undefined reference to `SSL_CTX_set_client_cert_cb'

Hello list,

I'm trying to compile postgresql-8.2.3 on a system running debian stable
with kernel 2.6.8-2-686, but compilation stops with this error:

<snip>
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-Wendif-labels -fno-strict-aliasing initdb.o  -L../../../src/port
-lpgport -L../../../src/interfaces/libpq -lpq -L../../../src/port
-Wl,-rpath,'/usr/local/pgsql-8.2.3/lib' -lpgport -lpam -lssl -lcrypto
-lkrb5 -lz -lreadline -lcrypt -ldl -lm  -o initdb
../../../src/interfaces/libpq/libpq.so: undefined reference to
`SSL_CTX_set_client_cert_cb'
collect2: ld returned 1 exit status
make[3]: *** [initdb] Error 1
make[3]: Leaving directory `/usr/local/src/postgresql-8.2.3/src/bin/initdb'
make[2]: *** [install] Error 2
make[2]: Leaving directory `/usr/local/src/postgresql-8.2.3/src/bin'
make[1]: *** [install] Error 2
make[1]: Leaving directory `/usr/local/src/postgresql-8.2.3/src'
</snip>

Of course the debian packages libssl-dev, libssl0.9.6, libssl0.9.7 and
openssl are installed.

Any ideas?

Thanks in advance
Dieter

Dieter Schicker wrote:
> postgresql-8.2.3 on a system running debian stable with kernel 2.6.8-2-686
> Any ideas?

No, but maybe an antiquated OS and up to date applications is not the
best match. Debian stable is somewhere around PG 7.4.x.

Can you build it successfully without SSL enabled? Maybe get 8.2 from
backports, or at least see what the 8.2 backports version list as
dependencies.


--
Best regards,
Hannes Dorbath

Hannes Dorbath <light@theendofthetunnel.de> writes:
> Dieter Schicker wrote:
>> postgresql-8.2.3 on a system running debian stable with kernel 2.6.8-2-686
>> Any ideas?

> No, but maybe an antiquated OS and up to date applications is not the
> best match. Debian stable is somewhere around PG 7.4.x.

But we were using SSL_CTX_set_client_cert_cb even in 7.4, and AFAICT
the function has existed in OpenSSL since 1999 or earlier.

I did some googling and found various people complaining of similar
build problems with completely Postgres-unrelated software that's using
OpenSSL, so it seems there's something a bit odd about that particular
function ... but I didn't find out what.

            regards, tom lane

Tom Lane wrote:
> Hannes Dorbath <light@theendofthetunnel.de> writes:
>> Dieter Schicker wrote:
>>> postgresql-8.2.3 on a system running debian stable with kernel 2.6.8-2-686
>>> Any ideas?
>
>> No, but maybe an antiquated OS and up to date applications is not the
>> best match. Debian stable is somewhere around PG 7.4.x.
>
> But we were using SSL_CTX_set_client_cert_cb even in 7.4, and AFAICT
> the function has existed in OpenSSL since 1999 or earlier.
>
> I did some googling and found various people complaining of similar
> build problems with completely Postgres-unrelated software that's using
> OpenSSL, so it seems there's something a bit odd about that particular
> function ... but I didn't find out what.
>
>             regards, tom lane
>

> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
Hehe, I would never ever do that, I swear! ;-)

First of all, thanks for your valuable answers!

Concerning the "antiquated OS": I think this is not the right place to
discuss the antiquity (right word? - sorry my mother tongue is German)
of an OS. Just one sentence: I have been in the business for 25 years
now and I therefore prefer stability to
"always-have-to-have-the-super-freshest-software". ;-)
The reason why I break this self-imposed "rule" with postgres is that we
use postgres (exclusively) for teaching database courses here at our
institution and we need some functionalities that require version 8.x.

Tom, of course I did that googling, too before I dared to ask on this
list. But all I found was questions, no answers. ;-) I will dig into
that problem further and keep you informed if I find a solution.

Thanks and Cheers
Dieter

Sorry for emailing you directly Dieter.  This question is for the group.

Any update on this issue.  I'm trying to run PyGreSQL-3.8.1 and python2.5.
The error message I'm getting after issuing the import _pg statement is below.


>>> import _pg
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: /usr/local/pgsql/lib/libpq.so.5: undefined symbol: SSL_CTX_set_client_cert_cb




---------- Forwarded message ----------
From: Ezra Taylor <ezra.taylor@gmail.com >
Date: Jun 1, 2007 8:52 PM
Subject: Re: [ADMIN] undefined reference to `SSL_CTX_set_client_cert_cb'
To: Dieter Schicker <dieter.schicker@uni-graz.at>

Guys:
           Any update on this issue.  I'm trying to run PyGreSQL-3.8.1 and python2.5.
The error message I'm getting after issuing the import _pg statement is below.


>>> import _pg
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: /usr/local/pgsql/lib/libpq.so.5: undefined symbol: SSL_CTX_set_client_cert_cb--
Ezra Taylor

--
Ezra Taylor