Postgres Pro
Downloads
Home   >   mailing lists

MD5 Authentication - Mailing list pgsql-general

From Raimon Fernandez
Subject MD5 Authentication
Date
Msg-id 5D659A3C-CF3D-4FB1-8C3D-279E4E2C6216@montx.com
Whole thread Raw
In response to Re: How can I pass an array to SPI_execute_with_args()?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: MD5 Authentication  (Sam Mason <sam@samason.me.uk>)
Re: MD5 Authentication  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
List pgsql-general
Tree view 
Hello again ...


I'm trying to Authenticate to some PostgreSQL using MD5.

I can get the salt, for example:

A7 2E DB 2F


Docs: AuthenticationMD5Password (B)
----------------------------------------------------------------------------------------
- Byte1(’R’) Identifies the message as an authentication request.
- Int32(12) Length of message contents in bytes, including self.
- Int32(5) Specifies that an MD5-encrypted password is required.
- Byte4 The salt to use when encrypting the password.

I'm not sure if I have to use 4 bytes (A7 2E DB 2F) or only the fourth
byte (2F)

And, where I have to add the salt, before the password or after the
password ?

Despite I've been trying all possibilities, but postgresql answers
with a FATAL error ...

:-)

I'm sure my MD5 rutines are working OK as they give me the same
results as other tools.

Maybe my problem is in sending the correct values, but once I'm sure
how the format is, I'll be sure where to lookfor ...

thanks again,

regards,

raimon

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump native format will not restore correctly
Next
From: "Scot Kreienkamp"
Date:
Subject: Re: pg_dump native format will not restore correctly