| 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: | Whole Thread | Raw Message | 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
| 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 |