Postgre security
От | Adam Maddock |
---|---|
Тема | Postgre security |
Дата | |
Msg-id | Pine.LNX.3.96.981208141558.3418A-100000@apu.maddock.net обсуждение исходный текст |
Ответ на | Cannot run destroydb: ERROR: typeidTypeRelid: Invalid type - oid = 0 (Jan Kim <kim@mpiz-koeln.mpg.de>) |
Список | 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@maddock.com "BE IMITATORS of God, therefore, as dearly loved children..." (Ephesians 5:1) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
В списке pgsql-admin по дате отправления: