azurerm_mysql_database resource
Warning
This resource will be deprecated when version 2 of the inspec-azure resource pack is released. Please use the azure_mysql_database resource instead.
Use the azurerm_mysql_database
InSpec audit resource to test properties and configuration of
an Azure MySQL Database on a MySQL Server.
Azure REST API version
This resource interacts with version 2017-12-01
of the Azure Management API. For more
information see the Official Azure Documentation.
At the moment, there doesn’t appear to be a way to select the version of the Azure API docs. If you notice a newer version being referenced in the official documentation please open an issue or submit a pull request using the updated version.
Availability
Install
This resource is available in the inspec-azure
resource
pack. To use it, add the
following to your inspec.yml
in your top-level profile:
depends:
inspec-azure:
git: https://github.com/inspec/inspec-azure.git
You’ll also need to setup your Azure credentials; see the resource pack README.
Version
This resource first became available in 1.6.0 of the inspec-azure resource pack.
Syntax
The resource_group
, server_name
and database_name
must be given as a parameter.
describe azurerm_mysql_database(resource_group: 'inspec-rg', server_name: 'customer_server', database_name: 'order-db') do
it { should exist }
end
Examples
If a MySQL Database is referenced with a valid Resource Group
, Server Name
and Database name
describe azurerm_mysql_database(resource_group: 'inspec-rg', server_name: 'customer_server', database_name: 'order-db') do
it { should exist }
its('name') { should be 'order-db' }
end
If a MySQL Database is referenced with an invalid Resource Group
, Server Name
or Database Name
describe azurerm_mysql_database(resource_group: 'inspec-rg', server_name: 'customer_server', database_name: 'invalid-db-name') do
it { should_not exist }
end
Parameters
resource_group
- The resource Group to which the MySQL Server belongs.server_name
- The unique name of the MySQL Server.database_name
- The unique name of the MySQL Database.
Attributes
id
name
type
properties
id
Azure resource ID.
name
SQL Server name, e.g. customer-database
.
type
The type of Resource, typically Microsoft.DBforMySQL/servers/databases
.
properties
A collection of additional configuration properties related to the MySQL Database, e.g. collation
.
Other Attributes
There are additional attributes that may be accessed that we have not
documented. Please take a look at the Azure documentation.
Any attribute in the response may be accessed with the key names separated by
dots (.
).
The API may not always return keys that do not have any associated data. There may be cases where the deeply nested property may not have the desired attribute along your call chain. If you find yourself writing tests against properties that may be nil, fork this resource pack and add an accessor to the resource. Within that accessor you’ll be able to guard against nil keys. Pull requests are always welcome.
Matchers
For a full list of available matchers, see our Universal Matchers page.This resource has the following special matchers.
exists
describe azurerm_mysql_database(resource_group: 'my-rg', server_name: 'server-name-1', database_name: 'customer-db') do
it { should exist }
end
Azure Permissions
Your Service
Principal
must be setup with a contributor
role on the subscription you wish to test.