di_apt_repository_stage: acceptation di_mtinfo_url: acc.mtinfo3000.com haproxy_ha_ip: localhost frontend_host: acc01 frontend_ip: 10.50.3.11 backend_host: acc02 backend_ip: 10.50.3.12 di_redis_uris: - host: accdb01 port: 6000 - host: accdb02 port: 6000 - host: accdb03 port: 6000 di_redis_frontend: host: accdb01 port: 6002 di_cp3000_interface_tcp_listen: ":4001" di_nbiot_interface_http_listen: ":8081" di_lora_interface_kpn_asid: acc.mtinfo3000.com di_lora_interface_kpn_askey: a4b702ed5159e93138f7bd91d8c52a85 di_lora_interface_proximus_username: "tc-acc@dualinventive.com" di_lora_interface_proximus_password: "BMZGm6A0KjBIt48HURj2" di_lora_interface_proximus_token: nrc1pbb1t9s6l9x2hhblv6ntuc3fl1qi4njphwhhb0edpuve74ozjwtihsq3jsf1 di_lora_interface_ttn_app_id: "di_acceptation" di_lora_interface_ttn_access_key: "ttn-account-v2.PZf4ZfnIT5_vvW37lb7iVcWdaA7foroVOkOB2OyvqiU" mti_default_host: accdb01 mti_default_password: pRSEMIPRj6lkwcKOr9Lf mti_default_username: mtinfo mti_mtinfo_name: mtinfo mti_logging_name: logging di_logging_mysql_host: accdb01 di_logging_mysql_user: logging di_logging_mysql_password: Iu72UNirw6KqnkIoXJ7W di_logging_mysql_database: logging di_mysql_proxy_db_host: accdb01 di_mysql_proxy_db_user: mtinfo_ro di_mysql_proxy_db_password: yqoT6kZSge2Lcle0k79g 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: acceptation di_influxdb_logger_influxdb_password: dICJJezj9o9Q7lqAD4e8 di_influxdb_logger_influxdb_database: acceptation di_backend_db_host: accdb01 di_backend_db_user: backend di_backend_db_pass: 349TyfrhGFuihf4E9 di_backend_db_name: backend di_cp3000_interface_db_host: accdb01:3306 di_cp3000_interface_db_user: mtinfo_main di_cp3000_interface_db_password: 4ybY5MUGj9PNn8G2 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-acc" di_messaging_proxy_push_aws_application_fcm: "arn:aws:sns:eu-central-1:498526085235:app/GCM/FCM-acc" #TODO use WNS acc endpoint di_messaging_proxy_push_aws_application_wns: "arn:aws:sns:eu-central-1:498526085235:app/WNS/WNS" di_aws_profile: "acc" di_aws_access_key: "AKIAIRYQSUWY3I5PDKUQ" di_aws_secret_key: "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" mtinfo_asset_manager_host: accdb01 mtinfo_asset_manager_name: mtiam mtinfo_asset_manager_username: mtiam mtinfo_asset_manager_password: Iu7s458Rj6lkwIoX4545 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://acc01/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: "acc" 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: 08857bd670 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: "wftd261blIju2nm74aDP" di_timesheet_api_db_name: "timesheet" di_railinsightbe_elastic_url: "http://accdb01:9200" di_railinsightbe_influxdb_url: "http://mon01:8086" di_railinsightbe_influxdb_dbname: "acceptation" di_railinsightbe_influxdb_username: "acceptation" di_railinsightbe_influxdb_password: "dICJJezj9o9Q7lqAD4e8" 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-accdb'] | map('extract', hostvars, ['ansible_eth0', 'ipv4', 'address']) | list }}" di_authentication_service_jwt_private_key_content: | -----BEGIN RSA PRIVATE KEY----- MIIJKAIBAAKCAgEAr3gOxz0lmHBWntWK4xFPi9WthUMRr1vBA3X2+47Yg7z3vaSe wlMelmKfunHhVe0cRLZvnrFZXTzC1LxERMIy+rv4H4/J19bsCz0LwWn51VTHYimS 13c9QQDL7c+C/gau+CCSnclIQqwW2xMz3VBIC6XlIl09nhEnlb8Xe5V20jg5rHDJ FiAAV2JVgb3PlSz0kJ5cjWrqgED67Hy+RulEcLu4enr0fnLV+zUO1oUI3GFQFGQq o5RaVlBSr1xC5tJGt3I2WSr5YIIYr+C1fZXxV+alx8lSJpkdqXeWFZCs0R8zs2GV DDiM81XUa7SJ3xXnRHLs1giICCIv/W0y4i1hBdzwaipahP884Nxj1pvLlFfSO0Q8 T83f+Mu6zIfZ2/0VTxNaCbEYNAncC670qGdM29YbLqPbN3dEQY1DC3jp3hpeeF7n 3MTLXSLEqxxR9G16ZMtyD99CdgDKb8j/OMBaA/27nL5WlwDg1K+Vut5+R8JBsEny ykJ8gxHdYQUFqJ5nIH8bfxKioycT01+7GnsZmJKw6p6Zy7RFo4NXu0XfxjzfiFZW 5n9MZ330h5VRxNaMhkwdEnoxY6lWz67WBCBdbltmW5yc0y22FJ+y50vQwr/a2vc0 DsbLrfC+8UXNEKuWIVj2/bgifEgg0SkhaT4bC0CaSyxmwt0wEUnVAMrsQzkCAwEA AQKCAgAues7vV/MtfhRz3nz7yQoZMHDWa/2zRcrK7+SMnjocK2I0ifbD4uCnVVia OrBF4pkqWmkW0EOrvvyc/YHX9NksMb54Hc6JrhS4pWMHyNq099AY4IpVKPDA10Ut qVo5j+upLnen9Dl/77XeMif659ktvLQFdk1sIX8q24OM6PqglOQyGW4qvi9Y9mNQ CseB7HacGFbL3xZfAtd07VY50nCerBsh1pANLr4f3N4hVPwT5HMh86aXziRf2McO TJIsMmcpEMf0tr14Iv4HGK76pU1Yy2/+jAWG0+hXi6Xl8HzWqD05tw+UPSaZDpNG NHyQ62xnZUn3KCtgfC3aI6Lm5r5cLrhdCU82RzUMCBW2J1XAaZvzX9rFAUq3AggF kUCorclF7rG5OITE+S+q9N7NHIywPypn42Z/cnEGE4cSKYb65fUalDQNSD6t2qL0 mJ4tHbxdAjwIytsPPdOSLABcO6DsbIV16VkSrMuwa7pjyX7J4xYEuJzzsvSnycgo ZGmudmtJ34DRkOMQZcbtmgtuYM3wNXFJvEzIYIEH9Dg0j8gTqD7S7aPkh/IdEO2A 4OKrtk8Tc1Y+ZvnoxQU/S272vuLvFuM3jHXxTDINIc4bwIF+/O2zamt4WPY5zBb0 q9JGmyH1tEmbIhgtc2apH29KB1TK+XnZfITk8SM2ToD35fJSQQKCAQEA4bk/SZfF kEIVv9XQfUmC6YEct5g2AyxJBePF6u6kCZqubLvR6X5EaN5FBizTd0dCvbBDi2LC Ag7f3uvEJeXoETLpbsB5YM+X5P71se5bE3phIDjM3sECvGy3jHJKaAlIqbf43ObR eAGXKjqC7tQ/ZZ5SGbsWMlq0t4uoUQytEbPbfidcFZf4JnDsjpzlEm8rYIyRwnFs Y1zja4oXzVeYwVQ1JTSzwF9px5tb85rMVCPcjrNmRLcFgqUxFrCe2vYTjuIr13J6 bSt1FSqfcByEZPBjdQgtSJDcHC4sChilQKcRpXfV9O5g2bJ3sHhlLMwG/Rdv9I33 MVIHlWZE2mwy1wKCAQEAxwEy4Bu0fELx2UjrB3IlQnwbEnLz3N+vlbi2fa6rlkCH wli7wffhB8t1bWoh7JL55NMaFLgfNMnmr8x1j4S4vECMrWbV4NuXkQyA3X07gX+8 5/bMdMUEelsf0pLxtRVkEPpnBkJK/ikhzlb6iIS0GhpnpXUaduF4ffKajXunUNzK oA8Ewyq8zczZlvFBQvgJk80PR+NoUmwL/WAH3ZDbXnyIGH6oEloo2GeJU1Qo+0oV DySD50H7EfW+b9NBNAl6gbAYapmCe5ikcGmk10L/YZI362tPJFsad5eaA671Av3p 254Sl0TdrdbsnGZXBcPGeMN2I9DAfjWzFnpv3QCIbwKCAQA82HSo39KPmmDGf1pe C2zQiM825j7ZCBz/C3EUbROmyx1tjgt9h13lbtToXzj5lCn3fAYZEpv9dgj+zErp dFnkGPc3tYaChDMLtXaBaiD+1SRNTUJcYWbdZ+jqYPyRor8FkOPyl/2q/bLD3VXi DzCvscery/SlyjGgsHLEtkgI15S5It79qyNnKVV68+wD1he5ROsdoPl4p1dea7ES 1yQEKTDSQKyblJytA8H7nqSpoakYhl9w8mz31JOw7BdGKsMG5wyuXNuHhglflUe5 Lta5ZttIdtXOE85hgki4x//zt5VYJz9zcLaGuEbvOOT8+FqB6slxALu7fcMxkInK 3xOtAoIBAQCwLduAlIaAzDOYjfmlKeTaq0y8VJCYpl+oSVMmiZDXAGIwKKZw3qaW ZAWdzCwkaSpa7plUZn0aGvTkBjq9yF5UK0Ff8n6/Bylz/IHJlKktyIzRP6laZ2HD gRD3N6hNDJb+gPDclawWvwtyxYYffnyD74R68uVvAcXOmw1A3IwQBqhMc39f2WI1 QHoSK5v/UeAIva4dkrI05frnYjEUcr4DNHS4WskpFjC7BU6KOyPc9IUYVtd/0OYZ zFnAXmKHUyzly6SSGz1tdoF+E8kf2eyF0RE4llQGd7FC1zA+upGnCGwVRihnS0yG LpRjEidQrzXyi/j3VERWd+wIpnSKT4J5AoIBACy3p/eoFK4N/rh6TsbuR3bsCR53 A/UXFO3xg66il3MvfN42x1urwGmUsO/7TADlJrU7XLWBYRkioPyVobU2riVb3Dap tqmG1KZ501P9yYh4x+A8mOIETy9wciQLQXrCjUM/a2+4ipl96ofk8XxOmhfeRIFF oSs/XtNn3dqOBgYLvn7UvhMUtNaN5Y8e4kJnb/vtIyA6rrZfmJ2YWX+zjYV9l69y 6GPYPA5x4AgxgXn9ydV/5N5UKEIyuM1Zl+uCKb5mZkSJ7e5Vl9nm3ZHmz+DKNThX +2cs4HspzKTFrCOlqxGkPZAhjnpdvLZRPdsommf4zYMx+RMWitTIeVslR2c= -----END RSA PRIVATE KEY----- di_authentication_service_jwt_public_key_content: | -----BEGIN PUBLIC KEY----- MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAr3gOxz0lmHBWntWK4xFP i9WthUMRr1vBA3X2+47Yg7z3vaSewlMelmKfunHhVe0cRLZvnrFZXTzC1LxERMIy +rv4H4/J19bsCz0LwWn51VTHYimS13c9QQDL7c+C/gau+CCSnclIQqwW2xMz3VBI C6XlIl09nhEnlb8Xe5V20jg5rHDJFiAAV2JVgb3PlSz0kJ5cjWrqgED67Hy+RulE cLu4enr0fnLV+zUO1oUI3GFQFGQqo5RaVlBSr1xC5tJGt3I2WSr5YIIYr+C1fZXx V+alx8lSJpkdqXeWFZCs0R8zs2GVDDiM81XUa7SJ3xXnRHLs1giICCIv/W0y4i1h BdzwaipahP884Nxj1pvLlFfSO0Q8T83f+Mu6zIfZ2/0VTxNaCbEYNAncC670qGdM 29YbLqPbN3dEQY1DC3jp3hpeeF7n3MTLXSLEqxxR9G16ZMtyD99CdgDKb8j/OMBa A/27nL5WlwDg1K+Vut5+R8JBsEnyykJ8gxHdYQUFqJ5nIH8bfxKioycT01+7GnsZ mJKw6p6Zy7RFo4NXu0XfxjzfiFZW5n9MZ330h5VRxNaMhkwdEnoxY6lWz67WBCBd bltmW5yc0y22FJ+y50vQwr/a2vc0DsbLrfC+8UXNEKuWIVj2/bgifEgg0SkhaT4b C0CaSyxmwt0wEUnVAMrsQzkCAwEAAQ== -----END PUBLIC KEY-----