search

Azure / azure-cli

Azure Command-Line Interface
MIT License
4.01k stars 2.98k forks source link

webapp connection create sql crash #24379

Closed felipmiguel closed 1 year ago

felipmiguel commented 2 years ago

This is autogenerated. Please review and update as needed.

Describe the bug

Command Name az webapp connection create sql

Errors:

The command failed with an unexpected error. Here is the traceback:
No module named 'pyodbc'
Traceback (most recent call last):
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 663, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 354, in create_aad_user_in_sql
ModuleNotFoundError: No module named 'pyodbc'

To Reproduce:

Steps to reproduce the behavior. Note that argument values have been redacted, as they may contain sensitive information.

Expected Behavior

Environment Summary

Windows-10-10.0.22621-SP0
Python 3.10.5
Installer: MSI

azure-cli 2.41.0

Extensions:
account 0.2.3
aks-preview 0.5.95
arcdata 1.4.7
azure-devops 0.25.0
connectedk8s 1.3.1
containerapp 0.3.10
k8s-configuration 1.6.0
logic 0.1.6
spring 1.1.5
spring-cloud 3.1.5

Dependencies:
msal 1.20.0b1
azure-mgmt-resource 21.1.0b1

Additional Context

yonzhan commented 2 years ago

route to CXP team

xfz11 commented 2 years ago

Thanks @felipmiguel for your feedback.

  1. Currently the code will check if pyodbc library is installed and will install it dynamically. Do you install the latest Azure CLI version with MSI?
  2. ODBC driver for sql should be installed manually. I would check our doc to make sure it's mentioned.
  3. I provide some hints for users who run the command first time, do you see similar output? image
ghost commented 2 years ago

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

Issue Details
### **This is autogenerated. Please review and update as needed.** ## Describe the bug **Command Name** `az webapp connection create sql` **Errors:** ``` The command failed with an unexpected error. Here is the traceback: No module named 'pyodbc' Traceback (most recent call last): File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 663, in execute File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__ File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 354, in create_aad_user_in_sql ModuleNotFoundError: No module named 'pyodbc' ``` ## To Reproduce: Steps to reproduce the behavior. Note that argument values have been redacted, as they may contain sensitive information. - _Put any pre-requisite steps here..._ - `az webapp connection create sql --resource-group {} --name {} --tg {} --server {} --database {} --client-type {} --system-identity` ## Expected Behavior ## Environment Summary ``` Windows-10-10.0.22621-SP0 Python 3.10.5 Installer: MSI azure-cli 2.41.0 Extensions: account 0.2.3 aks-preview 0.5.95 arcdata 1.4.7 azure-devops 0.25.0 connectedk8s 1.3.1 containerapp 0.3.10 k8s-configuration 1.6.0 logic 0.1.6 spring 1.1.5 spring-cloud 3.1.5 Dependencies: msal 1.20.0b1 azure-mgmt-resource 21.1.0b1 ``` ## Additional Context
Author: felipmiguel
Assignees: -
Labels: `Web Apps`, `Service Attention`, `Auto-Assign`
Milestone: -
navba-MSFT commented 2 years ago

Adding Service team to look into this.

felipmiguel commented 2 years ago

@xfz11 I manually installed the ODBC driver following the instructions from azure-cli. On Windows I have this:

image 
pip show pyodbc
Name: pyodbc
Version: 4.0.34
Summary: DB API Module for ODBC
Home-page: https://github.com/mkleehammer/pyodbc
Author:
Author-email:
License: MIT
Location: c:\users\fmiguel\appdata\local\programs\python\python39\lib\site-packages
Requires:
Required-by:
az webapp connection create sql --resource-group rg-dotnet-passwordless --name dotnet-passwordless-mssql --tg rg-dotnet-passwordless --server mssql-passwordless --database checklist --client-type dotnet --system-identity --debug
cli.knack.cli: Command arguments: ['webapp', 'connection', 'create', 'sql', '--resource-group', 'rg-dotnet-passwordless', '--name', 'dotnet-passwordless-mssql', '--tg', 'rg-dotnet-passwordless', '--server', 'mssql-passwordless', '--database', 'checklist', '--client-type', 'dotnet', '--system-identity', '--debug']
cli.knack.cli: __init__ debug log:
Enable color in terminal.
cli.knack.cli: Event: Cli.PreExecute []
cli.knack.cli: Event: CommandParser.OnGlobalArgumentsCreate [<function CLILogging.on_global_arguments at 0x03ADB388>, <function OutputProducer.on_global_arguments at 0x03FDE658>, <function CLIQuery.on_global_arguments at 0x03FFC2B0>]
cli.knack.cli: Event: CommandInvoker.OnPreCommandTableCreate []
cli.azure.cli.core: Modules found from index for 'webapp': ['azure.cli.command_modules.appservice', 'azure.cli.command_modules.serviceconnector']
cli.azure.cli.core: Loading command modules:
cli.azure.cli.core: Name                  Load Time    Groups  Commands
cli.azure.cli.core: appservice                0.289        72       251
cli.azure.cli.core: serviceconnector          0.236        16       212
cli.azure.cli.core: Total (2)                 0.524        88       463
cli.azure.cli.core: These extensions are not installed and will be skipped: ['azext_ai_examples', 'azext_next']
cli.azure.cli.core: Loading extensions:
cli.azure.cli.core: Name                  Load Time    Groups  Commands  Directory
cli.azure.cli.core: Total (0)                 0.000         0         0
cli.azure.cli.core: Loaded 87 groups, 463 commands.
cli.azure.cli.core: Found a match in the command table.
cli.azure.cli.core: Raw command  : webapp connection create sql
cli.azure.cli.core: Command table: webapp connection create sql
cli.knack.cli: Event: CommandInvoker.OnPreCommandTableTruncate [<function AzCliLogging.init_command_file_logging at 0x05067B20>]
cli.azure.cli.core.azlogging: metadata file logging enabled - writing logs to 'C:\Users\fmiguel\.azure\commands\2022-10-25.09-48-16.webapp_connection_create_sql.33404.log'.
az_command_data_logger: command args: webapp connection create sql --resource-group {} --name {} --tg {} --server {} --database {} --client-type {} --system-identity --debug
cli.knack.cli: Event: CommandInvoker.OnPreArgumentLoad [<function register_global_subscription_argument.<locals>.add_subscription_parameter at 0x050AB028>]
cli.knack.commands: Configured default 'rg-acme-fitness' for arg source_resource_group
cli.knack.cli: Event: CommandInvoker.OnPostArgumentLoad []
cli.knack.cli: Event: CommandInvoker.OnPostCommandTableCreate [<function register_ids_argument.<locals>.add_ids_arguments at 0x05089BF8>, <function register_cache_arguments.<locals>.add_cache_arguments at 0x050B94F0>]
cli.knack.cli: Event: CommandInvoker.OnCommandTableLoaded []
cli.knack.cli: Event: CommandInvoker.OnPreParseArgs []
cli.knack.cli: Event: CommandInvoker.OnPostParseArgs [<function OutputProducer.handle_output_argument at 0x03FDE6A0>, <function CLIQuery.handle_query_parameter at 0x03FFC2F8>, <function register_ids_argument.<locals>.parse_ids_arguments at 0x050B94A8>]
cli.azure.cli.command_modules.serviceconnector._validators: Connection name is not specified, use generated one: --connection sql_h8w6r
cli.azure.cli.core.commands.client_factory: Getting management service client client_type=ServiceLinkerManagementClient
cli.azure.cli.core.auth.persistence: build_persistence: location='C:\\Users\\fmiguel\\.azure\\msal_token_cache.bin', encrypt=True
cli.azure.cli.core.auth.binary_cache: load: C:\Users\fmiguel\.azure\msal_http_cache.bin
urllib3.util.retry: Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None, status=None)
msal.authority: openid_config = {'token_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/oauth2/v2.0/token', 'token_endpoint_auth_methods_supported': ['client_secret_post', 'private_key_jwt', 'client_secret_basic'], 'jwks_uri': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/discovery/v2.0/keys', 'response_modes_supported': ['query', 'fragment', 'form_post'], 'subject_types_supported': ['pairwise'], 'id_token_signing_alg_values_supported': ['RS256'], 'response_types_supported': ['code', 'id_token', 'code id_token', 'id_token token'], 'scopes_supported': ['openid', 'profile', 'email', 'offline_access'], 'issuer': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/v2.0', 'request_uri_parameter_supported': False, 'userinfo_endpoint': 'https://graph.microsoft.com/oidc/userinfo', 'authorization_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/oauth2/v2.0/authorize', 'device_authorization_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/oauth2/v2.0/devicecode', 'http_logout_supported': True, 'frontchannel_logout_supported': True, 'end_session_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/oauth2/v2.0/logout', 'claims_supported': ['sub', 'iss', 'cloud_instance_name', 'cloud_instance_host_name', 'cloud_graph_host_name', 'msgraph_host', 'aud', 'exp', 'iat', 'auth_time', 'acr', 'nonce', 'preferred_username', 'name', 'tid', 'ver', 'at_hash', 'c_hash', 'email'], 'kerberos_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/kerberos', 'tenant_region_scope': 'WW', 'cloud_instance_name': 'microsoftonline.com', 'cloud_graph_host_name': 'graph.windows.net', 'msgraph_host': 'graph.microsoft.com', 'rbac_url': 'https://pas.windows.net'}
msal.application: Broker enabled? False
cli.azure.cli.command_modules.serviceconnector._utils: CompletedProcess(args='az account show', returncode=0, stdout=b'{REMOVED})
cli.azure.cli.command_modules.serviceconnector._credential_free: Checking if WebApp enables System Identity...
cli.azure.cli.command_modules.serviceconnector._utils: CompletedProcess(args='az webapp identity show --ids /subscriptions/98bc5d13-2aa1-45cb-bf49-45aa47e220bf/resourceGroups/rg-dotnet-passwordless/providers/Microsoft.Web/sites/dotnet-passwordless-mssql', returncode=0, stdout=b'{\r\n  "principalId": "REMOVED",\r\n  "tenantId": "72f988bf-86f1-41af-91ab-2d7cd011db47",\r\n  "type": "SystemAssigned",\r\n  "userAssignedIdentities": null\r\n}\r\n', stderr=b'')
cli.azure.cli.command_modules.serviceconnector._utils: CompletedProcess(args='az ad sp show --id 3467ef5a-f905-481e-a16e-0b7f38dc0ba0', returncode=0, stdout=b'{\r\n  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#servicePrincipals/$entity",\r\n  "accountEnabled": true,\r\n  "addIns": [],\r\n  "alternativeNames": [\r\n    "isExplicit=False",\r\n    "/subscriptions/98bc5d13-2aa1-45cb-bf49-45aa47e220bf/resourcegroups/rg-dotnet-passwordless/providers/Microsoft.Web/sites/dotnet-passwordless-mssql"\r\n  ],\r\n  "appDescription": null,\r\n  "appDisplayName": null,\r\n  "appId": "6cfa34e9-3ab3-4927-b9ba-1e759ba45718",\r\n  "appOwnerOrganizationId": null,\r\n  "appRoleAssignmentRequired": false,\r\n  "appRoles": [],\r\n  "applicationTemplateId": null,\r\n  "createdDateTime": "2022-10-24T20:46:06Z",\r\n  "deletedDateTime": null,\r\n  "description": null,\r\n  "disabledByMicrosoftStatus": null,\r\n  "displayName": "dotnet-passwordless-mssql",\r\n  "homepage": null,\r\n  "id": "3467ef5a-f905-481e-a16e-0b7f38dc0ba0",\r\n  "info": null,\r\n  "keyCredentials": [\r\n    {\r\n     REMOVED PII CONTENT  \r\n  }\r\n}\r\n', stderr=b'')
cli.azure.cli.command_modules.serviceconnector._utils: CompletedProcess(args='az sql server ad-admin list --ids /subscriptions/98bc5d13-2aa1-45cb-bf49-45aa47e220bf/resourceGroups/rg-dotnet-passwordless/providers/Microsoft.Sql/servers/mssql-passwordless/databases/checklist', returncode=0, stdout=b'[\r\n  {\r\n    "administratorType": "ActiveDirectory",\r\n    "azureAdOnlyAuthentication": null,\r\n    "id": "/subscriptions/98bc5d13-2aa1-45cb-bf49-45aa47e220bf/resourceGroups/rg-dotnet-passwordless/providers/Microsoft.Sql/servers/mssql-passwordless/administrators/ActiveDirectory",\r\n    "login": "REMOVED PII CONTENT ",\r\n    "name": "ActiveDirectory",\r\n    "resourceGroup": "rg-dotnet-passwordless",\r\n    "sid": "909ce548-817f-41b0-bf5e-0c9295897bf7",\r\n    "tenantId": "72f988bf-86f1-41af-91ab-2d7cd011db47",\r\n    "type": "Microsoft.Sql/servers"\r\n  }\r\n]\r\n', stderr=b'')
cli.azure.cli.command_modules.serviceconnector._utils: CompletedProcess(args='az account get-access-token --output json --resource https://database.windows.net/', returncode=0, stdout=b'{\r\n  REMOVED PII CONTENT \n', stderr=b'')
cli.azure.cli.command_modules.serviceconnector._credential_free: Connecting to database...
D:\a\1\s\build_scripts\windows\artifacts\Python\Lib\site-packages\_distutils_hack/__init__.py:33: UserWarning: Setuptools is replacing distutils.
WARNING: pip is being invoked by an old script wrapper. This will fail in a future version of pip.
Please see https://github.com/pypa/pip/issues/5599 for advice on fixing the underlying issue.
To avoid this problem you can invoke Python with '-m pip' instead of running pip directly.
--- Logging error ---
Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 64, in format
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 52, in wrap_with_color
KeyError: 'verbose'
Call stack:
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 49, in <module>
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 36, in cli_main
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 656, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 349, in create_aad_user_in_sql
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\__init__.py", line 13, in main
    return _wrapper(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\entrypoints.py", line 43, in _wrapper
    return main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main.py", line 55, in main
    cmd_name, cmd_args = parse_command(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main_parser.py", line 58, in parse_command
    general_options, args_else = parser.parse_args(args)
  File "optparse.py", line 1371, in parse_args
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\parser.py", line 279, in get_default_values
    self.config.load()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 124, in load
    self._load_config_files()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 255, in _load_config_files
    parser = self._load_file(variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 261, in _load_file
    logger.verbose("For variant '%s', will try loading '%s'", variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\_log.py", line 23, in verbose
    return self.log(VERBOSE, msg, *args, **kwargs)
  File "logging\__init__.py", line 1547, in log
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1108, in emit
Message: "For variant '%s', will try loading '%s'"
Arguments: ('global', 'C:\\ProgramData\\pip\\pip.ini')
--- Logging error ---
Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 64, in format
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 52, in wrap_with_color
KeyError: 'verbose'
Call stack:
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 49, in <module>
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 36, in cli_main
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 656, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 349, in create_aad_user_in_sql
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\__init__.py", line 13, in main
    return _wrapper(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\entrypoints.py", line 43, in _wrapper
    return main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main.py", line 55, in main
    cmd_name, cmd_args = parse_command(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main_parser.py", line 58, in parse_command
    general_options, args_else = parser.parse_args(args)
  File "optparse.py", line 1371, in parse_args
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\parser.py", line 279, in get_default_values
    self.config.load()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 124, in load
    self._load_config_files()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 255, in _load_config_files
    parser = self._load_file(variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 261, in _load_file
    logger.verbose("For variant '%s', will try loading '%s'", variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\_log.py", line 23, in verbose
    return self.log(VERBOSE, msg, *args, **kwargs)
  File "logging\__init__.py", line 1547, in log
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1108, in emit
Message: "For variant '%s', will try loading '%s'"
Arguments: ('user', 'C:\\Users\\fmiguel\\pip\\pip.ini')
--- Logging error ---
Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 64, in format
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 52, in wrap_with_color
KeyError: 'verbose'
Call stack:
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 49, in <module>
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 36, in cli_main
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 656, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 349, in create_aad_user_in_sql
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\__init__.py", line 13, in main
    return _wrapper(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\entrypoints.py", line 43, in _wrapper
    return main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main.py", line 55, in main
    cmd_name, cmd_args = parse_command(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main_parser.py", line 58, in parse_command
    general_options, args_else = parser.parse_args(args)
  File "optparse.py", line 1371, in parse_args
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\parser.py", line 279, in get_default_values
    self.config.load()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 124, in load
    self._load_config_files()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 255, in _load_config_files
    parser = self._load_file(variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 261, in _load_file
    logger.verbose("For variant '%s', will try loading '%s'", variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\_log.py", line 23, in verbose
    return self.log(VERBOSE, msg, *args, **kwargs)
  File "logging\__init__.py", line 1547, in log
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1108, in emit
Message: "For variant '%s', will try loading '%s'"
Arguments: ('user', 'C:\\Users\\fmiguel\\AppData\\Roaming\\pip\\pip.ini')
--- Logging error ---
Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 64, in format
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 52, in wrap_with_color
KeyError: 'verbose'
Call stack:
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 49, in <module>
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 36, in cli_main
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 656, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 349, in create_aad_user_in_sql
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\__init__.py", line 13, in main
    return _wrapper(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\entrypoints.py", line 43, in _wrapper
    return main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main.py", line 55, in main
    cmd_name, cmd_args = parse_command(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main_parser.py", line 58, in parse_command
    general_options, args_else = parser.parse_args(args)
  File "optparse.py", line 1371, in parse_args
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\parser.py", line 279, in get_default_values
    self.config.load()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 124, in load
    self._load_config_files()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 255, in _load_config_files
    parser = self._load_file(variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 261, in _load_file
    logger.verbose("For variant '%s', will try loading '%s'", variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\_log.py", line 23, in verbose
    return self.log(VERBOSE, msg, *args, **kwargs)
  File "logging\__init__.py", line 1547, in log
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1108, in emit
Message: "For variant '%s', will try loading '%s'"
Arguments: ('site', 'C:\\Program Files (x86)\\Microsoft SDKs\\Azure\\CLI2\\pip.ini')
pip._internal.vcs.versioncontrol: Registered VCS backend: bzr
pip._internal.vcs.versioncontrol: Registered VCS backend: git
pip._internal.vcs.versioncontrol: Registered VCS backend: hg
pip._internal.vcs.versioncontrol: Registered VCS backend: svn
--- Logging error ---
Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 64, in format
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 52, in wrap_with_color
KeyError: 'verbose'
Call stack:
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 49, in <module>
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 36, in cli_main
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 656, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 349, in create_aad_user_in_sql
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\__init__.py", line 13, in main
    return _wrapper(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\entrypoints.py", line 43, in _wrapper
    return main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main.py", line 70, in main
    return command.main(cmd_args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 101, in main
    return self._main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 114, in _main
    options, args = self.parse_args(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 96, in parse_args
    return self.parser.parse_args(args)
  File "optparse.py", line 1371, in parse_args
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\parser.py", line 279, in get_default_values
    self.config.load()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 124, in load
    self._load_config_files()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 255, in _load_config_files
    parser = self._load_file(variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 261, in _load_file
    logger.verbose("For variant '%s', will try loading '%s'", variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\_log.py", line 23, in verbose
    return self.log(VERBOSE, msg, *args, **kwargs)
  File "logging\__init__.py", line 1547, in log
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1108, in emit
Message: "For variant '%s', will try loading '%s'"
Arguments: ('global', 'C:\\ProgramData\\pip\\pip.ini')
--- Logging error ---
Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 64, in format
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 52, in wrap_with_color
KeyError: 'verbose'
Call stack:
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 49, in <module>
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 36, in cli_main
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 656, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 349, in create_aad_user_in_sql
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\__init__.py", line 13, in main
    return _wrapper(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\entrypoints.py", line 43, in _wrapper
    return main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main.py", line 70, in main
    return command.main(cmd_args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 101, in main
    return self._main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 114, in _main
    options, args = self.parse_args(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 96, in parse_args
    return self.parser.parse_args(args)
  File "optparse.py", line 1371, in parse_args
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\parser.py", line 279, in get_default_values
    self.config.load()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 124, in load
    self._load_config_files()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 255, in _load_config_files
    parser = self._load_file(variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 261, in _load_file
    logger.verbose("For variant '%s', will try loading '%s'", variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\_log.py", line 23, in verbose
    return self.log(VERBOSE, msg, *args, **kwargs)
  File "logging\__init__.py", line 1547, in log
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1108, in emit
Message: "For variant '%s', will try loading '%s'"
Arguments: ('user', 'C:\\Users\\fmiguel\\pip\\pip.ini')
--- Logging error ---
Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 64, in format
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 52, in wrap_with_color
KeyError: 'verbose'
Call stack:
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 49, in <module>
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 36, in cli_main
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 656, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 349, in create_aad_user_in_sql
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\__init__.py", line 13, in main
    return _wrapper(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\entrypoints.py", line 43, in _wrapper
    return main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main.py", line 70, in main
    return command.main(cmd_args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 101, in main
    return self._main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 114, in _main
    options, args = self.parse_args(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 96, in parse_args
    return self.parser.parse_args(args)
  File "optparse.py", line 1371, in parse_args
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\parser.py", line 279, in get_default_values
    self.config.load()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 124, in load
    self._load_config_files()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 255, in _load_config_files
    parser = self._load_file(variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 261, in _load_file
    logger.verbose("For variant '%s', will try loading '%s'", variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\_log.py", line 23, in verbose
    return self.log(VERBOSE, msg, *args, **kwargs)
  File "logging\__init__.py", line 1547, in log
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1108, in emit
Message: "For variant '%s', will try loading '%s'"
Arguments: ('user', 'C:\\Users\\fmiguel\\AppData\\Roaming\\pip\\pip.ini')
--- Logging error ---
Traceback (most recent call last):
  File "logging\__init__.py", line 1100, in emit
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 64, in format
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/log.py", line 52, in wrap_with_color
KeyError: 'verbose'
Call stack:
  File "runpy.py", line 196, in _run_module_as_main
  File "runpy.py", line 86, in _run_code
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 49, in <module>
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/__main__.py", line 36, in cli_main
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 656, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 349, in create_aad_user_in_sql
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\__init__.py", line 13, in main
    return _wrapper(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\entrypoints.py", line 43, in _wrapper
    return main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\main.py", line 70, in main
    return command.main(cmd_args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 101, in main
    return self._main(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 114, in _main
    options, args = self.parse_args(args)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\base_command.py", line 96, in parse_args
    return self.parser.parse_args(args)
  File "optparse.py", line 1371, in parse_args
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\cli\parser.py", line 279, in get_default_values
    self.config.load()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 124, in load
    self._load_config_files()
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 255, in _load_config_files
    parser = self._load_file(variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\configuration.py", line 261, in _load_file
    logger.verbose("For variant '%s', will try loading '%s'", variant, fname)
  File "C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\lib\site-packages\pip\_internal\utils\_log.py", line 23, in verbose
    return self.log(VERBOSE, msg, *args, **kwargs)
  File "logging\__init__.py", line 1547, in log
  File "logging\__init__.py", line 1624, in _log
  File "logging\__init__.py", line 1634, in handle
  File "logging\__init__.py", line 1696, in callHandlers
  File "logging\__init__.py", line 968, in handle
  File "logging\__init__.py", line 1108, in emit
Message: "For variant '%s', will try loading '%s'"
Arguments: ('site', 'C:\\Program Files (x86)\\Microsoft SDKs\\Azure\\CLI2\\pip.ini')
Collecting pyodbc
  Using cached pyodbc-4.0.34.tar.gz (271 kB)
  Preparing metadata (setup.py) ... done
Building wheels for collected packages: pyodbc
  Building wheel for pyodbc (setup.py) ... error
  error: subprocess-exited-with-error

  × python setup.py bdist_wheel did not run successfully.
  │ exit code: 1
  ╰─> [5 lines of output]
      running bdist_wheel
      running build
      running build_ext
      building 'pyodbc' extension
      error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Microsoft C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
  ERROR: Failed building wheel for pyodbc
  Running setup.py clean for pyodbc
Failed to build pyodbc
Installing collected packages: pyodbc
  Running setup.py install for pyodbc ... error
  error: subprocess-exited-with-error

  × Running setup.py install for pyodbc did not run successfully.
  │ exit code: 1
  ╰─> [6 lines of output]
      running install
      D:\a\1\s\build_scripts\windows\artifacts\Python\Lib\site-packages\setuptools/command/install.py:34: SetuptoolsDeprecationWarning: setup.py install is deprecated. Use build and pip and other standards-based tools.
      running build
      running build_ext
      building 'pyodbc' extension
      error: Microsoft Visual C++ 14.0 or greater is required. Get it with "Microsoft C++ Build Tools": https://visualstudio.microsoft.com/visual-cpp-build-tools/
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: legacy-install-failure

× Encountered error while trying to install package.
╰─> pyodbc

note: This is an issue with the package mentioned above, not pip.
hint: See above for output from the failure.

[notice] A new release of pip available: 22.2.2 -> 22.3
[notice] To update, run: C:\Program Files (x86)\Microsoft SDKs\Azure\CLI2\python.exe -m pip install --upgrade pip
cli.azure.cli.command_modules.serviceconnector._credential_free: Please manually install odbc 18 for SQL server, reference: https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16 and run 'pip install pyodbc'
cli.azure.cli.core.util: azure.cli.core.util.handle_exception is called with an exception:
cli.azure.cli.core.util: Traceback (most recent call last):
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 663, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 354, in create_aad_user_in_sql
ModuleNotFoundError: No module named 'pyodbc'

cli.azure.cli.core.azclierror: The command failed with an unexpected error. Here is the traceback:
ERROR: The command failed with an unexpected error. Here is the traceback:
cli.azure.cli.core.azclierror: No module named 'pyodbc'
Traceback (most recent call last):
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 663, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 354, in create_aad_user_in_sql
ModuleNotFoundError: No module named 'pyodbc'
ERROR: No module named 'pyodbc'
Traceback (most recent call last):
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 233, in invoke
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 663, in execute
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 726, in _run_jobs_serially
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 697, in _run_job
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/__init__.py", line 333, in __call__
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/core/commands/command_operation.py", line 121, in handler
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/custom.py", line 267, in connection_create
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 73, in enable_mi_for_db_linker
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 308, in create_aad_user
  File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\azure/cli/command_modules/serviceconnector/_credential_free.py", line 354, in create_aad_user_in_sql
ModuleNotFoundError: No module named 'pyodbc'
To open an issue, please run: 'az feedback'
cli.knack.cli: Event: Cli.PostExecute [<function AzCliLogging.deinit_cmd_metadata_logging at 0x05067C40>]
exit code: 1
cli.__main__: Command ran in 23.862 seconds (init: 0.682, invoke: 23.179)
Begin splitting cli events and extra events, total events: 1
Accumulated 0 events. Flush the clients.
Finish splitting cli events and extra events, cli events: 1
Save telemetry record of length 6708 in cache
WARNING: Negative: The C:\Users\fmiguel\.azure\telemetry.txt was modified at 2022-10-25 09:48:17.601874, which in less than 600.000000 s

On Linux (WSL2):

image 
pip show pyodbc
Name: pyodbc
Version: 4.0.34
Summary: DB API Module for ODBC
Home-page: https://github.com/mkleehammer/pyodbc
Author:
Author-email:
License: MIT
Location: /home/fmiguel/.local/lib/python3.10/site-packages
Requires:
Required-by:

When executing on linux I receive the following error:


 az webapp connection create sql --resource-group rg-dotnet-passwordless --name dotnet-passwordless-mssql --tg rg-dotnet-passwordless --server mssql-passwordless --database checklist --client-type dotnet --system-identity --debug
cli.knack.cli: Command arguments: ['webapp', 'connection', 'create', 'sql', '--resource-group', 'rg-dotnet-passwordless', '--name', 'dotnet-passwordless-mssql', '--tg', 'rg-dotnet-passwordless', '--server', 'mssql-passwordless', '--database', 'checklist', '--client-type', 'dotnet', '--system-identity', '--debug']
cli.knack.cli: __init__ debug log:
Enable color in terminal.
cli.knack.cli: Event: Cli.PreExecute []
cli.knack.cli: Event: CommandParser.OnGlobalArgumentsCreate [<function CLILogging.on_global_arguments at 0x7f7e9b066d40>, <function OutputProducer.on_global_arguments at 0x7f7e9af94790>, <function CLIQuery.on_global_arguments at 0x7f7e9afc1ab0>]
cli.knack.cli: Event: CommandInvoker.OnPreCommandTableCreate []
cli.azure.cli.core: Modules found from index for 'webapp': ['azure.cli.command_modules.appservice', 'azure.cli.command_modules.serviceconnector']
cli.azure.cli.core: Loading command modules:
cli.azure.cli.core: Name                  Load Time    Groups  Commands
cli.azure.cli.core: appservice                0.082        72       251
cli.azure.cli.core: serviceconnector          0.016        12       159
cli.azure.cli.core: Total (2)                 0.098        84       410
cli.azure.cli.core: These extensions are not installed and will be skipped: ['azext_ai_examples', 'azext_next']
cli.azure.cli.core: Loading extensions:
cli.azure.cli.core: Name                  Load Time    Groups  Commands  Directory
cli.azure.cli.core: Total (0)                 0.000         0         0
cli.azure.cli.core: Loaded 83 groups, 410 commands.
cli.azure.cli.core: Found a match in the command table.
cli.azure.cli.core: Raw command  : webapp connection create sql
cli.azure.cli.core: Command table: webapp connection create sql
cli.knack.cli: Event: CommandInvoker.OnPreCommandTableTruncate [<function AzCliLogging.init_command_file_logging at 0x7f7e9a06e830>]
cli.azure.cli.core.azlogging: metadata file logging enabled - writing logs to '/home/fmiguel/.azure/commands/2022-10-25.09-43-20.webapp_connection_create_sql.1934.log'.
az_command_data_logger: command args: webapp connection create sql --resource-group {} --name {} --tg {} --server {} --database {} --client-type {} --system-identity --debug
cli.knack.cli: Event: CommandInvoker.OnPreArgumentLoad [<function register_global_subscription_argument.<locals>.add_subscription_parameter at 0x7f7e9a083370>]
cli.knack.commands: Configured default 'rg-acme-fitness-pwd' for arg source_resource_group
cli.knack.cli: Event: CommandInvoker.OnPostArgumentLoad []
cli.knack.cli: Event: CommandInvoker.OnPostCommandTableCreate [<function register_ids_argument.<locals>.add_ids_arguments at 0x7f7e9a0f5bd0>, <function register_cache_arguments.<locals>.add_cache_arguments at 0x7f7e9a0f5cf0>]
cli.knack.cli: Event: CommandInvoker.OnCommandTableLoaded []
cli.knack.cli: Event: CommandInvoker.OnPreParseArgs []
cli.knack.cli: Event: CommandInvoker.OnPostParseArgs [<function OutputProducer.handle_output_argument at 0x7f7e9af94820>, <function CLIQuery.handle_query_parameter at 0x7f7e9afc1b40>, <function register_ids_argument.<locals>.parse_ids_arguments at 0x7f7e9a0f5c60>]
cli.azure.cli.command_modules.serviceconnector._validators: Connection name is not specified, use generated one: --connection sql_8ixob
cli.azure.cli.core.commands.client_factory: Getting management service client client_type=ServiceLinkerManagementClient
cli.azure.cli.core.auth.persistence: build_persistence: location='/home/fmiguel/.azure/msal_token_cache.json', encrypt=False
cli.azure.cli.core.auth.binary_cache: load: /home/fmiguel/.azure/msal_http_cache.bin
urllib3.util.retry: Converted retries value: 1 -> Retry(total=1, connect=None, read=None, redirect=None, status=None)
msal.authority: openid_config = {'token_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/oauth2/v2.0/token', 'token_endpoint_auth_methods_supported': ['client_secret_post', 'private_key_jwt', 'client_secret_basic'], 'jwks_uri': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/discovery/v2.0/keys', 'response_modes_supported': ['query', 'fragment', 'form_post'], 'subject_types_supported': ['pairwise'], 'id_token_signing_alg_values_supported': ['RS256'], 'response_types_supported': ['code', 'id_token', 'code id_token', 'id_token token'], 'scopes_supported': ['openid', 'profile', 'email', 'offline_access'], 'issuer': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/v2.0', 'request_uri_parameter_supported': False, 'userinfo_endpoint': 'https://graph.microsoft.com/oidc/userinfo', 'authorization_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/oauth2/v2.0/authorize', 'device_authorization_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/oauth2/v2.0/devicecode', 'http_logout_supported': True, 'frontchannel_logout_supported': True, 'end_session_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/oauth2/v2.0/logout', 'claims_supported': ['sub', 'iss', 'cloud_instance_name', 'cloud_instance_host_name', 'cloud_graph_host_name', 'msgraph_host', 'aud', 'exp', 'iat', 'auth_time', 'acr', 'nonce', 'preferred_username', 'name', 'tid', 'ver', 'at_hash', 'c_hash', 'email'], 'kerberos_endpoint': 'https://login.microsoftonline.com/72f988bf-86f1-41af-91ab-2d7cd011db47/kerberos', 'tenant_region_scope': 'WW', 'cloud_instance_name': 'microsoftonline.com', 'cloud_graph_host_name': 'graph.windows.net', 'msgraph_host': 'graph.microsoft.com', 'rbac_url': 'https://pas.windows.net'}
msal.application: Broker enabled? False
cli.azure.cli.command_modules.serviceconnector._utils: CompletedProcess(args='az account show', returncode=0, stdout=b'{\n  REMOVED PII CONTENT  \n}\n', stderr=b'')
cli.azure.cli.command_modules.serviceconnector._utils: CompletedProcess(args='REMOVED"\n}\n', stderr=b'')
cli.azure.cli.command_modules.serviceconnector._credential_free: Checking if WebApp enables System Identity...
cli.azure.cli.command_modules.serviceconnector._utils: CompletedProcess(args='az webapp identity show --ids /subscriptions/98bc5d13-2aa1-45cb-bf49-45aa47e220bf/resourceGroups/rg-dotnet-passwordless/providers/Microsoft.Web/sites/dotnet-passwordless-mssql', returncode=0, stdout=b'{\n  "principalId": "REMOVED PII CONTENT\n}\n', stderr=b'')
cli.azure.cli.command_modules.serviceconnector._credential_free: Connecting to database...
Segmentation fault

Note that I there is a "Segmentation fault" error when trying to connect to the database

>Some content was removed as contains PII data
xfz11 commented 2 years ago

@felipmiguel After investigation, I find that the root cause is that Azure CLI MSI uses embedded 32bit python, but the pyodbclibrary has no pre-built wheel files for Python 32bit. So, it compiles from source code and fails.

The best workaround would be:

  1. uninstall azure cli msi.
  2. install azure cli with pip install azure-cli Then it will use your local python, which will be 64bit and can install pyodbc successfully.

A more official doc could be found here https://github.com/Azure/azure-cli/issues/20476 and other similar issue https://github.com/Azure/azure-cli/issues/18766

ghost commented 1 year ago

Hi @felipmiguel, since you haven’t asked that we “/unresolve” the issue, we’ll close this out. If you believe further discussion is needed, please add a comment “/unresolve” to reopen the issue.