ansible.builtin.azure_rm_mysqlserver (v2.9.17) — module

Install Ansible via pip

Install with pip install ansible==2.9.17

Description

Create, update and delete instance of MySQL Server.

Requirements

• python >= 2.7
• azure >= 2.0.0

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

  - name: Create (or update) MySQL Server
    azure_rm_mysqlserver:
      resource_group: myResourceGroup
      name: testserver
      sku:
        name: B_Gen5_1
        tier: Basic
      location: eastus
      storage_mb: 1024
      enforce_ssl: True
      version: 5.6
      admin_username: cloudsa
      admin_password: password

Inputs

    
sku:
    description:
    - The SKU (pricing tier) of the server.
    suboptions:
      capacity:
        description:
        - The scale up/out capacity, representing server's compute units.
      name:
        description:
        - The name of the sku, typically, tier + family + cores, for example C(B_Gen4_1),
          C(GP_Gen5_8).
      size:
        description:
        - The size code, to be interpreted by resource as appropriate.
      tier:
        choices:
        - basic
        - standard
        description:
        - The tier of the particular SKU, for example C(Basic).

name:
    description:
    - The name of the server.
    required: true

tags:
    description:
    - Dictionary of string:string pairs to assign as metadata to the object.
    - Metadata tags on the object will be updated with any provided values.
    - To remove tags set append_tags option to false.
    type: dict

state:
    choices:
    - absent
    - present
    default: present
    description:
    - Assert the state of the MySQL Server. Use C(present) to create or update a server
      and C(absent) to delete it.

secret:
    description:
    - Azure client secret. Use when authenticating with a Service Principal.
    type: str

tenant:
    description:
    - Azure tenant ID. Use when authenticating with a Service Principal.
    type: str

ad_user:
    description:
    - Active Directory username. Use when authenticating with an Active Directory user
      rather than service principal.
    type: str

profile:
    description:
    - Security profile found in ~/.azure/credentials file.
    type: str

version:
    choices:
    - 5.6
    - 5.7
    description:
    - Server version.

location:
    description:
    - Resource location. If not set, location from the resource group will be used as
      default.

password:
    description:
    - Active Directory user password. Use when authenticating with an Active Directory
      user rather than service principal.
    type: str

client_id:
    description:
    - Azure client ID. Use when authenticating with a Service Principal.
    type: str

storage_mb:
    description:
    - The maximum storage allowed for a server.
    type: int

api_profile:
    default: latest
    description:
    - Selects an API profile to use when communicating with Azure services. Default value
      of C(latest) is appropriate for public clouds; future values will allow use with
      Azure Stack.
    type: str
    version_added: 0.0.1
    version_added_collection: azure.azcollection

append_tags:
    default: true
    description:
    - Use to control if tags field is canonical or just appends to existing tags.
    - When canonical, any tags not found in the tags parameter will be removed from the
      object's metadata.
    type: bool

auth_source:
    choices:
    - auto
    - cli
    - credential_file
    - env
    - msi
    default: auto
    description:
    - Controls the source of the credentials to use for authentication.
    - Can also be set via the C(ANSIBLE_AZURE_AUTH_SOURCE) environment variable.
    - When set to C(auto) (the default) the precedence is module parameters -> C(env)
      -> C(credential_file) -> C(cli).
    - When set to C(env), the credentials will be read from the environment variables
    - When set to C(credential_file), it will read the profile from C(~/.azure/credentials).
    - When set to C(cli), the credentials will be sources from the Azure CLI profile.
      C(subscription_id) or the environment variable C(AZURE_SUBSCRIPTION_ID) can be used
      to identify the subscription ID if more than one is present otherwise the default
      az cli subscription is used.
    - When set to C(msi), the host machine must be an azure resource with an enabled MSI
      extension. C(subscription_id) or the environment variable C(AZURE_SUBSCRIPTION_ID)
      can be used to identify the subscription ID if the resource is granted access to
      more than one subscription, otherwise the first subscription is chosen.
    - The C(msi) was added in Ansible 2.6.
    type: str
    version_added: 0.0.1
    version_added_collection: azure.azcollection

create_mode:
    default: Default
    description:
    - Create mode of SQL Server.

enforce_ssl:
    default: false
    description:
    - Enable SSL enforcement.
    type: bool

admin_password:
    description:
    - The password of the administrator login.

admin_username:
    description:
    - The administrator's login name of a server. Can only be specified when the server
      is being created (and is required for creation).

resource_group:
    description:
    - The name of the resource group that contains the resource. You can obtain this value
      from the Azure Resource Manager API or the portal.
    required: true

subscription_id:
    description:
    - Your Azure subscription Id.
    type: str

cloud_environment:
    default: AzureCloud
    description:
    - For cloud environments other than the US public cloud, the environment name (as
      defined by Azure Python SDK, eg, C(AzureChinaCloud), C(AzureUSGovernment)), or a
      metadata discovery endpoint URL (required for Azure Stack). Can also be set via
      credential file profile or the C(AZURE_CLOUD_ENVIRONMENT) environment variable.
    type: str
    version_added: 0.0.1
    version_added_collection: azure.azcollection

adfs_authority_url:
    description:
    - Azure AD authority url. Use when authenticating with Username/password, and has
      your own ADFS authority.
    type: str
    version_added: 0.0.1
    version_added_collection: azure.azcollection

cert_validation_mode:
    choices:
    - ignore
    - validate
    description:
    - Controls the certificate validation behavior for Azure endpoints. By default, all
      modules will validate the server certificate, but when an HTTPS proxy is in use,
      or against Azure Stack, it may be necessary to disable this behavior by passing
      C(ignore). Can also be set via credential file profile or the C(AZURE_CERT_VALIDATION)
      environment variable.
    type: str
    version_added: 0.0.1
    version_added_collection: azure.azcollection

Outputs

fully_qualified_domain_name:
  description:
  - The fully qualified domain name of a server.
  returned: always
  sample: mysqlsrv1b6dd89593.mysql.database.azure.com
  type: str
id:
  description:
  - Resource ID.
  returned: always
  sample: /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/myResourceGroup/providers/Microsoft.DBforMySQL/servers/mysqlsrv1b6dd89593
  type: str
state:
  description:
  - A state of a server that is visible to user. Possible values include C(Ready),
    C(Dropping), C(Disabled).
  returned: always
  sample: Ready
  type: str
version:
  description:
  - Server version. Possible values include C(5.6), C(5.7).
  returned: always
  sample: 5.6
  type: str

See also

• Sign in with Azure CLI: How to authenticate using the C(az login) command. link