Hello, Another issue is performance - likely most account removals are done via human interaction during business hours. If users have large mail boxes, it would just slow the database down to go through and remove all their mail then. It works very well for us to just remove the users entry and have dbmail-maintenance do all the more disk intensive work in off-hours. I'd think make it optional for dbmail-adduser (which we don't use for that, but others do).
---- Original Message ---- From: Paul Stevens <[email protected]> To: [email protected] Subject: Re: [Dbmail] dbmail-adduser not cleaning up the tables Sent: Thu, 19 Jun 2003 21:19:52 +0200 > [EMAIL PROTECTED] wrote: > > The topic has been on air a cuple of days. For most of the work, you use > > dbmail-adduser d follow by a dbmail-maintenance -f. Only alias is there to > > clean up, and I have post a little script to do so a couple of days ago. > > The earlier thread was also started by Jacques, so I interpreted this > apparently repeated request as a wish-list type bugreport. > > To answer the question: yes dbmail-adduser could well be changed to > cleanup all data associated with an account, but there was no consensus > on whether such would be a good design decision. > > Like most of the other replies in the earlier thread I feel that this > can be well resolved either through database contraints or through > dbmail-maintenance. > > I for one can imagine well some situations where I would want to remove > an account, but still retain at least the messages and messageblks for > historical purposes. Perhaps you would want to assign such orphaned > messages to some bucket-type dummy user. Afaik many organisations are > required to maintain archives of email same as of paper documents for > several years. > > regards, > > > > > > Alejandro > > > > > >>Could dbmail-adduser be modified to clean up all the > >>tables (aliases,mailboxes,messages,messageblks) and aliases > >>"deliver_to" > >>when deleting a user. > >>I do it with a script but i think that should be done by dbmail-adduser > >>for > >>all of use. > >> > >>Why delete a user and leave all is data in the tables. > >> > >>Thanks > >>Jacques > >> > >>_______________________________________________ > >>Dbmail mailing list > >>[email protected] > >>https://mailman.fastxs.nl/mailman/listinfo/dbmail > >> > > > > > > _______________________________________________ > > Dbmail mailing list > > [email protected] > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > -- > ________________________________________________________________ > Paul Stevens mailto:[EMAIL PROTECTED] > NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] > The Netherlands________________________________http://www.nfg.nl > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- End Original Message -- -- Jesse Norell jesse (at) kci.net
