[Nix-dev] Cannot run "hydra-create-user" ("no such table: Users")

[Bjørn Forsman]

Hi all Hydra + Nixpkgs users,

How did you manage to run "hydra-create-user"? It fails for me:

  $ sudo -u hydra hydra-create-user alice --full-name 'Alice Q. User'
--email-address 'alice at example.org' --password alice --role admin
  DBIx::Class::Storage::DBI::_prepare_sth(): DBI Exception:
DBD::SQLite::db prepare_cached failed: no such table: Users at
/nix/store/2jy4y3nml6qljayqjlrf8mx6rrgj8g4l-hydra-2017-02-03/bin/.hydra-create-user-wrapped
line 56

This is on NixOS 17.03, using the hydra module provided by nixpkgs.
I've set "services.hydra.enable = true" in configuration.nix,
activated the configuration and verified that the hydra webUI is up. I
even have the 'Users' table that "hydra-create-user" says does not
exist:

  $ sudo psql -U hydra
  psql (9.5.6)
  Type "help" for help.

  hydra=> select * from Users;
   username | fullname | emailaddress | password | emailonerror | type
| publicdashboard
  ----------+----------+--------------+----------+--------------+------+-----------------
  (0 rows)

Any suggestions?

Best regards,
Bjørn Forsman