mirror of
https://github.com/postfixadmin/postfixadmin.git
synced 2026-11-20 23:43:26 +03:00
Add Dovecot 2.4-oriented documentation for PostfixAdmin installations. The new document covers: - baseline Dovecot 2.4 SQL passdb/userdb configuration - temporary weak password scheme compatibility for old MD5/MD5-CRYPT hashes - optional post-login password migration to ARGON2ID - optional per-user Maildir to mdbox migration using a local mail_format field - quota warning delivery to the user's INBOX - optional IMAPSieve/Rspamd spam and ham learning hooks - security notes for userdb_plain_pass and verbose password logging It also adds sanitized example files under DOCUMENTS/examples and references the new Dovecot 2.4 document from the existing DOVECOT and HASHING docs. Thanks @TrapoSAMA
12 lines
463 B
SQL
12 lines
463 B
SQL
-- Optional local extension for gradual per-user Maildir to mdbox migration.
|
|
--
|
|
-- This is not required for standard PostfixAdmin installations.
|
|
-- Use it only if your Dovecot 2.4 userdb query returns mail_driver/mail_path
|
|
-- from SQL and you want to migrate users gradually.
|
|
|
|
ALTER TABLE mailbox
|
|
ADD COLUMN mail_format VARCHAR(16) NOT NULL DEFAULT 'maildir';
|
|
|
|
-- Optional visibility check:
|
|
SELECT username, mail_format FROM mailbox ORDER BY username LIMIT 20;
|