Re: calculating the MD5 hash of role passwords in C

2020-02-05 Thread Stephen Frost
Greetings, * Matthias Apitz (g...@unixarea.de) wrote: > If I look into the database I see: > > sisis71=# select rolname, rolpassword from pg_authid where rolname = 'sisis'; > rolname | rolpassword > -+- > sisis |

Re: calculating the MD5 hash of role passwords in C

2020-01-23 Thread Matthias Apitz
El día jueves, enero 23, 2020 a las 05:15:37p. m. +0100, Christoph Moench-Tegeder escribió: > ## Matthias Apitz (g...@unixarea.de): > > > > The documentation on pg_authid has the details: > > > "The MD5 hash will be of the user's password concatenated to their user > > > name." > > >

Re: calculating the MD5 hash of role passwords in C

2020-01-23 Thread Bruce Momjian
On Thu, Jan 23, 2020 at 05:15:37PM +0100, Christoph Moench-Tegeder wrote: > ## Matthias Apitz (g...@unixarea.de): > > > > The documentation on pg_authid has the details: > > > "The MD5 hash will be of the user's password concatenated to their user > > > name." > > >

Re: calculating the MD5 hash of role passwords in C

2020-01-23 Thread Christoph Moench-Tegeder
## Matthias Apitz (g...@unixarea.de): > > The documentation on pg_authid has the details: > > "The MD5 hash will be of the user's password concatenated to their user > > name." > > https://www.postgresql.org/docs/12/catalog-pg-authid.html > > This is still not exactly what I was looking for.

RE: calculating the MD5 hash of role passwords in C

2020-01-23 Thread Igor Neyman
-Original Message- From: Matthias Apitz [mailto:g...@unixarea.de] Sent: Wednesday, January 22, 2020 3:05 PM To: Igor Neyman Cc: pgsql-general@lists.postgresql.org Subject: Re: calculating the MD5 hash of role passwords in C > -- > Matthias Apitz, ✉ g...@unixarea.de,

Re: calculating the MD5 hash of role passwords in C

2020-01-22 Thread Adrian Klaver
On 1/22/20 12:58 PM, Matthias Apitz wrote: El día miércoles, enero 22, 2020 a las 03:32:17p. m. -0500, Justin escribió: Not sure what your after but here is more information regarding how to store passwords in Postgresql, ... I just want to write a piece of C-code to generate the same

Re: calculating the MD5 hash of role passwords in C

2020-01-22 Thread Justin
Not sure what your after but here is more information regarding how to store passwords in Postgresql, not related to database roles but for storing passwords for things like websites... https://www.postgresql.org/docs/current/pgcrypto.html section F.25.2.XXX On Wed, Jan 22, 2020 at 2:41 PM

Re: calculating the MD5 hash of role passwords in C

2020-01-22 Thread Matthias Apitz
El día miércoles, enero 22, 2020 a las 07:52:51p. m. +, Igor Neyman escribió: > -Original Message- > From: Matthias Apitz [mailto:g...@unixarea.de] > Sent: Wednesday, January 22, 2020 2:41 PM > To: pgsql-general@lists.postgresql.org > Subject: Re: calculating the MD5 hash of role

RE: calculating the MD5 hash of role passwords in C

2020-01-22 Thread Igor Neyman
-Original Message- From: Matthias Apitz [mailto:g...@unixarea.de] Sent: Wednesday, January 22, 2020 2:41 PM To: pgsql-general@lists.postgresql.org Subject: Re: calculating the MD5 hash of role passwords in C . -- Matthias Apitz, ✉

Re: calculating the MD5 hash of role passwords in C

2020-01-22 Thread Matthias Apitz
El día miércoles, enero 22, 2020 a las 07:58:47p. m. +0100, Christoph Moench-Tegeder escribió: > ## Matthias Apitz (g...@unixarea.de): > > > sisis71=# select rolname, rolpassword from pg_authid where rolname = > > 'sisis'; > > rolname | rolpassword > >

Re: calculating the MD5 hash of role passwords in C

2020-01-22 Thread Christoph Moench-Tegeder
## Matthias Apitz (g...@unixarea.de): > sisis71=# select rolname, rolpassword from pg_authid where rolname = 'sisis'; > rolname | rolpassword > -+- > sisis | md52f128a1fbbecc4b16462e8fc8dda5cd5 > > I know the clear text password of the

Re: calculating the MD5 hash of role passwords in C

2020-01-22 Thread Adrian Klaver
On 1/22/20 10:20 AM, Matthias Apitz wrote: Hello, If I look into the database I see: sisis71=# select rolname, rolpassword from pg_authid where rolname = 'sisis'; rolname | rolpassword -+- sisis |

calculating the MD5 hash of role passwords in C

2020-01-22 Thread Matthias Apitz
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,