From owner-freebsd-questions Sun Jul 28 15:15:28 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C463C37B400 for ; Sun, 28 Jul 2002 15:15:25 -0700 (PDT) Received: from smtpzilla1.xs4all.nl (smtpzilla1.xs4all.nl [194.109.127.137]) by mx1.FreeBSD.org (Postfix) with ESMTP id EBDD243E70 for ; Sun, 28 Jul 2002 15:15:24 -0700 (PDT) (envelope-from danny@legalaliens.org) Received: from llama (allxs.xs4all.nl [194.109.223.7]) by smtpzilla1.xs4all.nl (8.12.0/8.12.0) with SMTP id g6SMFNSA016075; Mon, 29 Jul 2002 00:15:23 +0200 (CEST) Message-ID: <000f01c23684$3c8669a0$0164a8c0@llama> From: "Danny Carroll" To: "John Kerbawy" Cc: References: <001701c23670$7e545bd0$0164a8c0@llama> <20020728212145.GW28040@maKintosh.com> Subject: Re: Courier-imap and MySQL Date: Mon, 29 Jul 2002 00:15:09 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG 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" To: "Danny Carroll" 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