Обсуждение: 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"
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 failed > > vsop 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