Hello,
here's an update: it all works with version 0.99... But this version doesn't support shared folders and all my boss wants is shared folders and mysql.
Anyone got an idea why the mysql connection fails?
thanks, Michael
Michael Gabb schrieb:
Hello,
I'm trying to setup a mailserver running postfix and dovecot with mysql as database backend. Postfix is already running and delivers mails just fine. Unfortunately, dovecot has great problems connecting to the database (using username + password). If I disable the password, everthing works fine. But, thats harakiri, security wise ;-)
I tried dovecot-1.0-stable and the latest cvs-nightly (I think from August 9.). With both versions, I get the following error (there are little differences between the to versions, but the meaning ist the same...)
dovecot: auth-worker(default): mysql: Connect failed to localhost (my_dbname): Access denied for user 'my_user'@'localhost' (using password: YES) - waiting for 1 seconds before retry
My connect string is as follows: connect = host=/var/lib/mysql/mysql.sock user=my_user password=my_password dbname=my_dbname
Both versions are compiled with the following settings: ./configure --prefix=/usr --localstatedir=/var --libexecdir=/usr/lib --sysconfdir=/etc/dovecot --enable-ipv6 --with-rawlog --with-ssl=openssl --with-pop3d --with-mysql
"make" runs cleanly. Then I use "checkinstall" intead of "make install" because I want to generate an rpm package, but that shouldn't make any difference.
Im using the following packages from suse (since im building the server upon a SuSE 9.3): mysql-4.1.10a-3.2, mysql-devel-4.1.10a-3, mysql-client-4.1.10a-3 and mysql-shared-4.1.10a-3
I don't have any clue, why the connect fails. The password and the username are both correct (triple verified ;-)) and the user has SELECT- and USE- Permission for my_dbname.
Is there any known bug i didn't know about? Or is this a typical PEBKAC situation?
Thanks in advance, Michael
-- www.megamimi.de.vu