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'
juan carlos <jcflores <at> cablenet.com.pe> writes:> > 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: Unknowncolumn> '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 at 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. -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 197 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20091118/bb8bff5d/attachment-0002.bin>