Hi Folks!! :wave:
We are using ory kratos self hos...
# talk-kratosb
bumpy-policeman-45538
12/14/2022, 9:16 AMHi Folks!! 👋
We are using ory kratos self hosted instance and postgresql database to store identities
Issue : Copy code
{
"code": 500,
"status": "Internal Server Error",
"message": "ERROR: column \"oauth2_login_challenge\" of relation \"selfservice_login_flows\" does not exist (SQLSTATE 42703)"
} Copy code
environment:
- DSN=<postgres://database-server-credentials:5432/dev-ory>
- LOG_LEVEL=traceNotec
curved-fountain-46946
12/14/2022, 2:04 PMDid you run the db migrations?
b
bumpy-policeman-45538
12/14/2022, 5:40 PMHi @curved-fountain-46946, I am not aware with migration run. Is there any command or doc available ?
c
curved-fountain-46946
12/14/2022, 10:17 PMYeah, there are some ways to do it, here are the manual steps: https://www.ory.sh/docs/kratos/cli/kratos-migrate-sql . I think there are some ways to make your kratos instance do this on boot too, but I am not familiar enough with the mechanic to tell you exactly how all of those work. For docker-compose, there is an example yaml here: https://github.com/ory/kratos/blob/master/quickstart.yml . I know there are some helm charts too somewhere, and maybe even some flags if you're running it straight on the iron (?)
b
bumpy-policeman-45538
12/15/2022, 4:21 AMOh Great, Thanks!!
bumpy-policeman-45538
12/15/2022, 4:41 AMHi @curved-fountain-46946, While checking initial logs i got this, although connection URL is already defined 🤔
Copy code
level=debug msg=No SQL connection options have been defined, falling back to default connection options. func=<http://github.com/ory/x/logrusx.(*Logger).Logf|github.com/ory/x/logrusx.(*Logger).Logf> file=/go/pkg/mod/github.com/ory/x@v0.0.392/logrusx/helper.go:118 audience=application service_name=Ory Kratos service_version=v0.10.1 sql_max_connection_lifetime=0s sql_max_connections=16 sql_max_idle_connection_time=0s sql_max_idle_connections=8bumpy-policeman-45538
12/15/2022, 4:45 AMSharing quickstart file, please let me know if you get anything wrong
s
steep-lamp-91158
12/15/2022, 12:27 PM
The connection seems fine, as it knows the table
steep-lamp-91158
12/15/2022, 12:27 PM
You have to make sure the migrations are being run
steep-lamp-91158
12/15/2022, 12:28 PM
Your
kratos-migrateb
bumpy-policeman-45538
12/15/2022, 12:47 PMOkay @steep-lamp-91158 Thanks!, I think issue is related to postgres or configuration because same dsn is not working in my colleagues machine 👀
bumpy-policeman-45538
12/15/2022, 12:48 PMWhen they are using DSN as our rds (aws) server db instead of memory they are getting auth/error with below payload
Copy code
{
"code": 500,
"status": "Internal Server Error",
"message": "ERROR: column \"oauth2_login_challenge\" of relation \"selfservice_login_flows\" does not exist (SQLSTATE 42703)"
}s
steep-lamp-91158
12/15/2022, 3:57 PM
on memory migrations are always applied
steep-lamp-91158
12/15/2022, 3:58 PM
can you run
kratos migrate sqlsteep-lamp-91158
12/15/2022, 3:58 PM
this is 💯% the issue
b
bumpy-policeman-45538
12/15/2022, 3:59 PMRight!!, Let me check 🪄
s
steep-lamp-91158
12/15/2022, 4:00 PM
obviously same version as the server
b
bumpy-policeman-45538
12/15/2022, 4:07 PMOkay
s
steep-lamp-91158
12/15/2022, 4:58 PM
what did you get?
b
bumpy-policeman-45538
12/16/2022, 10:08 AMHey @steep-lamp-91158, Thanks a lot man. it has worked 🎉
9 Views