Get an empty list of firewallRules when querying a postgres instance through a AzureFunction

[blured75]

• Package Name: @azure/arm-postgresql
• Package Version: 6.0.0
• Operating system: MacOS
• nodejs
  • version: v14.18.3
• browser
  • name/version:
• typescript
  • version: 4.4.2
• Is the bug related to documentation in
  • README.md
  • source code documentation
  • SDK API docs on https://docs.microsoft.com

Describe the bug
I'm trying to get the list of firewall rules on a Postgres Instance in Azure, using the azure-js-sdk. Locally it works like a charm, I've got the list of firewall rules from my selected postgres instance. When I launch this process in an Azure function, targetting the same postgres instance, the firewall rules list is always empty, and there is no error message or exception thrown.

To Reproduce
Steps to reproduce the behavior:
Code which work locally

  ...
   const azureCredential = new DefaultAzureCredential();
   const subscriptionClient = new SubscriptionClient(azureCredential);
   const postgresCli = new PostgreSQLManagementClient(azureCredential, 'mySubscriptionId');
   const fwRules = postgresCli.firewallRules.listByServer('myResourceGroup', 'myServerName');

   for await (const fwRule of fwRules) {
      context.log.info('in the for of fwRules');
      context.log.info('DELETING ', fwRule.name, ' in ', azResourceGroup);
      ...
   }

Code which return a empty firewall rules list in a Azure function

index.ts

const httpTrigger: AzureFunction = async function (context: Context, req: HttpRequest): Promise~void~ {
    try {
      const azureCredential = new DefaultAzureCredential();
      const subscriptionClient = new SubscriptionClient(azureCredential);
      const postgresCli = new PostgreSQLManagementClient(azureCredential, 'mySubscriptionId');
      const fwRules = postgresCli.firewallRules.listByServer('myResourceGroup', 'myServerName');

      for await (const fwRule of fwRules) {
         context.log.info('in the for of fwRules');
         context.log.info('DELETING ', fwRule.name, ' in ', azResourceGroup);
         ...
      }
    }
    catch (e) {
        context.log.error(e);
        context.res = { status: 500, body: 'Internal Server Error' };
    }
};
function.json

    'bindings': [
    {
      'authLevel': 'function',
      'type': 'httpTrigger',
      'direction': 'in',
      'name': 'req',
      'methods': [
        'get'
      ]
    },
    {
      'type': 'http',
      'direction': 'out',
      'name': 'res'
    }
  ],
  'scriptFile': '../target/foobar/index.js'

Expected behavior
I expect to get the same list of firewall rules when i run my program locally or in an azure function.

Screenshots
N/A

Additional context
N/A

[azure-sdk]

Label prediction was below confidence level 0.6 for Model:ServiceLabels: 'Azure.Identity:0.28440252,ARM:0.072985284,Storage:0.054815795'

[qiaozha]

Thanks for reporting this, I will take a look.

[qiaozha]

@MaryGao Can you help take a look at this issue ? Thanks

[MaryGao]

@blured75 I couldn't reproduce this in my azure function. I could get the same list both in local and azure function .

But when I published my local code to azure function I did encounter the authentication issue. Here are the steps:

1. Everything works well in local function environment
2. I published to my online azure function and tested my online function in portal referencing the doc
3. In azure portal I checked the error log with message ... authenticate to your Azure account using 'az login'.at AzureCliCredential.getToken...
4. Then followed the doc to grant the proper permission for my azure function in postgresql server
5. Finally my azure function handled correctly

Please let me know if the steps are clear or not and share your message with us if still error!

[ghost]

Hi, we're sending this friendly reminder because we haven't heard back from you in a while. We need more information about this issue to help address it. Please be sure to give us your input within the next 7 days. If we don't hear back from you within 14 days of this comment the issue will be automatically closed. Thank you!