[Dovecot] After upgrading to 1.2 - absolute path questions

[Timo Sirainen]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20091209/60b1cef1/attachment.bin