mysql-operator icon indicating copy to clipboard operation
mysql-operator copied to clipboard

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

Open airdos360 opened this issue 7 years ago • 3 comments

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 avatar Aug 13 '18 19:08 airdos360

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

airdos360 avatar Aug 13 '18 20:08 airdos360

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

prydie avatar Aug 14 '18 07:08 prydie

Can I work on this?

AdityaMisra avatar Oct 13 '19 09:10 AdityaMisra