Solved Installing Webmail App leading to `Database Error - ER_DATA_TOO_LONG: Data too long for column 'value' at row 8`

[BrutalBirdie]

When installing Rainloop, Sogo or Roundcube I get this error - Database Error - ER_DATA_TOO_LONG: Data too long for column 'value' at row 8

Here are the full install logs - https://paste.cloudron.dev/deserarabi.pl

I assume I simply have to many domains.
48 Domains with each Mailboxes enabled and each 2-5 Mailboxes.

And the resulting SQL leads to this error:
Yes they are all sub.domain.tld for GDPR reasons.

    sql: "INSERT INTO appAddonConfigs(appId, addonId, name, value) VALUES ('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_SMTP_SERVER', 'mail'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_SMTP_PORT', '2525'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_IMAP_SERVER', 'mail'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_IMAP_PORT', '9993'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_SIEVE_SERVER', 'mail'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_SIEVE_PORT', '4190'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_DOMAIN', 'domain.tld'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_DOMAINS', 'sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld,sub.domain.tld'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_MAIL_SERVER_HOST', 'my.domain.tld.cloudron.dev'),('29cba863-b633-454a-92a3-7f3965f4986f', 'email', 'CLOUDRON_LDAP_MAILBOXES_BASE_DN', 'ou=mailboxes,dc=cloudron')"

[BrutalBirdie]

Looking into the box.mysqldump

DROP TABLE IF EXISTS `appAddonConfigs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `appAddonConfigs` (
`appId` varchar(128) COLLATE utf8_bin NOT NULL,
`addonId` varchar(32) COLLATE utf8_bin NOT NULL,
`value` varchar(512) COLLATE utf8_bin NOT NULL,
`name` varchar(128) COLLATE utf8_bin DEFAULT NULL,
KEY `appId` (`appId`),
CONSTRAINT `appAddonConfigs_ibfk_1` FOREIGN KEY (`appId`) REFERENCES `apps` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

`value` varchar(512)

Is simply to short for this amount of domains

[girish]

@brutalbirdie Ah, I see CLOUDRON_MAIL_DOMAINS overflow.

[girish]

@brutalbirdie OK, I have fixed it for next release. A temporary workaround is to comment out this line which adds the CLOUDRON_MAIL_DOMAINS - https://git.cloudron.io/cloudron/box/-/blob/master/src/services.js#L1016 . With that line commented out, you cannot use rainloop since that app uses that env var. SOGo and Roundcube should work.

[BrutalBirdie]

In case someone wants to see how this gets fixed.

https://git.cloudron.io/cloudron/box/-/commit/449220eca130f37dd2d094070ab44713633eba9b

[girish]

As a heads up, you cannot apply the change on your server because it's a migration script which is only run before an update. You should also not alter the database on the server because the migration script will then fail during next cloudron update.

[BrutalBirdie]

@girish Did this fix already get deployed?

[nebulon]

@brutalbirdie this was not pulled into v6.3.6 yet but is part of the coming release.

[BrutalBirdie]

@nebulon Thanks