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 Michael. ----- 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 > requests). > > MySQL and VPOPMAIL - > http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm > > Cheers, > peter > > -----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 > elegant > > > > way to rotating this than the normal delete vlog? Has anyone > scripted > > > > 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 > 'vlog'.... > vpopmail I believe logs to syslog, and if you're having syslog issues > you > 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 > on > your original question to let us know exactly what you're talking about. > > -Jeremy > > -- > Jeremy Kitchen > Systems Administrator > [EMAIL PROTECTED] > Kitchen @ #qmail on EFNet - Join the party! > ..................... > Inter7 Internet Technologies, Inc. > www.inter7.com > 866.528.3530 toll free > 847.492.0470 int'l > 847.492.0632 fax > GNUPG key ID: 93BDD6CE > >
