Hello, Could you put the c_defaults value in a txt or json file? Because with Outlook hard to tell if the line return is in database or from outlook formatting.
Quentin -----Original Message----- From: users-requ...@sogo.nu <users-requ...@sogo.nu> On Behalf Of Bits 'n Tricks Sent: lundi 20 novembre 2023 15:33 To: users@sogo.nu Subject: Re: [SOGo] 501 error Sure: c_uid: info c_defaults: {"SOGoMailLabelsColors":{"$mdnsent":["Ontvangstbewijs verzonden", "#006600"],"$label5":["Later", "#993399"],"$label2":["Werk", "#FF9900"],"$label4":["Te doen", "#3333FF"],"$forwarded":["Forwarded", "#B01FE3"],"$label1":["Belangrijk", "#FF0000"],"$label3":["Persoonlijk", "#009900"]},"SOGoMailAutoSave":"5","SOGoTimeFormat":"%H:%M","SOGoMailAddOutgoingAddresses":0,"SOGoCalendarCategories":["Klant", "Favorieten", "Kwesties", "Meeting", "Projecten", "Status", "Concurrentie", "Cliënten", "Zaken", "Vrije dagen", "Trouwdag", "Vervolggesprek", "Nationale feestdag", "Giften", "Reizen", "Diversen", "Persoonlijk", "Telefoongesprekken", "Verjaardag", "Ideeën", "Leveranciers", "Vakantie"],"SOGoCalendarDefaultReminder":"NONE","SOGoCalendarCategoriesColors":{"Diversen":"#FA016D","Persoonlijk":"#0E197D","Favorieten":"#0396FF","Zaken":"#623AA2","Vrije dagen":"#F55555","Vakantie":"#E80505","Ideeën":"#6018DC","Vervolggesprek":"#9708CC","Giften":"#E96D71","Cliënten":"#9F44D3","Kwesties":"#EA5455","Nationale feestdag":"#736EFE","Telefoongesprekken":"#DE4313","Status":"#F6416C","Klant":"#F8D800","Leveranciers":"#D939CD","Reizen":"#3677FF","Concurrentie":"#28C76F","Projecten":"#32CCBC","Trouwdag":"#8C1BAB","Meeting":"#7367F0","Verjaardag":"#002661"},"SOGoPasswordRecoveryQuestion":"SecretQuestion1","SOGoLoginModule":"Mail","SOGoDayStartTime":"08:00","SOGoCalendarWeekdays":["SU", "MO", "TU", "WE", "TH", "FR", "SA"],"SOGoCalendarTasksDefaultClassification":"PUBLIC","SOGoTimeZone":"GMT+1","SOGoPasswordRecoveryMode":"Disabled","SOGoRefreshViewCheck":"manually","SOGoLanguage":"Dutch","SOGoAnimationMode":"normal","SOGoMailSignaturePlacement":"below","SOGoSelectedAddressBook":"collected","SOGoContactsCategories":["Collega", "Concurrent", "Familie", "Klant", "Leverancier", "Pers", "VIP", "Vriend", "Zakenrelatie"],"SOGoShortDateFormat":"%d-%b-%y","SOGoFirstWeekOfYear":"January1","SOGoDefaultCalendar":"selected","SOGoFirstDayOfWeek":0,"SOGoAlternateAvatar":"none","SOGoTOTPEnabled":0,"SOGoCalendarEventsDefaultClassification":"PUBLIC","SOGoMailComposeMessageType":"html","SOGoGravatarEnabled":0,"SOGoLongDateFormat":"%A, %B %d, %Y","SOGoMailDisplayRemoteInlineImages":"never","SOGoMailAutoMarkAsReadDelay":0,"SOGoMailComposeFontSize":0,"SOGoMailMessageForwarding":"inline","SOGoMailReplyPlacement":"below","SOGoDayEndTime":"18:00"} c_settings: {"Calendar":{"SelectedList":"eventsListView","FoldersOrder":["personal"],"EventsFilterState":"view_next7","EventsSortingState":["start", "1"],"View":"weekview"},"Mail":{"folderForExpunge":"imap://info@localhost/INBOX/"}} --- Met Vriendelijke Groet, Kind Regards, Salutations, Bart Coninckx Bits 'n Tricks On 20/11/2023 08:47, smizr...@alinto.eu wrote: > Can you provide the content of the sogo_user_profile table for the > user when the problem occurs ? > > Sebastien > > Le Samedi, Novembre 18, 2023 17:44 CET, "Bits 'n Tricks" > (i...@bitsandtricks.com) <users@sogo.nu> a écrit: > >> I should add my config: >> >> { >> SOGoProfileURL = >> "mysql://sogo:hidden@localhost:3306/sogo/sogo_user_profile"; >> OCSFolderInfoURL = >> "mysql://sogo:hidden@localhost:3306/sogo/sogo_folder_info"; >> OCSSessionsFolderURL = >> "mysql://sogo:hiddenƒ@localhost:3306/sogo/sogo_sessions_folder"; >> //OCSEMailAlarmsFolderURL = >> "postgresql://sogo:password@127.0.0.1:5432/sogo/sogo_alarms_folder"; >> SOGoLanguage = English; >> SOGoAppointmentSendEMailNotifications = YES; >> SOGoMailingMechanism = smtp; >> SOGoSMTPServer = 127.0.0.1; >> SOGoTimeZone = GMT+1; >> SOGoSentFolderName = Sent; >> SOGoTrashFolderName = Trash; >> SOGoDraftsFolderName = Drafts; >> SOGoIMAPServer = "imap://localhost:143/?tls=NO"; >> SOGoSieveServer = "sieve://localhost:4190/?tls=YES"; >> SOGoIMAPAclConformsToIMAPExt = YES; >> SOGoVacationEnabled = NO; >> SOGoForwardEnabled = NO; >> SOGoSieveScriptsEnabled = NO; >> SOGoFirstDayOfWeek = 0; >> SOGoMailMessageCheck = manually; >> SOGoMailAuxiliaryUserAccountsEnabled = NO; >> SOGoMemcachedHost = 127.0.0.1; >> //SOGoSuperUsernames = (admin); >> SOGoUserSources = >> ( >> { >> type = sql; >> id = users; >> viewURL = "mysql://sogo:hidden@127.0.0.1:3306/sogo/sogo_users"; >> canAuthenticate = YES; >> isAddressBook = NO; >> userPasswordAlgorithm = md5; >> } >> ); >> } >> >> --- >> Met Vriendelijke Groet, >> Kind Regards, >> Salutations, >> >> Bart Coninckx >> Bits 'n Tricks >> >> On 18/11/2023 14:49, Bits 'n Tricks wrote: >>> Hi all, >>> >>> I installed SOGo by means of the packages in Debian 12. I used >> MariaDB >>> (MySQL) as the backend. After a while I get an 501 error and this >> in >>> the log file: >>> >>> 2023-11-18 14:34:47.939 sogod[325593:325593] EXCEPTION: >> <NSException: >>> 0x559f0f4b24a0> NAME:NSInvalidArgumentException >>> REASON:NSDataMalloc(instance) does not recognize isJSONString >>> INFO:(null) >>> Nov 18 14:34:47 sogod [325593]: 81.244.215.185 "POST >>> /SOGo/so/info/Mail/0/folderSent/view HTTP/1.1" 501 0/48 0.022 - - >> 0 - >>> 14 >>> >>> This is temporarily fixed by deleting the user row in >>> sogo_user_profile. >>> >>> Why is this happening and how can I fix it? >>> >>> Cheers!