Re: [SOGo] Sogo - dovecot - shared mailboxes

2015-06-30 Thread Frank Soyer

Hi again,
I've not say that Show subscribed mailboxes only is not cheched, of 
course.

Note also that calendars and address books sharing works fine.
Any help will be appreciated  :where and what to search, how to debug 
(*_debug options in 10-mail.conf provide no help).

Thanks

@Daniel : I agree, LIST command only list folders, no shares.

Le 27/06/2015 01:54, Frank Soyer a écrit :

Hi all,
I have a fresh install of Postfix-Dovecot-SOGo on CentOs-MariaDB. All 
works fine except one thing : I can't see shared mailboxes between 
users. Other User never appear in user mailboxes, nor on webUI or 
Thunderbird. Anybody seeing what I'm doing wrong ? I'm not sure what 
is needed in Sogo config for handle that ?


The ACL of Dovecot seems OK :
# telnet localhost 143
. login usersharingfol...@domain.com myPassword
. GETACL SharedFolder
* ACL SharedFolder userusingfol...@domain.com ilrtd 
usersharingfol...@domain.com lrwstipekxacd


In SOGo, ACLs are correctly kept in Share box, when I reopen it.
/home/vmail/shared-mailboxes contains :
shared/shared-boxes/user/userusingfol...@domain.com/usersharingfol...@domain.com 


1

/home/vmail/domain.com/userSharingFolder/dovecot-acl-list contains :

1435271252 SharedFolder


userUsingFolder is in delegation on mailbox of userSharingFolder.

Here is my dovecot config:

dict {
  quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf
}
first_valid_gid = 12
first_valid_uid = 101
lda_mailbox_autocreate = yes
lda_mailbox_autosubscribe = yes
lmtp_save_to_detail_mailbox = yes
mail_location = maildir:/home/vmail/%d/%n
mail_plugins = quota trash
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope
encoded-character vacation subaddress comparator-i;ascii-numeric
relational regex imap4flags copy include variables body enotify
environment mailbox date
mbox_write_locks = fcntl
namespace {
  inbox = yes
  location =
  prefix =
  separator = /
  type = private
}
namespace {
  list = children
  location = maildir:%%h/Maildir:INDEX=~/Maildir/shared/%%u
  prefix = shared/%%u/
  separator = /
  subscriptions = no
  type = shared
}
passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
plugin {
  acl = vfile
  acl_shared_dict = file:/home/vmail/shared-mailboxes
  quota = dict:user::proxy::quotadict
  sieve = ~/.dovecot.sieve
  sieve_dir = ~/sieve
  sieve_global_dir = /var/lib/dovecot/sieve/
  sieve_global_path = /var/lib/dovecot/sieve/default.sieve
  sieve_max_script_size = 1M
  trash = /etc/dovecot/trash.conf
}
protocols = imap lmtp sieve
service auth {
  unix_listener /var/spool/postfix/private/auth {
mode = 0666
  }
  unix_listener auth-userdb {
group = mail
mode = 0600
user = vmail
  }
}
service dict {
  unix_listener dict {
group = mail
mode = 0600
user = vmail
  }
}
service imap-login {
  inet_listener imap {
port = 143
  }
  inet_listener imaps {
port = 993
ssl = yes
  }
}
service imap {
  vsz_limit = 256 M
}
service managesieve-login {
  inet_listener sieve {
port = 4190
  }
  process_min_avail = 0
  service_count = 1
  vsz_limit = 64 M
}
service pop3-login {
  inet_listener pop3 {
port = 110
  }
  inet_listener pop3s {
port = 995
ssl = yes
  }
}
ssl_cert = /etc/pki/dovecot/certs/dovecot.pem
ssl_key = /etc/pki/dovecot/private/dovecot.pem
userdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}
protocol lmtp {
  mail_plugins = quota trash
}
protocol lda {
  mail_plugins = sieve acl
}
protocol imap {
  imap_client_workarounds = delay-newmail
  mail_plugins = quota trash acl imap_acl
}
protocol sieve {
  managesieve_implementation_string = Dovecot Pigeonhole
  managesieve_max_compile_errors = 5
  managesieve_max_line_length = 65536
}
protocol pop3 {
  mail_plugins = quota trash
  pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
}



Thank you !
Frank


--
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] BTS activities for Tuesday, June 30 2015

2015-06-30 Thread SOGo reporter
Title: BTS activities for Tuesday, June 30 2015





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Tuesday, June 30 2015

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
3235
	2015-06-30 13:29:04
	updated (open)
	ActiveSync
	a programming error in SOGoMailObject+ActiveSync.m
	
	  
	
3272
	2015-06-30 22:43:39
	updated (open)
	ActiveSync
	RoadSync for Java unable to sync
	
	  
	
3244
	2015-06-30 10:53:25
	updated (open)
	Backend Calendar
	Creating appointments fails silently through CalDAV if participant blocked being invited
	
	  
	
3152
	2015-06-30 09:28:36
	feedback (reopened)
	ActiveSync
	Sent email breaks mail thread on BlackBerry 10 smartphone
	
	  
	
  
  




[SOGo] ics export is slow

2015-06-30 Thread Emmanuel Dreyfus
Hi

I posted already about this issue and got no reply. I repost as I gathered
more information.

Exporting as .ucs is painfully slow. It can take more than 30s. I ruled 
out any problem with Apache and MySQL:

1) No problem in Apache, as the problem happens if I ask SOGo directly:
$ ICS=/SOGo/dav/user/Calendar/3E8-50B38880-F-6B8B4580.ics
$ time wget http://sogo-anonymous:@localhost:2${ICS}
Resolving localhost (localhost)... ::1, 127.0.0.1
Connecting to localhost (localhost)|::1|:2... failed: Connection refused.
Connecting to localhost (localhost)|127.0.0.1|:2... connected.
HTTP request sent, awaiting response... 401 Authorization Required
Authentication selected: basic realm=SOGo
Connecting to localhost (localhost)|127.0.0.1|:2... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1014850 (991K) [text/calendar]
Saving to: '3E8-50B38880-F-6B8B4580.ics.3'

3E8-50B38880-F-6B8B 100%[=] 991.06K  --.-KB/s   in 0.05s  

2015-06-30 09:11:15 (19.9 MB/s) - '3E8-50B38880-F-6B8B4580.ics.3' saved 
[1014850/1014850]

   50.48s real 0.00s user 0.04s system

2) No problem with MySQL. I enabled the slow query log, and mysqldumpslow
tells me no query took more than 0.25s. Therefore adding an index will not
help.

Count: 1  Time=0.25s (0s)  Lock=0.00s (0s)  Rows=1559.0 (1559)
  SELECT b.c_name,b.c_version,b.c_lastmodified,b.c_creationdate,
 a.c_component,b.c_content
  FROM sogouser00636dbde13_quick a, sogouser00636dbde13 b WHERE
  (c_classification = N) AND a.c_name = b.c_name AND (c_deleted !=
  N OR c_deleted IS NULL)

Count: 1  Time=0.03s (0s)  Lock=0.00s (0s)  Rows=1803.0 (1803),
  SELECT c_lastmodified FROM sogouser00636dbde13 ORDER BY c_lastmodified
  DESC

Count: 6  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (6),
  SELECT c_folder_id, c_path, c_location, c_quick_location,
  c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1
  = 'S' AND c_path2 = 'S' AND c_path3 = 'S' AND c_path4 = 'S'

Count: 5  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=3.0 (15),
  SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'S' AND
  c_folder_type = 'S'

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=1.0 (1),
  SELECT c_uid, c_object, c_role FROM sogoedreyfus0011f18833d_acl
  WHERE (c_object = 'S') AND ((c_uid = 'S') OR (c_uid LIKE 'S'))


Therefore the problem is really inside SOGo. Peeking at the source, 
it is said that SOGo has to parse the .ics output from the database.
Could that be the problem? Is there a way to speed it up?

-- 
Emmanuel Dreyfus
m...@netbsd.org
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Sogo connector - What for?

2015-06-30 Thread Luca Olivetti

El 29/06/15 a les 12:36, zsigmond.ta...@autoduna.hu ha escrit:


So my question is, what is the purpose of the sogo connector?


To synchronize and use remote address books.

Bye
--
Luca Olivetti
Wetron Automation Technology http://www.wetron.es/
Tel. +34 93 5883004 (Ext.3010)  Fax +34 93 5883007
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Sogo connector - What for?

2015-06-30 Thread Sven Schwedas
On 2015-06-29 12:36, zsigmond.ta...@autoduna.hu wrote:
 Hi everyone,
 
 I am using sogo together with thunderbird and lightning.
 I don't really see the reason for installing the sogo connector plugin,
 because it seems that  events get synchronized without the plugin, and it
 disables the folder bolding (when new mail arrives) in thunderbird.
 
 So my question is, what is the purpose of the sogo connector?

Lightning only provides CalDAV (=calendar, task sync), not CardDAV
(=address books), for that you need the connector. For SOGo-specific
things like ACL/subscription management and plug-in management you'll
need the Integrator as well.

 thunderbird 38.0.1
 lightning 4.0.0.1
 SOGO connector 31.0.1
 
 thanks and regards
 tom
 

-- 
Mit freundlichen Grüßen, / Best Regards,
Sven Schwedas
Systemadministrator
TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz
Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167
http://software.tao.at



signature.asc
Description: OpenPGP digital signature


Re: [SOGo] Sogo - dovecot - shared mailboxes

2015-06-30 Thread Daniel van Ham Colchete
Frank,

let me know when you find the answer. I'm having exactly the same problem
here. The fact is that the LIST * * IMAP command is not listing the
shared folders so SOGo won't find them. Your config is as good as mine.

Best,
Daniel

On Fri, Jun 26, 2015 at 8:54 PM, Frank Soyer fso...@free.fr wrote:

 Hi all,
 I have a fresh install of Postfix-Dovecot-SOGo on CentOs-MariaDB. All
 works fine except one thing : I can't see shared mailboxes between users.
 Other User never appear in user mailboxes, nor on webUI or Thunderbird.
 Anybody seeing what I'm doing wrong ? I'm not sure what is needed in Sogo
 config for handle that ?

 The ACL of Dovecot seems OK :
 # telnet localhost 143
 . login usersharingfol...@domain.com myPassword
 . GETACL SharedFolder
 * ACL SharedFolder userusingfol...@domain.com ilrtd 
 usersharingfol...@domain.com lrwstipekxacd

 In SOGo, ACLs are correctly kept in Share box, when I reopen it.
 /home/vmail/shared-mailboxes contains :

 shared/shared-boxes/user/
 userusingfol...@domain.com/usersharingfol...@domain.com
 1

 /home/vmail/domain.com/userSharingFolder/dovecot-acl-list contains :

 1435271252 SharedFolder


 userUsingFolder is in delegation on mailbox of userSharingFolder.

 Here is my dovecot config:

 dict {
   quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf
 }
 first_valid_gid = 12
 first_valid_uid = 101
 lda_mailbox_autocreate = yes
 lda_mailbox_autosubscribe = yes
 lmtp_save_to_detail_mailbox = yes
 mail_location = maildir:/home/vmail/%d/%n
 mail_plugins = quota trash
 managesieve_notify_capability = mailto
 managesieve_sieve_capability = fileinto reject envelope
 encoded-character vacation subaddress comparator-i;ascii-numeric
 relational regex imap4flags copy include variables body enotify
 environment mailbox date
 mbox_write_locks = fcntl
 namespace {
   inbox = yes
   location =
   prefix =
   separator = /
   type = private
 }
 namespace {
   list = children
   location = maildir:%%h/Maildir:INDEX=~/Maildir/shared/%%u
   prefix = shared/%%u/
   separator = /
   subscriptions = no
   type = shared
 }
 passdb {
   args = /etc/dovecot/dovecot-sql.conf.ext
   driver = sql
 }
 plugin {
   acl = vfile
   acl_shared_dict = file:/home/vmail/shared-mailboxes
   quota = dict:user::proxy::quotadict
   sieve = ~/.dovecot.sieve
   sieve_dir = ~/sieve
   sieve_global_dir = /var/lib/dovecot/sieve/
   sieve_global_path = /var/lib/dovecot/sieve/default.sieve
   sieve_max_script_size = 1M
   trash = /etc/dovecot/trash.conf
 }
 protocols = imap lmtp sieve
 service auth {
   unix_listener /var/spool/postfix/private/auth {
 mode = 0666
   }
   unix_listener auth-userdb {
 group = mail
 mode = 0600
 user = vmail
   }
 }
 service dict {
   unix_listener dict {
 group = mail
 mode = 0600
 user = vmail
   }
 }
 service imap-login {
   inet_listener imap {
 port = 143
   }
   inet_listener imaps {
 port = 993
 ssl = yes
   }
 }
 service imap {
   vsz_limit = 256 M
 }
 service managesieve-login {
   inet_listener sieve {
 port = 4190
   }
   process_min_avail = 0
   service_count = 1
   vsz_limit = 64 M
 }
 service pop3-login {
   inet_listener pop3 {
 port = 110
   }
   inet_listener pop3s {
 port = 995
 ssl = yes
   }
 }
 ssl_cert = /etc/pki/dovecot/certs/dovecot.pem
 ssl_key = /etc/pki/dovecot/private/dovecot.pem
 userdb {
   args = /etc/dovecot/dovecot-sql.conf.ext
   driver = sql
 }
 protocol lmtp {
   mail_plugins = quota trash
 }
 protocol lda {
   mail_plugins = sieve acl
 }
 protocol imap {
   imap_client_workarounds = delay-newmail
   mail_plugins = quota trash acl imap_acl
 }
 protocol sieve {
   managesieve_implementation_string = Dovecot Pigeonhole
   managesieve_max_compile_errors = 5
   managesieve_max_line_length = 65536
 }
 protocol pop3 {
   mail_plugins = quota trash
   pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
 }



 Thank you !
 Frank
 --
 users@sogo.nu
 https://inverse.ca/sogo/lists

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Base64 encoded zip file trouble

2015-06-30 Thread Christian M. Jensen

Hi all

i have a tiny problem, not sure if it's a bug or an just me.

when i receive and base64 encoded zip file i'm not able to download it 
from within SOGo WebUI, Thunderbird and outlook works as expected.

in this sample it's a DMARC report from google

here is the email

domain and email address are replaces with 'xx'
Download link shows as: https :/ / 
xx.xxx/SOGo/so/x...@xx.com/Mail/0/folderAdmins/folderdmarc/folderdk/folderxx/7/0




Return-Path: noreply-dmarc-supp...@google.com
Delivered-To: i...@xx.com
Received: from localhost (localhost.localdomain [127.0.0.1])
by xx.xx.com (Postfix) with ESMTP id 6774A15C0093
for dm...@xx.dk; Tue, 30 Jun 2015 10:55:14 +0200 (CEST)
X-Virus-Scanned: Debian amavisd-new at xx.xx.com
Authentication-Results: xx.xx.com (amavisd-new);
dkim=pass (2048-bit key) header.d=google.com
Received: from xx.xx.com ([127.0.0.1])
by localhost (xx.xx.com [127.0.0.1]) (amavisd-new, port 10024)
with ESMTP id 8D8AyTfq9zvZ for dm...@xx.dk;
Tue, 30 Jun 2015 10:55:13 +0200 (CEST)
Received-SPF: Pass (sender SPF authorized) identity=mailfrom; 
client-ip=2607:f8b0:4001:c05::24a; helo=mail-ig0-x24a.google.com; 
envelope-from=noreply-dmarc-supp...@google.com; receiver=dm...@xx.dk
Received: from mail-ig0-x24a.google.com (mail-ig0-x24a.google.com 
[IPv6:2607:f8b0:4001:c05::24a])

by xx.xx.com (Postfix) with ESMTPS id 9530B15C0091
for dm...@xx.dk; Tue, 30 Jun 2015 10:55:13 +0200 (CEST)
Received: by igdj8 with SMTP id j8so860472igd.0
for dm...@xx.dk; Tue, 30 Jun 2015 01:55:12 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=google.com; s=20120113;
h=mime-version:message-id:date:subject:from:to:content-type
 :content-disposition:content-transfer-encoding;
bh=gIzqeQNcg+/Y5ecop48/D4gcfLY0AWesk/jie07/kr8=;
b=nBgS98ZqztfnZR2gZiDpBqmjIFZVDyM7m3ZRCO27DiPOb0+MaRsqcz0rGA5hF54tkJ
VLsZmW0aGuzORsPFHp747QfIDjZvZ4uHq72oORy26KpWri4y41bImIIbZGRqIMsaNwmf
2x5gan7i9zZmZ4JkS4mXIK8j6qhMrEe42JMU8RHqQNIrZuTwU1wuy36FijSbk0xUJpUw
xMDiehnADEZl1GZHhpyFcsyhZymx8HuLgxqHCzrRCsjZl7pzTR/djwjiD/Bubx0MsyAN
ZIyUpnYUhsq756lCt4YSWB563PtUwH3/Lbs7syAtlSWQ5cOQNV7LQ7CW+I1wNCfhHEb6
 fCxA==
MIME-Version: 1.0
X-Received: by 10.50.103.39 with SMTP id ft7mr22315719igb.5.1435654512270;
 Tue, 30 Jun 2015 01:55:12 -0700 (PDT)
Message-ID: 9649290118032887...@google.com
Date: Tue, 30 Jun 2015 08:55:12 +
Subject: Report domain: xx.dk Submitter: google.com Report-ID: 
9649290118032887915

From: noreply-dmarc-supp...@google.com
To: dm...@xx.dk
Content-Type: application/zip;
name=google.com!xx.dk!1435536000!1435622399.zip
Content-Disposition: attachment;
filename=google.com!xx.dk!1435536000!1435622399.zip
Content-Transfer-Encoding: base64

UEsDBAoIAK9E3kawwSFb9AEAAMAGAAAyZ29vZ2xlLmNvbSFtYWotZGVzaWduLmRrITE0
MzU1MzYwMDAhMTQzNTYyMjM5OS54bWztVcuSmzAQvO9XUL4b8bBZcGm1OeULkjMlSwNWDJJKEvv4
+wgjHvFuVXLILTm4ED0zPdOtoYyf3/ouegFjhZJPuzROdhFIpriQ7dPu+7ev+3IXPZMH3ADwM2VX
8hBF2IBWxtU9OMqpoyPmUWXaWtIeSKtU20HMVI/RAk450FPREak8Q/e+5z01bG8HPdJ92ZZNeaHm
zRlaMyUdZa4WslHk4py2J4RCabyWIoqotK9gUHYoimOZeK6P9RNxkCE4qYpDlVVJmpZJnpXlY5Ue
MVrDU7qXCrWhsg1iPHSGVkiSHvLjMS+SxDebkDkOkt+iRZblVeVHkTMZ+pVt6bb1FGvVCfZe6+Hc
CXuBZRDl3ZGkpz/2HKxoZcyvnnBCpxTKr6InFqPpEECrmxs2PidI+7uQgJEO73YG7Ixo5kg6KhsP
t0k/m8p7yZSZBzTqdbHAqsEwqIUm5WNclXGWjr/Ud1gCcypTg/TNMJoOMxz6wQvtBm8anwOjE8Jq
ZYXzyxvm3iKbvNEETa0Xv/oRBDchsJiy0XjX09/SrAwLDtKJRvhPZym7AOVg6sao/v52tqHA9YEB
08FdagN26NxKejfw7y8/7PbIEqSFl0XdlhJvdP8l+nW90L2iMXlelD/ZmSxJ0tMh5cnJPyqen07/
N+df3xyM1j+jn1BLAQIKAAoIAK9E3kawwSFb9AEAAMAGAAAyAABn
b29nbGUuY29tIW1hai1kZXNpZ24uZGshMTQzNTUzNjAwMCExNDM1NjIyMzk5LnhtbFBLBQYA
AQABAGBEAgA=



and sorry for the image it was the best way to show that sogo recognizes 
the zip file but not i'm not able to downloaded it from the WebUI.


Regards
Christian Jensen



--
users@sogo.nu
https://inverse.ca/sogo/lists