Hmm... this solution isn't really statisfing. Making a dirty delete and hope that the command-line tool will clean it up...

Reindl Harald-2 wrote: > > > > Am 23.06.2012 12:29, schrieb cl445: >> >> What is the best way to delete an user from dbmail in SQL? Is there a >> cascading delete for dbmail_users? > > after remove it from "dbmail_users" all messages are orhpaned > and cleaned by dbmail-util - i am not sure if you have to > remove the records from "dbmail_aliases" manually, my backend does > > > > _______________________________________________ > DBmail mailing list > DBmail [at] dbmail > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail> >

Hmm... this solution isn't really statisfing. Making a dirty delete and hope that the command-line tool will clean it up...

Reindl Harald-2 wrote: > > > > Am 23.06.2012 12:29, schrieb cl445: >> >> What is the best way to delete an user from dbmail in SQL? Is there a >> cascading delete for dbmail_users? > > after remove it from "dbmail_users" all messages are orhpaned > and cleaned by dbmail-util - i am not sure if you have to > remove the records from "dbmail_aliases" manually, my backend does > > > > _______________________________________________ > DBmail mailing list > DBmail [at] dbmail > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail> >

why in the world do you think that this is a matter of hope? dbmail will NEVER remove all records even if you remove a message via POP3/IMAP - it will always only delete references and the rest is the job of dbmail-util

* delete 20000 messages * you will not notice load * call "dbmail-util -c -t -u -b -p -d -y" * call it 3 times * on the last 2 times you will note HEAVY IO-LOad

and that is why dbmail-util is called via crond on each proper setup in the night to not raise up system-load at business time for remove unused data

Am 23.06.2012 15:37, schrieb cl445: > > Hmm... this solution isn't really statisfing. Making a dirty delete and hope > that the command-line tool will clean it up... > > > Reindl Harald-2 wrote: >> >> >> >> Am 23.06.2012 12:29, schrieb cl445: >>> >>> What is the best way to delete an user from dbmail in SQL? Is there a >>> cascading delete for dbmail_users? >> >> after remove it from "dbmail_users" all messages are orhpaned >> and cleaned by dbmail-util - i am not sure if you have to >> remove the records from "dbmail_aliases" manually, my backend does >> >> >> >> _______________________________________________ >> DBmail mailing list >> DBmail [at] dbmail >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail>> >> >