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