is it possible to access the storage buckets directly via some sort of S3 browser not in the supabase web app?

hey guys 👋 im working with google oauth within supabase for my web app. im wanting to customise the oauth consent screen (see the screenshot). i went into my oauth consent screen settings in my google cloud dashboard, to customise and submit my app for review (so i can change the consent screen text/look) but i need to verify the linked domains. i have verified my domain, but the callback domain from supabase cannot be verified by me (they need to be verified in search console) - this is stopping me from submitting the app for review. is there a way around this? thank you 😅

Hello @87prashant! 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.

Hi everyone!! I am new to Open-source, and I am having an issue with the local setup of the project. Basically, my localhost:3000 is not refreshing/updating on changing the code. I just followed the installation instructions git clone https://github.com//supabase.git cd supabase cd apps/www npm install npm run dev Any help?

Is there any way i could stop the redirect to supabase domain on the email variable ConfirmationURL? For example, instead of: https://raciffyyjetslgfdsapmi.supabase.co/auth/v1/verify?token=[TOKEN]&type=magiclink&redirect_to=https://www.mywebsite.com/ It returns: https://www.mywebsite.com/?token=[TOKEN]&type=magiclink&redirect_to=... ?

Hey folks, I'm trying to add a new function hook in your UI and it's is erroring telling me "property table_id should not exist" and when I go to make a support request in your support form (https://app.supabase.com/support/new) it errors with "property verified should not exist". Stricter API validation maybe not playing ball?

I'm getting this message when trying to delete a user or send recovery emails. Any ideas?

@willm I am getting the exact same error, came into this server to ask the exact question.

Looks like i'm seeing the same kind of problem

Keep getting "id must be a number conforming to the specified constraints" when trying to update a table column via the UI

Playing around with supabase for couple days now and having issue with resetting local database in some cases. After remote commit and generated remote commit migration file I trying to reset database and keep getting:

Error: Error resetting database: ERROR:  cannot drop function graphql.build_insert(jsonb,jsonb,jsonb,text) because extension pg_graphql requires it
HINT:  You can drop extension pg_graphql instead.
ERROR:  current transaction is aborted, commands ignored until end of transaction block

Lines of migration that causing error is:

DROP FUNCTION IF EXISTS graphql.build_insert(ast jsonb, variable_definitions jsonb, variables jsonb, parent_type text);
DROP FUNCTION IF EXISTS graphql.build_delete(ast jsonb, variable_definitions jsonb, variables jsonb, parent_type text, parent_block_name text);
DROP FUNCTION IF EXISTS graphql.build_update(ast jsonb, variable_definitions jsonb, variables jsonb, parent_type text, parent_block_name text);
DROP FUNCTION IF EXISTS graphql.cache_key(role regrole, ast jsonb, variables jsonb);
DROP TABLE IF EXISTS graphql._field CASCADE;
DROP TABLE IF EXISTS graphql._type CASCADE;

Removing them fixes issue. Any ideas?

Hello, there! I'm having trouble with the

supabase.auth.update()

method in the Javascript library. My goal is to add a verified phone number to an existing user, who authenticated initially via Magic Link. What's boggling me is that I can make it work with a test project I created, but I can't get it to work with my main project!... In order to debug the flow, I created a very simple html page, where I included the javascript library via CDN:

<script src="https://cdn.jsdelivr.net/npm/@supabase/supabase-js"></script>
<script>
        const supabaseUrl = 'https://{{my-project}}.supabase.co'
        const supabaseKey = '{{my-anon-key}}'
        const supa = supabase.createClient(supabaseUrl, supabaseKey)
    </script>

With that, I'm using the browser console directly:

supa.auth.signIn({ email: 'some-test@emaill.com'})

The promise is fulfilled successfully and I receive the email with the Magic Link. Once I open the Magic Link, I'm successfully authenticated:

supa.auth.user()

shows me the user details Then I run:

supa.auth.update({ phone: '+1{{my-phone-here}}' })

Promise fulfilled successfully and I receive the code via SMS, through my Twilio account which I connected via the dashboard. Then I run:

supa.auth.verifyOTP({ phone: '+1{{my-phone-here}}', token:'XXXXXX', type: 'phone_change' })

This promise returns an error:

error:
message: "Token has expired or is invalid"
status: 401

The Auth log on the dashboard says this:

time="2022-06-22T04:54:21Z" level=info msg="401: Token has expired or is invalid" component=api error="redirect user" method=POST path=/verify referer="http://localhost:3000/" remote_addr="98.59.249.2:30283" request_id=97983326-7a91-44bb-990b-51e0052b16a5

The crazy part is that these exact same steps work fine with another project, and I get the phone number added to the user. I can't find any difference in the settings of these two projects. Does anybody have any idea what I'm doing wrong? Thanks!

Quick question. I just found Supabase and we are testing it to see if it fits to our projects. However i noticed the open source self hosted interface is very limited compared to the cloud one. It doesn't have create/edit ptojects, add users to project, etc. Ia a policy (the open source to be limited) or do we have to enable/install additional features? Thanks

Hi 👋 Is there a way to change the role a user gets in the auth scheme when user sign up or after their signed up? Trying to create admin users that have more access then normal authenticated user by creating new polices for tables. Or what is the best approach for this? 😊

I feel like I've answered this question before and now here I am asking it... When a webpage loads from: - Magic link - Oauth Provider - Forgot password link The initial state of the app is considered to be "Logged Out" then the access_token or provider_token is found in the url hash and then that triggers the session activation. How can one tell when that detection process is finished programatically?

Yo guys, any idea why https://supabase.com/docs/reference/javascript/auth-api-listusers only returns the first 50 users?

hi guys, what mean this error? duplicate key value violates unique constraint "user_pkey" I have problem in RLS? please help me

Hello @! Do you even Vim, bro?! 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.

Is there a bug with the resetPasswordForEmail JS function? The reset link in the email always redirects to the app base URL with User not found

we're trying to debug why two seemingly identical requests are getting different responses (200 vs. 406) from our sever. the logging explorer has been helpful, and we've confirmed that the event_message and URLs appear to be the same. are there any other properties we should check to track down this discrepancy? we've pinged the support email but in the meantime wanted to see if there is anywhere else obvious we should be looking. thanks!

Is RLS disabled by default and that's the reason why I can't use

.env

, but rather

.env.local

? And does it make any difference at all in case of Supabase? Is it safe to expose my

.env

file to the public?

is the supabase CLI installed by

yarn add supabase

different from https://github.com/supabase/cli ? I don't see a functions command in the node one.

Hello @garyaustin! 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.

On the auth.users table there is a column "instance_id" - what is this used for and if it is used for multi tenancy, is it something we as users can also utilize this way?

I'm thinking about instead of making every thing a table I may have like say the body of a blog post saved as json in a field. Is there a point where json is too big to store in field. Is this a fine approach. Like say each blog body i am saving as a json object converted to a string is around 10,000 chars. Is this not a problem to store and query and at what point is it a problem

Hi all, I'm new with Supabase and I can't find this anywhere. Does supabase authentication includes protection against brute force attacks?

how to replicate auth.users to a public table to work with pisma, please help

Hello can anyone help me to figure out what is wrong with my rpc function call? I keep getting the error " syntax error at or near "begin" " I used this online tool to check the syntax and it doesn't return an error. PS i'm new to rpc. Thank you https://extendsclass.com/postgresql-online.html

create or replace function get_summary(

)
returns table(
        "Nombre" varchar,
        "invoice_number" integer,
        "invoice_total" numeric,
        "part_cost" numeric,
        "other_expenses" numeric
)
language plpgsql
as $$
begin 
    return query
            select "Mecanicos"."Nombre",
            count(*) as "invoice_number",
            sum("Factura"."InvoiceTotal") as "invoice_total",
            sum("Factura"."PartCost"::float8) as "part_cost",
            sum("Factura"."OtherExpenses"::float8) as "other_expenses"
            from (
            select * from "Factura"
            where "Factura"."FDate" between symmetric '2022-06-22' and '2022-06-24'
            ) as "Factura"
            inner join "Mecanicos" on 
            "Mecanicos"."ID" = "Factura"."MechanicID"
            group by "Mecanicos"."Nombre"
            order by "Mecanicos"."Nombre" ASC;

end;$$

hello, i'm trying to signin with oidc (open id connect), here is my code:

js
 const { user, error, session } = await supabase.auth.signIn({
      oidc: {
        id_token: googleAuthSession.idToken!,
        provider: "google",
        nonce: "", // ? what should i pass here?
        issuer: "https://accounts.google.com",
      },
    });

it asks for a nonce but the authentication process with google does not return this field, how am I supposed to do?

Is there a list of options I can use with Templates? For example, for user sign up, there's

href="{{.ConfirmationURL}}

but I'd like to also use something like

<h2>Hello {{.User}}</h2>