Files
postfixadmin/DOCUMENTS/examples/add-mail-format-field.sql
Rodrigo Cortés Cano e280deb97a Document Dovecot 2.4 configuration (#1075)
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
2026-07-13 08:49:50 +01:00

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;