0005760: sogo_sessions_folder in DB not updating resulting in sessions expiring rapidly - SOGo

ID	Project	Category	View Status	Date Submitted	Last Update

0005760	SOGo	Backend General	public	2023-04-29 06:44	2023-05-04 09:37

Reporter	perkinma	Assigned To	sebastien
Priority	normal	Severity	minor	Reproducibility	always
Status	resolved	Resolution	no change required
Platform	Rocky Linux	OS Version	8.7
Product Version	5.8.2

Summary	0005760: sogo_sessions_folder in DB not updating resulting in sessions expiring rapidly
Description	SQL error on insert into sogo_sessions_folder results in session table not populating and sessions expiring on next cron run. SQL: INSERT INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, c_id) VALUES (1682747516, 1682747516, 'aV+4...... ....... ti4=', 'CNzDzQQEOOqw4iSp'); ERROR: Data too long for column 'c_value' at row 1 Resolved for me by: ALTER TABLE sogo_sessions_folder MODIFY COLUMN c_value varchar(16383); It looks like this might have been occuring for others as well for a while: https://www.mail-archive.com/users@sogo.nu/msg31272.html https://bugs.sogo.nu/view.php?id=5692 Does there need to be a small tweak to the schema?
Steps To Reproduce	1) Turn on database debugging 2) Log into SOGo 3) insert into session table fails.
Tags	No tags attached.

sebastien 2023-04-29 15:34 administrator ~0016917	If you update, did read 5.6.0 https://www.sogo.nu/files/docs/SOGoInstallationGuide.html#_upgrading ? Sebastien

perkinma 2023-05-04 06:47 reporter ~0016943	Thanks Sebastien you are correct I missed that. My apologies that is most likely the issue thank you for the pointer!

sebastien 2023-05-04 09:37 administrator ~0016945	No problem ;) Sebastien

Date Modified	Username	Field	Change
2023-04-29 06:44	perkinma	New Issue
2023-04-29 15:34	sebastien	Note Added: 0016917
2023-04-29 20:02	sebastien	Assigned To	=> sebastien
2023-04-29 20:02	sebastien	Status	new => feedback
2023-05-04 06:47	perkinma	Note Added: 0016943
2023-05-04 06:47	perkinma	Status	feedback => assigned
2023-05-04 09:37	sebastien	Note Added: 0016945
2023-05-04 09:37	sebastien	Status	assigned => resolved
2023-05-04 09:37	sebastien	Resolution	open => no change required