| From: | Adam Maddock <adam(at)maddock(dot)ml(dot)org> |
|---|---|
| To: | pgsql-admin(at)postgreSQL(dot)org |
| Subject: | Postgre security |
| Date: | 1998-12-08 19:26:05 |
| Message-ID: | Pine.LNX.3.96.981208141558.3418A-100000@apu.maddock.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I'm struggling with the methods of user authentication that Postgre uses.
I would like to be able to use the /etc/passwd or /etc/shadow file to
authenticate users. That way users could easily control their own
passwords by telnet-ing in to the machine.
I've tried the following line in my pg_hba.conf file:
"local all password /etc/passwd"
But to no good return. I think that my system (Linux 2.0.34) is using a
different encryption algorithm that Postgre.
For the password "temptemp", my system produces the following:
"3aBwsRu.LzR4k"
While Postgre's pg_passwd yields:
"VsHWG150vpTic"
Any insight into this matter would be greatly appreciated.
thanks much,
Adam
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Adam Maddock http://Adam.Maddock.com
Detroit, MI adam(at)maddock(dot)com
"BE IMITATORS of God, therefore, as dearly loved children..."
(Ephesians 5:1)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| From | Date | Subject | |
|---|---|---|---|
| Next Message | O.J. | 1998-12-09 08:00:33 | PostgreSQL 6.4 fails connect on local UNIX Sockets |
| Previous Message | Marc Eggenberger | 1998-12-08 19:15:05 | Compile Error on Linux |