| Server IP : 104.21.58.74 / Your IP : 216.73.216.213 Web Server : LiteSpeed System : Linux s12482.usc1.stableserver.net 5.14.0-570.32.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Aug 6 11:30:41 EDT 2025 x86_64 User : snownico ( 1231) PHP Version : 8.2.31 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /lib64/nagios/plugins/ |
Upload File : |
#!/usr/local/bin/php
<?php
$output = explode(PHP_EOL, shell_exec('sudo mysql -u root -e \'show engines\' | awk {\'print $1" "$2\'} | tail -n +2'));
$engines = ['InnoDB', 'MRG_MYISAM', 'MEMORY', 'MyISAM', 'ARCHIVE'];
foreach ($output as $string) {
list($k, $v) = explode(' ', $string);
$result[ $k ] = $v;
}
foreach ($engines as $engine) {
if ($result[$engine] == 'NO') {
$answer[]=$engine;
}
}
if (empty($answer)) {
echo "MySQL Engines OK.";
exit(0);
} else {
echo json_encode(['error' => 'true', 'failed_engines' => $answer], JSON_PRETTY_PRINT);
exit(2);
}