| Server IP : 198.38.94.67 / Your IP : 216.73.217.142 Web Server : LiteSpeed System : Linux d6054.dxb1.stableserver.net 5.14.0-570.25.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Jul 9 04:57:09 EDT 2025 x86_64 User : azfilmst ( 1070) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /usr/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);
}