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';
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 at prt.com,127.0.0.1): Password query failed: Table 'postfix.password' > doesn't existThere'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/
On Mon, 25 Aug 2008, gishaust wrote:> dovecot-mysql.conf and then restarted dovecot. then telnet and came up with > the same issueRight - we're getting there then..! :)> the log says the following > > Aug 25 10:09:12 mta dovecot: Dovecot v1.0.10 starting up > Aug 25 10:09:13 mta dovecot: auth-worker(default): mysql: Connected to > 127.0.0.1 (postfix) > Aug 25 10:11:33 mta dovecot: auth-worker(default): > plain_md5_verify(sal at prt.com): Invalid password encodingEasily fixed. (You are using MD5 for your passphrases, right?) in dovecot-sql.conf default_pass_scheme = MD5 /etc/init.d/dovecot restart That should work. -- Kind Regards, :: http://www.cjbuckley.net/ Chris Buckley :: http://photos.cjbuckley.net/
On Mon, 25 Aug 2008, gishaust wrote:>> Easily fixed. (You are using MD5 for your passphrases, right?) >> >> in dovecot-sql.conf >> default_pass_scheme = MD5 >> >> /etc/init.d/dovecot restart >> >> That should work. >> > > It work great thankyou for your help. You find this on the ubuntu server > forum as I have posted the same issue and never got a response now i show it > solved thanks again this has been a week long issue.No problem. Please remember to keep dovecot-mailing-list on CC (reply-to-all) so others can benefit. NB: I would recommend looking at CentOS/Red Hat for a proper Enterprise Server OS. All the best, -- Kind Regards, :: http://www.cjbuckley.net/ Chris Buckley :: http://photos.cjbuckley.net/