az webapp config connection-string set: not enough values to unpack (expected 2, got 1)

[sc-draymond]

az webapp config connection-string set: not enough values to unpack (expected 2, got 1)

[sc-draymond]

I found that I could not use an object to create the string and had to use a string replacement instead. This is showing to not be an issue with the connection-string set function.

$newConnectionString = $ConnectionStringName + '=''Data Source=tcp:' + $DataSource + ',1433;Initial Catalog=' + $SQLDatabase + ';User Id=' + $UserID + ';Password=' + $Password + ';'''

az webapp config connection-string set --connection-string-type SQLServer --name $AppServiceName --resource-group $AppServiceResourceGroupName --subscription $AppServiceSubscriptionID --settings $newConnectionString

[yonzhan]

Thank you for opening this issue, we will look into it.

[azure-client-tools-bot-prd]

Hi @sc-draymond
Find similar issue #11552.

Issue title	Error configuration function app with powershell object for --settings
Create time	2019-12-11
Comment number	7

Possible solution:
The error message "not enough values to unpack (expected 2, got 1)" is usually caused by an incorrect format of the input. In the existing issue, the error occurred when configuring application settings using a powershell object. The solution was to use the json format inside the json file and provide the correct path to the file in the --settings parameter.

Similarly, in this new issue, the error occurred when running the command "az webapp config connection-string set". The solution might be to check the format of the input and make sure it matches the expected format. It might also be helpful to check the structure of the json file to ensure it has the correct schema.

To set the connection string, you can try running the command with the --settings parameter and providing the correct path to the json file. The content of the json file should be in the following format:

[
{
"name": "ConnectionString",
"slotSetting": false,
"value": "Data Source=tcp:MyServer.database.windows.net,1433;Initial Catalog=MyDatabase;User Id=MyID;Password=MyPassword;"
}
]

Make sure to replace the values with your own connection string information.

---

Please confirm if this resolves your issue.

[microsoft-github-policy-service]

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

[microsoft-github-policy-service]

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

[seligj95]

I'm unable to repro - I copied your input into CloudShell and was able to set the connection strings.

Please ensure the settings parameter is formatted correctly and escape characters are included where needed based on your shell type.