laubonghaudoi
laubonghaudoi
DTDrizzle Team
Created by laubonghaudoi on 7/11/2023 in #help
Error: self signed certificate in certificate chain
Hello, I am a new user of drizzle and trying to run the command for the first time:
drizzle-kit introspect:pg
drizzle-kit introspect:pg
But I got this error
[⣟] 0 tables fetching
[⣟] 0 columns fetching
[⣟] 0 enums fetching
[⣟] 0 indexes fetching
[⣟] 0 foreign keys fetching
Error: self signed certificate in certificate chain
at TLSSocket.onConnectSecure (node:_tls_wrap:1530:34)
at TLSSocket.emit (node:events:390:28)
at TLSSocket._finishInit (node:_tls_wrap:944:8)
at TLSWrap.ssl.onhandshakedone (node:_tls_wrap:725:12) {
code: 'SELF_SIGNED_CERT_IN_CHAIN'
}
[⣟] 0 tables fetching
[⣟] 0 columns fetching
[⣟] 0 enums fetching
[⣟] 0 indexes fetching
[⣟] 0 foreign keys fetching
Error: self signed certificate in certificate chain
at TLSSocket.onConnectSecure (node:_tls_wrap:1530:34)
at TLSSocket.emit (node:events:390:28)
at TLSSocket._finishInit (node:_tls_wrap:944:8)
at TLSWrap.ssl.onhandshakedone (node:_tls_wrap:725:12) {
code: 'SELF_SIGNED_CERT_IN_CHAIN'
}
I am connecting drizzle to my Supabase instance, and my config file is like this
import type { Config } from "drizzle-kit";

export default {
schema: "./src/schema.ts",
driver: "pg",
out: "./drizzle",
dbCredentials: {
host: process.env.host,
port: 5432,
user: "postgres",
password: process.env.password,
database: "postgres",
ssl: true,
},
} satisfies Config;
import type { Config } from "drizzle-kit";

export default {
schema: "./src/schema.ts",
driver: "pg",
out: "./drizzle",
dbCredentials: {
host: process.env.host,
port: 5432,
user: "postgres",
password: process.env.password,
database: "postgres",
ssl: true,
},
} satisfies Config;
I have already enabled ssl, why does this happen and how to resolve this?
28 replies