User authentication failed
Hello
I'm running postgres-6.4.2 on one machine, and want to access it from
another, but get the error message
% psql -h vsop rndprojectdb
Connection to database 'rndprojectdb' failed.
User authentication failed
vsop is remote host
rndprojectdb is database
(above command run as user postgres, database rndprojectdb owned by user
postgres.)
I have edited the /usr/local/pgsql/data/pg_hba.conf with:
local all trust
host all 10.123.10.0 255.255.255.255 trust
host all 192.168.10.0 255.255.255.255 trust
I know it's using the correct port 5432, and that the postmaster is
listening, and reading pg_hba.conf.
(running on Irix 6.2)
Any help would be appreciated.............thanks
Jean
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jean Lee
Software Developer mailto:jean@cinesite.co.uk
Cinesite (Europe) Ltd. Telephone: 0171 973 4000
9 Carlisle Street Direct: 0171 973 4077
London W1V 5RG Fax: 0171 973 4040
Jean Lee <jean@cinesite.co.uk> writes:
host all 10.123.10.0 255.255.255.255 trust
host all 192.168.10.0 255.255.255.255 trust
You're allowing connections from 10.123.10.0 and 192.168.10.0 exactly,
and I'd bet the machine you're connecting from has neither of those
addresses. If what you meant was to allow connections from machines
in the networks 10.123.10.0/24 and 192.168.10.0/24, you want:
host all 10.123.10.0 255.255.255.0 trust
host all 192.168.10.0 255.255.255.0 trust
-tih
--
Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier"
Import Notes
Reply to msg id not found: JeanLee'smessageofTue23Mar1999122611+0000
Jean Lee wrote:
I'm running postgres-6.4.2 on one machine, and want to access it from
another, but get the error message% psql -h vsop rndprojectdb
Connection to database 'rndprojectdb' failed.
User authentication failedvsop is remote host
rndprojectdb is database
I was having a similar problem (same error message) when routing through a
TCPIP port. When I created a password with pg_passwd (something like that),
I was able to route through TCPIP as opposed to unix sockets, which had been
working all along.
--
Bob VonMoss
mailto:bvonmoss@bigfoot.com
from Rosemont, IL