Worker pod not able to connect to db about example-voting-app HOT 7 CLOSED

Try adding the following environment variable in db-deployment.yaml.

- name: POSTGRES_HOST_AUTH_METHOD
  value: trust

from example-voting-app.

If you install postgres with minimum version 12, u must add argument for authentication encryption method to md5 , u can add this environtment variable to postgres deployment file
name: POSTGRES_INITDB_ARGS
value: "--auth-host=md5 --auth-local=md5"

from example-voting-app.

If you install postgres with minimum version 12, u must add argument for authentication encryption method to md5 , u can add this environtment variable to postgres deployment file name: POSTGRES_INITDB_ARGS value: "--auth-host=md5 --auth-local=md5"

I've solved worker to db connection issues after adding this env variable. Thanks @feriva22

worker log showed this message:

System.NotSupportedException: Authentication method not supported (Received: 10)
at Npgsql.NpgsqlConnector.ParseServerMessage(ReadBuffer buf, BackendMessageCode code, Int32 len, DataRowLoadingMode dataRowLoadingMode, Boolean isPrependedMessage)
at Npgsql.NpgsqlConnector.DoReadMessage(DataRowLoadingMode dataRowLoadingMode, Boolean isPrependedMessage)
at Npgsql.NpgsqlConnector.ReadMessageWithPrepended(DataRowLoadingMode dataRowLoadingMode)
at Npgsql.NpgsqlConnector.HandleAuthentication(String username, NpgsqlTimeout timeout)
at Npgsql.NpgsqlConnector.Open(NpgsqlTimeout timeout)
at Npgsql.ConnectorPool.Allocate(NpgsqlConnection conn, NpgsqlTimeout timeout)
at Npgsql.NpgsqlConnection.OpenInternal()
at Worker.Program.OpenDbConnection(String connectionString) in /code/src/Worker/Program.cs:line 78
at Worker.Program.Main(String[] args) in /code/src/Worker/Program.cs:line 19

from example-voting-app.

I'm getting the same error.

from example-voting-app.

With the given yamls, worker-app uses the db credentials "postgres:postgres", so you'll need to specify two environment variables with the db (postgres) deployment i.e. POSTGRES_USER: postgres and POSTGRES_PASSWORD: postgres.
Once that's done, worker-app will automatically connect to the db.

from example-voting-app.

With the given yamls, worker-app uses the db credentials "postgres:postgres", so you'll need to specify two environment variables with the db (postgres) deployment i.e. POSTGRES_USER: postgres and POSTGRES_PASSWORD: postgres. Once that's done, worker-app will automatically connect to the db.

this is right i fix my problem by doing this. add two environment postgres name and postgres password to connect postgres,so the db container will run consistantly without exited.
db:
image: postgres:9.4
environment:
POSTGRES_USER: "postgres"
POSTGRES_PASSWORD: "postgres"
them docker-compose up

from example-voting-app.

We're sorry for the late response. Linux images have been refreshed, cleaned up, and are now multi-platform. If you're still having issues with the latest images, feel free to reopen this ticket.

from example-voting-app.