CPANEL-40284 - SQL configuration on cpanel 102+ query_cache_type configuration does not stick

danfbach

• March 22, 2022 08:45

Hello, Just updated my servers to whm/cpanel 102.0.8 and found the new SQL configuration page which is a nice feature addition. servers are running mariadb 10.5.15. When i try to enable query cache on the "Edit SQL Configuration" page (setting it to anything other than 0) the setting always reverts back to 0 when the page is refreshed. i've tried manually enabling it (query_cache_type=1) in /etc/my.cnf and the config page still shows zero after restarting mariadb. I've tried removing it entirely from my.cnf, restarting mariadb, and then setting it on the config page, and it still reverts to zero when the page is refreshed. In the meantime, i'll just enable it through my.cnf, but i thought i would bring this to your attention.

• 

  cPRex Jurassic Moderator

  • March 22, 2022 16:28

  Hey there! Let me do some testing with this and I'll get back to you!

  0
• 

  cPRex Jurassic Moderator

  • March 22, 2022 17:49

  I confirmed this behavior and opened case CPANEL-40284 to have our team look into this. If you're logged in, you can follow along with this case at

  0
• 

  cPRex Jurassic Moderator

  • April 04, 2022 15:26

  Update - this will be fixed in version 102.0.10 when that is released.

  0

Please sign in to leave a comment.