0. Installer list:
TIB_sfire_server_12.0.1_linux.tar、TIB_sfire_deploy_12.0.1.zip、TIB_sfire_server_12.0.0_languagepack-mul
ti.zip
TIB_sfire-analyst_12.0.1_single_user_win.zip、TIB_sfire-analyst_12.0.1_shared_computer_win.zip、TIB_sfire-analyst_12.0.1_portable_win.zip
TS_client_12.0.2_HF-007.zip
TIB_sf_statsvcs_12.0.1_linux24gl23_x86_64.tar、TIB_terrsrv_1.12.1_linux24gl23_x86_64.tar.gz,
TIB_sf-pysrv_1.12.1_linux24gl23_x86_64.tar.gz
1. create Spotfire account for installation:
sudo adduser spotfire
sudo passwd spotfire
sudo usermod -aG sudo spotfire
2. set the PostgreSQL 14.5.1:
sudo systemctl status postgresql
psql -V
$ su - postgres
$ psql
# ALTER ROLE postgres PASSWORD 'yourPassWord';
sudo vi +60 /etc/postgresql/14/main/postgresql.conf
# like below:
listen_addresses = '*' # what IP address(es) to listen on;
sudo vi +95 /etc/postgresql/14/main/pg_hba.conf
# like below:
# Database administrative login by Unix domain socket
local all postgres md5
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 192.168.x.x/24 md5
host all all 127.0.0.1/32 md5
sudo systemctl restart postgresql
psql –U postgres
3. unzip the installer and run the DB script:
mkdir -p /home/spotfire/spotfire_installer
cd /home/spotfire/spotfire_installer
tar -xvf TIB_sfire_server_12.0.1_linux.tar
cd scripts/postgres_install/
vi create_databases.sh
# Uncomment to set variables:
PGHOST=localhost
PGPORT=5432
DBSERVER_ADMIN_USERNAME=postgres
DBSERVER_ADMIN_PASSWORD=postgres
SPOTFIREDB_DBNAME=spotfire_server
SPOTFIREDB_USERNAME=spotfire
SPOTFIREDB_PASSWORD=spotfire
./create_databases.sh
cat log.txt
4. install Spotfire server:
sudo mkdir -p /opt/tibco/
sudo cp -a ./tss-12.0.1.x86_64.tar.gz /opt/tibco/
cd /opt/tibco/
sudo tar xzf tss-12.0.1.x86_64.tar.gz
cd /opt/tibco/tss-12.0.1.x86_64/
sudo ./configure -s 80 -r 9080 -b 9443
sudo ./configure-boot
vi tomcat/spotfire-bin/simple-config.txt
# Before using this script you need to set the variables below:
set SPOTFIREDB_DRIVER = "org.postgresql.Driver"
set SPOTFIREDB_URL = "jdbc:postgresql://localhost:5432/spotfire_server"
# set SPOTFIREDB_DRIVER = "tibcosoftwareinc.jdbc.oracle.OracleDriver"
# set SPOTFIREDB_URL = "jdbc:tibcosoftwareinc:oracle://<server>:<port>;SID=<SID>"
#set SPOTFIREDB_URL = "jdbc:tibcosoftwareinc:oracle://<server>:<port>;ServiceName=<pdborcl.example.com>"
#set SPOTFIREDB_DRIVER = "tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver"
#set SPOTFIREDB_URL = "jdbc:tibcosoftwareinc:sqlserver://<server>:<port>;DatabaseName=<database name>"
#set SPOTFIREDB_DRIVER = "org.postgresql.Driver"
#set SPOTFIREDB_URL = "jdbc:postgresql://<server>:<port>/<database name>"
set SPOTFIREDB_USERNAME = "spotfire"
set SPOTFIREDB_PASSWORD = "spotfire"
set CONFIG_TOOL_PASSWORD = "spotfire"
set ADMIN_USERNAME = "spotfire"
set ADMIN_PASSWORD = "spotfire"
cd /opt/tibco/tss-12.0.1.x86_64/tomcat/spotfire-bin/
./config.sh run simple-config.txt
sudo systemctl enable tss-12.0.1.service
./uiconfig.sh
fill in the information below:
Hostname: localhost
SID: spotfire_server
Username: spotfire
Password: spotfire
Address:
192.168.137.157
hostname
then create an admin user in Spotfire.
sudo systemctl restart tss-12.0.1.service
5. Install node manager:
cd /home/spotfire/spotfire_installer
sudo cp -a ./tsnm-12.0.1.x86_64.tar.gz /opt/tibco/
sudo tar zxf ./tsnm-12.0.1.x86_64.tar.gz
cd /opt/tibco/tsnm-12.0.1.x86_64/
ip a
sudo ./configure -m 9081 -c 9444 -s 192.168.137.157 -r 9080 -b 9443 -n 192.168.137.157
sudo ./configure-boot
sudo systemctl enable tsnm-12.0.0.service
sudo systemctl start tsnm-12.0.1.service
cd /home/spotfire/spotfire_installer
wget https://packages.microsoft.com/config/debian/11/packages-microsoft-prod.deb -O packages-microsoft-prod.deb
sudo dpkg -i packages-microsoft-prod.deb
sudo apt-get update && sudo apt-get install -y aspnetcore-runtime-6.0
sudo apt-get -y install xvfb
wget -c http://ftp.jp.debian.org/debian/pool/main/g/giflib/libgif7_5.2.1-2.5_amd64.deb
sudo dpkg -i libgif7_5.2.1-2.5_amd64.deb
6. Install and config web player, automation service, Terr, and Python service:
unzip the installer and deploy it to Spotfire.
sudo tar zxf TIB_sf-pysrv_1.12.1_linux24gl23_x86_64.tar.gz
sudo tar xzf TIB_terrsrv_1.12.1_linux24gl23_x86_64.tar.gz
do the config:
Web Player:
./config.sh export-service-config --capability=WEB_PLAYER --deployment-area=Production
cd config/root
vi +259 ./Spotfire.Dxp.Worker.Host.dll.config
<setting name='AllowAllFilePaths' serializeAs='String'>
<value>True</value>
</setting>
cd ../../
./config.sh import-service-config --config-name=webplayersrv
mv config ./webplayersrvconfig
Python Service:
./config.sh export-service-config --capability=PYTHON --deployment-area=Production
cd config/root/conf
vi +60 custom.properties
use.engine.containers: FALSE
cd /opt/tibco/tss-12.0.1.x86_64/tomcat/spotfire-bin
./config.sh import-service-config --config-name=pysrv
mv config ./pysrvconfig
TERR Service:
sudo tar xzf TIB_terrsrv_1.12.2_linux24gl23_x86_64.tar.gz
cd /opt/tibco/tss-12.0.1.x86_64/tomcat/spotfire-bin
./config.sh export-service-config --capability=TERR --deployment-area=Production
cd config/root/conf
vi +56 custom.properties
terr.restricted.execution.mode: FALSE
vi +63 custom.properties
use.engine.containers: FALSE
cd ../../../
./config.sh import-service-config --config-name=terrsrv
mv config ./terrsrvconfig
7. lessen the stop time of spotfire server service:
sudo vi /lib/systemd/system/spotfireserver-14.0.0.service
Then edit to add TimeoutStopSec:
[Service]
Type=forking
...
ExecStop="/opt/spotfire/spotfireserver-14.0.0.x86_64/tomcat/bin/shutdown.sh"
TimeoutStopSec=30s
sudo systemctl daemon-reload
sudo systemctl restart spotfireserver-14.0.0
KAGAYA's Blog 