Problems connecting from pgAdmin II v1.1 build 59

From: Jason Wong <postgresql(at)gremlins(dot)com(dot)hk>
To: PgSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Problems connecting from pgAdmin II v1.1 build 59
Date: 2001-10-30 15:19:29
Message-ID: 200110301519.f9UFJiP51136@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

SITUATION
=========
postgresql server was running fine on a linux server. I decided to
install pgAdmin on a Win98 to ease development.

WHAT I DID
==========
Installed pgAdmin, no problem.
On the server side I edited the postgresql.conf file to enable TCP/IP
connections.
I added a line to pg_hba.conf:

host all 10.0.0.0 255.255.255.0 password password.file

I then used pg_passwd to create the "password.file" file (in the same
directory as pg_hba.conf ie. /usr/local/pgsql/data), with a single user
& password.

I then restarted postmaster.

RESULT
======
When I try to connect to the server from pgAdmin I get this error:

[FATAL 1: user "blahblah" does not exist]

I have double-checked the file "password.file" and the user does have
an entry along with a crypted password.

For the heck of it I tried to connect using a random user in the
pgAdmin "Connect to Server" dialog and got this error:

[Password authentication failed for user 'dimwit']

On the console of the server the error was:

[verify_password: user 'dimwit' not found in password file.]
[Password authentication failed for user 'dimwit']

Next I edited pg_hba.conf to read instead:

host all 10.0.0.0 255.255.255.0 crypt password.file

And restarted postmaster.

Connecting results in this error:

[Password crypt authentication not supported]

I would be grateful if someone could point out what I am doing wrong.

thanks
--
Jason Wong

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2001-10-30 16:16:39 Re: Problems connecting from pgAdmin II v1.1 build 59
Previous Message Danny Aldham 2001-10-30 02:30:51 Re: Triggers failing from 7.0.2 to 7.1.3