Wait thre some ocnfusions, you don’t used ldap but a database for the user ?
What is your SOGoUserSources?
You should have something like this:
SOGoUserSources =
(
{
type = sql;
id = directory;
viewURL = "postgresql://sogo:sogo@127.0.0.1:5432/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = md5;
}
);
Quentin
From: users-requ...@sogo.nu <users-requ...@sogo.nu> On Behalf Of ????????
????????
Sent: mardi 12 décembre 2023 10:25
To: users@sogo.nu
Subject: Re: [SOGo] Authentication using ldap-md5 password fails
Sorry, but rollback is not possible.
I needed to move the mailer to another server. A backup was made on the old
server, on the new server I launched mailcow, then deployed the backup using
the backup_and_restore.sh script( (supplied with mailcow).
All containers started successfully, imap / smtp are working for all users.
Sogo also worked, but I tested it on a user with {BLF-CRYPT} password.
A couple of days later, a person contacted me who could not enter sogo. I
started looking into it and realized that only users with an md5 hash cannot
log in.
SOGO current version: 5.9.0
Old ver - i think Sogo 5.8.0, I can't look anymorе, old server is down.
вт, 12 дек. 2023 г. в 13:30, qhivert <users@sogo.nu <mailto:users@sogo.nu> >:
Hello, you’ve updated from what sogo version to what? If you rollback your
mailcow does it work again?
Quentin
From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu>
<users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > On Behalf Of ????????
????????
Sent: mardi 12 décembre 2023 07:22
To: users@sogo.nu <mailto:users@sogo.nu>
Subject: [SOGo] Authentication using ldap-md5 password fails
Good afternoon
I use a mailcow: dockerized mail server with an integrated container SOGO.
After the update, sogo stopped allowing users whose password hash was generated
using the {MD5} algorithm. Users whose password is generated by {BLF-CRYPT} are
authenticated normally. I turned on the logs, in the logs I can see access to
the database and retrieval of the password hash, but the password is not
accepted.
Dec 12 10:26:01 260deb884b40 2023-12-12 10:26:01.627 sogod[69:69]
<MySQL4Channel[0x0x5562e2feb2e0] connection=0x0x5562e2b3b230> SQL: SELECT
c_password FROM _sogo_static_view WHERE c_uid = 'pp_pet...@xx.xx';
Dec 12 10:26:01 260deb884b40 2023-12-12 10:26:01.627 sogod[69:69]
<MySQL4Channel[0x0x5562e2feb2e0] connection=0x0x5562e2b3b230> query has
results, entering fetch-mode.
...
SOGoRootPage Login from 'MY.IP.AD.DR' for user 'pp_pet...@xx.xx' might not
have worked - password policy: 65535 grace: -1 expire: -1 bound: 0
"c_password" field on _sogo_static_view contains hash like:
{MD5}ZVN1hovmmV34NCxjRKIDVw==
Base64 encoded MD5 hash
userPasswordAlg setting:
<key>userPasswordAlgoritm</key>
<string>ldap-md5</string>
i also try md5
What could be the problem? Plz help me fix it
