This application implements a Custom Resource provider for Microsoft Azure. The code is a REST-endpoint (implemented in ASP.NET Core 3). With this CRP, you can create and delete PostgreSQL databases (CREATE DATABASE foo) within an existing 'Azure Database for PostgreSQL' instance.

By default, ARM templates allow you to create a database instance (a server), but you need imperative code to create databases within the instance. This code does the following:

1. An ARM template for provisioning a PostgreSQL instance (so you have some resource to play around with), and a KeyVault instance (for storing the connection string)
2. An ARM template for registering a custom resource provider REST endpoint. This creates a hidden resource in your resource group. Please note that during the registration phase, there is no interaction between the ARM backend and our REST service.
3. An ARM template for creating a custom resource (in our sample a PostgreSQL database and a demo table)
4. A .NET Core application exposing the custom RP implementation via REST. During deployment/creation of the custom resource in the previous step, the ARM backend from Azure calls via PUT into our REST endpoint, and instructs it to create the actual custom resource.

• Uses the letsEncryptDomain config value to fetch a corresponding TLS server certificate from LetsEncrypt.
• Uses the authorizedCallers.armURI config value to fetch the current production client certificates from Azure.
• Uses the authorizedCallers.thumbPrints config value to identify (potentially self-signed) X.509 certificates for local REST calls.
• Uses the requiredCodeParameter config value to configure a ?code=... query parameter to determine valid calls.
• Uses the AzureServicesAuthConnectionString environment variable to fetch a service principal credential to authN against Azure KeyVault.
• Uses the AzureKeyVaultName and AzureKeyVaultSecretName to identity the KeyVault instance and secret name, to fetch the PostgreSQL connection string.
• The REST endpoint requires https:// (with client certificate) for provisioning requests.
• The REST endpoint currently supports create (PUT) and delete (DELETE) operations.
• When deleting a PostgreSQL database, the SQL code tries to terminate current connections to the database, before DROPping the database. This is not necessarily production quality DBA behavior, so use with care.
• All developer-provided config is stored in vars_used.json. This file MUST NOT be checked into version control!

Please have the following things ready:

• Your Azure Subscription ID
• Your Azure AD Tenant ID
• An existing service principal, i.e. the application ID of the service principal, and a password. This service principal will be used by the custom resource provider to read the PostgreSQL connection string from KeyVault.
• Some location where you can host your REST endpoint, such as an Azure web app, or some VM with a public IP address.

To setup the overall environment, run scripts/vars_set.cmd. This script will interactively collect various configuration values, and store them in ./vars_user.json. Please note that vars_user.json contains confidential information, and must not be checked in to git. All other scripts read their config primarily from that file.

If you plan to run run the .NET core code locally, please run scripts/set_AzureServicesAuthConnectionString.cmd.

This script will set a couple of environment variables needed by the running service, namely AzureServicesAuthConnectionString, AzureKeyVaultName and AzureKeyVaultSecretName.

!! Now restart your shell, to ensure to pickup the new values !!

This demo needs an Azure KeyVault and a PostgreSQL DB instance. The scripts/DEPLOY_DB_KEYVAULT.cmd command deploys these resources using the templates/postgresql_and_keyvault.json template.

To register the custom resource provider in a resource group, run the scripts/DEPLOY_CRP.cmd.

Each custom resource provider needs a name and a type. Currently, I'm pulling these out of templates/provider.json

DNS: When developing the CRP, I wanted to be able to locally (on my laptop) set a breakpoint in the codebase, so I created a .NET Core 3 console app, self-hosting the REST API via Kestrel. My DSL router at regularly registers itself at a dynamic DNS service, and I created a CNAME at my private domain to point to that dynamic DNS entry.

TCP Forwarding: On my DSL router, I configured port forwarding for ports 80/443 to my development machine, so that inbound Internet connections to my proper CNAME end up on my dev box.

When you register your CRP with an https:// URL, the ARM backend calls into your REST endpoint and authenticates itself using an X509 client certificate. ARM requires your TLS endpoint to serve out a proper (valid) certificate, so the application uses the fabulous LetsEncrypt CA to dynamically fetch a server cert. The ACME dance during certificate issuance is also the reason why we're exposing port TCP/80 for the initial phase. Actual CRP request require a TLS-connection.

The scripts/ folder contains various Windows command (.cmd) files:

• Configuration
  • vars_set.cmd to collect various deployment-time values, so that subsequent deployment scripts have all required data. When you re-run this script, it shows the current config values (if any), so pressing RETURN will keep the values as is.
  • vars_show.cmd prints the current configuration on screen.
  • vars_populate.cmd and vars_from_user_json_config.cmd are internal scripts, not to be used directly.
  • set_AzureServicesAuthConnectionString.cmd sets environment variables to you can locally run the server code.
• Deployment
  • DEPLOY_DB_KEYVAULT.cmd deploys a PostgreSQL and KeyVault instance to play with.
  • DEPLOY_CRP.cmd registers the custom resource provider.
  • Creating a custom resource
    • PUT_dev.cmd uses cURL to locally simulate an inbound creation call.
    • PUT_prod.cmd uses az to really deploy a custom resource via Azure.
  • Deleting a custom resource
    • DELETE_dev.cmd uses cURL to locally simulate an inbound deletion call.
    • DELETE_prod.cmd uses az to delete a custom resource via Azure.
  • LIST.cmd uses az to list all custom resources.