On Tuesday 13 April 2004 11:57 am, Peter Morin wrote:
Just curious. My VLOG has grown to over a gig..is there a more elegant
way to rotating this than the normal delete vlog? Has anyone scripted
this?
err?
Perhaps you posted to the wrong mailing list by accident?
-Jeremy
--
Jeremy Kitchen
- Original Message -
From: Jeremy Kitchen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 10:22 AM
Subject: Re: [vchkpw] VLOGaaarg
On Tuesday 13 April 2004 12:12 pm, Peter Morin wrote:
[fixed broken quoting, please fix your MUA]
Just curious
,
peter
-Original Message-
From: Jeremy Kitchen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 2:22 PM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] VLOGaaarg
On Tuesday 13 April 2004 12:12 pm, Peter Morin wrote:
[fixed broken quoting, please fix your MUA]
Just
On Apr 13, 2004, at 10:47 AM, Bastiaan van der Put wrote:
Don't think there is some otherway then just write a delete script,
and put it in cron or somthing similair.
Hopefully you can write it as a script that sends an SQL command to
MySQL to have it delete log entries more than x days old.
]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 3:36 AM
Subject: RE: [vchkpw] VLOGaaarg
Sorry for the confusion Jeremy. I am using VPOPMAIL with the MySQL
database option. The vlog table (--enable-mysql-logging) allows to
maintain the vpopmail's vlog table in MySQL (shows failed
On Apr 13, 2004, at 4:22 PM, Michael Bowe wrote:
Yes, your best bet would be periodically issue an SQL command such as
DELETE FROM vlog WHERE timestamp whateverdate
This should work as well:
DELETE FROM vlog WHERE timestamp DATE_SUB(CURRENT_DATE, INTERVAL 7
DAY)
--
Tom Collins - [EMAIL
On Tue, 13 Apr 2004, Tom Collins wrote:
On Apr 13, 2004, at 4:22 PM, Michael Bowe wrote:
Yes, your best bet would be periodically issue an SQL command such as
DELETE FROM vlog WHERE timestamp whateverdate
This should work as well:
DELETE FROM vlog WHERE timestamp DATE_SUB(CURRENT_DATE,
On Apr 13, 2004, at 6:01 PM, Charles Sprickman wrote:
DELETE FROM vlog WHERE timestamp DATE_SUB(CURRENT_DATE, INTERVAL 7
DAY)
On 5.3.x, timestamp is in unix timestamp format, so you'll need
something
like DELETE FROM vlog WHERE timestamp
unixtime_where_you_want_to_delete_from.
Is using a MySQL