From owner-freebsd-stable Mon Jul 29 14:38:34 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 38A7437B400; Mon, 29 Jul 2002 14:38:13 -0700 (PDT) Received: from smtpzilla5.xs4all.nl (smtpzilla5.xs4all.nl [194.109.127.141]) by mx1.FreeBSD.org (Postfix) with ESMTP id 82B7543E5E; Mon, 29 Jul 2002 14:38:09 -0700 (PDT) (envelope-from danny@legalaliens.org) Received: from llama (allxs.xs4all.nl [194.109.223.7]) by smtpzilla5.xs4all.nl (8.12.0/8.12.0) with SMTP id g6TLc2Xw093477; Mon, 29 Jul 2002 23:38:02 +0200 (CEST) Message-ID: <0bfb01c23748$3158c770$0164a8c0@llama> From: "Danny Carroll" To: "Lucas Peet" , Cc: , References: <001701c23670$7e545bd0$0164a8c0@llama> <00c101c2373e$00ec4760$580c6c0a@air> Subject: Re: Courier-imap and MySQL Date: Mon, 29 Jul 2002 23:37:46 +0200 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 Thanks to all.. I figured it out.... It was a combination of a few things... Got it working like a dream now :) -D ----- Original Message ----- From: "Lucas Peet" To: "Danny Carroll" ; Cc: ; Sent: Monday, July 29, 2002 10:24 PM Subject: Re: Courier-imap and MySQL > 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