Re: [vchkpw] Vpasswd question

2004-04-13 Thread Marty Buchaus
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Charles use vmoduser to change the users name and or password.. also you
can use vqadmin..  it's setup on Neon.
Charles Wu wrote:

| Hi,
|
| Having some issues w/ vpasswd, and was wondering if anyone would know
| the answer
|
| Basically, trying to use the vpasswd command to change a virtual domains
| user password, but for some reason, I get the following:
|
| [EMAIL PROTECTED] include]$ vpasswd [EMAIL PROTECTED]
| Enter the user's new password:
| Please type it again for verification:
| vpasswd: error changing the password for user
| '[EMAIL PROTECTED]':
|   Invalid or unknown virtual user
|
| What's weird is the fact that if I do a vuserinfo on the same user, I
| get info showing that the account exists, but for some reason, can't
| seem to change it
|
| [EMAIL PROTECTED] include]$ vuserinfo [EMAIL PROTECTED]
| name:   postmaster
| passwd: $1$OsSOD$jxfjlOBzcu4ah8Wlz6yYe.
| clear passwd:
| uid:1
| gid:0
| all services available
| dir:   /home/vpopmail/domains/hydeparkart.org/postmaster
| quota: NOQUOTA
| usage: NOQUOTA
| account created: Thu Oct 23 12:04:42 2003
| last auth: Never logged in
| [EMAIL PROTECTED] include]$
|
| Any pointers would be greatly appreciated...
|
| Thanks
|
| -Charles
|
- --
William Marty Buchaus
- - --
RHCE (Red Hat Certified Engineer) - 807101943103186
ICQ 10579998 AIM snuffychi Yahoo snuffychi
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFAe39vgYaEba/UDqcRAg/DAKD8LLMTHARfG96e1KfRSB0PzDlZvACgv3B8
vW5jORKLvULvaEIKdC6umiE=
=16xt
-END PGP SIGNATURE-


Re: [vchkpw] vqadmin silly question?

2004-04-13 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Tuesday 13 April 2004 08:00 am, Ken Jones wrote:
 On Monday 12 April 2004 7:50 am, Fajar Priyanto wrote:
  Hi all,
  I hope it's not too silly for asking this:
  When I was setting up a domain using vqadmin, what does it mean and how
  to fill it in:
  Accounts: -- I assume it's the number of mailbox allowed? What if I want
  to set it unlimited?
  Forwards:
  Aliases:
  Autoresponder:
  Mailing lists:

 I think -1 means unlimited. Or just leave the fields blank.

 Ken Jones

Thanks Jones!
- -- 
Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org
13:32:55 up 5:25, Mandrake Linux release 9.2 (FiveStar) for i586 
public key: https://www.arinet.org/fajar-pub.key
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAe4mukp5CsIXuxqURAr4bAJwIdz+aQnEcg+YOv2i+OD4zFPmRfACdFB+/
TQdL5Opx9pThAHVU3k3RrAg=
=BYE3
-END PGP SIGNATURE-



Re: [vchkpw] a lost passwords files

2004-04-13 Thread David Diaz
Ok thanks, but in the old server (where I just have the sqwebmail pass 
files) there are no mysql installed...
My point is how could migrate all the domains (users and password) to new 
server if I want install it with vpopmail  and mysql from an old server 
(current) with vpopmail 4.9 without mysql and without vpasswd files (or 
cdb), just sqwebmail pass???

sir_ddd





From: Ken Jones [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] a lost passwords files
Date: Mon, 12 Apr 2004 19:59:40 -0500
On Monday 12 April 2004 4:22 pm, David Diaz wrote:
 Hi, I have a trouble and I hope you can help me..

 I had a old server with qmail, vpopmail 4.9 and sqwebmail 1.0 on linux
 6.1 without mysql support and this is working very good... actually I 
need
 migrate it to other server (new server) with newers version of 
vpopmail
 and sqwebmail and mysql support and handle the clear passwords option on
 the table of mysql...

 The big trouble is that on the old server I don't have any passwords
 files, I mean there are no one vpasswd files or vpasswd.cdb
 formart...anything... I just have a sqwebmaill pass file for each 
account
 and this password is crypted

 it's very important for me to keep the original passwords for each
 user...How can import the passwords filesany idea

If your current vpopmail setup uses mysql you won't see any
vpasswd files. All the info is stored in the database.
Ken Jones
_
Únete al mayor servicio mundial de correo electrónico:  
http://www.hotmail.com



[vchkpw] vadddomain

2004-04-13 Thread Jasmine



Whenever i try to run vadddomain to add a virtual 
domain, i get this error message:

vmysql: sql error[3]: MySQL server has gone 
awayvmysql: sql error[2]: MySQL server has gone awayFailed while 
attempting to add user to auth backendError: (vadduser) no auth 
connection
Meanwhile mysql service runs;

mail3# ps waux | grep 
mysqlroot 8025 0.0 0.1 924 
668 p0- I Thu01PM 0:00.01 /bin/sh 
bin/safe_mysqldmysql 8035 0.0 1.7 38028 18028 
p0- S Thu01PM 1:13.98 
(mysqld)
Please can someone tell me why i get this error 
message?

jasmine.




RE: [vchkpw] vadddomain

2004-04-13 Thread David Diaz
Maybe could be a differents things, try to check:

a) The user of vpopmail to access to mysql db exists and the user and 
passwords is correct
b) This user (vpopmail user) has the right permissions to db
c) Try to conect to db from your prompt, I mean:
#mysql --user=vpopmail --database=vpopmail --password=password

and the last thing check in your etc directory of vpopmail 
(home/vpopmail/etc) exists the file:
vpopmail.mysql with the correct permissions, something like that:

-rw-r--r--1 vpopmail vchkpw636 abr  6 00:53 vpopmail.mysql

and check this file (open it) and you need to have somthing similar:

localhost|0|vpopmail|password|database
localhost|0|root|password|database


From: Jasmine [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [vchkpw] vadddomain
Date: Mon, 12 Apr 2004 23:43:38 +0200
Whenever i try to run vadddomain to add a virtual domain, i get this error 
message:

vmysql: sql error[3]: MySQL server has gone away
vmysql: sql error[2]: MySQL server has gone away
Failed while attempting to add user to auth backend
Error: (vadduser) no auth connection
Meanwhile mysql service runs;

mail3# ps waux | grep mysql
root8025  0.0  0.1   924  668  p0- IThu01PM   0:00.01 /bin/sh 
bin/safe_mysqld
mysql   8035  0.0  1.7 38028 18028  p0- SThu01PM   1:13.98  (mysqld)

Please can someone tell me why i get this error message?

jasmine.


_
MSN Fotos: la forma más fácil de compartir e imprimir fotos.  
http://photos.msn.es/support/worldwide.aspx



[vchkpw] Re: How to avoid rblsmtpd for smtp authenticated users

2004-04-13 Thread Peter Palmreuther
Hello Devendra,

On Monday, April 12, 2004 at 12:42:53 PM you wrote (at least in part):

 Is it possible to not to do rblsmtpd look-up for smtp-authenticated users?

No, because rblsmtpd looks up the IP before SMTP-AUTH is (or can be)
done.
-- 
Best regards
Peter Palmreuther

Since we're all here, we must not be all there. -- Bob Mountain Beck



RE: [vchkpw] vadddomain

2004-04-13 Thread Shane Chrisp



Whats in your ~vpopmail/etc/vpopmail.mysql 
file?

The format is meant to be like

192.168.0.1|3306|vpopmail|password|vpopmail

The password is plain text as well.

Sometimes there is a problem with connections using sockets 
so its worth trying to
connect with tcp instead.

Shane

  
  
  From: Jasmine 
  [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 April 
  2004 5:44 AMTo: [EMAIL PROTECTED]Subject: [vchkpw] 
  vadddomain
  
  Whenever i try to run vadddomain to add a virtual 
  domain, i get this error message:
  
  vmysql: sql error[3]: MySQL server has gone 
  awayvmysql: sql error[2]: MySQL server has gone awayFailed while 
  attempting to add user to auth backendError: (vadduser) no auth 
  connection
  Meanwhile mysql service runs;
  
  mail3# ps waux | grep 
  mysqlroot 8025 0.0 0.1 924 
  668 p0- I Thu01PM 0:00.01 /bin/sh 
  bin/safe_mysqldmysql 8035 0.0 1.7 38028 
  18028 p0- S Thu01PM 1:13.98 
  (mysqld)
  Please can someone tell me why i get this error 
  message?
  
  jasmine.
  
  


[vchkpw] Re: pros and cons of smtp auth and pop before smtp

2004-04-13 Thread Peter Palmreuther
Hello Jeff,

On Monday, April 12, 2004 at 4:48:28 PM you wrote (at least in part):

2. pop before smtp?

 - creates problems with qmail-scanner. Servers authorized to relay skip
 qmail-scanner virus checks.

*err* _Clients_ authorized to relay skip qmail-scanner _SpamAssassin_
checks.

But there is nothing that prevents you from editing qmail-scanner
source code (pure Perl) and change the line that checks for
$RELAYCLIENT and skips the SA-tests. Make the 'if' statement always
return false (e.g. by prepending '0  ' in front of
'defined($ENV{'RELAYCLIENT'}' and you're done.

Or alter vpopmail sources to set QS_SPAMASSASSIN additionally to
RELAYCLIENT for POP3 authenticated users.
-- 
Best regards
Peter Palmreuther

Man steps in with a terminal grin... blue skies turn to grey...



[vchkpw] Re: a lost passwords files

2004-04-13 Thread Peter Palmreuther
Hello David,

On Monday, April 12, 2004 at 11:22:47 PM you wrote (at least in part):

 it's very important for me to keep the original passwords for each 
 user...How can import the passwords files

Put the encrypted password from sqwebmail password files in vpopmail
password field.
If you enable --learn-password for your new vpopmail it should fill
the clear password fields automatically after successful
authentication done by the user.
-- 
Best regards
Peter Palmreuther

What do you call a sorority girl with a runny nose?  Full.



Read: [vchkpw] Re: a lost passwords files

2004-04-13 Thread Clayton Weise
attachment: winmail.dat

Read: [vchkpw] Re: a lost passwords files

2004-04-13 Thread Jasper Veltman
attachment: winmail.dat

Read: [vchkpw] Re: a lost passwords files

2004-04-13 Thread Srgio Manuel Rosa
Your message

To:  David Diaz in vpop
Subject:  4/13/2004 4:06 PM

was read on 4/13/2004 4:09 PM.

bin0.bin
Description: message/disposition-notification


RE: [vchkpw] vpopmaild development

2004-04-13 Thread Iavor Raytchev
[snip]
Tom:

At the very least, vpopmaild discussion should be on vpopmail-devel
instead of the vchkpw list.  I am sure that there are others, like me,
who aren't interested in following the early stages of development and
would prefer not to receive 20-30 messages a day discussing it.
[snip]

May be I am catching up a bit too late. Did the vpopmaild discussion move
somewhere?

I would support this for another reason. The vpopmail daemon is quite
important - may be for some it is just a vpopmail 'feature' of vpopmail as
for others it is a door to a whole universe.




Re: [vchkpw] VLOG....aaarrrrrggggg!!!!

2004-04-13 Thread Jeremy Kitchen
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
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


Re: [vchkpw] VLOG....aaarrrrrggggg!!!!

2004-04-13 Thread John Johnson

- 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. 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?

 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.

I would dare to guess he is talking about loging to the MySQL database
not to syslog.

-John



[vchkpw] envelope sender domain must exist?

2004-04-13 Thread Toshiro Viera
Hi!

I've installed the packages from www.qmailtoaster.com in a RedHat 9
server. The first virtual mail domain I setup works perfectly (which, is
the same as the original domain). The problem happens with the second
virtual domain I created, everytime I try to send a message using an
account from the second domain I get the following error:
Sorry, your envelope sender domain must exist.

I guess the problem is related to DNS, but the second domain is
configured OK (if I do 'nslookup mail.myseconddomain.com' I get the IP
address of the server, which BTW, is the same IP of the first domain)

Any help would be appreciated :)

Regards,
Toshiro.


-- 
Toshiro Viera [EMAIL PROTECTED]

--
Este mensaje (incluyendo documentos adjuntos) es confidencial. Si usted ha
recibido este e-mail por error, le agradecemos lo notifique inmediatamente
al remitente via email y elimine este mensaje (y documentos adjuntos) de su
sistema. No debera hacer uso del mismo, ni copiarlo o distribuirlo de forma
alguna.

Toda opinion expresada en este mensaje (y documentos adjuntos) es la de su 
autor, y no necesariamente refleja o compromete opiniones de la empresa.
--
DISCLAIMER


RE: [vchkpw] VLOG....aaarrrrrggggg!!!!

2004-04-13 Thread Bastiaan van der Put
Well people who use mysql, know from the first time what you were talking
about. The reaction of the unknown seems a bit offense
Don't think there is some otherway then just write a delete script,
and put it in cron or somthing similair.
Greetings,

Bas
At 19:36 4/13/2004, you wrote:
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] VLOGaaarg
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



[vchkpw] Lesebesttigung: [vchkpw] Re: a lost passwords files

2004-04-13 Thread Jan Metz
attachment: winmail.dat

[vchkpw] ignore this

2004-04-13 Thread Jeremy Kitchen
trying to get that tnef guy to mail to the list..

-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


Re: [vchkpw] VLOG....aaarrrrrggggg!!!!

2004-04-13 Thread Tom Collins
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.  That's a lot 
cleaner than deleting the database file out from under MySQL.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] vadddomain

2004-04-13 Thread Tom Collins
On Apr 13, 2004, at 7:56 AM, David Diaz wrote:
and the last thing check in your etc directory of vpopmail 
(home/vpopmail/etc) exists the file:
vpopmail.mysql with the correct permissions, something like that:

-rw-r--r--1 vpopmail vchkpw636 abr  6 00:53 vpopmail.mysql
Make sure your vpopmail.mysql file is NOT world readable.  If it is, 
anyone with access to your system can potentially read the 
username/password information and do bad things to your vpopmail 
database.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


[vchkpw] Announce List???

2004-04-13 Thread Cody Baker
Is there a inter7/vpopmail announcement list?  I'd to keep up on 
vpopmail and a few of the other inter7 projects but the volume of this 
list is a little to high for me.

Thank You,

Cody
[EMAIL PROTECTED]


Re: [vchkpw] VLOG....aaarrrrrggggg!!!!

2004-04-13 Thread Michael Bowe
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] 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 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] VLOGaaarg

 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





Re: [vchkpw] Announce List???

2004-04-13 Thread Tom Collins
On Apr 13, 2004, at 2:57 PM, Cody Baker wrote:
Is there a inter7/vpopmail announcement list?  I'd to keep up on  
vpopmail and a few of the other inter7 projects but the volume of this  
list is a little to high for me.
On SourceForge you can sign up for email notification of new releases.

This link will monitor the vpopmail-stable releases:

	http://sourceforge.net/project/filemodule_monitor.php? 
filemodule_id=89104

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] VLOG....aaarrrrrggggg!!!!

2004-04-13 Thread Tom Collins
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 PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] VLOG....aaarrrrrggggg!!!!

2004-04-13 Thread Charles Sprickman
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, 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 DATETIME type new in 5.4.x?

Thanks,

C

 --
 Tom Collins  -  [EMAIL PROTECTED]
 QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
 Info on the Sniffter hand-held Network Tester: http://sniffter.com/




Re: [vchkpw] VLOG....aaarrrrrggggg!!!!

2004-04-13 Thread Tom Collins
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 DATETIME type new in 5.4.x?
My mistake.  I was taking code from something else.

Perhaps this would work better:

DELETE FROM vlog WHERE timestamp  (UNIX_TIMESTAMP() - (7 * 24 * 60 * 
60))

Replace the 7 with the number of days of entries you want to keep.

This is totally untested, and based on documentation I just read at 
dev.mysql.com.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/