Comments (4)
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.
from debops-tools.
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?
from debops-tools.
@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.
from debops-tools.
It looks like at least in MariaDB on Debian, installation script lowers the hostname in mysql_system_tables_data.sql
from debops-tools.
Related Issues (20)
- Check code signatures
- Move `debops.keyring` Python module into this repo
- Refactor Python modules
- Signed PyPI releases
- debops-update: fails when ansible_managed contains variables
- Document subcommands
- Please enlighten me how to workaround this particular failure I noted HOT 12
- MS Windows Support? HOT 5
- Update http://debops.org/ to https://debops.org/ in repo description HOT 1
- README randomly lists 1 out of 3 dependencies
- provide a commented example config of how to use template_src HOT 1
- debops-padlock unusable with encfs > 1.9 HOT 6
- Raspbian detected as Debian HOT 4
- debops-update has no --dry-run argument HOT 2
- Debops inserts faulty Ansible ppa sources into sources.list HOT 1
- ERROR! Unexpected Exception: invalid syntax (profile_tasks.py, line 68)
- Broken Link for "Getting Started Guide" HOT 3
- wrong pathes for lookup_plugins in ansible.cfg HOT 5
- quoting directories with spaces in ansible.cfg breaks with 2.7 HOT 6
- Bootstrap: Variables from group_vars/all/bootstrap.yml not getting picked up HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from debops-tools.