[SOGo] SOGO reusing Dovecot db password issue

[Serveria Support]

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?