Server dovecot: auth: Warning: sql: Ignoring changed iterate_quer

[Joseph Malloy]

Hello, 

I am having an issue with Dovecot. I am using Roundcube to access my mailboxes, 
which I have set up using ViMbAdmin. 

However when I go to the Roundcube, I get login Failed. 


So looking in the mail.log I can see the following: 

Aug 15 13:20:09 Server dovecot: auth: Warning: sql: Ignoring changed 
iterate_query in /etc/dovecot/dovecot-sql.conf.ext, because userdb sql not 
used. (If this is intentional, set userdb_warning_disable=yes)

Aug 15 13:20:11 Server dovecot: imap-login: Disconnected (auth failed, 1 
attempts in 2 secs): user=<j...@anoblequest.co.uk>, method=PLAIN, 
rip=62.49.15.89, lip=192.168.0.90, TLS, session=<su7WCqoALAA+MQ9Z>

I am most greatful for the support

Joe
:)
root@Server:/etc/postfix# dovecot --version
2.2.9

root@Server:/etc/postfix# grep -v '^ *\(#.*\)\?$' dovecot-sql.conf
grep: dovecot-sql.conf: No such file or directory


root@Server:/etc/postfix# dovecot -n
# 2.2.9: /etc/dovecot/dovecot.conf
# OS: Linux 3.13.0-27-generic i686 Ubuntu 14.04.1 LTS ext4
auth_mechanisms = plain login
disable_plaintext_auth = no
mail_location = maildir:/var/mail/vhosts/%d/%n
mail_privileged_group = mail
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope encoded-character 
vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy 
include variables body enotify environment mailbox date ihave
namespace inbox {
  location =
  mailbox Drafts {
    special_use = \Drafts
  }
  mailbox Junk {
    special_use = \Junk
  }
  mailbox Sent {
    special_use = \Sent
  }
  mailbox "Sent Messages" {
    special_use = \Sent
  }
  mailbox Trash {
    special_use = \Trash
  }
  prefix =
}
passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
plugin {
  sieve = ~/.dovecot.sieve
  sieve_dir = ~/sieve
}
protocols = imap lmtp
service auth-worker {
  user = vmail
}
service auth {
  unix_listener /var/spool/postfix/private/auth {
    group = postfix
    mode = 0666
    user = postfix
  }
  unix_listener auth-userdb {
    mode = 0600
    user = vmail
  }
  user = dovecot
}
service imap-login {
  inet_listener imap {
    port = 0
  }
}
service lmtp {
  unix_listener /var/spool/postfix/private/dovecot-lmtp {
    group = postfix
    mode = 0600
    user = postfix
  }
}
ssl = required
ssl_cert = </etc/ssl/certs/dovecot.pem
ssl_key = </etc/ssl/private/dovecot.pem
userdb {
  args = uid=vmail gid=vmail home=/var/mail/vhosts/%d/%n
  driver = static
}
userdb {
  args = uid=5000 gid=5000 home=/var/vmail/%d/%n allow_all_users=yes
  driver = static
}