Hello :)
SOGo 5.9 installed from sources, RockyLinux9
SOGo kicks users after 5 min. of inactivity. The error notice apperars
in the log:
Nov 03 09:22:55 sogod [1682]: [ERROR] <...[GCSSessionsFolder]>
-[GCSSessionsFolder
writeRecordForEntryWithID:value:creationDate:lastSeenDate:]: cannot
write record: <MySQL4Exception: ...> NAME:ExecutionFailed REASON:Data
too long for column 'c_value' at row 1
There is the database scheme in Scripts/mysql-utf8mb4.sql:
CREATE TABLE sogo_sessions_folder (
c_id varchar(255) NOT NULL,
c_value varchar(255) NOT NULL,
c_creationdate int(11) NOT NULL,
c_lastseen int(11) NOT NULL,
PRIMARY KEY (c_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
I've increased c_value to varchar(4096), it solved the problem, and the
data stored in c_value is 2100 bytes long.
Is it the mistake in the instalation script or something went wrong
while compilation process?
Boguslaw Juza