dovecot-1.0.alpha5 + mysql

Wes Santee wsantee at gmail.com
Fri Feb 24 15:52:57 PST 2006


-----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 at 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 at 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-----


More information about the freebsd-questions mailing list