Use hydra-init / hydra-create-user in the tests

Dependencies

• [2] IZYR3KTL release.nix: Get rid of the "system" argument
• [3] LZVO64YG Merge in the first bits of the API work
• [4] UGA45FNC Add a plugin for backing up builds in s3
• [5] A3A2O37I Work around 9P corruption on 32-bit
• [6] YQWH4POV * Simplify.
• [7] 7C6HSXUQ * Start of a regression test for Hydra.
• [8] WDNDBFSG 32-bit qemu can only do 2047 MB
• [*] T4LLYESZ * Nix expression for building Hydra.

Change contents

• edit in release.nix at line 163
  [2.556]

  [2.556]
  + let dbi = "dbi:Pg:dbname=hydra;user=root;"; in
• replacement in release.nix at line 169
  [2.697]→[2.697:819](∅→∅)
  − ( "createdb -O root hydra",

  − , "psql hydra -f ${hydra}/libexec/hydra/sql/hydra-postgresql.sql"
  [2.697]

  [2.819]
  + ( "createdb -O root hydra"

  + , "HYDRA_DBI='${dbi}' hydra-init"

  + , "HYDRA_DBI='${dbi}' hydra-init" # again to test idempotence
• replacement in release.nix at line 176
  [2.913]→[2.913:1038](∅→∅)
  − $machine->mustSucceed("HYDRA_DATA=/var/lib/hydra HYDRA_DBI='dbi:Pg:dbname=hydra;user=hydra;' hydra-server >&2 &");
  [2.913]

  [2.1038]
  + $machine->mustSucceed("HYDRA_DATA=/var/lib/hydra HYDRA_DBI='${dbi}' hydra-server >&2 &");
• edit in release.nix at line 195
  [3.532]

  [3.532]
  + let dbi = "dbi:Pg:dbname=hydra;user=root;"; in
• replacement in release.nix at line 202
  [3.714]→[3.714:794](∅→∅)
  − , "psql hydra -f ${hydra}/libexec/hydra/sql/hydra-postgresql.sql"
  [3.714]

  [3.794]
  + , "HYDRA_DBI='${dbi}' hydra-init"

  + , "HYDRA_DBI='${dbi}' hydra-create-user root --email-address 'e.dolstra\@tudelft.nl' --password foobar --role admin"
• edit in release.nix at line 205
  [3.833]→[3.833:1114](∅→∅)
  − , "echo \"insert into Users(userName, emailAddress, password) values('root', 'e.dolstra\@tudelft.nl', '\$(echo -n foobar | sha1sum | cut -c1-40)');\" | psql hydra"

  − , "echo \"insert into UserRoles(userName, role) values('root', 'admin');\" | psql hydra"
• replacement in release.nix at line 212
  [3.1366]→[3.1366:1606](∅→∅)
  − $machine->mustSucceed("NIX_STORE_DIR=/run/nix NIX_LOG_DIR=/run/nix/var/log/nix NIX_STATE_DIR=/run/nix/var/nix HYDRA_DATA=/var/lib/hydra HYDRA_DBI='dbi:Pg:dbname=hydra;user=root;' LOGNAME=root DBIC_TRACE=1 hydra-server -d >&2 &");
  [3.1366]

  [3.1606]
  + $machine->mustSucceed("NIX_STORE_DIR=/run/nix NIX_LOG_DIR=/run/nix/var/log/nix NIX_STATE_DIR=/run/nix/var/nix HYDRA_DATA=/var/lib/hydra HYDRA_DBI='${dbi}' LOGNAME=root DBIC_TRACE=1 hydra-server -d >&2 &");