docker compose files using invalid migrate syntax

[Uli-Tiger]

keto/docker-compose-postgres.yml

Line 12 in bd88a36

migrate sql postgres://dbuser:secret@postgresd:5432/accesscontroldb?sslmode=disable

According to the CLI reference (https://www.ory.sh/keto/docs/cli/keto-migrate) this not valid syntax for migrate. As a consequence the keto-migrate service will not do anything.
With 0.7 this docker compose file will not work out of the box anymore, because duse to the invalid migrate the keto service will fail to start with Migrations were not applied yet, please apply them first.ketopoc_keto_1 exited with code 255

should this be better migrate up --yes? and the whole block

  keto-migrate:
    image:  oryd/keto:v0.7.0-alpha.0
    links:
      - postgresd:postgresd
    volumes:
      - type: bind
        source: .
        target: /home/ory
    environment:
      - LOG_LEVEL=debug
      - DSN=postgres://dbuser:secret@postgresd:5432/accesscontroldb?sslmode=disable
    command:
      migrate up --yes

or did i missed here something?

[zepatrik]

True, would you be up for a fix?

[Bhautik0110]

In oryd/keto:v0.6.0-alpha.1 works correctly, but in v0.7.x It fail with

keto_1  | time=2021-10-19T12:37:57Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Keto service_version=v0.7.0-alpha.0
keto_1  | time=2021-10-19T12:37:57Z level=debug msg=Ignoring migration file 20150100000001000000_networks.sqlite3.down.sql because dialect is not supported: unsupported dialect sqlite3 audience=application service_name=ORY Keto service_version=v0.7.0-alpha.0
keto_1  | time=2021-10-19T12:37:57Z level=debug msg=Ignoring migration file 20150100000001000000_networks.sqlite3.up.sql because dialect is not supported: unsupported dialect sqlite3 audience=application service_name=ORY Keto service_version=v0.7.0-alpha.0
db_1    | 2021-10-19 12:37:57.729 UTC [56] ERROR:  relation "schema_migration" does not exist at character 47
db_1    | 2021-10-19 12:37:57.729 UTC [56] STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
keto_1  | Migrations were not applied yet, please apply them first.cat-videos-example_keto_1 exited with code 255

[ogomezm]

I had the same issue and created a pull request for fixing it.

The issue is related to the ENTRYPONT and the CMD within the Dockerfile, both are using the exec format ["keto"] and ["serve"]. That forces the usage of exec form instead of the bash form into the docker-compose command ["migrate", "up", "-y"]