MySQL Troubleshooting

Upon logging into InterWorx, the MySQL status boxe shows "Stopped" even though the service is running. I have looked through the logs, but there aren't any abnormal messages that I can see.

InterWorx-CP performs a socket connection on localhost to the port that mysql is running on to see if it is a ‘up’. If anything is impeding that connection (firewall, config change, etc) it will show as down in the interface. NodeWorx does a fsockopen on the ftp port to 127.0.0.1. Can you give that a try and see if you get the ‘mysql ready’ message. Some folks block local mysql connections and this would interfere with the check.

Create a test file called, for example, /home/interworx/nodeworx/html/mysql-test.php. In it, put the following code:

<?
$fp = @fsockopen( "localhost",
                  21,
                  $errno,
                  $errstr,
                  30 );
if ( $fp === false ) {
  print "FTP NOT started!";
  var_dump( $errno, $errstr );
} else {
  print "FTP started!";
}
?>

Save and exit the file, then open up the page in your browser:

https://yourserver:2443/nodeworx/mysql-test.php

If mysql isn’t started, you’ll get a dump of information. If it is started, all you’ll see is “MySQL Started!”. If you get this message, try doing a Shift-Reload of the MySQL page.