Postfix + Dovecot + MySQL: automatic box creation?

Question

linux

Hello! It was necessary to automatically create mailboxes with a request from the site. For plain text passwords (setting in Dovecot PLAIN), everything is simple, boxes are perfectly created by the request

INSERT INTO mailbox (username, password, name, maildir, local_part, domain, active) VALUES ('[email protected]', 'Qwerty123', 'test_name', 'xx.domain.ru/test_name', 'test_name', 'xx.domain.ru', 1);

There was a need to create boxes with encrypted passwords (setting in Dovecot MD5-CRYPT). How to implement it?

Answer 1

I can’t check now, but I would form a password in the database something like this:
ENCRYPT('mypassword', CONCAT('$1$', SUBSTRING(MD5(RAND()), -8), '$'));