The following bug has been RESOLVED. ====================================================================== http://dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000106 ====================================================================== Reported By: seanxkelly Assigned To: aaron ====================================================================== Project: DBMail Bug ID: 106 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: minor Priority: normal Status: resolved Resolution: fixed ====================================================================== Date Submitted: 23-Oct-04 01:28 CEST Last Modified: 31-Oct-04 12:24 CET ====================================================================== Summary: dbmail-users -d leaves stale data in dbmail_aliases Description: When a user is deleted using "dbmail-users -d username" any aliases that user had in dbmail_aliases are left. Cleaning up the database using "dbmail-util -c -t -u -r -p -d" does not remove these stale aliases. ======================================================================
---------------------------------------------------------------------- aaron - 25-Oct-04 10:12 CEST ---------------------------------------------------------------------- So we should attack this from both angles. dbmail-util should have a mode to clean this up and dbmail-users should be clean in the first place. Any volunteers? ---------------------------------------------------------------------- seanxkelly - 25-Oct-04 18:20 CEST ---------------------------------------------------------------------- This is one of the reasons I suggested a cascading delete using foreign keys. That way dbmail-users doesn't have to clean up after itself because the database itself will maintain data integrity. Your comments? ---------------------------------------------------------------------- aaron - 31-Oct-04 12:24 CET ---------------------------------------------------------------------- Fixed in dbmail_2_0_branch and in HEAD. dbmail-users -d username deletes aliases for that user, too. Bug History Date Modified Username Field Change ====================================================================== 23-Oct-04 01:28seanxkelly New Bug 23-Oct-04 01:32seanxkelly Bug Monitored: seanxkelly 25-Oct-04 10:12aaron Bugnote Added: 0000320 25-Oct-04 18:20seanxkelly Bugnote Added: 0000322 31-Oct-04 12:24aaron Bugnote Added: 0000325 31-Oct-04 12:24aaron Assigned To => aaron 31-Oct-04 12:24aaron Resolution open => fixed 31-Oct-04 12:24aaron Status new => resolved ======================================================================
