Test-AzPostgreSqlFlexibleServerConnect kill PowerShell host with version 2 of SimplySQL Module #25499

HUMBERP · 2024-07-10T05:33:51Z

Description

If we run the cmdlet

Test-AzPostgreSqlFlexibleServerConnect -ResourceGroupName $serverResourceGroupName -Name $serverName -DatabaseName $databaseName -AdministratorUserName $aadAdministratorName -AdministratorLoginPassword $secureToken -ErrorAction Stop -QueryText $script

The PowerShell host quits when the new version of needed PowerShell Module SimplySQL is installed, with version prior to 2.x the cmdlet works fine.

The issue occurs within file

src/PostgreSql/PostgreSql.Autorest/custom/Test-AzPostgreSqlFlexibleServerConnect.ps1

line 149 and 152 when Open-PostGreConnection is called. The new version of Open-PostGreConnection needs a Credential Parameter instead of Username and Password (OpenPostGreConnection.vb), therefore you get a ParameterBindingException and then the cmdlet uses exit !!!! I highly recommend to rethrow the exception instead of closing the powershell session!

Issue script & Debug output

Can't paste because the powershell host quits ...

Environment data

Name                           Value
----                           -----
PSVersion                      7.4.3
PSEdition                      Core
GitCommitId                    7.4.3
OS                             Microsoft Windows 10.0.22621
Platform                       Win32NT
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0

Module versions

ModuleType Version    PreRelease Name                                PSEdition ExportedCommands
---------- -------    ---------- ----                                --------- ----------------
Script     12.0.0                Az                                  Core,Desk 
Script     3.0.0                 Az.Accounts                         Core,Desk {Disable-AzDataCollection, Disable-AzConΓÇª
Script     2.0.1                 Az.Advisor                          Core,Desk {Disable-AzAdvisorRecommendation, EnableΓÇª
Script     6.0.3                 Az.Aks                              Core,Desk {Disable-AzAksAddOn, Enable-AzAksAddOn, ΓÇª
Script     1.1.5                 Az.AnalysisServices                 Core,Desk {Add-AzAnalysisServicesAccount, Export-AΓÇª
Script     4.0.3                 Az.ApiManagement                    Core,Desk {Add-AzApiManagementApiToGateway, Add-AzΓÇª
Script     1.0.0                 Az.App                              Core,Desk {Disable-AzContainerAppRevision, Enable-ΓÇª
Script     1.3.1                 Az.AppConfiguration                 Core,Desk {Clear-AzAppConfigurationDeletedStore, GΓÇª
Script     2.2.5                 Az.ApplicationInsights              Core,Desk {Get-AzApplicationInsights, Get-AzApplicΓÇª
Script     1.0.1                 Az.ArcResourceBridge                Core,Desk {Get-AzArcResourceBridge, Get-AzArcResouΓÇª
Script     2.0.2                 Az.Attestation                      Core,Desk {Add-AzAttestationPolicySigner, Get-AzAtΓÇª
Script     1.0.1                 Az.Automanage                       Core,Desk {Get-AzAutomanageBestPractice, Get-AzAutΓÇª
Script     1.10.0                Az.Automation                       Core,Desk {Export-AzAutomationDscConfiguration, ExΓÇª
Script     3.6.1                 Az.Batch                            Core,Desk {Disable-AzBatchAutoScale, Disable-AzBatΓÇª
Script     2.0.4                 Az.Billing                          Core,Desk {Get-AzBillingAccount, Get-AzBillingInvoΓÇª
Script     3.2.0                 Az.Cdn                              Core,Desk {Clear-AzCdnEndpointContent, Clear-AzFroΓÇª
Script     2.0.1                 Az.CloudService                     Core,Desk {Get-AzCloudService, Get-AzCloudServiceIΓÇª
Script     1.14.1                Az.CognitiveServices                Core,Desk {Get-AzCognitiveServicesAccount, Get-AzCΓÇª
Script     8.0.0                 Az.Compute                          Core,Desk {Add-AzImageDataDisk, Add-AzVhd, Add-AzVΓÇª
Script     1.0.1                 Az.ConfidentialLedger               Core,Desk {Get-AzConfidentialLedger, New-AzConfideΓÇª
Script     4.0.1                 Az.ContainerInstance                Core,Desk {Add-AzContainerInstanceOutput, Get-AzCoΓÇª
Script     4.2.1                 Az.ContainerRegistry                Core,Desk {Connect-AzContainerRegistry, Get-AzContΓÇª
Script     1.14.3                Az.CosmosDB                         Core,Desk {Get-AzCosmosDBAccount, Get-AzCosmosDBAcΓÇª
Script     1.1.1                 Az.DataBoxEdge                      Core,Desk {Get-AzDataBoxEdgeBandwidthSchedule, GetΓÇª
Script     1.7.2                 Az.Databricks                       Core,Desk {Get-AzDatabricksAccessConnector, Get-AzΓÇª
Script     1.18.4                Az.DataFactory                      Core,Desk {Add-AzDataFactoryV2DataFlowDebugSessionΓÇª
Script     1.0.3                 Az.DataLakeAnalytics                Core,Desk {Get-AzDataLakeAnalyticsDataSource, New-ΓÇª
Script     1.3.1                 Az.DataLakeStore                    Core,Desk {Add-AzDataLakeStoreFirewallRule, Add-AzΓÇª
Script     2.4.0                 Az.DataProtection                   Core,Desk {Backup-AzDataProtectionBackupInstanceAdΓÇª
Script     1.0.2                 Az.DataShare                        Core,Desk {Get-AzDataShare, Get-AzDataShareAccountΓÇª
Script     1.1.0                 Az.DeploymentManager                Core,Desk {Get-AzDeploymentManagerArtifactSource, ΓÇª
Script     4.3.1                 Az.DesktopVirtualization            Core,Desk {Disconnect-AzWvdUserSession, Expand-AzWΓÇª
Script     1.1.1                 Az.DevCenter                        Core,Desk {Deploy-AzDevCenterUserEnvironment, Get-ΓÇª
Script     1.0.3                 Az.DevTestLabs                      Core,Desk {Get-AzDtlAllowedVMSizesPolicy, Get-AzDtΓÇª
Script     1.2.1                 Az.Dns                              Core,Desk {Add-AzDnsRecordConfig, Get-AzDnsRecordSΓÇª
Script     1.0.0                 Az.DnsResolver                      Core,Desk {Get-AzDnsForwardingRuleset, Get-AzDnsFoΓÇª
Script     1.0.2                 Az.ElasticSan                       Core,Desk {Add-AzElasticSanVolumeGroupNetworkRule,ΓÇª
Script     2.0.0                 Az.EventGrid                        Core,Desk {Disable-AzEventGridPartnerTopic, EnableΓÇª
Script     5.0.0                 Az.EventHub                         Core,Desk {New-AzEventHubAuthorizationRuleSASTokenΓÇª
Script     1.10.1                Az.FrontDoor                        Core,Desk {Disable-AzFrontDoorCustomDomainHttps, EΓÇª
Script     4.0.8                 Az.Functions                        Core,Desk {Get-AzFunctionApp, Get-AzFunctionAppAvaΓÇª
Script     6.1.0                 Az.HDInsight                        Core,Desk {Add-AzHDInsightClusterIdentity, Add-AzHΓÇª
Script     2.0.1                 Az.HealthcareApis                   Core,Desk {Get-AzHealthcareApisService, Get-AzHealΓÇª
Script     0.2.0                 Az.ImageBuilder                     Core,Desk {Get-AzImageBuilderRunOutput, Get-AzImagΓÇª
Script     2.7.6                 Az.IotHub                           Core,Desk {Add-AzIotHubCertificate, Add-AzIotHubCoΓÇª
Script     6.0.0                 Az.KeyVault                         Core,Desk {Add-AzKeyVaultCertificate, Add-AzKeyVauΓÇª
Script     2.3.1                 Az.Kusto                            Core,Desk {Add-AzKustoClusterLanguageExtension, AdΓÇª
Script     1.0.1                 Az.LoadTesting                      Core,Desk {Get-AzLoad, New-AzLoad, Remove-AzLoad, ΓÇª
Script     1.5.1                 Az.LogicApp                         Core,Desk {Get-AzIntegrationAccount, Get-AzIntegraΓÇª
Script     1.1.4                 Az.MachineLearning                  Core,Desk {Add-AzMlWebServiceRegionalProperty, ExpΓÇª
Script     1.0.1                 Az.MachineLearningServices          Core,Desk {Get-AzMLServiceQuota, Get-AzMLServiceUsΓÇª
Script     1.4.1                 Az.Maintenance                      Core,Desk {Get-AzApplyUpdate, Get-AzConfigurationAΓÇª
Script     1.2.1                 Az.ManagedServiceIdentity           Core,Desk {Get-AzFederatedIdentityCredential, Get-ΓÇª
Script     3.0.1                 Az.ManagedServices                  Core,Desk {Get-AzManagedServicesAssignment, Get-AzΓÇª
Script     2.0.1                 Az.MarketplaceOrdering              Core,Desk {Get-AzMarketplaceTerms, Invoke-AzMarketΓÇª
Script     1.1.2                 Az.Media                            Core,Desk {Sync-AzMediaServiceStorageKey, Set-AzMeΓÇª
Script     2.3.1                 Az.Migrate                          Core,Desk {Get-AzMigrateDiscoveredServer, Get-AzMiΓÇª
Script     5.2.1                 Az.Monitor                          Core,Desk {Add-AzLogProfile, Add-AzMetricAlertRuleΓÇª
Script     1.1.2                 Az.MySql                            Core,Desk {Get-AzMySqlConfiguration, Get-AzMySqlCoΓÇª
Script     7.6.0                 Az.Network                          Core,Desk {Add-AzApplicationGatewayAuthenticationCΓÇª
Script     1.0.1                 Az.NetworkCloud                     Core,Desk {Deploy-AzNetworkCloudCluster, Disable-AΓÇª
Script     1.0.1                 Az.Nginx                            Core,Desk {Get-AzNginxCertificate, Get-AzNginxConfΓÇª
Script     1.1.2                 Az.NotificationHubs                 Core,Desk {Get-AzNotificationHub, Get-AzNotificatiΓÇª
Script     3.2.1                 Az.OperationalInsights              Core,Desk {Disable-AzOperationalInsightsIISLogCollΓÇª
Script     1.6.5                 Az.PolicyInsights                   Core,Desk {Get-AzPolicyAttestation, Get-AzPolicyEvΓÇª
Script     1.1.1                 Az.PostgreSql                       Core,Desk {Get-AzPostgreSqlConfiguration, Get-AzPoΓÇª
Script     2.0.0                 Az.PowerBIEmbedded                  Core,Desk {Resume-AzPowerBIEmbeddedCapacity, SuspeΓÇª
Script     1.0.5                 Az.PrivateDns                       Core,Desk {Add-AzPrivateDnsRecordConfig, Get-AzPriΓÇª
Script     7.0.0                 Az.RecoveryServices                 Core,Desk {Add-AzRecoveryServicesAsrReplicationProΓÇª
Script     1.9.1                 Az.RedisCache                       Core,Desk {Export-AzRedisCache, Get-AzRedisCache, ΓÇª
Script     1.2.1                 Az.RedisEnterpriseCache             Core,Desk {Export-AzRedisEnterpriseCache, Get-AzReΓÇª
Script     2.0.1                 Az.Relay                            Core,Desk {Get-AzRelayAuthorizationRule, Get-AzRelΓÇª
Script     1.0.0                 Az.ResourceGraph                    Core,Desk {Search-AzGraph, Get-AzResourceGraphQuerΓÇª
Script     1.2.1                 Az.ResourceMover                    Core,Desk {Add-AzResourceMoverMoveResource, Get-AzΓÇª
Script     7.1.0                 Az.Resources                        Core,Desk {Export-AzResourceGroup, Export-AzTemplaΓÇª
Script     1.6.2                 Az.Security                         Core,Desk {Add-AzSecurityAdaptiveNetworkHardening,ΓÇª
Script     3.1.2                 Az.SecurityInsights                 Core,Desk {Get-AzSentinelAlertRule, Get-AzSentinelΓÇª
Script     4.0.0                 Az.ServiceBus                       Core,Desk {New-AzServiceBusAuthorizationRuleSASTokΓÇª
Script     3.3.3                 Az.ServiceFabric                    Core,Desk {Add-AzServiceFabricClientCertificate, AΓÇª
Script     2.0.1                 Az.SignalR                          Core,Desk {Get-AzSignalR, Get-AzSignalRKey, Get-AzΓÇª
Script     5.0.0                 Az.Sql                              Core,Desk {Add-AzSqlDatabaseToFailoverGroup, Add-AΓÇª
Script     2.2.1                 Az.SqlVirtualMachine                Core,Desk {Get-AzAvailabilityGroupListener, Get-AzΓÇª
Script     2.3.2                 Az.StackHCI                         Core,Desk {Add-AzStackHCIVMAttestation, Disable-AzΓÇª
Script     1.0.4                 Az.StackHCIVM                       Core,Desk {Add-AzStackHCIVMVirtualMachineDataDisk,ΓÇª
Script     7.0.0                 Az.Storage                          Core,Desk {Add-AzRmStorageContainerLegalHold, Add-ΓÇª
Script     1.3.1                 Az.StorageMover                     Core,Desk {Get-AzStorageMover, Get-AzStorageMoverAΓÇª
Script     2.1.1                 Az.StorageSync                      Core,Desk {Get-AzStorageSyncCloudEndpoint, Get-AzSΓÇª
Script     2.0.1                 Az.StreamAnalytics                  Core,Desk {Get-AzStreamAnalyticsCluster, Get-AzStrΓÇª
Script     2.0.0                 Az.Support                          Core,Desk {Get-AzSupportChatTranscript, Get-AzSuppΓÇª
Script     3.0.8                 Az.Synapse                          Core,Desk {Add-AzSynapseDataFlowDebugSessionPackagΓÇª
Script     1.2.2                 Az.TrafficManager                   Core,Desk {Add-AzTrafficManagerCustomHeaderToEndpoΓÇª
Script     3.2.1                 Az.Websites                         Core,Desk {Add-AzWebAppAccessRestrictionRule, Add-ΓÇª
Binary     2.0.2.182             AzureAD                             Desk      
Binary     2.0.2.149             AzureADPreview                      Desk

Error output

Can't paste because the powershell host quits ...

The text was updated successfully, but these errors were encountered:

microsoft-github-policy-service · 2024-07-11T06:24:48Z

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @DaeunYim, @rajsell.

HUMBERP added bug This issue requires a change to an existing behavior in the product in order to be resolved. needs-triage This is a new issue that needs to be triaged to the appropriate team. labels Jul 10, 2024

microsoft-github-policy-service bot added customer-reported needs-triage This is a new issue that needs to be triaged to the appropriate team. and removed needs-triage This is a new issue that needs to be triaged to the appropriate team. labels Jul 10, 2024

isra-fel added Service Attention This issue is responsible by Azure service team. PostgreSQL - Flexible Flexible server and removed needs-triage This is a new issue that needs to be triaged to the appropriate team. labels Jul 11, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Test-AzPostgreSqlFlexibleServerConnect kill PowerShell host with version 2 of SimplySQL Module #25499

Test-AzPostgreSqlFlexibleServerConnect kill PowerShell host with version 2 of SimplySQL Module #25499

HUMBERP commented Jul 10, 2024

microsoft-github-policy-service bot commented Jul 11, 2024

Test-AzPostgreSqlFlexibleServerConnect kill PowerShell host with version 2 of SimplySQL Module #25499

Test-AzPostgreSqlFlexibleServerConnect kill PowerShell host with version 2 of SimplySQL Module #25499

Comments

HUMBERP commented Jul 10, 2024

Description

Issue script & Debug output

Environment data

Module versions

Error output

microsoft-github-policy-service bot commented Jul 11, 2024