SQL modes

[ccfu]

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]

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

[ccfu]

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

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

[ccfu]

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