Re: Problem with libpq3 & postgresql8

Hi,

On Wed, 21 Sep 2005, Alex R. Mosteo wrote:

> I have a client program which worked ok, using libpq3 agains a 7.4
> database. Both linux versions. The client and server are in separate
> machines connecting via TCP/IP.
>
> I've just updated the database to 8.0, and the client program now can't
> connect. There's no error message, it simply gets stuck when doing the
> connection call and remains so indefinitely.
>
> Is this a known incompatibility? If not, any suggestions on what to try?

libpq version was changed in 8.0.2.

If you are using Red Hat / Fedora Core, install this package to solve the
problem:

http://developer.postgresql.org/~devrim/rpms/compat/compat-postgresql-libs-3-3PGDG.i686.rpm

This RPM installs the following files:

#rpm -qlp compat-postgresql-libs-3-3PGDG.i686.rpm
/usr/lib/libecpg.so.4
/usr/lib/libecpg.so.4.1
/usr/lib/libecpg_compat.so.1
/usr/lib/libecpg_compat.so.1.2
/usr/lib/libpgtypes.so.1
/usr/lib/libpgtypes.so.1.2
/usr/lib/libpq.so.3
/usr/lib/libpq.so.3.1

Regards,
--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
>From pgsql-general-owner(at)postgresql(dot)org Wed Sep 21 10:32:25 2005
X-Original-To: pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 42A28D9871
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 21 Sep 2005 10:31:44 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 90714-07
for <pgsql-general-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 21 Sep 2005 13:31:36 +0000 (GMT)
Received: from smtp.dkm.cz (smtp.dkm.cz [62.24.64.34])
by svr1.postgresql.org (Postfix) with SMTP id 6C59FD986F
for <pgsql-general(at)postgresql(dot)org>; Wed, 21 Sep 2005 10:31:37 -0300 (ADT)
Received: (qmail 96234 invoked by uid 0); 21 Sep 2005 13:31:40 -0000
Received: from j98.chello.upc.cz (HELO bafster.no-ip.org) (62.24.75.98)
by smtp.dkm.cz with SMTP; 21 Sep 2005 13:31:39 -0000
Received: from bafster.no-ip.org (localhost [127.0.0.1])
by bafster.no-ip.org (8.13.3/8.12.11) with ESMTP id j8LDrk9U011251
for <pgsql-general(at)postgresql(dot)org>; Wed, 21 Sep 2005 15:53:46 +0200
Received: (from bohdan(at)localhost)
by bafster.no-ip.org (8.13.3/8.12.11/Submit) id j8LDrkN4011250
for pgsql-general(at)postgresql(dot)org; Wed, 21 Sep 2005 15:53:46 +0200
Date: Wed, 21 Sep 2005 15:53:45 +0200
From: Bohdan Linda <bohdan(dot)linda(at)seznam(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: pgclient hostbased authentication
Message-ID: <20050921135345(dot)GA11149(at)bafster(dot)chello(dot)upc(dot)cz>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.4.2.1i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.303 required=5 tests=[AWL=-0.121,
DNS_FROM_RFC_ABUSE=0.374, FORGED_RCVD_HELO=0.05]
X-Spam-Level:
X-Archive-Number: 200509/819
X-Sequence-Number: 83834

Hello,

may I ask, how(or which) ip is checked against pg_hba.conf IP entry in NAT
environment?

Could it be, that psql client packs IP address of the client into athentication data?

Regards,
Bohdan