Give a chestnut! Tableau Tips (67): VMware builds a Tableau Server for Linux stand-alone environment

published: 2021-05-24

Tableau Server for Linux launched by Tableau 10.5 allows users to better integrate Tableau's analysis platform with the enterprise-level functions of Linux, thereby simplifying deployment and management.

Many users continue to choose Linux systems to run Tableau Server. We have also shared how to migrate Tableau Server from Windows to Linux.

But what if you can't completely give up on the Windows system and want to run Tableau Server on the Linux system? A more feasible method is to use virtual machines. This has the advantage of not only facilitating future testing, but also saving hardware resources.

 

In this issue of "Give a Chestnut", we will share this Tableau technique with you: VMware builds a Tableau Server for Linux standalone environment

Description:

The author is using Tableau Server version 10.5. If you are a higher version of Tableau Server user,

This chestnut is for reference only. I suggest you try to install a higher version of Tableau Server, and share the method with you through "Give a Chestnut"!

Next, let's take a look at the specific construction process!

Specific steps are as follows:

Step 1:Environmental preparation

(Note: Refer to Tableau Server's minimum hardware requirements and recommended configuration)

》Virtual machine part

Virtual machine download: VMware®Workstation14.1.1.28517

(download link: https://link.jianshu.com/?t=http%3A%2F%2Fsw.bos.baidu.com%2Fsw-search-sp%2Fsoftware%2F39f39fba669e1b70 %2FVMware-workstation-full-14.1.1.28517.exe)

》System part

❶ System download: CentOS-7-x86_64-DVD-1708

(download link: http://isoredirect.centos.org/centos/7/isos/x86_64/CentOS-7-x86_64-DVD-1708.iso)

❷ System configuration:

Hardware configuration: RAM 8G (real machine requires more than 12G RAM), processor 4 cores, hard disk 100 GB, network card bridge mode or NAT mode (make sure you can access the Internet);

System settings: configure a fixed IP, turn off SELinux, turn off the firewall (close the test environment directly).

Temporarily turn off SELinux/firewall

setenforce 0

iptables -F

Software part

Version number: 10500.18.0109.1050

Release Date: 2018-01-10

RHEL/CentOS:Tableau-server-10-5-0.x86_64.rpm

(download link: https://www.tableau.com/support/releases/server/10.5)

》Tools section

❶ Connection tool (easy to copy and paste commands directly): PuTTy tool

(download link: https://link.jianshu.com/?t=http%3A%2F%2Fsw.bos.baidu.com%2Fsw-search-sp%2Fsoftware%2F473c4b8568792 %2FPuTTY_0.67.0.0.exe)

❷ File tool (upload Server installation package): FileZilla tool

(download link: https://link.jianshu.com/?t=http%3A%2F%2Fsw.bos.baidu.com%2Fsw-search-sp%2Fsoftware%2F090246a8f0734 %2FFileZilla_3.24.0.0_win64-setup.exe)

Log in and upload files

 

Step 2: install Tableau Server

❶ Add the installation user (the pro-test must be a non-root user)

#Add group

[root@localhost ~]# groupadd tableau

#Add user

[root@localhost ~]# useradd admin -g tableau

#Set user password and activate

[root@localhost ~]# passwd admin

#Add TSM users and groups

[root@localhost ~]# groupadd tsmadmin

[root@localhost ~]# useradd myth -g tsmadmin

[root@localhost ~]# passwd myth

❷ Install the Tableau Server package

Log in as a user with sudo access to the computer where you want to install Tableau Server.

Add a normal user with sudo permissions

To modify /etc/sudoers, you need to use the visudo command

[root@localhost ~]# visudo

Add code

admin ALL=(ALL) ALL

Use the package manager to install the Tableau Server software package. The first execution of the YUM command will automatically synchronize and update some packages.

[admin@localhost ~]$ sudo yum -y install tableau-server-10-5-0.x86_64.rpm

Installation progress

❸ Start TSM

[admin@localhost ~]$ cd /opt/tableau/tableau_server/packages/scripts.10500.18.0109.1050/

[admin@localhost ~]$ sudo ./initialize-tsm --accepteula

TSM started successfully

 

❹ Execute environment variable script

[admin@localhost ~]$ source /etc/profile.d/tableau_server.sh

Step 3: register and activate Tableau Server

❶ Log in to Tableau Service Manager

[admin@localhost ~]$ tsm login -u myth

❷ Activate Tableau Server

To activate the license key, run the following command:

[admin@localhost ~]$ tsm licenses activate -k

To activate the trial version, run the following command:

[admin@localhost ~]$tsm licenses activate –t

Trial activated.

❸ Register Tableau Server

Create a registration file and generate a template that can be edited by running the following command.

[admin@localhost ~]$ tsm register --template > ~/registration_file.json

Edit the template file.

[admin@localhost ~]$ vi registration_file.json

Registration complete.

Examples are as follows:

{

“zip” : “10000”,

“country” : “China”,

“city” : “Wuhan”,

“last_name” : “myth”,

“industry” : “Software”,

“eula” : “yes”,

“title” : “Software Applications Engineer”,

“phone” : “13500000000”,

“company” : “Example”,

“state” : “NH”,

“department” : “Engineering”,

“first_name” : “lee”,

“email” : “12345678@qq.com”

}

Use the tsm register command to register Tableau Server.

[admin@localhost ~]$ tsm register --file ~/registration_file.json

Registration complete.

Step 4: configure the local firewall

❶ Run the following TSM command to retrieve the port number of the tabadmincontroller port

[admin@localhost ~]$ tsm topology list-ports

❷ Start the firewall

[admin@localhost ~]$ sudo systemctl start firewalld

❸ Verify whether the default zone is a high security zone

[admin@localhost ~] sudo firewall-cmd --get-default-zone [admin@localhost ~] sudofirewall−cmd−−get−default−zone[admin@localhost ]sudo firewall-cmd --set-default-zone=public

❹ Add ports for gateway and tabadmincontroller ports

[admin@localhost ~] sudo firewall-cmd --permanent --add-port=80/tcp [admin@localhost ~] sudofirewall−cmd−−permanent−−add−port=80/tcp[admin@localhost ]sudo firewall-cmd --permanent --add-port=8850/tcp

❺ Reload the firewall and verify the settings

[admin@localhost ~] sudo firewall-cmd --reload [admin@localhost ~] sudofirewall−cmd−−reload[admin@localhost ]sudo firewall-cmd --list-all

Firewall configuration

 

Step 5:configure initial node settings

Configure identity store settings

tsm settings import -f ~/file.json

[Example of creating an authentication file]

{

“configEntities”:{

“identityStore”: {

“_type”: “identityStoreType”,

“type”: “local”

}

}

}

Step 6:initial configuration and start service

❶ Apply initial configuration and run TSM process

[admin@localhost ~]$ tsm pending-changes apply

Start the TSM process

 

❷ Initialize and start Tableau Server

Initialize Tableau Server

[admin@localhost ~]$ tsm initialize --start-server --request-timeout 1800

Initial start

 

Create initial administrative user

[admin@localhost ~]$ tabcmd initialuser --server “localhost:80” --username “admin” --password “admin”

Create an administrative user

 

Step 7:the installation is successful

 

Open up your Tableau and give it a try!