From owner-freebsd-stable Sun Jul 28 20:20:39 2002 Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 23FEF37B400 for ; Sun, 28 Jul 2002 20:20:37 -0700 (PDT) Received: from mail.lambertfam.org (www.lambertfam.org [216.223.196.6]) by mx1.FreeBSD.org (Postfix) with ESMTP id A718F43E4A for ; Sun, 28 Jul 2002 20:20:36 -0700 (PDT) (envelope-from lambert@lambertfam.org) Received: from localhost.localdomain (localhost [127.0.0.1]) by localhost.inch.com (Postfix) with ESMTP id 4FF2635190 for ; Sun, 28 Jul 2002 23:17:59 -0400 (EDT) Received: from laptop.lambertfam.org (unknown [10.1.0.2]) by mail.lambertfam.org (Postfix) with ESMTP id 1A0823518E for ; Sun, 28 Jul 2002 23:17:54 -0400 (EDT) Received: by laptop.lambertfam.org (Postfix, from userid 1000) id D92D828B17; Sun, 28 Jul 2002 23:20:15 -0400 (EDT) Date: Sun, 28 Jul 2002 23:20:15 -0400 From: Scott Lambert To: stable@freebsd.org Subject: Re: Courier-imap and MySQL Message-ID: <20020729032015.GC82189@laptop.lambertfam.org> Mail-Followup-To: stable@freebsd.org References: <001701c23670$7e545bd0$0164a8c0@llama> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <001701c23670$7e545bd0$0164a8c0@llama> User-Agent: Mutt/1.4i Sender: owner-freebsd-stable@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Sun, Jul 28, 2002 at 09:53:38PM +0200, Danny Carroll wrote: > I have heard about a lot of people with the same problem as me. > I am trying to setup virtual mail users with postfix, courier-imap and > mySQL. > > I followed the proceedure at the following site: > http://kirb.insanegenius.net/postfix.html > The only message in the maillog log file is: "Jul 28 21:04:04 guard pop3d: > LOGIN FAILED, ip=[::ffff:127.0.0.1]" Courier doesn't log for shit. Sam seems diametrically opposed to adding any meaningful logging. His troubleshooting advise is "strace it". > I still can't figure out if that is the AuthModule which can't log in > to mySQL or the user/pass for the mail user is wrong. Did ANYONE? > Manager to get this going on 4.6-STABLE > > Here are my files: > [09:49pm root@guard:/usr/local/etc/courier-imap]#egrep ^[^#] authdaemonrc > authmodulelist="authmysql" > authmodulelistorig="authcustom authuserdb authmysql authpam" > daemons=5 > version="authdaemond.mysql" > authdaemonvar=/usr/local/var/authdaemon > > [09:49pm root@guard:/usr/local/etc/courier-imap]#egrep ^[^#] authmysqlrc > MYSQL_SERVER guard > MYSQL_SOCKET /tmp/mysql.sock > MYSQL_PORT 3306 I've not gotten TCP sockets working. I couldn't interpret the strace well enough. If MySQL is on the local server, set MYSQL_SERVER to "localhost" to try to use the unix socket. Also, to simplify the debug process, try using authtest to cut the pop3 server out of the loop. -- Scott Lambert KC5MLE Unix SysAdmin lambert@lambertfam.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message