Oops! I just remembered. SOGo needs to use the same database as your POP3/IMAP4 engine. I have been using Dovecot for that purpose.
If you are using MySQL you need to create a VIEW for SOGo to use. Here is what I did in my DB (and it is documented somewhere online): CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid, username AS c_name, crypt AS c_password, realname AS c_cn, username AS mail, realname AS displayName FROM users WHERE enabled='1'; (of course customize this according to your DB schema) Then in your authenticators set: viewURL ="mysql://DBUSER:[email protected]:3306/DBNAME/*sogo_auth_view*"; HTH On Fri, Apr 2, 2021 at 5:31 PM DEPRÉ Gaëtan - NGServers . com <[email protected]> wrote: > Hi ! > > > > My algorithms are well configured. I can login if I copy/paste hashed > password from the mailserver database to SOGo’s one. > > > > Sogo updates his database while changing password, but not mailserver’s > (dovecot/postfix) one. I would like to know where to implement such an > update script or add mysql UPDATE in the changing password action. > > > > Furthermore, if a user updates his password in SOGo, he can login again to > SOGo, but the mailserver will answer ‘bad login’ because of his password > not updated. > > > > *De :* [email protected] <[email protected]> *De la part de* > Odhiambo Washington > *Envoyé :* vendredi 2 avril 2021 12:25 > *À :* [email protected] > *Objet :* Re: [SOGo] change password won't update mailserver database > > > > > > > > On Fri, Apr 2, 2021 at 5:37 AM DEPRÉ Gaëtan - NGServers . com < > [email protected]> 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 ? > > > > I have SOGo update a MySQL database when users change passwords. > > I believe you should look at whether your setting > for userPasswordAlgorithm matches what is expected by your POP3/IMAP4 > engine. > > > > > -- > > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) > > -- > [email protected] > https://inverse.ca/sogo/lists > -- > [email protected] > https://inverse.ca/sogo/lists > -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -- [email protected] https://inverse.ca/sogo/lists
