Re: [SOGo] Orphaned database tables in mysql backend?

2016-10-27 Thread Peter Schmidt
Hi Ian, thanks for the answer. But that was exactly what I did to delete a user. The tables remain after a.) a user deletes his calendar/addressbook b.) a user gets deleted via sogo-tool remove Any other suggestions? Kind regards, Peter Am 2016-10-19 um 12:53 schrieb Ian McMichael (ian.mcmich

Re: [SOGo] Orphaned database tables in mysql backend?

2016-10-27 Thread Peter Schmidt
Hi again, Ian, thank you for reminding me about this issue. I found out, that the sogo db user had rights to create, delete, etc., but not to drop! Now tables are deleted in the database and I guess I will have to filter and drop those orphaned ones myself. Thank you! Kind regards, Peter

Re: [SOGo] Orphaned database tables in mysql backend?

2016-10-19 Thread Ian McMichael
On 19/10/16 11:12, Peter Schmidt (peter.schm...@bixa.cc) wrote: Is there really no one, that can tell me how to deal with tables that remain in the database after users or their folders (calendars, address books) have been deleted? Try running: sogo-tool remove I believe that should ti

Re: [SOGo] Orphaned database tables in mysql backend?

2016-10-19 Thread Peter Schmidt
Is there really no one, that can tell me how to deal with tables that remain in the database after users or their folders (calendars, address books) have been deleted? Kind regards, Peter Am 2016-10-06 um 17:33 schrieb Peter Schmidt (peter.schm...@bixa.cc): Hi there! I found that my sogo my

[SOGo] Orphaned database tables in mysql backend?

2016-10-06 Thread Peter Schmidt
Hi there! I found that my sogo mysql database has 179 tables. 5 of them are used for account data, namely: sogo_folder_info sogo_sessions_folder sogo_user_profile sogousers sogousersource (actually this a view) The remaining 174 tables contain user content and appear in a group of 3 tables name