Hi Buddies,
dovecot-sql.conf
driver = mysql
connect = host=127.0.0.1 dbname=postfix user=postfix password=secret
default_pass_scheme = plain
password_query = SELECT username as user, password
FROM mailbox WHERE username = '%u' AND active = 1
user_query = SELECT concat("/var/vmail/", maildir) as home, 125 as uid, 125
as gid FROM mailbox WHERE username = '%u'
Version: 2.0.19: /etc/dovecot/dovecot.conf doveconf: Warning: NOTE: You can get a new clean config file with: doveconf -n > dovecot-new.conf doveconf: Warning: Obsolete setting in /etc/dovecot/conf.d/10-mail.conf:157: fsync_disable has been renamed to mail_fsync # OS: Linux 3.2.0-37-generic x86_64 Ubuntu 12.04.2 LTS auth_mechanisms = plain login auth_verbose = yes debug_log_path = /var/log/dovecot-debug.log disable_plaintext_auth = no dotlock_use_excl = no first_valid_gid = 125 first_valid_uid = 125 last_valid_gid = 125 last_valid_uid = 125 log_path = /var/log/dovecot.log mail_debug = yes mail_location = maildir:/%Lh/:INDEX=/%Lh/ mail_nfs_storage = yes mmap_disable = yes passdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } protocols = " imap pop3" service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } } service imap-login { inet_listener imap { port = 143 } inet_listener imaps { port = 993 ssl = yes } } service pop3-login { inet_listener pop3 { port = 110 } inet_listener pop3s { port = 995 ssl = yes } } ssl_cert = </etc/postfix/ssl/mail.hiway.com.br.crt ssl_key = </etc/postfix/ssl/mail.hiway.com.br.key userdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } verbose_proctitle = yes protocol imap { imap_idle_notify_interval = 2 mins mail_max_userip_connections = 150 } protocol pop3 { pop3_uidl_format = %08Xu%08Xv }
##EOF
I use mailbox in nfs share. When i set the option "mail_nfs_index = yes" the dovecot fails to start.
Looking at logs, only prompted this:
"Feb 6 11:07:25 picapau kernel: [ 1436.376023] init: dovecot main process (4177) terminated with status 89" without more info.