From owner-freebsd-questions@FreeBSD.ORG Wed Aug 9 00:30:41 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5DEA116A4DD; Wed, 9 Aug 2006 00:30:41 +0000 (UTC) (envelope-from scrappy@freebsd.org) Received: from hub.org (hub.org [200.46.204.220]) by mx1.FreeBSD.org (Postfix) with ESMTP id AF97543D66; Wed, 9 Aug 2006 00:30:40 +0000 (GMT) (envelope-from scrappy@freebsd.org) Received: from localhost (mx1.hub.org [200.46.208.251]) by hub.org (Postfix) with ESMTP id E6F00291AFD; Tue, 8 Aug 2006 21:30:34 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 57571-05; Tue, 8 Aug 2006 21:30:38 -0300 (ADT) Received: from ganymede.hub.org (blk-224-179-167.eastlink.ca [24.224.179.167]) by hub.org (Postfix) with ESMTP id 43477290C37; Tue, 8 Aug 2006 21:30:33 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1027) id 795735C54F; Tue, 8 Aug 2006 21:30:42 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 7859433DF1; Tue, 8 Aug 2006 21:30:42 -0300 (ADT) Date: Tue, 8 Aug 2006 21:30:42 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: freebsd@ganymede.hub.org To: Antony Mawer In-Reply-To: <44D91F02.90107@mawer.org> Message-ID: <20060808212719.L7522@ganymede.hub.org> References: <20060807003815.C7522@ganymede.hub.org> <20060808102819.GB64879@augusta.de> <20060808153921.V7522@ganymede.hub.org> <44D8EC98.8020801@utdallas.edu> <20060808201359.S7522@ganymede.hub.org> <44D91F02.90107@mawer.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: Paul Schmehl , "Marc G. Fournier" , freebsd-questions@freebsd.org Subject: Re: BSDstats Project v2.0 ... X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Aug 2006 00:30:41 -0000 On Wed, 9 Aug 2006, Antony Mawer wrote: > On 9/08/2006 9:16 AM, Marc G. Fournier wrote: >>> Can you tell me exactly what you do with those two pieces of data? Is >>> there any way that information would be accessible from the internet? >> >> Absolutely nothing else we do with it ... it just gives us a unique key to >> work with ... in fact, assuming each of your servers use a different IP, >> there is no reason you couldn't do the uname trick above to hide the >> hostname ... >> >> Unless someone breaks into the server, or database, somehow, the data isn't >> accessible ... > > What if we improved upon this - if instead of storing the hostname and IP > address, we stored a one-way hash of this information? OpenSSH in recent > versions takes the same approach with its authorized_keys files... Could create problems long term .. one thing I will be using the IPs to do is: SELECT ip, count(1) FROM systems GROUP BY ip ORDER BY count DESC; to look for any 'abnormalities' like todays with Armenia ... hashing it would make stuff like that fairly difficult ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664