PS: I am not so used to top-posting on MLs. My question is - what is the problem with using the same DB? SOGo uses it'd own tables, which you can drop at will. After all, it's the same DB server! You will not _easily_ achieve what you want with two separate databases. Note *easily*. And I can assure you there isn't already a solution in the public domain. If you create the VIEW as I shared before, your problem is solved and you are home and dry. In fact even this discussion would have ended :-)
On Fri, Apr 2, 2021 at 11: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. > > > > > > > > *De :* users-requ...@sogo.nu <users-requ...@sogo.nu> *De la part de* > Patrik Chadima > *Envoyé :* vendredi 2 avril 2021 16:51 > *À :* SOGo reporter (flachape...@inverse.ca) <users@sogo.nu> > *Objet :* Re: [SOGo] change password won't update mailserver database > > > > Hi, > > > > On Fri, Apr 2, 2021 at 4:37 AM DEPRÉ Gaëtan - NGServers . com < > users@sogo.nu> wrote: > > Hi ! > > > > When a user changes his password via SOGo, SOGo doesn’t update the > mailserver database to make the both passwords equal ,and the user can > login but no mailbox will be displayed because of incorrect login on the > mail server. > > > > Is there any way to implement a custom script while changing password on > SOGo, allowing to update another database ? > > > > Regards, > > > > Gaetan > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > > > > If my understanding is correct, You are using multiple (probably two) user > databases? Different for SOGo and different for IMAP server (probably > Dovecot/Courrier)? > > If I'm right I can say that it is a good practice to use only one user > identity source for both systems. > > But we don't have enough information about Your background so there is no > correct answer to Your question. > > > > Best regards > > Patrik Chadima > > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- > users@sogo.nu > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- users@sogo.nu https://inverse.ca/sogo/lists