From owner-freebsd-questions@FreeBSD.ORG Fri Feb 24 23:52:56 2006 Return-Path: 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 DE68D16A420 for ; Fri, 24 Feb 2006 23:52:56 +0000 (GMT) (envelope-from wsantee@gmail.com) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.206]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6CA0243D45 for ; Fri, 24 Feb 2006 23:52:56 +0000 (GMT) (envelope-from wsantee@gmail.com) Received: by wproxy.gmail.com with SMTP id i27so402233wra for ; Fri, 24 Feb 2006 15:52:55 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:x-enigmail-version:content-type:content-transfer-encoding; b=mK9GEV3H6ZoPaJmAlyWyzqriOYj+IaMBTkoBoNfpzpqRYohKlLzgaVRdRjgC3owS0MtxT+Q0l7U/4l5RBeYCdC1aXgSYyynx3iTjGkhaDca9QiQliymIqYjk5ERWmAv1Arrp400RGuZ07+53JnX2KTW5n1SRI2K1kUi3eA31WBM= Received: by 10.35.99.14 with SMTP id b14mr298538pym; Fri, 24 Feb 2006 15:52:55 -0800 (PST) Received: from ?10.0.1.3? ( [168.103.224.74]) by mx.gmail.com with ESMTP id q36sm1228079pyg.2006.02.24.15.52.51; Fri, 24 Feb 2006 15:52:52 -0800 (PST) Message-ID: <43FF9C4B.5070700@gmail.com> Date: Fri, 24 Feb 2006 15:52:43 -0800 From: Wes Santee User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: fa References: <00d401c63977$67628880$2a05a8c0@dimas> In-Reply-To: <00d401c63977$67628880$2a05a8c0@dimas> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: dovecot-1.0.alpha5 + mysql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 24 Feb 2006 23:52:57 -0000 -----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=, 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-----