Unable to access SDDC Manager UI – Error: “Throwing error from session middleware - connect ECONNREFUSED 127.0.0.1:5432”, “code”:“ECONNREFUSED”, “status”:500.

Products

• VMware SDDC Manager

Issue/Introduction

• When attempting to log in to the SDDC Manager UI, the following error message is displayed: " ["message":"Session middleware wrapper failed initial and all retry attempts. Cannot continue. Throwing error from session middleware - connect ECONNREFUSED 127.0.0.1:5432","code":"ECONNREFUSED", "status":500}" 

• The following entries are seen in /var/log/vmware/vcf/sddc-manager-ui-app/sddcManagerServer.log 

[YYYY-MM-DDTHH:MM:SS] ERROR [ea640851ca604377] [services/wrappers/pgSessionWrapper.js, http-get-ui, sessionMiddlewareWrap:83] undefined {"address":"127.0.0.1","code":"ECONNREFUSED","errno":-111,"port":5432,"syscall":"connect"}
[YYYY-MM-DDTHH:MM:SS] ERROR [ea640851ca604377] [services/wrappers/pgSessionWrapper.js, http-get-ui, sessionMiddlewareWrap:84] Error from session middleware caught in middleware wrapper 2 {"error":{"address":"127.0.0.1","code":"ECONNREFUSED","errno":-111,"level":"error","port":5432,"syscall":"connect"}}
[YYYY-MM-DDTHH:MM:SS] VERBOSE [ea640851ca604377] [services/errorHandling.js, http-get-ui, csrfErrorLogger:239] Start csrfErrorLogger()
[YYYY-MM-DDTHH:MM:SS] ERROR [ea640851ca604377] [services/errorHandling.js, http-get-ui, productionErrorRoute:131]
600.158: VError: Sending error response: Session middleware wrapper failed initial and all retry attempts. Cannot continue. Throwing error from session middleware - connect ECONNREFUSED 127.0.0.1:5432
    at Object.errorHandlerSend (/opt/vmware/vcf/sddc-manager-ui-app/server/src/errors/VCFError.js:104:5)
    at productionErrorRoute (/opt/vmware/vcf/sddc-manager-ui-app/server/src/services/errorHandling.js:118:34)
    at Layer.handle_error (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/express/lib/router/layer.js:71:5)
    at trim_prefix (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/express/lib/router/index.js:326:13)
    at /opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/express/lib/router/index.js:286:9
    at Function.process_params (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/express/lib/router/index.js:346:12)
    at next (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/express/lib/router/index.js:280:10)
    at Layer.handle_error (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/express/lib/router/layer.js:67:12)
    at trim_prefix (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/express/lib/router/index.js:326:13)
    at /opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/express/lib/router/index.js:286:9
Error Info: {"id":"56######-####-####-####-#########e20","requestedPath":"/ui/","error":{"errno":-111,"code":"ECONNREFUSED","syscall":"connect","address":"127.0.0.1","port":5432,"level":"error"},"stack":"Error: connect ECONNREFUSED 127.0.0.1:5432\n    at /opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/pg-pool/index.js:45:11\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n    at async PGStore._asyncQuery (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/connect-pg-simple/index.js:321:21)","message":"Session middleware wrapper failed initial and all retry attempts. Cannot continue. Throwing error from session middleware - connect ECONNREFUSED 127.0.0.1:5432","code":"ECONNREFUSED","status":500,"errorModule":600,"errorCode":158}
caused by:
Error: connect ECONNREFUSED 127.0.0.1:5432
    at /opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async PGStore._asyncQuery (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/connect-pg-simple/index.js:321:21)
All Errors Info:
 Session middleware wrapper failed initial and all retry attempts. Cannot continue. Throwing error from session middleware - connect ECONNREFUSED 127.0.0.1:5432 {"code":"ECONNREFUSED","error":{"address":"127.0.0.1","code":"ECONNREFUSED","errno":-111,"level":"error","port":5432,"syscall":"connect"},"id":"56######-####-####-####-#########e20","requestedPath":"/ui/","stack":"Error: connect ECONNREFUSED 127.0.0.1:5432\n    at /opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/pg-pool/index.js:45:11\n    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n    at async PGStore._asyncQuery (/opt/vmware/vcf/sddc-manager-ui-app/server/node_modules/connect-pg-simple/index.js:321:21)","status":500}
(END)

Environment

VMware SDDC Manager 5.2.x

Cause

The SDDC Manager UI service relies on the local PostgreSQL database for session handling. If the service is not running, it results in the UI service being unable to connect to PostgreSQL (ECONNREFUSED ::1:5432), causing GUI inaccessibility.

Resolution

1. Verify the PostgreSQL service status:

systemctl status postgres -l

2. Restart the PostgreSQL service:

systemctl start postgres

 

If the issue is not resolved after restarting the PostgreSQL service reboot the SDDC Manager VM.