bin/slave-build-connect: block slaves which have `build_slaves`.`access_allowed`==0

1 files changed, 2 insertions, 1 deletions

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' ' '