Authenticating and Authorizing life changing food recommendations
Using dotnet core Identity template, configured to use Postgre SQL as DB OOTB template is augmented by IdentityServer open source project
The sample client that I have been using to test out the flow is under "AskToniAuthJavaScriptClient"
# Note:
Need to request user-secrets from repo owners to connect to databases
# Check to see if Secret Manager is working
dotnet user-secrets -h
# Add user secrets
dotnet user-secrets set MySecret ValueOfMySecret
# Build code
dotnet build
# Run project
dotnet run
The auth endpoint is live at: http://asktoniauthentication.azurewebsites.net
The identity server app is hosted in Azure.
The identity server is configured to use PostgreSQL. The database can queried using PGadmin in both development and prod.
The connection string is provided as a key-value pair with:
key = "DbConnectStr"
connectionstring = in format: "User ID={UserName};Password={Password};Host={Host};Port={Port};Database={DB Name};Pooling=true; And add "Use SSL Stream=True;SSL Mode=Require;TrustServerCertificate=True;" for heroku
These are dependant on your local installation of PostgreSQL. They should be stored in your dotnet user-secrets, the
The production database is hosted in Heroku Postgre. The credentials to log in to the database can be obtained by logging in to the Heroku web portal. -> Ask John for Credentials
- If you right-click on a table, you can get some premade queries under "Scripts"