Hi,
Sorry to hijack this thread, but I'm having exactly same issue. Here's
my conf file user sources part:
SOGoUserSources =
(
{
type = sql;
id = users;
viewURL =
"mysql://mailuser:password@localhost:3306/mailserver/sogo_users";
canAuthenticate = YES;
isAddressBook = NO;
userPasswordAlgorithm = ssha512;
}
);
I'm getting the same error TS has mentioned. Unfortunately, log file
doesn't seem to be particularly user friendly so we can only guess?
On 2022-09-30 21:44, Pierre wrote:
Hi,
Could have to do with encrytion used.
I got my setup working with the following (where "tablename" is
actually a view generated from the postfixadmin user table):
SOGoUserSources =
(
{
type = sql; id =
directory;
viewURL mysql://user:[email protected]:3306/dbname/tablename
[1]";
userPasswordAlgorithm = md5-crypt;
canAuthenticate = YES;
isAddressBook = YES; }
);
SOGoSMTPAuthenticationType = PLAIN;
On Fri, Sep 30, 2022, 12:21 PM "WilliamB" <[email protected]> wrote:
Hi I run an Ubuntu 20.04 with postfix/dovecot and postfix admin
I am trying to get SOGo working but it will not authenticate
might not have worked - password policy: 65535 grace: -1 expire:
-1 bound:
0
Any clues please
Links:
------
[1] http://user:[email protected]:3306/dbname/tablename
