PHP error with oauth2

[ocsav]

Can you please share an updated Google Authentication for wappler please.
I still can’t make mine to work based on the forum tutorial.

[Fred_K]

Ok, sharing the main steps, assuming you’ve done the Google Cloud setup already.

In the Globals, have the jwt setup, after you do the right setup on your Google Cloud Services:

Value in the Claims section:
https://www.googleapis.com/oauth2/v2/userinfo

In the oauth of Globals:

Create an API action with the following flow (it’s based on an existing forum tutorial):

URL: https://people.googleapis.com/v1/people/me

Hope this helps.

[ocsav]

@Fred_K

https://www.googleapis.com/oauth2/v2/userinfo

Hi, thanks for the details but where can I find the “Issuer”, “audience” and “Key” for the JWT inputs.

[Fred_K]

My bad, sorry, have done this setup months ago and don’t remember all the details, you don’t need JWT, only oauth:

[ocsav]

Hi, so should I follow only from the OAuth2 step !?
I am trying to create a log in using google and can’t find a way for months now followed all forum tutorials on the subject and can’t find a clean straight fwrd follow through tutorial that works.
Any help would be very appreciated.

[Fred_K]

@ocsav

so should I follow only from the OAuth2 step !?

Yes.

I’ve followed this tutorial

Using OAuth2 Connector with Google

Overview Using the OAuth2 Connector in Wappler you can add a “social login” option to your website, so the users can directly log in using their Google account. In this tutorial, we will show you how to create accounts for new users and also how to log the registered users in, using their Google account data - like email and Google ID. Setting up a google developer account First, go to https://developers.google.com/identity/sign-in/web/sign-in and sign in using your Google account. Create …

…and made some fixes (as per my sharing above)

[ocsav]

I followed that one and it gives me this error :

[Teodor]

Are you using a custom db query in your server action?

[ocsav]

[Teodor]

How is your join set up exactly - please post a screenshot? Also how did you manage to create a db query using a basic license?

[ocsav]

I followed these steps : Using OAuth2 Connector with Google

[Teodor]

As i already asked:

@Teodor

How is your join set up exactly - please post a screenshot

[ocsav]

@Teodor

join set up

Sorry but I am not very experienced with the nomenclature experienced people use,
this is workflow:

[Teodor]

In the query builder you have set up a database tables join. How did you set it up? Open the join editor and just make a screenshot of how is it set up!

[ocsav]

[Teodor]

Why did you join the table with itself then? What are you trying to do here?

I doubt you need this join here, and the error you pasted above is related to this query.

[ocsav]

[Teodor]

I am not interested in the insert step.
I was asking about the database query as the error is coming from it and you have a weird join added there. Check my previous reply.

@Teodor

Why did you join the table with itself then? What are you trying to do here?

I doubt you need this join here, and the error you pasted above is related to this query.

[ocsav]

not sure how this was created since I only have “users” in my database

[Teodor]

@ocsav

not sure how this was created

Well … in order for this to happen you need to add the same table over and over again in the query builder and set up the joins i see there.

Make sure the table is added only once in the query builder, without any joins.
Just recreate the query step and add only the table you need, only once.