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. 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. 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. ------------------------------------------------------------------------- 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
