bin/slave-build-connect: log ssh connections to the mysql database

1 files changed, 13 insertions, 0 deletions

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