search for: user_shar

...1-23 16:33:20 master: Info: Dovecot v2.1.13 (6eabf0c738d7) starting up but I do not get no core dumps. The last SQL statement executed by Posgres is (log level debug5): 2013-01-24 11:09:59 CET DEBUG: StartTransactionCommand 2013-01-24 11:09:59 CET STATEMENT: SELECT dummy,to_user,from_user FROM user_shares 2013-01-24 11:09:59 CET DEBUG: StartTransaction 2013-01-24 11:09:59 CET STATEMENT: SELECT dummy,to_user,from_user FROM user_shares 2013-01-24 11:09:59 CET DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 2013-01-24 11:09:59 CET STATE...

...'m using Postgres as dict backend now and then I get this error, when someone changed ACLs, actually for some reason some users, who get permission from other users, get this error quite often: dict: Error: sql dict: commit failed: ERROR: duplicate key value violates unique constraint "user_shares_pkey" (query: INSERT INTO user_shares (dummy,to_user,from_user) VALUES ('1','user1','user2')) It looks like that this error is triggered, when a MUA is connecting to Dovecot after ACLs had been changed and opens several mailboxes at once. So two or parallel Dovecot...

...while true; do ( echo -en "H2\t0\t0\t\tacl\nI1\tshared/shared-boxes/\n" sleep 1 ) | socat - unix:/var/run/dovecot2.2/dict done I interprete H2-I1..-bang.log.gz (logged with v2.1) so, that each time the ACL dict is iterated, driver_sqlpool_query_s() is executed two times, once for user_shares and once for anyone_shares. I guess that the user_shares one is never finished, so that the sqlpool keeps that slot in "busy" state until timeout. The information about the slots of the log lines 0x9886d0 1. state=3 to_recon=(nil) ready=0 |driver_sqlpool_query_s end is generated by:...

...ot errors in my log: Jun 17 15:50:33 dict: Error: sql dict iterate: Invalid/unmapped path: shared/shared-boxes/anyone/ I have no clue why this happening, users don't know about new functionality they just use imap as before. Also dict database begin to fill up by records like: select * from user_shares; user at domain.com|admin at domain.com|1 But user don't use setacl command. Searching for the list gave http://www.dovecot.org/list/dovecot/2009-April/038664.html , but question seemed still open. So, can someone give point how to fix\avoid this ? One more question, on live system it'...

...lboxes available only for the same domain. A trick could be set acl_shared_dict to /var/mail/%d-shared-mailboxes.db, but I don't know if it's safe on an NFS environment. So, why don't provide a way to restrict shared mailboxes also for dict in SQL? One way could be to add to "user_shares" table a column "domains" which is the same domain of the mailbox'owner and a config option, for acl, like acl_only_for_same_domain =yes/no so dovecot can add a "WHERE %n = domain" for the SELECT. Are there other possible solutions? Thanks -- Alessio Cecchi is:...

...IMAP(dvtest) [29801]: Error: acl: dict commit failed 2009-06-25 14:27:03 dovecot: Error: child 29802 (dict) killed with signal 11 (core dumps disabled) My sql-dict.conf is: connect = host=localhost dbname=dovecot user=dovecot # password=pass [CUT samples for quota & expire] # CREATE TABLE user_shares ( # from_user varchar(100) not null, # to_user varchar(100) not null, # primary key (from_user, to_user) # ); map { pattern = shared/shared-boxes/user/$to/$from table = user_shares fields { from_user = $from to_user = $to } } ================== So I changed the con...

HI Steffen. In folder /var/vmail/example.com/user_a i've a dovecot-acl file with " user=test at example.com lrwstipekxa " IN mysql table user_shares i set: +---------------------+------------------+-------+ | from_user | to_user | dummy | +---------------------+------------------+-------+ | user_a at example.com | test at example.com | 1 | +---------------------+------------------+-------+ and the doveadm acl comman...

.../user1/Maildir I have created a file dovecot-acl with : owner lrwstipekxa user=user2 at domain.tld rl - in the dovecot-share-sql.conf I have : connect = host=/var/lib/mysql/mysql.sock dbname=xxxx user=xxx password=postfixpass map { pattern = shared/shared-boxes/user/$to/$from table = user_shares value_field = dummy fields { from_user = $from to_user = $to } } and in the user_share table : +-------------------+------------------+-------+ | from_user | to_user | dummy | +-------------------+------------------+-------+ | user1 at myhost.ro | us...

...rator = / prefix = shared/%%u/ #location = maildir:%%h/Maildir:INDEX=~/Maildir/shared/%%u location = mbox:/usr/home/vmail/%d/%u:INDEX=/usr/home/vmail/shared/%%u subscriptions = no list = children } # Set ACL to SQL Server and Reference sql-dictionary # Table implemented in mysql:/postfix/user_shares plugin { acl_shared_dict = proxy::acl } dict { acl = mysql:/usr/local/etc/dovecot-dict-sql.conf } *cat /usr/local/etc/dovecot-dict-sql.conf * map { pattern = shared/shared-boxes/user/$to/$from table = user_shares value_field = dummy fields { from_user = $from to_user = $t...

...The file /private/etc/smb.conf looks like this: ;[public] ;path = /tmp ;public = yes ;only guest = yes ;writable = yes ;printable = no [printers] path = /tmp printable = yes [Shared] path = /Users/rp/Shared read only = No inherit permissions = No guest ok = Yes ;Created by SharePoints [User_Share] path = /Users/Shared read only = No inherit permissions = No guest ok = Yes ;Created by SharePoints} ********************************************** I've googled this issue and asked on both mac and my linux distro forum. Anyone know what's causing this? Thank you, Ron

Hi, I configured shared mailboxes and get an error when i use SQL as the acl_shared_dict. It works when i use a file instead. With SQL as the shared_dict, dict crashes. I have enabled sql query logs on the mariadb server, the table user_shares and anyone_shares are queried but there is no insert to the empty tables. The dovecot-acl files are created in the mailbox when i add an acl with doveadm acl add ... doveadm acl debug shows an error: doveadm acl debug -u my at example.net shared/other at example.net/INBOX doveadm(my at examp...

Hi to all. First of all.. I'm new on the mailing list.. So.. Sorry in advance for any mistake or error on posting here.. The question (or doubt..) is about sharing mail folder. I use a test mail server. Is not the production server (always dovecot + postfix + spamassassin + clamav) Well.. In test mail server i can use the share folder, follow the conf istruction on wiki dovecot.

...I have some IMAP groups configured for sharing. And I guessed the example dictionary didn't allow for them. Looking at my existing shared-mailboxes.db flat file I saw something that gave me a clue. So I added the following: map { pattern = shared/shared-boxes/group/$to/$from table = user_shares value_field = dummy fields { from_user = $from to_user = $to } } And things started working again! A suggestion that perhaps this be added to the wiki - possibly with a bit more information on the "map" sections. Also - would there be any benefit to setting up a...

...:%%h/Maildir" won't work as some mailboxes are already converted and others aren't. Is there a way to cope with that? "doveconf -n" outout: # 2.2.13: /etc/dovecot/dovecot.conf # OS: Linux 3.16-0.bpo.3-amd64 x86_64 Debian 7.8 dict { acldict = mysql:/etc/dovecot/dovecot-dict-user_shares.conf quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf } mail_gid = 8 mail_location = maildir:%h/Maildir mail_plugins = quota zlib mail_privileged_group = mail mail_shared_explicit_inbox = yes mail_uid = 999 namespace { list = children location = maildir:%%h/Maildir prefix = shared/%...

...main. Here's my dovecot shared namespace: namespace { type = shared separator = / prefix = shared/%%u/ location = maildir:%%h:INDEX=~/shared/%%u subscriptions = no list = yes } The dovecot-dict-sql.conf.ext file has: map { pattern = shared/shared-boxes/user/$to/$from table = user_shares value_field = dummy fields { from_user = $from to_user = $to } } map { pattern = shared/shared-boxes/anyone/$from table = anyone_shares value_field = dummy fields { from_user = $from } } and in my global acl file I have: shared/office@ user at domain.com lrwstipekx...

...hared_dict = proxy::acl } When ACLs were set for particular mailbox I can see that dovecot-acl file were created but I have no idea how to specify a pattern for shared folder like is in the `dovecot-dict-sql.conf.ext` map { pattern = shared/shared-boxes/user/$to/$from table = user_shares value_field = dummy fields { from_user = $from to_user = $to } } My goal is to control how it appears on the client site. As for now is as `shared/user at domain/folder/` but I have no idea where it is defined. Thanks, Adam -------------- next part -------...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 3 Jun 2014, Gianluca Calloni wrote: > In folder /var/vmail/example.com/user_a i've a dovecot-acl file with " > user=test at example.com lrwstipekxa " > > IN mysql table user_shares i set: > > +---------------------+------------------+-------+ > | from_user | to_user | dummy | > +---------------------+------------------+-------+ > | user_a at example.com | test at example.com | 1 | > +---------------------+------------------+-------+...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 3 Jun 2014, Gianluca Calloni wrote: > But i need to know if is possible for user_a at mydomain.com to share only 1 or > 2 subfolder (E.g. .INBOX.FOLDER_A and .INBOX.FOLDER_B shared, > .INBOX_FOLDER_C not shared) What's the dovecot-acl in .INBOX and the three directories mentioned above? Or: doveadm acl get -u user_a at

...ared_dict: proxy::acl sieve: ~/.dovecot.sieve sieve_dir: ~/sieve dict: acl: pgsql:/etc/dovecot/dovecot-dict-sql.conf # cat /etc/dovecot/dovecot-dict-sql.conf connect = host=foo.bar dbname=dovecot user=dovecot password=xxx map { pattern = shared/shared-boxes/user/$owner/$user table = user_shares value_field = dummy fields { owner = $owner usr = $user } } map { pattern = shared/shared-boxes/anyone/$owner table = global_shares value_field = dummy fields { owner = $owner } } map { pattern = shared/shared-boxes/group/$group/$owner table = group_sh...

...quota2 username_field = username value_field = messages } # expires map { pattern = shared/expire/$user/$mailbox table = expires value_field = expire_stamp fields { username = $user mailbox = $mailbox } } # acl map { pattern = shared/shared-boxes/user/$to/$from table = user_shares value_field = dummy fields { from_user = $from to_user = $to } } map { pattern = shared/shared-boxes/anyone/$from table = anyone_shares value_field = dummy fields { from_user = $from } } -- e: ckubu at so36.net