Postgre security

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: Raw Message | Whole Thread | 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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

In response to

Browse pgsql-admin by date

  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