From 99a5f0bebc3cdc5e73b25b4ac603df21f758becd Mon Sep 17 00:00:00 2001 From: Thomas Heller Date: Mon, 26 Sep 2016 15:21:56 +0200 Subject: [PATCH] BJE - configured live and db hosts --- customer/buschjaeger/common.yaml | 5 -- .../db01-buschjaeger-de.pixelpark.net.yaml | 29 +++++++++ .../db02-buschjaeger-de.pixelpark.net.yaml | 29 +++++++++ .../web01-buschjaeger-de.pixelpark.net.yaml | 62 +++++++++++++++++++ .../web02-buschjaeger-de.pixelpark.net.yaml | 62 +++++++++++++++++++ 5 files changed, 182 insertions(+), 5 deletions(-) diff --git a/customer/buschjaeger/common.yaml b/customer/buschjaeger/common.yaml index 68c58935..ed97d539 100644 --- a/customer/buschjaeger/common.yaml +++ b/customer/buschjaeger/common.yaml @@ -1,6 +1 @@ --- -accounts::users: - service.typo3: - apply: true - group: httpd - shell: bash diff --git a/customer/buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml b/customer/buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml index 4c3c2b5e..a6261b9f 100644 --- a/customer/buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml +++ b/customer/buschjaeger/db01-buschjaeger-de.pixelpark.net.yaml @@ -1,2 +1,31 @@ --- site::role: base + - site::profile::mysql_server + - logstash + +mysql::server::override_options: + 'mysqld': + server-id: '1' + auto_increment_offset: '1' + bind-address: '93.188.107.174' + auto_increment_increment: '2' + log-bin: 'binlog' + binlog-format: 'MIXED' + binlog-ignore-db: 'performance_schema, information_schema' + +mysql::server::root_password: +mysql::server::backup::backuppassword: +mysql::server::users: + 'replication@%': + password_hash: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAISEU6/p9Sf4rdpvXIymQLNHnM2mgSaJn2Gz+B25v6QqN3M5fmoSt5mu/KMtz3qj8yezsWpYnNyktJgN1wlymiDCoZKQeRDSKbyRuSoKanB5oOzv6Xa/iv1SBbE4By64KunjEOYFkdw9/e5kyWreAi2kJrdZnve6A5vC4c4wGnNL3Tpp1DBxdOSGS0S/5d5GHKUcRbiymtWuKYHMqoGPbCdHfwXOxe93Jlivvc9Mt3IXT7ZWONdr8RT1hPwSKi0sHoYOxexHQHq4V4ZNq4uscEzUcC8ZtOZ5umhaVxSWJ7UJPpjo5V29QZl8+CwTKkFOv3qextgQBgmlW2HORmXW1ZjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBcQq9kFLzo8Chvtlbqm64qgCDeGWgkUXvLRKEpNWjrhgS1Z2BOlbhlKXCmZGkkO4xdWg==] +mysql::server::grants: + 'replication@%/*.*': + options: 'GRANT' + privileges: 'REPLICATION SLAVE' + table: '*.*' + user: 'replication@%' + +site::profile::mysql_server::databases: + buschjaeger: + user: buschjaeger + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAg3b/hcogcZWEXmAR+t2/jsP8GIqbN7pQGnKtV9pmajGjt4OI/+RiUbw6mLZ2ZbdO+w7laW04rUozwyXGQwn10nfbym0m+IDAjVuAnQP5Sl3tU2Kdje+bcc5IAU36CoidkoAvMAI5Z9GHWtW/S8nr1tNeabzLotsJM4VOGpIF/s+aIJ+OSVHMuYcsW0PH0lSF+Gm0ErZZJ16YenU1Sazd625nABlKwOdZbtxfloB2ilQkoqhT/xWQrmqDNpuNqepQojJ5ncyYiVr3AM313LyCsbwvrt/YGCHXBo6MQvKfj7BrZsMiTUg9KeCd3nAtoVs8QfmymOQbdPRFFF7d6xfIXTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBfcrjMmfsDXo4qdURIb30BgCCIyMbnpf3K2Qg8Fgp+kWcsqJpK6SP0tOxXK4yG/YTd5Q==] diff --git a/customer/buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml b/customer/buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml index 4c3c2b5e..d97a9b1f 100644 --- a/customer/buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml +++ b/customer/buschjaeger/db02-buschjaeger-de.pixelpark.net.yaml @@ -1,2 +1,31 @@ --- site::role: base + - site::profile::mysql_server + - logstash + +mysql::server::override_options: + 'mysqld': + server-id: '2' + auto_increment_offset: '2' + bind-address: '93.188.107.175' + auto_increment_increment: '2' + log-bin: 'binlog' + binlog-format: 'MIXED' + binlog-ignore-db: 'performance_schema, information_schema' + +mysql::server::root_password: +mysql::server::backup::backuppassword: +mysql::server::users: + 'replication@%': + password_hash: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAISEU6/p9Sf4rdpvXIymQLNHnM2mgSaJn2Gz+B25v6QqN3M5fmoSt5mu/KMtz3qj8yezsWpYnNyktJgN1wlymiDCoZKQeRDSKbyRuSoKanB5oOzv6Xa/iv1SBbE4By64KunjEOYFkdw9/e5kyWreAi2kJrdZnve6A5vC4c4wGnNL3Tpp1DBxdOSGS0S/5d5GHKUcRbiymtWuKYHMqoGPbCdHfwXOxe93Jlivvc9Mt3IXT7ZWONdr8RT1hPwSKi0sHoYOxexHQHq4V4ZNq4uscEzUcC8ZtOZ5umhaVxSWJ7UJPpjo5V29QZl8+CwTKkFOv3qextgQBgmlW2HORmXW1ZjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBcQq9kFLzo8Chvtlbqm64qgCDeGWgkUXvLRKEpNWjrhgS1Z2BOlbhlKXCmZGkkO4xdWg==] +mysql::server::grants: + 'replication@%/*.*': + options: 'GRANT' + privileges: 'REPLICATION SLAVE' + table: '*.*' + user: 'replication@%' + +site::profile::mysql_server::databases: + buschjaeger: + user: buschjaeger + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAg3b/hcogcZWEXmAR+t2/jsP8GIqbN7pQGnKtV9pmajGjt4OI/+RiUbw6mLZ2ZbdO+w7laW04rUozwyXGQwn10nfbym0m+IDAjVuAnQP5Sl3tU2Kdje+bcc5IAU36CoidkoAvMAI5Z9GHWtW/S8nr1tNeabzLotsJM4VOGpIF/s+aIJ+OSVHMuYcsW0PH0lSF+Gm0ErZZJ16YenU1Sazd625nABlKwOdZbtxfloB2ilQkoqhT/xWQrmqDNpuNqepQojJ5ncyYiVr3AM313LyCsbwvrt/YGCHXBo6MQvKfj7BrZsMiTUg9KeCd3nAtoVs8QfmymOQbdPRFFF7d6xfIXTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBfcrjMmfsDXo4qdURIb30BgCCIyMbnpf3K2Qg8Fgp+kWcsqJpK6SP0tOxXK4yG/YTd5Q==] diff --git a/customer/buschjaeger/web01-buschjaeger-de.pixelpark.net.yaml b/customer/buschjaeger/web01-buschjaeger-de.pixelpark.net.yaml index 4c3c2b5e..a5214f7e 100644 --- a/customer/buschjaeger/web01-buschjaeger-de.pixelpark.net.yaml +++ b/customer/buschjaeger/web01-buschjaeger-de.pixelpark.net.yaml @@ -1,2 +1,64 @@ --- site::role: base +site::additional_classes: + - site::profile::mysql_server + - site::profile::typo3 + - apache::mod::headers + +accounts::users: + jenkins: + apply: true + group: apache + service.typo3: + apply: true + group: apache + heiko.hardt: + apply: true + +apache::default_vhost: false +apache::mpm_module: worker + +repo::remi_php70: true + +site::profile::apache::htdigest: + server: + www: ENC[PKCS7,MIIBeQYJKoZIhvcNAQcDoIIBajCCAWYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAA99fMDcku0YVZ6iGjWLJ0SyNookLa5DcQM4qy4ccId+UgOS/7fRcjQa3+TEPH26cBnH6yU3nqSPEoB94NtG7oGUP/UYJ0gFDBoLDvixGKItd4NkTYU2Ac94JjFRF+FNxXTvT9R2oPoJPsNsKM+lHY7d6oPD2FWCEyt3vjFxV8Vi4no5jDzTttiwtB/RMrCHjKoxjVHHh+f12fFvCgFS1tDTxWeckNESvD06K8kHjTgRuVP/SrkdKeMIcW09MJuLRlQjPDfGfOR0fncUwL4M4DtDZUs1ZQMszf1A+WpHst8EWGRAMVfZlW7LmczxdZLDlE4g4uRWLospi0YBFzdtYPDA8BgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBA302qMqHx/UHmKRsDlv0uogBDBDvhIN/87hDeBt4DaAw4u] + +site::profile::typo3::projects: + buschjaeger: + version: '7.6.11' + site_path: '/var/www/html/buschjaeger.de' + db_pass: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAg3b/hcogcZWEXmAR+t2/jsP8GIqbN7pQGnKtV9pmajGjt4OI/+RiUbw6mLZ2ZbdO+w7laW04rUozwyXGQwn10nfbym0m+IDAjVuAnQP5Sl3tU2Kdje+bcc5IAU36CoidkoAvMAI5Z9GHWtW/S8nr1tNeabzLotsJM4VOGpIF/s+aIJ+OSVHMuYcsW0PH0lSF+Gm0ErZZJ16YenU1Sazd625nABlKwOdZbtxfloB2ilQkoqhT/xWQrmqDNpuNqepQojJ5ncyYiVr3AM313LyCsbwvrt/YGCHXBo6MQvKfj7BrZsMiTUg9KeCd3nAtoVs8QfmymOQbdPRFFF7d6xfIXTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBfcrjMmfsDXo4qdURIb30BgCCIyMbnpf3K2Qg8Fgp+kWcsqJpK6SP0tOxXK4yG/YTd5Q==] + db_user: buschjaeger + db_name: buschjaeger + servername: web01-buschjaeger-de.pixelpark.net + ssl_cert: '/etc/pki/tls/certs/wildcard.pixelpark.net-cert.pem' + ssl_key: '/etc/pki/tls/private/wildcard.pixelpark.net-key.pem' + ssl_chain: '/etc/pki/tls/certs/wildcard.pixelpark.net-cert.pem' + directories: + - directory1: + provider: directory + path: '/var/www/html/buschjaeger.de/' + options: + - FollowSymLinks + - MultiViews + allow_override: + - All + - location1: + provider: location + path: '/' + auth_type: Digest + auth_name: server + auth_digest_provider: file + auth_digest_algorithm: MD5 + auth_user_file: '/etc/httpd/htdigest' + auth_require: 'valid-user' + require: + - local + user: service.typo3 + mode: '2775' + php_admin_value: + post_max_size: 500M + max_input_vars: 1500 + memory_limit: 256M + always_populate_raw_post_data: -1 diff --git a/customer/buschjaeger/web02-buschjaeger-de.pixelpark.net.yaml b/customer/buschjaeger/web02-buschjaeger-de.pixelpark.net.yaml index 4c3c2b5e..780a33e8 100644 --- a/customer/buschjaeger/web02-buschjaeger-de.pixelpark.net.yaml +++ b/customer/buschjaeger/web02-buschjaeger-de.pixelpark.net.yaml @@ -1,2 +1,64 @@ --- site::role: base +site::additional_classes: + - site::profile::mysql_server + - site::profile::typo3 + - apache::mod::headers + +accounts::users: + jenkins: + apply: true + group: apache + service.typo3: + apply: true + group: apache + heiko.hardt: + apply: true + +apache::default_vhost: false +apache::mpm_module: worker + +repo::remi_php70: true + +site::profile::apache::htdigest: + server: + www: ENC[PKCS7,MIIBeQYJKoZIhvcNAQcDoIIBajCCAWYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAA99fMDcku0YVZ6iGjWLJ0SyNookLa5DcQM4qy4ccId+UgOS/7fRcjQa3+TEPH26cBnH6yU3nqSPEoB94NtG7oGUP/UYJ0gFDBoLDvixGKItd4NkTYU2Ac94JjFRF+FNxXTvT9R2oPoJPsNsKM+lHY7d6oPD2FWCEyt3vjFxV8Vi4no5jDzTttiwtB/RMrCHjKoxjVHHh+f12fFvCgFS1tDTxWeckNESvD06K8kHjTgRuVP/SrkdKeMIcW09MJuLRlQjPDfGfOR0fncUwL4M4DtDZUs1ZQMszf1A+WpHst8EWGRAMVfZlW7LmczxdZLDlE4g4uRWLospi0YBFzdtYPDA8BgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBA302qMqHx/UHmKRsDlv0uogBDBDvhIN/87hDeBt4DaAw4u] + +site::profile::typo3::projects: + buschjaeger: + version: '7.6.11' + site_path: '/var/www/html/buschjaeger.de' + db_pass: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAg3b/hcogcZWEXmAR+t2/jsP8GIqbN7pQGnKtV9pmajGjt4OI/+RiUbw6mLZ2ZbdO+w7laW04rUozwyXGQwn10nfbym0m+IDAjVuAnQP5Sl3tU2Kdje+bcc5IAU36CoidkoAvMAI5Z9GHWtW/S8nr1tNeabzLotsJM4VOGpIF/s+aIJ+OSVHMuYcsW0PH0lSF+Gm0ErZZJ16YenU1Sazd625nABlKwOdZbtxfloB2ilQkoqhT/xWQrmqDNpuNqepQojJ5ncyYiVr3AM313LyCsbwvrt/YGCHXBo6MQvKfj7BrZsMiTUg9KeCd3nAtoVs8QfmymOQbdPRFFF7d6xfIXTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBfcrjMmfsDXo4qdURIb30BgCCIyMbnpf3K2Qg8Fgp+kWcsqJpK6SP0tOxXK4yG/YTd5Q==] + db_user: buschjaeger + db_name: buschjaeger + servername: web02-buschjaeger-de.pixelpark.net + ssl_cert: '/etc/pki/tls/certs/wildcard.pixelpark.net-cert.pem' + ssl_key: '/etc/pki/tls/private/wildcard.pixelpark.net-key.pem' + ssl_chain: '/etc/pki/tls/certs/wildcard.pixelpark.net-cert.pem' + directories: + - directory1: + provider: directory + path: '/var/www/html/buschjaeger.de/' + options: + - FollowSymLinks + - MultiViews + allow_override: + - All + - location1: + provider: location + path: '/' + auth_type: Digest + auth_name: server + auth_digest_provider: file + auth_digest_algorithm: MD5 + auth_user_file: '/etc/httpd/htdigest' + auth_require: 'valid-user' + require: + - local + user: service.typo3 + mode: '2775' + php_admin_value: + post_max_size: 500M + max_input_vars: 1500 + memory_limit: 256M + always_populate_raw_post_data: -1 -- 2.39.5