844600078504951838 #spicedb

Channels

zanzibar

spicedb

Jake

10/28/2021, 2:56 PM

spicedb does not store any data durably, it delegates that to the datastores, e.g. postgres/cockroachdb

sleipnir042

10/28/2021, 2:56 PM

🤦 of course

sleipnir042

10/28/2021, 2:57 PM

☕

sleipnir042

10/28/2021, 4:04 PM

Is there anything I need to do to initialize the postgres schema?

Copy code

spicedb_1  | {"level":"error","module":"pgx","args":[9223372036854775807],"err":"ERROR: relation \"namespace_config\" does not exist (SQLSTATE 42P01)","pid":85,"sql":"SELECT serialized_config, created_transaction FROM namespace_config WHERE deleted_transaction = $1","time":"2021-10-28T16:03:30Z","message":"Query"}

sleipnir042

10/28/2021, 4:05 PM

Also seeing a bunch of these. Not sure if that's a problem.

Copy code

spicedb_1  | {"level":"warn","error":"unable to instantiate AlembicPostgresDriver: pq: SSL is not enabled on the server","time":"2021-10-28T16:05:19Z","message":"error when attempting to perform garbage collection"}

Jake

10/28/2021, 4:12 PM

You need to run the

migrate

sub command. But it also looks like your connection string needs work

sleipnir042

10/28/2021, 4:17 PM

It looks ok and I can use it in IntelliJ to get a connection: postgres://spicedb:25p1cy4m3@psql:5432/spicedb

sleipnir042

10/28/2021, 4:18 PM

That pwd isn't sensitive, it's for my local docker config.

sleipnir042

10/28/2021, 4:22 PM

psql

is linked in docker-compose, and this gets run on db init:

Copy code

create user spicedb;
alter user spicedb password '25p1cy4m3';
create database spicedb;
grant all on database spicedb to spicedb;

sleipnir042

10/28/2021, 4:26 PM

I needed a

?sslmode=disable

on the end

Jake

10/28/2021, 5:15 PM

message has been deleted

ariel

10/28/2021, 6:08 PM

message has been deleted

Jake

10/28/2021, 6:09 PM

message has been deleted

sleipnir042

10/28/2021, 7:39 PM

Hi again. Is there a public docker image for spicedb based on the alpine distro instead of distroless? I'm finding I need to use

wait-for-it.sh

to force spicedb to wait for postgres to come up.

Jake

10/28/2021, 7:44 PM

you're using postgres inside k8s, right?

fukuroutoimasu

10/28/2021, 7:44 PM

you could just use an init-container that does that

fukuroutoimasu

10/28/2021, 7:44 PM

oh wait, you're using compose, right?

Jake

10/28/2021, 7:47 PM

this is what we used to use when we were using compose in dev: https://stackoverflow.com/a/55835081

sleipnir042

10/28/2021, 7:51 PM

docker-compose

sleipnir042

10/28/2021, 7:51 PM

yep

sleipnir042

10/28/2021, 7:52 PM

ahhhhh, health checks.

sleipnir042

10/28/2021, 7:52 PM

I think that'll get me some of the way.

sleipnir042

10/28/2021, 8:19 PM

Docker removed

depends_on

conditions from v3 of compose.

Jake

10/28/2021, 8:19 PM

the stack overflow seems to indicate that it still works, but maybe only the simple form?

sleipnir042

10/28/2021, 8:22 PM

Yeah, with v3 they removed the ability to do conditions. Just the simple form.

sleipnir042

10/28/2021, 8:22 PM

I'm gonna see what happens if I drop the config version to v2

Jake

10/28/2021, 8:22 PM

let me see if I can dig out what we used to do...

Jake

10/28/2021, 8:26 PM

so we were using version

3.8

Jake

10/28/2021, 8:26 PM

and we used basically exactly what was in the SO post

Jake

10/28/2021, 8:27 PM

Copy code

depends_on:
      db:
        condition: service_healthy