| Server IP : 192.250.235.158 / Your IP : 216.73.216.4 Web Server : LiteSpeed System : Linux s4099.sgp1.stableserver.net 5.14.0-503.21.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Sun Jan 12 09:45:05 EST 2025 x86_64 User : vmxfzbqj ( 1905) PHP Version : 8.3.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);
}