mysql configuration fails when hostname has a capital letter

[muelli]

For some reason configuring mysqld does not work when the hostname is not all lower case.
The work-around is to edit /etc/hostname and /etc/hosts to remove capital letters.
This may very well be a in bug in Debian's mysql setup. But I file it here so that it can be tracked.

[drybjed]

After some research I've found bug reports, this, this and this suggesting that it might be a bug related to mysql installation scripts. It looks like the MySQL server itself handles hostnames in lowercase, but the initialization script doesn't respect that and creates hostnames with uppercase letters in them if they are present in DNS.

Because of the above, "fixing" this issue by forcing hostnames to lowercase in either DebOps roles (all of them) or Ansible mysql_user module probably won't solve the issue.

[muelli]

right. So I guess this needs to be escalated to Debian, then.

FWIW: the puppet people are apparently "fixing" it themselves: larsks/puppetlabs-mysql@0afb8f0
So that's arguably a good enough solution.
But the root cause should really be fixed. I've never filed a Debian bug. Can you do that?

[drybjed]

@muelli An equivalent to Puppet solution would be an update to Ansible's mysql_user module.

This bug might already be fixed in Jessie, either in MySQL or MariaDB server. Before sending alarms anywhere it should be tested on current Debian Stable if bug still exists.

[drybjed]

It looks like at least in MariaDB on Debian, installation script lowers the hostname in mysql_system_tables_data.sql