Hi, I try to setup Kratos but I struggle with the DSN for the database connection. I get this error log message:

level=fatal msg=dsn must be set audience=application service_name=Ory Kratos service_version=v0.9.0-alpha.3

but it is hard for me to see what I should adjust to make it work. If I copy-paste those values and add them to the dsn, it just result in the same error message. I don't find any documentation about those

audience=application

values in the DSN, any suggestions?

the error message is

dsn must be set

- you can ignore

audience=application

as this is just an attribute for log filtering

Ok, that was good to know, but was hard to understand. Thanks. I have a DSN set but there must be something wrong with it, thanks anyway.

then either your

kratos.yaml

is not being loaded, or the environment variable isn’t correct, don’t think there’s a third possibility 🙂

This was actually for kratos-migrate and I have not understood wether it needs an

kratos.yaml

or not yet, so I have not included it.

kratos-migrate needs all of the same configuration as kratos 🙂

oh, I see. But I really hope that an error message about "dsn must be set" is NOT related to missing

kratos.yaml

- that would make me cry.

can you maybe give your config file? and obfuscate secrets?

I have tried with this kubernetes container spec in a Job:

- image: oryd/kratos:v0.9.0
        name: kratos-migrate
        command: ["kratos"]
        args:
        - migrate
        - sql
        - -e
        - --yes
        env:
          - name: DB_DSN
            value: <postgres://kratos:mypassword@127.0.0.1:5432/kratos?sslmode=disable&max_conns=20&max_idle_conns=4>

I run it on GKE with Goolge SQL Auth Proxy (as recommended by GCP) .... If I run a pod with

postgres

image and the same config, that can connect to the database using the psql command..... It's hard to see what is wrong for me.

shouldn’t it only be

DSN

instead of

DB_DSN

?

thanks, good catch 🙏. I will try