From d45764513cfae3a0f67cb1e304cdc3e961f5be00 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 19 Jan 2018 15:12:18 +0100
Subject: bin/slave-build-connect: log ssh connections to the mysql database

---
 bin/slave-build-connect | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/bin/slave-build-connect b/bin/slave-build-connect
index b1d3495..704a9da 100755
--- a/bin/slave-build-connect
+++ b/bin/slave-build-connect
@@ -18,6 +18,19 @@ if [ "${SSH_ORIGINAL_COMMAND%% *}" = "get-assignment" ] || \
   printf '%s %s %s\n' "$(date '+%F %T')" "$1" "${SSH_ORIGINAL_COMMAND}" >> \
     "${work_dir}/ssh-log"
 
+  ${mysql_command} -e "$(
+    # shellcheck disable=SC2016
+    printf 'UPDATE `build_slaves`'
+    # shellcheck disable=SC2016
+    printf ' SET `build_slaves`.`last_connection`=NOW'
+    # shellcheck disable=SC2016
+    printf ' WHERE `build_slaves`.`name`=from_base64("%s")\n' \
+      "$(
+        printf '%s' "$1" | \
+          base64 -w0
+      )"
+  )"
+
   slave="$1" /bin/sh -c "${base_dir}/bin/${SSH_ORIGINAL_COMMAND}"
 
 else
-- 
cgit v1.2.3-70-g09d2