search

microsoft / vscode-cosmosdb

Azure Databases extension for VS Code
https://marketplace.visualstudio.com/items?itemName=ms-azuretools.vscode-cosmosdb
MIT License
155 stars 68 forks source link

There is no operation "Enter server credentials to connect 'xxx'" after expanding "postgres" node on another machine #2231

Closed v-xinda closed 8 months ago

v-xinda commented 8 months ago

OS: Win10 Build Version: 20240112.17 Regression: Previous release

Repro Steps:

  1. Create a PostgreSQL Flexible server.
  2. Expand the PostgreSQL Flexible server on another machine -> Expand "postgres" node.
  3. Check whether there is an operation "Enter server credentials to connect 'xxx'".

Expect: There is an operation "Enter server credentials to connect 'xxx'". image

Actual:

  1. There is no operation "Enter server credentials to connect 'xxx'". image
  2. Prompt to enter server credentials to connect 'xxx'. image

More Info: This issue doesn't reproduce for the PostgreSQL Single server.

JasonYeMSFT commented 8 months ago

I wasn't able to reproduce and I have zero idea how this could happen. The code for showing the warning and the code for showing the "enter credential node" are literally next to each other. If you can get a reproducing server, could you share it with me and let me try it?

JasonYeMSFT commented 8 months ago

We did some more investigation offline. The root cause is that our auto firewall configuration detects that the current IP is already included in the IP whitelist but still get an IP address blocked error. This can happen if the client is under an uncooperative NAT that uses different IP addresses to connect to database server.