Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

Next:From: Tom LaneDate: 2006-02-22 14:28:01
Subject: Re: Finding the pqlib version
Previous:From: Peter EisentrautDate: 2006-02-22 12:44:56
Subject: Re: Finding the pqlib version

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group