Hi Paul, i have still the timeouts after 15 Minutes (900 Seconds) with the new Release. If i do a restart of dbmail it works for 15 Minutes, then the Clients cannot be authenticated.
Jochen > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Paul J Stevens > Gesendet: Dienstag, 11. Juli 2006 09:37 > An: DBMail mailinglist > Betreff: Re: [Dbmail] Delete accounts > > > > > Niblett, David A wrote: > > Sorry, I didn't remember, that I did create a foreign key > constraint > > on a new column in dbmail_aliases connecting it back to user_idnr. > > > > By adding that column, I was able to retain complete functionality. > > Now I admit that my internal requirement is that you can't have an > > dbmail_alias entry if you don't have a dbmail_users entry. I made a > > placeholder user and tie all my standalone aliases to it. > I suppose I > > could have used user_idnr #1 (the internal user), but that doesn't > > seem like a good idea. > > > > As for the messages, I think that is also removed (this is v2.0.10). > > > > CREATE TABLE dbmail_messages ( > > ... > > mailbox_idnr INT8 REFERENCES dbmail_mailboxes(mailbox_idnr) > > ON DELETE CASCADE, > > physmessage_id INT8 REFERENCES dbmail_physmessage(id) > > ON DELETE CASCADE, > > ... > > David, > > You're reading this the wrong way. The statement above says > that if you delete a physmessage all associated messages are > deleted. Deleting messages does *not* affect related physmessages. > > > > > > > Since the dbmail_messages keys to the dbmail_mailboxes, and to > > dbmail_physmessages (same with dbmail_messageblks), I > believe that it > > will cascade all the way down. > > No it doesn't. And that's a known bug (#305). > > > > > When I delete a user, I never see any orphaned blocks when I run > > dbmail-util. > > Because it turns out dbmail-util does not check for them > properly; contrary to my earlier statement. > > -- > ________________________________________________________________ > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > Dbmail mailing list > [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail >
