Strapy Error: The server does not support SSL connections
Я устанавливаю strapi командой:
npx create-strapi-app CMS
Далее выбираю:
custom > TS > postgres > CMS > 127.0.0.1 > 5432 > postgres > 12345 > N
мой database.ts
module.exports = ({ env }) => ({
connection: {
client: 'postgres',
connection: {
host: env('DATABASE_HOST', '127.0.0.1'),
port: env.int('DATABASE_PORT', 5432),
database: env('DATABASE_NAME', 'strapi'),
user: env('DATABASE_USERNAME', 'strapi'),
password: env('DATABASE_PASSWORD', 'strapi'),
schema: env('DATABASE_SCHEMA', 'public'), // Not required
ssl: env('DATABASE_SSL', false)
},
debug: false,
},
});
.env
# Database
DATABASE_CLIENT=postgres
DATABASE_HOST=127.0.0.1
DATABASE_PORT=5432
DATABASE_NAME=CMS
DATABASE_USERNAME=postgres
DATABASE_PASSWORD=12345
DATABASE_SSL=false
ошибка
Error: The server does not support SSL connections │
│ at Socket.<anonymous> (C:\Users\User\Desktop\Progect\CMS\node_modules\pg\lib\connection.js:71:37) │
│ at Object.onceWrapper (node:events:632:26) │
│ at Socket.emit (node:events:517:28) │
│ at Socket.emit (node:domain:489:12) │
│ at addChunk (node:internal/streams/readable:335:12) │
│ at readableAddChunk (node:internal/streams/readable:308:9) │
│ at Readable.push (node:internal/streams/readable:245:10) │
│ at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
по разному пытался переписать но всегда одна и таже ошибка
примеры
import { parse } from "pg-connection-string";
export default ({ env }) => ({
connection: {
client: 'postgres',
connection: parse("postgres://postgres:postgres@localhost:5432/postgres?ssl=false")),
},
второй пример
{
client: 'postgres',
connection: {
ssl: false,
user: 'postgres',
password: 'postgres',
port: '5432',
host: 'localhost',
database: 'postgres'
}
}
});