Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

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

    Support
    mail
    3
    9
    394
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • BrutalBirdie
      BrutalBirdie Staff last edited by girish

      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')"
      

      Like my work? Consider donating a beer 🍻 Cheers!

      BrutalBirdie 1 Reply Last reply Reply Quote 0
      • BrutalBirdie
        BrutalBirdie Staff @BrutalBirdie last edited by

        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 😬

        Like my work? Consider donating a beer 🍻 Cheers!

        girish BrutalBirdie 3 Replies Last reply Reply Quote 0
        • girish
          girish Staff @BrutalBirdie last edited by

          @brutalbirdie Ah, I see CLOUDRON_MAIL_DOMAINS overflow.

          1 Reply Last reply Reply Quote 1
          • girish
            girish Staff @BrutalBirdie last edited by

            @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.

            1 Reply Last reply Reply Quote 2
            • BrutalBirdie
              BrutalBirdie Staff @BrutalBirdie last edited by

              In case someone wants to see how this gets fixed.

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

              Like my work? Consider donating a beer 🍻 Cheers!

              1 Reply Last reply Reply Quote 1
              • girish
                girish Staff last edited by

                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 1 Reply Last reply Reply Quote 1
                • BrutalBirdie
                  BrutalBirdie Staff @girish last edited by

                  @girish Did this fix already get deployed?

                  Like my work? Consider donating a beer 🍻 Cheers!

                  nebulon 1 Reply Last reply Reply Quote 0
                  • nebulon
                    nebulon Staff @BrutalBirdie last edited by

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

                    BrutalBirdie 1 Reply Last reply Reply Quote 1
                    • BrutalBirdie
                      BrutalBirdie Staff @nebulon last edited by

                      @nebulon Thanks 👍

                      Like my work? Consider donating a beer 🍻 Cheers!

                      1 Reply Last reply Reply Quote 0
                      • Referenced by  BrutalBirdie BrutalBirdie 
                      • Referenced by  BrutalBirdie BrutalBirdie 
                      • First post
                        Last post
                      Powered by NodeBB