Hello, I am trying to setup SoGO3 for personal use as mailing + calendar system.
I need to add Web Calendars with auth to the Calendar view of SoGO but it seems
the authentication is not working.
Steps :
- Go to Calendar view
- Click + sign next to Web Calendars
- Type in CalDav URL
- Type user and password at prompt
- Click OK
- Wait, then no events are displayed.
The same URL, user and password are working in Thunderbird Lightning as well as
on the original Owncloud instance the calendar is served from.
The auth itself *is* working since typing in a wrong password fails, typing the
correct password succeeds but then the events aren't fetched or displayed.
I am using a SQL setup.
I've attached three logs:
-add.log: the output produced right when adding the calendar
-auth.log: right when clicking "ok" in the auth window with username and
password
-pgconnectiondropped.log: db connection drop, happens a few minutes later, no
idea if it's related but it happens when web calendars are added.
It should be noted I'm using an unofficial Docker image
(https://github.com/julienfastre/docker-sogo) for testing, though I'm hoping to
receive some help from this list!
I also tested with the SoGO3 test instances users sogo1-3 that you provide,
getting the same result.
Also note: a calendar *without* auth either from the same Owncloud instance or
from Google Agenda *does* work, the events are correctly fetched and displayed
etc...
Next test I want to do is compiling and installing SoGO manually and see if the
issue is resolved.
Meanwhile, any thoughts about this?
I could not find any other resource mentioning this kind of problem.
Thanks in advance!
--
users@sogo.nu
https://inverse.ca/sogo/lists
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x0x55e82d328b90[NGHttpRequest]> got 2 values for cookie 'XSRF-TOKEN', using first only: 0c0f1ae0924e311778fde7fb5be4d492af613d8a,7da74187ea82cb0579736bb9df600ad73543fc12
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| starting method 'POST' on uri '/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/set-credentials'
sogo_1 | 2017-06-07 12:25:28.070 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'SANITZED_SOGO_USERNAME' AND c_folder_type = 'Appointment'
sogo_1 | 2017-06-07 12:25:28.073 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/7-5926FF80-7-DB79270'
sogo_1 | 2017-06-07 12:25:28.076 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80'
sogo_1 | 2017-06-07 12:25:28.081 sogod[10] PG0x0x55e82d395fa0 SQL: BEGIN TRANSACTION
sogo_1 | 2017-06-07 12:25:28.082 sogod[10] PG0x0x55e82d395fa0 SQL: UPDATE sogo_user_profile SET c_settings = E'{"Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"FoldersOrder": ["personal", "7-5926FF80-7-DB79270"], "View": "monthview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, "WebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "https:\\/\\/SANITZED_URL\\/owncloud\\/remote.php\\/dav\\/calendars\\/SANITZED\\/-\\/", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "https:\\/\\/demo.nextcloud.com\\/testforsogo\\/remote.php\\/dav\\/principals\\/users\\/admin\\/"}, "WebCalendarsAuthentication": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "BQAIABMAAAAcABAAWQAGAAgAAwAeAAwAGwA=", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "AgAJAAwADgAHAFkADwACAA0AVgBbAFAA"}, "InactiveFolders": [], "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/9-59258300-5-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FB80-1-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/9-59258A00-B-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FD00-5-DB79270": 1}, "NotifyUserOnPersonalModifications": {}, "PreventInvitationsWhitelist": {}, "ListState": "collapse", "EventsSortingState": ["start", "1"]}, "Mail": {"ExpandedFolders": ["\\/1"]}}' WHERE c_uid = 'SANITZED_SOGO_USERNAME'
sogo_1 | 2017-06-07 12:25:28.082 sogod[10] PG0x0x55e82d395fa0 SQL: COMMIT TRANSACTION
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| request took 0.061712 seconds to execute
nginx_1 | 172.23.0.1 - - [07/Jun/2017:12:25:28 +0000] "POST /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/set-credentials HTTP/1.1" 204 0 "http://localhost:8080/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/view"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.35 Safari/537.36" "-"
sogo_1 | Jun 07 12:25:28 sogod [10]: 127.0.0.1 "POST /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/set-credentials HTTP/1.1" 204 0/41 0.065 - - 0
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x0x55e82d2e9e00[NGHttpRequest]> got 2 values for cookie 'XSRF-TOKEN', using first only: 0c0f1ae0924e311778fde7fb5be4d492af613d8a,7da74187ea82cb0579736bb9df600ad73543fc12
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| starting method 'GET' on uri '/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/reload'
sogo_1 | 2017-06-07 12:25:28.145 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'SANITZED_SOGO_USERNAME' AND c_folder_type = 'Appointment'
sogo_1 | 2017-06-07 12:25:28.146 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/7-5926FF80-7-DB79270'
sogo_1 | 2017-06-07 12:25:28.146 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80'
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x55e82d18ce60[SOGoWebAppointmentFolder]:A-5937F080-3-5D390D80> Load web calendar https://SANITZED_URL/owncloud/remote.php/dav/calendars/SANITZED/-/ (200)
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| request took 0.627295 seconds to execute
nginx_1 | 172.23.0.1 - - [07/Jun/2017:12:25:28 +0000] "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/reload HTTP/1.1" 200 147 "http://localhost:8080/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/view"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.35 Safari/537.36" "-"
sogo_1 | Jun 07 12:25:28 sogod [10]: 127.0.0.1 "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/reload HTTP/1.1" 200 147/0 0.628 - - 0
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x0x55e82d335b70[NGHttpRequest]> got 2 values for cookie 'XSRF-TOKEN', using first only: 0c0f1ae0924e311778fde7fb5be4d492af613d8a,7da74187ea82cb0579736bb9df600ad73543fc12
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| starting method 'GET' on uri '/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/calendarslist'
sogo_1 | 2017-06-07 12:25:28.790 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'SANITZED_SOGO_USERNAME' AND c_folder_type = 'Appointment'
sogo_1 | 2017-06-07 12:25:28.793 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/7-5926FF80-7-DB79270'
sogo_1 | 2017-06-07 12:25:28.794 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80'
sogo_1 | 2017-06-07 12:25:28.801 sogod[10] PG0x0x55e82d2e1600 SQL: BEGIN TRANSACTION
sogo_1 | 2017-06-07 12:25:28.802 sogod[10] PG0x0x55e82d2e1600 SQL: UPDATE sogo_user_profile SET c_settings = E'{"Calendar": {"FoldersOrder": ["A-5937F080-3-5D390D80", "7-5926FF80-7-DB79270", "personal"], "View": "monthview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, "WebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "https:\\/\\/SANITZED_URL\\/owncloud\\/remote.php\\/dav\\/calendars\\/SANITZED\\/-\\/", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "https:\\/\\/demo.nextcloud.com\\/testforsogo\\/remote.php\\/dav\\/principals\\/users\\/admin\\/"}, "WebCalendarsAuthentication": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "BQAIABMAAAAcABAAWQAGAAgAAwAeAAwAGwA=", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "AgAJAAwADgAHAFkADwACAA0AVgBbAFAA"}, "InactiveFolders": [], "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/9-59258300-5-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FB80-1-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FD00-5-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/9-59258A00-B-35BCA000": 1}, "NotifyUserOnPersonalModifications": {}, "PreventInvitationsWhitelist": {}, "EventsSortingState": ["start", "1"], "ListState": "collapse"}, "Contact": {"SortingState": ["c_cn", "1"]}, "Mail": {"ExpandedFolders": ["\\/1"]}}' WHERE c_uid = 'SANITZED_SOGO_USERNAME'
sogo_1 | 2017-06-07 12:25:28.803 sogod[10] PG0x0x55e82d2e1600 SQL: COMMIT TRANSACTION
sogo_1 | Jun 07 12:25:28 sogod [1]: [ERROR] <0x0x55e82cc98190[WOWatchDog]> No child available to handle incoming request!
sogo_1 | 2017-06-07 12:25:28.839 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/personal'
sogo_1 | 2017-06-07 12:25:28.845 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_component, c_status FROM sogoSANITZED_SOGO_USERNAME00150bee5e3_quick WHERE ((c_component = 'vtodo') AND (c_status != 1) AND (c_status != 3))
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| constructed root-url: /SOGo/
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| setting root-url in context: /SOGo/so/
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| ROOT baseURL(no container, name=(null)):
sogo_1 | own: /SOGo/so/
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x55e82d20d420[SOGoUserFolder]:SANITZED_SOGO_USERNAME> baseURL: name=SANITZED_SOGO_USERNAME (container=SOGo)
sogo_1 | container: /SOGo -- http://localhost/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/calendarslist
sogo_1 | own: /SOGo/so/SANITZED_SOGO_USERNAME
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| using root-url from context: /SOGo/so/
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| ROOT baseURL(no container, name=(null)):
sogo_1 | own: /SOGo/so/
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x55e82d20d420[SOGoUserFolder]:SANITZED_SOGO_USERNAME> baseURL: name=SANITZED_SOGO_USERNAME (container=SOGo)
sogo_1 | container: /SOGo -- http://localhost/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/calendarslist
sogo_1 | own: /SOGo/so/SANITZED_SOGO_USERNAME
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x55e82cea7d40[SOGoAppointmentFolders]:Calendar> baseURL: name=Calendar (container=SOGoUserFolder)
sogo_1 | container: /SOGo/so/SANITZED_SOGO_USERNAME/
sogo_1 | own: /SOGo/so/SANITZED_SOGO_USERNAME/Calendar
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| using root-url from context: /SOGo/so/
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| ROOT baseURL(no container, name=(null)):
sogo_1 | own: /SOGo/so/
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x55e82d20d420[SOGoUserFolder]:SANITZED_SOGO_USERNAME> baseURL: name=SANITZED_SOGO_USERNAME (container=SOGo)
sogo_1 | container: /SOGo -- http://localhost/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/calendarslist
sogo_1 | own: /SOGo/so/SANITZED_SOGO_USERNAME
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| using root-url from context: /SOGo/so/
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| ROOT baseURL(no container, name=(null)):
sogo_1 | own: /SOGo/so/
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x55e82d20d420[SOGoUserFolder]:SANITZED_SOGO_USERNAME> baseURL: name=SANITZED_SOGO_USERNAME (container=SOGo)
sogo_1 | container: /SOGo -- http://localhost/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/calendarslist
sogo_1 | own: /SOGo/so/SANITZED_SOGO_USERNAME
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x55e82cea7d40[SOGoAppointmentFolders]:Calendar> baseURL: name=Calendar (container=SOGoUserFolder)
sogo_1 | container: /SOGo/so/SANITZED_SOGO_USERNAME/
sogo_1 | own: /SOGo/so/SANITZED_SOGO_USERNAME/Calendar
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x55e82d4c3ab0[SOGoAppointmentFolder]:personal> baseURL: name=personal (container=SOGoAppointmentFolders)
sogo_1 | container: /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/
sogo_1 | own: /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/personal
nginx_1 | 172.23.0.1 - - [07/Jun/2017:12:25:28 +0000] "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/calendarslist HTTP/1.1" 200 1763 "http://localhost:8080/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/view"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.35 Safari/537.36" "-"
sogo_1 | 2017-06-07 12:25:28.853 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_component, c_status FROM sogoSANITZED_SOGO_USERNAME0047439574d_quick WHERE ((c_component = 'vtodo') AND (c_status != 1) AND (c_status != 3))
sogo_1 | 2017-06-07 12:25:28.861 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'SANITZED_SOGO_USERNAME' AND c_path3 = 'Calendar' AND c_path4 = 'A-5937F080-3-5D390D80'
sogo_1 | 2017-06-07 12:25:28.867 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_component, c_status FROM sogoSANITZED_SOGO_USERNAME0020ddd4b66_quick WHERE ((c_component = 'vtodo') AND (c_status != 1) AND (c_status != 3))
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| request took 0.088026 seconds to execute
sogo_1 | Jun 07 12:25:28 sogod [10]: 127.0.0.1 "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/calendarslist HTTP/1.1" 200 1763/0 0.092 - - 0
sogo_1 | Jun 07 12:25:28 sogod [10]: <0x0x55e82d4cabb0[NGHttpRequest]> got 2 values for cookie 'XSRF-TOKEN', using first only: 0c0f1ae0924e311778fde7fb5be4d492af613d8a,7da74187ea82cb0579736bb9df600ad73543fc12
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| starting method 'POST' on uri '/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/saveFoldersOrder'
sogo_1 | 2017-06-07 12:25:28.886 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'SANITZED_SOGO_USERNAME' AND c_folder_type = 'Appointment'
sogo_1 | 2017-06-07 12:25:28.888 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/7-5926FF80-7-DB79270'
sogo_1 | 2017-06-07 12:25:28.890 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80'
sogo_1 | 2017-06-07 12:25:28.901 sogod[10] PG0x0x55e82d395fa0 SQL: BEGIN TRANSACTION
sogo_1 | 2017-06-07 12:25:28.903 sogod[10] PG0x0x55e82d395fa0 SQL: UPDATE sogo_user_profile SET c_settings = E'{"Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"FoldersOrder": ["personal", "A-5937F080-3-5D390D80", "7-5926FF80-7-DB79270"], "View": "monthview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, "WebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "https:\\/\\/SANITZED_URL\\/owncloud\\/remote.php\\/dav\\/calendars\\/SANITZED\\/-\\/", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "https:\\/\\/demo.nextcloud.com\\/testforsogo\\/remote.php\\/dav\\/principals\\/users\\/admin\\/"}, "WebCalendarsAuthentication": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "BQAIABMAAAAcABAAWQAGAAgAAwAeAAwAGwA=", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "AgAJAAwADgAHAFkADwACAA0AVgBbAFAA"}, "InactiveFolders": [], "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/9-59258300-5-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FB80-1-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/9-59258A00-B-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FD00-5-DB79270": 1}, "NotifyUserOnPersonalModifications": {}, "PreventInvitationsWhitelist": {}, "ListState": "collapse", "EventsSortingState": ["start", "1"]}, "Mail": {"ExpandedFolders": ["\\/1"]}}' WHERE c_uid = 'SANITZED_SOGO_USERNAME'
sogo_1 | 2017-06-07 12:25:28.906 sogod[10] PG0x0x55e82d395fa0 SQL: COMMIT TRANSACTION
sogo_1 | Jun 07 12:25:28 sogod [10]: |SOGo| request took 0.038973 seconds to execute
sogo_1 | Jun 07 12:25:28 sogod [10]: 127.0.0.1 "POST /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/saveFoldersOrder HTTP/1.1" 204 0/71 0.044 - - 0
nginx_1 | 172.23.0.1 - - [07/Jun/2017:12:25:28 +0000] "POST /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/saveFoldersOrder HTTP/1.1" 204 0 "http://localhost:8080/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/view"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.35 Safari/537.36" "-"
sogo_1 | Jun 07 12:25:29 sogod [1]: [ERROR] <0x0x55e82cc98190[WOWatchDog]> No child available to handle incoming request!
sogo_1 | Jun 07 12:25:29 sogod [10]: <0x0x55e82d3671b0[NGHttpRequest]> got 2 values for cookie 'XSRF-TOKEN', using first only: 0c0f1ae0924e311778fde7fb5be4d492af613d8a,7da74187ea82cb0579736bb9df600ad73543fc12
sogo_1 | Jun 07 12:25:29 sogod [10]: |SOGo| starting method 'GET' on uri '/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/eventslist?asc=1&day=20170607&filterpopup=view_next7&search=title_Category_Location&sort=start&value='
sogo_1 | 2017-06-07 12:25:29.079 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'SANITZED_SOGO_USERNAME' AND c_folder_type = 'Appointment'
sogo_1 | 2017-06-07 12:25:29.080 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/7-5926FF80-7-DB79270'
sogo_1 | 2017-06-07 12:25:29.081 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80'
sogo_1 | 2017-06-07 12:25:29.084 sogod[10] PG0x0x55e82d395fa0 SQL: BEGIN TRANSACTION
sogo_1 | 2017-06-07 12:25:29.084 sogod[10] PG0x0x55e82d395fa0 SQL: UPDATE sogo_user_profile SET c_settings = E'{"Calendar": {"FoldersOrder": ["personal", "A-5937F080-3-5D390D80", "7-5926FF80-7-DB79270"], "View": "monthview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, "WebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "https:\\/\\/SANITZED_URL\\/owncloud\\/remote.php\\/dav\\/calendars\\/SANITZED\\/-\\/", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "https:\\/\\/demo.nextcloud.com\\/testforsogo\\/remote.php\\/dav\\/principals\\/users\\/admin\\/"}, "WebCalendarsAuthentication": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "BQAIABMAAAAcABAAWQAGAAgAAwAeAAwAGwA=", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "AgAJAAwADgAHAFkADwACAA0AVgBbAFAA"}, "InactiveFolders": [], "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/9-59258300-5-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FB80-1-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FD00-5-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/9-59258A00-B-35BCA000": 1}, "NotifyUserOnPersonalModifications": {}, "PreventInvitationsWhitelist": {}, "EventsSortingState": ["start", "1"], "ListState": "collapse"}, "Contact": {"SortingState": ["c_cn", "1"]}, "Mail": {"ExpandedFolders": ["\\/1"]}}' WHERE c_uid = 'SANITZED_SOGO_USERNAME'
sogo_1 | 2017-06-07 12:25:29.085 sogod[10] PG0x0x55e82d395fa0 SQL: COMMIT TRANSACTION
sogo_1 | 2017-06-07 12:25:29.130 sogod[10] PG0x0x55e82d2e1600 SQL: BEGIN TRANSACTION
sogo_1 | 2017-06-07 12:25:29.131 sogod[10] PG0x0x55e82d2e1600 SQL: UPDATE sogo_user_profile SET c_settings = E'{"Calendar": {"FoldersOrder": ["personal", "A-5937F080-3-5D390D80", "7-5926FF80-7-DB79270"], "View": "monthview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, "WebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "https:\\/\\/SANITZED_URL\\/owncloud\\/remote.php\\/dav\\/calendars\\/SANITZED\\/-\\/", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "https:\\/\\/demo.nextcloud.com\\/testforsogo\\/remote.php\\/dav\\/principals\\/users\\/admin\\/"}, "WebCalendarsAuthentication": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "BQAIABMAAAAcABAAWQAGAAgAAwAeAAwAGwA=", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "AgAJAAwADgAHAFkADwACAA0AVgBbAFAA"}, "InactiveFolders": [], "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/9-59258300-5-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FB80-1-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FD00-5-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/9-59258A00-B-35BCA000": 1}, "NotifyUserOnPersonalModifications": {}, "PreventInvitationsWhitelist": {}, "EventsSortingState": ["start", "1"], "ListState": "collapse"}, "Contact": {"SortingState": ["c_cn", "1"]}, "Mail": {"ExpandedFolders": ["\\/1"]}}' WHERE c_uid = 'SANITZED_SOGO_USERNAME'
sogo_1 | 2017-06-07 12:25:29.133 sogod[10] PG0x0x55e82d2e1600 SQL: COMMIT TRANSACTION
sogo_1 | 2017-06-07 12:25:29.149 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME00150bee5e3_quick a, sogoSANITZED_SOGO_USERNAME00150bee5e3 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1497398399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1496793600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.150 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME00150bee5e3_quick a, sogoSANITZED_SOGO_USERNAME00150bee5e3 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1497398399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1496793600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.153 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME0020ddd4b66_quick a, sogoSANITZED_SOGO_USERNAME0020ddd4b66 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1497398399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1496793600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.155 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME0020ddd4b66_quick a, sogoSANITZED_SOGO_USERNAME0020ddd4b66 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1497398399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1496793600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.157 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME0047439574d_quick a, sogoSANITZED_SOGO_USERNAME0047439574d b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1497398399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1496793600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.158 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME0047439574d_quick a, sogoSANITZED_SOGO_USERNAME0047439574d b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1497398399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1496793600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | Jun 07 12:25:29 sogod [10]: |SOGo| request took 0.083470 seconds to execute
nginx_1 | 172.23.0.1 - - [07/Jun/2017:12:25:29 +0000] "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/eventslist?asc=1&day=20170607&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 439 "http://localhost:8080/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/view"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.35 Safari/537.36" "-"
sogo_1 | Jun 07 12:25:29 sogod [10]: 127.0.0.1 "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/eventslist?asc=1&day=20170607&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 439/0 0.085 - - 0
sogo_1 | Jun 07 12:25:29 sogod [10]: <0x0x55e82d38f520[NGHttpRequest]> got 2 values for cookie 'XSRF-TOKEN', using first only: 0c0f1ae0924e311778fde7fb5be4d492af613d8a,7da74187ea82cb0579736bb9df600ad73543fc12
sogo_1 | Jun 07 12:25:29 sogod [10]: |SOGo| starting method 'GET' on uri '/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/eventsblocks?ed=20170701&sd=20170528&view=monthview'
sogo_1 | 2017-06-07 12:25:29.166 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'SANITZED_SOGO_USERNAME' AND c_folder_type = 'Appointment'
sogo_1 | 2017-06-07 12:25:29.167 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/7-5926FF80-7-DB79270'
sogo_1 | 2017-06-07 12:25:29.168 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80'
sogo_1 | 2017-06-07 12:25:29.176 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME00150bee5e3_quick a, sogoSANITZED_SOGO_USERNAME00150bee5e3 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1498953599)) AND ((c_enddate IS NULL) OR (c_enddate >= 1495929600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.177 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME00150bee5e3_quick a, sogoSANITZED_SOGO_USERNAME00150bee5e3 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1498953599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1495929600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.179 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME0020ddd4b66_quick a, sogoSANITZED_SOGO_USERNAME0020ddd4b66 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1498953599)) AND ((c_enddate IS NULL) OR (c_enddate >= 1495929600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.180 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME0020ddd4b66_quick a, sogoSANITZED_SOGO_USERNAME0020ddd4b66 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1498953599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1495929600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.182 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME0047439574d_quick a, sogoSANITZED_SOGO_USERNAME0047439574d b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1498953599)) AND ((c_enddate IS NULL) OR (c_enddate >= 1495929600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | 2017-06-07 12:25:29.184 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogoSANITZED_SOGO_USERNAME0047439574d_quick a, sogoSANITZED_SOGO_USERNAME0047439574d b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1498953599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1495929600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)
sogo_1 | Jun 07 12:25:29 sogod [10]: |SOGo| request took 0.028297 seconds to execute
nginx_1 | 172.23.0.1 - - [07/Jun/2017:12:25:29 +0000] "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/eventsblocks?ed=20170701&sd=20170528&view=monthview HTTP/1.1" 200 1973 "http://localhost:8080/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/view"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.35 Safari/537.36" "-"
sogo_1 | Jun 07 12:25:29 sogod [10]: 127.0.0.1 "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/eventsblocks?ed=20170701&sd=20170528&view=monthview HTTP/1.1" 200 1973/0 0.031 - - 0
sogo_1 | Jun 07 12:24:00 sogod [10]: <0x0x55e82d35d940[NGHttpRequest]> got 2 values for cookie 'XSRF-TOKEN', using first only: 0c0f1ae0924e311778fde7fb5be4d492af613d8a,7da74187ea82cb0579736bb9df600ad73543fc12
sogo_1 | Jun 07 12:24:00 sogod [10]: |SOGo| starting method 'POST' on uri '/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/addWebCalendar'
sogo_1 | 2017-06-07 12:24:00.043 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'SANITZED_SOGO_USERNAME' AND c_folder_type = 'Appointment'
sogo_1 | 2017-06-07 12:24:00.045 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'SANITZED_SOGO_USERNAME' AND c_path3 = 'Calendar' AND c_path4 = 'A-5937F080-3-5D390D80'
sogo_1 | 2017-06-07 12:24:00.046 sogod[10] PG0x0x55e82d2e1600 SQL: BEGIN TRANSACTION
sogo_1 | 2017-06-07 12:24:00.046 sogod[10] PG0x0x55e82d2e1600 SQL: INSERT INTO sogo_folder_info (c_path, c_path1, c_path2, c_path3, c_path4, c_foldername, c_location, c_quick_location, c_acl_location, c_folder_type) VALUES ('/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80', 'Users', 'SANITZED_SOGO_USERNAME', 'Calendar', 'A-5937F080-3-5D390D80', '-', 'postgresql://postgres:postgres@db:5432/postgres/sogoSANITZED_SOGO_USERNAME0020ddd4b66', 'postgresql://postgres:postgres@db:5432/postgres/sogoSANITZED_SOGO_USERNAME0020ddd4b66_quick', 'postgresql://postgres:postgres@db:5432/postgres/sogoSANITZED_SOGO_USERNAME0020ddd4b66_acl', 'Appointment')
sogo_1 | 2017-06-07 12:24:00.046 sogod[10] PG0x0x55e82d2e1600 SQL: CREATE TABLE sogoSANITZED_SOGO_USERNAME0020ddd4b66 (
sogo_1 | c_name VARCHAR (255) PRIMARY KEY,
sogo_1 | c_content TEXT NOT NULL,
sogo_1 | c_creationdate INT4 NOT NULL,
sogo_1 | c_lastmodified INT4 NOT NULL,
sogo_1 | c_version INT4 NOT NULL,
sogo_1 | c_deleted INT4 NULL
sogo_1 | )
sogo_1 | 2017-06-07 12:24:00.414 sogod[10] PG0x0x55e82d2e1600 SQL: CREATE TABLE sogoSANITZED_SOGO_USERNAME0020ddd4b66_quick (c_name VARCHAR(255) NOT NULL PRIMARY KEY, c_uid VARCHAR(255) NOT NULL, c_startdate INT NULL, c_enddate INT NULL, c_cycleenddate INT NULL, c_title VARCHAR(1000) NOT NULL, c_participants TEXT NULL, c_isallday INT NULL, c_iscycle INT NULL, c_cycleinfo TEXT NULL, c_classification INT NOT NULL, c_isopaque INT NOT NULL, c_status INT NOT NULL, c_priority INT NULL, c_location VARCHAR(255) NULL, c_orgmail VARCHAR(255) NULL, c_partmails TEXT NULL, c_partstates TEXT NULL, c_category VARCHAR(255) NULL, c_sequence INT NULL, c_component VARCHAR(10) NOT NULL, c_nextalarm INT NULL, c_description TEXT NULL)
sogo_1 | 2017-06-07 12:24:00.482 sogod[10] PG0x0x55e82d2e1600 SQL: CREATE TABLE sogoSANITZED_SOGO_USERNAME0020ddd4b66_acl (
sogo_1 | c_uid VARCHAR (255) NOT NULL,
sogo_1 | c_object VARCHAR (255) NOT NULL,
sogo_1 | c_role VARCHAR (80) NOT NULL
sogo_1 | )
sogo_1 | 2017-06-07 12:24:00.515 sogod[10] PG0x0x55e82d2e1600 SQL: COMMIT TRANSACTION
sogo_1 | 2017-06-07 12:24:00.527 sogod[10] PG0x0x55e82d395fa0 SQL: BEGIN TRANSACTION
sogo_1 | 2017-06-07 12:24:00.530 sogod[10] PG0x0x55e82d395fa0 SQL: UPDATE sogo_user_profile SET c_settings = E'{"Calendar": {"FoldersOrder": ["personal", "7-5926FF80-7-DB79270"], "View": "monthview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, "WebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "https:\\/\\/demo.nextcloud.com\\/testforsogo\\/remote.php\\/dav\\/principals\\/users\\/admin\\/"}, "WebCalendarsAuthentication": {"SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "AgAJAAwADgAHAFkADwACAA0AVgBbAFAA"}, "InactiveFolders": [], "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/9-59258300-5-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FB80-1-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FD00-5-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/9-59258A00-B-35BCA000": 1}, "NotifyUserOnPersonalModifications": {}, "PreventInvitationsWhitelist": {}, "EventsSortingState": ["start", "1"], "ListState": "collapse"}, "Contact": {"SortingState": ["c_cn", "1"]}, "Mail": {"ExpandedFolders": ["\\/1"]}}' WHERE c_uid = 'SANITZED_SOGO_USERNAME'
sogo_1 | 2017-06-07 12:24:00.532 sogod[10] PG0x0x55e82d395fa0 SQL: COMMIT TRANSACTION
sogo_1 | 2017-06-07 12:24:00.536 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/7-5926FF80-7-DB79270'
sogo_1 | 2017-06-07 12:24:00.538 sogod[10] PG0x0x55e82d395fa0 SQL: BEGIN TRANSACTION
sogo_1 | 2017-06-07 12:24:00.538 sogod[10] PG0x0x55e82d395fa0 SQL: UPDATE sogo_user_profile SET c_settings = E'{"Calendar": {"FoldersOrder": ["personal", "7-5926FF80-7-DB79270"], "View": "monthview", "FolderColors": {}, "NotifyOnPersonalModifications": {}, "EventsFilterState": "view_next7", "SelectedList": "eventsListView", "FreeBusyExclusions": {}, "WebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/A-5937F080-3-5D390D80": "https:\\/\\/SANITZED_URL\\/owncloud\\/remote.php\\/dav\\/calendars\\/SANITZED\\/-\\/", "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "https:\\/\\/demo.nextcloud.com\\/testforsogo\\/remote.php\\/dav\\/principals\\/users\\/admin\\/"}, "WebCalendarsAuthentication": {"SANITZED_SOGO_USERNAME:Calendar\\/7-5926FF80-7-DB79270": "AgAJAAwADgAHAFkADwACAA0AVgBbAFAA"}, "InactiveFolders": [], "NotifyOnExternalModifications": {}, "AutoReloadedWebCalendars": {"SANITZED_SOGO_USERNAME:Calendar\\/9-59258300-5-35BCA000": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FB80-1-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/7-5926FD00-5-DB79270": 1, "SANITZED_SOGO_USERNAME:Calendar\\/9-59258A00-B-35BCA000": 1}, "NotifyUserOnPersonalModifications": {}, "PreventInvitationsWhitelist": {}, "EventsSortingState": ["start", "1"], "ListState": "collapse"}, "Contact": {"SortingState": ["c_cn", "1"]}, "Mail": {"ExpandedFolders": ["\\/1"]}}' WHERE c_uid = 'SANITZED_SOGO_USERNAME'
sogo_1 | 2017-06-07 12:24:00.538 sogod[10] PG0x0x55e82d395fa0 SQL: COMMIT TRANSACTION
sogo_1 | 2017-06-07 12:24:00.548 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80'
sogo_1 | Jun 07 12:24:00 sogod [10]: |SOGo| request took 0.510405 seconds to execute
nginx_1 | 172.23.0.1 - - [07/Jun/2017:12:24:00 +0000] "POST /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/addWebCalendar HTTP/1.1" 200 44 "http://localhost:8080/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/view"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.35 Safari/537.36" "-"
sogo_1 | Jun 07 12:24:00 sogod [10]: 127.0.0.1 "POST /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/addWebCalendar HTTP/1.1" 200 44/85 0.512 - - 0
sogo_1 | Jun 07 12:24:00 sogod [10]: <0x0x55e82d3aa310[NGHttpRequest]> got 2 values for cookie 'XSRF-TOKEN', using first only: 0c0f1ae0924e311778fde7fb5be4d492af613d8a,7da74187ea82cb0579736bb9df600ad73543fc12
sogo_1 | Jun 07 12:24:00 sogod [10]: |SOGo| starting method 'GET' on uri '/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/reload'
sogo_1 | 2017-06-07 12:24:00.562 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'SANITZED_SOGO_USERNAME' AND c_folder_type = 'Appointment'
sogo_1 | 2017-06-07 12:24:00.563 sogod[10] PG0x0x55e82d2e1600 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/7-5926FF80-7-DB79270'
sogo_1 | 2017-06-07 12:24:00.563 sogod[10] PG0x0x55e82d395fa0 SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80'
sogo_1 | Jun 07 12:24:00 sogod [10]: <0x55e82d3369a0[SOGoWebAppointmentFolder]:A-5937F080-3-5D390D80> Load web calendar https://SANITZED_URL/owncloud/remote.php/dav/calendars/SANITZED/-/ (401)
sogo_1 | Jun 07 12:24:00 sogod [10]: |SOGo| request took 0.180184 seconds to execute
sogo_1 | Jun 07 12:24:00 sogod [10]: [WARN] <0x0x55e82d2ac280[WOHttpTransaction]> response is 401, but no www-authenticate header is set.
nginx_1 | 172.23.0.1 - - [07/Jun/2017:12:24:00 +0000] "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/reload HTTP/1.1" 401 133 "http://localhost:8080/SOGo/so/SANITZED_SOGO_USERNAME/Calendar/view"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.35 Safari/537.36" "-"
sogo_1 | Jun 07 12:24:00 sogod [10]: 127.0.0.1 "GET /SOGo/so/SANITZED_SOGO_USERNAME/Calendar/A-5937F080-3-5D390D80/reload HTTP/1.1" 401 133/0 0.181 - - 0
sogo_1 | PostgreSQL72 connection dropped 0x0x55e82d3b4240 (channel=0x0x55e82d284d00)
sogo_1 | PostgreSQL72 connection dropped 0x0x55e82d37ee70 (channel=0x0x55e82d2e1600)
sogo_1 | PostgreSQL72 connection dropped 0x0x55e82d365a00 (channel=0x0x55e82d395fa0)
