Followed: Generic Kubernetes installation - Percona Operator for MySQL based on Percona XtraDB Cluster
This very first pxc pod is stuck on its 3rd container:
$ kubectl get pods
cluster1-pxc-0 2/3 Running 1 7m40s
$ kubectl describe cluster1-pxc-0
Warning Unhealthy 3m6s (x19 over 12m) kubelet Readiness probe failed: mysql: [Warning] World-writable config file ‘/etc/my.cnf’ is ignored.
mysql: [Warning] World-writable config file ‘/etc/my.cnf’ is ignored.
ERROR 1045 (28000): Access denied for user ‘clustercheck’@‘localhost’ (using password: YES)
+[[ ‘’ == \P\r\i\m\a\r\y ]]
+exit 1
No changes in yamls were made.
Please suggest what can be the issue!
1 Like
Hello @IAtheist ,
I have tried to reproduce the issue, but it worked for me - the cluster is up and running with default cr.yaml.
I have a feeling that you missed the step # 5 where Secrets are created. Could you please check?
Is there anything specific about your Kubernetes environment?
2 Likes
Hi Sergey, I have a similar problem with version 1.13.0. Everything works fine except the message I get that the clustercheck password is not set.
I have applied a secrets (root access works,… in the configured one).
The message I get is the following in the PerconaXtraDBcluster object:
status:
backup: {}
conditions:
- lastTransitionTime: ‘2024-01-10T14:04:22Z’
status: ‘True’
type: initializing
- lastTransitionTime: ‘2024-01-10T14:07:29Z’
status: ‘True’
type: ready
- lastTransitionTime: ‘2024-01-10T14:07:29Z’
message: >-
manage sys users: update clustercheck users pass: update user pass:
alter user: Error 3878 (HY000): Empty password can not be retained as
second password for user ‘clustercheck’@‘localhost’.
reason: ErrorReconcile
status: ‘True’
Hello @Manuel_Galan_Privado ,
could you please share the steps to reproduce the problem and manifests that you use? I have hard times reproducing it.