Displaying 2 results from an estimated 2 matches for "imap_acl_shar".
Did you mean:
imap_acl_shares
2012 Jul 16
0
ACL with MySQL dict => full table scans
...alling ACL support on 2.1.6.
When a user changes these ACLs, this results in a full table scan on
the dictionary, that tells dovecot who shares with whom.
Here's what queries I see when I run
$ doveadm acl delete -u user1 shared/user2/folder user=user1
1: SELECT dummy,to_user,from_user FROM imap_acl_shares
2: SELECT dummy,from_user FROM imap_acl_anyone
3: BEGIN
4: DELETE FROM imap_acl_shares WHERE to_user = 'user1' AND from_user = 'user1'
5: INSERT INTO imap_acl_shares (dummy,to_user,from_user) VALUES ('1','user1','user1') ON DUPLICATE KEY UPDATE dummy='1...
2012 Aug 29
1
ACL MySQL dict: to_user==from_user entries
...Getacl completed.
As you can see, user at domain sets the ACL of his INBOX to the same
value it was set before (reading it from the server after this
idempotent write changed the order but none of the flags).
But after "SETACL INBOX user at domain lrwstipekxacd" I see a new entry
in my imap_acl_shares table where to_user and from_user both contain
the value "user at domain".
As far as I can see, this entry does not make much sense in the
database, because every user should be able so see its own folders.
But adding this line may blow up the database especially according to
the full...