Charles Marcus wrote:
On 2010-01-05, Anthony Nedland (anthony.nedl...@baldwin-telecom.net) wrote:
In my dovecot-postfix.conf mail_location = maildir:/var/vmail/%d/
Please post full dovecot -n output...
Also, whats your SQL query look like?
dovecot -n
# 1.1.11: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.31-16-generic i686 Ubuntu 9.10 ext4
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: imap imaps pop3 pop3s
login_dir: /var/run/dovecot/login
login_executable(default): /usr/lib/dovecot/imap-login
login_executable(imap): /usr/lib/dovecot/imap-login
login_executable(pop3): /usr/lib/dovecot/pop3-login
first_valid_uid: 150
last_valid_uid: 150
mail_privileged_group: mail
mail_location: maildir:/var/vmail/%d/%n
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(pop3): /usr/lib/dovecot/pop3
mail_plugin_dir(default): /usr/lib/dovecot/modules/imap
mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3
auth default:
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
socket:
type: listen
master:
path: /var/run/dovecot/auth-master
mode: 432
user: vmail
group: mail
SQL statements in dovecot-sql.conf
user_query = SELECT '/var/vmail/%d/%n' as home,
'maildir:/var/vmail/%d/%n' as mail, 150 AS uid, 8 AS gid,
concat('dirsize:storage=',quota) AS quota FROM mailbox WHERE username =
'%u' AND active = 1
password_query = SELECT username as user, password, '/var/vmail/%d/%n'
as userdb_home,'maildir:/var/vmail/%d/%n' as userdb_mail, 150 as
userdb_uid, 8 as userdb_gid FROM mailbox WHERE username = '%u' AND
active = 1
