From 31fa73701b80256cd844a9c62cb01f1c662a32e5 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Wed, 19 Jun 2019 10:18:22 +0200
Subject: bin/slave-build-connect: block slaves which have
 `build_slaves`.`access_allowed`==0

---
 bin/slave-build-connect | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/bin/slave-build-connect b/bin/slave-build-connect
index a3724cc..fa36219 100755
--- a/bin/slave-build-connect
+++ b/bin/slave-build-connect
@@ -27,11 +27,12 @@ if [ "x${SSH_ORIGINAL_COMMAND%% *}" = 'xget-assignment' ] || \
       printf ' FROM `build_slaves`'
       mysql_join_build_slaves_ssh_keys
       mysql_join_ssh_keys_persons
-      printf ' WHERE `build_slaves`.`name`=from_base64("%s");\n' \
+      printf ' WHERE `build_slaves`.`name`=from_base64("%s")' \
         "$(
           printf '%s' "$1" | \
             base64 -w0
         )"
+      printf ' AND `build_slaves`.`access_allowed`;\n'
     } | \
       mysql_run_query | \
       tr '\t' ' '
-- 
cgit v1.2.3-70-g09d2