Skip site navigation (1)Skip section navigation (2)
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>