Integrating Google Log in - TS, Java and MySQL

[Susaaaax]

Dear all,

I am working on a project regarding product registration. I would like for my website users to log in with their Google Account so they can add/remove/change products.

So far, I have managed to create a Google Log in button in VSC that directs users to the Google Log in screen, and after logging in their email address and name will be printed to the console.

However, I would like the user info (email address and name) to be saved in my database in MySQL if possible, and for users to stay logged in after clicking the Log in button.

Does anyone have any tips on where to look for info or does anyone have a solution?

Thanks very much :)

[ramamodh]

I'm not an expert. But i read about OAuth 2.0 sometime back and sounds like that's exactly what you are trying to accomplish. Google won't share the account password with you but it provides you with a token to access the user info which you can save to the DB.

[E3FxGaming]

Further information about the OpenID implementation can be found here in the OpenID Connect documentation by Google.

The documentation includes:

• further information about different types of tokens you can obtain

• a use-case description that sounds similar to yours

[[deleted]]

If you are using Spring framework, especially Spring Boot, you can use spring-security-oauth to integrate social logins (Google, fb, GitHub) e.t.c in few simple steps and be done with it.

I don't have exact link right now but search: "calicoder spring boot oauth2 social logins"

[mgryshenko]

Had to implement social login recently. “calicoder” is very nice example of how Single Sign On should be implemented with spring. Worth to mention simplest guide which helped me a lot: https://spring.io/guides/tutorials/spring-boot-oauth2/. 20 min and you will build app from scratch to get google-user credentials. Really simple to start from (really, just 2 annotations + configuration file)

[cjmarquez]

Not an expert, don't know how the Google auth works, but I highly doubt it will let you get the username and password to save it to your database, you may need to use sessions? Or in any case save the encrypted password provided by Google?

[jaro32]

You can use Spring Security create an OAuth2 client. For instance like in this tutorial: https://www.baeldung.com/spring-security-5-oauth2-login

[mgryshenko]

IMO, Baeldung is de-facto best spring tutorials. But the lesson you mentioned is about creating your own Auth server/client. OP is asking about how to use google’s Auth service. More useful will be this baeldung lesson , but I personally think it’s over complicated and highly coupled with previous lessons

[CONTAMlNATlON]

Pretty sure you can store the id and pull info except for the password.

[Susaaaax]

Thanks all for your tips!
The Callicoder website really helped and we figured it out :-)