MySQL Agent fails to connect when root password contains '#' - Githubissues

oracle / mysql-operator

Create, operate and scale self-healing MySQL clusters in Kubernetes

870 stars 235 forks source link

MySQL Agent fails to connect when root password contains '#' #200

Open airdos360 opened 6 years ago

airdos360 commented 6 years ago

Is this a BUG REPORT or FEATURE REQUEST?

BUG REPORT

Versions

MySQL Operator Version: 0.2.0

Environment: Linux

Kubernetes version (use kubectl version): 1.11.2
Cloud provider or hardware configuration:
OS (e.g. from /etc/os-release): CentOS 7

What happened?

MySQL agent will not connect when root password is set. If root password is left blank, it starts up correctly.

kubectl create secret generic -n mysql mysql-cluster-root-password --from-literal=password=XXXXXX

apiVersion: mysql.oracle.com/v1alpha1 kind: Cluster metadata: name: mysql-cluster namespace: mysql spec: multiMaster: true members: 3 rootPasswordSecret: name: mysql-cluster-root-password

What you expected to happen?

Pods to start up when rootPasswordSecret is set.

airdos360 commented 6 years ago

Seems to be if the password contains a "#" it fails. I got it to work without the #.

prydie commented 6 years ago

This will almost certainly be due to shell escaping. I suggest we explore storing the root password in a .mylogin.cnf.

AdityaMisra commented 5 years ago

Can I work on this?