> > On Tue, 2006-07-11 at 09:56 +0100, Jorge Bastos wrote: > > > >> It means that i just have to check for the owner_idnr before i delete the > >> record from dbmail_users, save it in a variable, delete the record from > >> dbmail_users and delete the values from the dbmail_aliases table with the > >> owner_idnr in the variable, and dbmail-util will take care of the rest! > >> > >> Did i missed something paul? > > > > > > Any users that have multiple aliases wouldn't be caught there, though > > you may not have any of those. Eg. if userid = "bob" and user_idnr = > > 123, you could have an alias entry for "[EMAIL PROTECTED]" with a > > deliver_to of "123" and another alias entry for "[EMAIL PROTECTED]" with a > > deliver_to of "[EMAIL PROTECTED]" (ie. forward bob's mail offsite in > > addition to saving it locally). Your proposal would catch the former, > > but not the latter. > > > > If you have userid's that are also the same as the email address, you > > can probably just delete all dbmail_aliases where the alias is the same > > as the userid. eg. if your username is "[EMAIL PROTECTED]" instead of just > > "bob" you could "delete from dbmail_aliases where alias = > > '[EMAIL PROTECTED]'. > >
Also, just to be complete, you probably would want to delete all dbmail_alias entries where deliver_to is the same as the userid, too. Ie. if one user forwarded mail to another, you could have: alias deliver_to ----- ---------- [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] 123 It sounds like that doesn't apply to your installation, but in case someone comes across this thread in the future, it might be useful... -- Jesse Norell - [EMAIL PROTECTED] Kentec Communications, Inc.
