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([EMAIL PROTECTED],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=<[EMAIL PROTECTED]>, 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 [EMAIL PROTECTED]
+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';
