X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5B01BD1C914 for ; Fri, 5 Mar 2004 15:17:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 54418-05 for ; Fri, 5 Mar 2004 11:17:34 -0400 (AST) Received: from magic.lif.icnet.uk (magic.lif.icnet.uk [143.65.100.6]) by svr1.postgresql.org (Postfix) with ESMTP id 61366D1DAC8 for ; Fri, 5 Mar 2004 11:17:28 -0400 (AST) Received: from atlantis.ox.icnet.uk (atlantis.ox.icnet.uk [143.65.27.60]) by magic.lif.icnet.uk (8.9.3p2/8.9.3) with ESMTP id PAA16750 for ; Fri, 5 Mar 2004 15:17:29 GMT Received: from halcyon (mail@halcyon.ox.icnet.uk [143.65.27.48]) by atlantis.ox.icnet.uk (8.12.6/8.12.6) with ESMTP id i25FHNPS018161 for ; Fri, 5 Mar 2004 15:17:23 GMT Received: from alex by halcyon with local (Exim 3.36 #1 (Debian)) id 1AzH4l-0005oU-00 for ; Fri, 05 Mar 2004 15:17:23 +0000 Resent-From: Alex Page Resent-Date: Fri, 5 Mar 2004 15:17:23 +0000 Resent-Message-ID: <20040305151723.GD11311@halcyon.ox.icnet.uk> Resent-To: pgsql-admin@postgresql.org Date: Fri, 5 Mar 2004 15:11:54 +0000 From: Alex Page To: Mitch Pirtle Subject: Re: Database Encryption (now required by law in Italy) Message-ID: <20040305151154.GC11311@halcyon.ox.icnet.uk> References: <200403050951.33230.silvanadimartino@tin.it> <40484403.70001@aldratech.com> <200403051245.10681.silvanadimartino@tin.it> <20040305121254.GK13042@nemesis.ox.icnet.uk> <40488640.1040409@spacemonkeylabs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <40488640.1040409@spacemonkeylabs.com> User-Agent: Mutt/1.5.5.1+cvs20040105i Resent-Sender: Alex Page X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/48 X-Sequence-Number: 12618 On Fri, Mar 05, 2004 at 08:53:04AM -0500, Mitch Pirtle wrote: > I understand (and demand) requiring SSL connections for database > clients, and MD5 hashing of passwords before storing in the database, > but implementing two-way encryption of database data just doesn't make > sense to me. It all comes down to what you're trying to protect your data *from*. If you're trying to protect it from people sniffing network traffic between clients and the server, then SSL is sensible. If you're trying to protect against somebody reading passwords out of a database and using them to impersonate other users, use MD5 (or SHA) hashing. If you're trying to protect against somebody taking down your server room door with a sledgehammer, lifting your server out of the rack, driving it away and booting off an alternative medium to avoid needing to know your root password, then a loopback encrypted partition (or data encrypted in GPG where the decryption key is not stored on the database server) is a sensible precaution. I expect that for most database users, it comes down to meeting the standards defined by law rather than realistic expectations of an attack - I expect that most of the situations we attempt to prevent are unlikely in the extreme, but we have various contractual and legal obligations which mean we have to defend against them anyway. Of course, this loopback encryption with a boot-time passphrase may fail if they take the rackmount UPS as *well*, and keep the machine powered at all times ;) Alex -- Mail: Alex Page Real: Systems/Network Assistant, Epidemiology Unit, Oxford Tel: 01865 302 223 (external) / 223 (internal) PGP: 8868 21D7 3D35 DD77 9D06 BF0A 0746 2DE6 55EA 367E