From owner-freebsd-stable Mon Jul 29 13:25: 7 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 6087137B400; Mon, 29 Jul 2002 13:25:00 -0700 (PDT) Received: from mail.eccod.com (mkc-65-30-112-108.kc.rr.com [65.30.112.108]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2FE3943E4A; Mon, 29 Jul 2002 13:24:59 -0700 (PDT) (envelope-from lpeet@lucastek.com) Received: from air (eccod.com [65.30.112.108]) by mail.eccod.com (Postfix) with SMTP id EF588246C5; Mon, 29 Jul 2002 15:24:03 -0500 (CDT) Message-ID: <00c101c2373e$00ec4760$580c6c0a@air> From: "Lucas Peet" To: "Danny Carroll" , Cc: , References: <001701c23670$7e545bd0$0164a8c0@llama> Subject: Re: Courier-imap and MySQL Date: Mon, 29 Jul 2002 15:24:55 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 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 One helpful thing I've found in troubleshooting this is to add this line to /etc/my.cnf: log = /tmp/query.log and restart MySQL. This file could potentially grow HUGE, as it logs every SQL query / statement sent to MySQL, so comment it out when you're done. Use tail -f on this file, and try to log in while watching the file to see what Courier is sending to the database. -Lucas ----- Original Message ----- From: "Danny Carroll" To: Cc: ; ; Sent: Sunday, July 28, 2002 2:53 PM Subject: Courier-imap and MySQL > Hiya... > > 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. > > The postfix stuff works well, delivering email where I want. > The courier pop and imap services, however refuse to authenticate. > > 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]" > > 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_USERNAME courier > MYSQL_PASSWORD XXXX > MYSQL_SOCKET /tmp/mysql.sock > MYSQL_PORT 3306 > MYSQL_OPT 0 > MYSQL_DATABASE maildb > MYSQL_USER_TABLE users > MYSQL_CRYPT_PWFIELD crypt > MYSQL_CLEAR_PWFIELD clear > MYSQL_UID_FIELD uid > MYSQL_GID_FIELD gid > MYSQL_LOGIN_FIELD id > MYSQL_HOME_FIELD home > MYSQL_NAME_FIELD name > MYSQL_MAILDIR_FIELD maildir > > [09:50pm root@guard:/usr/local/etc/courier-imap]#egrep ^[^#] pop3d > prefix=/usr/local > exec_prefix=/usr/local > sbindir="/usr/local/sbin" > PIDFILE=/var/run/pop3d.pid > MAXDAEMONS=40 > MAXPERIP=4 > AUTHMODULES="authdaemon" > AUTHMODULES_ORIG="authdaemon" > POP3AUTH="" > POP3AUTH_ORIG="LOGIN CRAM-MD5 CRAM-SHA1" > POP3AUTH_TLS="" > POP3AUTH_TLS_ORIG="LOGIN PLAIN" > PORT=110 > ADDRESS=0 > TCPDOPTS="-nodnslookup -noidentlookup" > POP3DSTART=YES > > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-stable" in the body of the message