Hi Bart,
On 31.01.24 18:07, Bits 'n Tricks (i...@bitsandtricks.com) wrote:
it came from /var/log/sogo/sogo.log:
ERROR: Table 'sogo.sogo_users' doesn't exist
[...]
Anyway, I have only one occurrence in the sogo.conf file and it is this:
viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/sogo_users";
IMHO the main question is: according to which documentation did you
create/edit your sogo.conf?
Please have a look at:
https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#Authentication-using-SQL
At the end of this section you'll find an example of a 'SOGoUserSources'
config and there (among others) the 'viewURL' parameter. Couldn't you try
to use this example from the official documentation?
On a former system I used:
SOGoUserSources =
(
{
type = sql;
id = users;
viewURL = "mysql://sogo:xxxxxxx@127.0.0.1:3306/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = SHA512-CRYPT;
prependPasswordScheme = YES;
displayName = "SOGo Benutzer";
}
);
and it worked without any problem.
Maybe it's worth a try.
HTH and regards,
Markus
