Read-Only for Changing MySQL lower_case_table_names variable

I have installed Nethserver 6.8, activate MySQL and install phpmyadmin from NethForge. When I try to change the variable lower_case_table_names value from 0 to1 under variables tab. I get the following error.

I try to add the setting lower_case_table_names = 1 in my.cnf but according remark stated in the file, it is maintained by Nethserver, any manual changes in the file will be overwritten.

May I know is there anyway I can change this variable’s value? Please help.

If there is any mysql database, read the mysql manual before proceeding.

To set the lower_case_table_names variable you can create a custom template.

What the code does is to copy the my.cnf fragment used by NethServer, which contains the [mysqld] section, to a custom template that you can edit while preserving the changes.

mkdir -p /etc/e-smith/templates-custom/etc/my.cnf/
cp /etc/e-smith/templates/etc/my.cnf/10base /etc/e-smith/templates-custom/etc/my.cnf/

Edit the custom template fragment (add the desired variable). You can replace vi with your preferred text editor:

vi /etc/e-smith/templates-custom/etc/my.cnf/10base

Save the changes:

signal-event nethserver-mysql-save