template5

heat_template_version: 2013-05-23

parameters:
  database_name:
    type: string
  database_user:
    type: string
  database_password:
    type: string
  database_root_password:
    type: string

resources:
  myserver:
    type: OS::Nova::Server
    Metadata:
      AWS::CloudFormation::Init:
        config:
          packages:
            yum:
              mariadb: []
              mariadb-server: []
          services:
            systemd:
              mariadb: {enabled: 'true', ensureRunning: 'true'}
    properties:
      flavor: m1.small
      image: Fedora-x86_64-20-20131211.1-sda
      key_name: heat
      user_data:
        str_replace:
          template: |
            #!/bin/bash -v
            /opt/aws/bin/cfn-init
            mysqladmin -u root password $db_rootpassword
            cat << EOF | mysql -u root --password=$db_rootpassword
            CREATE DATABASE $db_name;
            GRANT ALL PRIVILEGES ON $db_name.* TO "$db_user"@"%"
            IDENTIFIED BY "$db_password";
            FLUSH PRIVILEGES;
            EXIT
            EOF
          params:
            $db_rootpassword: {get_param: database_root_password}
            $db_name: {get_param: database_name}
            $db_user: {get_param: database_user}
            $db_password: {get_param: database_password}

outputs:
  server_address:
    value: {get_attr: [myserver, first_address]}