Using cockroachdb as backing store for openstack keystone


#1

Does anyone have keystone working with CRDB?

I am running openstack version 2.3.1 in a docker for mac container and am running CRDB natively on macos.

cockroach start --insecure --host=localhost

CockroachDB node starting at 2018-10-10 03:14:09.268279621 +0000 UTC (took 0.3s)
build: CCL v2.0.5 @ 2018/08/13 20:55:02 (go1.10.3)
admin: http://localhost:8080
sql: postgresql://root@localhost:26257?sslmode=disable
logs: /Users/mgreen/Work/roach/cockroach-data/logs
temp dir: /Users/mgreen/Work/roach/cockroach-data/cockroach-temp864256027
external I/O path: /Users/mgreen/Work/roach/cockroach-data/extern
store[0]: path=/Users/mgreen/Work/roach/cockroach-data
status: initialized new cluster
clusterID: 95f8c85a-ac12-44bf-bccc-17b2ee5d2cd8
nodeID: 1

keystone.conf:
connection = postgresql://root@docker.for.mac.localhost:26257/keystone
keystone.log:
2018-10-10 17:05:01.063 125 ERROR keystone.common.wsgi [req-888c04e0-d55a-4433-8b4e-51ac17820240 - - - - -] Could not determine version from string ‘CockroachDB CCL v2.0.5 (x86_64-apple-darwin17.7.0, built 2018/08/13 20:55:02, go1.10.3)’

In my keystone configuration I have tried two connection methods with the following log errors:

keystone.conf:
connection = cockroachdb://root@docker.for.mac.localhost:26257/keystone
keystone.log:
2018-10-10 17:30:48.753 125 ERROR keystone.common.wsgi [req-bb5f3292-3f50-4b50-b061-726e493271ce - - - - -] Can’t load plugin: sqlalchemy.dialects:cockroachdb