Jochen, I need a level5 trace
Jochen Entenmann wrote: > 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 >> > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
