Retool stop working, impossible to launch even from server machine by localhost

Self Hosted Retool
,
1

Hi all, facing the issue wia docker and retool. So im trying to use command /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/tryretool/retool-onpremise/ssop/deploy-retool)" < <(echo "SSOP_9433e54d-09ca-455f-8ead-8cc6bf829973")
but getting an output like this :

image
image1346×757 108 KB

also a log here :
sudo docker-compose logs --tail 500
Attaching to retool-onpremise-jobs-runner-1, retool-onpremise-api-1, retool-onpremise-db-connector-1, retool-onpremise-db-ssh-connector-1, retool-onpremise-postgres-1
retool-onpremise-api-1 | at Parser.parse (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:39:38)
retool-onpremise-api-1 | at Socket. (/snapshot/retool_development/node_modules/pg-protocol/dist/index.js:11:42)
retool-onpremise-api-1 | at Socket.emit (node:events:526:28)
retool-onpremise-api-1 | at addChunk (node:internal/streams/readable:315:12)
retool-onpremise-api-1 | at readableAddChunk (node:internal/streams/readable:289:9)
retool-onpremise-api-1 | at Socket.Readable.push (node:internal/streams/readable:228:10)
retool-onpremise-api-1 | at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
retool-onpremise-api-1 | length: 116,
retool-onpremise-api-1 | severity: 'FATAL',
retool-onpremise-api-1 | code: '28P01',
retool-onpremise-api-1 | detail: undefined,
retool-onpremise-api-1 | hint: undefined,
retool-onpremise-api-1 | position: undefined,
retool-onpremise-api-1 | internalPosition: undefined,
retool-onpremise-api-1 | internalQuery: undefined,
retool-onpremise-api-1 | where: undefined,
retool-onpremise-api-1 | schema: undefined,
retool-onpremise-api-1 | table: undefined,
retool-onpremise-api-1 | column: undefined,
retool-onpremise-api-1 | dataType: undefined,
retool-onpremise-api-1 | constraint: undefined,
retool-onpremise-api-1 | file: 'auth.c',
retool-onpremise-api-1 | line: '307',
retool-onpremise-api-1 | routine: 'auth_failed'
retool-onpremise-api-1 | }
retool-onpremise-api-1 | }
retool-onpremise-api-1 | wait-for-it.sh: waiting 15 seconds for postgres:5432
retool-onpremise-api-1 | wait-for-it.sh: postgres:5432 is available after 0 seconds
retool-onpremise-api-1 | not untarring the bundle
retool-onpremise-api-1 | {"message":"[process service types] MAIN_BACKEND","level":"info","timestamp":"2023-02-07T14:05:52.880Z"}
retool-onpremise-api-1 | Failing checking database migrations
retool-onpremise-api-1 | node:internal/process/promises:279
retool-onpremise-api-1 | triggerUncaughtException(err, true /* fromPromise /);
retool-onpremise-api-1 | ^
retool-onpremise-api-1 |
retool-onpremise-api-1 | ConnectionError [SequelizeConnectionError]: password authentication failed for user "retool_internal_user"
retool-onpremise-api-1 | at Client._connectionCallback (/snapshot/retool_development/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:182:24)
retool-onpremise-api-1 | at Client._handleErrorWhileConnecting (/snapshot/retool_development/node_modules/pg/lib/client.js:305:19)
retool-onpremise-api-1 | at Client._handleErrorMessage (/snapshot/retool_development/node_modules/pg/lib/client.js:325:19)
retool-onpremise-api-1 | at Connection.emit (node:events:526:28)
retool-onpremise-api-1 | at /snapshot/retool_development/node_modules/pg/lib/connection.js:114:12
retool-onpremise-api-1 | at Parser.parse (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:40:17)
retool-onpremise-api-1 | at Socket. (/snapshot/retool_development/node_modules/pg-protocol/dist/index.js:11:42)
retool-onpremise-api-1 | at Socket.emit (node:events:526:28)
retool-onpremise-api-1 | at addChunk (node:internal/streams/readable:315:12)
retool-onpremise-api-1 | at readableAddChunk (node:internal/streams/readable:289:9)
retool-onpremise-api-1 | at Socket.Readable.push (node:internal/streams/readable:228:10)
retool-onpremise-api-1 | at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
retool-onpremise-api-1 | parent: error: password authentication failed for user "retool_internal_user"
retool-onpremise-api-1 | at Parser.parseErrorMessage (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:287:98)
retool-onpremise-api-1 | at Parser.handlePacket (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:126:29)
retool-onpremise-api-1 | at Parser.parse (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:39:38)
retool-onpremise-api-1 | at Socket. (/snapshot/retool_development/node_modules/pg-protocol/dist/index.js:11:42)
retool-onpremise-api-1 | at Socket.emit (node:events:526:28)
retool-onpremise-api-1 | at addChunk (node:internal/streams/readable:315:12)
retool-onpremise-api-1 | at readableAddChunk (node:internal/streams/readable:289:9)
retool-onpremise-api-1 | at Socket.Readable.push (node:internal/streams/readable:228:10)
retool-onpremise-api-1 | at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
retool-onpremise-api-1 | length: 116,
retool-onpremise-api-1 | severity: 'FATAL',
retool-onpremise-api-1 | code: '28P01',
retool-onpremise-api-1 | detail: undefined,
retool-onpremise-api-1 | hint: undefined,
retool-onpremise-api-1 | position: undefined,
retool-onpremise-api-1 | internalPosition: undefined,
retool-onpremise-api-1 | internalQuery: undefined,
retool-onpremise-api-1 | where: undefined,
retool-onpremise-api-1 | schema: undefined,
retool-onpremise-api-1 | table: undefined,
retool-onpremise-api-1 | column: undefined,
retool-onpremise-api-1 | dataType: undefined,
retool-onpremise-api-1 | constraint: undefined,
retool-onpremise-api-1 | file: 'auth.c',
retool-onpremise-api-1 | line: '307',
retool-onpremise-api-1 | routine: 'auth_failed'
retool-onpremise-api-1 | },
retool-onpremise-api-1 | original: error: password authentication failed for user "retool_internal_user"
retool-onpremise-api-1 | at Parser.parseErrorMessage (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:287:98)
retool-onpremise-api-1 | at Parser.handlePacket (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:126:29)
retool-onpremise-api-1 | at Parser.parse (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:39:38)
retool-onpremise-api-1 | at Socket. (/snapshot/retool_development/node_modules/pg-protocol/dist/index.js:11:42)
retool-onpremise-api-1 | at Socket.emit (node:events:526:28)
retool-onpremise-api-1 | at addChunk (node:internal/streams/readable:315:12)
retool-onpremise-api-1 | at readableAddChunk (node:internal/streams/readable:289:9)
retool-onpremise-api-1 | at Socket.Readable.push (node:internal/streams/readable:228:10)
retool-onpremise-api-1 | at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
retool-onpremise-api-1 | length: 116,
retool-onpremise-api-1 | severity: 'FATAL',
retool-onpremise-api-1 | code: '28P01',
retool-onpremise-api-1 | detail: undefined,
retool-onpremise-api-1 | hint: undefined,
retool-onpremise-api-1 | position: undefined,
retool-onpremise-api-1 | internalPosition: undefined,
retool-onpremise-api-1 | internalQuery: undefined,
retool-onpremise-api-1 | where: undefined,
retool-onpremise-api-1 | schema: undefined,
retool-onpremise-api-1 | table: undefined,
retool-onpremise-api-1 | column: undefined,
retool-onpremise-api-1 | dataType: undefined,
retool-onpremise-api-1 | constraint: undefined,
retool-onpremise-api-1 | file: 'auth.c',
retool-onpremise-api-1 | line: '307',
retool-onpremise-api-1 | routine: 'auth_failed'
retool-onpremise-api-1 | }
retool-onpremise-api-1 | }
retool-onpremise-db-ssh-connector-1 | [deprecated] do nothing.
retool-onpremise-db-ssh-connector-1 | {"message":"[process service types] DB_SSH_CONNECTOR","level":"info","timestamp":"2023-02-07T14:05:34.281Z"}
retool-onpremise-db-ssh-connector-1 | {"message":"Not configuring Sentry...","level":"info","timestamp":"2023-02-07T14:05:37.862Z"}
retool-onpremise-db-ssh-connector-1 | {"message":"Not configuring StatsD...","level":"info","timestamp":"2023-02-07T14:05:37.862Z"}
retool-onpremise-db-ssh-connector-1 | Setting http and https agent maxSockets to 25
retool-onpremise-db-ssh-connector-1 | {"node_version":"v16.14.2","argv":["--max-http-header-size=80000"],"heap_size_limit_mib":5168,"level":"info","message":"Starting DBConnector","timestamp":"2023-02-07T14:05:37.866Z"}
retool-onpremise-db-ssh-connector-1 | Tue, 07 Feb 2023 14:05:38 GMT body-parser deprecated bodyParser: use individual json/urlencoded middlewares at ../snapshot/retool_development/backend/transpiled/dbconnector/app.js:null:null
retool-onpremise-db-ssh-connector-1 | Tue, 07 Feb 2023 14:05:38 GMT body-parser deprecated undefined extended: provide extended option at ../snapshot/retool_development/node_modules/body-parser/index.js:105:29
retool-onpremise-db-ssh-connector-1 | {"level":"info","durationMs":207,"message":"dbconnector boot-up","timestamp":"2023-02-07T14:05:38.072Z"}
retool-onpremise-db-ssh-connector-1 | {"source":"master","numCPUs":8,"numWorkers":1,"level":"info","message":"[Master] Starting workers","timestamp":"2023-02-07T14:05:38.072Z"}
retool-onpremise-db-ssh-connector-1 | {"source":"master","pid":35,"level":"info","message":"Started worker","timestamp":"2023-02-07T14:05:38.095Z"}
retool-onpremise-db-ssh-connector-1 | (node:9) [DEP0148] DeprecationWarning: Use of deprecated folder mapping "./" in the "exports" field module resolution of the package at /snapshot/retool_development/node_modules/@tryretool/common/package.json.
retool-onpremise-db-ssh-connector-1 | Update this package.json to use a subpath pattern like "./".
retool-onpremise-db-ssh-connector-1 | (Use retool_backend --trace-deprecation ... to show where the warning was created)
retool-onpremise-db-ssh-connector-1 | (node:9) Warning: Accessing non-existent property 'count' of module exports inside circular dependency
retool-onpremise-db-ssh-connector-1 | (node:9) Warning: Accessing non-existent property 'findOne' of module exports inside circular dependency
retool-onpremise-db-ssh-connector-1 | (node:9) Warning: Accessing non-existent property 'remove' of module exports inside circular dependency
retool-onpremise-db-ssh-connector-1 | (node:9) Warning: Accessing non-existent property 'updateOne' of module exports inside circular dependency
retool-onpremise-db-ssh-connector-1 | (node:9) [DEP0111] DeprecationWarning: Access to process.binding('http_parser') is deprecated.
retool-onpremise-db-ssh-connector-1 | {"message":"[process service types] DB_SSH_CONNECTOR","level":"info","timestamp":"2023-02-07T14:05:39.011Z"}
retool-onpremise-db-ssh-connector-1 | {"message":"Not configuring Sentry...","level":"info","timestamp":"2023-02-07T14:05:42.481Z"}
retool-onpremise-db-ssh-connector-1 | {"message":"Not configuring StatsD...","level":"info","timestamp":"2023-02-07T14:05:42.481Z"}
retool-onpremise-db-ssh-connector-1 | Setting http and https agent maxSockets to 25
retool-onpremise-db-ssh-connector-1 | {"node_version":"v16.14.2","argv":["--max-http-header-size=80000"],"heap_size_limit_mib":5168,"level":"info","message":"Starting DBConnector","timestamp":"2023-02-07T14:05:42.485Z"}
retool-onpremise-api-1 | routine: 'auth_failed'
retool-onpremise-api-1 | }
retool-onpremise-api-1 | }
retool-onpremise-api-1 | wait-for-it.sh: waiting 15 seconds for postgres:5432
retool-onpremise-api-1 | wait-for-it.sh: postgres:5432 is available after 0 seconds
retool-onpremise-api-1 | not untarring the bundle
retool-onpremise-api-1 | {"message":"[process service types] MAIN_BACKEND","level":"info","timestamp":"2023-02-07T14:06:10.902Z"}
retool-onpremise-api-1 | Failing checking database migrations
retool-onpremise-api-1 | node:internal/process/promises:279
retool-onpremise-api-1 | triggerUncaughtException(err, true /* fromPromise */);
retool-onpremise-api-1 | ^
retool-onpremise-api-1 |
retool-onpremise-api-1 | ConnectionError [SequelizeConnectionError]: password authentication failed for user "retool_internal_user"
retool-onpremise-api-1 | at Client._connectionCallback (/snapshot/retool_development/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:182:24)
retool-onpremise-api-1 | at Client._handleErrorWhileConnecting (/snapshot/retool_development/node_modules/pg/lib/client.js:305:19)
retool-onpremise-api-1 | at Client._handleErrorMessage (/snapshot/retool_development/node_modules/pg/lib/client.js:325:19)
retool-onpremise-api-1 | at Connection.emit (node:events:526:28)
retool-onpremise-api-1 | at /snapshot/retool_development/node_modules/pg/lib/connection.js:114:12
retool-onpremise-api-1 | at Parser.parse (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:40:17)
retool-onpremise-api-1 | at Socket. (/snapshot/retool_development/node_modules/pg-protocol/dist/index.js:11:42)
retool-onpremise-api-1 | at Socket.emit (node:events:526:28)
retool-onpremise-api-1 | at addChunk (node:internal/streams/readable:315:12)
retool-onpremise-api-1 | at readableAddChunk (node:internal/streams/readable:289:9)
retool-onpremise-api-1 | at Socket.Readable.push (node:internal/streams/readable:228:10)
retool-onpremise-api-1 | at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
retool-onpremise-api-1 | parent: error: password authentication failed for user "retool_internal_user"
retool-onpremise-api-1 | at Parser.parseErrorMessage (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:287:98)
retool-onpremise-api-1 | at Parser.handlePacket (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:126:29)
retool-onpremise-api-1 | at Parser.parse (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:39:38)
retool-onpremise-api-1 | at Socket. (/snapshot/retool_development/node_modules/pg-protocol/dist/index.js:11:42)
retool-onpremise-api-1 | at Socket.emit (node:events:526:28)
retool-onpremise-api-1 | at addChunk (node:internal/streams/readable:315:12)
retool-onpremise-api-1 | at readableAddChunk (node:internal/streams/readable:289:9)
retool-onpremise-api-1 | at Socket.Readable.push (node:internal/streams/readable:228:10)
retool-onpremise-api-1 | at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
retool-onpremise-api-1 | length: 116,
retool-onpremise-api-1 | severity: 'FATAL',
retool-onpremise-api-1 | code: '28P01',
retool-onpremise-api-1 | detail: undefined,
retool-onpremise-api-1 | hint: undefined,
retool-onpremise-api-1 | position: undefined,
retool-onpremise-api-1 | internalPosition: undefined,
retool-onpremise-api-1 | internalQuery: undefined,
retool-onpremise-api-1 | where: undefined,
retool-onpremise-api-1 | schema: undefined,
retool-onpremise-api-1 | table: undefined,
retool-onpremise-api-1 | column: undefined,
retool-onpremise-api-1 | dataType: undefined,
retool-onpremise-api-1 | constraint: undefined,
retool-onpremise-api-1 | file: 'auth.c',
retool-onpremise-api-1 | line: '307',
retool-onpremise-api-1 | routine: 'auth_failed'
retool-onpremise-api-1 | },
retool-onpremise-api-1 | original: error: password authentication failed for user "retool_internal_user"
retool-onpremise-api-1 | at Parser.parseErrorMessage (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:287:98)
retool-onpremise-api-1 | at Parser.handlePacket (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:126:29)
retool-onpremise-api-1 | at Parser.parse (/snapshot/retool_development/node_modules/pg-protocol/dist/parser.js:39:38)
retool-onpremise-api-1 | at Socket. (/snapshot/retool_development/node_modules/pg-protocol/dist/index.js:11:42)
retool-onpremise-api-1 | at Socket.emit (node:events:526:28)
retool-onpremise-api-1 | at addChunk (node:internal/streams/readable:315:12)
retool-onpremise-api-1 | at readableAddChunk (node:internal/streams/readable:289:9)
retool-onpremise-postgres-1 | LOG: database system was shut down at 2023-02-07 14:05:19 UTC
retool-onpremise-postgres-1 | LOG: MultiXact member wraparound protections are now enabled
retool-onpremise-jobs-runner-1 | wait-for-it.sh: waiting 15 seconds for postgres:5432
retool-onpremise-api-1 | at Socket.Readable.push (node:internal/streams/readable:228:10)
retool-onpremise-jobs-runner-1 | wait-for-it.sh: postgres:5432 is available after 0 seconds
retool-onpremise-db-connector-1 | {"message":"[process service types]
retool-onpremise-jobs-runner-1 | wait-for-it.sh: waiting 15 seconds for postgres:5432
retool-onpremise-jobs-runner-1 | wait-for-it.sh: postgres:5432 is available after 0 seconds
retool-onpremise-postgres-1 | Connection matched pg_hba.conf line 95: "host all all all md5"
retool-onpremise-jobs-runner-1 | not untarring the bundle
retool-onpremise-jobs-runner-1 | {"message":"[process service types] JOBS_RUNNER","level":"info","timestamp":"2023-02-07T14:05:52.538Z"}
retool-onpremise-jobs-runner-1 | Failing checking database migrations
retool-onpremise-jobs-runner-1 |
retool-onpremise-jobs-runner-1 | ---------------------------
retool-onpremise-jobs-runner-1 | - EXITING RETOOL -
retool-onpremise-jobs-runner-1 | ---------------------------
retool-onpremise-jobs-runner-1 |
retool-onpremise-jobs-runner-1 | Error running database migrations: SequelizeConnectionError: password authentication failed for user "retool_internal_user"
retool-onpremise-jobs-runner-1 | wait-for-it.sh: waiting 15 seconds for postgres:5432
retool-onpremise-jobs-runner-1 | wait-for-it.sh: postgres:5432 is available after 0 seconds
retool-onpremise-jobs-runner-1 | not untarring the bundle
retool-onpremise-jobs-runner-1 | {"message":"[process service types] JOBS_RUNNER","level":"info","timestamp":"2023-02-07T14:05:56.051Z"}
retool-onpremise-jobs-runner-1 | Failing checking database migrations
retool-onpremise-jobs-runner-1 |
retool-onpremise-jobs-runner-1 | ---------------------------
retool-onpremise-jobs-runner-1 | - EXITING RETOOL -
retool-onpremise-jobs-runner-1 | ---------------------------
retool-onpremise-jobs-runner-1 |
retool-onpremise-jobs-runner-1 | Error running database migrations: SequelizeConnectionError: password authentication failed for user "retool_internal_user"
retool-onpremise-jobs-runner-1 | wait-for-it.sh: waiting 15 seconds for postgres:5432
retool-onpremise-jobs-runner-1 | wait-for-it.sh: postgres:5432 is available after 0 seconds
retool-onpremise-jobs-runner-1 | not untarring the bundle
retool-onpremise-jobs-runner-1 | {"message":"[process service types] JOBS_RUNNER","level":"info","timestamp":"2023-02-07T14:05:59.649Z"}
retool-onpremise-jobs-runner-1 | Failing checking database migration
So probably its bcs of some password to retool internal user, but i never initialize this user and never setted this password, so im confused. If someone faced same case or know or have an idea about solutions - you are welcome)

2

I ran into some errors with running that command. This is the startup script we are using.

##Edit this command if the retool folder is NOT in /Home//
cd retool/retool-onpremise/

sudo docker-compose up -d

1 Like
3

Thank you, i used sudo docker-compose up -d. its started without errors, but retool still can`t be run. I try to launch it wia localhost:3000 ... or with public_ip:3000 or whatever ip.

4

Hi @Nik_Kimp Thanks for the update! So are there currently no errors in the container logs? What happens when you try to launch it via localhost:3000 (or public_ip:3000, any ip)? Can you share a screenshot?

5

I would expect that we still need to address the password issues. I'm linking a similar issue here and here

6

Thought of something else maybe. Where are you running retool? Is it on a Linux VM? If you are using the browser on the Linux box, you can use "localhost:3000" in the browser of the VM. Also, if you want it to be accessible on your local network, you may need to put the VM network adapter in bridged mode. This will cause the VM to get a separate IP address on the local network. You can either set it statically or let it get one through DHCP. Then you can access the VM's IP address on your network with: xxx.xxx.xxx.xxx:3000, where the x's are replaced with the VM IP. Hope this helps.

1 Like