Azure connection string is ignored

Question

Azure connection string is ignored

Anonymous

I have an AppService deployed and running on Azure. It connects to a Google Cloud PostreSQL database and have no problems.
In order to remove the connection string from the appSettings.config, I want to use an Azure connection string, which should override the appSettings.config value. I wrote should because I did it, but the value set in Azure is completely ignored.
This is my appSettings:

{
    "ConnectionStrings": {
        "postgres": "Host=XX.XX.XXX.XXX;Database=production;Username=portal;Password=myPassword"
    }
}

As I mentioned before, it is running. IF I add a value postgres with value "Host=XX.XX.XXX.XXX;Database=production;Username=portal;Password=wrongPassword", it still works, even if it souldn't.
What am I missing or doing wrong?

1 answer

Your answer

Answer 1

Ryan Hill 30,281 Microsoft Employee Moderator

Hi @Anonymous ,

Not sure if appSettings.config was a typo or not but App Service will overwrite settings from either web.config or appSettings.json. If you're expecting the values to be overridden, make sure you use Connections Strings area in the portal.

Anonymous

2021-11-30T12:57:00.557+00:00

Thanks for your answer, yes the config is appsettings.json, but I already set up my connection string:
Ryan Hill 30,281 Reputation points Microsoft Employee Moderator

2021-11-30T16:16:03.52+00:00

Is ASPNETCORE_ENVIRONMENT set to Development or Production? The value that postgres is overwritten with, is it aligned with appsettings.env.json?
Anonymous

2021-12-01T09:45:41.63+00:00
Here is my appSettings.json:

{ "ApplicationInsights": { ... }, "AzureAd": { ... }, "AllowedHosts": "*", "ConnectionStrings": { "postgres": "..." } }

Is ASPNETCORE_ENVIRONMENT set to Development or Production?

Do I need it?
Ryan Hill 30,281 Reputation points Microsoft Employee Moderator

2021-12-08T16:12:19.663+00:00

@Anonymous , you can use Production or Development @Anonymous . If you did a File -> New -> ASP.Net Web Project, have the setting set to Development, it will display the development error page. However, you can simply use Log Stream to see the errors.

I used a LocalDb connection string in my appsettings.json. I observed the errors in the Log Stream and then added a connection string; first with a bad password followed by the correct connection string and confirmed the app service will indeed replace that value.

Having said that, I would enable logging to see what's being retrieved, when, and how.
Anonymous

2021-12-27T11:30:49.547+00:00

At the end I migrated the whole project to Google Clound.

Share via

Azure connection string is ignored

1 answer

Your answer