Article ID: 2322, created on Oct 29, 2007, last review on Apr 25, 2014

  • Applies to:
  • Pro Control Panel Linux

AdditionalInformation

View Knowledge
Knowledge ID 1053
Product : WEBppliance for Linux
Version : 3.5.20
Topic : FAQ

Title
MySQL fails to restart after upgrade to Pro 3.5.20

Summary
MySQL fails to restart after upgrade to Pro 3.5.20

Prevention


Details
Solution:

If /etc/my.cnf has been customized, then upgrade to 3.5.20 may cause mysql to fail to restart.  You may see error messages similar to those below:

# /etc/rc.d/init.d/mysqld restart
Stopping MySQL: [ OK ]
dirname: too many arguments
Try `dirname --help' for more information.
mkdir: too few arguments
Try `mkdir --help' for more information.
dirname: too many arguments
Try `dirname --help' for more information.
chown: too few arguments
Try `chown --help' for more information.
dirname: too many arguments
Try `dirname --help' for more information.
chmod: too few arguments
Try `chmod --help' for more information.
/etc/rc.d/init.d/mysqld: [: /home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock: binary operator expected
/etc/rc.d/init.d/mysqld: [: /home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock: binary operator expected
/etc/rc.d/init.d/mysqld: [: /home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock: binary operator expected

This is caused by the following line in /etc/my.cnf contain spaces on either side of the '='.  On upgrade, webppliance has changed the location of the mysql.sock file for security fix.  The mysqld init script checks for this line and modifies /etc/my.cnf to have the new location of mysql.sock, however, because of an improper regex, 'socket' line with spaces causes duplicate 'socket' keys in this file and subsequently causes mysql restart to fail.

socket = /var/lib/mysql/mysql.sock

Edit the file /etc/my.cnf and remove the spaces on either side of the '=', then attempt to restart mysql.

This problem will be resolved in a future update of WEBppliance.


Attachments


Related Knowledge

Related Links
 
Last ModifiedUsageSatisfiedLast Used
8/20/2004 12:47:47 PM35 10/11/2007 5:59:01 AM

4cc899da08664637a8bc437308d3ddd7 3ccb419cf98083f3bb45808fba8dbc7c 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF