Try adding the '-y' flag to dbmail-util. I'm running dbmail 2.0.4 and if I don't specify the '-y' flag it will tell me about what needs to be done, without actually doing the work. I don't know if this was fixed in your release, 2.0.7.
-Brian On 11/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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... > > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
