From owner-freebsd-pf@FreeBSD.ORG  Fri Mar 24 14:26:04 2006
Return-Path: <owner-freebsd-pf@FreeBSD.ORG>
X-Original-To: freebsd-pf@freebsd.org
Delivered-To: freebsd-pf@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 6EF7016A420
	for <freebsd-pf@freebsd.org>; Fri, 24 Mar 2006 14:26:04 +0000 (UTC)
	(envelope-from kl@os.lv)
Received: from balodis.pvd.gov.lv (balodis.pvd.gov.lv [159.148.155.109])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9C4BC43D77
	for <freebsd-pf@freebsd.org>; Fri, 24 Mar 2006 14:26:01 +0000 (GMT)
	(envelope-from kl@os.lv)
Received: from balodis.pvd.gov.lv (mail [192.168.2.10])
	by balodis.pvd.gov.lv (Postfix) with ESMTP id B42D38508C2
	for <freebsd-pf@freebsd.org>; Fri, 24 Mar 2006 16:25:59 +0200 (EET)
Received: by balodis.pvd.gov.lv (Postfix, from userid 65534)
	id 9B2C98508C7; Fri, 24 Mar 2006 16:25:59 +0200 (EET)
Received: from [192.168.1.21] (sr [159.148.155.3])
	by balodis.pvd.gov.lv (Postfix) with ESMTP id 54E0B8508C2
	for <freebsd-pf@freebsd.org>; Fri, 24 Mar 2006 16:25:56 +0200 (EET)
Message-ID: <4424018D.5000500@os.lv>
Date: Fri, 24 Mar 2006 16:26:21 +0200
From: Casper <kl@os.lv>
User-Agent: Thunderbird 1.5 (X11/20060313)
MIME-Version: 1.0
To: freebsd-pf@freebsd.org
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Checker-Version: SpamAssassin 3.0.0 (2004-09-13) on mail
X-Spam-Level: 
X-Spam-Status: No, score=0.0 required=5.0 tests=none autolearn=failed 
	version=3.0.0
X-AV-Checked: SMTP-scan
Subject: Collecting pf log...
X-BeenThere: freebsd-pf@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: "Technical discussion and general questions about packet filter
	\(pf\)" <freebsd-pf.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-pf>,
	<mailto:freebsd-pf-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-pf>
List-Post: <mailto:freebsd-pf@freebsd.org>
List-Help: <mailto:freebsd-pf-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-pf>,
	<mailto:freebsd-pf-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 24 Mar 2006 14:26:04 -0000


  Hi,

  I currently have 3 isp`s routers and want to make central collection 
for logs in one place and give other people possible to make statistics 
etc. How I understand it is possible to write all log to sql database, 
but I heard that it is not good idea, because writing on line logs to 
sql database is not so fast as it to write to file, I can slow down my 
internet line. I have p4 2.4 512ram with ata disk router. I have 
suggested to make script what at night write log file to sql db.
  Any suggestion, have experience?

thnx,

Casper