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 [EMAIL PROTECTED] 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 = "[EMAIL PROTECTED]" > >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/[EMAIL PROTECTED]/Maildir > >You should be able to store "/home/vmail/[EMAIL PROTECTED]" 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. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ courier-users mailing list courier-users@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
