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 26, 2007 8:48:07 am
List:net.sourceforge.lists.courier-users

At 11:25 AM 3/26/2007, you wrote:

James Homuth wrote:

I'm definitely connecting to mysql. See this query log snip: 7 Connect mail_admin@localhost on 7 Init DB mail 7 Query SELECT email, password, "", 5000, 5000, /home/vmail,

CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'),

"", "", "" FROM users WHERE email = "my@test.email"

Have you tried actually executing that? I'd imagine that the server would tell you that "/home/vmail isn't a known column name" or something like that. "/home/vmail" isn't really your account's home directory anyway.

You're right, and I'm an idiot. I actually just did that after sending in the log snip and was in the process of trying to figure out how best to fix it. I got: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',' at line 1

I was actually trying to do something along this line. /home/vmail/domain.name/username/Maildir, and the tutorial via http://www.urbanpuddle.com/articles/2006/10/12/setup-postfix-in-about-1-hour originally looked like it might be the best way to do it. But, that's what I get for following someone else's advice. I'll manually change it to what needs changing, but like I said, I'm an idiot.

While it's possible to just have a Maildir for each account, and no home directory, I'd advise against it. You won't be able to use account-specific maildrop rules, or maildrop filters. Things will get messy if you later decide that you want to.

That's why I was going for the approach I mentioned above.

I recommend setting up your directory structure like:

/home/vmail/my@test.email/Maildir

You should be able to store "/home/vmail/my@test.email" as the account's home directory value, and avoid the custom query entirely.

Again, you're probably right. I shoulda just wrote the SQL side of the setup myself.