Skip to main content

Tableau Linux External File Store Configuration

1. Mount EFS Mount point on all the nodes and provide the user id for tableau run the ownership on the mount. 
2. stop the services using tsm stop 
3. stop Administrative services on all nodes using below command.              /opt/tableau/tableau_server/packages/scripts.2021x.xx.xxxx.x/stop-administrative-services 
4.Contact your infra team to change all tableau user id to same on all servers and change the ownership of files where the old UID and GID is the owner of them. IG GID is 991

     Update UID and GID manually in /etc/passwd and /etc/group file
    find / -group 991 -exec chgrp -h tableau {} \; 
     find / -user 991 -exec chown -h tableau {} \; 
     cd /etc/systemd/system/ 
     cp -p user@.service user@new_gid.service 
     chmod +x user@new_gid.service 
     systemctl enable user@new_gid.service 
5. make sure UID and GID of tableau is updated to new GID 
6. Reboot all nodes. 
7. Start Administrative services. 
        /opt/tableau/tableau_server/packages/scripts.2021x.xxx.xxx/start-administrative-services 
8. This will take long time to start the licensing services.(30 -40 mins) 
9. Run tsm start to start all the services. 
10. Validate once services have been started. check all the extracts running.
11. Stop the services using tsm stop
12. Run the below command to move to EFS 
        tsm topology external-services storage enable –-network-share /mnt/<network share name>/tableau
13. Run tsm start to start all the services. 
14. Validate once services have been started. check all the extracts running.

There will be folders created under the share. 
Extracts and workbook revisions:
tableau_data tabsvc/dataengine/extracts
tableau_data/tabsvc/dataengine/revisions
PostgreSQL data backups:
tableau_data/tabsvc/pg_backups

Labels

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