search

geerlingguy / ansible-role-mysql

Ansible Role - MySQL
https://galaxy.ansible.com/geerlingguy/mysql/
MIT License
1.05k stars 861 forks source link

Warning "Option column_case_sensitive is not provided" during MySQL user setup #535

Open tisba opened 8 months ago

tisba commented 8 months ago

I'm on 4.3.4 and just saw this warning:

[…]
TASK [geerlingguy.mysql : Ensure MySQL users are present.] ********************************************************************************************************************************************************************
ok: [myhost.example.com] => (item={'name': 'app', 'host': 'localhost', 'password': 'geheim', 'priv': {'app.*': 'ALL'}})
[WARNING]: Option column_case_sensitive is not provided. The default is now false, so the column's name will be uppercased. The default will be changed to true in community.mysql 4.0.0.
[…]

edit: I guess this originates from https://github.com/geerlingguy/ansible-role-mysql/blob/master/tasks/users.yml. Since the default of column_case_sensitive will change, maybe this needs to become configurable?

github-actions[bot] commented 4 months ago

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

tisba commented 4 months ago

This issue is still relevant IMO.

tolecnal commented 3 weeks ago

I'm just referring back to @tisba comment from May 6th, this issue is still quite relevant. I used this role on numerous occasions over the last few months, and seeing this warning is unnecessary given it should be fairly easy to fix in the code.

You can of course argue that the warning is quite trivial, and not relevant to most users, but warnings are warnings and most people would want to avoid them if at all possible.