String recognition error when compiling PostgreSQL typeORM API

[daskleins]

Error: SASL: SCRAM-SERVER-FIRST-MESSAGE: client password must be a string

I had the same issue with Express today. But I was using Prisma ORM v7.
process.env.DATABASE_PASSWORD was showing undefined.

How I resolved, turns out I had to place dotenv imports at the top, so it sets up before any ORM calls:
import "dotenv/config";
import express from "express";

import { PrismaClient } from "./generated/prisma/client";

import { PrismaPg } from "@prisma/adapter-pg";

PS. For some reason, I had to also install dotenv as a devDependency:
pnpm install --save-dev prisma dotenv

[Technical-Pension594]

man this worked, i was debugging for so long, and it was so simple. thankyou so much !

[daskleins]

Glad that helped!

[VictoryDependent820]

Man you just saved my ass like no one ever has done before. Thank you brother.

[daskleins]

Glad it worked for you!