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.