can't use slash in a password for monitor user

Description

The cluster can't leave initializing if a monitor user password contains slash:
The operator tries to execute:

But it's not working with mysql:

Instead the password should be escaped:

Environment

None

Smart Checklist

Activity

Slava Sarzhan November 28, 2022 at 12:42 PM

The issue was fixed under task.

Slava Sarzhan November 12, 2022 at 8:31 PM

, I have reproduced it.  In my case, you can change the password but can't start a new cluster.

inel.pandzic November 12, 2022 at 4:32 PM

Hello Nickolay,

Did you try this with updating the secrets? Because I can't reproduce the issue. I tried like this:

then exec into some pxc pod and run:

 

 

I tried it on main.

inel.pandzic November 1, 2022 at 8:47 AM

Hello ,

While we are here, do we maybe have some other chars that we need to escape besides the slash character? 

Also, you mentioned only the monitor user here, but I guess the same applies to every other user, right?

Nickolay Ihalainen September 13, 2022 at 3:42 PM

If a cluster is initialized normally, but password is changed to the one having slash, the whole cluster is crashed due to failed lifechecks

Done

Details

Assignee

Reporter

Needs QA

Yes

Fix versions

Affects versions

Priority

Smart Checklist

Created September 13, 2022 at 3:29 PM
Updated March 5, 2024 at 5:34 PM
Resolved December 7, 2022 at 1:53 PM