Robert Schetterer schrieb: > Timo Sirainen schrieb: >> On May 22, 2009, at 3:47 AM, Robert Schetterer wrote: >> >>> Timo Sirainen schrieb: >>>> On Mon, 2009-05-18 at 01:40 +0200, Robert Schetterer wrote: >>>>> could you include an example for having >>>>> acl_shared_dict in sql ? >>>> See if you can get it working with these kind of settings: >>>> http://www.dovecot.org/list/dovecot/2009-April/038922.html >>>> >>> Hi Timo, no chance, i dont understand >>> what to to do here , or to setup needed tables in sql >>> i ve asked a few sql people, and they dont understand this too, >>> there is too less info, perhaps our fault, but i need a more qualified >>> example to setup and testing >>> imap acls in sql, please include some in the wiki , if you have time >> The problem is that I don't know either. I guess I could try this some >> day when I have more time. > > Its ok for me later, i need this feature for redundant sql setups, > i think db solution is better then using file with nfs sharing etc > > But until then have you tried that kind of >> setups and looked at what kind of SQL queries they output and what >> should be changed to make them work? >> > > i would do but i have no idea how to start any kind of testing > do you mean set it in dovoecot.conf an try to find out find out what is > needed with sniffing the sql querries? > I might try to ask some sql people doing this, but i am short in time > too these days > > Hi Timo, there was a mail http://www.mail-archive.com/dovecot@dovecot.org/msg14121.html from Bernhard Herzog at beginning of acl coding he wrote about sqlite ( dont know if it works ) --- To configure, create an entry for dict section of dovecot.conf like this:
acl_shared_dict = sqlite:$PREFIX/etc/acl-shared-dict.conf with the acl-shared-dict.conf containing this: connect = $PREFIX/var/lib/dovecot/acl-shared-ns.sqlite map { table = acl_shared_ns pattern = shared/acl_shared_ns/$owner value_field = has_visible_folders fields { owner = $owner } } The corresponding table in the sqlite database can be created with CREATE TABLE acl_shared_ns ( owner, has_visible_folders, PRIMARY KEY (owner) ON CONFLICT REPLACE ); In the imap section of dovecot.conf, add acl_shared_dict = proxy::acl_shared_dict --- perhaps this helps creating a working mysql example -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria