Devilbox: mysql 5.6 cnf file don't work

Created on 6 Sep 2018  路  10Comments  路  Source: cytopia/devilbox

  1. Host operating system: Debian Stretch
  2. Native Docker or Docker Toolbox: Native Docker
  3. Docker version: 18.06.1-ce
  4. Docker Compose version: docker-compose version 1.21.2

SUMMARY

i have created cnf file on /devilbox/cfg/mysql-5.6/devilbox-custom.cnf
this fila contain
[mysqld]
lower_case_table_names=1

seeing mysql info, lower case table name is 0

STEPS TO REPRODUCE

created file, then run docker-compose up -d

bug mysql

Most helpful comment

@manzolo I've reproduced the behaviour and identified the issue: The currently mounted config directory does not evaluate in any of the official MySQL images. The fix will be provided shortly.

CC @jlopezjuy

All 10 comments

im trying to add
command: mysqld --lower_case_table_names=1 --skip-ssl
but not work
i have deleted all docker images and re run docker-compose up, but lowe case table name still on 0

@jlopezjuy I am really stuck on this one. Debian here as well and it works like a charm.
Can you try out a different MySQL version. Are there any other configuration files already present in that directory?

@jlopezjuy did you encounter any errors on file permissions. This file is NOT READ if it has the wrong permissions. See here: https://devilbox.readthedocs.io/en/latest/support/troubleshooting.html#warning-world-writable-config-file-etc-mysql-docker-default-d-my-cnf-is-ignored

Stale issue

This issue was marked with waiting for reply and did not receive an answer for a long time. If the requested information is not provided, it will be auto-closed.

Beep beep, I am a bot - do not reply to me.

I will close this issue as the requested information was not provided and I was unable to reproduce it. Feel free to reply here for re-opening.

With last version (commit 3cbbdb35b0434d7c71ad0e71bd205494c23a96ca)

Host operating system: Ubuntu 18.04
Native Docker or Docker Toolbox: Native Docker
Docker version: Docker version 18.09.3
Docker Compose version: docker-compose version 1.23.2

SUMMARY

i have created cnf file on
/devilbox/cfg/mysql-5.6/lower_case_table_names.cnf
and
/devilbox/cfg/mysql-5.5/lower_case_table_names.cnf
chmod 0444

file contents:
[mysqld]
lower_case_table_names=1

mysql info, lower lower_case_table_names is always 0

@manzolo I've reproduced the behaviour and identified the issue: The currently mounted config directory does not evaluate in any of the official MySQL images. The fix will be provided shortly.

CC @jlopezjuy

Fix will be available today. I've also added regression tests so that this issue won't be able to occur again:
https://github.com/devilbox/docker-mysql/pull/5/files

Fix is merged and available. Update all your MySQL, MariaDB and Percona images.

The next Devilbox Bugfix release will also enforce this new version even though if you haven't explicitly pulled those images.

Has been properly addressed in Release v1.0.1

https://github.com/cytopia/devilbox/releases/tag/v1.0.1

Was this page helpful?
0 / 5 - 0 ratings

Related issues

cytopia picture cytopia  路  4Comments

gowrav-vishwakarma picture gowrav-vishwakarma  路  6Comments

msyhr picture msyhr  路  7Comments

RaffyeMemon picture RaffyeMemon  路  4Comments

drupalshift picture drupalshift  路  5Comments