ConnectionError [SequelizeConnectionError]: password authentication failed for user "retool_internal_user"

when I try to compose up,the logs print this error. there are 2 postgre credentials info(postgres,hammerhead_production) in docker.envfile and 1(retooldb-postgres) in retooldb.env. Those are both generated automatically when its composing up. What is the problem here ?

code-executor_1         | {"level":"info","message":"CPU utilization: 93.89","timestamp":"2024-02-23T07:06:39.178Z"}
code-executor_1         | {"level":"info","message":"Memory usage: 62.45","timestamp":"2024-02-23T07:06:39.184Z"}
postgres_1              | 2024-02-23 07:06:39.302 UTC [64] LOG:  incomplete startup packet
api_1                   | wait-for-it.sh: postgres:5432 is available after 0 seconds
api_1                   | not untarring the bundle
db-ssh-connector_1      | {"level":"info","message":"[process service types] DB_SSH_CONNECTOR","timestamp":"2024-02-23T07:06:39.531Z"}
db-connector_1          | {"level":"info","message":"[process service types] DB_CONNECTOR","timestamp":"2024-02-23T07:06:39.571Z"}
workflows-worker_1      | wait-for-it.sh: waiting 15 seconds for postgres:5432
postgres_1              | 2024-02-23 07:06:40.174 UTC [65] LOG:  incomplete startup packet
workflows-worker_1      | wait-for-it.sh: postgres:5432 is available after 0 seconds
workflows-worker_1      | not untarring the bundle
workflows-backend_1     | {"level":"info","message":"[process service types] WORKFLOW_BACKEND, DB_CONNECTOR, DB_SSH_CONNECTOR","timestamp":"2024-02-23T07:06:40.363Z"}
api_1                   | sed: can't read ./dist/mobile/*.js: No such file or directory
workflows-backend_1     | Failing checking database migrations
postgres_1              | 2024-02-23 07:06:41.024 UTC [66] FATAL:  password authentication failed for user "retool_internal_user"
postgres_1              | 2024-02-23 07:06:41.024 UTC [66] DETAIL:  Password does not match for user "retool_internal_user".
postgres_1              |       Connection matched pg_hba.conf line 95: "host all all all md5"
workflows-backend_1     | /node_modules/sequelize/lib/dialects/postgres/connection-manager.js:143
workflows-backend_1     |                 reject(new sequelizeErrors.ConnectionError(err));
workflows-backend_1     |                        ^
workflows-backend_1     |
workflows-backend_1     | ConnectionError [SequelizeConnectionError]: password authentication failed for user "retool_internal_user"
workflows-backend_1     |     at Client._connectionCallback (/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:143:24)
workflows-backend_1     |     at Client._handleErrorWhileConnecting (/node_modules/pg/lib/client.js:305:19)
workflows-backend_1     |     at Client._handleErrorMessage (/node_modules/pg/lib/client.js:325:19)
workflows-backend_1     |     at Connection.emit (node:events:517:28)
workflows-backend_1     |     at /node_modules/pg/lib/connection.js:114:12
workflows-backend_1     |     at Parser.parse (/node_modules/pg-protocol/dist/parser.js:40:17)
workflows-backend_1     |     at Socket.<anonymous> (/node_modules/pg-protocol/dist/index.js:11:42)
workflows-backend_1     |     at Socket.emit (node:events:517:28)
workflows-backend_1     |     at addChunk (node:internal/streams/readable:335:12)
workflows-backend_1     |     at readableAddChunk (node:internal/streams/readable:308:9) {
workflows-backend_1     |   parent: error: password authentication failed for user "retool_internal_user"
workflows-backend_1     |       at Parser.parseErrorMessage (/node_modules/pg-protocol/dist/parser.js:287:98)
workflows-backend_1     |       at Parser.handlePacket (/node_modules/pg-protocol/dist/parser.js:126:29)
workflows-backend_1     |       at Parser.parse (/node_modules/pg-protocol/dist/parser.js:39:38)
workflows-backend_1     |       at Socket.<anonymous> (/node_modules/pg-protocol/dist/index.js:11:42)
workflows-backend_1     |       at Socket.emit (node:events:517:28)
workflows-backend_1     |       at addChunk (node:internal/streams/readable:335:12)
workflows-backend_1     |       at readableAddChunk (node:internal/streams/readable:308:9)
workflows-backend_1     |       at Readable.push (node:internal/streams/readable:245:10)
workflows-backend_1     |       at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
workflows-backend_1     |     length: 116,
workflows-backend_1     |     severity: 'FATAL',
workflows-backend_1     |     code: '28P01',
workflows-backend_1     |     detail: undefined,
workflows-backend_1     |     hint: undefined,
workflows-backend_1     |     position: undefined,
workflows-backend_1     |     internalPosition: undefined,
workflows-backend_1     |     internalQuery: undefined,
workflows-backend_1     |     where: undefined,
workflows-backend_1     |     schema: undefined,
workflows-backend_1     |     table: undefined,
workflows-backend_1     |     column: undefined,
workflows-backend_1     |     dataType: undefined,
workflows-backend_1     |     constraint: undefined,
workflows-backend_1     |     file: 'auth.c',
workflows-backend_1     |     line: '337',
workflows-backend_1     |     routine: 'auth_failed'
workflows-backend_1     |   },
workflows-backend_1     |   original: error: password authentication failed for user "retool_internal_user"
workflows-backend_1     |       at Parser.parseErrorMessage (/node_modules/pg-protocol/dist/parser.js:287:98)
workflows-backend_1     |       at Parser.handlePacket (/node_modules/pg-protocol/dist/parser.js:126:29)
workflows-backend_1     |       at Parser.parse (/node_modules/pg-protocol/dist/parser.js:39:38)
workflows-backend_1     |       at Socket.<anonymous> (/node_modules/pg-protocol/dist/index.js:11:42)
workflows-backend_1     |       at Socket.emit (node:events:517:28)
workflows-backend_1     |       at addChunk (node:internal/streams/readable:335:12)
workflows-backend_1     |       at readableAddChunk (node:internal/streams/readable:308:9)
workflows-backend_1     |       at Readable.push (node:internal/streams/readable:245:10)
workflows-backend_1     |       at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
workflows-backend_1     |     length: 116,
workflows-backend_1     |     severity: 'FATAL',
workflows-backend_1     |     code: '28P01',
workflows-backend_1     |     detail: undefined,
workflows-backend_1     |     hint: undefined,
workflows-backend_1     |     position: undefined,
workflows-backend_1     |     internalPosition: undefined,
workflows-backend_1     |     internalQuery: undefined,
workflows-backend_1     |     where: undefined,
workflows-backend_1     |     schema: undefined,
workflows-backend_1     |     table: undefined,
workflows-backend_1     |     column: undefined,
workflows-backend_1     |     dataType: undefined,
workflows-backend_1     |     constraint: undefined,
workflows-backend_1     |     file: 'auth.c',
workflows-backend_1     |     line: '337',
workflows-backend_1     |     routine: 'auth_failed'
workflows-backend_1     |   }
workflows-backend_1     | }
workflows-backend_1     |
workflows-backend_1     | Node.js v18.18.2
workflows-worker_1      | sed: can't read ./dist/mobile/*.js: No such file or directory

Hi @mkusakci, if this not the first time we are installing Retool, deleting old volumes should solve the problem. If this is the first time, let us know! :eyes:

1 Like