From: | Michael Richards <miker(at)scifair(dot)acadiau(dot)ca> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org, hackers(at)postgreSQL(dot)org |
Subject: | entries in pg_shadow |
Date: | 1999-08-29 00:40:29 |
Message-ID: | Pine.BSF.4.10.9908282128080.33117-100000@scifair.acadiau.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
Hi.
The entries entered in pg_shadow haven't ever worked for me. I've tried a
number of times without success. If I update a user in there and set a
password for them:
postgres=> select * from pg_shadow;
usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd|valuntil
---------+--------+-----------+--------+--------+---------+-------+----------------------------
postgres | 100|t |t |t |t | |Sat Jan31 01:00:00 2037 EST
user1 | 1001|f |t |f |t | |
equipment| 1004|f |t |f |t | MYPASS|
(3 rows)
This example assumes I've set my password to 'MYPASS'.
Now I change pg_hba.conf to have a:
host equipment 123.123.123.123 255.255.0.0 password
Assuming my IP is 123.123.123.123 and the database I need to connect to is
called equipment and the user is of course equipment...
I've restarted the server and...
Now I run off to my remote machine and try to connect...
psql -u -h test.mypostgresserverdomain.com equipment
Username: equipment
Password:
Connection to database 'equipment' failed.
Password authentication failed for user 'equipment'
Any ideas on what the heck I might be forgetting to do or not doing
properly?
I'm starting postgres up as:
su -l postgres -c 'exec /usr/local/pgsql/bin/postmaster
-D/dr/raid0/postgres/pgdata -d 1 -i -o "-E -F -S 16384 -o
/usr/local/pgsql/home/logfile" -s >> /usr/local/pgsql/home/errlog 2>&1
/usr/local/pgsql/home/errlog1 &'
In the server's errlog file I find:
Password authentication failed for user 'equipment'
It would be really nice if I'd see something like:
Sat Aug 28 21:43:39 EDT 1999 - Password authentication failed from
123.123.123.123 on database 'equipment'
-Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-08-29 00:49:28 | Re: [HACKERS] [Fwd: bug ? get_groname: group 0 not found] |
Previous Message | pgsql-hackers | 1999-08-28 21:27:46 | Quoting in stored procedures |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-08-29 00:46:40 | Re: [SQL] indexes using datetime |
Previous Message | Dipl.-Ing. Thomas Schallar | 1999-08-29 00:39:19 | LEFT or RIGHT JOINs? |