di_apt_repository_stage: testing di_mtinfo_url: tst.mtinfo3000.com haproxy_ha_ip: localhost frontend_host: tst01 frontend_ip: 10.50.3.6 backend_host: tst02 backend_ip: 10.50.3.7 di_redis_uris: - host: tstdb01 port: 6000 - host: tstdb02 port: 6000 - host: tstdb03 port: 6000 di_redis_frontend: host: tstdb01 port: 6002 di_cp3000_interface_tcp_listen: ":4001" di_nbiot_interface_http_listen: ":8081" di_lora_interface_kpn_asid: tst.mtinfo3000.com di_lora_interface_kpn_askey: dd36f145445f7a92a3c02d1b88d94722 di_lora_interface_proximus_username: "tc-tst@dualinventive.com" di_lora_interface_proximus_password: "rs97LMESNFD5NyM363XL" di_lora_interface_proximus_token: ccd16aa340822bd24149a251e5fe80e6521d4dba8280791875a0315fdc5b0300 di_lora_interface_ttn_app_id: "di_testing" di_lora_interface_ttn_access_key: "ttn-account-v2.ofFiXTLmUXZUlCKybAqC7S6pWFEtsfas8w5UeaRI9bw" mti_default_host: tstdb01 mti_default_password: jmkvE7Km6tQ3WIgH48sL mti_default_username: mtinfo mti_mtinfo_name: mtinfo mti_logging_name: logging di_logging_mysql_host: tstdb01 di_logging_mysql_user: logging di_logging_mysql_password: 0X5UX72Bn0BgHTLFUYTk di_logging_mysql_database: logging di_mysql_proxy_db_host: tstdb01 di_mysql_proxy_db_user: mtinfo_ro di_mysql_proxy_db_password: 2Lcle0k79gyqoT6kZSge di_mysql_proxy_db_name: mtinfo di_device_api_db_host: "{{ mti_default_host }}" di_device_api_db_user: "{{ di_mysql_proxy_db_user }}" di_device_api_db_password: "{{ di_mysql_proxy_db_password }}" di_device_api_db_name: "{{ mti_mtinfo_name }}" di_influxdb_logger_influxdb_username: testing di_influxdb_logger_influxdb_password: BFVJQHuBjknFIh7xsdo4 di_influxdb_logger_influxdb_database: testing di_backend_db_host: tstdb01 di_backend_db_user: backend di_backend_db_pass: 8kdBbJG3C1i6g3EnsemB di_backend_db_name: backend di_cp3000_interface_db_host: tstdb01 di_cp3000_interface_db_user: mtinfo_main di_cp3000_interface_db_password: NLdZU3b6USgstuGz di_cp3000_interface_db_name: mtinfo_main di_messaging_proxy_push_aws_application_apns: "arn:aws:sns:eu-central-1:498526085235:app/APNS_SANDBOX/APNS-tst" di_messaging_proxy_push_aws_application_fcm: "arn:aws:sns:eu-central-1:498526085235:app/GCM/FCM-tst" #TODO use WNS tst endpoint di_messaging_proxy_push_aws_application_wns: "arn:aws:sns:eu-central-1:498526085235:app/WNS/WNS" di_aws_profile: "tst" di_aws_access_key: "AKIAJQQR4TQBWG74R7XQ" di_aws_secret_key: "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" mtinfo_asset_manager_host: tstdb01 mtinfo_asset_manager_name: mtiam mtinfo_asset_manager_username: mtiam mtinfo_asset_manager_password: gJi7shMxhFxUMthTzxV6 di_web_mti_mtinfo_migrate_name: mtinfo di_web_mti_mtinfo_migrate_username: mtinfomigrate di_web_mti_mtinfo_migrate_password: Vw3isOciJe9EvslKRkWE di_web_am_mtinfo_asset_manager_migrate_name: mtiam di_web_am_mtinfo_asset_manager_migrate_username: mtinfo_ammigrate di_web_am_mtinfo_asset_manager_migrate_password: eS5itKJK0dhN4T69dAXd di_wss_server_endpoint: "http://tst01/mtiwss/request/submit" di_secure_server_frontend_uri: "tcp://*:12000" di_mysql_proxy_request_interface: "tcp://127.0.0.1:3232" di_zkl3000rc_secureserver_uri: "tcp://{{ ansible_default_ipv4.address }}:12002" di_zkl3000rc_projects_interface_uri: "tcp://{{ ansible_default_ipv4.address }}:11999" di_tws3000_secureserver_uri: "tcp://{{ ansible_default_ipv4.address }}:12001" di_tws3000_projects_interface_uri: "tcp://{{ ansible_default_ipv4.address }}:11999" di_crtm3000_secureserver_uri: "tcp://{{ ansible_default_ipv4.address }}:12003" di_crtm3000_projects_interface_uri: "tcp://{{ ansible_default_ipv4.address }}:11999" di_project_proxy_backend: "tcp://127.0.0.1:7001" di_web_secureserver_host: "{{ backend_host }}" di_web_messaging_host: "{{ backend_host }}" di_web_lorainterface_host: "{{ backend_host }}" di_web_environment_type: "tst" di_web_dvp_base_url: "https://api-a.dvp-portal.nl/v1/" di_web_dvp_password: "Account=Temp@DI2019" di_secure_server_mysql_host: "{{ di_backend_db_host }}:3306" di_secure_server_mysql_username: "{{ di_backend_db_user }}" di_secure_server_mysql_password: "{{ di_backend_db_pass }}" di_secure_server_mysql_database: "{{ di_backend_db_name }}" # api services di_api_service_database_username: mtinfo_api di_api_service_database_password: 5fcc52accc di_authentication_service_database_host: "{{ mti_default_host }}" di_authentication_service_database_user: "{{ di_api_service_database_username }}" di_authentication_service_database_password: "{{ di_api_service_database_password }}" di_authentication_service_redis_host: "devdb01" di_authentication_service_redis_port: "6003" di_authentication_service_redis_password: "" di_authentication_service_smtp_host: "localhost" di_authentication_service_smtp_port: 25 di_authentication_service_smtp_username: "" di_authentication_service_smtp_pass: "" di_authentication_service_smtp_sender: "authentication-service@mtinfo3000.com" di_users_service_database_host: "{{ mti_default_host }}" di_users_service_database_user: "{{ di_api_service_database_username }}" di_users_service_database_password: "{{ di_api_service_database_password }}" di_companies_service_database_host: "{{ mti_default_host }}" di_companies_service_database_user: "{{ di_api_service_database_username }}" di_companies_service_database_password: "{{ di_api_service_database_password }}" di_assets_service_database_host: "{{ mti_default_host }}" di_assets_service_database_user: "{{ di_api_service_database_username }}" di_assets_service_database_password: "{{ di_api_service_database_password }}" di_timesheet_api_db_host: "{{ mti_default_host }}" di_timesheet_api_db_user: "timesheet" di_timesheet_api_db_password: "VORMztIDWCuj30rZkDBh" di_timesheet_api_db_name: "timesheet" di_railinsightbe_elastic_url: "http://tstdb01:9200" di_railinsightbe_influxdb_url: "http://mon01:8086" di_railinsightbe_influxdb_dbname: "testing" di_railinsightbe_influxdb_username: "testing" di_railinsightbe_influxdb_password: "BFVJQHuBjknFIh7xsdo4" di_railinsightbe_auth_url: "localhost:8061" di_railinsightbe_kapacitor_endpoint: "http://mon01:8082/kapacitor/v1/tasks" di_railinsightbe_kapacitor_template_endpoint: "http://mon01:8082/kapacitor/v1/templates" mysql_databases: - name: '{{ di_logging_mysql_database }}' state: present - name: '{{ mti_mtinfo_name }}' state: present - name: '{{ mtinfo_asset_manager_name }}' state: present - name: "{{ di_backend_db_name }}" state: present - name: '{{ di_cp3000_interface_db_name }}' state: present - name: '{{ di_timesheet_api_db_name }}' state: present mysql_users: - username: "{{ di_cp3000_interface_db_user }}" password: "{{ di_cp3000_interface_db_password }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ backend_ip }}" priv: - "{{ di_cp3000_interface_db_name }}.*:ALL" - username: "{{ di_backend_db_user }}" password: "{{ di_backend_db_pass }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ backend_ip }}" priv: - "{{ di_backend_db_name }}.*:ALL" - username: "{{ di_logging_mysql_user }}" password: "{{ di_logging_mysql_password }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ backend_ip }}" priv: - "{{ di_logging_mysql_database }}.*:ALL" - username: "{{ mti_default_username }}" password: "{{ mti_default_password }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ frontend_ip }}" priv: - "{{ mti_mtinfo_name }}.*:ALL" - "{{ di_logging_mysql_database }}.*:SELECT" - username: "{{ di_api_service_database_username }}" password: "{{ di_api_service_database_password }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ backend_ip }}" priv: - "{{ mti_mtinfo_name }}.*:ALL" - username: "{{ di_timesheet_api_db_user }}" password: "{{ di_timesheet_api_db_password }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ backend_ip }}" priv: - "{{ di_timesheet_api_db_name }}.*:ALL" - username: "{{ di_mysql_proxy_db_user }}" password: "{{ di_mysql_proxy_db_password }}" hosts: - "{{ backend_ip }}" - 10.51.3.9 # mon01 - "%" priv: - "{{ mti_mtinfo_name }}.*:SELECT" - "{{ mtinfo_asset_manager_name }}.*:SELECT" - "{{ di_logging_mysql_database }}.*:SELECT" - username: "{{ di_web_mti_mtinfo_migrate_username }}" password: "{{ di_web_mti_mtinfo_migrate_password }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ frontend_ip }}" priv: - "{{ mti_mtinfo_name }}.*:ALL" - "{{ mtinfo_asset_manager_name }}.*:SELECT" - "*.*:SUPER" - username: "{{ mtinfo_asset_manager_username }}" password: "{{ mtinfo_asset_manager_password }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ frontend_ip }}" priv: - "{{ mtinfo_asset_manager_name }}.*:ALL" - "{{ mti_mtinfo_name }}.*:SELECT,UPDATE,INSERT,DELETE" - username: "{{ di_web_am_mtinfo_asset_manager_migrate_username }}" password: "{{ di_web_am_mtinfo_asset_manager_migrate_password }}" hosts: - "127.0.0.1" - "::1" - "localhost" - "{{ frontend_ip }}" priv: - "{{ mtinfo_asset_manager_name }}.*:ALL" - "*.*:SUPER" redis_servers: "{{ groups['dtap-tstdb'] | map('extract', hostvars, ['ansible_eth0', 'ipv4', 'address']) | list }}" di_authentication_service_jwt_private_key_content: | -----BEGIN RSA PRIVATE KEY----- MIIJJwIBAAKCAgEAuKgZNdjLt/tAZyZwsvE2bOwvC36vbBCYCF93qVjQ5suOkLYZ ttDzzN1aAwyp52WA7ils0NR+81BzmfYhnwSECSQTYsdelMABV92q/gYaFnLLV66W RApdXiLNsjk/fDhx0Gd2yDz6XMm7k37+x1HjHrIhuMAMs7HJ5zm5eZwG/tr4v7wq egLK1JXb7C5cwuYOfdX4nxGZPU9WO/tfrdB1jFSBg0OfIhB4zPmM4/128FkwLiRn rzfNF1smuIoYl+9FMmcCBQBAnEUO5ym/m0zfGCmXmGis0QgKkHzku+gXclQNBHir F3JsVIPpVTSERL+L6XrCyXKTADAhJAK625BWY6nlvCSmE8e1bltbr6cQtCuzGtHE T3mcGwinkIMSbIPiFj5Z7v2YIDfOV83VEkoP84BYGcn0/loKBIsvTAcvh+/E1fRV ge8tBRU1lQp4lZt7ym7+G87TwGXMxXUvmoEMJNjsIUspIxZYsIDN3JqZRgixBkWr zivU/tNfHKNMgFSB6oQiX70KgCmPEBYXJMFQLf/oDrGaqi2kIMhSCsV2jHgc9FMk gtocSbxdHdk9oig1A+RP6NdeNz5e99Zxu31+PUhuPu5V5QivihcrMYtiT/KZ3SHU kXXJtHZta3EUr/WPk4s0gub0rVgfOCgEjVahrmOOrY5dGL5OVe9FxFZ2vPsCAwEA AQKCAgBOOwE7O9bK4kodqT5zwRdyu/kOYKSHHtyaJ3/1oegW70Q98LgiKJIxR9Hb muDcZLdjru8n5e7GvF3Na2ZBDVO2367K2XYrhNDM3d+UcRdaTVXylseYmd+Ggy4s BG7t/KfTSBIdsR/McbbjPRlJblrPZV49/DclZfwI1v7KE50vGavq5xgDyu0NdVPP 0rB/7aFUFHOZSIZoYBVDojKd28QBKMgZyWtArkPPayYSbQ6XsuFjmw7GP9jGvVpB MlhK/haNzPAhGENHMUaoDprbe4zEmtJbwnT8tfBr2E27gg9040EElO6/Jz3X7G7N J0umKJRo3RZq6/x1Ru6zZ+isHpFKPUbPqqXUNtBAHZqzluRoWqqPxfZMUsDebHK2 Sf0a196GoE6QB2aXKi6SsgTAR+3qlM1QE0T1oAd1a1xzDUy9ko+E+UKPJA0zwKyU o1ZR3Wy1oWtUS+XcuXSlfdPuRgc/qBurT6AKTLw2piKp9WGcy7JLJefH5MUWoyF5 HXhePchJ/eDtSJUEv9/ACvbG3wHzBWQ1JX8yeoIfs9a+UQKzhCrbzIKz4L0dOaqE DzPakXTvK7dNOayn7okPNfDPHZLnsngdEXHkpHuQx8xb/obcJJNuazK2YuU3TuJm c+Fpw83lPyJytc30WsazMnAqMHl0mvzi/N6HNw355Y0XZ26KuQKCAQEA6NcoGxnx YCb4KPLGK5SoDdh0NPzcNET8GoueH9v1jQqCkVA3JqkHf3l4KlZBuzAu0/mlJZjj bKiavBH9C9pvtn6PeOtbNx+OJyvmlTiKTKeHOY+QcWZsw2raeac6tnx62uO0NhfB 7ENL8uulu9wjI/dbOSGhk8V8SNo+TAw13i48xvOAZb6+bUIQjd+hOlR0RTheaKuw C3fGjlfokrp1GRTL1YrFxPKK18Xbms33bcXWwFmuONDFL77KE6DHbxDgMa/V02ZA hOhzWKMSPoaGcvk3iuyuiGYYj2FLIeZGu9rm7PPOQHnn2a76eNEi5V7Wjf48YNGF mbIjHeVl5qSIrwKCAQEAywYIGPMpovCVjAz5qI2Zs7PGNJI/MchMMtXpjFAd8WrN FStsmk4f1xVdnlsHNZxyUhqRcNF9Mls7S2nsx3+EpEsCdQneqpZ/YszFCgTnV5VE 8z11XQUYaOZsJ1yh5phaNyrxXMU9TxbA++Mw2U2GDebsK3JXe0G4OCT1EbnfIyCz uKzWfn0G1UFfSXTSGE4gZLurgvQMZsjkSmwAi+wFwKb+3fdD4Oce2/aNcAOlCVh/ ev8eKniE64PdoLzviO+1KpZmI+93dhC1xYmuscjexlwj9yxSqWvQKXRIvyc0PnBa Ea8LtJuq9eU36UabRrHMeuNJRAdT/PrTh/JRBpdLdQKCAQAIhQbkpvhcClD+PpPd uFzF1Ou7nJz6FKQc3Ir2o3fCp2XLp2G9OmYZ1fn9opZZIRQ1kWbnj0aTDUBMLWRS 8LUxukPJquL1i2QKLuMLBryYvXCHPKeOXq8QH3LLDMFrN/bO15IagJgJ6xR2WQUB cLagdEaUOpTM8Wbwy3uIENJPxOVYakSCdI5HNSmh51Lg7YIrnjpmHhIc+U78ml7a L5RlTIuAzskZwb4u0wCME4lALQMEmsNzNMBiVNrUCQgDGlz5tHNgftdRhafi0GS0 gPuebVwI60wflYzEgkzbeq+P5BybAvjDBzLiljJ4BT7/oY68N1dCO6hlzUzXpTMr U03lAoIBACq4JDALynEMqosDl+zNjs/vPf+F3mI9QTtZI4FwwjwwOuL/diSp161M Q5y0jrnLJ4r7KCtTCUL1S2685SO9Q03Gssepwf6nGDrT14oaKguVzyJXhkCCd/Zq tcs6hJ6e5CzDjnH01sezg/v8fCTdWR3Hv14M+zdmRrsZm6+VKsybbvWm+KM4750j 2kb8m9Cdb9eCXb56V7mw/8hhHWRTz4oQGYTfKJtERowGPxCY07s5selRkSlinqVn 49SUrNplhftmFivtkXd4YKcmJ2olWCro7HBwFRytIOn4G+6M80NIJMufx5jDQJ/p EXC2eKnRc7NP6/SyjgunQ6dRZ5c5cpkCggEAdPKXSRJrznrd0BABsSngA8LMRJBH 4B6wyVrUXWJk2RqENCDSQRZATdgZVIBaIxkyQtlPromQZ6WvVKy775Bb8USf//0a QqL1612fxg5EZCqJMdrHfWaPE5akKGpsoyOSqra5W9EhFChVpArJH6zoxgHEpwMW 8xY8JgMA9k/65N1eR+OzOONOTS/HVDkYduAp+S37+KK7LwWd7lcsjnscte5Pj9hp 3TBGRjlGFnKSs4sXyiqAgYYiSD89iZTimGXo00LiyQuDx1HUBFWh933w4wte6frs FWg5ZPAhminfDgcV+JLAXOdN0IoS773jol1z8WUyOZ1OVrV09I9wZDfVXg== -----END RSA PRIVATE KEY----- di_authentication_service_jwt_public_key_content: | -----BEGIN PUBLIC KEY----- MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAuKgZNdjLt/tAZyZwsvE2 bOwvC36vbBCYCF93qVjQ5suOkLYZttDzzN1aAwyp52WA7ils0NR+81BzmfYhnwSE CSQTYsdelMABV92q/gYaFnLLV66WRApdXiLNsjk/fDhx0Gd2yDz6XMm7k37+x1Hj HrIhuMAMs7HJ5zm5eZwG/tr4v7wqegLK1JXb7C5cwuYOfdX4nxGZPU9WO/tfrdB1 jFSBg0OfIhB4zPmM4/128FkwLiRnrzfNF1smuIoYl+9FMmcCBQBAnEUO5ym/m0zf GCmXmGis0QgKkHzku+gXclQNBHirF3JsVIPpVTSERL+L6XrCyXKTADAhJAK625BW Y6nlvCSmE8e1bltbr6cQtCuzGtHET3mcGwinkIMSbIPiFj5Z7v2YIDfOV83VEkoP 84BYGcn0/loKBIsvTAcvh+/E1fRVge8tBRU1lQp4lZt7ym7+G87TwGXMxXUvmoEM JNjsIUspIxZYsIDN3JqZRgixBkWrzivU/tNfHKNMgFSB6oQiX70KgCmPEBYXJMFQ Lf/oDrGaqi2kIMhSCsV2jHgc9FMkgtocSbxdHdk9oig1A+RP6NdeNz5e99Zxu31+ PUhuPu5V5QivihcrMYtiT/KZ3SHUkXXJtHZta3EUr/WPk4s0gub0rVgfOCgEjVah rmOOrY5dGL5OVe9FxFZ2vPsCAwEAAQ== -----END PUBLIC KEY-----