relation "users" does not exist

[zebrassimo]

Hi there!

I'm rying to run haystack annotation tool loally. After running docker-compose up in the annotation_tool subfolder, I will be presented th login screen, just like in the handbook of the hosted service. I can't log into the service, can't register.

The console log looks like this:

annotation_tool-db-1 | 2022-07-15 15:25:37.051 UTC [433] FATAL: database "somesafeuser" does not exist
annotation_tool-db-1 | 2022-07-15 15:25:37.094 UTC [442] FATAL: role "somesafepassword" does not exist

A failed login attempt looks like this:

annotation_tool-backend-1 | parameters: undefined
annotation_tool-backend-1 | headers: {"Access-Control-Allow-Origin":"http://localhost:7001","vary":"Origin"}
annotation_tool-backend-1 | pid: 83
annotation_tool-backend-1 | hostname: af3a1f9fa996

I'm trying with:

DEFAULT_ADMIN_EMAIL: "example@example.com"
DEFAULT_ADMIN_PASSWORD: "DEMO_PASSWORD"

running docker ps gives me:

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
af3a1f9fa996 deepset/haystack-annotation:latest "./entrypoint.sh" 23 minutes ago Up 23 minutes 0.0.0.0:7001->7001/tcp, 8080/tcp annotation_tool-backend-1
fecfb23f922d postgres:12 "docker-entrypoint.s…" 24 minutes ago Up 23 minutes (unhealthy) 0.0.0.0:5432->5432/tcp annotation_tool-db-1
8654dda874c6 deepset/haystack-cpu:latest "/bin/bash -c 'sleep…" 28 minutes ago Up 28 minutes 0.0.0.0:8000->8000/tcp haystack-haystack-api-1
ea1af708d222 deepset/elasticsearch-countries-and-capitals "/tini -- /usr/local…" 28 minutes ago Up 28 minutes 0.0.0.0:9200->9200/tcp, 9300/tcp haystack-elasticsearch-1
4e08bdd061ae deepset/haystack-streamlit-ui:latest "/bin/bash -c 'sleep…" 28 minutes ago Up 28 minutes 0.0.0.0:8501->8501/tcp haystack-ui-1

and then docker exec -ti fecfb23f922d bash and psql -h localhost returns:

connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: role "root" does not exist

What am I doing wrong? It looks as if the postgresql is not properly configured.

[tstadel]

@zebrassimo
thx for reporting. There's a bug within the docker-compose file.
As quickfix just correct the username of the following line to somesafeuser as this:
test: "pg_isready --username=somesafeuser && psql --username=somesafeuser --list"

Then it should work. Official fix is underway, too.

[arun-rangarajan]

@tstadel
Thanks, but the quickfix fixed only this issue:
FATAL: role "somesafepassword" does not exist

but I am still getting this error:

annotation_tool-db-1       | 2023-07-11 08:14:43.976 UTC [750] FATAL:  database "somesafeuser" does not exist
annotation_tool-db-1       | 2023-07-11 08:15:14.138 UTC [768] FATAL:  database "somesafeuser" does not exist
annotation_tool-db-1       | 2023-07-11 08:15:44.311 UTC [786] FATAL:  database "somesafeuser" does not exist
annotation_tool-db-1       | 2023-07-11 08:16:14.475 UTC [804] FATAL:  database "somesafeuser" does not exist

The UI doesn't work either. (UPDATE: The UI works after fixing the inbound port rules for the Azure VM to allow port 7001, so the tool itself works fine despite this error message.)

How does one fix this?