azure_mysql_flexible_server query always returns public_network_access as "enabled" even if db does not have public access.

[ManojDhanorkar]

Below azure_mysql_flexible_server query always returns public_network_access as "enabled" even if db does not have public access.

select name, id, public_network_access from azure_mysql_flexible_server

Steampipe v0.22.1

Azure 0.64.0

[ParthaI]

Hi @ManojDhanorkar, Sorry to see that you are encountering the error.

• In our project we use the ListByResourceGroup API call from the mysqlflexibleservers package.
• This API returns an attribute called PublicNetworkAccess under the Network property.
• However, the PublicNetworkAccess value we receive is always Enabled, regardless of whether it is actually enabled or disabled in the portal.

I have raised an issue on the Azure Go SDK repository to address this response. You can track the issue here.

We will revisit this matter once it is resolved on the Azure Go SDK side.

Thanks!

[ManojDhanorkar]

I suspect this problem may be there in mysql standalone , postgres standalone and postgres flexible. Will this new PR fix it across all of them ?

[ManojDhanorkar]

when this would get merged ?

[ManojDhanorkar]

which query should be used on azure_postgresql_flexible_server to know if server has public access enabled. I searched a lot but could not find one.

[ParthaI]

Hi @ManojDhanorkar, in the azure_mysql_flexible_server table, there is a column named public_network_access with possible values of Disabled or Enabled. This allows you to determine whether the server has public access enabled.

I have added the example queries in the PR body. Did you get a chance to have a look?

[ManojDhanorkar]

for azure_postgresql_flexible_server ( postgress ) should I raise new issue ? I am looking for similar column in postgres. Any pointers around that.

[ManojDhanorkar]

On the mysql PR some checks are failing . https://github.com/turbot/steampipe-plugin-azure/pull/820

[ParthaI]

for azure_postgresql_flexible_server ( postgress ) should I raise new issue ? I am looking for similar column in postgres. Any pointers around that.

Yes, please raise a separate issue.

On the mysql PR some checks are failing . https://github.com/turbot/steampipe-plugin-azure/pull/820

It is not due to the code changes in that PR. It is due to the use of a few deprecated Azure Go packages. We will be working on it.

[ManojDhanorkar]

thanks

[ManojDhanorkar]

When is the next release planned where we can expect the changes to be included ?

[ManojDhanorkar]

will this be available in https://github.com/turbot/steampipe-plugin-azure/releases/tag/v0.65.0 ?