From owner-freebsd-questions@FreeBSD.ORG Tue Aug 26 06:29:18 2003 Return-Path: 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 6CAC316A4BF for ; Tue, 26 Aug 2003 06:29:18 -0700 (PDT) Received: from ajax.achean.com (ajax.achean.com [212.87.82.16]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3A3A443F75 for ; Tue, 26 Aug 2003 06:29:14 -0700 (PDT) (envelope-from jon.mercer@achean.com) Received: from menelaus.office.achean.com (dsl-217-155-191-93.zen.co.uk [217.155.191.93]) by ajax.achean.com (8.12.9/8.12.8) with ESMTP id h7QDSffS050695 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Tue, 26 Aug 2003 14:28:42 +0100 (BST) (envelope-from jon.mercer@achean.com) Received: from achean.com (localhost [127.0.0.1])h7QDSVZ8001067 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 26 Aug 2003 14:28:35 +0100 (BST) (envelope-from jon.mercer@achean.com) Message-ID: <3F4B607C.9040603@achean.com> Date: Tue, 26 Aug 2003 14:28:28 +0100 From: Jon Mercer User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20030806 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Johan Paul References: <1367.193.166.135.194.1061902265.squirrel@silakka.nettikala.fi> In-Reply-To: <1367.193.166.135.194.1061902265.squirrel@silakka.nettikala.fi> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-2.6 required=5.0 tests=EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA,X_ACCEPT_LANG version=2.55-achean_mailfilter_v1.00 X-Spam-Report: This mail is probably spam. The original message has been attachedunwanted mail in future. See http://spamassassin.org/tag/ for more details. for yonks, and found that there were some other files that needed to be setup, e.g.: ajax# cd /usr/local/lib/sasl2 ajax# cat Cyrus.conf pwcheck_method: saslauthd ajax# [...] Content analysis details: (-2.60 points, 5 required) X_ACCEPT_LANG (-0.1 points) Has a X-Accept-Language header IN_REP_TO (-0.5 points) Has a In-Reply-To header non-spam MUA (Mozilla)headeremail attributionquoted email text REPLY_WITH_QUOTES (-0.5 points) Reply with quoted text X-Spam-Checker-Version: SpamAssassin 2.55-achean_mailfilter_v1.00 (1.174.2.19-2003-05-19-exp) cc: freebsd-questions@freebsd.org Subject: Re: Cyrus IMAP with pam_mysql? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 26 Aug 2003 13:29:18 -0000 Welcome to nightmaresville. I struggled with this for yonks, and found that there were some other files that needed to be setup, e.g.: ajax# cd /usr/local/lib/sasl2 ajax# cat Cyrus.conf pwcheck_method: saslauthd ajax# There is at least one other one, and I'm trying to find it! Are you getting any trace out that you can post? I'd agree with you that it doesn't seem to be contacting the database. If you have a log against mysql, you could check this from the database end. In my view, the docs for Cyrus fall a long way short of what is really needed! Cheers, Jon Mercer Johan Paul wrote: > Hi, > > Has anyone managed to get the Cyrus imapd to authenticate with pam_mysql > -authentication? > > In /usr/local/etc/imapd.conf I have: > allowanonymouslogin: no > allowplaintext: yes > sasl_pwcheck_method: saslauthd > sasl_mech_list: PLAIN > > ...among other things. > > I am running saslauthd with pam authentication: > silakka# ps xa |grep saslauthd > 258 ?? Is 0:00.01 /usr/local/sbin/saslauthd1 -a pam > > > This is what I have in my /etc/pam.conf: > > # Mail services > imap auth sufficient pam_mysql.so user=mail passwd=uBerSecRETPASS > host=localhost db=mail table=accountuser usercolumn=username > passwdcolumn=password crypt=1 > > imap account required pam_mysql.so user=mail passwd=uBerSecRETPASS > host=localhost db=mail table=accountuser usercolumn=username > passwdcolumn=password crypt=1 > > The problem, I think, is the service column. The authentication is done > via PAM since when I change the password for my shell account the mail > password is changed too. But saslauthd uses some other service to > authenticate, not imap and thus not pam_mysql. Why doesn't it reconize the > above lines for Cyrus? > > I am running FreeBSD 4.8R > > This is giving me serious headache :) Thanks in advance for any clues!! > > > Regards, > > Johan Paul > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" -- +----------------------------------------------------------------+ | ___ ___ | | / | | / | | / /| | / / | | / / | | _____ / / ____ ____ ___ | | / /__| | / ___ \ / /__ / __ \ / _ | | /__ | | / ____ | / / /_/ / ___ \ / /_/ / / / | | / ___ \ | | / / | | / / __ / / \ \ | ___/__ / / / / / / \ \ | | / / | | | |__/ / / / / / | \__/ / | |_| | / / / / | | /__\ /___\ \_____/ /__| /__| \_____/ \__/|_| /__| /__| | | | | www.achean.com | | ============== | | Jon Mercer jon.mercer@achean.com | | | | Mobile 07973 256496 | | | | Tel. 0117 9561211 | | | | Fax 0117 9565637 | +----------------------------------------------------------------+