Yes, your best bet would be periodically issue an SQL command such as
"DELETE FROM vlog WHERE timestamp < whateverdate"
Also note that vpopmail < v5.3.14 used to log all auth requests (successful
and fails) to vlog, which resulted in that table growing very big very fast
5.3.14 and later included a fix so that the amount of detail logged to vlog
would be controlled by the "--enable-logging=" configure switch
In most cases, you would only want to log auth failures, so make sure you
have set --enable-logging=p
----- Original Message -----
From: "Peter Morin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 14, 2004 3:36 AM
Subject: RE: [vchkpw] VLOG....aaarrrrrggggg!!!!
> 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 authentication
> MySQL and VPOPMAIL -
> -----Original Message-----
> From: Jeremy Kitchen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 13, 2004 2:22 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [vchkpw] VLOG....aaarrrrrggggg!!!!
> On Tuesday 13 April 2004 12:12 pm, Peter Morin wrote:
> [fixed broken quoting, please fix your MUA]
> > > > Just curious. My VLOG has grown to over a gig..is there a more
> > > > way to rotating this than the normal delete vlog? Has anyone
> > > > this?
> > > Perhaps you posted to the wrong mailing list by accident?
> > Is this not the list for vpopmail issues?
> I guess I don't know what you're talking about when you talk about
> vpopmail I believe logs to syslog, and if you're having syslog issues
> should be asking either your OS vendor, or the list of the system logger
> you're running.
> If there's something else you're talking about, perhaps you could expand
> your original question to let us know exactly what you're talking about.
> Jeremy Kitchen
> Systems Administrator
> [EMAIL PROTECTED]
> Kitchen @ #qmail on EFNet - Join the party!
> Inter7 Internet Technologies, Inc.
> 866.528.3530 toll free
> 847.492.0470 int'l
> 847.492.0632 fax
> GNUPG key ID: 93BDD6CE