Jump to content
Froxlor Forum
  • 0

Dovecot SQL Config Wrong



Just FYI on the gentoo ebuild version 0.9.16 the dovecot-sql.conf file is incorrect or at least isn't consistent with the postfix configuration...


The is that it only returns a home director resulting in trying to put mail in ~/Maildir and whereas the postfix config uses ~/ as the maildir.


Changed queries to:


password_query = "SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, CONCAT('maildir:', homedir, maildir) AS userdb_mail, uid AS userdb_uid, gid AS userdb_gid, CONCAT('*:storage=', quota,'M') AS userdb_quota_rule FROM mail_users WHERE (username = '%u' OR email = '%u') AND ((imap = 1 AND '%Ls' = 'imap') OR (pop3 = 1 AND '%Ls' = 'pop3') OR '%Ls' = 'smtp')"
user_query = "SELECT CONCAT(homedir, maildir) AS home, CONCAT('maildir:', homedir, maildir) AS mail, uid, gid, CONCAT('*:storage=', quota,'M') AS quota_rule FROM mail_users WHERE (username = '%u' OR email = '%u')"


I have not adjusted the e-build or the config template in froxlor yet... and maybe this isn't the case in the svn ebild...

Link to comment
Share on other sites

1 answer to this question

Recommended Posts


This topic is now archived and is closed to further replies.

  • Create New...