protocol, md5 authentication

From: "Josh Close" <narshe(at)gmail(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: protocol, md5 authentication
Date: 2006-02-22 14:22:51
Message-ID: 4a0cafe20602220622g77666533k7564b439e83ce55@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I can't seem to get the md5 authentication to work with the postgres
protocol version 3.

The docs don't really say how to send an authenticated password, just that
you need to use the returned salt from the md5 authentication request.

I've read somewhere that it needs to work like this:

1. Combine password + user.
2. MD5 hash the result.
3. Add the salt to the end of that.
4. Hash the result.
5. Add "md5" to the front of this, so postgres knows it's md5.

This hasn't worked for me.

What is the correct way of MD5 authenticating?

-Josh

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2006-02-22 14:28:01 Re: Finding the pqlib version
Previous Message Peter Eisentraut 2006-02-22 12:44:56 Re: Finding the pqlib version