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 at ip.of.host.machine' (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.
Thursday, June 23, 2011, 8:37:50 AM, you wrote:> 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 at ip.of.host.machine' (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.You need to make sure there is a mysql account named 'sqladmin'@'ip.of.host.machine' that has access to whatever database/table it needs. -- Best regards, Duane mailto:duane at duanemail.org
On Thu, 23 Jun 2011 15:48:58 +0200, Johan Hendriks <joh.hendriks at gmail.com> wrote:> Op 23-6-2011 15:37, list at 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 at 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 at airstreamcomm.net > [2] mailto:sqladmin at ip.of.host.machineWhen 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 at 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