[Dovecot] example sql acl_shared_dict wiki

[Robert Schetterer]

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