Installing Webmail App leading to `Database Error - ER_DATA_TOO_LONG: Data too long for column 'value' at row 8`
-
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 allsub.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')"
-
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
-
@brutalbirdie Ah, I see
CLOUDRON_MAIL_DOMAINS
overflow. -
@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.
-
In case someone wants to see how this gets fixed.
https://git.cloudron.io/cloudron/box/-/commit/449220eca130f37dd2d094070ab44713633eba9b
-
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 this was not pulled into v6.3.6 yet but is part of the coming release.
-
-