1. User usuari.ana changes her preferences language to SpanishSpain: Mar 07 10:21:12 sogod [9926]: |SOGo| starting method 'POST' on uri '/SOGo/so/usuari.ana/Preferences/save' Mar 07 10:21:12 sogod [9926]: |SOGo| traverse(acquire): usuari.ana => Preferences => save Mar 07 10:21:12 sogod [9926]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:21:12 sogod [9926]: |SOGo| do traverse name: 'Preferences' Mar 07 10:21:12 sogod [9926]: |SOGo| do traverse name: 'save' Mar 07 10:21:12 sogod [9926]: |SOGo| set clientObject: <0x0x55e2a78dcc70[SoPageInvocation]: class=UIxPreferences product=<0x0x55e2a78cfcd0[SoProduct]: loaded code-loaded bundle=/usr/lib/GNUstep/SOGo/PreferencesUI.SOGo #categories=1 rm=0x0x55e2a78d19a0>> 2018-03-07 10:21:12.138 sogod[9926] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'usuari.ana' AND c_folder_type = 'Contact'; 2018-03-07 10:21:12.138 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:12.138 sogod[9926] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'usuari.ana' AND c_folder_type = 'Contact'; 2018-03-07 10:21:12.138 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:12.138 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Contacts/contacts~sToUJ-75UskBsCz9ilaFk6p'; 2018-03-07 10:21:12.139 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:12.139 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Contacts/contacts~personal_ldap'; 2018-03-07 10:21:12.139 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:12.139 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Contacts/contacts~favourites'; 2018-03-07 10:21:12.139 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:12.139 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Contacts/personal'; 2018-03-07 10:21:12.139 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:12.143 sogod[9926] SQL: BEGIN; 2018-03-07 10:21:12.143 sogod[9926] query has no results. 2018-03-07 10:21:12.143 sogod[9926] SQL: UPDATE sogo_user_profile SET c_defaults = '{"SOGoMailSynchronizeOnlyDefaultFolders": 1, "SOGoMailReceiptNonRecipientAction": "ignore", "SOGoMailAutoSave": 5, "SOGoMailLabelsColors": {"$label5": ["Més tard", "#993399"], "$label2": ["Feina", "#FF9900"], "$label4": ["Per fer", "#3333FF"], "$label1": ["Important", "#FF0000"], "$label3": ["Personal", "#009900"]}, "SOGoTimeFormat": "%H:%M", "SOGoAppointmentSendEMailNotifications": 1, "SOGoMailAddOutgoingAddresses": 0, "SOGoCalendarCategories": ["Feina", "Telefonades", "Favorits", "Reunió", "Idees", "Altres", "Natalici", "Aniversari", "Vacances", "Viatges", "Projectes", "Proveïdors", "Regals", "Clients", "Assumptes", "Negocis", "Festes", "Personal", "Estat", "Competició", "Seguiment", "Vacances públiques"], "SOGoCalendarDefaultReminder": "NONE", "SOGoCalendarCategoriesColors": {"Idees": "#CCCCCC", "Vacances": "#CCCCCC", "Feina": "#CCCCCC", "Personal": "#CCCCCC", "Altres": "#CCCCCC", "Reunió": "#CCCCCC", "Festes": "#CCCCCC", "Regals": "#CCCCCC", "Viatges": "#CCCCCC", "Telefonades": "#FFCC33", "Estat": "#CCCCCC", "Negocis": "#CCCCCC", "Natalici": "#CCCCCC", "Projectes": "#CCCCCC", "Vacances públiques": "#CCCCCC", "Clients": "#CCCCCC", "Proveïdors": "#CCCCCC", "Assumptes": "#CCCCCC", "Aniversari": "#CCCCCC", "Competició": "#CCCCCC", "Favorits": "#CCCCCC", "Seguiment": "#CCCCCC"}, "SOGoMailReceiptOutsideDomainAction": "ignore", "SOGoRememberLastModule": 0, "SOGoMailReceiptAnyAction": "ignore", "SOGoLoginModule": "Mail", "SOGoSieveFilters": [{"actions": [{"argument": "INBOX", "method": "fileinto"}], "name": "filtre1", "rules": [{"field": "subject", "operator": "contains", "value": "testXXXXXXXXX"}], "match": "all", "active": 1}], "Vacation": {"daysBetweenResponse": 7, "autoReplyEmailAddresses": ["usuari.ana@upcnet.es"], "enabled": 1, "customSubject": "No estic a l\'oficina", "endDate": 0, "autoReplyText": "No estic a l\'oficina durant una bona temporada...", "alwaysSend": 1, "ignoreLists": 1, "discardMails": 1, "startDate": 0, "customSubjectEnabled": 1}, "SOGoDayStartTime": "08:00", "SOGoCalendarWeekdays": ["MO", "TU", "WE", "TH", "FR", "SU", "SA"], "SOGoCalendarTasksDefaultClassification": "PUBLIC", "SOGoTimeZone": "Europe\\/Madrid", "SOGoMailReceiptAllow": "1", "SOGoRefreshViewCheck": "manually", "SOGoLanguage": "SpanishSpain", "SOGoAnimationMode": "normal", "LocaleCode": "pt_BR", "SOGoMailSignaturePlacement": "below", "SOGoSelectedAddressBook": "personal", "SOGoContactsCategories": [" Business Partner", " Competitor", " Customer", " Family", " Friend", " Press", " Provider", " VIP", "Colleague"], "SOGoShortDateFormat": "%Y-%m-%d", "SOGoFirstWeekOfYear": "January1", "SOGoDefaultCalendar": "selected", "SOGoAlternateAvatar": "none", "SOGoFirstDayOfWeek": 1, "SOGoCalendarEventsDefaultClassification": "PUBLIC", "SOGoMailComposeMessageType": "html", "SOGoGravatarEnabled": 0, "SOGoLongDateFormat": "%A, %B %d, %Y", "SOGoMailDisplayRemoteInlineImages": "never", "AuxiliaryMailAccounts": [], "SOGoMailComposeFontSize": 0, "SOGoMailMessageForwarding": "inline", "SOGoMailShowSubscribedFoldersOnly": 0, "SOGoMailReplyPlacement": "below", "SOGoDayEndTime": "18:00", "locale": {"months": ["Janeiro", "Fevereiro", "Março", "Abril", "Maio", "Junho", "Julho", "Agosto", "Setembro", "Outubro", "Novembro", "Dezembro"], "shortMonths": ["Jan", "Fev", "Mar", "Abr", "Mai", "Jun", "Jul", "Ago", "Set", "Out", "Nov", "Dez"], "shortDays": ["Dom", "Seg", "Ter", "Qua", "Qui", "Sex", "Sab"], "days": ["Domingo", "Segunda", "Terça", "Quarta", "Quinta", "Sexta", "Sábado"]}}' WHERE c_uid = 'usuari.ana'; 2018-03-07 10:21:12.144 sogod[9926] query has no results. 2018-03-07 10:21:12.144 sogod[9926] SQL: COMMIT; 2018-03-07 10:21:12.148 sogod[9926] query has no results. 2018-03-07 10:21:12.406 sogod[9926] SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'j.antonio.fernandez'; 2018-03-07 10:21:12.407 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:12.407 sogod[9926] SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'j.antonio.fernandez'; 2018-03-07 10:21:12.408 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:13.091 sogod[9926] SQL: BEGIN; 2018-03-07 10:21:13.091 sogod[9926] query has no results. 2018-03-07 10:21:13.091 sogod[9926] SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar": {"SubscribedFolders": ["albert.petit-ramirez:Calendar\\/personal", "usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300"], "WebCalendars": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": "https:\\/\\/govern.upc.edu\\/ca\\/consell-de-govern\\/consell-de-govern\\/ics_view", "usuari.ana:Calendar\\/8022-5A65DA00-1-66590600": "https:\\/\\/espaitic.upc.edu\\/ca\\/area-tic\\/cotetic\\/reunions-de-seguiment\\/ics_view"}, "FreeBusyExclusions": {"usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": 0, "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": 0, "usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 0, "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": 0, "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": 0, "usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300": 1, "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": 0, "albert.petit-ramirez:Calendar\\/personal": 1, "usuari.ana:Calendar\\/personal": 0}, "EventsFilterState": "view_next7", "NotifyOnPersonalModifications": {"usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": 1, "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": 1, "usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 1, "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": 1, "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": 1, "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": 1, "usuari.ana:Calendar\\/personal": 1}, "FoldersOrder": ["B6FC-5A030700-1-77AADB80", "68D2-5A02F680-19-2F1090C0", "6D2E-5A030200-43-4D1CCE00", "6D31-5A02F580-33-22C6D9C0", "personal", "D1C2-5A2FA980-1-3E892E40", "albert_D_petit-ramirez_personal", "usuari_D_elena2_90A3-5A61B500-B-241F8300", "8022-5A65DA00-1-66590600", "19A5-5A648E00-7-4828728"], "FolderDisplayNames": {"usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300": "fcb-usuari.elena2", "albert.petit-ramirez:Calendar\\/personal": "Calendari personal (Albert Petit Ramirez )"}, "PreventInvitations": 1, "PreventInvitationsWhitelist": {"usuari.elena2": "Usuari Elena2 "}, "TasksSortingState": ["status", "1"], "View": "weekview", "ListState": "collapse", "InactiveFolders": ["albert_D_petit-ramirez_personal", "6D31-5A02F580-33-22C6D9C0", "B6FC-5A030700-1-77AADB80", "68D2-5A02F680-19-2F1090C0", "6D2E-5A030200-43-4D1CCE00", "D1C2-5A2FA980-1-3E892E40"], "AutoReloadedWebCalendars": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 0, "usuari.ana:Calendar\\/6CC2-5A65D580-15-65A73D80": 0}, "FolderSynchronize": {"usuari.ana:Calendar\\/personal": 1}, "NotifyUserOnPersonalModifications": {"usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": 0, "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": 0, "usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 0, "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": 0, "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": 0, "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": 0, "usuari.ana:Calendar\\/personal": 0}, "FolderShowAlarms": {"usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300": 0, "albert.petit-ramirez:Calendar\\/personal": 0}, "TasksFilterState": "view_incomplete", "FolderColors": {"usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": "#66CCCC", "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": "#FF0000", "usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": "#AAAAAA", "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": "#CC0000", "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": "#FF6600", "usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300": "#AAAAAA", "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": "#33CC00", "albert.petit-ramirez:Calendar\\/personal": "#990000", "usuari.elena2:Calendar\\/personal": "#9c27b0", "usuari.ana:Calendar\\/personal": "#FF9900"}, "NotifyOnExternalModifications": {"usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": 1, "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": 1, "usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 1, "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": 1, "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": 1, "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": 1, "usuari.ana:Calendar\\/personal": 1}, "EventsSortingState": ["start", "1"], "SelectedList": "eventsListView"}, "Contact": {"SortingState": ["c_cn", "1"]}, "Mail": {"ExpandedFolders": ["\\/0", "\\/0\\/folderOther_SP_Users"], "DelegateFrom": ["j.antonio.fernandez"], "DelegateTo": ["albert.solana"]}, "ShowCompletedTasks": "0"}' WHERE c_uid = 'usuari.ana'; 2018-03-07 10:21:13.092 sogod[9926] query has no results. 2018-03-07 10:21:13.092 sogod[9926] SQL: COMMIT; 2018-03-07 10:21:13.104 sogod[9926] query has no results. Mar 07 10:21:13 sogod [9926]: |SOGo| request took 0.971773 seconds to execute Mar 07 10:21:13 sogod [9926]: 10.4.198.78, 10.4.206.31 "POST /SOGo/so/usuari.ana/Preferences/save HTTP/1.1" 200 0/8022 0.973 - - 0 Mar 07 10:21:13 sogod [9926]: |SOGo| starting method 'GET' on uri '/SOGo/so/usuari.ana/Preferences' Mar 07 10:21:13 sogod [9926]: |SOGo| traverse(acquire): usuari.ana => Preferences Mar 07 10:21:13 sogod [9926]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:21:13 sogod [9926]: |SOGo| do traverse name: 'Preferences' Mar 07 10:21:13 sogod [9926]: |SOGo| set clientObject: <0x55e2a8666830[SOGoUserFolder]: name=usuari.ana container=0x55e2a7629d30/(null)> Mar 07 10:21:13 sogod [9925]: |SOGo| starting method 'GET' on uri '/SOGo/dav/' 2018-03-07 10:21:13.173 sogod[9926] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'usuari.ana' AND c_folder_type = 'Contact'; 2018-03-07 10:21:13.173 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:13.173 sogod[9926] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'usuari.ana' AND c_folder_type = 'Contact'; 2018-03-07 10:21:13.173 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:13.174 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Contacts/contacts~sToUJ-75UskBsCz9ilaFk6p'; 2018-03-07 10:21:13.174 sogod[9926] query has results, entering fetch-mode. Mar 07 10:21:13 sogod [9928]: |SOGo| starting method 'GET' on uri '/SOGo/dav/' 2018-03-07 10:21:13.183 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Contacts/contacts~personal_ldap'; 2018-03-07 10:21:13.184 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:13.184 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Contacts/contacts~favourites'; 2018-03-07 10:21:13.184 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:21:13.184 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Contacts/personal'; 2018-03-07 10:21:13.184 sogod[9926] query has results, entering fetch-mode. Mar 07 10:21:13 sogod [9926]: |SOGo| request took 0.073091 seconds to execute Mar 07 10:21:13 sogod [9926]: 10.4.198.78, 10.4.206.31 "GET /SOGo/so/usuari.ana/Preferences HTTP/1.1" 200 25457/0 0.076 109822 76% 0 Mar 07 10:21:13 sogod [9925]: |SOGo| traverse: Mar 07 10:21:13 sogod [9925]: |SOGo| set clientObject: Mar 07 10:21:13 sogod [9928]: |SOGo| traverse: Mar 07 10:21:13 sogod [9928]: |SOGo| set clientObject: Mar 07 10:21:13 sogod [9925]: [WARN] <0x0x55e2a76ec090[WOContext]> Got no user from authenticator: Mar 07 10:21:13 sogod [9928]: [WARN] <0x0x55e2a851e800[WOContext]> Got no user from authenticator: Mar 07 10:21:13 sogod [9926]: |SOGo| starting method 'GET' on uri '/SOGo/dav/' Mar 07 10:21:13 sogod [9926]: |SOGo| traverse: Mar 07 10:21:13 sogod [9926]: |SOGo| set clientObject: Mar 07 10:21:13 sogod [9926]: |SOGo| request took 0.000398 seconds to execute Mar 07 10:21:13 sogod [9926]: 127.0.0.1 "GET /SOGo/dav/ HTTP/1.1" 401 0/0 0.001 - - 0 Mar 07 10:21:13 sogod [9925]: |SOGo| request took 0.267905 seconds to execute Mar 07 10:21:13 sogod [9925]: 127.0.0.1 "GET /SOGo/dav/ HTTP/1.1" 401 0/0 0.269 - - 0 Mar 07 10:21:13 sogod [9928]: |SOGo| request took 0.303737 seconds to execute Mar 07 10:21:13 sogod [9928]: 127.0.0.1 "GET /SOGo/dav/ HTTP/1.1" 401 0/0 0.305 - - -192K Mar 07 10:21:13 sogod [9928]: |SOGo| starting method 'GET' on uri '/SOGo/so/usuari.ana/Calendar/alarmslist?browserTime=1520414473' Mar 07 10:21:13 sogod [9928]: |SOGo| traverse(acquire): usuari.ana => Calendar => alarmslist Mar 07 10:21:13 sogod [9928]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:21:13 sogod [9928]: |SOGo| do traverse name: 'Calendar' Mar 07 10:21:13 sogod [9928]: |SOGo| do traverse name: 'alarmslist' 2018-03-07 10:21:13.742 sogod[9928] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'usuari.ana' AND c_folder_type = 'Appointment'; 2018-03-07 10:21:13.742 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.743 sogod[9928] 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 = 'usuari.elena2' AND c_path3 = 'Calendar' AND c_path4 = '90A3-5A61B500-B-241F8300'; 2018-03-07 10:21:13.743 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.744 sogod[9928] SQL: SELECT c_uid, c_object, c_role FROM sogousuariel001391c056e_acl WHERE (c_object = '/usuari.elena2/Calendar/90A3-5A61B500-B-241F8300') AND ((c_uid = 'usuari.ana') OR (c_uid LIKE '@%')); 2018-03-07 10:21:13.744 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.744 sogod[9928] SQL: SELECT c_uid, c_object, c_role FROM sogousuariel001391c056e_acl WHERE (c_object = '/usuari.elena2/Calendar/90A3-5A61B500-B-241F8300') AND ((c_uid = '') OR (c_uid LIKE '@%')); 2018-03-07 10:21:13.745 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.745 sogod[9928] 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 = 'albert.petit-ramirez' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2018-03-07 10:21:13.745 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.746 sogod[9928] SQL: SELECT c_uid, c_object, c_role FROM sogoalbertpe00145416c42_acl WHERE (c_object = '/albert.petit-ramirez/Calendar/personal') AND ((c_uid = 'usuari.ana') OR (c_uid LIKE '@%')); 2018-03-07 10:21:13.746 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.746 sogod[9928] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/6D31-5A02F580-33-22C6D9C0'; 2018-03-07 10:21:13.746 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.748 sogod[9928] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/6D2E-5A030200-43-4D1CCE00'; 2018-03-07 10:21:13.748 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.748 sogod[9928] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/8022-5A65DA00-1-66590600'; 2018-03-07 10:21:13.749 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.749 sogod[9928] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/19A5-5A648E00-7-4828728'; 2018-03-07 10:21:13.749 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.749 sogod[9928] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/B6FC-5A030700-1-77AADB80'; 2018-03-07 10:21:13.750 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.750 sogod[9928] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/D1C2-5A2FA980-1-3E892E40'; 2018-03-07 10:21:13.750 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.750 sogod[9928] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/68D2-5A02F680-19-2F1090C0'; 2018-03-07 10:21:13.750 sogod[9928] query has results, entering fetch-mode. Mar 07 10:21:13 sogod [9928]: |SOGo| set clientObject: <0x55e2a83f19c0[SOGoAppointmentFolders]: name=Calendar container=0x55e2a8533d80/usuari.ana> 2018-03-07 10:21:13.752 sogod[9928] 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 = 'usuari.ana' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2018-03-07 10:21:13.752 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.752 sogod[9928] SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogousuarian0020682464c_quick WHERE (((c_nextalarm <= 1520587273) AND (c_nextalarm >= 1520414473)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1520414473) AND (c_enddate > 1520414473))); 2018-03-07 10:21:13.753 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.753 sogod[9928] 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 = 'usuari.ana' AND c_path3 = 'Calendar' AND c_path4 = '8022-5A65DA00-1-66590600'; 2018-03-07 10:21:13.753 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.754 sogod[9928] SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogousuarian00158359cad_quick WHERE (((c_nextalarm <= 1520587273) AND (c_nextalarm >= 1520414473)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1520414473) AND (c_enddate > 1520414473))); 2018-03-07 10:21:13.754 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.754 sogod[9928] 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 = 'usuari.ana' AND c_path3 = 'Calendar' AND c_path4 = '19A5-5A648E00-7-4828728'; 2018-03-07 10:21:13.754 sogod[9928] query has results, entering fetch-mode. 2018-03-07 10:21:13.755 sogod[9928] SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogousuarian0010dcdac0b_quick WHERE (((c_nextalarm <= 1520587273) AND (c_nextalarm >= 1520414473)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1520414473) AND (c_enddate > 1520414473))); 2018-03-07 10:21:13.755 sogod[9928] query has results, entering fetch-mode. 2. User usuari.ana then does a logout 3. usuari.ana does login again but this time selecting Catalan language in login page: You can see how usuari.ana preferences are updated in mysql DB forcing the change to Catalan language (it had to remains as SpanishSpain) Mar 07 10:27:31 sogod [9925]: |SOGo| starting method 'POST' on uri '/SOGo/connect' Mar 07 10:27:31 sogod [9925]: |SOGo| traverse(acquire): SOGo => connect Mar 07 10:27:31 sogod [9925]: |SOGo| do traverse name: 'SOGo' Mar 07 10:27:31 sogod [9925]: |SOGo| do traverse name: 'connect' Mar 07 10:27:31 sogod [9925]: |SOGo| set clientObject: Mar 07 10:27:31 sogod [9925]: SOGoRootPage successful login from '10.4.198.78, 10.4.206.31' for user 'usuari.ana' - expire = -1 grace = -1 2018-03-07 10:27:31.570 sogod[9925] MySQL4 connection established 0x0x55e2a863b740 2018-03-07 10:27:31.571 sogod[9925] MySQL4 channel 0x0x55e2a8357fc0 opened (connection=0x0x55e2a863b740,sogo) 2018-03-07 10:27:31.571 sogod[9925] MySQL4 connection established 0x0x55e2a76683f0 2018-03-07 10:27:31.571 sogod[9925] MySQL4 channel 0x0x55e2a8212750 opened (connection=0x0x55e2a76683f0,sogo) 2018-03-07 10:27:31.571 sogod[9925] SQL: BEGIN; 2018-03-07 10:27:31.571 sogod[9925] query has no results. 2018-03-07 10:27:31.572 sogod[9925] SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='Wtc8wPzMcRxCSsRqSTcAcQ=='; 2018-03-07 10:27:31.572 sogod[9925] query has results, entering fetch-mode. 2018-03-07 10:27:31.572 sogod[9925] SQL: ROLLBACK; 2018-03-07 10:27:31.572 sogod[9925] query has no results. 2018-03-07 10:27:31.572 sogod[9925] SQL: BEGIN; 2018-03-07 10:27:31.572 sogod[9925] query has no results. 2018-03-07 10:27:31.572 sogod[9925] SQL: INSERT INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, c_id) VALUES (1520414851, 1520414851, 'j4/dRdH4CNP1Aw0vWr6EUaGSnRuklj08nyuC9vnrS9/BP8WAccE1trdSP0B3lEs1ZQyHGYh5tn3GFu2uJLZWmOeG3zzT3goF7wrB+2mlu5EcHmju/Jg2l5vcZQxhwubROkFUQbCxVx9Yj3Lbp3FO3GiyG2fPdh2onYflRTAgz8GOXyeNDpuFnll5/3r2xGwW9knuPYiZhIS7kJDBENaw+g==', 'Wtc8wPzMcRxCSsRqSTcAcQ=='); 2018-03-07 10:27:31.573 sogod[9925] query has no results. 2018-03-07 10:27:31.573 sogod[9925] SQL: COMMIT; 2018-03-07 10:27:31.577 sogod[9925] query has no results. 2018-03-07 10:27:31.580 sogod[9925] SQL: BEGIN; 2018-03-07 10:27:31.581 sogod[9925] query has no results. 2018-03-07 10:27:31.582 sogod[9925] SQL: UPDATE sogo_user_profile SET c_defaults = '{"SOGoMailSynchronizeOnlyDefaultFolders": 1, "SOGoMailReceiptNonRecipientAction": "ignore", "SOGoMailAutoSave": 5, "SOGoMailLabelsColors": {"$label2": ["Feina", "#FF9900"], "$label5": ["Més tard", "#993399"], "$label1": ["Important", "#FF0000"], "$label4": ["Per fer", "#3333FF"], "$label3": ["Personal", "#009900"]}, "SOGoTimeFormat": "%H:%M", "SOGoAppointmentSendEMailNotifications": 1, "SOGoMailAddOutgoingAddresses": 0, "SOGoCalendarCategories": ["Feina", "Telefonades", "Favorits", "Reunió", "Idees", "Altres", "Natalici", "Aniversari", "Vacances", "Viatges", "Projectes", "Proveïdors", "Regals", "Clients", "Assumptes", "Negocis", "Festes", "Personal", "Estat", "Competició", "Seguiment", "Vacances públiques"], "SOGoCalendarDefaultReminder": "NONE", "SOGoCalendarCategoriesColors": {"Idees": "#CCCCCC", "Vacances": "#CCCCCC", "Feina": "#CCCCCC", "Personal": "#CCCCCC", "Reunió": "#CCCCCC", "Altres": "#CCCCCC", "Festes": "#CCCCCC", "Regals": "#CCCCCC", "Viatges": "#CCCCCC", "Telefonades": "#FFCC33", "Estat": "#CCCCCC", "Negocis": "#CCCCCC", "Natalici": "#CCCCCC", "Projectes": "#CCCCCC", "Vacances públiques": "#CCCCCC", "Clients": "#CCCCCC", "Proveïdors": "#CCCCCC", "Assumptes": "#CCCCCC", "Aniversari": "#CCCCCC", "Competició": "#CCCCCC", "Seguiment": "#CCCCCC", "Favorits": "#CCCCCC"}, "SOGoMailReceiptOutsideDomainAction": "ignore", "SOGoRememberLastModule": 0, "SOGoMailReceiptAnyAction": "ignore", "SOGoLoginModule": "Mail", "SOGoSieveFilters": [{"actions": [{"argument": "INBOX", "method": "fileinto"}], "name": "filtre1", "rules": [{"field": "subject", "operator": "contains", "value": "testXXXXXXXXX"}], "match": "all", "active": 1}], "Vacation": {"daysBetweenResponse": 7, "enabled": 1, "autoReplyEmailAddresses": ["usuari.ana@upcnet.es"], "customSubject": "No estic a l\'oficina", "endDate": 0, "autoReplyText": "No estic a l\'oficina durant una bona temporada...", "alwaysSend": 1, "discardMails": 1, "ignoreLists": 1, "customSubjectEnabled": 1, "startDate": 0}, "SOGoDayStartTime": "08:00", "SOGoCalendarWeekdays": ["MO", "TU", "WE", "TH", "FR", "SU", "SA"], "SOGoCalendarTasksDefaultClassification": "PUBLIC", "SOGoTimeZone": "Europe\\/Madrid", "SOGoMailReceiptAllow": "1", "SOGoRefreshViewCheck": "manually", "SOGoLanguage": "Catalan", "SOGoAnimationMode": "normal", "LocaleCode": "pt_BR", "SOGoMailSignaturePlacement": "below", "SOGoSelectedAddressBook": "personal", "SOGoContactsCategories": [" Business Partner", " Competitor", " Customer", " Family", " Friend", " Press", " Provider", " VIP", "Colleague"], "SOGoFirstWeekOfYear": "January1", "SOGoShortDateFormat": "%Y-%m-%d", "SOGoFirstDayOfWeek": 1, "SOGoAlternateAvatar": "none", "SOGoDefaultCalendar": "selected", "SOGoCalendarEventsDefaultClassification": "PUBLIC", "SOGoGravatarEnabled": 0, "SOGoMailComposeMessageType": "html", "SOGoLongDateFormat": "%A, %B %d, %Y", "AuxiliaryMailAccounts": [], "SOGoMailDisplayRemoteInlineImages": "never", "SOGoMailComposeFontSize": 0, "SOGoMailMessageForwarding": "inline", "SOGoDayEndTime": "18:00", "SOGoMailReplyPlacement": "below", "SOGoMailShowSubscribedFoldersOnly": 0, "locale": {"months": ["Janeiro", "Fevereiro", "Março", "Abril", "Maio", "Junho", "Julho", "Agosto", "Setembro", "Outubro", "Novembro", "Dezembro"], "shortMonths": ["Jan", "Fev", "Mar", "Abr", "Mai", "Jun", "Jul", "Ago", "Set", "Out", "Nov", "Dez"], "shortDays": ["Dom", "Seg", "Ter", "Qua", "Qui", "Sex", "Sab"], "days": ["Domingo", "Segunda", "Terça", "Quarta", "Quinta", "Sexta", "Sábado"]}}' WHERE c_uid = 'usuari.ana'; 2018-03-07 10:27:31.582 sogod[9925] query has no results. 2018-03-07 10:27:31.582 sogod[9925] SQL: COMMIT; 2018-03-07 10:27:31.588 sogod[9925] query has no results. 2018-03-07 10:27:31.589 sogod[9925] SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'usuari.ana'; 2018-03-07 10:27:31.594 sogod[9925] query has results, entering fetch-mode. 2018-03-07 10:27:31.594 sogod[9925] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/19A5-5A648E00-7-4828728'; 2018-03-07 10:27:31.595 sogod[9925] query has results, entering fetch-mode. 2018-03-07 10:27:31.595 sogod[9925] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/8022-5A65DA00-1-66590600'; 2018-03-07 10:27:31.595 sogod[9925] query has results, entering fetch-mode. Mar 07 10:27:31 sogod [9925]: |SOGo| request took 0.095373 seconds to execute Mar 07 10:27:31 sogod [9925]: 10.4.198.78, 10.4.206.31 "POST /SOGo/connect HTTP/1.1" 200 47/87 0.096 - - 0 Mar 07 10:27:32 sogod [9925]: |SOGo| starting method 'GET' on uri '/SOGo/so//usuari.ana' Mar 07 10:27:32 sogod [9925]: |SOGo| traverse(acquire): usuari.ana Mar 07 10:27:32 sogod [9925]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:27:32 sogod [9925]: |SOGo| set clientObject: <0x55e2a83a4a30[SOGoUserFolder]: name=usuari.ana container=0x55e2a7629d30/(null)> Mar 07 10:27:32 sogod [9925]: |SOGo| request took 0.001218 seconds to execute Mar 07 10:27:32 sogod [9925]: 10.4.198.78, 10.4.206.31 "GET /SOGo/so//usuari.ana HTTP/1.1" 302 0/0 0.002 - - 0 Mar 07 10:27:32 sogod [9925]: |SOGo| starting method 'GET' on uri '/SOGo/so//usuari.ana/view' Mar 07 10:27:32 sogod [9925]: |SOGo| traverse(acquire): usuari.ana => view Mar 07 10:27:32 sogod [9925]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:27:32 sogod [9925]: |SOGo| do traverse name: 'view' Mar 07 10:27:32 sogod [9925]: |SOGo| set clientObject: <0x55e2a81a97d0[SOGoUserFolder]: name=usuari.ana container=0x55e2a7629d30/(null)> Mar 07 10:27:32 sogod [9925]: |SOGo| request took 0.003590 seconds to execute Mar 07 10:27:32 sogod [9925]: 10.4.198.78, 10.4.206.31 "GET /SOGo/so//usuari.ana/view HTTP/1.1" 302 0/0 0.005 - - 128K Mar 07 10:27:32 sogod [9925]: |SOGo| starting method 'GET' on uri '/SOGo/so/usuari.ana/Mail' Mar 07 10:27:32 sogod [9925]: |SOGo| traverse(acquire): usuari.ana => Mail Mar 07 10:27:32 sogod [9925]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:27:32 sogod [9925]: |SOGo| do traverse name: 'Mail' Mar 07 10:27:32 sogod [9925]: |SOGo| set clientObject: <0x55e2a840ae50[SOGoMailAccounts]: name=Mail container=0x55e2a8220f90/usuari.ana> Mar 07 10:27:32 sogod [9925]: |SOGo| request took 0.001877 seconds to execute Mar 07 10:27:32 sogod [9925]: 10.4.198.78, 10.4.206.31 "GET /SOGo/so/usuari.ana/Mail HTTP/1.1" 302 0/0 0.003 - - 0 Mar 07 10:27:32 sogod [9925]: |SOGo| starting method 'GET' on uri '/SOGo/so/usuari.ana/Mail/view' Mar 07 10:27:32 sogod [9925]: |SOGo| traverse(acquire): usuari.ana => Mail => view Mar 07 10:27:32 sogod [9925]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:27:32 sogod [9925]: |SOGo| do traverse name: 'Mail' Mar 07 10:27:32 sogod [9925]: |SOGo| do traverse name: 'view' Mar 07 10:27:32 sogod [9925]: |SOGo| set clientObject: <0x55e2a7c24f50[SOGoMailAccounts]: name=Mail container=0x55e2a857af20/usuari.ana> 2018-03-07 10:27:32.850 sogod[9925] SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'j.antonio.fernandez'; 2018-03-07 10:27:32.850 sogod[9925] query has results, entering fetch-mode. 2018-03-07 10:27:32.850 sogod[9925] SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'j.antonio.fernandez'; 2018-03-07 10:27:32.851 sogod[9925] query has results, entering fetch-mode. Mar 07 10:27:32 sogod [9925]: |SOGo| request took 0.319579 seconds to execute Mar 07 10:27:32 sogod [9925]: 10.4.198.78, 10.4.206.31 "GET /SOGo/so/usuari.ana/Mail/view HTTP/1.1" 200 20093/0 0.323 77694 74% 0 Mar 07 10:27:33 sogod [9925]: |SOGo| starting method 'GET' on uri '/SOGo/dav/' Mar 07 10:27:33 sogod [9928]: |SOGo| starting method 'GET' on uri '/SOGo/dav/' Mar 07 10:27:33 sogod [9925]: |SOGo| traverse: Mar 07 10:27:33 sogod [9925]: |SOGo| set clientObject: Mar 07 10:27:33 sogod [9928]: |SOGo| traverse: Mar 07 10:27:33 sogod [9928]: |SOGo| set clientObject: Mar 07 10:27:33 sogod [9925]: [WARN] <0x0x55e2a82b7350[WOContext]> Got no user from authenticator: Mar 07 10:27:33 sogod [9928]: [WARN] <0x0x55e2a85ae160[WOContext]> Got no user from authenticator: Mar 07 10:27:33 sogod [9926]: |SOGo| starting method 'GET' on uri '/SOGo/so/usuari.ana/Calendar/alarmslist?browserTime=1520414853' Mar 07 10:27:33 sogod [9926]: |SOGo| traverse(acquire): usuari.ana => Calendar => alarmslist Mar 07 10:27:33 sogod [9926]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:27:33 sogod [9926]: |SOGo| do traverse name: 'Calendar' Mar 07 10:27:33 sogod [9926]: |SOGo| do traverse name: 'alarmslist' 2018-03-07 10:27:33.568 sogod[9926] MySQL4 connection established 0x0x55e2a76683f0 2018-03-07 10:27:33.568 sogod[9926] MySQL4 channel 0x0x55e2a86a25f0 opened (connection=0x0x55e2a76683f0,sogo) 2018-03-07 10:27:33.569 sogod[9926] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'usuari.ana' AND c_folder_type = 'Appointment'; 2018-03-07 10:27:33.569 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.570 sogod[9926] 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 = 'usuari.elena2' AND c_path3 = 'Calendar' AND c_path4 = '90A3-5A61B500-B-241F8300'; 2018-03-07 10:27:33.570 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.571 sogod[9926] SQL: SELECT c_uid, c_object, c_role FROM sogousuariel001391c056e_acl WHERE (c_object = '/usuari.elena2/Calendar/90A3-5A61B500-B-241F8300') AND ((c_uid = 'usuari.ana') OR (c_uid LIKE '@%')); 2018-03-07 10:27:33.571 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.571 sogod[9926] SQL: SELECT c_uid, c_object, c_role FROM sogousuariel001391c056e_acl WHERE (c_object = '/usuari.elena2/Calendar/90A3-5A61B500-B-241F8300') AND ((c_uid = '') OR (c_uid LIKE '@%')); 2018-03-07 10:27:33.571 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.572 sogod[9926] 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 = 'albert.petit-ramirez' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2018-03-07 10:27:33.572 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.573 sogod[9926] SQL: SELECT c_uid, c_object, c_role FROM sogoalbertpe00145416c42_acl WHERE (c_object = '/albert.petit-ramirez/Calendar/personal') AND ((c_uid = 'usuari.ana') OR (c_uid LIKE '@%')); 2018-03-07 10:27:33.573 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.573 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/6D31-5A02F580-33-22C6D9C0'; 2018-03-07 10:27:33.573 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.574 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/6D2E-5A030200-43-4D1CCE00'; 2018-03-07 10:27:33.574 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.574 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/8022-5A65DA00-1-66590600'; 2018-03-07 10:27:33.574 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.575 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/19A5-5A648E00-7-4828728'; 2018-03-07 10:27:33.575 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.575 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/B6FC-5A030700-1-77AADB80'; 2018-03-07 10:27:33.576 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.576 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/D1C2-5A2FA980-1-3E892E40'; 2018-03-07 10:27:33.576 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.576 sogod[9926] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/usuari.ana/Calendar/68D2-5A02F680-19-2F1090C0'; 2018-03-07 10:27:33.576 sogod[9926] query has results, entering fetch-mode. Mar 07 10:27:33 sogod [9926]: |SOGo| set clientObject: <0x55e2a877aae0[SOGoAppointmentFolders]: name=Calendar container=0x55e2a854ba30/usuari.ana> 2018-03-07 10:27:33.578 sogod[9926] 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 = 'usuari.ana' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2018-03-07 10:27:33.578 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.579 sogod[9926] SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogousuarian0020682464c_quick WHERE (((c_nextalarm <= 1520587653) AND (c_nextalarm >= 1520414853)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1520414853) AND (c_enddate > 1520414853))); 2018-03-07 10:27:33.579 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.579 sogod[9926] 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 = 'usuari.ana' AND c_path3 = 'Calendar' AND c_path4 = '8022-5A65DA00-1-66590600'; 2018-03-07 10:27:33.579 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.580 sogod[9926] SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogousuarian00158359cad_quick WHERE (((c_nextalarm <= 1520587653) AND (c_nextalarm >= 1520414853)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1520414853) AND (c_enddate > 1520414853))); 2018-03-07 10:27:33.580 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.580 sogod[9926] 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 = 'usuari.ana' AND c_path3 = 'Calendar' AND c_path4 = '19A5-5A648E00-7-4828728'; 2018-03-07 10:27:33.580 sogod[9926] query has results, entering fetch-mode. 2018-03-07 10:27:33.581 sogod[9926] SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogousuarian0010dcdac0b_quick WHERE (((c_nextalarm <= 1520587653) AND (c_nextalarm >= 1520414853)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1520414853) AND (c_enddate > 1520414853))); 2018-03-07 10:27:33.581 sogod[9926] query has results, entering fetch-mode. Mar 07 10:27:33 sogod [9926]: |SOGo| request took 0.015540 seconds to execute Mar 07 10:27:33 sogod [9926]: 10.4.198.78, 10.4.206.31 "GET /SOGo/so/usuari.ana/Calendar/alarmslist?browserTime=1520414853 HTTP/1.1" 200 63/0 0.017 - - 0 Mar 07 10:27:33 sogod [9928]: |SOGo| request took 0.482350 seconds to execute Mar 07 10:27:33 sogod [9928]: 127.0.0.1 "GET /SOGo/dav/ HTTP/1.1" 401 0/0 0.483 - - 0 Mar 07 10:27:33 sogod [9928]: |SOGo| starting method 'GET' on uri '/SOGo/so/usuari.ana/Mail/0/view' Mar 07 10:27:33 sogod [9928]: |SOGo| traverse(acquire): usuari.ana => Mail => 0 => view Mar 07 10:27:33 sogod [9928]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:27:33 sogod [9928]: |SOGo| do traverse name: 'Mail' Mar 07 10:27:33 sogod [9928]: |SOGo| do traverse name: '0' Mar 07 10:27:33 sogod [9928]: |SOGo| do traverse name: 'view' Mar 07 10:27:33 sogod [9925]: |SOGo| request took 0.538298 seconds to execute Mar 07 10:27:33 sogod [9925]: 127.0.0.1 "GET /SOGo/dav/ HTTP/1.1" 401 0/0 0.539 - - 0 Mar 07 10:27:33 sogod [9928]: |SOGo| set clientObject: <0x55e2a80cb9f0[SOGoMailAccount]: name=0 container=0x55e2a839e0c0/Mail> Mar 07 10:27:34 sogod [9928]: |SOGo| request took 0.640066 seconds to execute Mar 07 10:27:34 sogod [9928]: 10.4.198.78, 10.4.206.31 "GET /SOGo/so/usuari.ana/Mail/0/view HTTP/1.1" 200 4446/0 0.641 - - 0 Mar 07 10:27:34 sogod [9928]: |SOGo| starting method 'POST' on uri '/SOGo/so/usuari.ana/Mail/0/folderINBOX/view' Mar 07 10:27:34 sogod [9928]: |SOGo| traverse(acquire): usuari.ana => Mail => 0 => folderINBOX => view Mar 07 10:27:34 sogod [9928]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:27:34 sogod [9928]: |SOGo| do traverse name: 'Mail' Mar 07 10:27:34 sogod [9928]: |SOGo| do traverse name: '0' Mar 07 10:27:34 sogod [9928]: |SOGo| do traverse name: 'folderINBOX' Mar 07 10:27:34 sogod [9928]: |SOGo| do traverse name: 'view' Mar 07 10:27:34 sogod [9928]: |SOGo| set clientObject: <0x55e2a838db30[SOGoMailFolder]: name=folderINBOX container=0x55e2a866c410/0> 2018-03-07 10:27:34.600 sogod[9928] SQL: BEGIN; 2018-03-07 10:27:34.600 sogod[9928] query has no results. 2018-03-07 10:27:34.600 sogod[9928] SQL: UPDATE sogo_user_profile SET c_settings = '{"Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"SubscribedFolders": ["albert.petit-ramirez:Calendar\\/personal", "usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300"], "WebCalendars": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": "https:\\/\\/govern.upc.edu\\/ca\\/consell-de-govern\\/consell-de-govern\\/ics_view", "usuari.ana:Calendar\\/8022-5A65DA00-1-66590600": "https:\\/\\/espaitic.upc.edu\\/ca\\/area-tic\\/cotetic\\/reunions-de-seguiment\\/ics_view"}, "FreeBusyExclusions": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 0, "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": 0, "usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": 0, "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": 0, "usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300": 1, "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": 0, "albert.petit-ramirez:Calendar\\/personal": 1, "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": 0, "usuari.ana:Calendar\\/personal": 0}, "EventsFilterState": "view_next7", "NotifyOnPersonalModifications": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 1, "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": 1, "usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": 1, "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": 1, "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": 1, "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": 1, "usuari.ana:Calendar\\/personal": 1}, "FoldersOrder": ["B6FC-5A030700-1-77AADB80", "68D2-5A02F680-19-2F1090C0", "6D2E-5A030200-43-4D1CCE00", "6D31-5A02F580-33-22C6D9C0", "personal", "D1C2-5A2FA980-1-3E892E40", "albert_D_petit-ramirez_personal", "usuari_D_elena2_90A3-5A61B500-B-241F8300", "8022-5A65DA00-1-66590600", "19A5-5A648E00-7-4828728"], "FolderDisplayNames": {"usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300": "fcb-usuari.elena2", "albert.petit-ramirez:Calendar\\/personal": "Calendari personal (Albert Petit Ramirez )"}, "PreventInvitations": 1, "PreventInvitationsWhitelist": {"usuari.elena2": "Usuari Elena2 "}, "TasksSortingState": ["status", "1"], "View": "weekview", "ListState": "collapse", "InactiveFolders": ["albert_D_petit-ramirez_personal", "6D31-5A02F580-33-22C6D9C0", "B6FC-5A030700-1-77AADB80", "68D2-5A02F680-19-2F1090C0", "6D2E-5A030200-43-4D1CCE00", "D1C2-5A2FA980-1-3E892E40"], "AutoReloadedWebCalendars": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 0, "usuari.ana:Calendar\\/6CC2-5A65D580-15-65A73D80": 0}, "FolderSynchronize": {"usuari.ana:Calendar\\/personal": 1}, "NotifyUserOnPersonalModifications": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 0, "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": 0, "usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": 0, "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": 0, "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": 0, "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": 0, "usuari.ana:Calendar\\/personal": 0}, "FolderShowAlarms": {"usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300": 0, "albert.petit-ramirez:Calendar\\/personal": 0}, "TasksFilterState": "view_incomplete", "NotifyOnExternalModifications": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": 1, "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": 1, "usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": 1, "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": 1, "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": 1, "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": 1, "usuari.ana:Calendar\\/personal": 1}, "FolderColors": {"usuari.ana:Calendar\\/19A5-5A648E00-7-4828728": "#AAAAAA", "usuari.ana:Calendar\\/6D31-5A02F580-33-22C6D9C0": "#FF0000", "usuari.ana:Calendar\\/68D2-5A02F680-19-2F1090C0": "#66CCCC", "usuari.ana:Calendar\\/D1C2-5A2FA980-1-3E892E40": "#CC0000", "usuari.elena2:Calendar\\/90A3-5A61B500-B-241F8300": "#AAAAAA", "usuari.ana:Calendar\\/B6FC-5A030700-1-77AADB80": "#FF6600", "usuari.elena2:Calendar\\/personal": "#9c27b0", "albert.petit-ramirez:Calendar\\/personal": "#990000", "usuari.ana:Calendar\\/6D2E-5A030200-43-4D1CCE00": "#33CC00", "usuari.ana:Calendar\\/personal": "#FF9900"}, "SelectedList": "eventsListView", "EventsSortingState": ["start", "1"]}, "ShowCompletedTasks": "0", "Mail": {"ExpandedFolders": ["\\/0", "\\/0\\/folderOther_SP_Users"], "DelegateFrom": ["j.antonio.fernandez"], "DelegateTo": ["albert.solana"]}}' WHERE c_uid = 'usuari.ana'; 2018-03-07 10:27:34.601 sogod[9928] query has no results. 2018-03-07 10:27:34.601 sogod[9928] SQL: COMMIT; 2018-03-07 10:27:34.605 sogod[9928] query has no results. Mar 07 10:27:35 sogod [9928]: |SOGo| request took 0.874099 seconds to execute Mar 07 10:27:35 sogod [9928]: 10.4.198.78, 10.4.206.31 "POST /SOGo/so/usuari.ana/Mail/0/folderINBOX/view HTTP/1.1" 200 240072/48 0.876 - - 23M Mar 07 10:27:35 sogod [9928]: |SOGo| starting method 'GET' on uri '/SOGo/dav/' Mar 07 10:27:35 sogod [9928]: |SOGo| traverse: Mar 07 10:27:35 sogod [9928]: |SOGo| set clientObject: Mar 07 10:27:35 sogod [9928]: [WARN] <0x0x55e2a8285ff0[WOContext]> Got no user from authenticator: Mar 07 10:27:35 sogod [9928]: |SOGo| request took 0.485101 seconds to execute Mar 07 10:27:35 sogod [9928]: 127.0.0.1 "GET /SOGo/dav/ HTTP/1.1" 401 0/0 0.486 - - -6984K Mar 07 10:27:35 sogod [9928]: |SOGo| starting method 'POST' on uri '/SOGo/so/usuari.ana/Mail/unseenCount' Mar 07 10:27:35 sogod [9928]: |SOGo| traverse(acquire): usuari.ana => Mail => unseenCount Mar 07 10:27:35 sogod [9928]: |SOGo| do traverse name: 'usuari.ana' Mar 07 10:27:35 sogod [9928]: |SOGo| do traverse name: 'Mail' Mar 07 10:27:35 sogod [9928]: |SOGo| do traverse name: 'unseenCount' Mar 07 10:27:35 sogod [9928]: |SOGo| set clientObject: <0x55e2a859def0[SOGoMailAccounts]: name=Mail container=0x55e2a8521e60/usuari.ana> Mar 07 10:27:36 sogod [9928]: |SOGo| request took 0.471966 seconds to execute Mar 07 10:27:36 sogod [9928]: 10.4.198.78, 10.4.206.31 "POST /SOGo/so/usuari.ana/Mail/unseenCount HTTP/1.1" 200 25/31 0.473 - - 0 Mar 07 10:27:38 sogod [9928]: |SOGo| starting method 'GET' on uri '/SOGo/dav/' Mar 07 10:27:38 sogod [9928]: |SOGo| traverse: Mar 07 10:27:38 sogod [9928]: |SOGo| set clientObject: Mar 07 10:27:38 sogod [9925]: |SOGo| starting method 'GET' on uri '/SOGo/dav/' Mar 07 10:27:38 sogod [9925]: |SOGo| traverse: Mar 07 10:27:38 sogod [9925]: |SOGo| set clientObject: Mar 07 10:27:38 sogod [9928]: [WARN] <0x0x55e2a85387f0[WOContext]> Got no user from authenticator: Mar 07 10:27:38 sogod [9925]: [WARN] <0x0x55e2a848bf50[WOContext]> Got no user from authenticator: Mar 07 10:27:38 sogod [9928]: |SOGo| request took 0.333578 seconds to execute Mar 07 10:27:38 sogod [9928]: 127.0.0.1 "GET /SOGo/dav/ HTTP/1.1" 401 0/0 0.334 - - 0 Mar 07 10:27:38 sogod [9925]: |SOGo| request took 0.522003 seconds to execute Mar 07 10:27:38 sogod [9925]: 127.0.0.1 "GET /SOGo/dav/ HTTP/1.1" 401 0/0 0.523 - - 0