lastk/reboot_mysql_database.php

## reboot_mysql_database.php
<?php
// Start / Stop / Reboot MySQL Database server using SSH with PHP
// Requires the library from phpseclib.sourceforge.net / https://github.com/phpseclib/phpseclib

// Server user login data
$ssh_user = '';
$ssh_password = '';
$ssh_server_ip = '';
?>
<!DOCTYPE html>
<html>
<body>
    <title>Re-boot MySQL Database Server</title>

<?php

  function didMySqlDbRestart($sshCommandResponseString){
    if(preg_match('/process \d+$/', trim($sshCommandResponseString)) > 0){
        return true;
    }else if($sshCommandResponseString == 'start: Job is already running: mysql'){
        return true;
    }else{
        return false;
    }
  }

// phpseclib.sourceforge.net / https://github.com/phpseclib/phpseclib
include('Net/SSH2.php');

if(isset($_GET['restart-mysql']) && $_GET['restart-mysql'] === 'yes'){


    $ssh = new Net_SSH2($ssh_server_ip);
    if (!$ssh->login($ssh_user, $ssh_password)) {
        exit('Login Failed');
    }

    ob_start();
    echo $ssh->exec('service mysql restart');
    $sshCommandResponseString = ob_get_contents();
    ob_end_clean();

//echo $sshCommandResponseString;
     if(didMySqlDbRestart($sshCommandResponseString)){
        echo 'SUCCESS: MySQL Database Rebooted';
    } else{
        echo 'ERROR: MySQL Database Did Not Reboot';
     }


}else if(isset($_GET['stop-mysql']) && $_GET['stop-mysql'] === 'yes'){

    $ssh = new Net_SSH2($ssh_server_ip);
    if (!$ssh->login($ssh_user, $ssh_password)) {
        exit('Login Failed');
    }

    ob_start();
    echo $ssh->exec('service mysql stop');
    $sshCommandResponseString = ob_get_contents();
    ob_end_clean();

    //echo $sshCommandResponseString;

     if(didMySqlDbRestart($sshCommandResponseString)){
        echo 'SUCCESS: MySQL Database Stopped';
    } else{
        echo 'ERROR: MySQL Database Did Not Stop';
     }


}else if(isset($_GET['start-mysql']) && $_GET['start-mysql'] === 'yes'){

    $ssh = new Net_SSH2($ssh_server_ip);
    if (!$ssh->login($ssh_user, $ssh_password)) {
        exit('Login Failed');
    }

    ob_start();
    echo $ssh->exec('service mysql start');
    $sshCommandResponseString = ob_get_contents();
    ob_end_clean();

     if(didMySqlDbRestart($sshCommandResponseString)){
        echo 'SUCCESS: MySQL Database Started';
    } else{
        echo 'ERROR: MySQL Database Did Not Start';
     }
}else{
?>
    <h1>Reboot MySQL Database Server</h1>
    <p>If the MySQL Database crashes then you can run this script which will login to the server via SSH and execute the restart commands to start the database server.</p>
    <p>If this does not resolve the issue then please contact Jason Davis - jason.davis.fl@gmail.com</p>

    <form action=""  method="get">
      <input type="hidden" name="restart-mysql" value="yes">
      <input type="submit" value="Restart MySQL Database">
    </form><br>

    <form action=""  method="get">
      <input type="hidden" name="stop-mysql" value="yes">
      <input type="submit" value="Stop MySQL Database">
    </form><br>

    <form action=""  method="get">
      <input type="hidden" name="start-mysql" value="yes">
      <input type="submit" value="Start MySQL Database">
    </form>
<?php
}
?>

</body>
</html>
	<?php
	// Start / Stop / Reboot MySQL Database server using SSH with PHP
	// Requires the library from phpseclib.sourceforge.net / https://github.com/phpseclib/phpseclib

	// Server user login data
	$ssh_user = '';
	$ssh_password = '';
	$ssh_server_ip = '';
	?>
	<!DOCTYPE html>
	<html>
	<body>
	<title>Re-boot MySQL Database Server</title>

	<?php

	function didMySqlDbRestart($sshCommandResponseString){
	if(preg_match('/process \d+$/', trim($sshCommandResponseString)) > 0){
	return true;
	}else if($sshCommandResponseString == 'start: Job is already running: mysql'){
	return true;
	}else{
	return false;
	}
	}

	// phpseclib.sourceforge.net / https://github.com/phpseclib/phpseclib
	include('Net/SSH2.php');

	if(isset($_GET['restart-mysql']) && $_GET['restart-mysql'] === 'yes'){


	$ssh = new Net_SSH2($ssh_server_ip);
	if (!$ssh->login($ssh_user, $ssh_password)) {
	exit('Login Failed');
	}

	ob_start();
	echo $ssh->exec('service mysql restart');
	$sshCommandResponseString = ob_get_contents();
	ob_end_clean();

	//echo $sshCommandResponseString;
	if(didMySqlDbRestart($sshCommandResponseString)){
	echo 'SUCCESS: MySQL Database Rebooted';
	} else{
	echo 'ERROR: MySQL Database Did Not Reboot';
	}


	}else if(isset($_GET['stop-mysql']) && $_GET['stop-mysql'] === 'yes'){

	$ssh = new Net_SSH2($ssh_server_ip);
	if (!$ssh->login($ssh_user, $ssh_password)) {
	exit('Login Failed');
	}

	ob_start();
	echo $ssh->exec('service mysql stop');
	$sshCommandResponseString = ob_get_contents();
	ob_end_clean();

	//echo $sshCommandResponseString;

	if(didMySqlDbRestart($sshCommandResponseString)){
	echo 'SUCCESS: MySQL Database Stopped';
	} else{
	echo 'ERROR: MySQL Database Did Not Stop';
	}


	}else if(isset($_GET['start-mysql']) && $_GET['start-mysql'] === 'yes'){

	$ssh = new Net_SSH2($ssh_server_ip);
	if (!$ssh->login($ssh_user, $ssh_password)) {
	exit('Login Failed');
	}

	ob_start();
	echo $ssh->exec('service mysql start');
	$sshCommandResponseString = ob_get_contents();
	ob_end_clean();

	if(didMySqlDbRestart($sshCommandResponseString)){
	echo 'SUCCESS: MySQL Database Started';
	} else{
	echo 'ERROR: MySQL Database Did Not Start';
	}
	}else{
	?>
	<h1>Reboot MySQL Database Server</h1>
	<p>If the MySQL Database crashes then you can run this script which will login to the server via SSH and execute the restart commands to start the database server.</p>
	<p>If this does not resolve the issue then please contact Jason Davis - jason.davis.fl@gmail.com</p>

	<form action="" method="get">
	<input type="hidden" name="restart-mysql" value="yes">
	<input type="submit" value="Restart MySQL Database">
	</form><br>

	<form action="" method="get">
	<input type="hidden" name="stop-mysql" value="yes">
	<input type="submit" value="Stop MySQL Database">
	</form><br>

	<form action="" method="get">
	<input type="hidden" name="start-mysql" value="yes">
	<input type="submit" value="Start MySQL Database">
	</form>
	<?php
	}
	?>

	</body>
	</html>