webapp connection create sql crash #24379
Assignees
Labels
Auto-Assign
Auto assign by bot
issue-addressed
This issue is addressed and ready to close.
question
The issue doesn't require a change to the product in order to be resolved. Most issues start as that
Service Attention
This issue is responsible by Azure service team.
Web Apps
az webapp
Comments
ghost
added
Web Apps
|
route to CXP team |
|
Thanks @felipmiguel for your feedback.
|
navba-MSFT
added
Service Attention
|
Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @AzureAppServiceCLI, @antcp. Issue DetailsThis is autogenerated. Please review and update as needed.Describe the bugCommand Name Errors: To Reproduce:Steps to reproduce the behavior. Note that argument values have been redacted, as they may contain sensitive information.
Expected BehaviorEnvironment SummaryAdditional Context
|
|
Adding Service team to look into this. |
|
@xfz11 I manually installed the ODBC driver following the instructions from azure-cli. On Windows I have this: On Linux (WSL2): 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 |
|
@felipmiguel The best workaround would be:
A more official doc could be found here #20476 and other similar issue #18766 |
navba-MSFT
added
question
|
Hi @felipmiguel, since you haven’t asked that we “ |
This issue was closed.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This is autogenerated. Please review and update as needed.
Describe the bug
Command Name
az webapp connection create sqlErrors:
To Reproduce:
Steps to reproduce the behavior. Note that argument values have been redacted, as they may contain sensitive information.
az webapp connection create sql --resource-group {} --name {} --tg {} --server {} --database {} --client-type {} --system-identityExpected Behavior
Environment Summary
Additional Context
The text was updated successfully, but these errors were encountered: