Date: Mon, 29 Jul 2002 15:24:55 -0500 From: "Lucas Peet" <lpeet@lucastek.com> To: "Danny Carroll" <danny@legalaliens.org>, <question@freebsd.org> Cc: <stable@freebsd.org>, <kirby@insanegenius.net> Subject: Re: Courier-imap and MySQL Message-ID: <00c101c2373e$00ec4760$580c6c0a@air> References: <001701c23670$7e545bd0$0164a8c0@llama>
next in thread | previous in thread | raw e-mail | index | archive | help
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" <danny@legalaliens.org> To: <question@freebsd.org> Cc: <stable@freebsd.org>; <kirby@insanegenius.net>; <lpeet@lucastek.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?00c101c2373e$00ec4760$580c6c0a>