How to Remove Client Secrets from Source Code: Part II (the environment part)

Or:  How to batch update environment variables in Azure App Services.

It’s so easy, yet so wrong to put client secrets and passwords to external services in your source code.  But for a small site like music4dance, it just didn’t seem to be worth the trouble to do anything else when the only people that had access to the source code were also trusted enough to have access to the passwords.  I talked about why I changed my mind in my last post as well as how I refactored my code to make it reasonably easy to make the changes.

The other part of the problem is that I now have a couple of dozen environment variables that I want to set on a number of machines, both locally and in the cloud and I don’t want to have to update them manually.  I can easily write a command or PowerShell script to handle local machines, but how do I manage the Azure App Services in the cloud?  It seems like PowerShell remote management would be a reasonable way to approach this, similar to the solution to restarting Azure Search, but I was completely stumped on how to to do that.

Azure Resource Explorer

Until I found this new tool called Azure Resource Explorer.  Check out David Ebbo’s video describing it here:

Azure Resource Explorer

It’s incredibly straightforward.  Just open up the website and sign in with the same credentials that you use for the Azure portal.  There is a drop-down control in the top center where you choose your directory, make sure you set it to the directory that you’re interested in modifying if you have multiple subscriptions set up.  Then take a gander at the tree control in the left pane.

I see two top-level nodes: Providers and Subscriptions. Spend some time browsing through this tree as there is plenty of gold here.

In order to change the environment variables for my web site, I’m looking for the settings for the App Service called music4dance which is housed in the Default-Web-WestUS resource group.  So I navigate through the hierarchy like this:  subscriptions->bizspark->resourceGroups->Default-Web-WestUS->providers->Microsoft.Web->sites->m4d->config->appsettings.

Once I’ve selected app settings in the tree, I can look at the main panel, where the default tab is labeled Data (GET, PUT).  The text box has a JSON formatted object that describes the node in the tree and contains a property set of the environment variables for app settings.  We can almost stop here if we want to.  The first time through this I just copied my block of environment variables into the properties section and hit the POST button.  I went back to the azure portal, navigated to the Application Settings panel and scrolled down to the app settings panel, and there I saw my new environment variables.

Azure Resource Explorer
Azure Resource Explorer


But the best part is the PowerShell tab. This gives the template to view and modify the object that we’re viewing.

# PowerShell equivalent script

# List appsettings
$resource = Invoke-AzureRmResourceAction -ResourceGroupName My-Resource-Group-Name -ResourceType Microsoft.Web/sites/config -ResourceName my-resource-name/appsettings -Action list -ApiVersion 2015-08-01 -Force

# SET list
$PropertiesObject = @{
	#Property = value;
New-AzureRmResource -PropertyObject $PropertiesObject -ResourceGroupName My-Resource-Group-Name -ResourceType Microsoft.Web/sites/config -ResourceName my-resource-name/appsettings -ApiVersion 2015-08-01 -Force

You can just copy this into a .ps file and add in your environment variables to the PropertyObject. Don’t forget to add all the other environment variables (you can grab these in an appropriate format from the get/post tab of the resource explorer). To match up with the code that I wrote to load the environment variables, my version of SET list looks something like this:

# SET list
$PropertiesObject = @{
    #Property = value;
    "xbox-client-id" = "my-xbox-clientid";
    "xbox-client-secret" = "my-xbox-client-secret";
    "spot-client-id", "my-spotify-clientid";
    "spot-client-secret", "my-spotify-client-secret";
    # and many more

Putting it all together

The way I run this script is to load it into the PowerShell ISE, log into the correct subscription (see the instruction to do that here) and run the script. Pretty simple, and not prone to typos or copy/paste errors the way doing the same thing in the azure portal would be.

I think the ultimate solution would be to write a pair of PowerShell scripts, one to do the local load and one to do the remote load, both taking the same tab separated or JSON formatted file of id/secret pairs. That’s more effort than I would put in for myself, but if others are interested I’ll see what I can throw together.

Restarting Azure Search

I had the misfortune of discovering that my Azure Search Service had been stopped unexpectedly.  In the end, this turned out to be my fault (I let a subscription lapse), and the azure search folks were a great help in resolving the issue.  But the bottom line was, when I saw that the website had broken and tracked it down to the search service not responding, I was stuck.

Here’s what I saw:

Search with Status = Stopped

After some frantic searching around the portal interface as well as asking the internet I concluded that there wasn’t any way to restart the service from the portal.  What didn’t occur to me since I’ve never used PowerShell for azure management in the past is that there is a reasonably easy way to start and stop the search service (and presumably other services) from PowerShell.

Here’s what I did:

Step 1: Install the Azure PowerShell cmdlets

I followed the instructions here and used the second method – Installing from the WebPI.

Step 2: Logging in

Since I have multiple subscriptions, I couldn’t just use the standard login, I had to add the SubscriptionId parameter.

PS >Login-AzureRmAccount -SubscriptionId xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

Environment           : AzureCloud
Account               :
TenantId              : yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy
SubscriptionId        : 
SubscriptionName      : BizSpark
CurrentStorageAccount : 

Step 3: Start the Search Service

PS >Invoke-AzureRmResourceAction -ResourceType "Microsoft.Search/searchServices" -ResourceGroupName "My-Resource-Group-Name" -ResourceName "my-resource-name" -ApiVersion 2015-08-19 -Action "Start"

id         : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroupsMy-Resource-Group-Name/providers/Microsoft.Search/searchServices/my-resource-name
name       : m4d
type       : Microsoft.Search/searchServices
location   : West US
properties : @{replicaCount=1; partitionCount=1; status=running; statusDetails=; provisioningState=succeeded; hostingMode=Default}
sku        : @{name=free}

And Voila, the search service is restarted and the website is back up and running again.

Search with Status = Running

Step 0: Errata

Of course, this didn’t go as smoothly as I outlined. There were two major blockers. First, I didn’t think to pop down to the PowerShell tools when the portal didn’t do what I needed it to do. That’s a lesson that I’m hoping I only have to learn once.

The second issue was that I didn’t actually do a clean install of the PowerShell extensions, assuming that since I was keeping Visual Studio up to date including Azure extensions that would take care of PowerShell. So my first attempt to start the service looked more like this:

PS >Invoke-AzureRmResourceAction -ResourceType "Microsoft.Search/searchServices" -ResourceGroupName "My-Resource-Group-Name" -ResourceName "my-resource-name" -ApiVersion 2015-08-19 -Action "Start"

Invoke-AzureRmResourceAction : Run Login-AzureRmAccount to login.
At line:1 char:1
+ Invoke-AzureRmResourceAction -ResourceType "Microsoft.Search/searchSe ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  + CategoryInfo : InvalidOperation: (:) [], PSInvalidOperationException

But I had already logged in, and apparently successfully. So WTF? After scratching my head a bit, I started looking at version information and discovered that I was on version 1 of the Azure PowerShell cmdlet, while the current version was 3.1.0. Oops.

Here’s how to check your cmdlet versions:

PS >(Get-Module -ListAvailable | Where-Object{ $_.Name -eq 'Azure' }) `
| Select Version, Name, Author, PowerShellVersion  | Format-List;

Version           : 3.1.0
Name              : Azure
Author            : Microsoft Corporation
PowerShellVersion : 3.0

And while I’m at it, here’s how to check your PowerShell version and some of the related stack:

PS >$PSVersionTable

Name                           Value                                                                                                                                                                                                                                               
----                           -----                                                                                                                                                                                                                                               
PSVersion                      5.1.14393.576                                                                                                                                                                                                                                       
PSEdition                      Desktop                                                                                                                                                                                                                                             
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                                                                                                                                                                                             
BuildVersion                   10.0.14393.576                                                                                                                                                                                                                                      
CLRVersion                     4.0.30319.42000                                                                                                                                                                                                                                     
WSManStackVersion              3.0                                                                                                                                                                                                                                                 
PSRemotingProtocolVersion      2.3                                                                                                                                                                                                                                                 


I will be digging into more PowerShell management options since my naive assumption that the portal would give me what I needed to manage Azure Services was proven so totally wrong in this case.