Getting PAM-compatible password hashes from pgcrypto
0
votes
0
answers
212
views
I want to keep user records in Postgres database and faced one issue which block me. It is password encryption. For example, this is correcetly encrypted password
12345
via default Ubuntu crypt
function:
$6$P5jfk4Ufh33f$.Dc8H9jsWAl/igt4QPbYI/El28SyUEAoJPPHsLIGMKOymhC7AIaiizlW5W9hm7kU7PYMCySEhYtMqVPFsVTMK/
As I understand first 6
means that it is encrypted via sha384
(or sha256
) algorithm. Ok, i created an extension pgcrypto
in desired database, but following code: SELECT digest('12345', 'sha384') as pwhash;
returns absolutely different result - without algorithm mark and salt:
\x0fa76955abfa9dafd83facca8343a92aa09497f98101086611b0bfa95dbc0dcc661d62e9568a5a032ba81960f3e55d4a
I want to get exactly specified format because it is used by PAM to check user credetials and it does not understand password hashed another way.
Asked by Alex G.P.
(101 rep)
Dec 8, 2014, 07:26 PM
Last activity: Dec 8, 2014, 07:42 PM
Last activity: Dec 8, 2014, 07:42 PM