25 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Can't log in via ...
FromSent OnAttachments
James HomuthMar 26, 2007 2:56 am 
Bernd WurstMar 26, 2007 3:52 am 
Bernd WurstMar 26, 2007 3:54 am 
James HomuthMar 26, 2007 3:57 am 
Bernd WurstMar 26, 2007 4:02 am 
James HomuthMar 26, 2007 5:08 am 
Gordon MessmerMar 26, 2007 8:25 am 
James HomuthMar 26, 2007 8:48 am 
Gordon MessmerMar 26, 2007 9:34 am 
James HomuthMar 26, 2007 5:51 pm 
Gordon MessmerMar 26, 2007 9:57 pm 
Bernd WurstMar 26, 2007 10:35 pm 
James HomuthMar 27, 2007 3:19 am 
Gordon MessmerMar 27, 2007 6:46 am 
James HomuthMar 27, 2007 8:52 am 
Bernd WurstMar 27, 2007 10:29 am 
James HomuthMar 28, 2007 3:39 pm 
Bernd WurstMar 28, 2007 10:42 pm 
James HomuthMar 31, 2007 4:21 am 
James HomuthMar 31, 2007 4:25 am 
Bernd WurstMar 31, 2007 6:54 am 
James HomuthMar 31, 2007 7:32 am 
Bernd WurstMar 31, 2007 7:42 am 
James HomuthMar 31, 2007 9:05 am 
James HomuthMar 31, 2007 9:12 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [courier-users] Can't log in via courier-pop3Actions...
From:James Homuth (jam@the-jdh.com)
Date:Mar 27, 2007 3:19:21 am
List:net.sourceforge.lists.courier-users

At 01:35 AM 3/27/2007, you wrote:

Hi.

Am Dienstag, 27. März 2007 schrieb James Homuth:

Should I be seeing something in the SQL logs like this, or did I screw up your query? 9 Connect mail_admin@localhost on 9 Init DB mail 9 Query SELECT email, password, "", 5000, 5000, /home/vmail/$(domain)/$(local_part), "", "", "", "" FROM users WHERE email = "my@test.email" 9 Quit>

Again, you have /home/vmail... unquoted as a field name, what can never work.

Are you using MYSQL_SELECT_CLAUSE for this?

... Actually, I was just going to append the last part of the query with MYSQL_WHERE_CLAUSE. I hadn't made any real modifications to the default courier-authmysql query after my original modification went south. So, the unquoted /home/mail part of the query is Courier itself. All I'm basicly using is:

SELECT email, password, "", $UID, $GID, /$HOME, "", "", "", "" FROM users WHERE email = "$LOGINID"

James