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!
