On Wed, 2009-12-09 at 12:22 -0800, Richard Stockton wrote:
At 11:45 AM 12/9/2009, Timo Sirainen wrote:
On Wed, 2009-12-09 at 11:38 -0800, Richard Stockton wrote:
password_query = .., 'maildir:/mail/' || home as userdb_mail, ..
Sorry, that doesn't work either. I get an "imap protocol error" in squirrelmail.
And what did Dovecot's logs say? http://wiki.dovecot.org/Logging
mail_location: Ambiguous mail location setting, don't know what to do with it: 0 (try prefixing it with mbox: or maildir:)
Oh. || wasn't concat operator in MySQL after all. I just recently tested that it didn't give an error so I assumed it was concat, not logical or. :)
I believe these errors were from my first attempt, when I just had "'/mail/' || home as userdb_home".
You should have used instead: concat('mail', home) as userdb_home