Tableau Server を分散構成でインストールする

#パッケージの更新確認・アップデート
sudo dnf upgrade --releasever=latest
sudo dnf check-upgrade --releasever=latest

# タイムゾーンの変更
sudo timedatectl set-timezone Asia/Tokyo
timedatectl

# ロケールの変更
sudo localectl set-locale LANG=ja_JP.utf8
localectl status

# ホスト名を変更
sudo hostnamectl set-hostname tabsrv-node2
hostnamectl

# nmap-ncat パッケージをインストール
$ sudo dnf install -y nmap-ncat

# tabsrv-node1.test.internal のポート 80 への接続確認
$ nc -zv tabsrv-node1.test.internal 80
Ncat: Version 7.93 ( https://nmap.org/ncat )
Ncat: Connected to 10.0.139.68:80.  
Ncat: 0 bytes sent, 0 bytes received in 0.03 seconds. 

# tabsrv-node1.test.internal のポート 8850 への接続確認
$ nc -zv tabsrv-node1.test.internal 8850
Ncat: Version 7.93 ( https://nmap.org/ncat )
Ncat: Connected to 10.0.139.68:8850.  
Ncat: 0 bytes sent, 0 bytes received in 0.03 seconds. 

$ nc -zv tabsrv-node1 8850
Ncat: Version 7.93 ( https://nmap.org/ncat )
Ncat: Could not resolve hostname "tabsrv-node1": Name or service not known. QUITTING.
$ nc -zv tabsrv-node1 80
Ncat: Version 7.93 ( https://nmap.org/ncat )
Ncat: Could not resolve hostname "tabsrv-node1": Name or service not known. QUITTING.

# 設定変更
$ sudo vi /etc/systemd/resolved.conf

# 設定変更後の内容
$ cat /etc/systemd/resolved.conf
#  This file is part of systemd.
#
#  systemd is free software; you can redistribute it and/or modify it under the
#  terms of the GNU Lesser General Public License as published by the Free
#  Software Foundation; either version 2.1 of the License, or (at your option)
#  any later version.
#
# Entries in this file show the compile time defaults. Local configuration
# should be created by either modifying this file, or by creating "drop-ins" in
# the resolved.conf.d/ subdirectory. The latter is generally recommended.
# Defaults can be restored by simply deleting this file and all drop-ins.
#
# Use 'systemd-analyze cat-config systemd/resolved.conf' to display the full config.
#
# See resolved.conf(5) for details.

[Resolve]
# Some examples of DNS servers which may be used for DNS= and FallbackDNS=:
# Cloudflare: 1.1.1.1#cloudflare-dns.com 1.0.0.1#cloudflare-dns.com 2606:4700:4700::1111#cloudflare-dns.com 2606:4700:4700::1001#cloudflare-dns.com
# Google:     8.8.8.8#dns.google 8.8.4.4#dns.google 2001:4860:4860::8888#dns.google 2001:4860:4860::8844#dns.google
# Quad9:      9.9.9.9#dns.quad9.net 149.112.112.112#dns.quad9.net 2620:fe::fe#dns.quad9.net 2620:fe::9#dns.quad9.net
#DNS=
#FallbackDNS=
Domains=test.internal
#DNSSEC=no
#DNSOverTLS=no
#MulticastDNS=no
#LLMNR=no
#Cache=yes
#CacheFromLocalhost=no
#DNSStubListener=yes
#DNSStubListenerExtra=
#ReadEtcHosts=yes
#ResolveUnicastSingleLabel=no

sudo systemctl restart systemd-resolved.service

$ tail /etc/resolv.conf
#
# Third party programs should typically not access this file directly, but only
# through the symlink at /etc/resolv.conf. To manage man:resolv.conf(5) in a
# different way, replace this symlink by a static file or a different symlink.
#
# See man:systemd-resolved.service(8) for details about the supported modes of
# operation for /etc/resolv.conf.

nameserver 10.0.0.2
search test.internal ec2.internal

$ nc -zv tabsrv-node1 80
Ncat: Version 7.93 ( https://nmap.org/ncat )
Ncat: Connected to 10.0.139.68:80.
Ncat: 0 bytes sent, 0 bytes received in 0.03 seconds.

$ nc -zv tabsrv-node1 8850
Ncat: Version 7.93 ( https://nmap.org/ncat )
Ncat: Connected to 10.0.139.68:8850.
Ncat: 0 bytes sent, 0 bytes received in 0.03 seconds.

aws s3 cp s3://<バケット名>/bootstraps/bootstrap.json .

wget https://downloads.tableau.com/esdalt/2024.2.4/tableau-server-2024-2-4.x86_64.rpm

sudo dnf install tableau-server-2024-2-4.x86_64.rpm

$ tree /opt/tableau -L 2 -d
/opt/tableau
└── tableau_server
    ├── manifests
    └── packages

$ sudo /opt/tableau/tableau_server/packages/scripts.20242.24.1011.1414/initialize-tsm -b bootstrap.json --accepteula --activation-service -d /opt/tableau/data/
Creating environment file...
Creating directories and setting permissions...
Using '/opt/tableau/data' as the data directory.
Adding user 'ec2-user' to group 'tableau'...
Adding user 'ec2-user' 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.
Tableau Server runs best with at least 50 GB of free disk space,
but found only 23 GB for the data directory '/opt/tableau/data'. Continuing.
mount found at : /opt/tableau
Calling node installer...
Node installed successfully
Use the 'tsm' command on the controller node to configure services.
Done.

# jarファイルをダウンロード
wget https://github.com/pgjdbc/pgjdbc/releases/download/REL42.7.4/postgresql-42.7.4.jar
# 指定のディレクトリに配置
sudo mkdir /opt/tableau/tableau_driver/jdbc -p
sudo cp postgresql-42.7.4.jar /opt/tableau/tableau_driver/jdbc
# 権限を構成
## jdbcディレクトリのグループを tableau に変更
sudo chown root:tableau /opt/tableau/tableau_driver/jdbc
## jdbcフォルダに対して、グループに読み取りおよび実行権限を付与
sudo chmod g+rx /opt/tableau/tableau_driver/jdbc
## ファイルのグループをtableauに変更
sudo chgrp tableau /opt/tableau/tableau_driver/jdbc/postgresql-42.7.4.jar
## ファイルのグループに実行権限を付与
sudo chmod 754 /opt/tableau/tableau_driver/jdbc/postgresql-42.7.4.jar

$ ls /opt/tableau/tableau_driver/ -l
合計 0
drwxr-xr-x. 2 root tableau 35 12月 13 14:49 jdbc

$ ls /opt/tableau/tableau_driver/jdbc -l
合計 1064
-rwxr-xr--. 1 root tableau 1086687 12月 13 14:49 postgresql-42.7.4.jar