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

Reply via email to