[SOGo] Web Calendars do not show any appointments

2019-11-27 Thread Lars Liedtke
Hello all,

I tried to add WebDAV-Calendars to SOGo and neither with nextcloud, nor
with OpenXchange or Google Calendar this is working.

The Calendar is added and I am being prompted for my username and
password. But that's it. I see no appointments in the Web GUI where
there should be some.

In the logfile I can see that it is adding the calendar and that it gets
a HTTP 200 back after logging in.

2019-11-27 11:44:20.745 sogod[800:100059]  SQL: UPDATE sogo_user_profile SET c_settings = 
'{"Calendar": {"FoldersOrder": ["personal"], "View": "weekview", 
"FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": 
"view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, 
"WebCalendars": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
 "InactiveFolders": [], "NotifyOnExternalModifications": {}, 
"AutoReloadedWebCalendars": {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
"NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
"1"]}}'   WHERE c_uid = 'ry86';
Nov 27 11:44:20 sogod [800]: 
<0x80b266b08[SOGoWebAppointmentFolder]:320-5DDE5380-5-53FB8680> Load web 
calendar 
https://nextcloud.familie-liedtke.net/remote.php/dav/calendars/lars/default/ 
(401)
2019-11-27 11:44:27.651 sogod[800:100059]  SQL: UPDATE sogo_user_profile SET c_settings = 
'{"Calendar": {"FoldersOrder": ["personal"], "View": "weekview", 
"FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": 
"view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, 
"WebCalendars": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
 "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
"NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
{"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
"NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
"1"]}}'   WHERE c_uid = 'ry86';
Nov 27 11:44:28 sogod [800]: 
<0x80b2f39c8[SOGoWebAppointmentFolder]:320-5DDE5380-5-53FB8680> Load web 
calendar 
https://nextcloud.familie-liedtke.net/remote.php/dav/calendars/lars/default/ 
(200)
2019-11-27 11:44:28.759 sogod[800:100059]  SQL: UPDATE sogo_user_profile SET c_settings = 
'{"Calendar": {"FoldersOrder": ["personal", "320-5DDE5380-5-53FB8680"], "View": 
"weekview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
"EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
"FreeBusyExclusions": {}, "WebCalendars": 
{"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
 "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
"NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
{"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
"NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
"1"]}}'   WHERE c_uid = 'ry86';
2019-11-27 11:44:28.825 sogod[800:100059]  SQL: UPDATE sogo_user_profile SET c_settings = 
'{"Calendar": {"FoldersOrder": ["personal", "320-5DDE5380-5-53FB8680"], "View": 
"weekview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
"EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
"FreeBusyExclusions": {}, "WebCalendars": 
{"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
 "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
"NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
{"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
"NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
"1"]}}'   WHERE c_uid = 'ry86';
2019-11-27 11:44:28.826 sogod[800:100059]  SQL: UPDATE sogo_user_profile SET c_settings = 
'{"Calendar": {"FoldersOrder": ["personal", "320-5DDE5380-5-53FB8680"], "View": 
"weekview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
"EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
"FreeBusyExclusions": {}, "WebCalendars": 
{"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
 "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
"IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
"NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
{"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
"NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
"1"]}}'   WHERE c_uid = 'ry86';

A look into the database 

RE: [SOGo] Issues with Apostrophe (Single Quote)

2019-11-27 Thread Andrew Mogg
Hi Anselm
SOGo version is 4.1.1
It is running onNethServer 7.7.1908

The original email headers (with quote marks now included):
Return-Receipt-To: "Andy Hope" 
From: "Andy Hope" 
To: <"Danny.O'Brien"@#>
References: 
 
 

In-Reply-To: 

Subject: RE: water meter transducer
Date: Wed, 27 Nov 2019 09:49:06 -
Message-ID:


The return Bounce message fails on the user not known, Notice the single quote 
has been removed in the header on the For header, but not the To. Sogo has 
stripped the ‘ from the email address. I cannot ask a customer to change their 
email address due to our systems.

Return-Path: 
Received: from localhost (localhost [127.0.0.1])
(Authenticated sender: andy.hope@)
by mercury.#(Postfix) with ESMTPA id A26BE10093573
for ; Wed, 27 Nov 2019 09:49:06 + (GMT)
Return-Receipt-To: "Andy Hope" 
From: "Andy Hope" 
To: 
References: 
 
 

In-Reply-To: 


From: users-requ...@sogo.nu  On Behalf Of Anselm Martin 
Hoffmeister
Sent: 26 November 2019 17:10
To: users@sogo.nu
Subject: Re: [SOGo] Issues with Apostrophe (Single Quote)


Hi Andrew,

I just tested writing a mail from SOGo webmail (4.1.0 in this case) to a fake 
version of my private account elsewhere, having inserted an apostrophe '. My 
private server rightfully refuses the (invalid) destination address - it seems 
SOGo does everything correctly here and hands through the apostrophe exactly as 
I would expect.

Trying to replicate the problem, doing the same with both the forward and 
backward tick ´` (single quotation marks or accent over blank, or whatever you 
call them), the same happens, SOGo hands through those mails and the 
destination server then refuses - the forward tick for "invalid postbox", the 
backtick as "restricted characters in address", and the non-delivery mail 
quotes the refused target address including the superfluous characters.

So it seems (my) SOGo 4.1.0 works correctly. But there may be other parties 
involved: Usually SOGo hands off the mail to a local running exim (or 
postfix), which then forwards the mail as applicable. There may be a 
different mail path between roundcube and SOGo, depending on your local 
configuration.

Can you find some relevant lines in the mail server logs? In exim case and on 
Debian(ish) Linuxes, /var/log/exim4/mainlog would be the place to investigate.

Also having details on the software version involved and perhaps the relevant 
parts of the SOGO config may be helpful.

Best regards

Anselm
Am 26.11.2019 um 13:37 schrieb Andrew Mogg 
(and...@logicomm.co.uk):

Hi
We are having issues with a particular email address which has a ‘ in its email 
address. Such as Dano’rou...@gmail.com
When the email is sent from SOGo, it removes the ‘ from the email address, so 
the email is actually sent to danorou...@gmail.com 
and therefore fails (ie bounces). Interestingly, when I access the server via 
Roundcube and send, this does not happen, so its SOGo
Has anyone had any experience of this?

This email has been scanned for email related threats and delivered safely by 
Exascale.
For more information please visit https://www.exascale.co.uk


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

[SOGo] Failed to update sogo 4.0.8 to 4.1.1 [so-product-registry] failed to load product CommonUI required by MainUI

2019-11-27 Thread Senechal Jean Francois

I have not managed to update sogo
I had to put back my old version

I updated with compilation http://wiki.sogo.nu/Compilation#Build

I took the sources by the page download and also test with the sources 
in both cases the same problem


After the update I had these error messages :

"[ERROR] [so-product-registry] failed to load product CommonUI required 
by MainUI."


Error (objc-load):libSOGoUI.so.4.1: Ne peut ouvrir le fichier d'objet 
partagé: Aucun fichier ou dossier de ce type


My environnement

Debian 7.11

Thank you


--

Jean-François Sénéchal


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

Re: [SOGo] Web Calendars do not show any appointments

2019-11-27 Thread Christian Mack
Hello

Of course that is not working.
SOGo does not support remote WebDAV/calDAV calendars.
It only supports webcalendars as readonly ics files.

See Feature Request
https://sogo.nu/bugs/view.php?id=2124


Kind regards,
Christian Mack

Am 27.11.19 um 11:55 schrieb Lars Liedtke (lied...@punkt.de):
> Hello all,
> 
> I tried to add WebDAV-Calendars to SOGo and neither with nextcloud, nor
> with OpenXchange or Google Calendar this is working.
> 
> The Calendar is added and I am being prompted for my username and
> password. But that's it. I see no appointments in the Web GUI where
> there should be some.
> 
> In the logfile I can see that it is adding the calendar and that it gets
> a HTTP 200 back after logging in.
> 
> 2019-11-27 11:44:20.745 sogod[800:100059]  connection=0x0x80c2b4a08> SQL: UPDATE sogo_user_profile SET c_settings = 
> '{"Calendar": {"FoldersOrder": ["personal"], "View": "weekview", 
> "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": 
> "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, 
> "WebCalendars": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
> "https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
>  "InactiveFolders": [], "NotifyOnExternalModifications": {}, 
> "AutoReloadedWebCalendars": {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
> "NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
> "1"]}}'   WHERE c_uid = 'ry86';
> Nov 27 11:44:20 sogod [800]: 
> <0x80b266b08[SOGoWebAppointmentFolder]:320-5DDE5380-5-53FB8680> Load web 
> calendar 
> https://nextcloud.familie-liedtke.net/remote.php/dav/calendars/lars/default/ 
> (401)
> 2019-11-27 11:44:27.651 sogod[800:100059]  connection=0x0x80c2b4a08> SQL: UPDATE sogo_user_profile SET c_settings = 
> '{"Calendar": {"FoldersOrder": ["personal"], "View": "weekview", 
> "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": 
> "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, 
> "WebCalendars": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
> "https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
>  "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
> "IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
> "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
> {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
> "NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
> "1"]}}'   WHERE c_uid = 'ry86';
> Nov 27 11:44:28 sogod [800]: 
> <0x80b2f39c8[SOGoWebAppointmentFolder]:320-5DDE5380-5-53FB8680> Load web 
> calendar 
> https://nextcloud.familie-liedtke.net/remote.php/dav/calendars/lars/default/ 
> (200)
> 2019-11-27 11:44:28.759 sogod[800:100059]  connection=0x0x80c2b5908> SQL: UPDATE sogo_user_profile SET c_settings = 
> '{"Calendar": {"FoldersOrder": ["personal", "320-5DDE5380-5-53FB8680"], 
> "View": "weekview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
> "EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
> "FreeBusyExclusions": {}, "WebCalendars": 
> {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
> "https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
>  "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
> "IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
> "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
> {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
> "NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
> "1"]}}'   WHERE c_uid = 'ry86';
> 2019-11-27 11:44:28.825 sogod[800:100059]  connection=0x0x80c2b5908> SQL: UPDATE sogo_user_profile SET c_settings = 
> '{"Calendar": {"FoldersOrder": ["personal", "320-5DDE5380-5-53FB8680"], 
> "View": "weekview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
> "EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
> "FreeBusyExclusions": {}, "WebCalendars": 
> {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
> "https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
>  "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
> "IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
> "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
> {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
> "NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
> "1"]}}'   WHERE c_uid = 'ry86';
> 2019-11-27 11:44:28.826 sogod[800:100059]  connection=0x0x80c2b4a08> SQL: UPDATE sogo_user_profile SET c_settings = 
> '{"Calendar": {"FoldersOrder": ["personal", "320-5DDE5380-5-53FB8680"], 
> "View": "weekview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
> "EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
> 

Re: [SOGo] Web Calendars do not show any appointments

2019-11-27 Thread Lars Liedtke
Hey,

thanks. Using Nextcloud's ics-export did the trick.

Best regards

Lars

Am 27.11.19 um 15:57 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Hello
>
> Of course that is not working.
> SOGo does not support remote WebDAV/calDAV calendars.
> It only supports webcalendars as readonly ics files.
>
> See Feature Request
> https://sogo.nu/bugs/view.php?id=2124
>
>
> Kind regards,
> Christian Mack
>
> Am 27.11.19 um 11:55 schrieb Lars Liedtke (lied...@punkt.de):
>> Hello all,
>>
>> I tried to add WebDAV-Calendars to SOGo and neither with nextcloud, nor
>> with OpenXchange or Google Calendar this is working.
>>
>> The Calendar is added and I am being prompted for my username and
>> password. But that's it. I see no appointments in the Web GUI where
>> there should be some.
>>
>> In the logfile I can see that it is adding the calendar and that it gets
>> a HTTP 200 back after logging in.
>>
>> 2019-11-27 11:44:20.745 sogod[800:100059] > connection=0x0x80c2b4a08> SQL: UPDATE sogo_user_profile SET c_settings = 
>> '{"Calendar": {"FoldersOrder": ["personal"], "View": "weekview", 
>> "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
>> "EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
>> "FreeBusyExclusions": {}, "WebCalendars": 
>> {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
>> "https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
>>  "InactiveFolders": [], "NotifyOnExternalModifications": {}, 
>> "AutoReloadedWebCalendars": {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
>> "NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
>> "1"]}}'   WHERE c_uid = 'ry86';
>> Nov 27 11:44:20 sogod [800]: 
>> <0x80b266b08[SOGoWebAppointmentFolder]:320-5DDE5380-5-53FB8680> Load web 
>> calendar 
>> https://nextcloud.familie-liedtke.net/remote.php/dav/calendars/lars/default/ 
>> (401)
>> 2019-11-27 11:44:27.651 sogod[800:100059] > connection=0x0x80c2b4a08> SQL: UPDATE sogo_user_profile SET c_settings = 
>> '{"Calendar": {"FoldersOrder": ["personal"], "View": "weekview", 
>> "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
>> "EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
>> "FreeBusyExclusions": {}, "WebCalendars": 
>> {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
>> "https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
>>  "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
>> "IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
>> "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
>> {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
>> "NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
>> "1"]}}'   WHERE c_uid = 'ry86';
>> Nov 27 11:44:28 sogod [800]: 
>> <0x80b2f39c8[SOGoWebAppointmentFolder]:320-5DDE5380-5-53FB8680> Load web 
>> calendar 
>> https://nextcloud.familie-liedtke.net/remote.php/dav/calendars/lars/default/ 
>> (200)
>> 2019-11-27 11:44:28.759 sogod[800:100059] > connection=0x0x80c2b5908> SQL: UPDATE sogo_user_profile SET c_settings = 
>> '{"Calendar": {"FoldersOrder": ["personal", "320-5DDE5380-5-53FB8680"], 
>> "View": "weekview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
>> "EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
>> "FreeBusyExclusions": {}, "WebCalendars": 
>> {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
>> "https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
>>  "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
>> "IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
>> "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
>> {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
>> "NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
>> "1"]}}'   WHERE c_uid = 'ry86';
>> 2019-11-27 11:44:28.825 sogod[800:100059] > connection=0x0x80c2b5908> SQL: UPDATE sogo_user_profile SET c_settings = 
>> '{"Calendar": {"FoldersOrder": ["personal", "320-5DDE5380-5-53FB8680"], 
>> "View": "weekview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, 
>> "EventsFilterState": "view_next7", "SelectedList": "eventsListView", 
>> "FreeBusyExclusions": {}, "WebCalendars": 
>> {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
>> "https:\\/\\/nextcloud.familie-liedtke.net\\/remote.php\\/dav\\/calendars\\/lars\\/default\\/"},
>>  "WebCalendarsAuthentication": {"ry86:Calendar\\/320-5DDE5380-5-53FB8680": 
>> "IQAIABwAHABPAC4ACAAaAFcARwBIAEwAOQBRAFwATAA="}, "InactiveFolders": [], 
>> "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": 
>> {"ry86:Calendar\\/320-5DDE3980-1-53FB8680": 1}, 
>> "NotifyUserOnPersonalModifications": {}, "EventsSortingState": ["start", 
>> "1"]}}'   WHERE c_uid = 'ry86';
>> 2019-11-27 11:44:28.826 sogod[800:100059] > connection=0x0x80c2b4a08> SQL: UPDATE