From owner-freebsd-questions@FreeBSD.ORG Wed Aug 9 07:22:26 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 96C3116A4E0 for ; Wed, 9 Aug 2006 07:22:26 +0000 (UTC) (envelope-from igorr@speechpro.com) Received: from speechpro.ru (speech-tech-2.ip.PeterStar.net [81.3.190.130]) by mx1.FreeBSD.org (Postfix) with ESMTP id D443D43D6B for ; Wed, 9 Aug 2006 07:22:25 +0000 (GMT) (envelope-from igorr@speechpro.com) Received: from [192.168.2.26] (helo=sysadm.stc) by s1.stc with esmtp (Exim 4.53 (FreeBSD)) id 1GAiOW-000Gcf-5f for freebsd-questions@freebsd.org; Wed, 09 Aug 2006 11:22:24 +0400 Received: from localhost.stc ([127.0.0.1] helo=sysadm.stc) by sysadm.stc with esmtp (Exim 4.62 (FreeBSD)) (envelope-from ) id 1GAiPJ-0005Gi-PW for freebsd-questions@freebsd.org; Wed, 09 Aug 2006 11:23:13 +0400 Received: (from igorr@localhost) by sysadm.stc (8.13.6/8.13.6/Submit) id k797NDVH020255 for freebsd-questions@freebsd.org; Wed, 9 Aug 2006 11:23:13 +0400 (MSD) (envelope-from igorr) Date: Wed, 9 Aug 2006 11:23:13 +0400 From: Igor Robul To: freebsd-questions@freebsd.org Message-ID: <20060809072313.GA19441@sysadm.stc> 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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060808212719.L7522@ganymede.hub.org> User-Agent: Mutt/1.5.12-2006-07-14 X-Archived: Yes 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 07:22:26 -0000 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 :-)