From owner-freebsd-questions@FreeBSD.ORG Wed Aug 9 10:42:09 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 976FC16A4DA for ; Wed, 9 Aug 2006 10:42:09 +0000 (UTC) (envelope-from nikolas.britton@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by mx1.FreeBSD.org (Postfix) with ESMTP id 47D3D43D76 for ; Wed, 9 Aug 2006 10:42:00 +0000 (GMT) (envelope-from nikolas.britton@gmail.com) Received: by nf-out-0910.google.com with SMTP id g2so133571nfe for ; Wed, 09 Aug 2006 03:41:56 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hW62MVEY8GMk8grTvGs+gssqzEvLaSA7+pskMsB9nSxBAuJV84RBOxEKfjDUOQEREQkq9e7Vf7yyU97zTpz1BJa4BNCZuT64xPe7mrHV9Jb7JPXwEAv6WvEAZ2dX76jYyd7t8pH1ZktBVQcQm3Q7qmA8XdJX8NwtpVfXQPzh1OU= Received: by 10.78.147.3 with SMTP id u3mr251471hud; Wed, 09 Aug 2006 03:41:55 -0700 (PDT) Received: by 10.78.143.11 with HTTP; Wed, 9 Aug 2006 03:41:55 -0700 (PDT) Message-ID: Date: Wed, 9 Aug 2006 05:41:55 -0500 From: "Nikolas Britton" To: "Igor Robul" In-Reply-To: <20060809072313.GA19441@sysadm.stc> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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> 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 10:42:09 -0000 On 8/9/06, 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 :-) I still like my idea the best for unique keys. It's a better way to detect hosts behind NATs, here it is again, four versions to pick from: # ifconfig | sha256 cbcc2f55a340c248af7e8a10871150d827af11d7051bbc782eefa04b0603248b # ifconfig | sha1 b607b9d45e6ad40c02ab20800e0d70245ab6db68 # ifconfig | md5 22a2a3eca61166fb113f1a688b3dd842 # ifconfig | cksum 3977021799 540 The only down side is it still can be faked, just like everything else. -- BSD Podcasts @: http://bsdtalk.blogspot.com/ http://freebsdforall.blogspot.com/