can't get user authentication to work - HELP!

From: "Floyd Shackelford" <floyds(at)4peakstech(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: can't get user authentication to work - HELP!
Date: 2000-11-16 21:57:46
Message-ID: 000b01c05018$4105a4e0$9701a8c0@fwshackelford.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just can't seem to figure out how to get the userid/password thing to
work.

i created a database called a_database.

i created a user using createuser named "user1" with password "password1"

my pg_hba.conf file has the following entry:

host all 192.168.1.0 255.255.255.0 password pg_passwd

i try the following:

psql -h 192.168.1.200 -d a_database -U user1 -W

and i enter "password1" (sans quotes) at the password prompt and get:

psql: FATAL 1: SetUserId: user 'user1' is not in 'pg_shadow'

How do I get this to work? How do i get an entry into pg_shadow?

I even tried it with the postgres super user:

psql -h 192.168.1.200 -d a_database -U postgres -W

and I get:

psql: Password authentication failed for user 'postgres'

What do I do to get user authentication to work?

Regards,
Floyd Shackelford
4 Peaks Technology Group, Inc., http://www.4peakstech.com/
dba Corona Professional Services, http://www.coronaps.com/
P. O. Box 27740, Las Vegas, Nevada 89126
office: +1.888.398.4405 fax: +1.916.404.7125
net2phone nickname: fwshack PGPfone: enabled

"[A]ll men are ... endowed by their Creator with certain unalienable Rights
... whenever ... Government becomes destructive of these Ends, it is the
Right of the People ... it is their Duty, to throw off such
Government...." --Declaration of Independence

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Jerusalem 2000-11-17 00:56:02 I know installation questions are boring ...
Previous Message Michael Fork 2000-11-16 21:55:02 Starting Postmaster with -d2