Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1az6RC-0000Hc-BO for pgsql-admin@arkaria.postgresql.org; Sat, 07 May 2016 17:54:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1az6RB-0003Zu-Lf for pgsql-admin@arkaria.postgresql.org; Sat, 07 May 2016 17:54:45 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1az6PV-0001hh-Ek for pgsql-admin@postgresql.org; Sat, 07 May 2016 17:53:01 +0000 Received: from shopzeus.com ([87.229.70.149]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1az6PS-0004Ih-Ih for pgsql-admin@postgresql.org; Sat, 07 May 2016 17:52:59 +0000 Received: from [127.127.127.127] (localhost [127.127.127.127]) (Authenticated sender: gandalf) by shopzeus.com (Postfix) with ESMTPSA id F299F889C90B; Sat, 7 May 2016 13:52:54 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=shopzeus.com; s=shopzeus_com; t=1462643575; bh=9kTu1fxF+STWzXeQ4lrh5zS0bwYfOgsqd5lJdA8rzYk=; h=Subject:To:References:Cc:From:Date:In-Reply-To:From; b=hy1HCKfuHKDTt77pZiTh6/ZjfNaCFdtfNhqwAUuNYJLd9y9dEfJVcDZMyQSZQeDQ4 nLwpCShDynsZFZDTGxWXr1/OSMbATfvL4EuN4vtn/UkNUcmZ3Vq7ZwFflPChjCIVcw Y99McMFdhnvupPiTi78Srj1kwxXNbAc0gBrE8NUdpqSbuno0cBuR+C0hTIjRTXcUR4 7sabp7+RIY15ly/V1tPJLDnnkgosdhyi/6/Q+x4xteQUZCl2p51c3Rjbt3K7Kc2DF3 Id9z9gzlWIsvR2RWOQS61Wgrw7bUgEUMsBTT+NjAlIalMufMrLh0ajesixqMmQhBdb X9+PXLxh4CfIQ== Subject: Re: md5 auth procotol - can it be replayed? To: Tom Lane , Stephen Frost References: <572E0BFE.7040709@shopzeus.com> <20160507155124.GP10850@tamriel.snowman.net> <23281.1462638517@sss.pgh.pa.us> Cc: pgsql-admin@postgresql.org From: =?UTF-8?Q?Nagy_L=c3=a1szl=c3=b3_Zsolt?= Message-ID: <572E2B83.10908@shopzeus.com> Date: Sat, 7 May 2016 19:53:07 +0200 MIME-Version: 1.0 In-Reply-To: <23281.1462638517@sss.pgh.pa.us> Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -6.4 (------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org >> There is a challenge/response compoent, so the md5 hash which is stored >> is not what is sent across the wire. That prevents replay attacks when >> the attacker is simply sniffing the network. > Worth noting here is that the challenge key space is not all that huge, > so an attacker who captures a large number of challenge/response pairs > would have a good probability of being able to answer the next challenge > successfully. However, if you're concerned about sniffing of your > database connections happening on that scale, you really ought to be using > SSL encryption which would make the whole thing moot. In many cases, > capturing a database session would reveal lots of interesting data passing > over the wire whether or not you'd captured a usable password --- so I'd > call it fairly irresponsible to not be using SSL if you think your > connection is open to sniffing. Thank you for your responses, this is exactly what I was looking for. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin