di_apt_repository_stage: development di_mtinfo_url: dev.mtinfo3000.com mysql_version: 10.3 haproxy_ha_ip: localhost frontend_host: dev01 frontend_ip: 10.50.3.1 backend_host: dev02 backend_ip: 10.50.3.2 di_redis_uris: - host: devdb01 port: 6000 - host: redis02 port: 6000 - host: redis03 port: 6000 di_redis_frontend: host: devdb01 port: 6002 di_cp3000_interface_tcp_listen: ":4001" di_nbiot_interface_http_listen: ":8081" di_lora_interface_kpn_asid: dev.mtinfo3000.com di_lora_interface_kpn_askey: ba3ba86fd49a9576d6e8110d5c927dd2 di_lora_interface_proximus_username: "tc-dev@dualinventive.com" di_lora_interface_proximus_password: "v0VPmy09OumKUEEfUXX1" di_lora_interface_proximus_token: gffu4msjrvdg7oho7n3bzuoc4ywahguw4rg353ky4drrgfhzsuao21nfxe0guyqx di_lora_interface_ttn_app_id: "di_development" di_lora_interface_ttn_access_key: "ttn-account-v2.9Oq7VHWK7tm0U0JKvyBSZw50qTSNwH55wcTkSBYH9SY" mti_default_host: devdb01 mti_default_password: pRSEMIPRj6lkwcKOr9Lf mti_default_username: mtinfo mti_mtinfo_name: mtinfo mti_logging_name: logging di_logging_mysql_host: "{{ mti_default_host }}" di_logging_mysql_user: logging di_logging_mysql_password: Iu72UNirw6KqnkIoXJ7W di_logging_mysql_database: logging di_mysql_proxy_db_host: "{{ mti_default_host }}" di_mysql_proxy_db_user: mtinfo_ro di_mysql_proxy_db_password: XOjJEb9GO6jyFPjc2gqK di_mysql_proxy_db_name: "{{ mti_mtinfo_name }}" 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: development di_influxdb_logger_influxdb_password: iPxJmzHzuNZVSkddVGH9 di_influxdb_logger_influxdb_database: development di_backend_db_host: "{{ mti_default_host }}" di_backend_db_user: backend di_backend_db_pass: 8kdBbJG3C1i6g3EnsemB di_backend_db_name: backend di_cp3000_interface_db_host: "{{ mti_default_host }}:3306" di_cp3000_interface_db_user: mtinfo_main di_cp3000_interface_db_password: fsdurWZNhsTCq95y 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-dev" di_messaging_proxy_push_aws_application_fcm: "arn:aws:sns:eu-central-1:498526085235:app/GCM/FCM-dev" #TODO use WNS dev endpoint di_messaging_proxy_push_aws_application_wns: "arn:aws:sns:eu-central-1:498526085235:app/WNS/WNS" di_aws_profile: "dev" di_aws_access_key: "AKIAIWAGTZT2V4MU24AA" di_aws_secret_key: "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" mtinfo_asset_manager_host: "{{ mti_default_host }}" mtinfo_asset_manager_name: mtiam mtinfo_asset_manager_username: mtiam mtinfo_asset_manager_password: pRSEMIPRj6lkwcKOr9Lf di_web_mti_mtinfo_migrate_name: mtinfo di_web_mti_mtinfo_migrate_username: mtinfomigrate di_web_mti_mtinfo_migrate_password: MigratePasswordSecret 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: AMm1gr4tePW di_wss_server_endpoint: "http://dev01/mtiwss/request/submit" di_smp_logif_bind: "tcp://*:6000" di_smp_reqrep_bind: "tcp://*:7000" di_smp_pub_bind: "tcp://*:5000" di_smp_sub_bind: "tcp://*:5001" di_secure_server_frontend_uri: "tcp://*:12000" 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_project_proxy_frontend: "tcp://*:6001" di_web_secureserver_host: "{{ backend_host }}" di_web_messaging_host: "{{ backend_host }}" di_web_lorainterface_host: "{{ backend_host }}" di_web_environment_type: "dev" 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: 45ee1f742b 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 }}" # TODO migrate with mtinfo database (mti_mtinfo_name)? di_timesheet_api_db_host: "{{ mti_default_host }}" di_timesheet_api_db_user: "timesheet" di_timesheet_api_db_password: "c46eRzrSYzRwpwPXZcB6" di_timesheet_api_db_name: "timesheet" # end api services di_railinsightbe_elastic_url: "http://devdb01:9200" di_railinsightbe_influxdb_url: "http://mon01:8086" di_railinsightbe_influxdb_dbname: "development" di_railinsightbe_influxdb_username: "development" di_railinsightbe_influxdb_password: "iPxJmzHzuNZVSkddVGH9" 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 }}" - "10.52.3.1" # dev05 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-devdb'] | map('extract', hostvars, ['ansible_eth0', 'ipv4', 'address']) | list }}" di_authentication_service_jwt_private_key_content: | -----BEGIN RSA PRIVATE KEY----- MIIJKQIBAAKCAgEA24Iw6VOS6EONb6SKzkCcijw48sVmTvKyoc6PkTIPJb4vyFrb jgqC0mVSs4fIRzzGpavIi76ZIp/fipvf38JVXKwAxHJXzWHi1lYmprxnuiAsiL/T EQKvHD4e/Nc73MoPinfxkiCFo6+9d8Wp7mmVsfaYLqX2Q8U+kEHOqCcsA7cnP+lu RqtwA6xiXnACW3GU8Kenw2u+5CwoUaBMBPfcWtpqPUisGQEhcKxrqnBCdqcdOBR8 9/YtUYluoiDiDZf8lhS/ssZqejOaRLDCAGRRn3gaHdZfRM0jWbNzhL9TNLe3gR6H FSvVGnnchi3kkj1sWfN++u1QGAv08rjyGzPyQUj3Q04T0t4FSeZrRIby7OePaWH3 2JXiAn9RlWczUee9aE34LW3Wl2bhxDg6QylwyIdg3GquC2DfqWB0DBSTPqsUOiBG we4MxxU6N+7n4CPJ3IrPN34MaOsggFXnL5RwycHoQ1LBbRsa+gi5NQ1E0uRTBGL9 Jy5yqoqwbVzO5YJLw24zYy6A9W6qz3LkCNDBJTWKLF2x+R2FwOuugP+0bAcTwM3K MEjX7it2JNVHQfjaANY7Dl6JoB6GTy+fvJSYeJnZLK/zByCnuoqMJJgurYitYauU ZqEcsQyCdSUf8WWYA/EfQfclY/7zGWh8rc5bB9dyIaIA861tvZ5f6PQGubcCAwEA AQKCAgAC4Ir5k/HZ/4CsFPEI0Qn8OdvZOsMjh8TVoBp7obdXHE4OBzrXesXKMi/K UJ5MaLyF0WGYi1AAhy3r6C0gBrENvOdpq8IA3CaX/psVFmUZqHBM/o6qq2lWKm5H jB6pvzBC9V2CN9Dom1YVas7WZCXlJkFKYzx+GOjABUzLIXBPQChQiyO542dddPX5 HOi7ABseqGPniNMAtJ92qm40pncJ7dD0qq4uybgBfREQM9Z7LaeRY5tbuKtRZUbA 80NjQDm8UdtNYZJltaVw/wwb6zSyrWVSPMwU38d11odOFx/lEf9ivt6wZVmutigw zgsv64QvDaT9bvzcw9NbFxd9ScoEENSre9BO5c382QlOlD5J4tmgHhnWA293bRBJ Ql8q6IEH7Yeh7e7tDNg4EWP1v35wnTHRH14pZHbdO19T0AS5v+wEjosolBEXm4iN JxQfwdnBLgF/nxdP5w08DkiSvGWz/czcOHFd89HXyuNSzGlQX6EMtqJCMxDqBlL3 ePM7dy5PU3bVJL4GiQ4+0wCoGqlrcESDsQRFSxlNd9Tz2Aa42RhhrOrhMuBAQeb3 t4zeqbYyLlK4VUsidPNe2k0SWPTEZp8X1DKFCfhu4/BzkpQMf2cAkJYth7ZdNkfX iiUYsbWel1qBY1PPLGF7CmNLijajRhsyoW4X/4ynUr1bfk+TmQKCAQEA8UuuXIvw PsHYhLakT+8UK6YZe884SZg16JUBcd9/5cOevwWlGRIHxKzjhlVzAu/GynNlFE6q ZJkACWz0PXtsaGAsEU/9vpI7xSE2klV9G/HvHSXUI43XmeZ4IUteYD77fXclYm40 kDyg95SdYsic3JI9DP4xNuOjMtu2bGCjwGlUJ4kPi+X7rno6i4CAGqxyX8STp6T8 86+XG4oSUAEB01MRDOQ01ZRvCz+ove2YAWzacGrdM40owHJ04FYK8g5o200icz5R O0/7B/xElRyISVfznY3NIkI2eAjn2tw2/ommIzQX8vlUUO2HCoe8HBAnPkfW0sV4 IWJRY9ZFs2ALewKCAQEA6OKfOufvGvnvb/bmro+UciXR6vDctyKAb3vPqhlTJg3s jsfHV8qGwuicRDa6QnY+8PPtmL8dcjdBQph45Ff3Ba2nXzdmiizbl5NJl8un4YtT uI+SQ91XGEOJZGcPzA3taNg53MdUzH6AMBpBUaQ1v83KHMjFSviARMKYkNqc1CF2 yzzFmxq+a539u7wDsvHM2yZ3LKyhwMFuUVups2gNknR2JXbJKFOMygSH25I5cHcE RMMue0/8jrTXubQxLfqbZnvQCVeoVr+AN/R0HpoFOYW4FiYnryoSrTHITVps+ZbF OcX9EKFVD+AxjKVk4QdhHyJS94weX3H63Q3juVQn9QKCAQEAnwlNq8vEFej3x0kF 9XVTaw14AGVs6Py8k0YahK5Vgt+zMp4K2gJLQnLdJ34MZuQYtvjlp0POBK3fG1dH h3pg0k6I3QRG7yM858njSQG1iwSjoCd9sc1cTCBeDzu4wWDhqykrZ7vRQzvisCuw rBojYTG1sWmckFvrBatQihAL/dauU7x/laqIftAq5CVWyb3dSIes9jLFUevqgYk4 VqjDRkCanU+QDzFdGyHjGwONS2sucifNEZw5PtZxeCbd4fpjXB9z1Fc/fQNTJkk7 /remkAi7FZ4PlUPk2Kqt/k9ko9GfwdYk7s0sqIZVmjgqYKi45NC+o37plb9Se6YP nJFyHwKCAQAOFR4h1sKbs/9pmtmKNr54RJc0CMqf/GMd2rPNCmj/xRnH7Ia+ZU3O 3XgNm+2ZdUMLGQUGFpB2RqcYmtW8oSEb48taM6RsuJeyy8JIfpUxS1aNs4jZt7m7 iuH1A1JuOW1gyKp/EkKrdv7TadMHV9G0PoJ5SR69ENfY0JefMskG/tsLISql3XEk WtJsFst2d662ldXhCrNhT5EXNF7HrYQclhRK4ar6WEsMMEfy3B3DEj9c1RyrckPI cWEWJrJOoHfjM5t55SYV0NC1EYAwFYo5Vz+xfy8pJXcpp/f/zXcHhLl6a+GIrujQ 4/K7GYlHHkYeNtojhAKWLPNJiLx7iX49AoIBAQC0XsTyyfi0m2Fmh4a4jbxbolXN dz5lc6HEnhnp0qU+8HTFjQeNTKAhCKwO7snv5l/p7GN1BkcnrOUZnDJHFRUJmsbk ZpJpya4QeQSQwhXZu9lv3363prIqlDQkYiGjtk60bPrC2Qi2fC6p2iZj0cFKLJOK fNC2u+h1IJ9tRQyjzMUZ5n/1/GGl9HZhcBmCkW9TG84yAuaqN367gpo3otOdl3kZ 8QVz5qLhacGorpVR4PNrqq84mVZUxtcvwEpbpFs4qEfAa/oiBuzhqiKYgS3I4pw8 JumLlkPcSQs6K0J/4Hizf16qtEacwwEmK/BbN7a4Ikai7LS30qcVWzuYJVb/ -----END RSA PRIVATE KEY----- di_authentication_service_jwt_public_key_content: | -----BEGIN PUBLIC KEY----- MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA24Iw6VOS6EONb6SKzkCc ijw48sVmTvKyoc6PkTIPJb4vyFrbjgqC0mVSs4fIRzzGpavIi76ZIp/fipvf38JV XKwAxHJXzWHi1lYmprxnuiAsiL/TEQKvHD4e/Nc73MoPinfxkiCFo6+9d8Wp7mmV sfaYLqX2Q8U+kEHOqCcsA7cnP+luRqtwA6xiXnACW3GU8Kenw2u+5CwoUaBMBPfc WtpqPUisGQEhcKxrqnBCdqcdOBR89/YtUYluoiDiDZf8lhS/ssZqejOaRLDCAGRR n3gaHdZfRM0jWbNzhL9TNLe3gR6HFSvVGnnchi3kkj1sWfN++u1QGAv08rjyGzPy QUj3Q04T0t4FSeZrRIby7OePaWH32JXiAn9RlWczUee9aE34LW3Wl2bhxDg6Qylw yIdg3GquC2DfqWB0DBSTPqsUOiBGwe4MxxU6N+7n4CPJ3IrPN34MaOsggFXnL5Rw ycHoQ1LBbRsa+gi5NQ1E0uRTBGL9Jy5yqoqwbVzO5YJLw24zYy6A9W6qz3LkCNDB JTWKLF2x+R2FwOuugP+0bAcTwM3KMEjX7it2JNVHQfjaANY7Dl6JoB6GTy+fvJSY eJnZLK/zByCnuoqMJJgurYitYauUZqEcsQyCdSUf8WWYA/EfQfclY/7zGWh8rc5b B9dyIaIA861tvZ5f6PQGubcCAwEAAQ== -----END PUBLIC KEY-----