From 299162eb2d32880c6ebc7efc0a2e65657e2d9881 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Oliver=20B=C3=B6ttcher?= Date: Wed, 7 Feb 2018 11:23:56 +0100 Subject: [PATCH] ODT INT - db --- ...-tmp-db-odt-daimler-com.pixelpark.net.yaml | 64 +++++++++++++++++++ 1 file changed, 64 insertions(+) diff --git a/customer/mbvd-odt/int-tmp-db-odt-daimler-com.pixelpark.net.yaml b/customer/mbvd-odt/int-tmp-db-odt-daimler-com.pixelpark.net.yaml index 3b0442d3..b2caeacf 100644 --- a/customer/mbvd-odt/int-tmp-db-odt-daimler-com.pixelpark.net.yaml +++ b/customer/mbvd-odt/int-tmp-db-odt-daimler-com.pixelpark.net.yaml @@ -1,2 +1,66 @@ --- infra::role: base +infra::additional_classes: + - infra::profile::pg_server +# - infra::profile::mongodb_server +# - mongodb::globals + + +infra::profile::pg_server::install_contrib: true +postgresql::server::locale: 'de_DE.UTF-8' +postgresql::server::ipv4acls: + - 'host openemm openemm 217.66.51.0/24 md5' + - 'host openemm openemm 217.66.50.0/24 md5' + - 'host openemm_cms openemm 217.66.51.0/24 md5' + - 'host openemm_cms openemm 127.0.0.1/8 md5' + - 'host openemm_cms openemm 93.188.107.233/32 md5' + - 'host openemm retailmig 217.66.50.0/24 md5' + - 'host openemm openemm 93.188.107.218/32 md5' + - 'host openemm openemm 217.66.55.69/32 md5' + - 'host openemm openemm 77.74.234.109/32 md5' + +infra::profile::pg_server::pgpw: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAQgpDTDusJsmMYdACOwKPfEhZbLU+Tynjnm7fBDH+KTS9cPCoCQ4E9TZgHEwy3wNv+nMbUsoSZY/xFHoF/JgPlV0cZLtsJ2WLJZC5SLIoL0JEvOlUIMgbSnxwKJ72zKUf6qJnuCDz0rJ7LavwQvf3D/lmBo2rXP5wuQfyxeSr0aO7JsO7f58VUMRigLZ/JvOAmvMycbtVaSd3n+TYoKCRlomzdFeZkC6DTVMWIiuVuhRG05XL5rkSdO+EUMi0ohZ2LKKBqJHL5tATDK9QRSllKSoix5Y3jhye1LFHDZJm1w2BRX7n107v1sjsI9lax5gDsiMIfbsNv0aBGxMUcht7uzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBFb2Q2Qy9+9O4bZAQTb1OzgCDAwTXbSFnPfdRaWlI3R734TM0APzt2EvIExutplW942Q==] +infra::profile::pg_server::dbs: + openemm: + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEADPSXLVuM9nmMpbRt/etFFeeLfDPUq1fzPiytEDkr/A6rrROWorN+sAKcjWkkfX0ho7iu3k6AZ9ZBJtniypjPIs67Y95VGH3bn/eqPwb25NyxDDKv7XnRe37+m7G6tXj87pGMeDKyYwjkUdhXkCV1JkQ/Xz4RdY3ZSJxIxIuUxViyuV7DkqKfXg8EFkyY90JqgevyXg0dIsGZPwqyxiOHORyITggEJPxQHMHHcl8kgnAPjAXaSZfHwcyIP77Xry2a/6T3jJ303OvSyP6DBxsLdo/mdswo2yVU2cjNKH5h8uRpHl6+LfrCzl4+B6ascnez4SQYn0HZEpG+sUsDHbWvTDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDVXVAkvpjUk2nEDb3zzhhfgCAO4KYsx3netoqYJF1rntp/3FBPA2VYYoIClaBfWO3Spg==] + network: 93.188.107.233/32 + opencms: + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAopzonTmN8Z6furB9Llot9Xa7dGzwicFZkAQUsdWMgi4x0nagchN8beQch+EkZovU1CcIGPtS4erYgrX/KRQIDgMQH2WzMVd15AU1C3qziwJLxWpONvKswoKPcQmhFIFbMYLc3/WoSehtgB4TtSrsA2gNsZbgLHL3qdbjBvSxcMAPQYONXUo76hQRUTI/KPp3kqolrw3uRLPdhtTQQSDLRq7vsY4znCB8ZSdImCINfi2dN0Qqd7OM3NOSXW2qH72C31PXR2Hv3PeAuzCBzfWYzFPzHaChHM1+vQblnZPOf71yjTPDgkFA1jjBORbgEboy53oRA+PZS4d4qHj6FU3kDTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCvqVqsimbzgkRQFMq4OcvegCCvFhmDxWNr4hxzSkYOoGWtvuoYOc7zriuV97QGhHN0QQ==] + network: 93.188.107.232/32 + +infra::profile::pg_server::configs: + shared_buffers: + value: '4096MB' + max_connections: + value: '200' + work_mem: + value: '16MB' + dynamic_shared_memory_type: + value: 'mmap' + shared_preload_libraries: + value: 'pg_stat_statements' + +infra::profile::pg_server::backup::weeks_to_keep: 0 +infra::profile::pg_server::backup::days_to_keep: 2 +infra::profile::pg_server::backup::enable_plain_backups: false + +mongodb::globals::manage_package_repo: true +mongodb::globals::bind_ip: 0.0.0.0 +mongodb::globals::repo_location: 'https://repo.pixelpark.com/Linux/yum/mongodb/7/mongodb-org-3.4/' +mongodb::server::auth: true +mongodb::server::store_creds: true +mongodb::server::admin_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEApFHBPhrgFFa/jrl/7TpNZQ1eeEFaO7OEiHtndCpgiKP7hBjMooQrJUK/LgSv09MQ4mHwgIH8xo6/1sc9pykhe4EKmD59G4lbPWpmLOLdj6lQG9IGDoyNXxVjHAYCLUDbAX63O6YNShPdfQghfVrk0m0kaoVFSdbYs8Xq9O0Qylg/LP847fZFOGWab79N2/QHWY+DOWxpjl5ZmWLBFF6R5MFKoxcoNvAhYOf1XgBj93nK3sCxqGlvVt5ctwMj/RbxUKtfoyBroeWE1qOryWbv4jlKpZWfBmDBnhbwhkbzGWdP3vGIWmsXqkGV0ICUNMfn1TfOmz2WfL3MbmSH5BJvZDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC2tVEcFTVCocnq0QyUZd1mgCCDA+MILv46tBd6vh//saT2HSnVK7WqaBAcFDcvAV1iTw==] + +infra::profile::mongodb_server::databases: + handraising: + user: handraising-mongo + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAVilK6i4a6G1yZd8PinDrhgHzrn3VBN62907pwfPIKUZY6SdOdkbNZe2HyNNKckANSEzfSHtOCviOkuWlnJiiQULU9JqAb2Cz1QMo1qnFsxnE9IhGklNTcDvw7uhpUvXc7u9giJgViRqJLxgvuwdvr7YnI5wEW+Wgm6dvruTzaH7jh7tVOXuD01yxe/9ER6zcFZK0vfOU87Q9ecqaLXVIl5uajh0HhnT8sNBu2jpACIZorZPTxXfppyp4Fv6Lru1zY6Izc44mAG6sZgI/j++jFgpqmVF0mm1b4imTtGc7iLssPWdARMe9f1rLUqGYutWYwdC5APsS8fkgaVulFJciOzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBAlbBAooxS7OkTe/p9IIzMngCDz1WbEoig3vKQHMWY8LHQ1R25nMlgvhFl4DLzeBf+U7A==] + roles: + - dbOwner + teileNewsStats: + user: teilenews + password: ENC[PKCS7,MIIBeQYJKoZIhvcNAQcDoIIBajCCAWYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAwQKGhN6gw28uqXP3yP4vu/5A//8TJBuUWQHHg/euJkU/LY2NzN532zHUBad9VvIo7IA/MKmj2zB9hV+tDae8rrhmKZmxKBCLKxTO/eYgFGvpFLonEv2zwWD5h6yhiWGRyAiA6v0vwB+hzg0PNehUuEsZap7nSaBMUAcQQhxAwvqzFthhZFUkKM3enPjP/gYFgTegajmJskZ8/qF41pNNVgRMecH9yoISzGbfj88D+mRVuqYni+WRaCet9Z2Prly3cu93fNdKQxjQQ0gijhDT3sSOCqS0N1nOerAgNvWlK2odIr/YystxWuBAoGXTfv8cOV6U5e5FcyBUY/iEXEengzA8BgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDEcCM1U7vbkTNs1Bu3+5SvgBALbKvN05Y22Y+JZmdw/yy2] + roles: + - dbOwner +infra::profile::mongodb_server::backup::db_username: 'backup' +infra::profile::mongodb_server::backup::db_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEANnUupXmoJupuOXb4NZYNVlebd63QUoq8Wgj9CY5N4/7V/fP2EWxvljpkzEEK52LR/1s/qMi1TDZnYa5mfQ9px5fLHelhZPepVGwq2Nw+EbAFnvkY3md+i4DfKrE/MNkvohfpDlYNv27n1XVB8SiWTGBFKNw4v7gvDZIzYIGBbbTSZyoHk9GMrUlb/cTasT5n+lqocZeseBbH4kAiJYhhGGGMXuORw0C76br2oVmxcF/QT7BtM7hSKitt1M9Z4jdYFB/P8aoXXB2BZlajeJ5kkFP6jBVZey2tbSdRiX5qA6m1AOKNGLfhw+8NylZd7qoDN9wk5b5Kogk5siEtkKa6nzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBAAC4K36vtkPpvtWzOdsHOTgCDPhkt3nuDYUFr5bhnPvALotq0A6coqWK8R3zfyJt3/DA==] -- 2.39.5