It can end, I created the view and it’s working now. Thx for that.
There is no technical problem using two DBs, we both know that. It is just a choice not to work like that. If I’m not wrong, this ML is there for ppl looking for help & ppl who want to make some contribution, right ? If you think I don’t use it like I should, just tell me… But that’s not, in my mind, the good way to create a rich knowledge base and community. :/ I’m new in SOGo, and I really like using it and providing it to my customers. I’m just trying to improve their experience. Last thing, if SOGo’s Goal is to be completely closed in creating and giving some customizations, just tell it, people will know. De : users-requ...@sogo.nu <users-requ...@sogo.nu> De la part de Odhiambo Washington Envoyé : vendredi 2 avril 2021 22:43 À : users@sogo.nu Objet : Re: [SOGo] change password won't update mailserver database 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 <mailto: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 <mailto:users-requ...@sogo.nu> <users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > De la part de Patrik Chadima Envoyé : vendredi 2 avril 2021 16:51 À : SOGo reporter (flachape...@inverse.ca <mailto:flachape...@inverse.ca> ) <users@sogo.nu <mailto: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 <mailto: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 <mailto: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 <mailto:users@sogo.nu> https://inverse.ca/sogo/lists -- users@sogo.nu <mailto: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 <mailto:users@sogo.nu> https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
