-----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([EMAIL PROTECTED],127.0.0.1): Password query failed: Not connected to > database > dovecot: Feb 24 16:57:44 Info: pop3-login: Aborted login: > user=<[EMAIL PROTECTED]>, 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----- _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"