Displaying 1 result from an estimated 1 matches for "new_mail_fmt".
2013 Dec 26
1
Dovecot quota with MySQL - username issue
...th a mixture of email
addresses and usernames, which causes things to not fully work. It
*should* be just usernames. the LDA SQL statement is:
user_query = \
SELECT mailboxes.username, accounts.uid, accounts.uid AS gid, \
concat('/home/',mailboxes.username) AS home, \
(SELECT IF(accounts.new_mail_fmt=1, \
CONCAT('Maildir:',home,'/Maildir'), \
CONCAT('mbox:',home,'/Maildir:INBOX=/var/spool/mail/',mailboxes.username)))
AS mail_location \
FROM mailboxes JOIN accounts ON accounts.username=mailboxes.username \
WHERE (mailboxes.email='%u' || \
(mailboxes.email...