lib/mysql.php: do not print warning if last ssh_log is less than a minute ago

1 files changed, 11 insertions, 2 deletions

diff --git a/lib/mysql.php b/lib/mysql.php
index 60bfa3a..6d575ad 100644
--- a/lib/mysql.php
+++ b/lib/mysql.php
@@ -20,9 +20,18 @@ function mysql_run_query($query) {
 }
 
 function show_warning_on_offline_slave() {
-  $result = mysql_run_query("SHOW STATUS LIKE \"Slave_running\"");
+  $result = mysql_run_query(
+    "SHOW STATUS LIKE \"Slave_running\""
+  );
   if (($result -> num_rows == 0) ||
     ($result -> fetch_assoc() ["Value"] != "ON")) {
-    print "<div><font color=\"ff0000\">The replication slave is currently not running. The database might be outdated.</font></div>\n";
+    $result = mysql_run_query(
+      "SELECT 1 FROM `ssh_log`" .
+      " WHERE ADDTIME(`ssh_log`.`date`,\"1:00\")>NOW()" .
+      " LIMIT 1"
+    );
+    if ($result -> num_rows == 0) {
+      print "<div><font color=\"ff0000\">The replication slave is currently not running. The database might be outdated.</font></div>\n";
+    }
   }
 }