Hello. I'm having some problems to find the best way to auth on server side with NextJs integration. I'm trying to handle the token like is mentioned in the docu (https://supabase.com/docs/reference/javascript/auth-setauth)

js
export default async function handler (req, res) {
  const { access_token } = req.get('X-Supabase-Auth')
  const { user, error } = supabase.auth.setAuth(access_token)

  console.log('error', error)
  console.log('user', user)
}

but with NextJs middleware is becoming difficult,

req.get

is not defined. There are some documentation about this behaviour.

I'm having trouble using email/password signup... Not getting any kind of feedback at all... https://pastebin.com/MFdyxfbm

I cannot sign into Supabase

getting error 403

permission denied for table identities

, probably because my RLS policy does a lookup in the identities table. how can I change the RLS policy to let someone lookup their own identity?

I have a sveltekit app working with Supabase on Vercel. There seems to be an issue with Supabase js and Node 16:

[POST] /api/auth/signin
14:25:55:71
2022-05-17T04:25:56.345Z    9224560d-5da7-4630-8ecf-2c93d7755e57    ERROR    Error: Dynamic require of "stream" is not supported
    at file:///var/task/index.js:12:9
    at node_modules/node-fetch/lib/index.js (file:///var/task/index.js:7860:35)
    at __require2 (file:///var/task/index.js:18:50)
    at node_modules/cross-fetch/dist/node-ponyfill.js (file:///var/task/index.js:8927:21)
    at __require2 (file:///var/task/index.js:18:50)
    at node_modules/@supabase/gotrue-js/dist/main/lib/helpers.js (file:///var/task/index.js:8981:41)
    at __require2 (file:///var/task/index.js:18:50)
    at node_modules/@supabase/gotrue-js/dist/main/GoTrueApi.js (file:///var/task/index.js:9090:21)
    at __require2 (file:///var/task/index.js:18:50)
    at node_modules/@supabase/gotrue-js/dist/main/index.js (file:///var/task/index.js:10191:39)
2022-05-17T04:25:56.349Z

Does anyone have any ideas?

The docs for setting up Twitter Login are outdated. The 3-legged OAuth is no longer available. I've tried what was suggested in this discussion: https://github.com/supabase/supabase/discussions/2270. The authentication redirection works, but when I get back to my site I get the following

http://localhost:3000/?error=server_error&error_description=Error+getting+user+email+from+external+provider

Am I doing something wrong? What's the right way of setting up Twitter Oauth? I'm attaching screenshots of my Twitter Dashboard setup.

Using the

@nuxtjs/supabase

module, trying to setup a really basic auth. On my login page I have:

javascript
const login = async () => {
  await auth
    .signIn({
      email: email.value,
      password: password.value,
    })
    .then(() => {
      router.push("/");
    })
    .catch((error) => {
      return alert(error);
    });
};

On the index page I have the following calling middleware:

javascript
definePageMeta({
  middleware: "auth",
});

And the

auth

middleware is:

javascript
export default defineNuxtRouteMiddleware((to, _from) => {
    const user = useSupabaseUser()
    if (!user.value) {
        console.log("User not authenticated")
        return navigateTo('/login')
    }
})

When I login, the middleware fails and says "User not authenticated". However it actually has, if I refresh I am logged in. It's almost like the middleware just acts too quickly and needs to wait a second. Any idea how to resolve this?

Am i doing something wrong or is it the supabase dashboard ? for past 3 days supabase anon key and service key was changed all of sudden, i haven't changed anything on supabase studio but the keys have changed 3-4 time in that duration... what can be the possible reason that they key is changed ? One thing is i have assigned roles to users in

auth.users

in supabase db. does changing role trigger it or is it due to something else.

Hello! 👋 I'm using supabase free plan, suddenly the open-API stopped working (about 7 days ago) The message is "Missing or invalid credentials" I've tried to change anon key - but it didn't work I observe some errors in DB which says "password auto failed for user postgres" - maybe something is wrong on supabase side, or I'm missing something? -- If someone have same issues would appreciate help 🙏 Here is my link to API which is currently not working https://dwdzonwbstsmajepwrjn.supabase.co/rest/v1/?apikey=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6ImR3ZHpvbndic3RzbWFqZXB3cmpuIiwicm9sZSI6ImFub24iLCJpYXQiOjE2NTI3ODM3ODUsImV4cCI6MTk2ODM1OTc4NX0.t3kRiEkgsdOhxHNic5Xj-U4pZMUmqCH4qxml8XOy84g

Has anyone built any custom integration around emails? Seems like Supabase doesn't have it. I've a usecase where when a record is inserted into table by some custom logic, send an email

Does Supabase have any solution for Auth using just Username & Password?

Hello everyone! recently started using supabase and i have a question about RLS Is it possible to use an array of IDs (strings) to authenticate? I tried the example bellow but i have something wrong in the syntax: (collection is my table which has a column of user_ids)

exists (
  select 1
  from collection
  where auth.uid() in collection.user_ids
)

Sorry for reposting this but seems to be more activity in here. Everything below has been done in JavaScript. If I have someone submitting a Username and UUID number... How do I get it to check and see if the UUID number has already been assigned to another Username? So if the UUID doesnt have a username then it will let the user submit their username, but if that UUID already has a username attached to it, then it will tell the user to try again. Any help would be greatly appreciated!

Hi all, I'm at a loss with trying to get realtime working. Replication is turned on for a table called

messages

but

const sub = supabase.from('messages').on("*", console.log).subscribe()

never prints anything. Is there something I'm missing? Thank you for any help!

When I try to listBuckets(), I get an empty array, but I have one public bucket... const { data, error } = await supabase.storage.listBuckets() I also tried with getBucket('ressources'), (ressources being the name of my bucket) and I also get nothing

Hey folks, I'm trying to generate types for my project following this guide: https://supabase.com/docs/guides/api/generating-types#generating-types-from-openapi-specification When I swap in my project url and anon key however, I'm getting an error (even when loading it in the browser),

Missing or invalid credentials.

$supabase.auth.signIn for provider:'azure' is giving me "Error getting user email from external provider" error on signIn for a new AD test account. Testing the same AD account on firebase auth works, so there is something up with how I'm using supabase auth or the gotrue server does not quite liking that account. Are there more detailed logs available from the server? I'm using the hosted server not local.

How can I recursive query with Supabase? Or I have to write a postgresql function for that

Hello everyone! Cross-posting this quesiton here, in case anyone can help out with auth suggestions: https://discord.com/channels/839993398554656828/932506573987790908/976314717612150795

hi, what's are the storage needs of Supabase for self-hosting? I've spun it up on a 20GB VPS and its at capacity after running for a couple days without any real usage and a nearly empty DB, what's a recommended minimum size for a VPS to host Supabase?

Getting some intermittent upsert errors when pushing to our DB

Hello @Michie! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

I want to throw errors and exceptions in plsql functions but I don't see auto suggestions for "Raise Exception" or "Notice" . Is it not supported in Supabase? Is there any workaround or otherways to do it? My usecase is I am building a function where I want to use it as an endpoint. I need to throw errors from function so it is visible on the endpoint.

what is the vps requirements for self hosting supabase?

I faced an issue with graphql, after turn off/on

pg_graphql

extension. when I run the query in the sql editor, it will response me data. but when I try to use postman call the query it returns me an error. Sql Editor

select graphql.resolve($$
    {
      usersCollection(first: 1) {
        edges {
          node {
            id
          }
        }
      }
    }
$$);

result

{
  "data": {
    "usersCollection": {
      "edges": []
    }
  }
}

postman request

query{
    usersCollection(first: 1) {
        edges {
            node {
                id
            }
        }
    }
}

postman response

{
  "data": null,
  "errors": [
    {
      "message": "Unknown field 'usersCollection' on type 'Query'"
    }
  ]
}

Hello, anyone have an idea why im getting "connecting to default project" in supabase studio? It rolls forever. Im using supabase in self hosted version. What I did, I've had a server with supabase running on it, connected to postgres on different server, then i took my docker-compose and .env files and just tried to start it on another server. I also connected it to the same postgres. Now i have 2 supabase running on different machines, connected to the same postgres. Can this be an issue why i cannot connect to default project on new server?

is there an easy way to convert

timestampz

to just date / time / zone? I have tried

.toLocaleString

but it doesn't seem to work

Hello @avalanche! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Got couple of questions: 1.) Is it possible to connect to local instance with pgAdmin? When I enter my localhost:54322/postgres as host I get error. 2.) Anyone had issue with delete on cascade actually not deleting referenced items? 3.) What is the proper way to seed online instance? If I try to do it over API I get request exceeded error.

were you able to figure this out? I'm facing the same issue myself