Trying to deploy a Boundary Controller server

Boundary
1

I am trying to deploy a Boundary Controller through a config file and I’m stuck at the point where it can’t find the relations in postgresql. I can attach my config file if needed but here is the error i’m seeing when I start the service:

==> Boundary server started! Log data will stream in below:

2020-10-15T17:12:55.705Z [INFO]  controller: cluster address: addr=[::]:9201
2020-10-15T17:12:55.715Z [ERROR] controller: error performing termination of completed sessions: error="terminate completed sessions: exec: failed: pq: relation "session_state" does not exist"
2020-10-15T17:12:55.740Z [ERROR] controller: error performing status update: error="error performing status upsert: exec: failed: pq: relation "server" does not exist"
2020-10-15T17:12:55.740Z [ERROR] controller: error performing recovery nonce cleanup: error="error performing nonce cleanup: delete: failed pq: relation "recovery_nonces" does not exist"
2020-10-15T17:12:58.311Z [ERROR] controller: internal error returned: error id=CcvtYxk6pa error="lookup scope: failed pq: relation "iam_scope" does not exist fo global"
2020-10-15T17:12:58.352Z [ERROR] controller: internal error returned: error id=9WabyBbrBv error="lookup scope: failed pq: relation "iam_scope" does not exist fo global"
2020-10-15T17:12:58.422Z [ERROR] controller: internal error returned: error id=lxovUg3gSB error="lookup scope: failed pq: relation "iam_scope" does not exist fo global"

My question is, do we need to setup anything else in postgresql other than create the database? It seems to connect to the database fine. My config is also using an admin account in psql as well.

2

Did you run boundary database init?

3

That is what I was missing… Thanks @jeff
As soon as I read your reply I remembered reading that in the docs.

1 Like
4

Where was this in the docs? I cannot find it and I had the exact same issue trying to load a server/controller/worker/listener etc as one. It wasnt the config but rather the lack of database init!

5

@jessequinn - I’m realizing this was somewhat buried in the docs: https://www.boundaryproject.io/docs/installing/no-gen-resources#initialize-the-database

I’m going to fix this up today so it’s surfaced in our database docs for install as well.