-

Changing the Domain of a Qlik Replicate server

If you change the domain of its server, Qlik Replicate won't immediately work afterwards. Compose and Enterprise Manager seem to handle this a lot more simply.

For all of them it's worth making sure you have a local admin account that already has permissions to log in though before you change the domain. 

For Replicate, you need to update 3 things:

  1. "C:\Program Files\Attunity\Replicate\data\ServersConfiguration.xml" to have the new fully-qualified domain name. e.g. change "server.old-domain.local" in there to "server.new-domain.com"
  2. "C:\Program Files\Attunity\Replicate\data\service.url" - the same change as above (we found doing this in a text editor to be best rather than setting the properties as this seemed to keep reverting)
  3. This is the trickiest bit - you need to update the SQLite database stored in "C:\Program Files\Attunity\Replicate\data\GlobalRepo.sqlite"
    1. Firstly get a program like DB Browser for SQLite (sqlitebrowser.org) and open the file (making sure you have a backup of course).
    2. Check your existing host configuration:
      select * from objects where name='host_configuration';
    3. Then execute SQL to update the relevant line, starting with the json output above and replacing the hostname and domain with the new values - e.g. 
      update objects set json='
      {"$type":"RepUiHostConfigurationDto","repsrv_host":"127.0.0.1","repsrv_port":3552,"repsrv_root":"attunityreplicate","host_address":"server.new-domain.com","host_http_port":80,"host_https_port":443,"host_root":"/attunityreplicate","disable_http_cache_control":false,"max_receive_message_length":104857600,"session_timeout_sec":300,"allow_unsafe_protocols":false,"use_kerberos_authentication":false,"test_https":true,"min_size_for_compression":0,"max_size_for_compression":1572864,"max_concurrent_calls":128,"max_concurrent_sessions":800,"auth_method":"SSO","default_ad_domain":"new-domain.com","user_idle_timeout_sec":300,"idp_user_name_attribute":"username","idp_user_display_name_attribute":"displayname","idp_user_groups_attribute":"groups","static_http_headers":[],"rest_http_headers":[],"sliding_http_cache":false,"open_id_additional_scopes":"groups","api_token_daily_maintenance_time":"00:30","api_token_life_time":180,"open_id_refresh_token_life_time":0,"open_id_user_name_claim_type":"preferred_username","open_id_display_name_claim_type":"name","open_id_group_claim_type":"groups","use_strict_same_site_cookie":false,"name":"host_configuration","version":637606820403260000}'
      where name='host_configuration';
Have more questions? Submit a request

Comments