Re: [SOGo] Exchange 2003 -> Sogo

[Johannes Faber]

Hi,

"rough edges" is a real underestimating term ;)

Here is what came out after a long evaluation and polishing the rough edges.

What was positive:

- It is possible to share AD with a real Windows DC, as long it is 2008 
and Samba is a DC (making it everything a bit more complicated). Member 
server does not work.
- Autodiscover does work with Outlook and different DNs than the 
defaults for users, if you change the hard coded DNs in the python 
autodiscover scripts.

- Simple addressbook and calendar stuff for Outlook works.
- Out of office function for Outlook works (but only for external 
contacts, as there is no support in SOGo for internal contacts).


What was negative:

- Multiple personal addressbook in Outlook do not work properly.
- If automatic email completion does not work, start from scratch for 
the user.

- Outlook stops syncing out of nowhere.
- Outlook crashs for no apparent reason. If it crashs directly after 
launch, start from scratch for the user.

- Outlook in a non-english language seems even more unstable.
- Automatic Inbox notification does not work (even after self-compiling 
and installing the dovecot plugin. The documentation here is sparse).
- You are never sure, that everthing from Outlook is in sync with the 
server.
- Some Outlook problems where only solvable by clearing the SOGo cache 
or even worse by recreating the user on the server site. A new Outlook 
profile was in most cases not enough.

- Migration from existing user data triggered some obscure behaviour.
- SOGo develops the backend and Zentyl develops OpenChange.

So if you can go with Outlook 2013 and EAS. Avoid OpenChange or plan a 
long evaluation phase to catch all problems.


Regards,

Johannes

Am 11.03.16 um 13:08 schrieb Quique:

Hello Martin,

With OpenChange, you will have support from Outlook 2003 to Outlook
2010. There are users in production with OpenChange. There are rough
edges but for a normal usage it will work.

Best,

On 10 March 2016 at 18:20, Martin Simovic mailto:mar...@netson.sk>> wrote:

Hi Steve,

You are right - my suggestion does not involve openchange at all.
Openchange would be certainly better option, but do you know anyone
who has *working* openchange setup? In production?

Best Regards
Martin.


On 10 Mar 2016, at 17:08, Steve Ankeny mailto:stev...@cinergymetro.net>> wrote:

Martin . . .

Am I right in understanding your suggestion does not involve
OpenChange?  Would that limit a user to Outlook 2013?  It appears
to require a lot of resources to implement, and even then, there
appear to be limitations.

pg. 51-55, SOGo Installation and Configuration Guide

From my view, this is certainly preferable to using OpenChange

On 03/10/2016 10:44 AM, Martin Simovic wrote:

Hi,

I recommend you test your setup before the actual migration.
ActiveSync can be very resource demanding, especially with large
mailboxes. At the moment, every EAS connection requires a
separate sogod process, which in your case means you need 32+ GB
RAM - assuming your users use Outlook only (and not the phone,
etc.) Add one more device per user (e.g. Android phone) and
amount of required RAM duplicates.

Best Regards
Martin.


On 10 Mar 2016, at 15:36, EFEKT PAWKI
<pawec...@gmail.com
> wrote:

Hello.
I have to migrate from Exchange 2003 to something else.
My users will kill me if I force them to switch from MS Outlook
to something else.

How Sogo behave with account with a lot of data using Active
Sync protocol?
Especially owner of company - he have 5GB of OST and 45 in PST.

Calendar is full of meettings etc...
Will Sogo be able to work fluently with such amount of data?
There will be about 100 mailboxes.
Best regards. Pawel
--
users@sogo.nu 
https://inverse.ca/sogo/lists




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





--
Quique

Wikipedia: http://es.wikipedia.org/wiki/Usuario:Sixstone
Last.fm: http://www.last.fm/user/sixstone
--
users@sogo.nu
https://inverse.ca/sogo/lists

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

Re: [SOGo] Exchange 2003 -> Sogo

[Johannes Faber]

Am 11.03.16 um 15:08 schrieb Martin Simovic:

Hi,


On 11 Mar 2016, at 13:08, Quique mailto:quique...@gmail.com>> wrote:

Hello Martin,

With OpenChange, you will have support from Outlook 2003 to Outlook
2010. There are users in production with OpenChange. There are rough
edges but for a normal usage it will work.


Is automatic Inbox refresh triggered on new mail arrival working? Last
time I checked it wasn’t.


No. You need the dovecot plugin for this and it is not in the repository.

Regards,

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

Re: [SOGo] login problelms for one user - expire = -1 grace = -

[Johannes Faber]

Am 15.02.16 um 13:31 schrieb Götz Reinicke - IT Koordinator:

Hi,

we have one user who cant login to sogo anymore since friday  we did
not change anything to the servers (mail, web, DB, ...)

The message in the logfile is

SOGoRootPage successful login from 'xxx.xxx.xxx.xxx' for user 'xx' -
expire = -1  grace = -1


Any hints?


OK, looks like authentication works.

If you are sure authentication works like expected then this could be a 
messed up cache. Start from the browser cache down to the memcached cache.


Last resort is to drop the sogo_cache_folder_USERNAME table. It is 
recreated automatically on the next login of the user.


The last one fixed some really strange problems for me like a internal 
samba error that was triggered constantly by a user.


Regards,

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

Re: [SOGo] Has anyone had problems with Firefox 42.x and the SOGo interface?

[Johannes Faber]

Am 19.11.15 um 17:46 schrieb Steve Ankeny:

On 11/19/2015 10:58 AM, Johannes Faber wrote:


Am 19.11.15 um 16:16 schrieb Steve Ankeny:

I know that Firefox 42.x blocks Java, but there's a work around --

https://www.java.com/en/download/help/firefox_java.xml

However, I get the following error when I attempt to login to the SOGo
web interface --

2015-11-15 20:58:01.607 sogod[1829] ERROR(-[NSException(NGMiscellaneous)
initWithFormat:]): missing format!
Nov 15 20:58:01 sogod [1829]: <0x0x7f9f9166bf98[NGImap4Client]>
ERROR(-[NGImap4Client _processUnknownCommandParserException:]): catched
non-IMAP4 parsing exception NGSocketException:  NGActiveSocket is not
open
Nov 15 20:58:01 sogod [1829]: [ERROR]
<0x0x7f9f9138f368[NGImap4ConnectionManager]> IMAP4 login failed:

Before anyone thinks it's an IMAP error, IMAP works correctly in
Thunderbird 38.3.0 with SOGo Connector/Integrator 31.0.2 and Lightning
4.0.3.1, and it works correctly with 'telnet' commands.

Any suggestion beside "rolling back" to an earlier version of Firefox?


Hi Steve,

SOGo runs without problems on Firefox 42.0 here. And without Java.

Why do you think you need Java? SOGo web frontend is
HTML/CSS/JavaScript only.

Firefox does not connect directly to IMAP but connects thru Apache. It
looks like something mangels your login credentials on the way (virus
scanner, adblocker etc.) or the authenciation between Apache/SOGo/IMAP
is not configured right.

Enable debug logging on your IMAP server and look how SOGo tries to
authenticate.

Regards,

Johannes


debugging is enabled, and there are no IMAP errors (except in the SOGo log)


So your imap log says steve can just log in fine WITH SOGo?

If you have Dovecot set auth_verbose and auth_debug to yes.

Have you setup trust between SOGo and your IMAP server or how do you 
pass credentials to your IMAP server?



as for Java, it's required for "other" applications, and it's disabled
by default in Firefox

there is no virus scanner or adblocker on this interface

I've set both Java plugins to "Never activate" but the problem persists.


You don't need Java for SOGo. Only JavaScript. That are two different 
things, altought they sound alike.



thx for the quick reply

here are the errors that follow --

2015-11-19 11:30:12.169 sogod[10430]
ERROR(-[NSException(NGMiscellaneous) initWithFormat:]): missing format!
Nov 19 11:30:12 sogod [10430]: <0x0x7f8c3fa9ed58[NGImap4Client]>
ERROR(-[NGImap4Client _processUnknownCommandParserException:]): catched
non-IMAP4 parsing exception NGSocketException: NGActiveSocket is not open
Nov 19 11:30:12 sogod [10430]: [ERROR]
<0x0x7f8c3faad708[NGImap4ConnectionManager]> IMAP4 login failed:
   host=127.0.0.1, user=steve, pwd=yes
   url=imap://steve@127.0.0.1:443/INBOX/
   base=(null)
   base-class=(null))
   = <0x0x7f8c3fa9ed58[NGImap4Client]: login=steve(pwd)
socket=
address=<0x0x7f8c3f858288[NGInternetSocketAddress]:
host=localhost.smbdomain.com port=46129>>>
Nov 19 11:30:12 sogod [10430]: <0x3F8BB6F8[SOGoMailFolder]:folderINBOX>
renewing imap4 password
Nov 19 11:30:20 sogod [10416]: [WARN]
<0x0x7f8c3f4b6678[WOWatchDogChild]> pid 10430 has been hanging in the
same request for 1 minutes
2015-11-19 11:31:03.593 sogod[10430]
ERROR(-[NSException(NGMiscellaneous) initWithFormat:]): missing format!
Nov 19 11:31:03 sogod [10430]: <0x0x7f8c3fb23668[NGImap4Client]>
ERROR(-[NGImap4Client _processUnknownCommandParserException:]): catched
non-IMAP4 parsing exception NGSocketException: NGActiveSocket is not open
Nov 19 11:31:03 sogod [10430]: [ERROR]
<0x0x7f8c3faad708[NGImap4ConnectionManager]> IMAP4 login failed:

and, it repeats several more times


SOGo can't login with the user name steve. Why? Only your imap log can 
tell you the details.



as I said earlier, the IMAP mailing system is working fine with
Thunderbird (send/receive, etc.)


I guess nobody doubts that you have a working IMAP setup. But it looks 
like your authentication setup between Firefox/Apache/SOGo/IMAP does not 
work.



there is one other error in the SOGo log --

Nov 19 10:13:34 sogod [1866]: 192.168.121.179 "PROPFIND
/SOGo/dav/steve/Calendar/personal/ HTTP/1.1" 401 0/306 0.199 - - 3M
Nov 19 10:13:36 sogod [1866]: 192.168.121.179 "PROPFIND
/SOGo/dav/steve/Calendar/personal/ HTTP/1.1" 401 0/306 0.012 - - 0
Nov 19 10:13:40 sogod [1809]: [ERROR] <0x0x7fc6cc71a428[WOWatchDog]> No
child available to handle incoming request!
Nov 19 10:13:40 sogod [1867]: 192.168.121.179 "OPTIONS
/SOGo/dav/steve/Contacts HTTP/1.1" 401 0/0 0.025 - - 1M
Nov 19 10:13:40 sogod [1809]: [ERROR] <0x0x7fc6cc71a428[WOWatchDog]> No
child available to handle incoming request!
Nov 19 10:13:40 sogod [1867]: 192.168.121.179 "PROPFIND
/SOGo/dav/steve/Mail HTTP/1.1" 401 0/146 0.012 - - 64K
Nov 19 10:13:40 sogod [1809]: [ERROR] <0x0x7fc6cc71a428[WOWa

Re: [SOGo] Problems with Samba4

[Johannes Faber]

Am 18.11.15 um 14:21 schrieb Saul Bertuccio:

Hi,

excuse me for bad english.

I'm trying to setup Sogo, using our internal LDAP server and IMAP server
(on Zimbra).
LDAP and IMAP are on separate server.

I followed the guide in order to setup, first the Sogo Web interface and
then the Outlook Connector using samba4 and openchange.

The web interface works very well: mail and folder was correctly
displayed. But when i try to sync using Outlook 2013, Samba4 service crash.

Please find attached samba and sogo, and samba and sogo configurations
file.

Hardware:
WMWare VM with 4 CPU and 4 Gb Ram.

Software used:
 debian 8
 Sogo  version: 2.2.9+git20141017-1 (from debian-nightly repos)
 Samba 4.1.18-Debian

Before I used the debian-v3 repos, but upgraded to nightly version, to
try to solve the problem.


2.2.9 is rather old and probably just gives you headaches. I would 
suggest to use the latest version (2.3.3a) from the inverse.ca repos and 
start from scratch. Outlook support did improve and you maybe don't need 
an extra connector for it. Maybe.


Regards,

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

Re: [SOGo] Has anyone had problems with Firefox 42.x and the SOGo interface?

[Johannes Faber]

Am 19.11.15 um 16:16 schrieb Steve Ankeny:

I know that Firefox 42.x blocks Java, but there's a work around --

https://www.java.com/en/download/help/firefox_java.xml

However, I get the following error when I attempt to login to the SOGo
web interface --

2015-11-15 20:58:01.607 sogod[1829] ERROR(-[NSException(NGMiscellaneous)
initWithFormat:]): missing format!
Nov 15 20:58:01 sogod [1829]: <0x0x7f9f9166bf98[NGImap4Client]>
ERROR(-[NGImap4Client _processUnknownCommandParserException:]): catched
non-IMAP4 parsing exception NGSocketException:  NGActiveSocket is not open
Nov 15 20:58:01 sogod [1829]: [ERROR]
<0x0x7f9f9138f368[NGImap4ConnectionManager]> IMAP4 login failed:

Before anyone thinks it's an IMAP error, IMAP works correctly in
Thunderbird 38.3.0 with SOGo Connector/Integrator 31.0.2 and Lightning
4.0.3.1, and it works correctly with 'telnet' commands.

Any suggestion beside "rolling back" to an earlier version of Firefox?


Hi Steve,

SOGo runs without problems on Firefox 42.0 here. And without Java.

Why do you think you need Java? SOGo web frontend is HTML/CSS/JavaScript 
only.


Firefox does not connect directly to IMAP but connects thru Apache. It 
looks like something mangels your login credentials on the way (virus 
scanner, adblocker etc.) or the authenciation between Apache/SOGo/IMAP 
is not configured right.


Enable debug logging on your IMAP server and look how SOGo tries to 
authenticate.


Regards,

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

[SOGo] Fwd: WebApp Error: : 'NoneType' object has no attribute 'prefmap'

[Johannes Faber]

Hi,

does anybody know where this comes from and by which it is triggered? 
There were several today and some last week.


Regards,

Johannes


URL: http://example.com/ews/as
Module weberror.errormiddleware:*162* in |__call__|
<< <#> __traceback_supplement__ = Supplement, self, environ
sr_checker = ResponseStartChecker(start_response)
app_iter = self.application(environ, sr_checker)
return self.make_catching_iter(app_iter, environ, sr_checker)
except:
 >> <#>app_iter = self.application(environ, sr_checker)
Module beaker.middleware:*155* in |__call__|
<< <#> headers.append(('Set-cookie', cookie))
return start_response(status, headers, exc_info)
return self.wrap_app(environ, session_start_response)

def _get_session(self):
 >> <#>return self.wrap_app(environ, session_start_response)
Module routes.middleware:*131* in |__call__|
<< <#> r'\1', oldpath)

response = self.app(environ, start_response)

# Wrapped in try as in rare cases the attribute will be gone already
 >> <#>response = self.app(environ, start_response)
Module pylons.wsgiapp:*102* in |__call__|
<< <#> return ['%s' % paste.registry.restorer.get_request_id(environ)]

controller = self.resolve(environ, start_response)
response = self.dispatch(controller, environ, start_response)
 >> <#>controller = self.resolve(environ, start_response)
Module pylons.wsgiapp:*231* in |resolve|
<< <#> if self.log_debug:
log.debug("Resolved URL to controller: %r", controller)
return self.find_controller(controller)

def find_controller(self, controller):
 >> <#>return self.find_controller(controller)
Module pylons.wsgiapp:*269* in |find_controller|
<< <#> __traceback_hide__ = 'before_and_this'

__import__(full_module_name)
if hasattr(sys.modules[full_module_name], '__controller__'):
mycontroller = getattr(sys.modules[full_module_name],
 >> <#>__import__(full_module_name)
Module ?:*507* in ||
<< <#>EwsApp = Application([ExchangeService], EWS_M_NS,
name="ExchangeApplication",
interface=Wsdl11(), in_protocol=Soap11(), out_protocol=Soap11())

AsController = WsgiApplication(EwsApp)
 >> <#>interface=Wsdl11(), in_protocol=Soap11(), out_protocol=Soap11())
Module spyne.interface.wsdl.wsdl11:*149* in |__init__|
<< <#> def __init__(self, interface=None, _with_partnerlink=False):
super(Wsdl11, self).__init__(interface)

self._with_plink = _with_partnerlink
 >> <#>super(Wsdl11, self).__init__(interface)
Module spyne.interface.xml_schema._base:*111* in |__init__|
<< <#> self.validation_schema = None

pref = self.interface.prefmap[self.interface.app.tns]
self.namespaces = odict({pref: SchemaInfo()})
 >> <#>pref = self.interface.prefmap[self.interface.app.tns]
*AttributeError: 'NoneType' object has no attribute 'prefmap'*
CGI Variables
CONTENT_LENGTH  '1812'
CONTENT_TYPE'text/xml; charset=utf-8'
HTTP_AUTHORIZATION  'NTLM
TlRMTVNTUAADGAAYAIQAAABCAUIBnBIAEgBYBgAGAGoUABQAcADeAQAABYKIogYBsR0PZn/oy0AYNyNxlUk1mdGB1FMAVQBCAFQASQBMAFMAUQBMAGgAagBnAFMAVQBCAFQASQBMAC0ASABKAEcA3aulN7E4SgKyZfy6FNzAdwEBs/VUgXsb0QHDB6G4aePgoAACABIAUwBVAEIAVABJAEwAUwBRAEwAAQASAEcAUgBPAFUAUABXAEEAUgBFAAQAHgBzAHUAYgB0AGkAbABzAHEAbAAuAGwAbwBjAGEAbAADADIAZwByAG8AdQBwAHcAYQByAGUALgBzAHUAYgB0AGkAbABzAHEAbAAuAGwAbwBjAGEAbAAIADAAMAABACAAADG9+1pQdCGTzBVjXqKtN2E+z1dBGMHRSoaiN/qUDKcyCgAQAAKUOHdpZM21PX3k1UEGI0oJAD4ASABUAFQAUAAvAGcAcgBvAHUAcAB3AGEAcgBlAC4AcwB1AGIAdABpAGwALQBnAHIAbwB1AHAALgBjAG8AbQ=='
HTTP_CACHE_CONTROL  'no-cache'
HTTP_CONNECTION 'close'
HTTP_COOKIE 'OutlookSession="{7F703E5E-C3A1-4DFC-A41D-626FBDBF67C0}";
oc-ntlm-auth=222a00a1-8666-4f1b-b6b3-312d5f077cec'
HTTP_DEPTH  '0'
HTTP_HOST   'example.com'
HTTP_PRAGMA 'no-cache'
HTTP_USER_AGENT 'Microsoft Office/14.0 (Windows NT 6.1; Microsoft
Outlook 14.0.7159; Pro)'
HTTP_X_CLIENTSTATISTICS
'MessageId=urn:uuid:2CE9C6C9-AEA9-4F19-A920-58C921908D40,RequestTime=2015-11-10T05:49:00Z,ResponseTime=1373,ResponseSize=0,HttpResponseCode=500; 

MessageId=urn:uuid:2CE9C6C9-AEA9-4F19-A920-58C921908D40,RequestTime=2015-11-10T05:49:00Z,ResponseTime=1591,ResponseSize=0,HttpResponseCode=500; 


MessageId=urn:uuid:D79B26E8-CB82-47AE-ACC8-AD22C74D78C6,RequestTime=2015-11-10T05:49:00Z,ResponseTime=187,ResponseSize=0,HttpResponseCode=500,overflow=2'
HTTP_X_FORWARDED_FOR'80.146.216.52'
HTTP_X_FORWARDED_HOST   'example.com'
HTTP_X_FORWARDED_SERVER 'example.com'
HTTP_X_USER_IDENTITY't...@example.com'
NTLMAUTHHANDLER_WORKDIR '/var/cache/ntlmauthhandler'
PATH_INFO   '/ews/as'
REMOTE_ADDR '127.0.0.1'
REQUEST_METHOD  'POST'
SAMBA_HOST  '127.0.0.1'
SERVER_NAME '127.0.0.1'
SERVER_PORT '5000'
SERVER_PROTOCOL 'HTTP/1.1'

WSGI Variables
application 
beaker.get_session  >
beaker.session  {'_accessed_time': 1447134441.438011, '_creation_time':
1447134441.438011}
paste.httpserver.thread_pool
paste.registry  
paste.throw_errors  True
pylons.environ_config   {'session': 'beaker.session', 'cache':
'bea

Re: [SOGo] Zentyal packages in Sogo

[Johannes Faber]

Am 06.11.15 um 00:12 schrieb Ludovic Marcotte:

On 05/11/2015 17:58, Michel Memeteau - EKIMIA wrote:

hi ,

2015-11-05 13:51 GMT+01:00 Martin Simovic :

The difference is that Zentyal COMMERCIAL repository contains a
dependency package which is a dovecot-openchange module. This package
is responsible for notifying openchange about new email arrival and
thus triggering mailbox refresh in outlook.

dovecot-openchange package is not available from other source (SOGo,
Zentyal) only from Zentyal Commercial.


I'm confused, that would be the first time something goes in Zentyal
commercial before being in community , why would they do that ?

The code is available:

https://github.com/zentyal/openchange/tree/master/mapiproxy/services/plugins/dovecot


What's the trick here?

Compiling the plugin, enabling and configuring it in dovecot, enabling 
asyncemsmdb for the mapiproxy so emsmbd does not complain, all leads to 
"resolver: Not Found" for the plugin. Looking at memcached the 
neccessary key is never created.


So I guess this is not the only thing not packaged.

Regards,

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

Re: [SOGo] Zentyal packages in Sogo

[Johannes Faber]

Am 30.10.15 um 14:16 schrieb Martin Simovic:

Hi,



On 30 Oct 2015, at 12:46, Johannes Faber mailto:johan...@fundament.org>> wrote:

Hi there,

what kind of features do the Zentyal OpenChange packages in the Sogo
repository provide?

Do they provide the same features as the free version, where Zentyal
removed regular OpenChange features?


Not sure what you mean here. Free version of what? Openchange packages
are currently built by Zentyal regardless of repository you pull them
off (SOGo, Zentyal).

What features you thing Zentyal removed from Openchange?! Are you
referring to the difference between Zentyal Commercial and Zentyal
Community edition?


Hi,

from the release notes of OpenChange 2.3 VULCAN:

- Automatic Outlook inbox refresh when receiving new emails

Looking at the version numbers this version is included in the SOGo 
repositories via the Zentyal packages.


From the release notes of Zentyal 4.2, section Mail & Groupware:

- Autorefresh and desktop notifications (commercial version only)

Zentyal and SOGo can do what they want, but it would make things easier 
to tell people, that they can't expect automatic inbox refresh if they 
are using the SOGo repositories of OpenChange and don't use EAS or IMAP.


BECAUSE autorefresh is not working with the Zentyal packages from the 
SOGo repository.


Regards,

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

Re: [SOGo] No Joy iOS

[Johannes Faber]

Am 03.11.15 um 21:22 schrieb Bob Wooldridge:

I have tried several different things I've found on the internet to try
and get iPhones and iPad to sync calendars.  The config always appears
to work but no calendar events show up.

Is there anyone out there who has a working iPhone with calendars?


Yes and it all depends on the version and configuration of SOGo. If you 
could provide a bit more information, maybe someone can give you a hint.


Regards,

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

Re: [SOGo] Installproblem

[Johannes Faber]

Am 05.11.15 um 01:41 schrieb Robert Rott:

Hello,
I'm installing Sogo on Debian Jessie an i got a bug.

When I use this code:

openchange_provision --openchangedb --openchangedb-uri 'mysql://openchange-
user[:openchange$123]@localhost/openchange'


Did you just copy and paste this line? Or do you really have a user with 
name


user[

and the password is

openchange$123]

? I guess not.

The part after mysql:// and before the second colon is the user name for 
the mysql connection and the part between the second colon and the at 
sign is the password for the connection.


If you got that line from some documentation, the brackets normally 
mean, that this part is optional.



I get:

Setting up openchange db
Traceback (most recent call last):
   File "/usr/sbin/openchange_provision", line 128, in 
 openchange.openchangedb_provision(provisionnames, lp,
opts.openchangedb_uri)
   File "/usr/lib/python2.7/dist-packages/openchange/provision.py", line 1312,
in openchangedb_provision
 openchangedb = mailbox.OpenChangeDBWithMysqlBackend(uri, find_setup_dir())
   File "/usr/lib/python2.7/dist-packages/openchange/mailbox.py", line 375, in
__init__
 self._connect_to_mysql()
   File "/usr/lib/python2.7/dist-packages/openchange/mailbox.py", line 300, in
_connect_to_mysql
 host, user, passwd, self.db_name, port = self._parse_mysql_url()
   File "/usr/lib/python2.7/dist-packages/openchange/mailbox.py", line 306, in
_parse_mysql_url
 conn_url = urlparse(self.url)
   File "/usr/lib/python2.7/urlparse.py", line 143, in urlparse
 tuple = urlsplit(url, scheme, allow_fragments)
   File "/usr/lib/python2.7/urlparse.py", line 214, in urlsplit
 raise ValueError("Invalid IPv6 URL")
ValueError: Invalid IPv6 URL

Can someone help me please?


It looks like the brackets confuse the URL parser.

Regards,

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

[SOGo] Zentyal packages in Sogo

[Johannes Faber]

Hi there,

what kind of features do the Zentyal OpenChange packages in the Sogo repository 
provide?

Do they provide the same features as the free version, where Zentyal removed 
regular OpenChange features?

Regards,

Johannes

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

Re: [SOGo] how does CalDAV sync work in SOGo

[Johannes Faber]

> Am 07.10.2015 um 02:04 schrieb Stephen Ingram :
> 
> I'm trying to find out why an iPhone will not grab all of the events for a 
> particular user's calendar. I've setup a private server just for that user so 
> I can see only logs from their iPhone. Does anyone know how the whole CalDAV 
> sync works? How does the iPhone know if there are additional events to sync? 
> Is there a way to obtain telemetry information in the logs so I can grab more 
> detail during the sync? I'm hoping to identify where the bug is.

I tested several third party calendar solutions (read non-apple solutions) for 
the iPhone and the best setting to catch really all events – even not so old 
ones – was to set syncing to all events. This is not the default setting and 
this may be a problem for big calendars.

Most of the solutions do not support push or the iPhone does not like their 
push support. Therefore you are stuck with loading updates every 15 minutes. 
Can’t currently see, that SOGo is better in this regard.

The first sync can take some time.

You can force an update of the calendar with deactivating the account, killing 
the calendar app and reactivating the account. If you are testing a lot, this 
saves you some headaches.

To that it all depends on the software version of the iPhone how smoothly it 
runs. Try to have the most current version of iOS.

Regards,

Johannes

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

Re: [SOGo] Outlook 2003 'Deleted Items' vs IMAP 'Trash'

[Johannes Faber]

> Am 06.10.2015 um 22:27 schrieb Gerald Brandt :
> 
> Hi,
> 
> When I delete an email via Outlook 2003, it moves the email into 'Deleted 
> Items'.  When I delete via Thunderbird or the web interface, it moves the 
> email into 'Trash'.
> 
> These two folder don't contain the same data.  Do I have a configuration 
> error, or is it a known issue?

"Trash" is the default folder for Thunderbird and "Deleted Items" the default 
folder for Outlook. At least if you are running Outlook in english.

It is partly a client thing.

As I don’t know no sane possibility to change the trash folder name for 
Outlook, I’ll configure all clients and servers to use the name Outlook uses. 
For most clients you can use profiles to reduce roll out headaches.

To that I make sure, that the IMAP server tells the client the name of the 
trash folder. Likewise for SOGo (SOGoTrashFolderName in /etc/sogo/sogo.conf).

Regards,

Johannes

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

Re: [SOGo] Outlook stops syncing

[Johannes Faber]

> Am 22.07.2015 um 16:31 schrieb Ludovic Marcotte :
> 
> On 21/07/2015 16:42, Gerald Brandt wrote:
>> Has this been fixed?
> It has not. We are still waiting for an updated openchange version.
> 
> We'll release v2.3.1 nonetheless today since many many other enhancements and 
> fixes got in since early June and it's time it gets released. Hopefully 
> v2.3.2 will follow very shortly with the openchange fixes.

Are these changes already available via source code?

Regards,

Johannes

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

Re: [SOGo] RPC-over-HTTP does this really work?

[Johannes Faber]

> Am 13.07.2015 um 19:03 schrieb Martina Weber :
> 
> Hello,
> 
> No matter what I try to do from Outlook when using the Exchange configurator 
> it will always try to connect to my sogo server on DCERPC and other ports, 
> even if I specify the exchange proxy server (the same machine with 
> https:// at the connection).

Did you also check in „Exchange Proxy Settings“ the „connect using HTTP first“ 
options for fast and slow networks?

> My goal would be that if it's possible put the sogo and openchange server 
> behind another apache which proxypasses the connections to the real groupware 
> server.
> 
> Can this be done? Yes or No?

Yes.

> Is this RPC-over-HTTP really works in Outlook 2007,2010,2013?

Tested this with 2010 and 2013. For 2013 you can additionally use EAS, which 
seems to be a bit more bullet proof.

> My exchange replacement server will be on the Internet not on a LAN. I don't 
> want to allow netbios communication.
> 
> If I understand this correctly that if Outlook would use the proxy properly 
> then all traffic would go on a single :443 TCP SSL port to my SOGO server.

Exactly. I would use a firewall to simulate this situation to avoid any Outlook 
automatisms.

Regards,

Johannes

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

Re: [SOGo] Save preferences without sieve

[Johannes Faber]

Recommended IMAP servers for SOGo are Cyrus IMAP or Dovecot. Both support sieve 
and can provide a sieve service on port 4190 that you need to provide 
configuration for normal users.

You will have a lot of fun making any other solution work, but I think that’s 
not what you want.

> Am 10.07.2015 um 15:51 schrieb Mirosław Sławiński :
> 
> Ok. Thanks
> 
> One more question: Sieve configure only on dovecot ?
> 
> W dniu 2015-07-10 o 15:13, Christian M. Jensen pisze:
>> Hi
>> 
>> yes you will need sieve to use vacation option
>> 
>> read the installation guide.
>> http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf
>> page 37 for option 'SOGoVacationEnabled'
>> and page 47 for setting up vacation cron
>> 
>> Regards
>> Christian Jensen
>> 
>> On 10-07-2015 14:49, Mirosław Sławiński wrote:
>>> I have set 'SOGoSieveScriptsEnabled= NO' but i find when i change to NO 
>>> Vacation and another stuff then preference work fine, but i want vacation 
>>> :) so i must have sieve ?
>>> 
>>> Regard
>>> Miroslaw Slawinski
>>> 
>>> W dniu 2015-07-10 o 12:48, Christian M. Jensen pisze:
 Hi
 
 Set 'SOGoSieveScriptsEnabled= NO'
 
 that will disable sieve and remove it from webinterface
 
 Regards
 Christian Jensen
 
 On 10-07-2015 11:01, Mirek wrote:
> Hi, I have working SOGo, but when i want save another preferences ( for
> example change first day a week ) and click save then is error Warning 
> service
> temporarily unavailable. In my log (sogo.log) i see problem : [ERROR]
> <0x0x7f9bf0af8790[SOGoSieveManager]> Sieve connection failed on
> sieve://127.0.0.1:4190
> 
> This is a possible to not use a sieve protocol ?
> 
> Regards,
> Miroslaw Slawinski
 
 
>>> 
>> 
>> 
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

Re: [SOGo] Save preferences without sieve

[Johannes Faber]

Exactly. No fancy stuff without sieve ;0)

If you want vacation without, you have to do it manually on the file system.

> Am 10.07.2015 um 14:49 schrieb Mirosław Sławiński :
> 
> I have set 'SOGoSieveScriptsEnabled= NO' but i find when i change to NO 
> Vacation and another stuff then preference work fine, but i want vacation :) 
> so i must have sieve ?
> 
> Regard
> Miroslaw Slawinski
> 
> W dniu 2015-07-10 o 12:48, Christian M. Jensen pisze:
>> Hi
>> 
>> Set 'SOGoSieveScriptsEnabled= NO'
>> 
>> that will disable sieve and remove it from webinterface
>> 
>> Regards
>> Christian Jensen
>> 
>> On 10-07-2015 11:01, Mirek wrote:
>>> Hi, I have working SOGo, but when i want save another preferences ( for
>>> example change first day a week ) and click save then is error Warning 
>>> service
>>> temporarily unavailable. In my log (sogo.log) i see problem : [ERROR]
>>> <0x0x7f9bf0af8790[SOGoSieveManager]> Sieve connection failed on
>>> sieve://127.0.0.1:4190
>>> 
>>> This is a possible to not use a sieve protocol ?
>>> 
>>> Regards,
>>> Miroslaw Slawinski
>> 
>> 
> 
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists

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

Re: [SOGo] Sogo - dovecot - shared mailboxes

[Johannes Faber]

Hi Frank,

increase Dovecot logging with

mail_debug=yes

and look if you maybe have some permission problems.

You could also try

doveadm acl debug -u userUsingFolder shared/userSharingFolder/Folder

to get more information.

Regards,

Johannes


> Am 10.07.2015 um 14:03 schrieb Frank Soyer :
> 
> Strange... I discover that on my Android phone, 2 folders are visibles when I 
> display all folders : "share" and "shared/". OK, they are empty (I don't see 
> the folders shared to me by another user) but they are present...
> 
> 
> Frank
> 
> 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 = >> ssl_key = >> 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

Re: [SOGo] openchange_provision error

[Johannes Faber]

> Am 10.07.2015 um 09:14 schrieb petr.sev...@linuxbox.cz:
> 
> Hi all,
> 
> I discovered the same problem on CentOS release 6.6 (Final)
> 
> I'm using nightly packages:
> openchange-ocsmanager-2.3.r5529.sogo-1.centos6.x86_64
> openchange-rpcproxy-2.3.r5529.sogo-1.centos6.x86_64
> openchange-2.3.r5529.sogo-1.centos6.x86_64
> sogo-activesync-2.3.0.20150709-1.centos6.x86_64
> sogo-debuginfo-2.3.0.20150709-1.centos6.x86_64
> sogo-ealarms-notify-2.3.0.20150709-1.centos6.x86_64
> sogo-openchange-backend-2.3.0.20150709-1.centos6.x86_64
> sogo-slapd-sockd-2.3.0.20150709-1.centos6.x86_64
> sogo-tool-2.3.0.20150709-1.centos6.x86_64
> sogo-2.3.0.20150709-1.centos6.x86_64
> 
> When I run openchange_newuser I get this error log:
> Traceback (most recent call last):
> File "/usr/sbin/openchange_newuser", line 30, in 
>   import openchange.provision as openchange
> File "/usr/lib64/python2.6/site-packages/openchange/provision.py", line 27,
> in 
>   from openchange import mailbox
> File "/usr/lib64/python2.6/site-packages/openchange/mailbox.py", line 34, in
> 
>   from openchange.migration import MigrationManager
> File "/usr/lib64/python2.6/site-packages/openchange/migration/__init__.py",
> line 61
>   self._version = {app: None for app in self.migrations.keys()}
>^
> SyntaxError: invalid syntax

Do you maybe have your users on a different dn than OpenChange expects? I had 
to make some changes to the scripts to use something different than the default 
user dn.

OpenChange expects everything within ou=Users,DC=domain,DC=toplevel and it is 
hardcoded at several places.

Regards,

Johannes

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

Re: [SOGo] Native Outlook

[Johannes Faber]

Hi Daniel,

because I get no proper sync with Outlook 2010 whatever I try and was wondering 
if after all these years in the making SOGo/OpenChange is already unicode clean.

I think I tracked one reason down to non-ascii characters in the special 
folders. I found some typical double-encoded UTF8 entries in the database and 
some warnings for incomplete multibyte sequences in the samba log. Does not 
matter what settings I throw at MySQL. It’s either this problem or that 
problem. Looks like 2.3 is terribly broken.

Outlook 2013 and EAS is currently no option.

Regards,

Johannes

> Am 09.07.2015 um 16:46 schrieb Daniel van Ham Colchete 
> :
> 
> Hi Johannes,
> 
> I do (Brazillian Portuguese), but I'm using EAS instead of native MAPI.
> 
> Why?
> Daniel Colchete
> 
> On Thu, Jul 9, 2015 at 7:29 AM, Johannes Faber  wrote:
> Hi,
> 
> does anybody have Outlook running in a non-english language?
> 
> Regards,
> 
> Johannes
> 
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
> 

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

Re: [SOGo] Cannot send message: all recipients are invalid.

[Johannes Faber]

> Am 09.07.2015 um 12:47 schrieb artbala...@gmail.com:
> 
> Hi to all,
> 
> I've got this error "Cannot send message: all recipients are invalid." when
> sending or replying to domain with this format, here is my example :
> 
> a...@the-greatbuys.com
> 
> But when I using to reply emails to this domain using gmail, yahoomail and
> other email system it is ok.
> I think domain name with the mark or sign (—) is the problem. Is there a way
> to solve this issue.\

Have a look at the logs. Most of the time it is a misconfiguration of where the 
several services look up their information. I would start at the SMTP logs and 
maybe increase verbosity in advance.

Regards,

Johannes

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

[SOGo] Native Outlook

[Johannes Faber]

Hi,

does anybody have Outlook running in a non-english language?

Regards,

Johannes

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

[SOGo] you should *never* get here

[Johannes Faber]

Hi,

I get a 0x00040820 error while syncing with Outlook. The folder for syncing 
problems is empty, so there is no real hint from Outlook what’s happening. Like 
always.

I dug into the samba log and found:

[2015/07/09 01:14:34.506817,  5] libmapi/oc_log.c:52(oc_logv)
  mapiproxy/servers/default/emsmdb/oxcfold.c:64(EcDoRpc_RopOpenFolder): 
exchange_emsmdb: [OXCFOLD] OpenFolder (0x02)
<0x0x7f463af1a5a0[MAPIStoreFallbackContext]> -[MAPIStoreContext 
getPath:ofFMID:inMemCtx:]: you should *never* get here

This hints to MAPIStoreContext and MAPIStoreContext.m does indeed contain this 
message. As far as I understand the things behind the getPath method, it gets 
its information from the SQL table folders, mainly from the field MAPIStoreURI.

Unfortunately, MAPIStoreURI is NULL for some rows for this user:

id  ou_id   folder_id   folder_classmailbox_id  
parent_folder_idFolderType  SystemIdx   MAPIStoreURI
85  1   17366724588070764545system  3   NULL1   9   
NULL
86  1   17438782182108692481system  3   NULL1   10  
NULL
87  1   17510839776146620417system  3   NULL1   11  
NULL
88  1   17582897370184548353system  3   NULL1   12  
NULL

Unfortunately, the Fields with SystemIdx between 9 and 12 do always contain 
NULL for MAPIStoreURI, independent from how I create the user. I can’t find 
further information about the fields to the table, so I’m stuck.

Is the table broken? Does it lead to the 0x00040820 error?

Could it be a problem with localization where Outlook can’t connect to the 
proper folder? I need to start outlook.exe with /resetfoldernames to get native 
folder names in outlook.

Regards,

Johannes

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

Re: [SOGo] Outlook stops syncing

[Johannes Faber]

Am 02.07.2015 um 12:28 schrieb Ludovic Marcotte:

> On 07/06/2015 07:24, Saso Slavicic wrote: 
>> Outlook 2010 starts and syncs all folders and properly creates Suggested 
>> contacts (can be seen on SOGo web). For some other folders (Sync issues) it 
>> created 6 copies of all folders (listed in /var/spool/dovecot): 
> I've been able to reproduce this issue, expect updated packages this week 
> with the proper bug fix.

Any news on this? I still can see this behaviour with nightly builds.

Was there a version before 2.3 without this behaviour?
Is it maybe related to some IMAP configuration?

Regards,

Johannes

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