Submitted by MDS85 on Fri, 07/27/2012 - 15:27
Could have labeled this under Webmin, however this occurred using the Virtualmin GPL installer.
Changing the MySQL configuration via Virtualmin's UI will kill the MySQL server to the point where it will not restart.
Reproduce:
- Virtualmin on Ubuntu 12.04 (AMDx64)
- Navigate to Servers > MySQL Database Server > MySQL Server Configuration
- Find "Maximum packet size" .. Give this a value of 32 MB
- Click "Save and Restart MySQL"
Reason: In the example above, Virtualmin (Webmin) adds "set-variable = max_allowed_packet=32MB" to the my.cnf file, which is invalid, and prevents the server from restarting. You must manually edit the my.cnf file and remove it to fix it.
Status:
Closed (fixed)
Comments
Submitted by JamieCameron on Fri, 07/27/2012 - 16:29 Comment #1
That's odd, this works fine for me with MySQL 5.0.77 - although I assume Ubuntu 12.04 has a newer MySQL version, so maybe they removed this option.
What gets logged to the MySQL error log file when you try to restart it with this option set?
Submitted by MDS85 on Sat, 07/28/2012 - 18:51 Comment #2
The issue is quite clear.... Regardless, it's:
120728 19:44:51 [ERROR] mysqld: unknown variable 'set-variable=max_allowed_packet=32M'
120728 19:44:51 [ERROR] Aborting
Submitted by JamieCameron on Sat, 07/28/2012 - 23:33 Comment #3
Looks like this used to be settable with the set-variable option, but no longer. I will fix this in the 1.600 Webmin release.
Submitted by Issues on Sat, 08/11/2012 - 23:46 Comment #4
Automatically closed -- issue fixed for 2 weeks with no activity.
Submitted by Pierrot on Sat, 12/05/2015 - 07:07 Comment #5
Hello,
I'm seeing the same behavior here on Debian 7 and Webmin 1.770 although not during install but because I wanted to tweak some mysql settings. So I used the Webmin interface and the generated my.cnf has some "set-variable=" that prevent mysqld from starting, for example:
[ERROR] /usr/sbin/mysqld: unknown variable 'set-variable=myisam_sort_buffer_size=8M' 151205 13:36:11 [ERROR] Aborting
I had to manually edit my.cnf to regain control. I did it again to re-check, same result ...
Pierre.
Submitted by JamieCameron on Sat, 12/05/2015 - 20:27 Comment #6
Are you using the stock version of MySQL that comes with Debian 7? Perhaps it doesn't support MyISAM format tables..
Submitted by Pierrot on Sun, 12/06/2015 - 15:02 Comment #7
Hello,
Yes stock version of PHP and mySQL, I never change these.
That error is just an example, there was three of them ... And if I replace 'set-variable=myisam_sort_buffer_size=8M' by 'myisam_sort_buffer_size=8M' it works.
Pierre.
Submitted by JamieCameron on Sun, 12/06/2015 - 21:26 Comment #8
Ok, this will be fixed in the next Webmin release.
Submitted by Issues on Sun, 12/20/2015 - 21:30 Comment #9
Automatically closed -- issue fixed for 2 weeks with no activity.