[SequelizeConnectionError]: The server does not support SSL connections

[dev-nicelee]

Recently, I met an error below during deployment in production..

0|outline  | ConnectionError [SequelizeConnectionError]: The server does not support SSL connections
0|outline  |     at Client._connectionCallback (/home/ubuntu/outline/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:188:20)
0|outline  |     at Client._handleErrorWhileConnecting (/home/ubuntu/outline/node_modules/pg/lib/client.js:305:19)
0|outline  |     at Client._handleErrorEvent (/home/ubuntu/outline/node_modules/pg/lib/client.js:315:19)
0|outline  |     at Connection.emit (events.js:315:20)
0|outline  |     at Connection.EventEmitter.emit (domain.js:482:12)
0|outline  |     at Socket.<anonymous> (/home/ubuntu/outline/node_modules/pg/lib/connection.js:72:23)
0|outline  |     at Object.onceWrapper (events.js:422:26)
0|outline  |     at Socket.emit (events.js:315:20)
0|outline  |     at Socket.EventEmitter.emit (domain.js:482:12)
0|outline  |     at addChunk (_stream_readable.js:295:12)
0|outline  |     at readableAddChunk (_stream_readable.js:271:9)
0|outline  |     at Socket.Readable.push (_stream_readable.js:212:10)
0|outline  |     at TCP.onStreamRead (internal/stream_base_commons.js:186:23) {
0|outline  |   parent: Error: The server does not support SSL connections
0|outline  |       at Socket.<anonymous> (/home/ubuntu/outline/node_modules/pg/lib/connection.js:72:37)
0|outline  |       at Object.onceWrapper (events.js:422:26)
0|outline  |       at Socket.emit (events.js:315:20)
0|outline  |       at Socket.EventEmitter.emit (domain.js:482:12)
0|outline  |       at addChunk (_stream_readable.js:295:12)
0|outline  |       at readableAddChunk (_stream_readable.js:271:9)
0|outline  |       at Socket.Readable.push (_stream_readable.js:212:10)
0|outline  |       at TCP.onStreamRead (internal/stream_base_commons.js:186:23),
0|outline  |   original: Error: The server does not support SSL connections
0|outline  |       at Socket.<anonymous> (/home/ubuntu/outline/node_modules/pg/lib/connection.js:72:37)
0|outline  |       at Object.onceWrapper (events.js:422:26)
0|outline  |       at Socket.emit (events.js:315:20)
0|outline  |       at Socket.EventEmitter.emit (domain.js:482:12)
0|outline  |       at addChunk (_stream_readable.js:295:12)
0|outline  |       at readableAddChunk (_stream_readable.js:271:9)
0|outline  |       at Socket.Readable.push (_stream_readable.js:212:10)
0|outline  |       at TCP.onStreamRead (internal/stream_base_commons.js:186:23)

I tried both options..

• PGSSLMODE=disable
• yarn sequelize:migrate --env=production-ssl-disabled

But still get an error when I get a log from pm2 process.

Is it because I ran server without SSL certificate?🤔

[tommoor]

Is it because I ran server without SSL certificate?🤔

Correct, but it is supported with PGSSLMODE=disable environment variable as you tried. Make sure NODE_ENV=production as well.

[dev-nicelee]

@tommoor Please forgive my dummy behavior🙏 I kept setting my env variable in a postgres docker container..🤦🏻‍♂️

It's resolved by export PGSSLMODE=disable in the server.