Failed to connect to the database [Error: The edge runtime does not support Node.js 'net' module. when using drizzle

[vatoer]

Following the documentation is challenging,

so far I can connect my database with drizzle, and can query from database but when I try to insert this logic to credential authorize it become error

and then

in my auth.config.ts

import bcrypt from "bcryptjs";
import Credentials from "next-auth/providers/credentials";
import Google from "next-auth/providers/google";

import { LoginSchema } from "@/auth/login/_zodschema/login";
import { getUserByEmail } from "@/data/auth/user2";
import { NextAuthConfig } from "next-auth";

export default {
  //  basePath: "/api/auth", // <https://github.com/nextauthjs/next-auth/discussions/9748
  trustHost: true, // <https://github.com/nextauthjs/next-auth/issues/8327>
  pages: {
    signIn: "/login",
    signOut: "/logout",
  },
  providers: [
    Google({
      clientId: process.env.GOOGLE_CLIENT_ID,
      clientSecret: process.env.GOOGLE_CLIENT_SECRET,
      allowDangerousEmailAccountLinking: true, // <https://github.com/nextauthjs/next-auth/issues/519>
    }),
    Credentials({
      async authorize(credentials) {
        const validatedCredentials = LoginSchema.safeParse(credentials);

        if (validatedCredentials.success) {
          const { email, password } = validatedCredentials.data;
          const user = await getUserByEmail(email);
          console.log("user", user);
          if (!user || !user.password) {
            return null;
          }

          const isPasswordMatch = await bcrypt.compare(password, user.password);
          if (!isPasswordMatch) {
            return null;
          }

          //return user;
          return {
            ...user,
            perwakilan: "perwakilan", // bagaimana cara mendapatkan perwakilan dari user?
          };
        }

        return null;
      },
    }),
  ],
  callbacks: {
    async signIn({ user, account, profile, email, credentials }) {
      if (!user || !account) {
        throw new Error("Invalid sign in");
      }

      if (account.provider === "google" && profile) {
        //console.log("profile", profile);
        //console.log("user", user);
        const { name, email, picture } = profile;
        if (!email || !name) {
          throw new Error("Google account missing email");
        }
        const img = picture || null;
        //update user profile
        return true;
      }
      return true;
    },
    async session({ session, token }) {
      //console.log("session", session);
      //console.log("token", token);
      session.user.id = token.sub as string;
      return session;
    },
    async jwt({ token, user, account, profile }) {
      //console.log("[jwt] token", token);
      //console.log("[jwt] account", account);
      if (user) {
        token.id = user.id;
        //token.sekolahId = user.sekolahId;
      }
      return token;
    },
  },
} satisfies NextAuthConfig;

auth.ts

import { DrizzleAdapter } from "@auth/drizzle-adapter";
import NextAuth from "next-auth";
import Google from "next-auth/providers/google";
import authConfig from "./auth.config";
import { dbauth } from "./drizzle/dbauth";

export const {
  handlers: { GET, POST },
  signIn,
  signOut,
  auth,
} = NextAuth({
  adapter: DrizzleAdapter(dbauth),
  ...authConfig,
});

and my user2.ts

import { DrizzleAdapter } from "@auth/drizzle-adapter";
import NextAuth from "next-auth";
import Google from "next-auth/providers/google";
import authConfig from "./auth.config";
import { dbauth } from "./drizzle/dbauth";

export const {
  handlers: { GET, POST },
  signIn,
  signOut,
  auth,
} = NextAuth({
  adapter: DrizzleAdapter(dbauth),
  ...authConfig,
});

my drizzle conection

import { drizzle } from "drizzle-orm/mysql2";
import mysql from "mysql2/promise";
import { env } from "process";
import * as schema from "./schema";

let connection;

try {
  const { DB_HOST, DB_PORT, DB_USERNAME, DB_PASSWORD, DB_NAME } = process.env;

  //console.log(env);

  if (!DB_HOST || !DB_PORT || !DB_USERNAME || !DB_PASSWORD || !DB_NAME) {
    throw new Error("Required environment variables are not set");
  }

  connection = await mysql.createConnection({
    host: DB_HOST,
    port: Number(DB_PORT),
    user: DB_USERNAME,
    password: DB_PASSWORD,
    database: DB_NAME,
  });
} catch (error) {
  console.error("Failed to connect to the database", error);
  throw error;
  //process.exit(1);
}

export const dbauth = drizzle(connection, { schema, mode: "default" });

and then I got a bunch of error

The generated code contains 'async/await' because this module is using "topLevelAwait".
However, your target environment does not appear to support 'async/await'.
As a result, the code may not run as expected or may cause runtime errors.

 ⚠ Fast Refresh had to perform a full reload due to a runtime error.
 ⨯ Error: The edge runtime does not support Node.js 'net' module.

Failed to connect to the database [Error: The edge runtime does not support Node.js 'net' module.

[jamespantalones]

did you look at this? https://authjs.dev/getting-started/migrating-to-v5#edge-compatibility

you will probably use lazy initialization like they recommend

[vatoer]

Yes, already look into this, still trying to figure it out to implement with drizzle, another problem is async await in top level to initialize db connection on drizzle.

[Waylon-Firework]

did you look at this? https://authjs.dev/getting-started/migrating-to-v5#edge-compatibility

you will probably use lazy initialization like they recommend

I fixed the issue based on the link. Thank you

[Waylon-Firework]

I also met the issue. The problem occurs when retrieving the session from the database.

[Waylon-Firework]

I use mysql2.

[Waylon-Firework]

Although it failed the first time, it will be called again and the second time is successful. So it has not affected my use at present. There is just an error message all the time.

[Waylon-Firework]

#10796 (reply in thread)