Date: Wed, 9 Aug 2006 11:23:13 +0400 From: Igor Robul <igorr@speechpro.com> To: freebsd-questions@freebsd.org Subject: Re: BSDstats Project v2.0 ... Message-ID: <20060809072313.GA19441@sysadm.stc> In-Reply-To: <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> <20060808212719.L7522@ganymede.hub.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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 :-)
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060809072313.GA19441>