Cannot Connect to Postgres

[mertturkmenoglu]

Hello everyone,

I am trying to use the email provider and Postgres database. I enter my email, an email magic link comes to my mailbox. After I click the link, I get the following result:

TypeError: Cannot read property 'isConnected' of null

I inspect the database and the tables are there. I can see the verification_requests table and its data.

I tried using different databases and different configurations (via database URI, or TypeORM config object). The result is the same.

Thank you.

[balazsorban44]

Hi! This has been reported over at #1968

I pushed a fix for this for the TypeORM adapter, and if you run npm i or yarn and make sure that your package-lock.json or yarn.lock lists at least @next-auth/[email protected], it should be resolved for now! Feel free to give further feedback on the above-linked issue, if that is still not the case! Thank you!

[mertturkmenoglu]

Hi,

Running npm i didn't do it but I removed node_modules folder and package-lock.json file and tried to run the same command, and this time it worked.

Before trying this solution, I found a workaround but I'm not sure if this is how it is supposed to be:

import NextAuth from 'next-auth';
import Providers from 'next-auth/providers';
import Adapters from 'next-auth/adapters';

export default NextAuth({
  providers: [
    // Providers
  ],
  adapter: Adapters.TypeORM.Adapter({
     type: 'postgres',
     host: 'localhost',
     port: 5432,
     username: 'myusername',
     password: 'mypassword',
     database: 'mydatabase',
     synchronize: true,
  }),
});

I couldn't found an example of this, I was trying random things with the help of IntelliSense. But this code did the job for me.

Thank you.

[balazsorban44]

looks good!