Received: with LISTAR (v1.0.0; list gopher); Sat, 06 Oct 2001 01:27:28 -0500 (EST) Return-Path: <spectre@stockholm.ptloma.edu> Delivered-To: gopher@complete.org Received: from stockholm.ptloma.edu (stockholm.ptloma.edu [199.106.86.50]) by pi.glockenspiel.complete.org (Postfix) with ESMTP id 2BD703B80B for <gopher@complete.org>; Sat, 6 Oct 2001 01:27:28 -0500 (EST) Received: (from spectre@localhost) by stockholm.ptloma.edu (8.9.1/8.9.1) id XAA07958 for gopher@complete.org; Fri, 5 Oct 2001 23:32:10 -0700 From: Cameron Kaiser <spectre@stockholm.ptloma.edu> Message-Id: <200110060632.XAA07958@stockholm.ptloma.edu> Subject: [gopher] Re: Taps for dead servers In-Reply-To: <20011005163433.A22770@mothra.dyndns.org> from David Allen at "Oct 5, 1 04:34:33 pm" To: gopher@complete.org Date: Fri, 5 Oct 2001 23:32:10 -0700 (PDT) X-Mailer: ELM [version 2.4ME+ PL39 (25)] MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-archive-position: 218 X-listar-version: Listar v1.0.0 Sender: gopher-bounce@complete.org Errors-to: gopher-bounce@complete.org X-original-sender: spectre@stockholm.ptloma.edu Precedence: bulk Reply-to: gopher@complete.org List-help: <mailto:listar@complete.org?Subject=help> List-unsubscribe: <mailto:gopher-request@complete.org?Subject=unsubscribe> List-software: Listar version 1.0.0 X-List-ID: Gopher <gopher.complete.org> List-subscribe: <mailto:gopher-request@complete.org?Subject=subscribe> List-owner: <mailto:jgoerzen@complete.org> List-post: <mailto:gopher@complete.org> List-archive: <http://www.complete.org/mailinglists/archives/> X-list: gopher

> Wow - you know one of the things that struck me when looking at that > list was that it looks like there's > 2% of servers running on > nonstandard (Read: != 70) ports. Is there any way you could do some > sort of a quick grep to let us know roughly the percentage in the > entire system where this is the case?

mysql> select count(*) from v2_stats where port != 70 ; +----------+ | count(*) | +----------+ | 126 | +----------+ 1 row in set (0.04 sec)

mysql> select count(*) from v2_stats ; +----------+ | count(*) | +----------+ | 509 | +----------+ 1 row in set (0.00 sec)

Straight from the horse's mouth, as it were :-)

-- ----------------------------- personal page: http://www.armory.com/~spectre/ -- Cameron Kaiser, Point Loma Nazarene University * ckaiser@stockholm.ptloma.edu -- The whippings shall continue until morale improves. ------------------------