calculating the MD5 hash of role passwords in C - Mailing list pgsql-general

From Matthias Apitz
Subject calculating the MD5 hash of role passwords in C
Date
Msg-id 20200122182036.GA2908@c720-r342378
Whole thread Raw
Responses Re: calculating the MD5 hash of role passwords in C
Re: calculating the MD5 hash of role passwords in C
Re: calculating the MD5 hash of role passwords in C
List pgsql-general
Hello,

If I look into the database I see:

sisis71=# select rolname, rolpassword from pg_authid where rolname = 'sisis';
 rolname |             rolpassword
---------+-------------------------------------
 sisis   | md52f128a1fbbecc4b16462e8fc8dda5cd5

I know the clear text password of the role, it is simple 'sisis123', how
could I calculate the above MD5 hash from the clear text password, for
example in C? Which salt is used for the crypt(3) function?

Thanks

    matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgresSQL 10 on remote server - Socket is not connected(0x00002749/10057)
Next
From: Adrian Klaver
Date:
Subject: Re: calculating the MD5 hash of role passwords in C