From owner-freebsd-questions Mon Apr 15 19:51:31 2002 Delivered-To: freebsd-questions@freebsd.org Received: from catalyst.sasknow.net (catalyst.sasknow.net [207.195.92.130]) by hub.freebsd.org (Postfix) with ESMTP id 653F437B416 for ; Mon, 15 Apr 2002 19:51:28 -0700 (PDT) Received: from localhost (ryan@localhost) by catalyst.sasknow.net (8.11.6/8.11.6) with ESMTP id g3G2pQ065755; Mon, 15 Apr 2002 20:51:26 -0600 (CST) (envelope-from ryan@sasknow.com) X-Authentication-Warning: catalyst.sasknow.net: ryan owned process doing -bs Date: Mon, 15 Apr 2002 20:51:26 -0600 (CST) From: Ryan Thompson To: Ronnie Clark Cc: freebsd-questions@FreeBSD.ORG Subject: Re: IPFW Logging In-Reply-To: <1018924374.215.3.camel@compudyne2.clark.us> Message-ID: <20020415203432.U57269-100000@catalyst.sasknow.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Ronnie Clark wrote to freebsd-questions@FreeBSD.ORG: > Hello all! > > Two quick questions. Is it possible to have IPFW log to a mysql > database? Or do I need a third party software, or some custom script > to accomplish this? IPFW logs to syslogd(8). See syslog.conf(5)... it is possible to pipe syslog output to a command, which could then, in theory, be used to parse the log entries and insert them into a database. Not having ever had occasion to try this, I would recommend thorough load testing. :-) - Ryan -- Ryan Thompson SaskNow Technologies - http://www.sasknow.com 901 1st Avenue North - Saskatoon, SK - S7K 1Y4 Tel: 306-664-3600 Fax: 306-664-3630 Saskatoon Toll-Free: 877-727-5669 (877-SASKNOW) North America To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message