On Wed, 2009-12-09 at 13:05 -0800, Richard Stockton wrote:
> At 12:28 PM 12/9/2009, Timo Sirainen wrote:
> >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
>
> I just tried: concat('mail/', home) as userdb_home
Was it really 'mail/', not '/mail/'? I forgot those / characters above..
> If I try: concat('maildir:/mail/', home) as userdb_mail
> (leaving the old config mail_location = maildir:/mail/:INDEX=MEMORY)
>
> I get the same squirrelmail error and this in dovecot-info.log
> Dec 9 12:49:13 webmail02 dovecot: Fatal: Mailbox indexes in
> /mail/r/l/rls/Maildir/ are in NFS mount. You must set
> mail_nfs_index=yes (and mail_nfs_storage=yes) to avoid index
> corruptions. If you're sure this check was wrong, set nfs_check=no.
>
> which I assume is due to there being no "INDEX=MEMORY" anywhere.
Right, you should have added that to the concat() also. The point of
userdb_mail is that it completely overrides mail_location setting's
value.
signature.asc
Description: This is a digitally signed message part
