[Dovecot] Unbreakable NFS locking issues...

[Timo Sirainen]

On Nov 19, 2008, at 9:01 PM, Rod Treweek wrote:

> password_query = SELECT username as user, password,
> concat('/NFS1MAILDIR/mailSysV2/',
> maildir) as userdb_home, concat('maildir:/NFS1MAILDIR/ 
> mailSysV2/',maildir,
> ':INDEX=/usr/local/dovecot/indexes/',maildir) as userdb_mail, 143 AS
> userdb_uid, 143 AS userdb_gid, concat('*:storage=',  
> floor(quota*1024)) AS
> quota_rule FROM mailbox WHERE username = '%u' AND active = '1'

The userdb_* fields here are used only if you're using prefetch userdb.

> user_query = SELECT concat('/NFS1MAILDIR/mailSysV2/', maildir) as  
> home,
> concat('maildir:/NFS1MAILDIR/mailSysV2/', maildir) as mail,
> concat('maildir:/NFS1MAILDIR/mailSysV2/',maildir,
> ':INDEX=/usr/local/dovecot/indexes/',maildir) as mail_location,

"mail_location" field is ignored. It's called mail, which you're also  
returning without the :INDEX.

So I guess you're 1) not using prefetch userdb so the userdb_mail in  
password_query doesn't get used and 2) the "mail" field without :INDEX  
is used from user_query.

> I've got mail working more or less, however the indexes simply will  
> not
> appear in the path referenced above. My suspicion has been that this  
> is
> where my nfs locking problems are occurring, as  the indexes are  
> just not
> getting populated.  Any ideas?  I gather that the  cacheing done  
> through the
> mysql database is desirable as it would tend to speed things up  
> quite a
> bit....any ideas on how to pass the index location through the  
> string as
> well? Or is this generally regarded as a negligible gain?

What caching? I'm not really sure what you're asking here.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 194 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20081120/3d572a5a/attachment-0001.bin