Hi
Enable debugging for mysql in sogo.conf:
MySQL4DebugEnabled = YES;Also which password hashing are you using? See "userPasswordAlgorithm" in "Installation and Konfiguration Guide". Kind regards, Christian Mack Am 06.10.22 um 10:44 schrieb Serveria Support ([email protected]):
Hi,Thanks for responding. I did enable all possible logging in Dovecot and I can see Windows Mail clients logging in successfully. But for some reason my SOGo connection attempts are not showing up in logs at all. SOGo log still shows the same error message I already posted. SOGo website is giving me this error: Wrong username or password.On 2022-10-04 18:54, Odhiambo Washington wrote:On Thu, Sep 29, 2022 at 4:01 PM Serveria Support <[email protected]> wrote:Hi, After weeks of trying to configure iredmail package for my needs (and failing miserably) I decided to start everything from scratch: I took a vanilla Debian 11 server and installed Dovecot + Postfix + MariaDB + Apache. Mailserver works like a charm - emails are getting sent/delivered/stored perfectly. Users are able to log in/authenticate. Then I decided to add SOGo to the config and installed it, also configured using the basic howto from sogo website. All done, web frontend comes up. So far so good.... unfortunately I'm unable to authenticate using my Dovecot users db. Here I have to add that I didn't create a separate table for SOGo but instead tried to reuse my Dovecot user credentials by creating a VIEW in my DB. However, this doesn't seem to work, here's my sogo.log: Sep 29 06:30:17 sogod [151286]: XXXIPADDRESSXXX "POST /SOGo/connect HTTP/1.1" 403 34/89 0.003 - - 0 - 12 Sep 29 06:30:25 sogod [151286]: |SOGo| starting method 'POST' on uri '/SOGo/connect' 2022-09-29 06:30:25.510 sogod[151286:151286] <MySQL4Channel[0x0x557d1232c5c0] connection=0x0x557d12597cd0> SQL: SELECT c_password FROM sogo_users WHERE c_uid = '[email protected]'; 2022-09-29 06:30:25.510 sogod[151286:151286] <MySQL4Channel[0x0x557d1232c5c0] connection=0x0x557d12597cd0> query has results, entering fetch-mode. Sep 29 06:30:25 sogod [151286]: SOGoRootPage Login from 'XXXIPADDRESSXXX' for user '[email protected]' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 Sep 29 06:30:25 sogod [151286]: |SOGo| request took 0.001784 seconds to execute Unfortunately, I'm not too good at reading SOGo logs and the error message seems to be not very self-explanatory. What exactly does this mean? Unable to fetch password? Password didn't work? Wrong encryption protocol? Any suggestions?Look at the dovecot logging configuration and bump the debugging up and you'll get it right. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
-- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
