[GH-ISSUE #496] Config dovecot demo VM -> file dovecot-sql.conf #480

New issue

Closed

opened 2026-02-27 11:11:58 +03:00 by kerem · 0 comments

kerem commented

2026-02-27 11:11:58 +03:00

Owner

Originally created by @jniltinho on GitHub (Dec 10, 2013).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/496

/etc/dovecot/dovecot-sql.conf

Change:
user_query = SELECT concat('/srv/vmail/', dom.name, '/', mb.path) AS home, uid, gid FROM admin_mailbox mb INNER JOIN auth_user user ON mb.user_id=user.id INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE mb.address='%n' AND dom.name='%d' AND user.is_active=1 AND dom.enabled=1

To:
user_query = SELECT concat('/srv/vmail/%d/%n') AS home, uid, gid FROM admin_mailbox mb INNER JOIN auth_user user ON mb.user_id=user.id INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE mb.address='%n' AND dom.name='%d' AND user.is_active=1 AND dom.enabled=1

Fast and simple.

Originally created by @jniltinho on GitHub (Dec 10, 2013). Original GitHub issue: https://github.com/modoboa/modoboa/issues/496 /etc/dovecot/dovecot-sql.conf Change: user_query = SELECT concat('/srv/vmail/', dom.name, '/', mb.path) AS home, uid, gid FROM admin_mailbox mb INNER JOIN auth_user user ON mb.user_id=user.id INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE mb.address='%n' AND dom.name='%d' AND user.is_active=1 AND dom.enabled=1 To: user_query = SELECT concat('/srv/vmail/%d/%n') AS home, uid, gid FROM admin_mailbox mb INNER JOIN auth_user user ON mb.user_id=user.id INNER JOIN admin_domain dom ON mb.domain_id=dom.id WHERE mb.address='%n' AND dom.name='%d' AND user.is_active=1 AND dom.enabled=1 Fast and simple.