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","SOGoMail
A ddOutgoingAddresses":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","SOGoCalendarCategor
i
esColors":{"Diversen":"#FA016D","Persoonlijk":"#0E197D","Favorieten":"
#0396FF","Zaken":"#623AA2","Vrije
dagen":"#F55555","Vakantie":"#E80505","Ideeën":"#6018DC","Vervolggesp
r
ek":"#9708CC","Giften":"#E96D71","Cliënten":"#9F44D3","Kwesties":"#EA
5
455","Nationale
feestdag":"#736EFE","Telefoongesprekken":"#DE4313","Status":"#F6416C"
,
"Klant":"#F8D800","Leveranciers":"#D939CD","Reizen":"#3677FF","Concur
r
entie":"#28C76F","Projecten":"#32CCBC","Trouwdag":"#8C1BAB","Meeting":
"#7367F0","Verjaardag":"#002661"},"SOGoPasswordRecoveryQuestion":"Sec
r
etQuestion1","SOGoLoginModule":"Mail","SOGoDayStartTime":"08:00","SOG
o
CalendarWeekdays":["SU",
"MO", "TU", "WE", "TH", "FR",
"SA"],"SOGoCalendarTasksDefaultClassification":"PUBLIC","SOGoTimeZone"
:"GMT+1","SOGoPasswordRecoveryMode":"Disabled","SOGoRefreshViewCheck":
"manually","SOGoLanguage":"Dutch","SOGoAnimationMode":"normal","SOGoM
a
ilSignaturePlacement":"below","SOGoSelectedAddressBook":"collected","
S
OGoContactsCategories":["Collega",
"Concurrent", "Familie", "Klant", "Leverancier", "Pers", "VIP",
"Vriend",
"Zakenrelatie"],"SOGoShortDateFormat":"%d-%b-%y","SOGoFirstWeekOfYear"
:"January1","SOGoDefaultCalendar":"selected","SOGoFirstDayOfWeek":0,"
S
OGoAlternateAvatar":"none","SOGoTOTPEnabled":0,"SOGoCalendarEventsDef
a
ultClassification":"PUBLIC","SOGoMailComposeMessageType":"html","SOGo
G ravatarEnabled":0,"SOGoLongDateFormat":"%A,
%B %d,
%Y","SOGoMailDisplayRemoteInlineImages":"never","SOGoMailAutoMarkAsRe
a
dDelay":0,"SOGoMailComposeFontSize":0,"SOGoMailMessageForwarding":"in
l ine","SOGoMailReplyPlacement":"below","SOGoDayEndTime":"18:00"}
c_settings:
{"Calendar":{"SelectedList":"eventsListView","FoldersOrder":["persona
l "],"EventsFilterState":"view_next7","EventsSortingState":["start",
"1"],"View":"weekview"},"Mail":{"folderForExpunge":"imap://info@local
h
ost/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!