Hi, has anyone successfully used CockroachDB with ...
# ory-selfhostingd
delightful-noon-48365
03/08/2023, 5:32 PMHi, has anyone successfully used CockroachDB with Ory in Kubernetes ?
c
curved-oxygen-35290
03/08/2023, 5:36 PMnope. but it's on my todo after getting pg working š
l
late-balloon-3804
03/08/2023, 5:44 PMwe use CockroachDB but the Cockroach Labs version so we don't manage it ourselves
d
delightful-noon-48365
03/08/2023, 5:49 PM@curved-oxygen-35290 Getting pg to work was easy but we are stuck with CockroachDB, we couldn't get Ory to work with it.
c
curved-oxygen-35290
03/08/2023, 5:50 PMstrange it should be wire compatible
l
late-balloon-3804
03/08/2023, 5:50 PMwire compatible != database migration compatible
late-balloon-3804
03/08/2023, 5:50 PMyou'll need to use
cockroach://c
curved-oxygen-35290
03/08/2023, 5:50 PMurgh
l
late-balloon-3804
03/08/2023, 5:52 PMI believe much of the Ory Network uses CockroachDB as their database, so it has fairly good support
s
steep-lamp-91158
03/08/2023, 5:56 PM
yes we are using crdb, and yeah the
cockroach://steep-lamp-91158
03/08/2023, 5:57 PM
but that should be all
s
steep-teacher-8664
03/09/2023, 6:15 AM@delightful-noon-48365 Self-hosted CRDB in K8s and Ory are fully compatible. Iām using this setup successfully in production.
d
delightful-noon-48365
03/09/2023, 9:56 AMHello @steep-teacher-8664, we are not saying that it is not fully compatible but we could not get it to work. Is it possible to show how you configured it in your cluster?
s
steep-teacher-8664
03/09/2023, 4:11 PM Copy code
hydra:
hydra:
config:
dsn: "<cockroach://hydra:[redacted]@cockroachdb.crdb.svc.cluster.local:26257/ory_hydra>"steep-teacher-8664
03/09/2023, 4:12 PMDoes this help you? š
I am not sure where your problem is exactly? Please explain it further :)
d
delightful-noon-48365
03/09/2023, 4:35 PMYes, this is exactly the same configuration we have, we just successfully connected to cockroachdb but now we want to make an InitContainer to create a database when Ory starts.
s
steep-teacher-8664
03/09/2023, 4:37 PM Copy code
hydra:
automigration:
enabled: true
type: "initContainer"steep-teacher-8664
03/09/2023, 4:38 PMWhat error are you getting, my friend? š
steep-teacher-8664
03/09/2023, 4:38 PMTroubleshooting is hard, if I don't know your situation or setup.
d
delightful-noon-48365
03/09/2023, 4:50 PMSorry it's extraInitContainers : https://github.com/ory/k8s/blob/master/helm/charts/kratos/values.yaml#L372 based on @stocky-king-5626 reply on this issue ; https://github.com/ory/kratos/discussions/1111
s
steep-teacher-8664
03/09/2023, 4:52 PMBut...what is the problem?
steep-teacher-8664
03/09/2023, 4:53 PMYou said "you could not get ory with crdb to work" - now it is working. So what is the log error or whatever? Oo
d
delightful-noon-48365
03/09/2023, 5:04 PMWe want to deploy a new DB as the same time we deploy our Ory, like DBaaS
2 Views