From owner-freebsd-questions@FreeBSD.ORG  Fri Jun 24 14:16:53 2005
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 10FF116A422
	for <freebsd-questions@freebsd.org>;
	Fri, 24 Jun 2005 14:16:53 +0000 (GMT)
	(envelope-from B.Candler@pobox.com)
Received: from orb.pobox.com (orb.pobox.com [207.8.226.5])
	by mx1.FreeBSD.org (Postfix) with ESMTP id D79E243D4C
	for <freebsd-questions@freebsd.org>;
	Fri, 24 Jun 2005 14:16:52 +0000 (GMT)
	(envelope-from B.Candler@pobox.com)
Received: from orb (localhost [127.0.0.1])
	by orb.pobox.com (Postfix) with ESMTP
	id 96C6227A0; Fri, 24 Jun 2005 10:16:43 -0400 (EDT)
Received: from bloodhound.noc.clara.net (bloodhound.noc.clara.net
	[195.8.70.207]) (using TLSv1 with cipher RC4-MD5 (128/128 bits))
	(No client certificate requested)
	by orb.sasl.smtp.pobox.com (Postfix) with ESMTP id 28FE595;
	Fri, 24 Jun 2005 10:16:41 -0400 (EDT)
From: Brian Candler <B.Candler@pobox.com>
To: Muhammad Kashif Yaqoob <mkyaqoob2005@yahoo.com>
Date: Fri, 24 Jun 2005 15:16:58 +0100
User-Agent: KMail/1.8
References: <20050624134244.42476.qmail@web32013.mail.mud.yahoo.com>
In-Reply-To: <20050624134244.42476.qmail@web32013.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-6"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200506241516.59227.B.Candler@pobox.com>
Cc: freebsd-questions@freebsd.org, courier-imap@lists.sourceforge.net
Subject: Re: courier-imap authenticate mysqk user
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 Jun 2005 14:16:53 -0000

On Friday 24 June 2005 14:42, Muhammad Kashif Yaqoob wrote:
>  I am working on postfix Mailserver at freebsd.and install the courier Imap
> and courier-authlib-mysql .and also Configuration the setting of
> courier-imap with mysql.When i authenticate the mysql pop user  with
> courier-imap.Following error message occour.
>
> Part of my maillog:
>
> Jun 24 22:44:44 post-4 authdaemond.mysql: modules="authmysql", daemons=5
> Jun 24 22:48:20 post-4 authdaemond.mysql: modules="authmysql", daemons=5
> Jun 24 22:48:43 post-4 pop3d: LOGIN FAILED, ip=[::1]
> Jun 24 22:58:21 post-4 pop3d: LOGIN FAILED, ip=[::1]

You don't say what version of courier-imap you are using, but from those log 
messages I think it is 3.x or older. You should install 4.x with 
courier-authlib; it gives much better debugging.

Full details of how to debug authentication problems with courier-authilb are 
in http://www.courier-mta.org/authlib/README.authdebug.html

Turning on debugging will show you exactly what SQL queries are being sent to 
the database, for example.

Brian.