Koozali.org: home of the SME Server
Obsolete Releases => SME 9.x Contribs => Topic started by: pelli on September 19, 2015, 03:04:41 PM
-
Hello, i have found a critical problem in sme with zarafa and fetchmail. If the zarafa-server is down (example db reconstruction) qmail process the email and after delete it
example /var/log/qmail/current
4000000055fd5978289bc274 delivery 16866: success: [32752]_Unable_to_connect_to_zarafa_server_for_user_test,_using_socket:_'file:///var/run/zarafa'/did_0+0+2/
this is a big problem because i lost all email when zarafa-server is down.
Have any suggestion?
Thanks
-
No immediate help, but please consider to change to SoGO.
I don't get the fetchmail part?
-
moving to SME 9.x Contribs as requested
-
What do you have in /home/e-smith/files/users/test/.qmail ?
-
No immediate help, but please consider to change to SoGO.
Any idea how to migrate?
stefan
-
you can use imapsync to pull emails from your zarafa's imap accounts and push them into your "normal" imap mailboxes, even on the same server..
-
stefano,
thank you for your hint.
Emails is the one thing, but what about tasks and dates? Anyway there are a few reasons to move away from zarafa... I'll give it a try and will report. Will take a while, I'm too busy right now.
stefan
-
https://github.com/zarafagroupware/zarafa-tools/blob/master/contacts/csv2contacts/process-contacts.php
search with google, I'm not an expert..
-
Got this already, thank you very much. I played a little around to migrate the whole zarafa-stuff to sogo and I think, I found a way. I'll write a how-to when I migrate. Maybe some other people are also interested.
stefan
-
Got this already, thank you very much. I played a little around to migrate the whole zarafa-stuff to sogo and I think, I found a way. I'll write a how-to when I migrate. Maybe some other people are also interested.
stefan
it would be great, thank you in advance
-
I gave up. No luck at all syncing emails with my mobile phone. It's a nokia e7-00. Actually it should be synced out-of-the-box with M$ activesync. In fact, the phone connects, but no emails are shown in the inbox. And yes, I added a group, gave the user a new password and added the user to the group. Didn't help. Unfortunately tail -f sogo.log, httpd/access_log, messages isn't showing errors. Contacts and calender have been synced (a few minor issues), but no emails at all. That's useless for me. Tried funambol, z-push for sogo, got stuck. I'd like to migrate from zarafa to sogo, but without getting emails on our mobiles, it's making no sense. I read in the sogo-forums it could depend on the phone. Well, it's a symbian-OS - this might be the reason. With z-push an zarafa it's syncing perfect. I'm sorry I can't help out.
stefan
-
sincerely I don't understand "syncing emails".. just setup as imap and you're done.. I hope your phone is imap(s) capable
-
That's what I tried. It's not syncing with the buildin addon of sogo.
As far as I see, one can try with the original z-push backends (http://z-push.org/download/), in this case with the imap backend, or one could try this one: https://github.com/fmbiete/Z-Push-contrib. In both cases the config.php of the imap-backend has to be configured:
1.) original one (from z-push.org)
<?php
/***********************************************
* File : config.php
* Project : Z-Push
* Descr : IMAP backend configuration file
*
* Created : 27.11.2012
*
* Copyright 2007 - 2013 Zarafa Deutschland GmbH
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License, version 3,
* as published by the Free Software Foundation with the following additional
* term according to sec. 7:
*
* According to sec. 7 of the GNU Affero General Public License, version 3,
* the terms of the AGPL are supplemented with the following terms:
*
* "Zarafa" is a registered trademark of Zarafa B.V.
* "Z-Push" is a registered trademark of Zarafa Deutschland GmbH
* The licensing of the Program under the AGPL does not imply a trademark license.
* Therefore any rights, title and interest in our trademarks remain entirely with us.
*
* However, if you propagate an unmodified version of the Program you are
* allowed to use the term "Z-Push" to indicate that you distribute the Program.
* Furthermore you may use our trademarks where it is necessary to indicate
* the intended purpose of a product or service provided you use it in accordance
* with honest practices in industrial or commercial matters.
* If you want to propagate modified versions of the Program under the name "Z-Push",
* you may only do so if you have a written permission by Zarafa Deutschland GmbH
* (to acquire a permission please contact Zarafa at trademark@zarafa.com).
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
* Consult LICENSE file for details
************************************************/
// ************************
// BackendIMAP settings
// ************************
// Defines the server to which we want to connect
define('IMAP_SERVER', 'localhost');
// connecting to default port (143)
define('IMAP_PORT', 143);
// best cross-platform compatibility (see http://php.net/imap_open for options)
define('IMAP_OPTIONS', '/notls/norsh');
// overwrite the "from" header if it isn't set when sending emails
// options: 'username' - the username will be set (usefull if your login is equal to your emailaddress)
// 'domain' - the value of the "domain" field is used
// '@mydomain.com' - the username is used and the given string will be appended
define('IMAP_DEFAULTFROM', '');
// copy outgoing mail to this folder. If not set z-push will try the default folders
define('IMAP_SENTFOLDER', '');
// forward messages inline (default false - as attachment)
define('IMAP_INLINE_FORWARD', false);
// use imap_mail() to send emails (default) - if false mail() is used
define('IMAP_USE_IMAPMAIL', true);
/* BEGIN fmbiete's contribution r1527, ZP-319 */
// list of folders we want to exclude from sync. Names, or part of it, separated by |
// example: dovecot.sieve|archive|spam
define('IMAP_EXCLUDED_FOLDERS', '');
/* END fmbiete's contribution r1527, ZP-319 */
?>
the other one looks like this:
?php
/***********************************************
* File : config.php
* Project : Z-Push
* Descr : IMAP backend configuration file
*
* Created : 27.11.2012
*
* Copyright 2007 - 2013 Zarafa Deutschland GmbH
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License, version 3,
* as published by the Free Software Foundation with the following additional
* term according to sec. 7:
*
* According to sec. 7 of the GNU Affero General Public License, version 3,
* the terms of the AGPL are supplemented with the following terms:
*
* "Zarafa" is a registered trademark of Zarafa B.V.
* "Z-Push" is a registered trademark of Zarafa Deutschland GmbH
* The licensing of the Program under the AGPL does not imply a trademark license.
* Therefore any rights, title and interest in our trademarks remain entirely with us.
*
* However, if you propagate an unmodified version of the Program you are
* allowed to use the term "Z-Push" to indicate that you distribute the Program.
* Furthermore you may use our trademarks where it is necessary to indicate
* the intended purpose of a product or service provided you use it in accordance
* with honest practices in industrial or commercial matters.
* If you want to propagate modified versions of the Program under the name "Z-Push",
* you may only do so if you have a written permission by Zarafa Deutschland GmbH
* (to acquire a permission please contact Zarafa at trademark@zarafa.com).
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
* Consult LICENSE file for details
************************************************/
// ************************
// BackendIMAP settings
// ************************
// Defines the server to which we want to connect
define('IMAP_SERVER', 'localhost');
// connecting to default port (143)
define('IMAP_PORT', 143);
// best cross-platform compatibility (see http://php.net/imap_open for options)
define('IMAP_OPTIONS', '/notls/norsh');
// Mark messages as read when moving to Trash.
// BE AWARE that you will lose the unread flag, but some mail clients do this so the Trash folder doesn't get boldened
define('IMAP_AUTOSEEN_ON_DELETE', false);
// IMPORTANT: BASIC IMAP FOLDERS [ask your mail admin]
// We can have diferent cases (case insensitive):
// 1.
// inbox
// sent
// drafts
// trash
// 2.
// inbox
// common.sent
// common.drafts
// common.trash
// 3.
// common.inbox
// common.sent
// common.drafts
// common.trash
// 4.
// common
// common.sent
// common.drafts
// common.trash
//
// gmail is a special case, where the default folders are under the [gmail] prefix and the folders defined by the user are under INBOX.
// This configuration seems to work:
// define('IMAP_FOLDER_PREFIX', '');
// define('IMAP_FOLDER_INBOX', 'INBOX');
// define('IMAP_FOLDER_SENT', '[Gmail]/Sent');
// define('IMAP_FOLDER_DRAFTS', '[Gmail]/Drafts');
// define('IMAP_FOLDER_TRASH', '[Gmail]/Trash');
// define('IMAP_FOLDER_SPAM', '[Gmail]/Spam');
// define('IMAP_FOLDER_ARCHIVE', '[Gmail]/All Mail');
// Since I know you won't configure this, I will raise an error unless you do.
// When configured set this to true to remove the error
define('IMAP_FOLDER_CONFIGURED', false);
// Folder prefix is the common part in your names (3, 4)
define('IMAP_FOLDER_PREFIX', '');
// Inbox will have the preffix preppend (3 & 4 to true)
define('IMAP_FOLDER_PREFIX_IN_INBOX', false);
// Inbox folder name (case doesn't matter) - (empty in 4)
define('IMAP_FOLDER_INBOX', 'INBOX');
// Sent folder name (case doesn't matter)
define('IMAP_FOLDER_SENT', 'SENT');
// Draft folder name (case doesn't matter)
define('IMAP_FOLDER_DRAFT', 'DRAFTS');
// Trash folder name (case doesn't matter)
define('IMAP_FOLDER_TRASH', 'TRASH');
// Spam folder name (case doesn't matter). Only showed as special by iOS devices
define('IMAP_FOLDER_SPAM', 'SPAM');
// Archive folder name (case doesn't matter). Only showed as special by iOS devices
define('IMAP_FOLDER_ARCHIVE', 'ARCHIVE');
// forward messages inline (default true - inlined)
define('IMAP_INLINE_FORWARD', true);
// list of folders we want to exclude from sync. Names, or part of it, separated by |
// example: dovecot.sieve|archive|spam
define('IMAP_EXCLUDED_FOLDERS', '');
// overwrite the "from" header with some value
// options:
// '' - do nothing, use the From header
// 'username' - the username will be set (usefull if your login is equal to your emailaddress)
// 'domain' - the value of the "domain" field is used
// 'sql' - the username will be the result of a sql query. REMEMBER TO INSTALL PHP-PDO AND PHP-DATABASE
// 'ldap' - the username will be the result of a ldap query. REMEMBER TO INSTALL PHP-LDAP!!
// '@mydomain.com' - the username is used and the given string will be appended
define('IMAP_DEFAULTFROM', '');
// DSN: formatted PDO connection string
// mysql:host=xxx;port=xxx;dbname=xxx
// USER: username to DB
// PASSWORD: password to DB
// OPTIONS: array with options needed
// QUERY: query to execute
// FIELDS: columns in the query
// FROM: string that will be the from, replacing the column names with the values
define('IMAP_FROM_SQL_DSN', '');
define('IMAP_FROM_SQL_USER', '');
define('IMAP_FROM_SQL_PASSWORD', '');
define('IMAP_FROM_SQL_OPTIONS', serialize(array(PDO::ATTR_PERSISTENT => true)));
define('IMAP_FROM_SQL_QUERY', "select first_name, last_name, mail_address from users where mail_address = '#username@#domain'");
define('IMAP_FROM_SQL_FIELDS', serialize(array('first_name', 'last_name', 'mail_address')));
define('IMAP_FROM_SQL_FROM', '#first_name #last_name <#mail_address>');
define('IMAP_FROM_SQL_FULLNAME', '#first_name #last_name');
// SERVER: ldap server
// SERVER_PORT: ldap port
// USER: dn to use for connecting
// PASSWORD: password
// QUERY: query to execute
// FIELDS: columns in the query
// FROM: string that will be the from, replacing the field names with the values
define('IMAP_FROM_LDAP_SERVER', 'localhost');
define('IMAP_FROM_LDAP_SERVER_PORT', '389');
define('IMAP_FROM_LDAP_USER', 'cn=zpush,ou=servers,dc=zpush,dc=org');
define('IMAP_FROM_LDAP_PASSWORD', 'password');
define('IMAP_FROM_LDAP_BASE', 'dc=zpush,dc=org');
define('IMAP_FROM_LDAP_QUERY', '(mail=#username@#domain)');
define('IMAP_FROM_LDAP_FIELDS', serialize(array('givenname', 'sn', 'mail')));
define('IMAP_FROM_LDAP_FROM', '#givenname #sn <#mail>');
define('IMAP_FROM_LDAP_FULLNAME', '#givenname #sn');
// Method used for sending mail
// mail => mail() php function
// sendmail => sendmail executable
// smtp => direct connection against SMTP
define('IMAP_SMTP_METHOD', 'mail');
global $imap_smtp_params;
// SMTP Parameters
// mail : no params
$imap_smtp_params = array();
// sendmail
//$imap_smtp_params = array('sendmail_path' => '/usr/bin/sendmail', 'sendmail_args' => '-i');
// smtp
// "host" - The server to connect. Default is localhost.
// "port" - The port to connect. Default is 25.
// "auth" - Whether or not to use SMTP authentication. Default is FALSE.
// "username" - The username to use for SMTP authentication. "imap_username" for using the same username as the imap server
// "password" - The password to use for SMTP authentication. "imap_password" for using the same password as the imap server
// "localhost" - The value to give when sending EHLO or HELO. Default is localhost
// "timeout" - The SMTP connection timeout. Default is NULL (no timeout).
// "verp" - Whether to use VERP or not. Default is FALSE.
// "debug" - Whether to enable SMTP debug mode or not. Default is FALSE.
// "persist" - Indicates whether or not the SMTP connection should persist over multiple calls to the send() method.
// "pipelining" - Indicates whether or not the SMTP commands pipelining should be used.
// "verify_peer" - Require verification of SSL certificate used. Default is TRUE.
// "verify_peer_name" - Require verification of peer name. Default is TRUE.
// "allow_self_signed" - Allow self-signed certificates. Requires verify_peer. Default is FALSE.
//$imap_smtp_params = array('host' => 'localhost', 'port' => 25, 'auth' => false);
// If you want to use SSL with port 25 or port 465 you must preppend "ssl://" before the hostname or IP of your SMTP server
// IMPORTANT: To use SSL you must use PHP 5.1 or later, install openssl libs and use ssl:// within the host variable
// IMPORTANT: To use SSL with PHP 5.6 you should set verify_peer, verify_peer_name and allow_self_signed
//$imap_smtp_params = array('host' => 'ssl://localhost', 'port' => 465, 'auth' => true, 'username' => 'imap_username', 'password' => 'imap_password');
// If you are using IMAP_SMTP_METHOD = mail or sendmail and your sent messages are not correctly displayed you can change this to "\n".
// BUT, it doesn't comply with RFC 2822 and will break if using smtp method
define('MAIL_MIMEPART_CRLF', "\r\n");
// A file containing file mime types->extension mappings.
// SELINUX users: make sure the file has a security context accesible by your apache/php-fpm process
define('SYSTEM_MIME_TYPES_MAPPING', '/etc/mime.types');
// Use BackendCalDAV for Meetings. You cannot hope to get that functionality working without a caldav backend.
define('IMAP_MEETING_USE_CALDAV', false);
And as pre-requisite is libawl-php required. No idea where to get this...
Anyway - the mailbox on the phone is defined as M$ Active-Exchange, in the logs I see the connect, but it isn't syncing. Maybe I have to modify the paths to the imap folders. The port should also be 993 on SME...
-
sogo has nothing to do with imap, meaning that it uses Mailboxex, but it has not its own imap daemon..
regarding emails, you just need to configure your phone email client to work with an imap account.. you'd do it with or without zarafa or sogo..
in other words, sogo is not involved in any way in email syncing with your phone.. it is needed just to sync contacts and calendars.
can you share here a link to your phone model? I saw something here some time ago regarding problems with a nokia phone (is it still a nokia one or a M$ one?)
-
Here's the link: http://nds1.nokia.com/phones/files/guides/Nokia_E7-00_UG_en.pdf It's a Nokia - OS Symbian (I'm some kind of old fashioned...)
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.
In my understanding the clue should be to set up an email account with active-sync on the mobile. That's it. In this case you don't have to configure imap or what ever...
-
Not quite sure... seems I'm OT? Should I raise a bug? Would like to know if activesync works on SME.
-
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.
-
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.
-
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.
-
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?
-
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?
-
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
-
After installation, sogo is managed via server-manager. No manual edits of config files. Activesync can be enabled there.
-
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.
-
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.
-
activesync for contacts/calendars,
imap for email: https://www.youtube.com/watch?v=CgNeubkmn2U
-
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.
-
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...
-
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 (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?
-
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.
-
take a look here..
http://wiki.sogo.nu/ExchangeActiveSync
and try to search funambol here..
IIRC an user (nicolatiana) did something
-
Actually the support for ActiveSync has been integrated starting from 2.1 or 2.2 release.
-
Actually the support for ActiveSync has been integrated starting from 2.1 or 2.2 release.
Hence my very first reply.
-
Posted by: Stefano
« on: Yesterday at 08:35:14 PM »
take a look here..
http://wiki.sogo.nu/ExchangeActiveSync
and try to search funambol here..
IIRC an user (nicolatiana) did something
I did.
The "official" project mit best ActiveSync support can be found https://github.com/xbgmsharp/sogosync (https://github.com/xbgmsharp/sogosync) here.
Dead end...
I tried to install funambol. There's a wiki for SME. I gave up.
Remember, I have a running system with zarafa. (30 years ago, it was a bonmot "never touch a running system". Still good for today.). There's no pressure for me to migrate to SOGo. I'd like to - but I'll wait til activesync is working proper. Or if migrating to SOGo - I'll set up two mailboxes. Activesync (SOGo-Build-In) for calendar, contacts and tasks, and a second one as imap for emails. It's a workaround, not quite elegant, but one could do it in this way.
Posted by: stephdl
« on: Yesterday at 08:34:17 PM »
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.
If I find some time I'll install sogo on zentyal (or another server). We'll see if activesync works properly with a nokia E7-00. If not, no need to raise a bug for the contrib. In this case the right place would be the SOGo-forum.
-
As promised:
Zentyal 4.1 (i386) installed in virtualbox. Server is running and up. Installed and configured all stuff needed to test SOGo with sogo-activesync.
Here are the logs:
syslog:
Oct 1 21:47:01 mond dovecot: imap-login: Login: user=<testerle@home.dyndns.org>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, mpid=4475, secured, session=<HBqKTxAh2AB/AAAB>
sogo.log:
Oct 01 21:44:06 sogod [3246]: <0x0xb79f19b4[SOGoProductLoader]> MailerUI.SOGo, ContactsUI.SOGo, AdministrationUI.SOGo, Mailer.SOGo, Appointments.SOGo, PreferencesUI.SOGo, ActiveSync.SOGo, MainUI.SOGo, Contacts
.SOGo, CommonUI.SOGo, SchedulerUI.SOGo, MailPartViewers.SOGo
Oct 01 21:49:18 sogod [3253]: 82.113.123.4 "OPTIONS /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail HTTP/1.1" 401 0/0 0.005 - - 4K
Oct 01 21:49:19 sogod [3253]: 82.113.123.4 "OPTIONS /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail HTTP/1.1" 200 0/0 0.004 - - 0
Oct 01 21:49:20 sogod [3253]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Settings HTTP/1.1" 200 19/90 0.012 - - 252K
Oct 01 21:49:21 sogod [3253]: [WARN] <0x0xb7cdfdec[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
Oct 01 21:49:21 sogod [3253]: [WARN] <0x0xb7cdfdec[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
Oct 01 21:49:21 sogod [3253]: [WARN] <0x0xb7cdfdec[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
Oct 01 21:49:21 sogod [3253]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=FolderSync HTTP/1.1" 200 541/13 0.591 - - 712K
Oct 01 21:49:23 sogod [3253]: <0x0xb7d1836c[SOGoActiveSyncDispatcher]> Change detected, we push the content.
Oct 01 21:49:23 sogod [3253]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Sync HTTP/1.1" 200 73/58 0.190 - - 0
Oct 01 21:49:24 sogod [3253]: <0x0xb79368bc[NGImap4Client]> Note: no key found for sorting, using 'DATE': (null)
Oct 01 21:49:24 sogod [3253]: <0x0xb7d1a2a4[SOGoActiveSyncDispatcher]> Change detected, we push the content.
Oct 01 21:49:24 sogod [3253]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Sync HTTP/1.1" 200 1174/124 0.703 - - 104K
Oct 01 21:49:33 sogod [3253]: 82.113.123.4 "OPTIONS /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail HTTP/1.1" 200 0/0 0.002 - - 0
Oct 01 21:49:34 sogod [3253]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=Settings HTTP/1.1" 200 19/90 0.033 - - 0
Oct 01 21:49:35 sogod [3253]: 82.113.123.4 "POST /SOGo/Microsoft-Server-ActiveSync?User=testerle&DeviceId=IMEI357909041390858&DeviceType=NokiaEmail&Cmd=FolderSync HTTP/1.1" 200 57/45 0.232 - - 28K
From SOGo-Forums:
https://lists.inverse.ca/sogo/arc/users/2015-01/msg00256.html (https://lists.inverse.ca/sogo/arc/users/2015-01/msg00256.html)
https://lists.inverse.ca/sogo/arc/users/2015-01/msg00319.html (https://lists.inverse.ca/sogo/arc/users/2015-01/msg00319.html)
Googling a while brings another few Nokia mobiles which don't sync with sogo-activesync. I didn't google for other mobiles. As all those Nokia phones with an implemented function to connect a M$ exchange server do work with a native (original) M$ exchange server, and besides as I reported also with z-push emulating the exchange server, it must be a bug in sogo-activesync. Not with a mixed or dual setup. They just need to be setuo with an exchange account. This one and only exchange account syncs all, means, email, calendar, contacts and tasks.
The challenge would be to finish, or adapt, this for SME: https://github.com/fmbiete/Z-Push-contrib/wiki/Example-Configuration (https://github.com/fmbiete/Z-Push-contrib/wiki/Example-Configuration)
I'm not going to open a bug. The SOGo people know about the problem until now, obviously no reaction.
@RequestedDeletion: In all your servers with SOGo installed and mobile syncing, did you grep in the logs "Nokia"? If so, what type of Nokia mobiles? And are they setup with exchange accounts? Just out of curiousity...