Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Rehan
Creator III
Creator III

Qlik Sense Node Installation Issue

I am setting  up a Prod environment  with a Central Node and one Rim Node. I have already setup the central node with the localhost repository wiith the  default user name of  "qliksenserepository". The central node is working perfectly fine(Server1.Domain).

Now I would like to add a Rim Node (Server2.Domain). At the start up of the Qlik Sense installation of this RIM I selected the option for "Join Cluster" and its askind to enter the

"Database Host Name": "Server1.Domain"

Database Port:         4432 (Same what I defined i the Central Node installation and the port is open)

Databaseuser :      qliksenserepository (Same what I defined i the Central Node installation and the port is open)

Database user password: (Same what I defined i the Central Node installation and the port is open)

 

I get the message "The database rejected the connection. Check your User name and Password"

What am I doing wrong here . 

 

Please see the attached screenshot 

 

 

1 Solution

Accepted Solutions
vishalarote
Partner - Creator II
Partner - Creator II

Multi-Node Connection with Central Node

1. First Install Qlik Sense Server (i.e. Central Node or Create Cluster).

Note: Before doing 2nd, 3rd and 4th step create backup those files.

2. Go to PostgreSQL\9.6 path like below.
C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6
Open postgresql.conf file.

3. Go to #listen_addresses

Do the following Changes:
#listen_addresses = ‘*’
max_connections = 200

4. Then open file pg_hba.conf from same path.

Do the Following Changes:
# IPv4 Local connections:
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::0/0 md5

5. Open cmd (run as administrator)
Write following truncate command.

(echo TRUNCATE "AppAvailabilities", "SyncSessions", "BinaryDownloadProperties", "BinaryDownloads", "BinaryDeleteProperties", "BinaryDeletes", "BinarySyncRuleEvaluations" CASCADE;) | "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\psql.exe" -U postgres -p 4432 -d QSR

Then write password for user postgres: (i.e. Qlik Super User Password or Qlik Repository Password)

6. Restart all Qlik Services.

7. Now Install Qlik Sense Server (i.e RIM Node or Join Cluster)

8. Open Setup file and click on install.

9. Accept the License agreements and click on Next.

10. Click on Join Cluster.

11. Write Database host Name is nothing but IP address of Central Node machine.
Database port: 4432
Database user: qliksenserepository
Password also same (Central Node installation password).

12. Click on Next.

13. Write Username and password for RIM node installation Machine.

14. Click on Install.

15. Click on finish.

16. Open QMC of Central Node.

17. Go to Nodes tab and click on Create new.

18. Fill the information like as below.
Name: Node1 (i.e. Any Name)
Host Name: IP address of RIM Node Machine.
Node Purpose: Both
Disable the Failover Candidate
Enable the All Service Activations.

19. Click on Apply.

20. It will prompted Node registration password and URL.
Copy that URL.
Paste into RIM Node Machine.
It will show you Install certificates message.

21. Paste here Node registration password.

22. The services was successfully unlocked.

23. Open QMC of Central Node.
Go to Node tab.
The Newly created node will display the status as “certificate has not been install”.

24. Restart all Qlik Sense Services (i.e. Central Node).

25. Open again QMC of Central Node.
Status will change to “5 of 5 services are running”.

26. Restart all services of Qlik Sense RIM Node.

27. Open QMC in RIM Node.
First it will hide all tabs for RIM Node user because the access is not been given by Central Node to RIM Node.

28. Open QMC of Central Node then go to Users tab and select User for RIM Node Machine and click on Edit.
Add Root Admin or any of the specific role to that user.

29. Refresh again QMC of RIM Node.
It will show you all data from Central Node.

 

View solution in original post

2 Replies
vishalarote
Partner - Creator II
Partner - Creator II

Multi-Node Connection with Central Node

1. First Install Qlik Sense Server (i.e. Central Node or Create Cluster).

Note: Before doing 2nd, 3rd and 4th step create backup those files.

2. Go to PostgreSQL\9.6 path like below.
C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6
Open postgresql.conf file.

3. Go to #listen_addresses

Do the following Changes:
#listen_addresses = ‘*’
max_connections = 200

4. Then open file pg_hba.conf from same path.

Do the Following Changes:
# IPv4 Local connections:
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::0/0 md5

5. Open cmd (run as administrator)
Write following truncate command.

(echo TRUNCATE "AppAvailabilities", "SyncSessions", "BinaryDownloadProperties", "BinaryDownloads", "BinaryDeleteProperties", "BinaryDeletes", "BinarySyncRuleEvaluations" CASCADE;) | "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\psql.exe" -U postgres -p 4432 -d QSR

Then write password for user postgres: (i.e. Qlik Super User Password or Qlik Repository Password)

6. Restart all Qlik Services.

7. Now Install Qlik Sense Server (i.e RIM Node or Join Cluster)

8. Open Setup file and click on install.

9. Accept the License agreements and click on Next.

10. Click on Join Cluster.

11. Write Database host Name is nothing but IP address of Central Node machine.
Database port: 4432
Database user: qliksenserepository
Password also same (Central Node installation password).

12. Click on Next.

13. Write Username and password for RIM node installation Machine.

14. Click on Install.

15. Click on finish.

16. Open QMC of Central Node.

17. Go to Nodes tab and click on Create new.

18. Fill the information like as below.
Name: Node1 (i.e. Any Name)
Host Name: IP address of RIM Node Machine.
Node Purpose: Both
Disable the Failover Candidate
Enable the All Service Activations.

19. Click on Apply.

20. It will prompted Node registration password and URL.
Copy that URL.
Paste into RIM Node Machine.
It will show you Install certificates message.

21. Paste here Node registration password.

22. The services was successfully unlocked.

23. Open QMC of Central Node.
Go to Node tab.
The Newly created node will display the status as “certificate has not been install”.

24. Restart all Qlik Sense Services (i.e. Central Node).

25. Open again QMC of Central Node.
Status will change to “5 of 5 services are running”.

26. Restart all services of Qlik Sense RIM Node.

27. Open QMC in RIM Node.
First it will hide all tabs for RIM Node user because the access is not been given by Central Node to RIM Node.

28. Open QMC of Central Node then go to Users tab and select User for RIM Node Machine and click on Edit.
Add Root Admin or any of the specific role to that user.

29. Refresh again QMC of RIM Node.
It will show you all data from Central Node.

 

unknown321
Contributor
Contributor

Hi,

I cannot find the bin\psql.exe in the abovementioned location. 
Where can i find the same, or would i need to do something to get the file in the location.


Thanks