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