Hi odhiambo,
SOGoUserSources = (
{
type = sql;
canAuthenticate = YES;
displayName = "Staff Members";
id = users;
isAddressBook = YES;
userPasswordAlgorithm = MD5;
//userPasswordAlgorithm = none;
viewURL ="mysql://exim4u:[email protected]:3306/exim4u/sogo_auth_view";
}
);
XXXWWW is plain text and 'userPasswordAlgorithm = MD5;' in the configuration
file. Your original SQL INSERT user should look something like this:
INSERT INTO sogo_users VALUES (...., MD5('password'), ....);
The 'MD5' on the password is what does the encryption.
Pay attention to the size of the database 'password' field - MD5 always
encrypts to VARCHAR(32).
--
[email protected]
https://inverse.ca/sogo/lists
