| 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 |