Date: Mon, 29 Jul 2002 23:37:46 +0200 From: "Danny Carroll" <danny@legalaliens.org> To: "Lucas Peet" <lpeet@lucastek.com>, <question@freebsd.org> Cc: <stable@freebsd.org>, <kirby@insanegenius.net> Subject: Re: Courier-imap and MySQL Message-ID: <0bfb01c23748$3158c770$0164a8c0@llama> References: <001701c23670$7e545bd0$0164a8c0@llama> <00c101c2373e$00ec4760$580c6c0a@air>
next in thread | previous in thread | raw e-mail | index | archive | help
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" <lpeet@lucastek.com> To: "Danny Carroll" <danny@legalaliens.org>; <question@freebsd.org> Cc: <stable@freebsd.org>; <kirby@insanegenius.net> 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" <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?0bfb01c23748$3158c770$0164a8c0>