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

Operating System & Version
CENTOS 7.9
cPanel & WHM Version
102.0.8

danfbach

Member
Jan 14, 2021
23
3
3
United States
cPanel Access Level
Root Administrator
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.
 
Last edited by a moderator: