Cannot connect to postgres database in azure

[RRajdev]

We have written the needed data into your clipboard because it was too large to send. Please paste.

Issue Type: Bug

[2021-05-07 11:27:05.450] [renderer1] [info] Creating new connection connection:providerName:PGSQL|applicationName:azdata|authenticationType:SqlLogin|dbname:|host:eun-prod-128-identity-postgresqlcc.postgres.database.azure.com|user:identityPostgresAdmin@eun-prod-128-identity-postgresqlcc|group:C777F06B-202E-4480-B475-FA416154D458 [2021-05-07 11:27:05.450] [renderer1] [info] Adding connection connection:providerName:PGSQL|applicationName:azdata|authenticationType:SqlLogin|dbname:|host:eun-prod-128-identity-postgresqlcc.postgres.database.azure.com|user:identityPostgresAdmin@eun-prod-128-identity-postgresqlcc|group:C777F06B-202E-4480-B475-FA416154D458 [2021-05-07 11:27:05.450] [renderer1] [info] Successfully added connection connection:providerName:PGSQL|applicationName:azdata|authenticationType:SqlLogin|dbname:|host:eun-prod-128-identity-postgresqlcc.postgres.database.azure.com|user:identityPostgresAdmin@eun-prod-128-identity-postgresqlcc|group:C777F06B-202E-4480-B475-FA416154D458 [2021-05-07 11:28:20.592] [renderer1] [info] Deleting connection connection:providerName:PGSQL|applicationName:azdata|authenticationType:SqlLogin|dbname:|host:eun-prod-128-identity-postgresqlcc.postgres.database.azure.com|user:identityPostgresAdmin@eun-prod-128-identity-postgresqlcc|group:C777F06B-202E-4480-B475-FA416154D458 [2021-05-07 11:28:20.593] [renderer1] [error] server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

[2021-05-07 11:29:21.292] [renderer1] [error] Cannot set property 'azureAccountToken' of undefined: TypeError: Cannot set property 'azureAccountToken' of undefined at e.fillInOrClearToken (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5558:811) at e.addSavedPassword (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5550:119) at k.handleFillInConnectionInputs (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7096:593) at file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7099:197 at c.fire (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:219:801) at F.onConnectionClick (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7088:574) at u.clickcb (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7086:40) at u.onLeftClick (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5185:42) at u.onMouseDown (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5185:331) at w.onMouseDown (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:1795:916) at HTMLDivElement. (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:1785:349) at ZoneDelegate.invokeTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:421:31) at Zone.runTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:188:47) at ZoneTask.invokeTask [as invoke] (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:496:34) at invokeTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:1540:14) at HTMLDivElement.globalZoneAwareCallback (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:1566:17) [2021-05-07 11:37:35.424] [renderer1] [error] Cannot set property 'azureAccountToken' of undefined: TypeError: Cannot set property 'azureAccountToken' of undefined at e.fillInOrClearToken (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5558:811) at e.addSavedPassword (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5550:119) at k.handleFillInConnectionInputs (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7096:593) at file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7099:197 at c.fire (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:219:801) at F.onConnectionClick (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7088:574) at u.clickcb (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7086:40) at u.onLeftClick (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5185:42) at u.onMouseDown (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5185:331) at w.onMouseDown (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:1795:916) at HTMLDivElement. (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:1785:349) at ZoneDelegate.invokeTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:421:31) at Zone.runTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:188:47) at ZoneTask.invokeTask [as invoke] (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:496:34) at invokeTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:1540:14) at HTMLDivElement.globalZoneAwareCallback (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone.js:1566:17)

Azure Data Studio version: azuredatastudio 1.28.0 (13e362762762e5cb76a5c8afd2bc650f48c2d3d8, 2021-04-15T00:25:54.683Z) OS version: Darwin x64 19.6.0

System Info

|Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-9750H CPU @ 2.60GHz (12 x 2600)| |GPU Status|2d_canvas: enabled
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
metal: disabled_off
multiple_raster_threads: enabled_on
oop_rasterization: enabled
opengl: enabled_on
protected_video_decode: unavailable_off
rasterization: enabled
skia_renderer: disabled_off_ok
video_decode: enabled
webgl: enabled
webgl2: enabled| |Load (avg)|2, 2, 2| |Memory (System)|16.00GB (0.22GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|

Extensions (1)

Extension|Author (truncated)|Version ---|---|--- azuredatastudio-postgresql|Mic|0.2.7

[iAlexanderMoon]

Works for me on 1.28.0 on Windows.

Did you follow https://docs.microsoft.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication#connecting-to-azure-database-for-postgresql-using-azure-ad

I spent 30 minutes until I read the cli section

Important considerations when connecting:

user@tenant.onmicrosoft.com is the name of the Azure AD user or group you are trying to connect as

I had setup a group but was trying to login as my user.

[mksuni]

@RRajdev Please provide steps to reproduce the issue. Seems like you are using AAD here. Do confirm if you followed the steps here https://docs.microsoft.com/en-us/azure/postgresql/howto-configure-sign-in-aad-authentication#connecting-to-azure-database-for-postgresql-using-azure-ad

[nasc17]

Please update to latest stable release of PostgreSQL extension v0.4.2. We would appreciate your verification if this issue is still present.