Topic: zarafa on sme 9 - critical problem

[SchulzStefan]

Not quite sure... seems I'm OT? Should I raise a bug? Would like to know if activesync works on SME.

[guest22]

Right now we use zarafa. The phones are configured to connect to a M$ Exchange Server. Connected via z-push, that works perfect. The phones are configured with the email account of the user, the user, the password, the server and the domain. That's it. Maybe I'm wrong, but that's the way SOGo promises.

And that is how it works as of SoGO 2.2. If it doesn't on ALL phones, then something went wrong with the installation. So Let's start by telling us what exact steps you took and what versions you have installed for SoGO.

[SchulzStefan]

All right:

It's a SME 9.0 32bit, up-to-date, in a virtual machine. Installed contrib is zarafa. The server can be connected with a dyndns account.

I followed http://wiki.contribs.org/Sogo. For a clean connection with the SOGo activesync feature, I removed z-push and z-push-zarafa. The mobile is set up to connect to M$ exchange server. The logs in /var/log/sogo/sogo.log and /var/log/httpd/access_log are showing that the mobile is connecting. The sogo.log is showing some errors. In the sogo forums it's said, that these errors (mainly index-errors) are minor. The mobile gets nothing (contacts, email nor calendar) at all.

The same setup works (with the same mobile) with zarafa and z-push like a charm.

I can provide any kind of information if somebody wants to work on this.

[SchulzStefan]

More information:

Installieren:
 smeserver-sogo            noarch  9:1.3-15.el6.sme              stephdl   54 k
Installiert für Abhängigkeiten:
 dovecot-pigeonhole        i686    1:2.0.9-19.el6_7.2            updates  100 k
 gnustep-base              i686    1.23.0-1                      sogo     1.4 M
 gnustep-filesystem        noarch  2.6.2-1.el6                   epel     8.0 k
 gnustep-make              i686    2.6.2-1.el6                   epel     265 k
 lasso                     i686    2.4.0-6.el6                   base     174 k
 libmemcached              i686    0.49-1                        sogo     134 k
 libobjc                   i686    4.4.7-16.el6                  base      91 k
 libwbxml                  i686    0.11.2-4.centos6              sogo      86 k
 memcached                 i686    1.4.4-3.el6                   base      67 k
 python-memcached          noarch  1.43-6.el6                    base      32 k
 smeserver-dovecot-extras  noarch  0.1.1-1.el6.sme               stephdl  9.5 k
 sogo                      i686    2.3.2-1.centos6               sogo     3.1 M
 sogo-activesync           i686    2.3.2-1.centos6               sogo      75 k
 sogo-ealarms-notify       i686    2.3.2-1.centos6               sogo      10 k
 sogo-tool                 i686    2.3.2-1.centos6               sogo      39 k
 sope49-appserver          i686    4.9-20150916_1664.el6.1       sogo     692 k
 sope49-cards              i686    2.3.2-1.centos6               sogo     149 k
 sope49-core               i686    4.9-20150916_1664.el6.1       sogo     252 k
 sope49-gdl1               i686    4.9-20150916_1664.el6.1       sogo     125 k
 sope49-gdl1-contentstore  i686    2.3.2-1.centos6               sogo      45 k
 sope49-gdl1-mysql         i686    4.9-20150916_1664.el6.1       sogo      27 k
 sope49-ldap               i686    4.9-20150916_1664.el6.1       sogo      39 k
 sope49-mime               i686    4.9-20150916_1664.el6.1       sogo     219 k
 sope49-sbjson             i686    2.3.1-20150916_1664.el6.1     sogo      15 k
 sope49-xml                i686    4.9-20150916_1664.el6.1       sogo     162 k
 xmlsec1                   i686    1.2.20-4.el6                  base     162 k
 xmlsec1-openssl           i686    1.2.20-4.el6                  base      69 k

Vorgangsübersicht
================================================================================
Install      28 Package(s)

Gesamte Downloadgrösse: 7.5 M
Installed size: 32 M

In the server-manager sogo enabled also active sync enabled.

[SchulzStefan]

Removed zarafa completly. Maybe the zarafa activesync interferes with sogo.

Following the SOGo-Documentation:

# Enable to use Microsoft ActiveSync support
# Note that you MUST have many sogod workers to use ActiveSync.
# See the SOGo Installation and Configuration guide for more details.
#
#ProxyPass /Microsoft-Server-ActiveSync \
http://127.0.0.1:20000/SOGo/Microsoft-Server-ActiveSync retry=60 connectiontimeout=5 timeout=360

<Proxy http://127.0.0.1:20000/SOGo>
## adjust the following to your configuration
  RequestHeader set "x-webobjects-server-port" "443"
  RequestHeader set "x-webobjects-server-name" "yourhostname" <--- ? Don't know what to do with this
  RequestHeader set "x-webobjects-server-url" "https://yourhostname" <---?  Don't know what to do with this

Further I adjusted from https://www.foteviken.de/?p=2788

Did a sogo, memcached and httpd-e-smith restart. Here are the logs when connecting the mobile:

tail -f /var/log/sogo/sogo.log
Sep 27 13:50:23 sogod [2865]: [WARN] <0x0xb4cc773c[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
Sep 27 13:50:23 sogod [2865]: [WARN] <0x0xb4cc773c[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
Sep 27 13:50:23 sogod [2865]: [WARN] <0x0xb4cc773c[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
Sep 27 13:50:23 sogod [2863]: <0x0xb544a2a4[SOGoCache]> Cache cleanup interval set every 1800.000000 seconds
Sep 27 13:50:23 sogod [2863]: <0x0xb544a2a4[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
Sep 27 13:50:23 sogod [2865]: 192.168.10.163 "POST /SOGo/so/test/Calendar/alarmslist?browserTime=1443354623 HTTP/1.1" 200 2/0 0.187 - - 160K
Sep 27 13:50:23 sogod [2863]: 192.168.10.163 "POST /SOGo/so/test/Mail/0/mailboxes HTTP/1.1" 200 724/0 0.272 - - 0M
Sep 27 13:50:23 sogod [2865]: 192.168.10.163 "POST /SOGo/so/test/Mail/foldersState HTTP/1.1" 200 0/0 0.003 - - 0
Sep 27 13:50:23 sogod [2863]: 192.168.10.163 "POST /SOGo/so/test/Mail/0/folderINBOX/unseenCount HTTP/1.1" 200 13/0 0.274 - - 84K
Sep 27 13:50:27 sogod [2863]: 192.168.10.163 "GET /SOGo/ HTTP/1.1" 200 4058/0 0.134 12621 67% 2M
Sep 27 13:55:37 sogod [2863]: 82.113.123.4 "OPTIONS /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail HTTP/1.1" 401 0/0 0.002 - - 32K
Sep 27 13:55:37 sogod [2863]: 82.113.123.4 "OPTIONS /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail HTTP/1.1" 200 0/0 0.004 - - 28K
Sep 27 13:55:38 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Settings HTTP/1.1" 200 19/90 0.069 - - 220K
Sep 27 13:55:39 sogod [2863]: [WARN] <0x0xb4c5f73c[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
Sep 27 13:55:39 sogod [2863]: [WARN] <0x0xb4c5f73c[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
Sep 27 13:55:39 sogod [2863]: [WARN] <0x0xb4c5f73c[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
Sep 27 13:55:39 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=FolderSync HTTP/1.1" 200 900/13 0.492 - - 320K
Sep 27 13:55:41 sogod [2863]: <0x0xb4ddd444[SOGoActiveSyncDispatcher]> Change detected, we push the content.
Sep 27 13:55:41 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Sync HTTP/1.1" 200 73/58 0.297 - - 16K
Sep 27 13:55:43 sogod [2863]: <0x0xb4e30064[NGImap4Client]> Note: no key found for sorting, using 'DATE': (null)
Sep 27 13:55:43 sogod [2863]: <0x0xb56adf6c[SOGoActiveSyncDispatcher]> Change detected, we push the content.
Sep 27 13:55:43 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Sync HTTP/1.1" 200 4953/124 1.184 - - 204K
Sep 27 13:55:54 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=FolderSync HTTP/1.1" 200 57/45 0.309 - - 4K
Sep 27 14:00:23 sogod [2863]: 192.168.10.163 "POST /SOGo/so/test/Mail/0/folderINBOX/unseenCount HTTP/1.1" 200 4061/0 0.028 12624 67% 16K
Sep 27 14:00:23 sogod [2865]: 192.168.10.163 "POST /SOGo/so/test/Mail/0/folderINBOX/uids HTTP/1.1" 200 4061/92 0.057 12624 67% 36K
^C
# tail -f /var/log/sogo/sogo.log /var/log/httpd/access_log
==> /var/log/sogo/sogo.log <==
Sep 27 13:55:39 sogod [2863]: [WARN] <0x0xb4c5f73c[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
Sep 27 13:55:39 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=FolderSync HTTP/1.1" 200 900/13 0.492 - - 320K
Sep 27 13:55:41 sogod [2863]: <0x0xb4ddd444[SOGoActiveSyncDispatcher]> Change detected, we push the content.
Sep 27 13:55:41 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Sync HTTP/1.1" 200 73/58 0.297 - - 16K
Sep 27 13:55:43 sogod [2863]: <0x0xb4e30064[NGImap4Client]> Note: no key found for sorting, using 'DATE': (null)
Sep 27 13:55:43 sogod [2863]: <0x0xb56adf6c[SOGoActiveSyncDispatcher]> Change detected, we push the content.
Sep 27 13:55:43 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Sync HTTP/1.1" 200 4953/124 1.184 - - 204K
Sep 27 13:55:54 sogod [2863]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=FolderSync HTTP/1.1" 200 57/45 0.309 - - 4K

==> /var/log/httpd/access_log <==
home.dyndns.org 82.113.123.4 - - [27/Sep/2015:13:55:36 +0200] "OPTIONS /Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail HTTP/1.1" 401 - "-" "NokiaE700/1.00(0)ActiveSync 3gpp-gba"
home.dyndns.org 82.113.123.4 - - [27/Sep/2015:13:55:37 +0200] "OPTIONS /Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail HTTP/1.1" 200 - "-" "NokiaE700/1.00(0)ActiveSync 3gpp-gba"
home.dyndns.org 82.113.123.4 - - [27/Sep/2015:13:55:38 +0200] "POST /Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Settings HTTP/1.1" 200 19 "-" "NokiaE700/1.00(0)ActiveSync 3gpp-gba"
home.dyndns.org 82.113.123.4 - - [27/Sep/2015:13:55:38 +0200] "POST /Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=FolderSync HTTP/1.1" 200 900 "-" "NokiaE700/1.00(0)ActiveSync 3gpp-gba"
home.dyndns.org 82.113.123.4 - - [27/Sep/2015:13:55:41 +0200] "POST /Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Sync HTTP/1.1" 200 73 "-" "NokiaE700/1.00(0)ActiveSync 3gpp-gba"
home.dyndns.org 82.113.123.4 - - [27/Sep/2015:13:55:42 +0200] "POST /Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Sync HTTP/1.1" 200 4953 "-" "NokiaE700/1.00(0)ActiveSync 3gpp-gba"
home.dyndns.org 82.113.123.4 - - [27/Sep/2015:13:55:53 +0200] "POST /Microsoft-Server-ActiveSync?User=test&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=FolderSync HTTP/1.1" 200 57 "-" "NokiaE700/1.00(0)ActiveSync 3gpp-gba"

Seems the mobile is unauthorized, but why?

[guest22]

The SoGO wiki page is ALL you need. Manually changing config files is not the way forward for they will interfere with SME Server defaults. Please concentrate on the wiki page only, and not on any other bits and pieces on the net, even Sogo documentation for it is all automated by the contrib.


Please consider changing to SME Server 9.x 64-bit.


Start over clean perhaps?

[SchulzStefan]

I can try again with a clean installation.

In the wiki is nothing said about mobiles and active sync. Is it covered in the contrib or not? In the contrib the default is:

# Enable to use Microsoft ActiveSync support
# Note that you MUST have many sogod workers to use ActiveSync.
# See the SOGo Installation and Configuration guide for more details.
#
#ProxyPass /Microsoft-Server-ActiveSync \
#http://127.0.0.1:20000/SOGo/Microsoft-Server-ActiveSync retry=60 connectiontimeout=5 timeout=360

[guest22]

After installation, sogo is managed via server-manager. No manual edits of config files. Activesync can be enabled there.

[SchulzStefan]

After installation, sogo is managed via server-manager. Activesync can be enabled there.

I know.

No manual edits of config files.

Not quite sure about this.

I downloaded an actual ISO of SME 9.0 i386. Installed the server in a virtual machine. Did a yum update. Followed exactly the SOGo-Wiki. After all it's like I stated before. Contacts, calender and tasks are synced by activesync on the mobile. Emails are not beeing synced.

I'm able to sync with SOGo (or the server) by adding a new IMAP-account on the mobile. On the Nokia E7-00 with a build-in M$ Exchange-Server sync default, for me it's not possible to sync emails with the SOGo activesync. Interesting thing, Zarafa does it with z-push. With the same config on the mobile. I think, it's a SOGo bug.

I'll stop here. If someone wants to work further on this track, I'll provide any information I can give.

Migrating from zarafa to sogo with my mobile would be not as smooth as it's promised. ActiveSync working full properly would have been the goal.

[guest22]

I downloaded an actual ISO of SME 9.0 i386.

Why please? the advise was to use SME Server 64-bit.

Installed the server in a virtual machine. Did a yum update. Followed exactly the SOGo-Wiki. After all it's like I stated before. Contacts and calender are synced by activesync on the mobile. Emails are not beeing synced.

so it's partially working?

I'm able to sync with SOGo (or the server) by adding a new IMAP-account on the mobile. On the Nokia E7-00 with a build-in M$ Exchange-Server sync default, for me it's not possible to sync emails with the SOGo activesync. Interesting thing, Zarafa does it with z-push. With the same config on the mobile. I think, it's a SOGo bug.

Activesync is always a MS Exchange account, not an imap account


Funny thing is that I have many production servers serving sogo and active sync to may different devices. Somehow it won;t work for you.

[Stefano]

activesync for contacts/calendars,

imap for email: https://www.youtube.com/watch?v=CgNeubkmn2U

[SchulzStefan]

Why please? the advise was to use SME Server 64-bit.

Only one processor free. Can't use the 64bit in this VM.

so it's partially working?

Yes.

Activesync is always a MS Exchange account, not an imap account

I know.

Funny thing is that I have many production servers serving sogo and active sync to may different devices.

You could check the httpd/access_logs for "NokiaE700/1.00(0)ActiveSync 3gpp-gba". It would be interesting if one of your users is syncing SOGo with this type of a mobile device.

[SchulzStefan]

activesync for contacts/calendars,

imap for email: https://www.youtube.com/watch?v=CgNeubkmn2U

No, there's no problem to use activesync with an E7-00 for just syncing everything in zarafa. Emails, calendar, contacts and tasks. No need to set up a second imap account on the mobile. The exchange account is good enough and works perfect for everything. Since years. Years back that was one of the reasons for me to choose zarafa...

[SchulzStefan]

Did a test and installed z-push. It seems to be hard to configure z-push to work proper with SOGo. https://github.com/fmbiete/Z-Push-contrib/wiki/Example-Configuration

So, what I wanted to test is the ability to sync emails, while the phone is set up with an M$ exchange account. That works without any problem. Of course, I modified the httpd.conf for the test.

In the end it seems to me, that the activesync feature of SOGo has a bug. Should I open one?

[stephdl]

I don't use activesync with my cellphone but if you think you have something wrong with sogo, please fill a bug and bring all needed informations. It is possible that the bug comes from sogo (I don't have a hand on it) and not from smeserver-sogo which is just the integration of sogo in smeserver.