Skip to main content

Adding Load balancer on Tableau Server

Adding Load balancer on Tableau Server


There are 2 ways to add Load balancer to Tableau Server

  1. key-value pairs to configure Tableau Server for a load balancer
  2. use the configuration file template 

Load balancer configuration key-value pairs


 To Add Load balancer on Tableau Server you need following Information

  1. URL used to reach Tableau Server from Load balancer
  2. port 443 open
  3. Load Balancer IPv4
  4. Load Balancer Fully Qualified Domain Name and any aliases
tsm configuration set -k gateway.public.host -v "tableau.example.com"

Tableau Server is reached by entering tableau.example.com in a browser address bar

tsm configuration set -k gateway.public.port -v "443"

tsm configuration set -k gateway.trusted -v "10.32.139.45, 10.32.139.46, 10.32.139.47"

The above Ips are examples. Please use your load balancer IPs

tsm configuration set -k gateway.trusted_hosts -v "lb.example.com, lb, ftp.example.com, www.example.com"

 Hosts/alternate names for the Load balancers

After executing the above command, apply the pending changes
 tsm pending-changes apply
This will prompt for restart of Tableau Server


Configuring Template


You can configure all of the settings in one operation by customizing the following configuration template example and creating a configKey json file.

Refer to the key-value pair descriptions above to customize the values for your organisation.

{
 "configKeys": {
"gateway.public.host": "tableau.example.com",
"gateway.public.port": "443",
"gateway.trusted": "proxy1, proxy2, proxy3",
"gateway.trusted_hosts": "lb.example.com, lb, ftp.example.com, www.example.com"
}
}
When you are finished, save the json file.

Pass the json file with tsm to set the configuration, and then apply settings by running the following commands:

tsm settings import -f /path/to/file.json

tsm pending-changes apply

------------------------------------------------------------------------------------------------------------------------
Labels:

Comments

Post a Comment

Popular posts from this blog

Gateway port to use 80 to 443 on Tableau Server

Change Gateway port from 80 to 443 or 8080       To change the Gateway port from 80 to 443 then use below commands First , list your nodes with the command. tsm topology list-node  Then execute the command to set port  tsm topology set-ports --node-name node1 --port-name gateway:primary --port-value 443 The above command will ask for a restart.  Check ports using  tsm topology list-ports  If some error occurs in applying changes: try disabling (enable later) external ssl first- tsm security external-ssl disable You might need to run init command again with new port- tsm reset tabcmd initialuser --server localhost:443 --username 'ADMINUSER' --password 'adminpwd'
Post a Comment
Read more

Creating Groups using Tableau API and Python Script

 Creating Tableau Groups using Python and API Prerequisites: Python on the machine tableauserverclient module API enabled on Tableau server. Permissions to update for the user Groups.csv file . list all groups in a csv file Changes to be made in the script for below lines in the script groups = open('<Filepath>/groups.csv') pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' Script: import tableauserverclient as TSC import csv groups = open('<Filepath>/groups.csv') grp = csv.reader(groups) sourcegroups=[] createdgrps=[] pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' ta = TSC.PersonalAccessTokenAuth(token_name=tokenName, personal_access_token=pat) with server.auth.sign_in_with_personal_access_token(ta):    groupslist, pagination_item  = server.groups.get() ...
Post a Comment
Read more

Tableau dirty Backup

Steps for performing a dirty restore 1. Install Tableau Server 2019.1.0 on the Dev machine 2. Stop Tableau Server 3. Copy the following folders from the current production: D:\Tableau Server\data\tabsvc\pgsql D:\Tableau Server\data\tabsvc\dataengine 4. Update the pg_hba.conf D:\Tableau Server\data\tabsvc\config\pgsql_0.<version>/pg_hba.conf Change "md5" to "trust" for the user "tblwgadmin" like this: host    all         tblwgadmin         <address>/32          md5 to : host    all         tblwgadmin        <address>/32         trust 5. Regenerate the internal token: tsm security regenerate-internal-tokens [options] [global options] tsm pending-changes apply 6. Re-index tsm maintenance reindex-search 7. Make a proper backup: tsm maintenance backup -f myBackup At this point, we w...
Post a Comment
Read more