dbmail 2.0.7
MySQL 4.1.14 INNODB

I've just created new `dbmail` database from
`create_tables_innoDB.mysql` file

And did the following steps:
1) Adding new user
> dbmail-users -a test -w testpwd

Opening connection to database...
Opening connection to authentication...
Ok. Connected
Adding user test with password type ,0 bytes mailbox limit and clientid 0... 
Ok, user added id [3]
Adding INBOX for new user
Ok. added
Done

This created user_idnr=3 and mailbox mailbox_idnr=1

2) Sending test message

> dbmail-smtp -u test < 1msg

This created messageblk_idnr=1 and 2


3) Deleting user

> dbmail-users -d test
Opening connection to database...
Opening connection to authentication...
Ok. Connected
Deleting aliases for user [test]...
Done
Deleting user [test]...
Done

messageblk_idnr=1 and 2 stays on it's place !

4) Runnig dbmail-util to destroy messages of deleted user

> dbmail-util -tubpdr
Opening connection to database... 
Opening connection to authentication... 
Ok. Connected.

Repairing DBMAIL messageblocks integrity...
Ok. Found [0] unconnected messageblks.

Checking DBMAIL message integrity...
Ok. Found [0] unconnected messages.

Checking DBMAIL mailbox integrity...
Ok. Found [0] unconnected mailboxes.

Repairing DBMAIL for NULL messages...
Ok. Found [0] NULL messages.

Checking DBMAIL for NULL physmessages...
Ok. Found [0] physmessages without messageblocks.

Repairing DBMAIL for incorrect is_header flags...
Ok. Found [0] incorrect is_header flags.

Deleting messages with PURGE status...
Ok. [0] messages deleted.

Setting DELETE status for deleted messages...
Ok. [0] messages set for deletion.
Re-calculating used quota for all users...
Ok. Used quota updated for all users.

Maintenance done. No errors found.


messageblk_idnr=1 and 2 stays on it's place AGAIN!!!

What is wrong? As I understand messages of deleted user must be
deleted by dbmail-util...


Reply via email to