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([EMAIL PROTECTED],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/
