From 857d7d193c454ff18c4c15089bc465178415a5a8 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 22 Jun 2018 13:32:13 +0200
Subject: lib/mysql.php: do not print warning if last ssh_log is less than a
 minute ago

---
 lib/mysql.php | 13 +++++++++++--
 1 file changed, 11 insertions(+), 2 deletions(-)

(limited to 'lib')

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";
+    }
   }
 }
-- 
cgit v1.2.3