Thx, patrik for those advices. I managed to make it working with the mysql VIEW.
Everything is ok now. & I can work with clean DBs ^^ Thx to everybody participating in sogo's development. Le Samedi, Avril 03, 2021 10:06 CEST, "Patrik Chadima" (hy3...@gmail.com) <users@sogo.nu> a écrit: Hi, On Fri, Apr 2, 2021 at 10:11 PM DEPRÉ Gaëtan - NGServers . com <users@sogo.nu> wrote: >> If my understanding is correct, You are using multiple (probably two) user >> databases? Different for SOGo and different for IMAP server (probably >> Dovecot/Courrier)? You’re right. I didn’t want to use my mailserver database, because of populating of SOGo (it creates 3 tables per user especially terminating with ‘_acl’ & ‘_quick’ & I wanted to keep my mailserver database clean). The two databases used are ‘mailserver’ & ‘sogo’. I realize with your answers that we have no other choice than using the same DB. Creating custom script that would be executed while doing an action could help 😊 Another idea would be to create a new directive, telling which is the mailserver users Db/password field and allowing SOGo to act in it while changing password, for example. You certainly can use a separate database for sogo tables and different one for users (the same one that IMAP Server uses). We are currently using the same setup. But you will have to create a view in the user database and in the SOGo settings use this view to the user database in SOGoUserSources attribute viewURL. And you will have a clean database of users and a separate database for sogo profiles etc. So You will end up with the same user source for IMAP and for SOGo. I understand why You want to have this setup. It is clean and easier to maintain, backup and restore. Best regards, Patrik -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
