Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql 5.6 cnf file don't work #373

Closed
jlopezjuy opened this issue Sep 6, 2018 · 10 comments
Closed

mysql 5.6 cnf file don't work #373

jlopezjuy opened this issue Sep 6, 2018 · 10 comments
Assignees

Comments

@jlopezjuy
Copy link

  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

@jlopezjuy
Copy link
Author

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

@cytopia cytopia self-assigned this Sep 11, 2018
@cytopia
Copy link
Owner

cytopia commented Sep 11, 2018

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

@cytopia
Copy link
Owner

cytopia commented Nov 1, 2018

@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

@dvlbot
Copy link
Collaborator

dvlbot commented Dec 27, 2018

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.

@dvlbot dvlbot added the issue:stale This issue has become stale and is marked for auto-close label Dec 27, 2018
@cytopia
Copy link
Owner

cytopia commented Dec 29, 2018

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.

@cytopia cytopia closed this as completed Dec 29, 2018
@manzolo
Copy link

manzolo commented Mar 20, 2019

With last version (commit 3cbbdb3)

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

@cytopia cytopia removed issue:stale This issue has become stale and is marked for auto-close waiting for reply labels Mar 22, 2019
@cytopia cytopia reopened this Mar 22, 2019
@cytopia cytopia added the bug label Mar 22, 2019
@cytopia
Copy link
Owner

cytopia commented Mar 22, 2019

@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

@cytopia
Copy link
Owner

cytopia commented Mar 23, 2019

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

@cytopia
Copy link
Owner

cytopia commented Mar 23, 2019

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.

@cytopia
Copy link
Owner

cytopia commented Mar 24, 2019

Has been properly addressed in Release v1.0.1

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants