[Dovecot] password issue
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@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@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@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';
On Mon, 25 Aug 2008, gishaust wrote:
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@prt.com,127.0.0.1): Password query failed: Table 'postfix.password' doesn't exist
There's your hint.. :-)
Sounds like your sql statement for passwd lookup simply needs some adjustment.
for example, my table in MySQL looks like this: +------------------------+------------------------------------+---------------+-------------------------+-------+---------------+---------------------+---------------------+--------+ | username | password | name | maildir | quota | domain | created | modified | active | +------------------------+------------------------------------+---------------+-------------------------+-------+---------------+---------------------+---------------------+--------+
I use the statement: password_query = SELECT password FROM mailbox WHERE username = '%u'
to ensure the lookup is correct.
If you can do the following, I can write you the correct sql statement:
mysql -u root -p use postfix; show tables; <--- output of this required. select * from mailbox <-- ditto for this
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';
This is the section more than probably at fault - paste the above into a pastebin (pastebin.ca is good) and let us know the outputs.
Cheers,
-- Kind Regards, :: http://www.cjbuckley.net/ Chris Buckley :: http://photos.cjbuckley.net/
participants (2)
-
Chris Buckley
-
gishaust