Cannot connect to Neon database

Community
1

hi, i am trying to connect my application using nestjs with neon db, but i am getting error message “connection is insecure (try using sslmode=require)” , how can i fix it ? Thanks

337630041_203540669061471_1439009966444800718_n
337630041_203540669061471_1439009966444800718_n705×85 5.44 KB

2

Can you try adding ?sslmode=require at the end of the connection string?

3

Hi Stas, where can i add ? thank you

337774413_5758209290968513_798739669242798504_n
337774413_5758209290968513_798739669242798504_n692×395 21.5 KB

4

As per TypeORM / postgres.js documentation you most likely can add ssl: 'require' key to the settings

5

I am getting this same error using NestJS and Neon, do you have any updates, or did you get this to work @Stas_Kelvich & @phuonghust2110 ?

7

I just got it to work here’s my code:

@Module({
    imports: [
        ConfigModule.forRoot({ isGlobal: true }),
        TypeOrmModule.forRoot({
            type: 'postgres',
            host: process.env.POSTGRES_HOST,
            port: parseInt(<string>process.env.POSTGRES_PORT),
            username: process.env.POSTGRES_USER,
            password: process.env.POSTGRES_PASSWORD,
            database: process.env.POSTGRES_DATABASE,
            autoLoadEntities: true,
            options: { encrypt: false },
            logging: true,
            synchronize: true, // shouldn't really be used in production - may lose data

            ssl: true,
            extra: {
                ssl: {
                    rejectUnauthorized: false,
                },
            },
        }),
        SummaryModule,
        AuthModule,
    ],
    controllers: [AppController],
    providers: [
        AppService,
        {
            provide: APP_FILTER,
            useClass: AllExceptionsFilter,
        },
    ],
})
4 Likes
8

Hi, please am also experiencing this on my project and have added sslmode=require but it still throwing the error please how can I go about this issue? thank you.

sslmode1
sslmode11656×679 48.1 KB

9

I see that you are connecting from Sequelize. Please see this post: