Hello, this is my first post here, so hi to all!
I've just configured a new Suse Linux 10.1 distribution that comes with:
- postfix 2.2.9 + mysql tables
- dovecot 1.0.beta3
- mysql 5.0.18
- kernel 2.6.16.13-4-bigsmp i386 on a Intel Xeon 2.0Ghz with 3Gb RAM
I've also added postfixadmin 2.1.0 to build an IMAP server with virtual
users/virtual hosts management, and ran the script DATABASE_MYSQL.TXT to
build correctly database/tables and user/permissions.
The problem is that dovecot fail to access to mysql tables with the
following error:
==================dovecot: Jun 12 18:40:28 Info: Dovecot v1.0.beta3 starting up
dovecot: Jun 12 18:40:29 Error: auth-worker(default): mysql: Connect failed
to 127.0.0.1 (postfix): Access denied for user
'postfix'@'localhost' (using
password: YES) - waiting for 1 seconds before retry
==================
I've tried to connect to mysql using the socket instead of the local ip
address, but i've got the same error:
==================dovecot: Jun 12 18:55:19 Info: Dovecot v1.0.beta3 starting up
dovecot: Jun 12 18:55:20 Error: auth-worker(default): mysql: Connect failed
to (null) (postfix): Access denied for user
'postfix'@'localhost' (using
password: YES) - waiting for 1 seconds before retry
==================
In mysql the user "postfix" is correctly created with access granted
from
either localhost and 127.0.0.1
If i do the same from the command line it works perfectly:
==================server01:/ # mysql -h localhost -u postfix -p
Enter password: secret
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 136 to server version: 5.0.18
Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.
mysql>
==================
Here is my dovecot.conf:
==================default_mail_env = maildir:/home/mbox/%d/%n
protocols = imap pop3
auth default {
mechanisms = plain
userdb sql {
args = /etc/dovecot/dovecot-sql.conf
}
passdb sql {
args = /etc/dovecot/dovecot-sql.conf
}
}
first_valid_uid = 51
ssl_disable = yes
listen = *
log_path = /var/log/dovecot.log
info_log_path = /var/log/dovecot.log
==================
And my dovecot-sql.conf:
==================driver = mysql
connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix
password=secret
default_pass_scheme = PLAIN
password_query = SELECT password FROM mailbox WHERE username = '%u' AND
active = '1'
user_query = SELECT maildir AS mail, 51 AS uid, 51 AS gid FROM mailbox WHERE
username = '%u' AND active = '1'
==================
I'v tried also all the password mechanisms (PLAIN, PLAIN-MD5, MD5, CRYPT)
with no success.
My google searches ended with no results. Btw, the same configuration on a
Suse 9.3 professional works perfectly :(
Please anyone can help me?
Thanks in advance for all the kindly support
Saluti
G.Bartolini
Linux User #333064