Re: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'
Hi,
The comment from Scripts/mysql-utf8mb4.sql, from Sogo 5.9 dist:
-- This schema includes some specific table creation
-- parameters needed for complete Unicode coverage
-- (required for emoji character support, for instance).
--
-- Note: SOGo automagically creates those tables on start,
-- but *without* full Unicode compliance. So this schema
-- must be imported before SOGo runs for the first time.
That's true, that SOGo could create this table dynamically,
but there were problems with national characters in names.
So I've found this file and run it before SOGo first run.
Boguslaw Juza
W dniu 3.11.2023 o 11:21, qhivert (qhiv...@alinto.eu) pisze:
Hello,
Well, I don't know how exactly you build sogo but sogo create dynamically the
table with correct length. Look for:
- (NSString *) createSessionsFolderWithName: (NSString *) tableName
{
static NSString *sqlFolderFormat
= (@"CREATE TABLE %@ ("
@" c_id VARCHAR(255) PRIMARY KEY,"
@" c_value VARCHAR(4096) NOT NULL,"
@" c_creationdate INT NOT NULL,"
@" c_lastseen INT NOT NULL)");
return [NSString stringWithFormat: sqlFolderFormat, tableName];
}
Once sogo is build, you don't need to run any script concerning the database
except if an older version of sogo was previously used.
Quentij
-Original Message-
From: users-requ...@sogo.nu On Behalf Of Boguslaw Juza
Sent: vendredi 3 novembre 2023 09:39
To: users@sogo.nu
Subject: [SOGo] GCSSessionsFolder - Data too long for column 'c_value'
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:
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_valuevarchar(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
[SOGo] GCSSessionsFolder - Data too long for column 'c_value'
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: 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_valuevarchar(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
[SOGo] How to change palette
Hello, There are three color templates in the file WebServerResources/js/Common/Common.app.js. 'sogo-green', 'sogo-blue', 'sogo-grey'. How to set it? There is no any option to change from 'sogo-green' to 'sogo-blue'. Boguslaw Juza
Re: [SOGo] SOGo 5.9.0 could not load product
W dniu 8.10.2023 o 09:37, Bogusław Juza pisze: Additional information appears, when SOGo is going down: Error (objc-load):/usr/local/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: TNEFParseMemory I've added "-lytnef" in BUNDLE_LIBS in file SOGo-5.9.0/SoObjects/Mailer/GNUmakefile.preamble It resolved the issue. Bogusław Juza
Re: [SOGo] SOGo 5.9.0 could not load product
W dniu 8.10.2023 o 08:54, Bogusław Juza pisze: Fresh instalation of SOGo 5.9.0 from sources, RockyLinux 9.2. When runned, these lines appeared in the log: sogod [1712]: [so-product-registry] could not load product: MailPartViewers sogod [1712]: [ERROR] [so-product-registry] failed to load product MailPartViewers required by MailerUI. sogod [1712]: [so-product-registry] could not load product: MailerUI sogod [1712]: [so-product-registry] could not load product: PreferencesUI How to debug it? Additional information appears, when SOGo is going down: Error (objc-load):/usr/local/lib64/GNUstep/SOGo/Mailer.SOGo/Mailer: undefined symbol: TNEFParseMemory Error (objc-load):/usr/local/lib64/GNUstep/SOGo/MailPartViewers.SOGo/MailPartViewers: undefined symbol: __objc_class_name_SOGoMailBodyPart Error (objc-load):/usr/local/lib64/GNUstep/SOGo/PreferencesUI.SOGo/PreferencesUI: undefined symbol: __objc_class_name_SOGoMailLabel Error (objc-load):/usr/local/lib64/GNUstep/SOGo/MailerUI.SOGo/MailerUI: undefined symbol: __objc_class_name_SOGoMailLabel Bogusław Juza
[SOGo] SOGo 5.9.0 could not load product
Hello, Fresh instalation of SOGo 5.9.0 from sources, RockyLinux 9.2. When runned, these lines appeared in the log: sogod [1712]: [so-product-registry] could not load product: MailPartViewers sogod [1712]: [ERROR] [so-product-registry] failed to load product MailPartViewers required by MailerUI. sogod [1712]: [so-product-registry] could not load product: MailerUI sogod [1712]: [so-product-registry] could not load product: PreferencesUI How to debug it? Bogusław Juza
[SOGo] SOGO 2.4.3 - password change fails
HI!
In the latest SOGo v2 (2.4.3) password change option doesn't work.
There is code in file WebServerResources/UIxPreferences.js:
...
else if (password.length > 0) {
var loginValues = readLoginCookie();
var policy = new PasswordPolicy(loginValues[0],
loginValues[1]);
...
but the function "readLoginCookie()" was removed from file
WebServerResources/generic.js.
The code from version 2.3.23:
function readLoginCookie() {
var loginValues = null;
var cookie = readCookie("0xHIGHFLYxSOGo");
if (cookie && cookie.length > 8) {
var value = decodeURIComponent(cookie.substr(8));
loginValues = value.base64decode().split(":");
}
return loginValues;
}
But when I have copied this code to SOGo 2.4.3, it still haven't
worked. Do anybody has any idea, how to repair this issue?
Bogusław Juza
