Can't override my.cnf, reverting after restart

trueicecold

Hey all,

Whenever I try to edit sql_mode to remove ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES from it, it's saved ok, but after a restart the default value of "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" keeps coming back...

Has anyone encountered this?

trueicecold

It works only if I edit the my.cnf file inside Indigo.app Services directory, but I assumed it should have merged the original with the stack config?

Indigo

Hi @trueicecold — thanks for your post & welcome to the forums 🙂

As you astutely discovered, Indigo clones in a fresh copy of the config files from their source inside the Indigo.app bundle every time you start a stack. However, it also checks your stack file (which is also a bundle) and clones it from there instead if it finds one. This allows you to override any service config (or indeed any service file even including the binary itself).

Indigo's override mechanism could certainly be easier to use, and I have a few ideas I'm keen to implement at some point. Until then, the method is as described here.

Let me know how you go!

trueicecold

Thanks a lot, copying the mysql folder and changing it to mysql_XXXX, editing the conf file inside did the trick 🙂

Indigo

Great, glad to hear it worked! 🙂

Just one thing... I'm not sure if you've copied the entire mysql folder with all its contents, but just to clarify, you only want to copy the conf file that you intend to change, and put it in a folder hierarchy so when it's merged in it overwrites the original. You shouldn't copy over any other files unless you want them overridden as well.

trueicecold

Sorry, Should have made it clearer, created mysql_XXXX/conf, and copied my.cnf there 🙂

Indigo

Perfect 👍