A BUGNOTE has been added to this bug. ====================================================================== http://dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000106 ====================================================================== Reported By: seanxkelly Assigned To: ====================================================================== Project: DBMail Bug ID: 106 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: always Severity: minor Priority: normal Status: new ====================================================================== Date Submitted: 23-Oct-04 01:28 CEST Last Modified: 25-Oct-04 18:20 CEST ====================================================================== 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? 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 ======================================================================