Hello Daniel,

DB> there are now thousands of messages still in the database, but all
DB> mail accounts are checked regularly... it seems like messages
DB> arent being deleted from the mailboxes?

The default setup does NOT install a cron job to regularly run
dbmail-maint... You need to periodically run two passes, one which
deletes all messages with a status of '003', and one which elevates
all messages with status of '002' (deleted by the user) to '003'
(ready to be deleted by the system).

On our main servers, this is run daily as a task in /etc/cron.daily.
We have one customer who wants to be able to go back further to
retrieve a possibly-errant message, so it is run monthly on their
server (lower volume of mail), so you can always go back 28 or more
days to undelete something.

My script simply runs these two commands:

/usr/local/sbin/dbmail-maintenance -p
/usr/local/sbin/dbmail-maintenance -d

And I get back a daily report that looks like:

*** dbmail-maintenance ***
Opening connection to the database... Ok. Connected
Deleting messages with DELETE status... Ok. [642] messages deleted.
Maintenance done.

*** dbmail-maintenance ***
Opening connection to the database... Ok. Connected
Setting DELETE status for deleted messages... Ok. [709] messages set for 
deletion.
Maintenance done.


-- 
Jeff Brenton
President,
Engineered Software Products, Inc
http://espi.com
Questionable web page: http://dididahdahdidit.com

Liberalism grants you the freedom to advocate any idea*.
 * Please see http://www.dididahdahdidit.com/except.php for a
   current list of exceptions

Reply via email to