Date: Mon, 29 Jul 2002 00:26:25 +0200 From: "Danny Carroll" <danny@legalaliens.org> To: "Kirby Menzel" <kirb@insanegenius.net>, <john@maKintosh.com> Cc: <questions@freeBSD.org> Subject: Re: Courier-imap and MySQL Message-ID: <003201c23685$cf666620$0164a8c0@llama> References: <001701c23670$7e545bd0$0164a8c0@llama> <20020728171058.5e85085a.kirb@insanegenius.net>
next in thread | previous in thread | raw e-mail | index | archive | help
OK, Thanks to both of you for the QUICK responses. I've been struggeling with this all day. So a number of things needed to happen to get both postfix and courier-imap working with mySQL. 1. I needed to use encrypt() instead of password() in my SQL statements. 2. I needed to set in postfix... virtual_mailbox_base=/ That is dissapointing because I wanted to move it along to a nice quiet area... Maybe I could chroot the delivery agent.. Anyway I will leave it for now. 3. The maildir field needed to be absolute for courier... So now I have two questions for whoever has time... ;) 1. Is it OK to leave the virtual_mailbox_base=/ ??? 2. I want to forward any unmatched email for a domain, to a general wastebasket that I can sift through at my leasure. Can I add it to the sendmail virtualuser table in /etc/mail or can I use the virtual table in mysql to manage that? I guess I am asking, what /etc/mail files will postfix look at?? mailer.conf and /etc/aliases surely... but any more? -D ----- Original Message ----- From: "Kirby Menzel" <kirb@insanegenius.net> To: "Danny Carroll" <danny@legalaliens.org> Sent: Monday, July 29, 2002 12:10 AM Subject: Re: Courier-imap and MySQL > > > 1: make sure you start authdaemond BEFORE any courier services. > 2: If that wasn't the problem, turn on verbose logging in MySQL. Observe > the logs. > 3: If all else fails, run a kernel trace on the authdaemon and wade > through the output. > > 4: Sorry for the abruptness of my response, but I'm tired and busy right > now. > > > On Sun, 28 Jul 2002 21:53:38 +0200 > "Danny Carroll" <danny@legalaliens.org> wrote: > > > 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-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?003201c23685$cf666620$0164a8c0>