next.js - Cannot get a response from PostgreSQL server

Question

I freely admit that I am completely new to next-auth and the documentation for Credentials is understandably very light. I have got the email link process to work perfectly and will be moving users across top this.

Unfortunately, I have a lot of user data that will require credentials to login and, after spending a few days getting nowhere, I just want to get some idea of what I am doing wrong! This is my [...nextauth].js file:

import NextAuth from "next-auth";
import Providers from "next-auth/providers";
import axios from 'axios'

const options = {
  providers: [
    Providers.Email({
      server: {
        host: process.env.EMAIL_SERVER_HOST,
        port: process.env.EMAIL_SERVER_PORT,
        auth: {
          user: process.env.EMAIL_SERVER_USER,
          pass: process.env.EMAIL_SERVER_PASSWORD
        }
      },
      from: process.env.EMAIL_FROM
    }),
    Providers.Credentials({
      credentials: {
        mem_num: { label: "Membership Number", type: "text", placeholder: "12345" },
        password: { label: "Password", type: "text" }
      },
      authorize: async (credentials) => {
        console.log("credentials: ", credentials)
        try {
          const data = {
            mem_num: credentials.mem_num,
            password: credentials.password
          }
          const user = await login(data)
          if (user) {
            console.log('user:', user)
            return user
          }
        } catch (error) {
          if (error.response) {
            console.log(error.response)
            Promise.reject(new Error('Invalid Number and Password combination'))
          }
        }
      }
    })
  ],
  site: process.env.NEXTAUTH_URL || "http://localhost:3000",
  database: process.env.DATABASE_URL,
  session: {
    // Use JSON Web Tokens for session instead of database sessions.
    // This option can be used with or without a database for users/accounts.
    // Note: `jwt` is automatically set to `true` if no database is specified.
    jwt: true,
  },
}

const login = async data => {
  var config = {
      headers: {
          'Content-Type': "application/json; charset=utf-8",
          'corsOrigin': '*',
          "Access-Control-Allow-Origin": "*"
      }
  };
  const url = process.env.DATABASE_URL;
  const result = await axios.post(url, data, config);
  console.log('result', result);
  return result;
};

export default (req, res) => NextAuth(req, res, options);

question from:https://stackoverflow.com/questions/66050478/cannot-get-a-response-from-postgresql-server

Answer 1

Waitting for answers