I set up a mail server and the users info is in the database. And here starts my question I wanna encrypt the paswords that are in the database I’m using MariaDB I’ve red this https://mariadb.com/kb/en/aes_encrypt/ so like I’ve a database users I do
INSERT INTO users (pass) VALUES (AES_ENCRYPT('text',SHA2('password',512)));
but what about that value 'text does it matter somewhat? I mean when user logs in and types password would it matter?
And another question I’ve binded myql with postfix this way
lloks like that
user=mail password=*mailPASSWORD* dbname=maildb table=users select_field=maildir where_field=id hosts=127.0.0.1 additional_conditions = and enabled = 1
but I want multiple users so there’d be different values for different users in table : users ->field : pass but in that file /mailbox.cf there’s only one .
I know I can use yast ->network services-> mail server but there’s only option for one user i.e. I’ve set up the server manually and the changes will over yast will overwrite the files like /etc/postfix/main.cf I’ve virtual users…