[Dovecot] Unknown column mail_plugins in field list
I have installed debian lenny, postfix 2.5.5 and dovecot 1.0.15 and can't send emails locally. this is the error in the log Error: auth-worker(default): sql(xxx@yyy.com): User query failed: Unknown column 'mail_plugins' in 'field list'
juan carlos
I have installed debian lenny, postfix 2.5.5 and dovecot 1.0.15 and can't send emails locally. this is the error in the log Error: auth-worker(default): sql(xxx <at> yyy.com): User query failed: Unknown
column
'mail_plugins' in 'field list'
this is the configuration
smtp:~# dovecot -n
# 1.0.15: /etc/dovecot/dovecot.conf base_dir: /var/run/dovecot/ log_path: /var/log/mail.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap pop3 disable_plaintext_auth: no 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 login_processes_count: 5 login_max_processes_count: 256 login_max_connections: 512 max_mail_processes: 512 first_valid_uid: 5000 last_valid_uid: 5000 first_valid_gid: 5000 mail_access_groups: vmail mail_privileged_group: vmail mail_location: maildir:/home/vmail/%d/%n maildir_copy_with_hardlinks: yes maildir_copy_preserve_filename: yes mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_plugins(default): quota imap_quota trash mail_plugins(imap): quota imap_quota trash mail_plugins(pop3): quota 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 imap_client_workarounds(default): outlook-idle delay-newmail imap_client_workarounds(imap): outlook-idle delay-newmail imap_client_workarounds(pop3): outlook-idle pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xu%08Xv pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh namespace: type: private separator: . prefix: INBOX. inbox: yes auth default: mechanisms: plain login user: vmail passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: vmail master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: vmail plugin: quota: maildir:storage=51200:messages=1000:ignore=Trash:ignore=Sent trash: /etc/dovecot/dovecot-trash.conf
On Wed, 2009-11-18 at 20:31 +0000, juan carlos wrote:
I have installed debian lenny, postfix 2.5.5 and dovecot 1.0.15 and can't send emails locally. this is the error in the log Error: auth-worker(default): sql(xxx@yyy.com): User query failed: Unknown column 'mail_plugins' in 'field list'
The SELECT query in your dovecot-sql.conf tries to select "mail_plugins" field from your SQL database, but such column doesn't exist in the database.
participants (2)
-
juan carlos
-
Timo Sirainen