[Dovecot] password issue

gishaust gishaust at gmail.com
Mon Aug 25 01:51:47 EEST 2008


hi everyone I am new to dovecot  and I am having  a little trouble

I am getting this error  in my mail.log I have google it and can't find 
a response,

Aug 25 08:14:24 mta dovecot: auth-worker(default): mysql: Connected to 
127.0.0.1 (postfix)
Aug 25 08:14:24 mta dovecot: auth-worker(default): 
sql(sal at prt.com,127.0.0.1): Password query failed: Table 
'postfix.password' doesn't exist
Aug 25 08:17:22 mta dovecot: pop3-login: Disconnected: Inactivity: 
user=<sal at prt.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured

The error comes when I telnet in

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Dovecot ready.
user sal at prt.com
+OK
pass ********
-ERR Temporary authentication failure.



This is the current setup.

dovecot -n,


# 1.0.10: /etc/dovecot/dovecot.conf
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: pop3 pop3s imap imaps
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
mail_location: maildir:/home/vmail/%d/%n/Maildir
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
pop3_uidl_format(default):
pop3_uidl_format(imap):
pop3_uidl_format(pop3): %08Xu%08Xv
namespace:
  type: private
  separator: .
  prefix: INBOX.
  inbox: yes
auth default:
  mechanisms: plain login
  passdb:
    driver: pam
  passdb:
    driver: sql
    args: /etc/dovecot/dovecot-sql.conf
  userdb:
    driver: passwd
  userdb:
    driver: static
    args: uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes
  socket:
    type: listen
    client:
      path: /var/spool/postfix/private/auth
      mode: 432
      user: postfix
      group: postfix
    master:
      path: /var/run/dovecot/auth-master
      mode: 384
      user: vmail


Mysql database for email,

host=127.0.0.1
dbname=postfix
user=postfix
password= *********
Table =mailbox
User is =  user
Column password = password


vim /etc/dovecot/dovecot-sql.conf has the following

connect = host=127.0.0.1 dbname=postfix user=postfix password=*******
default_pass_scheme = PLAIN-MD5
password_query = SELECT mailbox as user, password FROM password WHERE 
email='%u';








More information about the dovecot mailing list