On Thu, 23 Jun 2011 15:48:58 +0200, Johan Hendriks <joh.hendr...@gmail.com> wrote: > Op 23-6-2011 15:37, l...@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: > 'sqlad...@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:l...@airstreamcomm.net > [2] mailto:sqlad...@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.
