[Dovecot] Dovecot not delivering mail.

[Anthony Nedland]

Charles Marcus wrote:
> On 2010-01-05, Anthony Nedland (anthony.nedland at 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