Attachment 871447 Details for Bug 1073420 – 192.168.1.12_mysql.pp

192.168.1.12_mysql.pp

192.168.1.12_mysql.pp (text/plain), 1.49 KB, created by Giulio Fidente on 2014-03-06 13:30:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Giulio Fidente

Created: 2014-03-06 13:30:08 UTC

Size: 1.49 KB

patch

obsolete

>
>class {"mysql::server":
>    config_hash => {bind_address => "0.0.0.0",
>                    root_password => "5a2ecb02da674561",}
>}
>
># deleting database users for security
># this is done in mysql::server::account_security but has problems
># when there is no fqdn, so we're defining a slightly different one here
>database_user { [ 'root@127.0.0.1', 'root@::1', '@localhost', '@%' ]:
>    ensure  => 'absent', require => Class['mysql::config'],
>}
>if ($::fqdn != "" and $::fqdn != "localhost") {
>    database_user { [ "root@${::fqdn}", "@${::fqdn}"]:
>        ensure  => 'absent', require => Class['mysql::config'],
>    }
>}
>if ($::fqdn != $::hostname and $::hostname != "localhost") {
>    database_user { ["root@${::hostname}", "@${::hostname}"]:
>        ensure  => 'absent', require => Class['mysql::config'],
>    }
>}
>
>class {"keystone::db::mysql":
>    password      => "011c510c6bf8408f",
>    allowed_hosts => "%",
>}
>
>class {"nova::db::mysql":
>    password      => "f878d01494584ae3",
>    allowed_hosts => "%",
>}
>class {"cinder::db::mysql":
>    password      => "5d2a69e6175f49c3",
>    allowed_hosts => "%",
>}
>class {"glance::db::mysql":
>    password      => "41b9fc9be38f4b1f",
>    allowed_hosts => "%",
>}
># Create firewall rules to allow only the hosts that need to connect
># to mysql
>
>$hosts = [ '192.168.1.12' ]
>
>define add_allow_host {
>    firewall { "001 mysql incoming ${title}":
>        proto  => 'tcp',
>        dport  => ['3306'],
>        action => 'accept',
>        source => $title,
>    }
>}
>
>add_allow_host { $hosts:}
>

Actions: View

Attachments on bug 1073420: 871447