[Dovecot] Problem with mysql authentication
Hi,
I'm trying to set up dovecot-stable (http://www.dovecot.org/nightly/stable/dovecot-stable-20051124.tar.gz)
All seems to be prepared correctly, but... my dovecot can not access the mysql database :(
Connection string goes like this (i tried changing the order of parameters, that's why password is the first in the line):
connect = password=***** host=/var/lib/mysql/system/mysql.sock dbname=vmail user=vmail
But - in dovecot log I see:
dovecot: Nov 24 23:53:05 Error: auth(default): mysql: Connect failed to vmail: Access denied for user 'vmail'@'localhost' (using password: TAK)
Same in mysql log:
051124 23:53:05 171 Connect Access denied for user 'vmail'@'localhost' (using password: TAK)
All settings in connection string are 100% correct - I have pasted them from dovecot-sql.conf to command-line mysql client and it worked, I have logged in.
My copy of dovecot has been compiled recently, so all libraries are correct. Mysql version is 5.0.15 - but I doubt it is the reason...
Can anyone help? Thanks in advance!
Greetz,
Jacek Osiecki joshua@ceti.pl GG:3828944 Poland
Jacek Osiecki wrote:
Mysql version is 5.0.15 - but I doubt it is the reason...
It is. This came up a few times recently. Please read the list archives, e.g. http://dovecot.org/list/dovecot/2005-November/009980.html
Should probably go into the Wiki...
On Fri, 25 Nov 2005, Jakob Hirsch wrote:
Jacek Osiecki wrote:
Mysql version is 5.0.15 - but I doubt it is the reason... It is. This came up a few times recently. Please read the list archives, e.g. http://dovecot.org/list/dovecot/2005-November/009980.html Should probably go into the Wiki...
I think this is something different... My dovecot is running, and it has been build with mysql-5.0.15 libs. It tries to access the database, only it has some troubles with passing the correct password...
Maybe there is something wrong with mysql 5.0 support in dovecot?
Greetz,
Jacek Osiecki joshua@ceti.pl GG:3828944 "Poglądy polityczne mają takie znaczenie w sejmie jak upierzenie u krokodyla" (c) Tomasz Olbratowski 2004
Jacek Osiecki wrote:
My dovecot is running, and it has been build with mysql-5.0.15 libs. It tries to access the database, only it has some troubles with passing the correct password...
It is a problem with new MySQL PASSWORD() function from MySQL 4.1 onwards:
http://www.dovecot.org/list/dovecot/2005-November/010000.html
-- Tomi Hakala
Jacek Osiecki wrote:
I think this is something different... My dovecot is running, and it has been build with mysql-5.0.15 libs. It
Did you check if dovecot is really using the new libs?
tries to access the database, only it has some troubles with passing the correct password...
Once again: Please read the list archive.
I didn't say this thread is the solution to your problem. Maybe this is (maybe not): http://dovecot.org/list/dovecot/2005-November/010000.html
Maybe there is something wrong with mysql 5.0 support in dovecot?
dovecot has no explicit "mysql5 support", AFAIK.
On Fri, 25 Nov 2005, Jakob Hirsch wrote:
Jacek Osiecki wrote:
I think this is something different... My dovecot is running, and it has been build with mysql-5.0.15 libs. It Did you check if dovecot is really using the new libs?
There are no other mysql-libs on my server :)
tries to access the database, only it has some troubles with passing the correct password...
Once again: Please read the list archive.
I didn't say this thread is the solution to your problem. Maybe this is (maybe not): http://dovecot.org/list/dovecot/2005-November/010000.html
Yup, that's it :)
Maybe there is something wrong with mysql 5.0 support in dovecot? dovecot has no explicit "mysql5 support", AFAIK.
That explains everything :)
Greetz,
Jacek Osiecki joshua@ceti.pl GG:3828944 "Poglądy polityczne mają takie znaczenie w sejmie jak upierzenie u krokodyla" (c) Tomasz Olbratowski 2004
participants (3)
-
Jacek Osiecki
-
Jakob Hirsch
-
Tomi Hakala