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

    SQL modes

    LAMP
    2
    5
    279
    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.
    • C
      ccfu last edited by

      I know there is a solved topic about this, so forgive me for bringing this up again for a specific use case.

      I am well aware that all apps share the same database and that therefore variable changes in mysql are not possible for one app without impacting all other apps. However, in Cloudron installations where all of the apps need the exact same SQL mode settings (but not the standard ones) and runtime setting is not a feasible option, it would seem reasonable to enable the change on that specific server. The question is: where is the mode set for the mysql version used by the apps and can this be done at one's own risk?

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

        @ccfu this is currently not possible. The main config regenerated into /run/mysql/my.cnf (inside the docker container filesystem) on every service restart to get back to a known state.

        Which variable do you need to change? Maybe some make sense to expose for configuration?

        C 1 Reply Last reply Reply Quote 1
        • C
          ccfu @nebulon last edited by

          @nebulon I thought that might be the case.

          The variable I need to change is 'sql mode' as I need to remove the only_full_group_by and STRICT_TRANS_TABLES for this particular use case.

          I guess the alternative would be to use an external MYSQL database for these apps if there is no other way, but a limited configuration option would be great if doable.

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

            @ccfu I think the risk that users change this for one app and then break others leading to hard-to-debug issues is quite high. Since this is the LAMP app, I assume this is some custom php app and thus maybe there is the option for you to patch the app code to be compatible? Of course since you control the app there using an external MYSQL should always work. Maybe this also plays a bit into the request to add plain database apps.

            C 1 Reply Last reply Reply Quote 1
            • C
              ccfu @nebulon last edited by

              @nebulon I also think plain database apps would be the way to go here. Patching the app code is complicated in this particular case, so for now I I will just go with an external database.

              1 Reply Last reply Reply Quote 1
              • First post
                Last post
              Powered by NodeBB