[email protected] wrote at
Thu, 29 Apr 2004 08:07:51 -0700:
>Folks,
> I've just installed DBMail, and I'm doing some testing on
it. I am using
>PostgreSQL as the database. So far I am able to receive
email correctly
>from the MTA, and get it from the server using IMAP.
However when I delete
>a message, the deleted_flag gets set, but when I run
>dbmail-maintanance -cfpd it doesn't delete any messages,
and doesn't change
>the status of any messages to STATUS_DELETE.
>
> It looks like there are three related functions in
dbpgsql.c, db_expunge
>which marks the status of all messages with deleted_flag=1
to STATUS_DELETE,
>db_set_deleted which sets status=STATUS_PURGE where
status=STATUS_DELETE and
>db_deleted_purge which deletes from messages where
status=STATUS_PURGE.
>Looking in maintenance.c I see that it calls
db_deleted_purge and
>db_set_deleted, but not db_expunge. Should the status get
set somewhere
>else, or is this broken, or is there some third option I'm
not seeing? :)
>
> Any help would be appreciated.
>
>Thanks,
>Peter Darley
Check the man for dbmail-maintenance.
from ther you have:
"All messages that are set for
deletion will be marked for final deletion (status
3). All
message that are marked for final deletion will be
cleared
from the database."
There is column status in the messages table which can have
3 values 000 or 002 or 003 (if I'am not mistaken).
000 not deleted by the client (OE, NS)
002 deleted by the client - to be marked for deletion from
the database
003 to be permanently deleted from the database.
all this means you have to run dbmail-maintenance 2 times in
order to permanently delete a message from the database.
If any errors please correct!
Regards
Mario Ivano
------------------------ Werbung ------------------------
>> NEU: Ab sofort: AT-Domains superguenstig um EUR 12,00
http://www.emerion.com
---------------------------------------------------------
*** sent through http://www.everymail.net FREE e-mail
