Date: Fri, 24 Feb 2006 15:52:43 -0800 From: Wes Santee <wsantee@gmail.com> To: fa <facha2002@mail.ru> Cc: freebsd-questions@freebsd.org Subject: Re: dovecot-1.0.alpha5 + mysql Message-ID: <43FF9C4B.5070700@gmail.com> In-Reply-To: <00d401c63977$67628880$2a05a8c0@dimas> References: <00d401c63977$67628880$2a05a8c0@dimas>
next in thread | previous in thread | raw e-mail | index | archive | help
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 fa wrote: > Hi. Sorry if this is a wrong place to ask. I've just compiled > dovecot-1.0.alpha5 with mysql support.from freebsd > ports (FreeBSD 6.0-RELEASE). It looks like dovecot has problems connecting > to mysql. In the log I'm getting: > > dovecot: Feb 24 16:57:41 Error: auth-worker(default): mysql: Connect failed > to (null) (exim): Access denied for user 'root'@'localhost' (using > password: > YES) - waiting for 5 seconds before retry > dovecot: Feb 24 16:57:41 Error: auth-worker(default): > sql(facha@facha.org.ua,127.0.0.1): Password query failed: Not connected to > database > dovecot: Feb 24 16:57:44 Info: pop3-login: Aborted login: > user=<facha@facha.org.ua>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, > secured > > This is my dovecot-mysql.conf: > connect = host=localhost dbname=exim user=root password=qwer > default_pass_scheme = PLAIN > password_query = SELECT password FROM auth WHERE username = '%u' AND domain > = '%d' http://www.dovecot.org/list/dovecot/2005-November/010000.html Check this thread. If it's the same thing that happened to me, you have to use OLD_PASSWORD(), not PASSWORD() in MySQL (assuming you're using 5.0) to set your password that dovecot uses to connect. Cheers, - -Wes -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) iQIVAwUBQ/+cO4rq8W17hxGfAQhmIhAAmRpyrCY9731s7CKRtOvaOfExZiFekZRj 1S7YVz4op3BdHmhs5iydvhjLRaLSVYKKDRmubaPWOZbjDsAPdoAsPjyhOTHBTvuA vzRaiR2XFj8m77qhYDnzd031RZz7MPUCXYkxOXs5NBa5hRQSvaxWJOYDXO81/p4i wMUnyUaht974OurWaZaT56JIEg1AnJRY7wurx5Q1i6ZcNLBIkM39neVbkkI18rMS rFUbc2L2l27745ttKLW1xqX7dkkyAKW+M/cz2n3IDIjfa31cue5u4ddFS2RYMD+f 1sMt2M5UMsxwPlLpBdI7kZYw7j5nwVuoYlsSShbKKyZBoTCgDKHUomIiuYIjwkrP 3DB3DH1R+yUZcvrR92JDZ2t80QpzyM7gckRCR5ig7aQdNg667SaFhvrpOlbDw9JJ rfryHhtsK6mKqMd8J+y14PTGDzvUZTYF6UIhDJFEvJos+XBDeG7Co82ZlgH7MY/f /QZ0fTH6YOonfy5KY0UL+HUCv/VHwrSMpp/wZsLh1A7Y2xJC8yFsOKUIy42DkARH 2Yg4Z4GwxFRt7bUvcVeeutBQrVNLBf5/vOpq2SlGbJtzKPPhCAz7FIGAbw4qF2TE 1TLTPcDum/ugJeKRcv6/PaIIgvdHJ+ZU9Ydl2hmXMafI90e16RLO5XGjr0EJHTyF Lvk1CpyOxME= =nKqV -----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43FF9C4B.5070700>