Re: [Dovecot] Mysql access denied
On Thu, 23 Jun 2011 15:48:58 +0200, Johan Hendriks <joh.hendriks@gmail.com> wrote:
Op 23-6-2011 15:37, list@airstreamcomm.net [1] schreef:
Currently using dovecot 2.0.12 and mysql server 4.0.20 (I know, it's really old) and having issues getting Dovecot to authenticate to the mysql server. We have confirmed that the credentials are correct and the host machine can access the database, however we are getting the following error:Jun 23 08:12:50 hostname dovecot: auth: Error: mysql(databaseserver.com): Connect failed to database (database): Access denied for user: 'sqladmin@ip.of.host.machine [2]' (Using password: YES) - waiting for 1 seconds before retry
We are assuming this has something to do with the password hashing algorithm in older versions of mysql, but we are hoping to confirm this theory and find a solution.
Thanks.
This has as far as i can see nothing to do with hashes. It is the mysql database that disallows the user sqladmin access to the database. Make sure the user sqladmin has the proper rights to access the database, from the ipadres.
Gr Johan Hendriks
Links:
[1] mailto:list@airstreamcomm.net [2] mailto:sqladmin@ip.of.host.machine
When talking about hashes I was referring to this wiki article: http://wiki1.dovecot.org/MysqlProblems. As I stated in my email we have confirmed that the host can access the database just fine, and the credentials are correct in the config for Dovecot.
Thanks.
On 23/06/11 16:11, list@airstreamcomm.net wrote:
We are assuming this has something to do with the password hashing algorithm in older versions of mysql, but we are hoping to confirm this theory and find a solution.
When talking about hashes I was referring to this wiki article: http://wiki1.dovecot.org/MysqlProblems. As I stated in my email we have confirmed that the host can access the database just fine, and the credentials are correct in the config for Dovecot.
On the wiki page are 2 possible workarounds listed, did you try any of them?
-- Regards, Tom
list@airstreamcomm.net schreef:
On Thu, 23 Jun 2011 15:48:58 +0200, Johan Hendriks <joh.hendriks@gmail.com> wrote:
Op 23-6-2011 15:37, list@airstreamcomm.net [1] schreef: Currently using dovecot 2.0.12 and mysql server 4.0.20 (I know, it's really old) and having issues getting Dovecot to authenticate to the mysql server. We have confirmed that the credentials are correct and the host machine can access the database, however we are getting the following error:
Jun 23 08:12:50 hostname dovecot: auth: Error: mysql(databaseserver.com): Connect failed to database (database): Access denied for user: 'sqladmin@ip.of.host.machine [2]' (Using password: YES) - waiting for 1 seconds before retry
We are assuming this has something to do with the password hashing algorithm in older versions of mysql, but we are hoping to confirm this theory and find a solution.
Thanks.
This has as far as i can see nothing to do with hashes. It is the mysql database that disallows the user sqladmin access to the database. Make sure the user sqladmin has the proper rights to access the database, from the ipadres.
Gr Johan Hendriks
Links:
[1] mailto:list@airstreamcomm.net [2] mailto:sqladmin@ip.of.host.machine When talking about hashes I was referring to this wiki article: http://wiki1.dovecot.org/MysqlProblems. As I stated in my email we have confirmed that the host can access the database just fine, and the credentials are correct in the config for Dovecot.
Thanks. Well the wiki page you refering to is indeed describing problems with sha hashes. But the last line on this page tells you that it is fixed after 1.0rc9 And you mentioned using 2.0.12 So this is not the issue.
Sometimes you need to use the FQDN in the GRANT command within mysql also. regards, Johan Hendriks Double L automatisering
--- On Thu, 23/6/11, list@airstreamcomm.net <list@airstreamcomm.net> wrote:
From: list@airstreamcomm.net <list@airstreamcomm.net> Subject: Re: [Dovecot] Mysql access denied To: "Dovecot Mailing List" <dovecot@dovecot.org> Date: Thursday, 23 June, 2011, 17:11 On Thu, 23 Jun 2011 15:48:58 +0200, Johan Hendriks <joh.hendriks@gmail.com> wrote:
Op 23-6-2011 15:37, list@airstreamcomm.net [1] schreef: Currently using dovecot 2.0.12 and mysql server 4.0.20 (I know, it's really old) and having issues getting Dovecot to authenticate to the mysql server. We have confirmed that the credentials are correct and the host machine can access the database, however we are getting the following error:
Jun 23 08:12:50 hostname dovecot: auth: Error: mysql(databaseserver.com): Connect failed to database (database): Access denied for user: 'sqladmin@ip.of.host.machine [2]' (Using password: YES) - waiting for 1 seconds before retry
We are assuming this has something to do with the password hashing algorithm in older versions of mysql, but we are hoping to confirm this theory and find a solution.
Thanks.
This has as far as i can see nothing to do with hashes. It is the mysql database that disallows the user sqladmin access to the database. Make sure the user sqladmin has the proper rights to access the database, from the ipadres.
Gr Johan Hendriks
Links:
[1] mailto:list@airstreamcomm.net [2] mailto:sqladmin@ip.of.host.machine
When talking about hashes I was referring to this wiki article: http://wiki1.dovecot.org/MysqlProblems. As I stated in my email we have confirmed that the host can access the database just fine, and the credentials are correct in the config for Dovecot.
Thanks.
Hi ,
Just my 2c.
I noticed even in newer versions (in my case built from sources), if the admin enters special symbols on the passwords like !@#$%, MySQL accepts them but the user will never authenticate afterwards. So I keep passwords simple with latin and numbers only.
Also, make sure you have grasped well the "grant" syntax : example :
[root@localhost ~]# mysql –uroot –p<password> <ENTER> mysql> use datebase_schema; <ENTER> mysql> grant all on database_schema.* -> to user@localhost; <ENTER>
Try the same for ip addresses.
HTH,
s.
"I merely function as a channel that filters music through the chaos of noise"
- Vangelis
participants (4)
-
Johan Hendriks
-
list＠airstreamcomm.net
-
Spyros Tsiolis
-
Tom Hendrikx