X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5D1049DC806 for ; Wed, 22 Feb 2006 10:22:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21861-04 for ; Wed, 22 Feb 2006 10:22:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.198]) by postgresql.org (Postfix) with ESMTP id D4B569DCB81 for ; Wed, 22 Feb 2006 10:22:47 -0400 (AST) Received: by uproxy.gmail.com with SMTP id j3so782837ugf for ; Wed, 22 Feb 2006 06:22:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=nLXRfasDs1S0ZteSk5XF0d+pbdPEoK1rPZ996z/iD7WgA4drk7ryknuclRU5ZCZ7grLZsQpxAuRYeeMxMWi2iw7NOAAlCUvDjWZpTcn/spLIV5CtucviS1kWXiBmJOs+bzmzxRY7ft6gL0yoiYOrxMVSC66dBkr9NKkroDqz1Tk= Received: by 10.66.225.18 with SMTP id x18mr2499710ugg; Wed, 22 Feb 2006 06:22:51 -0800 (PST) Received: by 10.66.224.11 with HTTP; Wed, 22 Feb 2006 06:22:51 -0800 (PST) Message-ID: <4a0cafe20602220622g77666533k7564b439e83ce55@mail.gmail.com> Date: Wed, 22 Feb 2006 08:22:51 -0600 From: "Josh Close" To: pgsql-interfaces@postgresql.org Subject: protocol, md5 authentication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25050_22629475.1140618171256" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.461 required=5 tests=[AWL=0.515, HTML_10_20=0.945, HTML_MESSAGE=0.001] X-Spam-Score: 1.461 X-Spam-Level: * X-Archive-Number: 200602/68 X-Sequence-Number: 6032 ------=_Part_25050_22629475.1140618171256 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 ------=_Part_25050_22629475.1140618171256 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I can't seem to get the md5 authentication to work with the postgres protoc= ol 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 authent= ication request.

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

1. Comb= ine password + user.
2. MD5 hash the result.
3. Add the salt to the e= nd of that.
4. Hash the result.
5. Add "md5" to the front o= f this, so postgres knows it's md5.

This hasn't worked for me.

What is the correct way of MD5 au= thenticating?

-Josh
------=_Part_25050_22629475.1140618171256--