From owner-freebsd-questions@FreeBSD.ORG  Fri Feb 24 19:20:49 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 8C4B916A436
	for <freebsd-questions@freebsd.org>;
	Fri, 24 Feb 2006 19:20:49 +0000 (GMT)
	(envelope-from facha2002@mail.ru)
Received: from rider.com.ua (rider.net.ua [217.144.69.33])
	by mx1.FreeBSD.org (Postfix) with ESMTP id A977E43D4C
	for <freebsd-questions@freebsd.org>;
	Fri, 24 Feb 2006 19:20:48 +0000 (GMT)
	(envelope-from facha2002@mail.ru)
Received: from [192.168.5.42] (helo=dimas)
	by rider.com.ua with smtp (Exim 4.34) id 1FCibc-000CYK-Sn
	for freebsd-questions@freebsd.org; Fri, 24 Feb 2006 21:27:56 +0200
Message-ID: <00d401c63977$67628880$2a05a8c0@dimas>
From: "fa" <facha2002@mail.ru>
To: <freebsd-questions@freebsd.org>
Date: Fri, 24 Feb 2006 21:20:42 +0200
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="koi8-r"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Subject: dovecot-1.0.alpha5 + mysql
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 24 Feb 2006 19:20:49 -0000

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'

Exim is working with the same settings on the same machine. I also checked
if I can use these settings with mysql console client. I don't know where to
look for errors. Is anyone else having this problem?

Thanks in advance for your answers.