View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004414SOGoWeb Preferencespublic2018-03-06 18:092018-06-28 18:45
ReporterASolana Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityalways
Status assignedResolutionreopened 
PlatformLinuxOSUbuntuOS Version16.04 LTS
Product Version3.2.10 
Summary0004414: Language preferences overridden by selected language in login page
Description

Any selected language o default language on SOGo login page overrides the previously user saved language preferences.

It's annoying for users because they are trusting on their saved preferences and login page selected language is what they get.

The worst thing is they lost their language preference.

Steps To Reproduce

  1. UserA sets English in language preferences

  2. UserA does a log out
    At this point UserA backup file contains "SOGoLanguage = English;"

  3. Login page is configured with French language as default

  4. UserA does a log in without changing default selected language (French) because his saved preferences contains "English"

  5. UserA gets French language overridden his French language preference.
    At this point UserA backup file contains "SOGoLanguage = French;"

TagsNo tags attached.

Activities

ASolana

ASolana

2018-03-06 18:18

reporter   ~0012626

I can reproduce this issue with Firefox 54.0 and Chrome 64.0.3282.186 (64 bits)
francis

francis

2018-03-06 20:30

administrator   ~0012628

I can't reproduce this issue. Have you modified SOGoRootPage.wox?
ASolana

ASolana

2018-03-07 09:12

reporter   ~0012638

I haven't modified SOGoRootPage.wox file

root@sybill1:~# ls -altr /usr/lib/GNUstep/SOGo/Templates/MainUI/SOGoRootPage.wox
-rw-r--r-- 1 root root 7469 Jul 5 2017 /usr/lib/GNUstep/SOGo/Templates/MainUI/SOGoRootPage.wox
root@sybill1:~#
ASolana

ASolana

2018-03-07 09:34

reporter  

20180307.debug.log.changing.language.preference.txt (56,332 bytes)    
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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:12.138 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:12.138 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:12.139 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:12.139 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:12.139 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:12.143 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> SQL: BEGIN;
2018-03-07 10:21:12.143 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:21:12.143 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:21:12.144 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> SQL: COMMIT;
2018-03-07 10:21:12.148 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:21:12.406 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'j.antonio.fernandez';
2018-03-07 10:21:12.407 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:12.407 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'j.antonio.fernandez';
2018-03-07 10:21:12.408 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.091 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> SQL: BEGIN;
2018-03-07 10:21:13.091 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:21:13.091 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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 <albert.petit-ramirez@upcnet.es>)"}, "PreventInvitations": 1, "PreventInvitationsWhitelist": {"usuari.elena2": "Usuari Elena2 <usuari.elena2@upc.edu>"}, "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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:21:13.092 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> SQL: COMMIT;
2018-03-07 10:21:13.104 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.173 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.174 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.184 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.184 sogod[9926] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a83dffa0] connection=0x0x55e2a76683f0>   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: <SOGo[0x0x55e2a7629d30]: name=SOGo>
Mar 07 10:21:13 sogod [9928]: |SOGo| traverse: 
Mar 07 10:21:13 sogod [9928]: |SOGo| set clientObject: <SOGo[0x0x55e2a7629d30]: name=SOGo>
Mar 07 10:21:13 sogod [9925]: [WARN] <0x0x55e2a76ec090[WOContext]> Got no user from authenticator: <SOGoDAVAuthenticator: 0x55e2a79a33a0>
Mar 07 10:21:13 sogod [9928]: [WARN] <0x0x55e2a851e800[WOContext]> Got no user from authenticator: <SOGoDAVAuthenticator: 0x55e2a79a33a0>
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: <SOGo[0x0x55e2a7629d30]: name=SOGo>
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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.743 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.744 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.744 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> SQL: SELECT c_uid, c_object, c_role FROM sogousuariel001391c056e_acl WHERE (c_object = '/usuari.elena2/Calendar/90A3-5A61B500-B-241F8300') AND ((c_uid = '<default>') OR (c_uid LIKE '@%'));
2018-03-07 10:21:13.745 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.745 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.746 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.746 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.748 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.748 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.749 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.749 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.750 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.750 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.752 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.753 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.754 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.754 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:21:13.755 sogod[9928] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a76bb2d0] connection=0x0x55e2a76683f0>   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: <SOGo[0x0x55e2a7629d30]: name=SOGo>
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] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0> SQL: BEGIN;
2018-03-07 10:27:31.571 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:27:31.572 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:31.572 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0> SQL: ROLLBACK;
2018-03-07 10:27:31.572 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:27:31.572 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740> SQL: BEGIN;
2018-03-07 10:27:31.572 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740>   query has no results.
2018-03-07 10:27:31.572 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740> 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] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740>   query has no results.
2018-03-07 10:27:31.573 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740> SQL: COMMIT;
2018-03-07 10:27:31.577 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740>   query has no results.
2018-03-07 10:27:31.580 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0> SQL: BEGIN;
2018-03-07 10:27:31.581 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:27:31.582 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:27:31.582 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0> SQL: COMMIT;
2018-03-07 10:27:31.588 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0>   query has no results.
2018-03-07 10:27:31.589 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'usuari.ana';
2018-03-07 10:27:31.594 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740>   query has results, entering fetch-mode.
2018-03-07 10:27:31.594 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:31.595 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740> 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] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740>   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] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'j.antonio.fernandez';
2018-03-07 10:27:32.850 sogod[9925] <MySQL4Channel[0x0x55e2a8212750] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:32.850 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740> SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'j.antonio.fernandez';
2018-03-07 10:27:32.851 sogod[9925] <MySQL4Channel[0x0x55e2a8357fc0] connection=0x0x55e2a863b740>   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: <SOGo[0x0x55e2a7629d30]: name=SOGo>
Mar 07 10:27:33 sogod [9928]: |SOGo| traverse: 
Mar 07 10:27:33 sogod [9928]: |SOGo| set clientObject: <SOGo[0x0x55e2a7629d30]: name=SOGo>
Mar 07 10:27:33 sogod [9925]: [WARN] <0x0x55e2a82b7350[WOContext]> Got no user from authenticator: <SOGoDAVAuthenticator: 0x55e2a79a33a0>
Mar 07 10:27:33 sogod [9928]: [WARN] <0x0x55e2a85ae160[WOContext]> Got no user from authenticator: <SOGoDAVAuthenticator: 0x55e2a79a33a0>
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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.570 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.571 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.571 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> SQL: SELECT c_uid, c_object, c_role FROM sogousuariel001391c056e_acl WHERE (c_object = '/usuari.elena2/Calendar/90A3-5A61B500-B-241F8300') AND ((c_uid = '<default>') OR (c_uid LIKE '@%'));
2018-03-07 10:27:33.571 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.572 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.573 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.573 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.574 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.574 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.575 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.575 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.576 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.576 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.579 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.579 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.580 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.580 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   query has results, entering fetch-mode.
2018-03-07 10:27:33.581 sogod[9926] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0> 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] <MySQL4Channel[0x0x55e2a86a25f0] connection=0x0x55e2a76683f0>   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] <MySQL4Channel[0x0x55e2a8103e80] connection=0x0x55e2a8475cb0> SQL: BEGIN;
2018-03-07 10:27:34.600 sogod[9928] <MySQL4Channel[0x0x55e2a8103e80] connection=0x0x55e2a8475cb0>   query has no results.
2018-03-07 10:27:34.600 sogod[9928] <MySQL4Channel[0x0x55e2a8103e80] connection=0x0x55e2a8475cb0> 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 <albert.petit-ramirez@upcnet.es>)"}, "PreventInvitations": 1, "PreventInvitationsWhitelist": {"usuari.elena2": "Usuari Elena2 <usuari.elena2@upc.edu>"}, "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] <MySQL4Channel[0x0x55e2a8103e80] connection=0x0x55e2a8475cb0>   query has no results.
2018-03-07 10:27:34.601 sogod[9928] <MySQL4Channel[0x0x55e2a8103e80] connection=0x0x55e2a8475cb0> SQL: COMMIT;
2018-03-07 10:27:34.605 sogod[9928] <MySQL4Channel[0x0x55e2a8103e80] connection=0x0x55e2a8475cb0>   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: <SOGo[0x0x55e2a7629d30]: name=SOGo>
Mar 07 10:27:35 sogod [9928]: [WARN] <0x0x55e2a8285ff0[WOContext]> Got no user from authenticator: <SOGoDAVAuthenticator: 0x55e2a79a33a0>
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: <SOGo[0x0x55e2a7629d30]: name=SOGo>
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: <SOGo[0x0x55e2a7629d30]: name=SOGo>
Mar 07 10:27:38 sogod [9928]: [WARN] <0x0x55e2a85387f0[WOContext]> Got no user from authenticator: <SOGoDAVAuthenticator: 0x55e2a79a33a0>
Mar 07 10:27:38 sogod [9925]: [WARN] <0x0x55e2a848bf50[WOContext]> Got no user from authenticator: <SOGoDAVAuthenticator: 0x55e2a79a33a0>
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
20180307.debug.log.changing.language.preference.txt (56,332 bytes)   
ASolana

ASolana

2018-03-07 09:50

reporter   ~0012639

I've attached an extract of debug log file named "20180307.debug.log.changing.language.preference.txt" that contains the proof that login page always modifies Language preferences at login time (I've reproduced this issue on test and production servers).

I've activated mysql debug on a test server and then:

  1. I've configured Spanish language to user usuari.ana in preferences and debug file shows an "UPDATE sogo_user_profile " command with "SOGoLanguage": "SpanishSpain". That's correct.

  2. After that, usuari.ana does a logout.

  3. Then usuari.ana does a login again but selecting Catalan language in login page and then debug log file shows an "UPDATE sogo_user_profile command with "SOGoLanguage": "Catalan": this is wrong so that's the proof that login page always modifies user preferences.

I hope it helps you to resolve this issue.
francis

francis

2018-03-07 11:29

administrator   ~0012640

This behaviour is as designed. If the user changes the language on the login page, it will become the user's default language.
ludovic

ludovic

2018-03-13 20:52

administrator   ~0012691

No bug, as designed.
ASolana

ASolana

2018-03-15 10:37

reporter   ~0012707

If this behaviour is as designed then why do you let to choose language on General Preferences?

That's confusing users and they are complaining about this behaviour.

If you keep this behaviour perhaps you would have to remove this language preference.

We would prefer language preference saved by users takes preference over language choosed in login page.
Christian Mack

Christian Mack

2018-03-16 14:15

developer   ~0012732

I think the problem stems from the fact, that the login page automatically always selects the browser language in the language field.
In earlier SOGo versions that field was not set automatically.
Therefore the language chosen by setting the language in Preferences from the user was used on login.

The browser language should only be used, if the user didn't set any language before and didn't select a language in the login page.
Else when using computers, which do not belong to you, you will always get the language the admin set for the Browser you use, instead of your preferred language.
francis

francis

2018-03-19 13:04

administrator   ~0012782

This is not true.

The login page uses the language of the browser if it is in the SOGoSupportedLanguages parameter. Otherwise it will fallback to the SOGoLanguage parameter.

If you don't manually change the language on the login page, the interface will use the user's language once authenticated.
ASolana

ASolana

2018-03-20 17:41

reporter   ~0012790

You said "If you don't manually change the language on the login page, the interface will use the user's language once authenticated."

I haven't noticed this behaviour in my tests.

In fact, in login page there's no option to left language blank, there is always a language selected

My Sogo server uses SOGoSupportedLanguages by default, so it supports all languages, sometimes I tried to force SOGoLanguage too, but always login page won.

My tests always show that login page language, whatever it be, manually chosen o automatically configured from web browser language, always becames the new user language (mysql sogo debug log shows that).

As I said, its a very confusing behaviour for users.
Christian Mack

Christian Mack

2018-04-18 13:28

developer   ~0012849

Just to clarify.
In SOGo V2 + V3 the language set by browser will always set the preferred language of the user upon login.

In SOGo V4 the behaviour is as francis described.
isibaar

isibaar

2018-06-28 18:45

reporter   ~0012931

I have the same problem than the original reporter (and I'm using SOGo 4.0). And I think too that this is a bug. If this is working as designed, then the design is flawed.

The problem is that the user has no way of setting a language preference that would override the language of the browser. The login form always preselects the language of the browser from the language dropdown. And when the user then logs on without changing the pre-selected language, he will get this language even if he had previously configured a different language preference in the SOGo settings.

So, in short: If a user wants a different language than his browser's language, he needs to manually select this every time when logging in. Or his administrator would have to remove all other languages for everyone (via the SOGoSupportedLanguages parameter) to make another language than the browser language the pre-selected language in the login form.

Like others have pointed out too, I think it is common that people may have a different SOGo language preference than is the browser language. So there should be a way that the user's "globally" configured language preference in the SOGo general settings dialog overrides the automatically preselected language in the login form.

So in the SOGo general settings, there should e.g. be a checkbox "Always use this language" and when it's checked the chosen language will be kept even when the user next time logs in with a different language chosen in the login form.

Or there should be an additional entry in the language dropdown "As chosen on login form", which is the default (and matches the current behavior). But when the user then explicitely selects a language preference in the general settings, then this should always take precedence over what's chosen on the login form.

Another (but I think less good) possibility would be to add a new parameter that allows to disable the automatic language pre-selection based on the browser language (SOGoLanguage should be always pre-selected then). Or the user's language preference as set in general settings is stored in a cookie and this - if present - takes precedence over the browser language when preselecting the language on the login form.

Issue History

Date Modified Username Field Change
2018-03-06 18:09 ASolana New Issue
2018-03-06 18:18 ASolana Note Added: 0012626
2018-03-06 20:30 francis Note Added: 0012628
2018-03-07 09:12 ASolana Note Added: 0012638
2018-03-07 09:34 ASolana File Added: 20180307.debug.log.changing.language.preference.txt
2018-03-07 09:50 ASolana Note Added: 0012639
2018-03-07 11:29 francis Note Added: 0012640
2018-03-13 20:52 ludovic Note Added: 0012691
2018-03-13 20:52 ludovic Status new => resolved
2018-03-13 20:52 ludovic Resolution open => no change required
2018-03-13 20:52 ludovic Assigned To => ludovic
2018-03-15 10:37 ASolana Note Added: 0012707
2018-03-15 10:37 ASolana Status resolved => feedback
2018-03-15 10:37 ASolana Resolution no change required => reopened
2018-03-16 14:15 Christian Mack Note Added: 0012732
2018-03-19 13:04 francis Note Added: 0012782
2018-03-20 17:41 ASolana Note Added: 0012790
2018-03-20 17:41 ASolana Status feedback => assigned
2018-04-18 13:28 Christian Mack Note Added: 0012849
2018-06-28 18:45 isibaar Note Added: 0012931