studio dosnt connect, stuck on the launch screen, neon websock, then something about .pem file.

I’m getting the error of:

no such file or directory, open '/Users/MYCOMPUTER/Library/Application Support/drizzle-studio/localhost-key.pem'

no such file or directory, open '/Users/MYCOMPUTER/Library/Application Support/drizzle-studio/localhost-key.pem'

Also: '@Neondatabase/serverless' can only connect to remote Neon/Vercel Postgres/Supabase instances through a websocket What websocket? There’s also a package mckat? I installed the correct spelling But nothing changed

11 Replies

rphlmr ⚡•5mo ago

👋 I have just launch a Neon db following https://orm.drizzle.team/docs/get-started-postgresql#neon-postgres and I am not able to reproduce. I use import { neon } from '@neondatabase/serverless'; as driver My config:

export default {
  schema: "./index.ts",
  dialect: "postgresql",
  out: "drizzle",
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
  strict: true,
} satisfies Config;

export default {
  schema: "./index.ts",
  dialect: "postgresql",
  out: "drizzle",
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
  strict: true,
} satisfies Config;

I have launched studio with npx drizzle-kit studio it seems you are using drizzle studio as a PWA right? would you mind to delete it and try from https://local.drizzle.studio/ ?

rphlmr ⚡•5mo ago

also you have to follow https://github.com/FiloSottile/mkcert?tab=readme-ov-file#macos for the cert issue

GitHub

GitHub - FiloSottile/mkcert: A simple zero-config tool to make loca...

A simple zero-config tool to make locally trusted development certificates with any names you'd like. - FiloSottile/mkcert

rphlmr ⚡•5mo ago

it's not a npm package, just an authority for self signed certificates like the one used by drizzle studio

brew install mkcert
brew install nss # if you use Firefox

brew install mkcert
brew install nss # if you use Firefox

Then mkcert -install and restart drizzle studio (npx drizzle-kit studio)

JustCodeItAllOP•5mo ago

Is there npm version? Where is the Config imported from? I think that did it… there’s no error I think that just worked, I haven’t tried the Mercer cat, but….idk how to install that The official docs are wrong, this is about the 10th time errors I. Docs are wrong… and I’m blamed 😆

rphlmr ⚡•5mo ago

Oh it’s just a type from drizzle-kit Mkcert and nss are not js packages 😬

JustCodeItAllOP•5mo ago

How do I fix it?

rphlmr ⚡•5mo ago

Installing it like https://discord.com/channels/1043890932593987624/1261800215313121371/1262810645645234298

brew install mkcert
brew install nss # if you use Firefox

brew install mkcert
brew install nss # if you use Firefox

Then mkcert -install and restart drizzle studio (npx drizzle-kit studio) I did nothing more 🫣

JustCodeItAllOP•5mo ago

I don’t use brew, did it work for you? I just talked to someone from drizzle, he said it was a wrong version in the docs

rphlmr ⚡•5mo ago

Yes I use brew for many things (installing node and some other tools). Brew is like a npm but for native macos/linux cli-tools/apps And yes it worked the first time for me 😦 #gateway is maybe the best solution in the future

JustCodeItAllOP•5mo ago

Did you choose App router? Or Page dir?

rphlmr ⚡•5mo ago

I don’t use Nextjs 🫣

Gaming

Programming

studio dosnt connect, stuck on the launch screen, neon websock, then something about .pem file.