Hi,
I'm using a docker container for SOGo (frederickzh/archlinux-sogo:latest) and
postgres:18.4 as database backend.
I want to use the authentification via SQL and use this part in my sogo.conf
SOGoUserSources =
(
{
type = sql;
id = directory;
viewURL = "postgresql://sogo:password@sogo-db:5432/sogo/sogo_users";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = md5;
} );
The password for database is calculate with "echo -n 'password' | md5sum".
This is the entry in my postgresql database table sogo_users:
c_uid c_name c_password c_cn mail
user user 5f4dcc3b5aa765d61d8327deb882cf99 user [email protected]
I get the this error after failed login:
sogo | Jun 13 20:43:18 sogod [97]: SOGoRootPage Login from '192.168.20.5' for
user 'user' might not have worked - p
assword policy: 65535 grace: -1 expire: -1 bound: 0
If I set "userPasswordAlgorithm = plain" it works after I update my sogo_users
table with "password".
What is the reason that only plain works? sha256 or sha512 also not working.
Thanks for help ... :-)
Bye, Damgis
