Date: Fri, 8 Aug 2008 10:21:22 +0400
From: =?windows-1251?B?yvPw4Pjq6O0gxOzo8vDo6Q==?= <dnk@dolg.su>
Reply-To: =?windows-1251?B?yvPw4Pjq6O0gxOzo8vDo6SDN6Oru6+Dl4uj3?=
 <dnk@dolg.su>
Organization: =?windows-1251?B?xO7r4+7i7uUgwOPl7fLx8uLuICLK7u3x8+si?=
Message-ID: <18810370276.20080808102122@dolg.su>
To: pgsql-admin@postgresql.org
Subject: Problems with connection
In-Reply-To: <1894788884.20080807162245@dolg.su>
References: <1894788884.20080807162245@dolg.su>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1251
Content-Transfer-Encoding: quoted-printable

Hi to all!

I have following systems:
1. Local machine with Windows XP SP2 and PostgreSQL 8.2 - test system.
2. Work server in local network (FreeBSD + PostgreSQL 8.2) - work
system.

I write client with Delphi 7 IDE and use Zeos Lib 6.6.2
(http://zeos.firmos.at/) for database access.

When I tried to connect to server I recieve error message: "SQL Error:
fe_sendauth: authentication type 5 not supported."
After searching in internet I found solution: set authentication
method "password" instead of "md5".
In file pg_hba.conf on local machine I wrote:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
host    all         all         127.0.0.1/32          password

and on server:
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
host    all         all         192.168.3.0/24        password

My IP-address in local network is 192.168.3.16...

After that I can to connect to test PostgreSQL server on localhost,
and connection works fine, but attempt to connect to work server finishes by
same error message "SQL Error: fe_sendauth: authentication type 5 not
supported."

I tried to place string in pg_hba.conf on first and last positions,
wrote names of databases and users instead of "all" but it doesn't
work.

As I understand, my main problem is to force PostgreSQL server allow
me to connect with password authentication method, isn't it? And how I
can do that?

P. S. Sorry for poor english...