Activities of "okains"

Hi,

You have access to this repo in GitHub, it is the same repo as before. The problem is though that this doesn't happen locally, it is only showing up when we deploy to Azure. And not all the time.

I just need to figure out a fix or workaround for this in some way so that we can deploy properly. If you have any ideas or can look at the code and see if there is anything obviously wrong with the Auth project that would be great.

Thanks,

Karim

Hi,

OK I copied the .map file into the libs folder and that seems to have fixed it, thanks,

Karim

Hi,

OK I commented out the // Application = await OpenIdApplicationRepository.GetListAsync(); line,

I am still getting the : [ERR] An error occurred using the connection to database 'ESv2-testing' on server 'tcp:hathor-hk.database.windows.net,1433'. error intermittently.

Any idea of what I can try next on this? This is a pretty critical error, we can deploy our app reliably at this point. Any help would be much appreciated.

Thanks,

Karim

OK that's great, thanks for your help and explanation.

Hi,

Yes, that works! Great, thank you. Can you explain to me though why that caused the problem?

Thanks,

Karim

Ah sorry, I just gave you access to the shared repo, should be able to build now.

Hi,

I have granted access, thanks.

That client validation failed INF is only present when the DB connection ERR happens. The configuration is fine, it works fine occasionally and I have double and tripled checked Environment Variables and the redirectURLs in the OpenIddictApplications table. Everything is at it should be.

This is why I had said that I think that DB error is happening when trying to read the OpenIddictApplications table, so no data coming back therefore the redirect_uri mismatch. Just a guess but I have been testing this for days and that seems to be the 1 thing that makes a bit of sense. That is why I wanted to retry that db call in the first place.

This is happening on an AppService in Azure with 3 deployment slots, Test / Staging / Production . It seems that only 1 deployment slot will work at a time, the other 2 then throw the ' error using the connection to the database ' error and then redirect uri mismatch. And there are no config changes at all being made.

Hi,

Would it be easier to give you access to the GitHub repo? This would be a very big file otherwise.

Thanks,

Karim

Hi,

I have shared the full debug logs of the site load and login attempt. Here is a screenshot of the db error that I believe is causing these 400 errors:

Thanks,

Karim