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 |
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."
> > >
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."
> > >
## 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.
-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,
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
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
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
-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, ✉
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
> >
## 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
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 |
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,
13 matches
Mail list logo