备案控制台
探索云世界
开发者社区 安全 文章 正文

CentOS7中安装Tableau Server 2019.3踩坑指南

2019-10-17 3156
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： 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

基础的操作步骤

https://www.tableau.com/zh-cn/learn/starter-kits/publish/server

讲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
文章标签：
Linux
网络安全
数据安全/隐私保护
关键词：
CentOS安装
阿姆斯特芬
目录
相关文章
vzmvmwcrnweq2
|
1月前
|
Linux 网络安全 数据安全/隐私保护
如何在 VM 虚拟机中安装 CentOS Linux 9 操作系统保姆级教程（附链接）
如何在 VM 虚拟机中安装 CentOS Linux 9 操作系统保姆级教程（附链接）
vzmvmwcrnweq2
170 0
1932836719192345
|
2月前
|
关系型数据库 MySQL Linux
centos7.0环境下安装MySql_8.0.12
centos7.0环境下安装MySql_8.0.12
1932836719192345
269 2
图灵重生我名苏泽
|
1月前
|
存储 JavaScript Linux
Linux环境下安装nmp（Centos环境）保姆级教学 一步到位
Linux环境下安装nmp（Centos环境）保姆级教学 一步到位
图灵重生我名苏泽
53 1
渐暖
|
3天前
|
Linux
centos 6.5安装yum
centos 6.5安装yum
渐暖
22 0
XPcode7
|
3天前
|
运维 网络协议 Linux
【运维系列】Centos7安装并配置PXE服务
PXE是Intel开发的预启动执行环境，允许工作站通过网络从远程服务器启动操作系统。它依赖DHCP分配IP，DNS服务分配主机名，TFTP提供引导程序，HTTP/FTP/NFS提供安装源。要部署PXE服务器，需关闭selinux和防火墙，安装dhcpd、httpd、tftp、xinetd及相关服务，配置引导文件和Centos7安装源。最后，通过syslinux安装引导文件，并创建pxelinux.cfg/default配置文件来定义启动参数。
XPcode7
15 0
XPcode7
|
3天前
|
运维 网络协议 Linux
【运维系列】Centos7安装并配置postfix服务
安装CentOS7的Postfix和Dovecot，配置Postfix的`main.cf`文件，包括修改完全域名、允许所有IP、启用邮箱等。然后，配置Dovecot的多个配置文件以启用auth服务和调整相关设置。重启Postfix和Dovecot，设置开机自启，并关闭防火墙进行测试。最后，创建邮箱账户并在Windows邮箱客户端中添加账户设置。
XPcode7
10 0
XPcode7
|
3天前
|
Linux 网络安全
Centos6.5安装并配置NFS服务
该内容描述了在Linux系统中设置NFS服务的步骤。首先挂载yum源，然后安装NFS服务，并编辑配置文件。接着，重启rpcbind和NFS服务，可能需要重复此过程以解决初始可能出现的问题。此外，关闭防火墙策略，并再次重启服务。最终，根目录被共享，特定IP网段被允许访问。
XPcode7
9 0
蓝易云
|
4天前
|
存储 Linux 网络安全
centos7使用yum网络安装
这些是使用Yum进行网络安装的基本步骤。根据你的需求，你可以重复步骤3和4来安装其他软件包。请注意，执行Yum操作需要root或具有sudo权限的用户。
蓝易云
16 1
橙子先生
|
10天前
|
关系型数据库 MySQL Linux
centos7安装mysql-带网盘安装包
centos7安装mysql-带网盘安装包
橙子先生
60 2
jianz123
|
16天前
|
存储 Linux Shell
centos 部署docker容器 安装 、基本使用方法（一）
centos 部署docker容器 安装 、基本使用方法（一）
jianz123
32 0

热门文章

最新文章

  • 1
    CentOS8中Docker安装及部署
  • 2
    CentOS 7 下使用yum安装MySQL5.7.20 最简单 图文详解
  • 3
    linux centos7 挂载本地iso yum源
  • 4
    centos6.0下Error:Connectionactivationfailed:DevicenotmanagedbyNetworkManager解决办法
  • 5
    centos7安装mysql-带网盘安装包
  • 6
    Centos7的虚拟机创建流程
  • 7
    Centos7 /etc/sysconfig/network-scripts/ifcfg-＜interface＞网络配置
  • 8
    Centos 防火墙端口控制命令
  • 9
    centos7 Nginx Log日志统计分析 常用命令
  • 10
    Centos7.9的ip更改--详细版
  • 1
    【MYSQL】—— MySQL 在 Centos 7环境安装
    52
  • 2
    服务器Centos7 静默安装Oracle Database 12.2
    86
  • 3
    Flume【部署 02】Flume监控工具Ganglia的安装与配置（CentOS 7.5 在线安装系统监控工具Ganglia + 权限问题处理 + Flume接入监控配置 + 图例说明）
    29
  • 4
    如何在 VM 虚拟机中安装 CentOS Linux 9 操作系统保姆级教程（附链接）
    170
  • 5
    Linux环境下安装nmp（Centos环境）保姆级教学 一步到位
    53
  • 6
    Flume【环境搭建 01】CentOS Linux release 7.5 安装配置 apache-flume-1.9.0 并验证
    34
  • 7
    【VMware安装+centos 7Linux系统+MySQL安装】——在Linux系统中安装MySQL步骤，以及遇见的各种问题（如：vm两个虚拟网卡消失、vm网络适配器有感叹号等等）
    185
  • 8
    阿里云ECS(CentOS镜像)安装docker
    386
  • 9
    【PUSDN】centos查看日志文件内容，包含某个关键字的前后5行日志内容，centos查看日志的几种方法
    49
  • 10
    Centos8下编译安装最新版ffmpeg解决方案（含Centos8换源阿里云）
    156

    • 相关课程

    更多
  • SQL Server on Linux入门教程
  • Linux MySQL服务器搭建与应用
  • 企业Web常用架构LAMP-LNMP实战
  • Linux Web服务器Nginx搭建与配置
  • Linux软件包安装和yum仓库实战

    • 相关电子书

    更多
  • CentOS Nginx PHP JAVA 多语言镜像使用手
  • CentOS Nginx PHP JAVA多语言镜像使用手册
  • 阿里云Elasticsearch2.0发布

    • 相关实验场景

    更多
  • 基于ROS快速部署LNMP环境（CentOS 7）
  • 基于ROS一键安装LAMP环境
  • 手动部署MySQL数据库（CentOS 7）
  • 部署并使用Docker（CentOS 8）
  • 手动搭建FTP站点（CentOS 8）
  • 部署Linux主机管理系统WDCP

    • 推荐镜像

    更多
  • centos
  • centos-vault
  • centos-altarch
    • 下一篇
    部署LAMP环境（Alibaba Cloud Linux 3）