Drizzle Team•11mo ago

Unable to get local issuer certificate

getting the above error, using @vercel/postgres and drizzle-orm/vercel-postgres. I think Ive got it all setup correctly. (MacBook Pro, Sonoma 14.0) (following is snippet of relevant parts I think, complete code can be found here: https://github.com/bryce-frontend-mentor-projects/devlinks)

import { sql } from "@vercel/postgres";
import { drizzle } from "drizzle-orm/vercel-postgres";

export const users = pgTable("user", {
...
});

const db = drizzle(sql);

const results = await db.select().from(users)

import { sql } from "@vercel/postgres";
import { drizzle } from "drizzle-orm/vercel-postgres";

export const users = pgTable("user", {
...
});

const db = drizzle(sql);

const results = await db.select().from(users)

with following (redacted) environment variables:

POSTGRES_DATABASE="verceldb"
POSTGRES_HOST="ep-silent-hall-xxxxxxxx-pooler.us-east-1.postgres.vercel-storage.com"
POSTGRES_PASSWORD="redacted"
POSTGRES_PRISMA_URL="postgres://default:3He6WsAwELnx@ep-silent-hall-xxxxxxxx-pooler.us-east-1.postgres.vercel-storage.com/verceldb?pgbouncer=true&connect_timeout=15"
POSTGRES_URL="postgres://default:3He6WsAwELnx@ep-silent-hall-xxxxxxxx-pooler.us-east-1.postgres.vercel-storage.com/verceldb"
POSTGRES_URL_NON_POOLING="postgres://default:3He6WsAwELnx@ep-silent-hall-xxxxxxxx.us-east-1.postgres.vercel-storage.com/verceldb"
POSTGRES_USER="default"
VERCEL="1"
VERCEL_ENV="development"

POSTGRES_DATABASE="verceldb"
POSTGRES_HOST="ep-silent-hall-xxxxxxxx-pooler.us-east-1.postgres.vercel-storage.com"
POSTGRES_PASSWORD="redacted"
POSTGRES_PRISMA_URL="postgres://default:3He6WsAwELnx@ep-silent-hall-xxxxxxxx-pooler.us-east-1.postgres.vercel-storage.com/verceldb?pgbouncer=true&connect_timeout=15"
POSTGRES_URL="postgres://default:3He6WsAwELnx@ep-silent-hall-xxxxxxxx-pooler.us-east-1.postgres.vercel-storage.com/verceldb"
POSTGRES_URL_NON_POOLING="postgres://default:3He6WsAwELnx@ep-silent-hall-xxxxxxxx.us-east-1.postgres.vercel-storage.com/verceldb"
POSTGRES_USER="default"
VERCEL="1"
VERCEL_ENV="development"

1 Reply

k_computer•3mo ago

I'm having this too now. Any luck?

Gaming

Programming

Unable to get local issuer certificate