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
signature.asc
Description: This is a digitally signed message part
