Date: Mon, 29 Jul 2002 00:15:09 +0200 From: "Danny Carroll" <danny@legalaliens.org> To: "John Kerbawy" <john@maKintosh.com> Cc: <questions@freebsd.org> Subject: Re: Courier-imap and MySQL Message-ID: <000f01c23684$3c8669a0$0164a8c0@llama> References: <001701c23670$7e545bd0$0164a8c0@llama> <20020728212145.GW28040@maKintosh.com>
next in thread | previous in thread | raw e-mail | index | archive | help
I turned on logging and indeed got a select in there...
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
020729 0:00:23 1 Connect courier@guard on
1 Init DB maildb
1 Query SELECT id, crypt, clear, uid, gid, home,
maildir, "", name FROM users WHERE id = "testuser1"
So that's something... I also made some other progress..
The user's password was set as password('mypass') instead of
encrypt('mypass') so I changed that
So I have that working now and it seems there is a few problems with where
my mail is being stored.
Will test some stuff and respond..
-D
----- Original Message -----
From: "John Kerbawy" <john@maKintosh.com>
To: "Danny Carroll" <danny@legalaliens.org>
Sent: Sunday, July 28, 2002 11:21 PM
Subject: Re: Courier-imap and MySQL
> On Sun, Jul 28, 2002 at 09:53:38PM +0200, Danny Carroll 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
>
> Have you tried turning on logging in MySQL so you can see what the query
> looks like? It's a bit easier than hacking up Courier's source.
>
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?000f01c23684$3c8669a0$0164a8c0>