On Thu, Sep 29, 2022 at 4:01 PM Serveria Support <users@sogo.nu> 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 = 'u...@mydomain.tld'; > 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 'u...@mydomain.xxx' 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 '^$|^.*#' ¯\_(ツ)_/¯ :-)
