From owner-freebsd-questions@FreeBSD.ORG Wed Aug 9 08:54:31 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 BA94616A4DA for ; Wed, 9 Aug 2006 08:54:31 +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 5DA7943D66 for ; Wed, 9 Aug 2006 08:54:26 +0000 (GMT) (envelope-from scrappy@freebsd.org) Received: from localhost (mx1.hub.org [200.46.208.251]) by hub.org (Postfix) with ESMTP id 75240291B02; Wed, 9 Aug 2006 05:54:22 -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 21127-02; Wed, 9 Aug 2006 05:54:24 -0300 (ADT) Received: from ganymede.hub.org (blk-224-179-167.eastlink.ca [24.224.179.167]) by hub.org (Postfix) with ESMTP id 17E9D291B00; Wed, 9 Aug 2006 05:54:21 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1027) id 7E8C45D2F1; Wed, 9 Aug 2006 05:54:26 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 768785D2B2; Wed, 9 Aug 2006 05:54:26 -0300 (ADT) Date: Wed, 9 Aug 2006 05:54:26 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: freebsd@ganymede.hub.org To: Igor Robul In-Reply-To: <20060809072313.GA19441@sysadm.stc> Message-ID: <20060809055245.J7522@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> <20060808212719.L7522@ganymede.hub.org> <20060809072313.GA19441@sysadm.stc> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: 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 08:54:31 -0000 On Wed, 9 Aug 2006, Igor Robul wrote: > On Tue, Aug 08, 2006 at 09:30:42PM -0300, Marc G. Fournier wrote: >> 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 ... > You can make _two_ hashes and then concatenate to form unique key. > Then you still be able to see "a lot of single IPs". Personaly, I dont > care very much about IP/hostname disclosure :-) Except that you are disclosing that each and every time you send out an email, or hit a web site ... :) Regardless, though ... what do ppl suggest here? Simple 'md5' hash? ---- 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