Relation "hydra_jwk" does not exist

[janekolszak]

Hi there!
I'm working on a clean Hydra installation, running in a container defined myself.
Database is created, but empty.

time="2017-08-15T17:43:18Z" level=info msg="Connecting with postgres://*:*@db/hydra?sslmode=disable" 
time="2017-08-15T17:43:18Z" level=info msg="Connected to SQL!" 
Could not fetch signing key for OpenID Connect - did you forget to run "hydra migrate sql" or forget to set the SYSTEM_SECRET? Got error: pq: relation "hydra_jwk" does not exist

Env variables:

            - SYSTEM_SECRET=NWM4M2I3OGY1MTRmYTM5ZDEwNjBhODVl
            - FORCE_ROOT_CLIENT_CREDENTIALS=...
            - DISABLE_TELEMETRY=1
            - CONSENT_URL=https://auth.localhost/login
            - ISSUER=https://oidc.localhost
            - HTTPS_TLS_KEY_PATH=/etc/hydra/key.pem
            - HTTPS_TLS_CERT_PATH=/etc/hydra/cert.pem
            - DATABASE_URL=postgres://postgres:password@db/hydra?sslmode=disable

Any idea what's wrong? Maybe SYSTEM_SECRET is in bad format?

[aeneasr]

Did you run hydra migrate sql <database-url>?

[janekolszak]

No, why should I? It's an empty database.

[aeneasr]

Migrations are no longer done automatically, this includes installs on a new database, in case you want to use (for example) a custom schema :)

[janekolszak]

Confirmed - in order to setup Hydra for the first time, on an empty database one has to do hydra migrate sql ....