From owner-freebsd-questions@FreeBSD.ORG  Wed Jul  2 08:46:01 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 643C9106566C
	for <freebsd-questions@freebsd.org>;
	Wed,  2 Jul 2008 08:46:01 +0000 (UTC)
	(envelope-from nicolas@nicoelro.net)
Received: from mail.nicoelro.net (helm.nicoelro.net [87.98.216.147])
	by mx1.freebsd.org (Postfix) with ESMTP id 253808FC1B
	for <freebsd-questions@freebsd.org>;
	Wed,  2 Jul 2008 08:46:00 +0000 (UTC)
	(envelope-from nicolas@nicoelro.net)
Received: by mail.nicoelro.net (Postfix, from userid 58)
	id 4505479B85; Wed,  2 Jul 2008 10:45:59 +0200 (CEST)
X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on helm.nicoelro.net
X-Spam-Level: 
X-Spam-Status: No, score=-4.4 required=6.0 tests=ALL_TRUSTED,AWL,BAYES_00
	autolearn=ham version=3.2.5
Received: from nogrod.nicoelro.net (162.102.82-79.rev.gaoland.net
	[79.82.102.162])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	(Authenticated sender: nicolas@nicoelro.net)
	by mail.nicoelro.net (Postfix) with ESMTP id 2BE8979B47
	for <freebsd-questions@freebsd.org>;
	Wed,  2 Jul 2008 10:45:58 +0200 (CEST)
Date: Wed, 2 Jul 2008 10:45:54 +0200
From: Nicolas Letellier <nicolas@nicoelro.net>
To: FreeBSD Questions <freebsd-questions@freebsd.org>
Message-ID: <20080702104554.6b1ebb45@nogrod.nicoelro.net>
X-Mailer: Claws Mail 3.3.0 (GTK+ 2.12.7; i386-unknown-openbsd4.3)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Subject: mysql log and newsyslog
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 02 Jul 2008 08:46:01 -0000

Hello.

I have a problem with mysql logs and newsyslog. I archive mysql log
with this in my my.cnf:
log=/var/log/mysql

My log works fine.
However, when newsylog archives the log and create a new log file,
mysql doesn't log anymore anything.

See my newsyslog.conf:
/var/log/mysql  mysql:wheel 640  100   *    @T23  Z

And after 23:00:
-rw-r-----  1 mysql  wheel      62  1 jul 23:00 mysql
-rw-r-----  1 mysql  wheel  213993  1 jul 23:00 mysql.0.gz

The old log is archived, the new is created, but mysql doestn't log
anymore anything.

Any idea to solve this problem? 

Thanks!

-- 
 - Nicolas.