grahamc/hydra2 - Change V4R3SIRMYTN4CVYWPFPFT34N3PCGVTGNWUSX4VE4B4FT5EEVWJFAC

hydra-module.nix: Don't use a password

If PostgreSQL is running on the same system, then the "hydra" user can can connect without a password (via Unix domain socket authentication), so no need to set up a password. If PostgreSQL is on another machine, then creating a user/database won't work anyway.

Created by Eelco Dolstra on November 6, 2013

V4R3SIRMYTN4CVYWPFPFT34N3PCGVTGNWUSX4VE4B4FT5EEVWJFAC

Dependencies

In channels

main

Change contents

Replacement in hydra-module.nix at line 43 [4.1]

∅:D[2.57] → [3.122:190]

B:BD[4.1082] → [3.122:190]

        default = "dbi:Pg:dbname=hydra;host=localhost;user=hydra;";

[2.57]

[4.1149]

        default = "dbi:Pg:dbname=hydra;user=hydra;";
        example = "dbi:Pg:dbname=hydra;host=postgres.example.org;user=foo;";

Replacement in hydra-module.nix at line 183 [4.1]

B:BD[5.195] → [6.88:345]

          pass=$(HOME=/root ${pkgs.openssl}/bin/openssl rand -base64 32)
          if [ ! -f ${baseDir}/.pgpass ]; then
              ${config.services.postgresql.package}/bin/psql postgres << EOF
          CREATE USER hydra PASSWORD '$pass';
          EOF

[5.195]

[6.345]

          ${optionalString (cfg.dbi == "dbi:Pg:dbname=hydra;user=hydra;") ''
            if ! [ -e ${baseDir}/.db-created ]; then
              ${config.services.postgresql.package}/bin/createuser hydra

Replacement in hydra-module.nix at line 187 [4.1]

B:BD[6.425] → [6.425:697]

              cat > ${baseDir}/.pgpass-tmp << EOF
          localhost:*:hydra:hydra:$pass
          EOF
              chown hydra ${baseDir}/.pgpass-tmp
              chmod 600 ${baseDir}/.pgpass-tmp
              mv ${baseDir}/.pgpass-tmp ${baseDir}/.pgpass
          fi

[6.425]

[2.655]

              touch ${baseDir}/.db-created
            fi
          ''}