CentOS7中安装Tableau Server 2019.3踩坑指南

简介: CentOS7中安装Table Server 2019.3踩坑指南 下载Tableau Server的linux版本 https://www.tableau.com/products/server/download/linux 当前版本为:tableau-server-2019-3-0.

CentOS7中安装Tableau Server 2019.3踩坑指南

下载Tableau Server的linux版本

https://www.tableau.com/products/server/download/linux
当前版本为:tableau-server-2019-3-0.x86_64.rpm

tableau server最低硬件要求:16G内存/8Cpu,否则安装程序会报错终止安装:

--Your system does NOT meet the minimum system requirements for Tableau Server--
Tableau Server requires these minimum hardware requirements: http://www.tableau.com/products/server/specs
Either try the install on a different computer, or explore our other options for running a trial of Tableau Server: http://www.tableau.com/products/server/download
Tableau Server requires at least 16 GB memory to run, but found only 8 GB of memory.      ---》强制指标,内存达不到就会停止安装
Tableau Server runs best with at least 8 cores, but found only 4 core(s).                 ---》不是强制指标

达不到以下最低配置:
8 核、2.0 GHz 或更高频率的处理器
64 位处理器架构
32 GB 内存
50 GB 可用磁盘空间
安装上去了,也是非常卡顿的

添加安装用户(亲测必须非root用户安装)

[root@localhost ~]# useradd tabadmin
[root@localhost ~]# passwd tabadmin
Changing password for user tabadmin.
New password: 
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@localhost ~]# groupadd tsmadmi
[root@localhost ~]# usermod -aG tsmadmin tabadmin
[root@localhost ~]# vi /etc/sudoers
[root@localhost ~]# 
在文件的最后一行,加上,目的就是后续用飞root用户,加上sudo来执行安装过程中的命令
tabadmin ALL=(ALL) ALL

[tabadmin@localhost Downloads]$ pwd
/home/tabadmin/Downloads
[tabadmin@localhost Downloads]$ sudo yum install tableau-server-2019-3-0.x86_64.rpm
[sudo] password for tabadmin:                 ------》输入操作系统密码
Loaded plugins: fastestmirror, langpacks
Examining tableau-server-2019-3-0.x86_64.rpm: tableau-server-20193.19.0913.2225-20193-19.0913.2225.x86_64
Marking tableau-server-2019-3-0.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package tableau-server-20193.19.0913.2225.x86_64 0:20193-19.0913.2225 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================================================================================================================================
 Package                                                       Arch                               Version                                        Repository                                                   Size
===================================================================================================================================================================================================================
Installing:
 tableau-server-20193.19.0913.2225                             x86_64                             20193-19.0913.2225                             /tableau-server-2019-3-0.x86_64                             3.5 G

Transaction Summary
===================================================================================================================================================================================================================
Install  1 Package

Total size: 3.5 G
Installed size: 3.5 G
Is this ok [y/d/N]: y               ------》手工输入【y】
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction

Your hardware meets the minimum requirements for a trial of Tableau Server.
If you plan to run Tableau Server in a production environment, we recommend the following hardware specifications: http://www.tableau.com/products/server/specs
Tableau Server runs best with at least 32 GB memory, but found only 16 GB of memory.
Tableau Server runs best with at least 8 cores, but found only 4 core(s).

  Installing : tableau-server-20193.19.0913.2225-20193-19.0913.2225.x86_64                                                                                                                                     1/1 

If this is a single node or initial node installation, run:

    sudo /opt/tableau/tableau_server/packages/scripts.20193.19.0913.2225/initialize-tsm --accepteula

to continue setting up Tableau Server. If this installation is part of a multi-node configuration,
see the online documentation for installing Tableau Server on additional nodes.

  Verifying  : tableau-server-20193.19.0913.2225-20193-19.0913.2225.x86_64                                                                                                                                     1/1 

Installed:
  tableau-server-20193.19.0913.2225.x86_64 0:20193-19.0913.2225                                                                                                                                                    

Complete!
[tabadmin@localhost Downloads]$ 
[tabadmin@localhost packages]$ cd /opt/tableau/tableau_server/packages/script*
[tabadmin@localhost scripts.20193.19.0913.2225]$ pwd
/opt/tableau/tableau_server/packages/scripts.20193.19.0913.2225
[tabadmin@localhost scripts.20193.19.0913.2225]$ ls -al
total 200
drwxr-xr-x.  2 root root  4096 Oct 16 08:12 .
drwxr-xr-x. 66 root root  4096 Oct 16 08:12 ..
-rwxr-xr-x.  1 root root  3341 Sep 14 02:55 after-install
-rw-r--r--.  1 root root 30518 Sep 14 02:55 after-install-common
-rwxr-xr-x.  1 root root  1891 Sep 14 02:55 before-remove
-rw-r--r--.  1 root root   125 Sep 14 02:55 config.json
-rw-r--r--.  1 root root   355 Sep 14 02:55 defaults.bash
-rwxr-xr-x.  1 root root  3099 Sep 14 02:55 disable-coordination-service-authentication
-rwxr-xr-x.  1 root root 20885 Sep 14 02:55 initialize-tsm
-rw-r--r--.  1 root root 20109 Sep 14 02:55 initialize-tsm-common
-rw-r--r--.  1 root root  2900 Sep 14 02:55 local-configuration
-rwxr-xr-x.  1 root root  6718 Sep 14 02:55 migrate-to-single-user
-rwxr-xr-x.  1 root root  4072 Sep 14 02:55 move-tsm-controller
-rw-r--r--.  1 root root   201 Sep 14 02:55 README
-rwxr-xr-x.  1 root root  2799 Sep 14 02:55 stack-traces-from-coredumps
-rwxr-xr-x.  1 root root  1553 Sep 14 02:55 start-administrative-services
-rwxr-xr-x.  1 root root  2633 Sep 14 02:55 stop-administrative-services
-rw-r--r--.  1 root root 11690 Sep 14 02:55 tabcmd.autocomplete
-rwxr-xr-x.  1 root root  8033 Sep 14 02:55 tableau-server-obliterate
-rw-r--r--.  1 root root 25728 Sep 14 02:55 tsm.autocomplete
-rwxr-xr-x.  1 root root  8405 Sep 14 02:55 upgrade-tsm
-rw-r--r--.  1 root root   681 Sep 14 02:55 user-at.service

初始化tsm

[tabadmin@localhost scripts.20193.19.0913.2225]$ sudo ./initialize-tsm --accepteula

[sudo] password for tabadmin:                 -----》输入操作系统密码
Creating 'tableau' unprivileged user account
Creating directories and setting permissions...
Using '/var/opt/tableau/tableau_server' as the data directory.
Adding user 'tabadmin' to group 'tableau'...
Adding user 'tabadmin' to group 'tsmadmin'...
Added. Note: These group membership changes do not take effect in shells already open. For these to take effect, log out of the shell and log back in.
Creating environment file...
Starting TSM services...
Updating repository version in Tableau Server Coordination Service.
TSM services started successfully
Use the 'tsm' command to continue setting up Tableau Server.
>> Tableau binary directory will be added to PATH for new shells. To get the
>> updated path, either start a new session, or for bash users run:
>> source /etc/profile.d/tableau_server.sh
The TSM administrative web interface (and REST API) is now available at
https://localhost.localdomain:8850
You can continue the configuration and initialization of Tableau server using either the TSM command line interface,
or the web interface.
You will be prompted to authenticate, or can log in using the username 'tabadmin', with the same password you used to log into this session. You could also use any username, with its password, from the administrative group in the domain.
Done.
[tabadmin@localhost scripts.20193.19.0913.2225]$

设置环境变量

[tabadmin@localhost scripts.20193.19.0913.2225]$ source /etc/profile.d/tableau_server.sh

安装成功后启动tsm

用tsm命令登陆
[tabadmin@localhost scripts.20193.19.0913.2225]$ tsm login -u tabadmin
Password:         ---》输入操作系统密码

激活商业key

[tabadmin@localhost scripts.20193.19.0913.2225]$ tsm licenses activate -k <keyxxxxx>
或者是申请试用 Trail自己的两周试用版
[tabadmin@localhost scripts.20193.19.0913.2225]$ tsm licenses activate -t
Trial activated.

注册

创建注册配置文件

[tabadmin@localhost scripts.20193.19.0913.2225]$ tsm register --template > /home/tabadmin/Downloads/registration_file.json
[tabadmin@localhost scripts.20193.19.0913.2225]$ vi /home/tabadmin/Downloads/registration_file.json
{
   
"zip" : "03079",
"country" : "USA",
"city" : "Salem",
"last_name" : "Smith",
"industry" : "Software",
"eula" : "yes",
"title" : "Software Applications Engineer",
"phone" : "5556875309",
"company" : "Example",
"state" : "NH",
"department" : "Engineering",
"first_name" : "Jason",
"email" : "jsmith@example.com"
}

注册文件传递给 TSM 以注册

[tabadmin@localhost scripts.20193.19.0913.2225]$ tsm register --file /home/tabadmin/Downloads/registration_file.json

Registration complete.

配置本地防火墙

一 、运行以下 TSM 命令来检索 tabadmincontroller 端口的端口号
[admin@localhost ~]$ tsm topology list-ports
二、启动防火墙
[admin@localhost ~]$ sudo systemctl start firewalld
三、验证默认区域是否是高安全性区域
[admin@localhost ~]$sudo firewall-cmd --get-default-zone
[admin@localhost ~]$sudo firewall-cmd --set-default-zone=public
四、针对 gateway 端口和 tabadmincontroller 端口添加端口
[admin@localhost ~]$sudo firewall-cmd --permanent --add-port=80/tcp
[admin@localhost ~]$sudo firewall-cmd --permanent --add-port=8850/tcp
五、重新加载防火墙并验证设置
[admin@localhost ~]$sudo firewall-cmd --reload
[admin@localhost ~]$sudo firewall-cmd --list-all

配置初始节点设置

[tabadmin@localhost scripts.20193.19.0913.2225]$ vim /home/tabadmin/Downloads/local_auth_file.json
创建身份验证文件

{
   
"configEntities":{
   
"identityStore": {
   
"_type": "identityStoreType",
"type": "local"
}
}
}

[tabadmin@localhost scripts.20193.19.0913.2225]$ tsm settings import -f /home/tabadmin/Downloads/local_auth_file.json

应用初始配置并运行TSM进程

[tabadmin@localhost scripts.20193.19.0913.2225]$ tsm pending-changes apply
Starting deployments asynchronous job.
Job id is '0', timeout is 10 minutes.
6% - Retrieving the topology to deploy.
13% - Retrieving the configuration to deploy.
20% - Validating the new topology.
26% - Determining if server needs to be started.
33% - Disabling all services.
40% - Waiting for the services to stop.
46% - Updating nodes to new topology.
53% - Waiting for topology to be applied.
60% - Updating nodes to new configuration.
66% - Disabling all services.
73% - Waiting for the services to stop.
80% - Reconfiguring services.    
86% - Waiting for services to reconfigure.    
93% - Enabling all services.
100% - Waiting for the services to start.
Successfully deployed nodes with updated configuration and topology version.

初始化启动Tableau Server(这时间可是比较长的,要有耐心)

[tabadmin@localhost scripts.20193.19.0913.2225]$ tsm initialize --start-server --request-timeout 1800
Initializing the server...
Job id is '1', timeout is 30 minutes.
3% - Validating that there are no pending changes.
6% - Generating passwords.
10% - Generating search server ssl certificate.    
13% - Generating Elastic Server SSL certificate.    
17% - Generating key store.    
20% - Promoting configuration.
24% - Waiting for services to reconfigure.    
27% - Generating new asset key.
31% - Saving asset key.
34% - Initializing the topology.    
37% - Waiting for the maintenance app to start.    
41% - Initializing the temporary database instance.    
44% - Starting the temporary database instance.    
48% - Creating roles and databases.    
51% - Running migrations.    
55% - Localizing the default projects.    
58% - Stopping the temporary database instance.    
62% - Making the temporary database default.
65% - Initializing the next active repository.    
68% - Enabling services needed for server initialization.    
72% - Connecting to the Backup/Restore service.
75% - Saving asset key metadata.
79% - Configuring search server.    
82% - Connecting to the Backup/Restore service.
86% - Initializing Elastic Server.    
89% - Finalizing the topology.    
93% - Connecting to Vizportal Maintenance.
96% - Rebuilding the search index.    
100% - Finalizing the initialization.

Server was initialized successfully.

创建初始管理用户(将来的tableau页面中的第一个管理员用户,就是这里创建的)

[tabadmin@localhost scripts.20193.19.0913.2225]$ tabcmd initialuser --server "localhost:80" --username "admin" --password "admin"
===== redirecting to http://localhost/auth
===== Signed out
===== Creating new session
=====     Server:   http://localhost:80
=====     Username: admin
===== Connecting to the server...
===== Signing in...
===== Succeeded
[tabadmin@localhost scripts.20193.19.0913.2225]$

验证tableau server安装是否成功

在浏览器中打开-->http://localhost:80,即可看到table server的登录界面,用新创建的管理用户admin/admin登录,即可管理tableau服务器了

222222

讲tableau desktop编辑开发的可视化内容发布到tableau server中

2018版的tableau还有一个服务器的菜单,到2019版本,这个菜单好像没有看到了,直接就在:【文件】->【共享】,输入刚才创建的用户名、密码:admin/admin即可登录tableau server上看到tableau desktop中编辑的可视化内容

linux版本的驱动程序的安装

常见的驱动程序下载路径:https://downloads.tableau.com/drivers/linux/yum/tableau-driver/
运行以下命令:
sudo yum install mysql-connector-odbc-5.3.10-1.el7.x86_64.rpm
安装驱动程序后,将以下部分追加到 /etc/odbcinst.ini 文件(如果不存在则添加,我在安装时发现文件有下面代码所以没有添加):
[MySQL ODBC 5.3 Unicode Driver]
Driver = /usr/lib64/libmyodbc5w.so
UsageCount = 1

FAQ:

tableau server 安装好后也能登陆控制台,但是web应用无法向tableau server请求服务时请求不到数据
解决方法就是向 Tableau Server 添加受信任的 IP 地址或主机名称
Linux版添加方法就是登陆tsm执行添加受信任的ip
su tabadmin
tsm login -u tabadmin
然后执行如下命令

有在阿里云中安装tableau的指导,竟然没有华为云中的安装指导
tsm authentication trusted configure -th "192.168.1.101"

分布式安装参照:

至少需要三台计算机或虚拟机:一台用作初始 Tableau Server 节点,两台用作附加节点。
https://help.tableau.com/current/server/zh-cn/distrib_ha.htm
https://help.tableau.com/current/server/zh-cn/distrib_requ.htm
相关文章
|
1月前
|
存储 Ubuntu Linux
VMware-安装CentOS系统教程及安装包
虚拟机相当于是一个独立于你电脑的环境,在这个环境上面,你可以安装Linux、Windows、Ubuntu等各个类型各个版本的系统,在这个系统里面你不用担心有病读等,不用担心文件误删导致系统崩溃。 虚拟机也和正常的电脑系统是一样的,也可以开关机,不用的时候,你关机就可以了,也不会占用你的系统资源,使用起来还是比较方便 这里也有已经做好的CentOS 7系统,下载下来解压后直接用VMware打开就可以使用
470 69
|
7天前
|
存储 分布式计算 Linux
安装篇--CentOS 7 虚拟机安装
VMware 装 CentOS 7 不知道从哪下手?这篇超详细图文教程手把手教你在 VMware Workstation 中完成 CentOS 7 桌面系统的完整安装流程。从 ISO 镜像下载、虚拟机配置,到安装图形界面、设置用户密码,每一步都有截图讲解,适合零基础新手快速上手。装好之后无论你是要搭 Hadoop 集群,还是练 Linux ,这个环境都够你折腾一整天!
248 2
|
1月前
|
Ubuntu Linux 索引
Centos 7、Debian及Ubuntu系统中安装和验证tree命令的指南。
通过上述步骤,我们可以在CentOS 7、Debian和Ubuntu系统中安装并验证 `tree`命令。在命令行界面中执行安装命令,然后通过版本检查确认安装成功。这保证了在多个平台上 `tree`命令的一致性和可用性,使得用户无论在哪种Linux发行版上都能使用此工具浏览目录结构。
250 78
|
7天前
|
安全 关系型数据库 MySQL
CentOS 7 yum 安装 MySQL教程
在CentOS 7上安装MySQL 8,其实流程很清晰。首先通过官方Yum仓库来安装服务,然后启动并设为开机自启。最重要的环节是首次安全设置:需要先从日志里找到临时密码来登录,再修改成你自己的密码,并为远程连接创建用户和授权。最后,也别忘了在服务器防火墙上放行3306端口,这样远程才能连上。
185 16
|
2月前
|
Linux 网络安全 Apache
针对在Centos/Linux安装Apache过程中出现的常见问题集锦
以上每个问题的解决方案应深入分析错误日志、系统消息和各种配置文件,以找到根本原因并加以解决。务必保持系统和Apache软件包更新到最新版本,以修复已知的bugs和安全漏洞。安装和管理Web服务器是一项需要细致关注和不断学习的任务。随着技术的发展,推荐定期查看官方文档和社区论坛,以保持知识的更新。
179 80
|
1月前
|
存储 关系型数据库 MySQL
在CentOS 8.x上安装Percona Xtrabackup工具备份MySQL数据步骤。
以上就是在CentOS8.x上通过Perconaxtabbackup工具对Mysql进行高效率、高可靠性、无锁定影响地实现在线快速全量及增加式数据库资料保存与恢复流程。通过以上流程可以有效地将Mysql相关资料按需求完成定期或不定期地保存与灾难恢复需求。
151 10
|
2月前
|
人工智能 数据挖掘 Linux
Centos安装Python3.7(亲测可用)
本指南详细介绍了在基于Linux(以CentOS系统为例,使用yum包管理器)的系统上安装Python 3.7版本的完整流程。Python是一种广泛使用的高级编程语言,在各种领域如软件开发、数据分析、人工智能和区块链开发等都有着重要的应用。
293 2
|
1月前
|
运维 网络协议 Linux
CentOS下Bind服务的安装与故障排查
通过以上的步骤,您应该能够在CentOS系统上安装并配置BIND DNS服务,并进行基本的故障排查。
193 0
|
1月前
|
存储 Ubuntu Linux
安卓手机免root安装各种Linux系统:Ubuntu, Centos,Kali等
此外还可以安装Slackware、Archstrike等系统,还可以通过github查找方法安装更多有趣的东西。 昨日小编就是通过Termux安装的Kali Linux工具包。