topic Re: Rename Qlik Sense Server in Management & Governance

Rename Qlik Sense Server

Ricardo_Gerhard — Thu, 19 Feb 2015 13:26:11 GMT

I installed Qlik Sense on win-i3l69ais9mr. After installed and configured, I rename the server name do SENSE.

When I try to open QMC or HUB, I see the error message

Error 500 - Internal server error

Cannot establish a connection to Qlik Sense: Qlik Sense Hub.

I tried to recreate certificates, but still old name in mmc certificates.

All services are running ok.

Any idea to restablish system?

Re: Rename Qlik Sense Server

korsikov — Fri, 20 Feb 2015 09:44:36 GMT

Hi.

You need stop all services, expept database service.

1. Delete all certificates. they will be recreated during the next startup services

2. open phadmin c:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.3\bin\pgAdmin3.exe and open Your DB

port localhost:4432 DB user Postgres. Password you specified during installation.

3. open DB QSR

4. in table ServerNodeConfigurations change Hostname and save

5. Try start services.

Re: Rename Qlik Sense Server

Ricardo_Gerhard — Mon, 23 Feb 2015 17:04:29 GMT

Did you try this?

I made this steps and the same error.

Stopped all services, delete certificates , open db and change database value.

After start QRS, the database value return old value in the database and the certificates was recreated with old name.

Re: Rename Qlik Sense Server

Michael_Tarallo — Mon, 23 Feb 2015 20:38:15 GMT

Hello Ricardo,

Take a look at this and see if this is helpful

There is a file named: Host.cfg located in <drive>:\ProgramData\Qlik\Sense

It has a base64 encoded string which when decoded you can see the hostname the product was installed on:

You can use this free online tool to decode and encode the string:

https://www.base64decode.org/

You can edit the Host.cfg and replace the encoded string with another encoded string and restart your services.

so - mynewhostname - will look like this in the Host.cfg file: bXluZXdob3N0bmFtZQ==

Note: When I did this (because my Amazon EC2 instanced had a hostname change) - it worked but - for some reason in the QMC it showed my scheduler and proxies as stopped even though they were running. You may have to restart the individual services (scheduler and proxy) a 2nd time again to get the notifications to clear in the QMC.

Hope this helps

Note: Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike T

Qlik

Re: Rename Qlik Sense Server

korsikov — Mon, 23 Feb 2015 20:49:24 GMT

As always, the decision was easier than it looked. Thanks Mike, I walked through the configuration files, but did not think that the host name can be saved in base64 encoded string

Re: Rename Qlik Sense Server

Ricardo_Gerhard — Wed, 25 Feb 2015 20:07:40 GMT

Thanks Michael.

After change, I changed the RootAdmin directly and worked fine.

Re: Rename Qlik Sense Server

Sun, 08 May 2016 14:58:36 GMT

Since this is very useful to know is there a reason this method isn't (I believe) in the official documentation (or ideally, the interface itself)? Is it because it's a rather drastic change with many consequences (since it affects certificates, whitelists, proxy redirection paths etc)? I also believe some form of automatic hostname validation is needed since a misconfigured server name can have detrimental consequences with no obvious clues (e.g. the engine, proxy and printing services may appear to start normally but fail to resolve the provided hostname).

Re: Rename Qlik Sense Server

Sat, 27 Aug 2016 16:08:39 GMT

I was ready to take some of the steps above, which can be quite involved, later I realized that in my case, I only needed to add an extra host name in the "Host white list" for the default Virtual Proxy. I'm sure the people above had good reasons to change the original host name but if you just want to make the Qlik Sense hub available under an extra host name then adding it to the Host white list might be enough.

Re: Rename Qlik Sense Server

muhammadraza — Wed, 12 Apr 2017 11:06:07 GMT

getting internal server and QlikSense Hub Error error after doing this change. I even restarted the services multiple times but issue persists.

Re: Rename Qlik Sense Server

Thu, 13 Apr 2017 16:55:44 GMT

Hi ,

I tried to follow the procedure to change the server name but couldn't find the host config file in

QS 3.2 version.Can you please help me with this.

Thanks,

Veeru

Re: Rename Qlik Sense Server

Michael_Tarallo — Thu, 13 Apr 2017 19:25:08 GMT

Hi Veeren,

You are in the wrong location as per your screenshot.

you should be here: C:\ProgramData\Qlik\Sense

ProgramData I believe is hidden by default you need to "un-hide" it:

Hope this helps

Mike

Re: Rename Qlik Sense Server

Anonymous — Mon, 08 Jan 2018 17:28:48 GMT

I cannot reach Qlik Sense pages after changing the server name & hosts.cfg file.

Getting a site cannot be reached error.

Re: Rename Qlik Sense Server

Anonymous — Mon, 15 Jan 2018 08:31:19 GMT

Hi!

I had exactly the same issue (Error 404). Did you manage to solve the problem?

Re: Rename Qlik Sense Server

Anonymous — Tue, 16 Jan 2018 15:13:49 GMT

I did!

Repairing Qlik Sense fixed it.

I however reverted it back to the old hostname before I did the repair. Not sure if its a valid step though.

Sorry for the late reply.

Re: Rename Qlik Sense Server

Anonymous — Tue, 16 Jan 2018 21:47:37 GMT

Hi Michael,

after doing this, impossible to open the QMC or the Hub and following message in the Security Repository log:

"Not possible to decrypt encrypted string in database; this is probably due to the secrets key on server certificate has been changed and the old database value hasn't"

Do you maybe have a solution for that?

Thanks.

Re: Rename Qlik Sense Server

Anonymous — Wed, 17 Jan 2018 07:09:25 GMT

Yeah. I had errors in many logs after I changed this.

I think this method stopped working after Qlik changed to shared persistence model.

Did you try repair though?

Re: Rename Qlik Sense Server

Anonymous — Wed, 17 Jan 2018 08:17:04 GMT

You repaired it but at the end you still have the old hostname.

I guess that I will have no choice but to uninstall and reinstall after the name change....

Thank you.

Re: Rename Qlik Sense Server

itmakervf — Mon, 22 Jan 2018 21:02:02 GMT

It's posible that something change to version 3.0.0? 'cause neither Host.cnf file or the order of the folders are the same.

Re: Rename Qlik Sense Server

mnu — Tue, 20 Feb 2018 21:19:54 GMT

As of Qlik Sense June 2017 you also need to run the Repository bootstrap process as follows:

Open cmd.exe with administrative rights
Change the directory to the Repository install path
- Default path C:\"Program Files"\Qlik\Sense\Repository
Execute the following command: Repository.exe -bootstrap -standalone -restorehostname

Re: Rename Qlik Sense Server

EmmaC — Tue, 29 May 2018 11:15:07 GMT

If the shared persistance folder is in the server that just changed its name. The repository info has to be changed as well. The table is ServiceClusterSettingsSharedPersistenceProperties

regards,

Emma