#4020 MySQL Server Configuration writes invalid entry to my.cnf

1.570
closed-fixed
5
2011-11-04
2011-11-04
No

E.g. if I set "Query cache size in bytes" to 0 (zero) instead of "Default" from the web interface, it gets written something like as
set-variable=query_cache_size=0
into my.cnf, which is of course invalid and causes mysqld to fail. If this is relevant, note that I've come across this just after I've upgraded to MySQL 5.5 from 5.1. Versions: debian 6.0.3 32bit, Webmin 1.570, Virtualmin 3.88.gpl GPL

Discussion

  • Jamie Cameron

    Jamie Cameron - 2011-11-04

    Thanks - I'll add a check to prevent a zero cache size.

     
  • Jamie Cameron

    Jamie Cameron - 2011-11-04
    • status: open --> closed-fixed
     
  • Jamie Cameron

    Jamie Cameron - 2011-11-05

    I don't understand - didn't your initial bug report say that setting it to 0 causes mysqld to fail?

     
  • Halil Özgür

    Halil Özgür - 2011-11-08

    No, if you could read it again, it says that Webmin sets it to 0 in a wrong way that cause MySQL not to start. 0 is a meaningful and required value for that setting. If you set it to 0, Webmin writes something like:
    set-variable=query_cache_size=0
    into my.cnf (MySQL config file). Instead, it should write:
    query_cache_size=0

     
  • Jamie Cameron

    Jamie Cameron - 2011-11-08

    Ok, I see now .. this will be fixed in the next Webmin release.

     

Log in to post a comment.