search for: imap_acl_shares

Displaying 2 results from an estimated 2 matches for "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 t...