#4622 Horrible Bug of Mysql Module!!!

[Timmy]

Hello!
Today, I tune my mysql server with stricter permission. I test it without X509 certificate connection, so I turn it off and then on. However, this X509 option cannot be turned on again! It is so horrible because all the data transport becomes PLAIN TEXT!!!

Please repair it as soon as possible! I become a kindergarten without the Webmin GUI! :O

I have sought help from command freaks and fix the condition.

[Jamie Cameron]

That does sound like a fairly nasty bug!

When you say you can't turn it on again, do you mean that the field for the SSL type doesn't appear when you edit the user?

[Timmy]

Hi Jamie,
Yes, when I edit the user's permission and choose SSL or X509 and then save, the certificate option will stay as NONE! On the other hand, the X509 option can be turned off to NONE!

I immediately seek help from command freaks and issue this command, the X509 option appears again as in my picture:
GRANT USAGE ON . TO 'user'@'domain_name' REQUIRE X509;

So I can confirm this is a Bug.

[Jamie Cameron]

Ok, I see the cause of this - MySQL behaves very oddly when updating the SSL type field. I will work around it in the next Webmin release though.