1. make spotfire account in Linux
adduser spotfire
passwd spotfire
2. make the account as sudoer
visudo
add spotfire as the sudoer in the block: Allow root to run any commands anywhere
## Allow root to run any commands anywhere
root ALL=(ALL) ALL
spotfire ALL=(ALL) ALL
3. install the postgreSQL
sudo yum install postgresql-server postgresql-contrib
sudo postgresql-setup initdb
sudo systemctl enable postgresql
sudo systemctl start postgresql
sudo passwd postgres
su - postgres
psql postgres
set the IPv4 local connections and password authority if necessary, METHOD -> md5
sudo vi /var/lib/pgsql/data/pg_hba.conf
restart the postgresql service
sudo systemctl restart postgresql
4. login as spotfire, and download the spotfire installer, unzip it
tar -xvf TIB_sfire_server_12.0.0_linux.tar
5. creat databases for spotfire server
change the content in /scripts/postgres_install/create_databases.sh as below:
# Uncomment to set variables:
PGHOST=localhost
PGPORT=5432
DBSERVER_ADMIN_USERNAME=postgres
DBSERVER_ADMIN_PASSWORD=manager2
SPOTFIREDB_DBNAME=spotfire_server
SPOTFIREDB_USERNAME=spotfire
SPOTFIREDB_PASSWORD=spotfire
execute it
postgres_install$./create_databases.sh
you got log as below:
CREATE DATABASE
CREATE ROLE
ALTER DATABASE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE VIEW
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE TABLE
ALTER TABLE
CREATE INDEX
ALTER TABLE
CREATE INDEX
CREATE INDEX
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
ALTER TABLE
CREATE FUNCTION
CREATE FUNCTION
CREATE TRIGGER
CREATE TRIGGER
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE VIEW
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE VIEW
CREATE FUNCTION
CREATE FUNCTION
CREATE TRIGGER
CREATE TRIGGER
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE VIEW
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
ALTER TABLE
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE INDEX
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE VIEW
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE VIEW
CREATE TABLE
CREATE INDEX
CREATE TABLE
psql:create_server_db.sql:913: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:913: NOTICE: type reference lib_current_items.version_id%TYPE converted to character
psql:create_server_db.sql:913: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:913: NOTICE: type reference lib_current_items.version_id%TYPE converted to character
psql:create_server_db.sql:913: NOTICE: type reference lib_current_items.parent_id%TYPE converted to character
psql:create_server_db.sql:913: NOTICE: type reference lib_current_items.modified_by%TYPE converted to character
psql:create_server_db.sql:913: NOTICE: type reference lib_current_items.title%TYPE converted to character varying
CREATE FUNCTION
psql:create_server_db.sql:943: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:943: NOTICE: type reference lib_current_items.parent_id%TYPE converted to character
psql:create_server_db.sql:943: NOTICE: type reference lib_current_items.modified_by%TYPE converted to character
psql:create_server_db.sql:943: NOTICE: type reference lib_current_items.title%TYPE converted to character varying
CREATE FUNCTION
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.title%TYPE converted to character varying
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.description%TYPE converted to character varying
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.item_type%TYPE converted to character
psql:create_server_db.sql:1111: NOTICE: type reference lib_item_versions.format_version%TYPE converted to character varying
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.created_by%TYPE converted to character
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.created%TYPE converted to timestamp without time zone
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.modified_by%TYPE converted to character
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.modified%TYPE converted to timestamp without time zone
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.accessed%TYPE converted to timestamp without time zone
psql:create_server_db.sql:1111: NOTICE: type reference lib_data.content_size%TYPE converted to bigint
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.parent_id%TYPE converted to character
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.hidden%TYPE converted to boolean
psql:create_server_db.sql:1111: NOTICE: type reference lib_current_items.version_id%TYPE converted to character
psql:create_server_db.sql:1111: NOTICE: type reference lib_data.data_id%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:1155: NOTICE: type reference lib_resolved_depend_ver.dependent_version_id%TYPE converted to character
psql:create_server_db.sql:1155: NOTICE: type reference lib_resolved_depend_ver.required_id%TYPE converted to character
psql:create_server_db.sql:1155: NOTICE: type reference lib_resolved_depend_ver.description%TYPE converted to character varying
psql:create_server_db.sql:1155: NOTICE: type reference lib_resolved_depend_ver.cascading_delete%TYPE converted to boolean
psql:create_server_db.sql:1155: NOTICE: type reference lib_resolved_depend_ver.original_required_id%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:1209: NOTICE: type reference lib_access.item_id%TYPE converted to character
psql:create_server_db.sql:1209: NOTICE: type reference lib_access.user_id%TYPE converted to character
psql:create_server_db.sql:1209: NOTICE: type reference lib_access.permission%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:1290: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:1290: NOTICE: type reference lib_current_items.modified_by%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:1440: NOTICE: type reference lib_current_items.version_id%TYPE converted to character
psql:create_server_db.sql:1440: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:1440: NOTICE: type reference lib_current_items.title%TYPE converted to character varying
psql:create_server_db.sql:1440: NOTICE: type reference lib_current_items.description%TYPE converted to character varying
psql:create_server_db.sql:1440: NOTICE: type reference lib_current_items.item_type%TYPE converted to character
psql:create_server_db.sql:1440: NOTICE: type reference lib_item_versions.data_id%TYPE converted to character
psql:create_server_db.sql:1440: NOTICE: type reference lib_item_versions.format_version%TYPE converted to character varying
psql:create_server_db.sql:1440: NOTICE: type reference lib_current_items.parent_id%TYPE converted to character
psql:create_server_db.sql:1440: NOTICE: type reference lib_current_items.hidden%TYPE converted to boolean
psql:create_server_db.sql:1440: NOTICE: type reference lib_current_items.created_by%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:1529: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:1529: NOTICE: type reference lib_current_items.version_id%TYPE converted to character
psql:create_server_db.sql:1529: NOTICE: type reference lib_current_items.title%TYPE converted to character varying
psql:create_server_db.sql:1529: NOTICE: type reference lib_current_items.description%TYPE converted to character varying
psql:create_server_db.sql:1529: NOTICE: type reference lib_item_versions.data_id%TYPE converted to character
psql:create_server_db.sql:1529: NOTICE: type reference lib_item_versions.format_version%TYPE converted to character varying
psql:create_server_db.sql:1529: NOTICE: type reference lib_current_items.hidden%TYPE converted to boolean
psql:create_server_db.sql:1529: NOTICE: type reference lib_current_items.modified_by%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:1681: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:1681: NOTICE: type reference lib_current_items.modified_by%TYPE converted to character
CREATE FUNCTION
CREATE FUNCTION
psql:create_server_db.sql:1742: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:1742: NOTICE: type reference lib_current_items.version_id%TYPE converted to character
psql:create_server_db.sql:1742: NOTICE: type reference lib_current_items.version_id%TYPE converted to character
psql:create_server_db.sql:1742: NOTICE: type reference lib_current_items.modified_by%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:1796: NOTICE: type reference lib_item_versions.item_id%TYPE converted to character
psql:create_server_db.sql:1796: NOTICE: type reference lib_item_versions.version_id%TYPE converted to character
psql:create_server_db.sql:1796: NOTICE: type reference lib_current_items.modified_by%TYPE converted to character
CREATE FUNCTION
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
ALTER TABLE
CREATE INDEX
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
ALTER TABLE
CREATE TABLE
CREATE INDEX
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:create_server_db.sql:2513: NOTICE: type reference routing_rules.id%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:2557: NOTICE: type reference routing_rules.id%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:2619: NOTICE: type reference users.user_id%TYPE converted to character
psql:create_server_db.sql:2619: NOTICE: type reference lib_current_items.item_id%TYPE converted to character
psql:create_server_db.sql:2619: NOTICE: type reference sites.site_id%TYPE converted to character
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.id%TYPE converted to character
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.name%TYPE converted to character varying
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.lib_item_id%TYPE converted to character
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.group_id%TYPE converted to character
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.user_id%TYPE converted to character
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.resource_pool_id%TYPE converted to character
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.priority%TYPE converted to integer
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.status%TYPE converted to smallint
psql:create_server_db.sql:2619: NOTICE: type reference routing_rules.type%TYPE converted to character
CREATE FUNCTION
psql:create_server_db.sql:2648: NOTICE: type reference sites.site_id%TYPE converted to character
CREATE FUNCTION
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE INDEX
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE VIEW
CREATE VIEW
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
6. copy it to /opt/tibco/ and unzip it
mkdir -p /opt/tibco/
sudo cp -a ./tss-12.0.0.x86_64.tar.gz /opt/tibco/
sudo tar xzf tss-12.0.0.x86_64.tar.gz
if you don’t unzip to /opt/tibco there will be error like:
$sudo systemctl status tss-12.0.0.service
● tss-12.0.0.service - TIBCO Spotfire Server 12.0.0
Loaded: loaded (/usr/lib/systemd/system/tss-12.0.0.service; disabled; vendor preset: disabled)
Active: activating (auto-restart) (Result: exit-code) since Fri 2022-07-29 18:23:51 JST; 5s ago
Process: 3768 ExecStartPre=/bin/chown -R spotfire:spotfire /home/spotfire/tss-12.0.0.x86_64 (code=exited, status=0/SUCCESS)
Process: 3769 ExecStart=/home/spotfire/tss-12.0.0.x86_64/tomcat/bin/startup.sh (code=exited, status=203/EXEC)
CPU: 13ms
$ journalctl -xeu tss-12.0.0.service
░░ Subject: A start job for unit tss-12.0.0.service has begun execution
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ A start job for unit tss-12.0.0.service has begun execution.
░░
░░ The job identifier is 16127.
Aug 16 18:25:53 rocky9 systemd[3908]: tss-12.0.0.service: Failed to locate executable /home/spotfire/tss-12.0.0.x86_64/tomcat/bin/startup.sh: Permission denied
░░ Subject: Process /home/spotfire/tss-12.0.0.x86_64/tomcat/bin/startup.sh could not be executed
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ The process /home/spotfire/tss-12.0.0.x86_64/tomcat/bin/startup.sh could not be executed and failed.
░░
░░ The error number returned by this process is ERRNO.
Aug 16 18:25:53 rocky9 systemd[3908]: tss-12.0.0.service: Failed at step EXEC spawning /home/spotfire/tss-12.0.0.x86_64/tomcat/bin/startup.sh: Permission denied
░░ Subject: Process /home/spotfire/tss-12.0.0.x86_64/tomcat/bin/startup.sh could not be executed
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ The process /home/spotfire/tss-12.0.0.x86_64/tomcat/bin/startup.sh could not be executed and failed.
░░
░░ The error number returned by this process is ERRNO.
Aug 16 18:25:53 rocky9 systemd[1]: tss-12.0.0.service: Control process exited, code=exited, status=203/EXEC
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ An ExecStart= process belonging to unit tss-12.0.0.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 203.
Aug 16 18:25:53 rocky9 systemd[1]: tss-12.0.0.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ The unit tss-12.0.0.service has entered the 'failed' state with result 'exit-code'.
Aug 16 18:25:53 rocky9 systemd[1]: Failed to start TIBCO Spotfire Server 12.0.0.
░░ Subject: A start job for unit tss-12.0.0.service has failed
░░ Defined-By: systemd
░░ Support: https://access.redhat.com/support
░░
░░ A start job for unit tss-12.0.0.service has finished with a failure.
░░
░░ The job identifier is 16127 and the job result is failed.
7. install spotfire server
/opt/tibco/tss-12.0.0.x86_64$sudo ./configure -s 80 -r 9080 -b 9443
Then it says: Post install configuration of TIBCO Spotfire Server 12.0.0 was successful.
/opt/tibco/tss-12.0.0.x86_64$sudo ./configure-boot
Then it says: TIBCO Spotfire Server 12.0.0 has been successfully configured to start on system boot.
8. set the db driver in the uiconfig.
/opt/tibco/tss-12.0.0.x86_64$vi tomcat/spotfire-bin/simple-config.txt
edit it as below:
# 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_USERNAME = "spotfire"
set SPOTFIREDB_PASSWORD = "spotfire"
set CONFIG_TOOL_PASSWORD = "spotfire"
set ADMIN_USERNAME = "spotfire"
set ADMIN_PASSWORD = "spotfire"
Then execute to set the db driver information.
cd tomcat/spotfire-bin/
spotfire-bin$./config.sh run simple-config.txt
log is as below:
Creating the database connection configuration
Successfully created the bootstrap configuration file /opt/tibco/tss-12.0.0.x86_64/tomcat/webapps/spotfire/WEB-INF/bootstrap.xml
The following addresses were automatically configured for the server:
rocky9
192.168.81.152
To update the addresses please use the 'set-addresses' command.
Creating the default configuration
Successfully exported the default server configuration to file /opt/tibco/tss-12.0.0.x86_64/tomcat/spotfire-bin/configuration.xml
Importing the configuration
Successfully imported the server configuration with hash: 727d5529f9d780c08f5c0500425cb293c0006fa4
The imported configuration has been set as active.
Don't forget to deploy client packages to the server.
See the TIBCO Spotfire Deployment and Administration Manual for more information.
Creating the 'spotfire' user to become administrator
Successfully created the new user 'spotfire'
Promoting the user 'spotfire' to administrator
Successfully assigned administrator privileges to the 'spotfire' user
9. set it as start automatically
sudo systemctl enable tss-12.0.0.service
sudo systemctl start tss-12.0.0.service
Now we should see the spotfire server console webpage.
10. Then upload the package
Deployment Area: Linux
Spotfire.Dxp.netcore-linux.sdn
Spotfire.Dxp.NodeManagerLinux.sdn
ja-JP-netcore.sdnDeployment Area: Windows
Spotfire.Dxp.sdn
Spotfire.Dxp.NodeManagerWindows.sdn
ja-JP.sdnWindows DA is for spotfire analyst on windows
11. copy tsnm-12.0.0.x86_64.tar.gz to /opt/tibco/ and then unzip it
sudo cp -a tsnm-12.0.0.x86_64.tar.gz /opt/tibco/
/opt/tibco$sudo tar zxf ./tsnm-12.0.0.x86_64.tar.gz
12. install Node Manager
/opt/tibco$cd tsnm-12.0.0.x86_64/
/opt/tibco/tsnm-12.0.0.x86_64$sudo ./configure -m 9081 -c 9444 -s 192.168.81.152 -r 9080 -b 9443 -n 192.168.81.152
log: Post install configuration of TIBCO Spotfire Server Node Manager 12.0.0 was successful.
sudo ./configure-boot
log: TIBCO Spotfire Server Node Manager 12.0.0 has been successfully configured to start on system boot.
13. set Node Manager start automatically
sudo systemctl enable tsnm-12.0.0.service
sudo systemctl start tsnm-12.0.0.service
14. in the spotfire server web console page, Nodes&Services->Untrusted nodes to trust the node
15. Install .Net
Install the .NET Runtime on CentOS
sudo dnf install aspnetcore-runtime-6.0
log:
Dependencies resolved.
===============================================================================
Package Arch Version Repository Size
===============================================================================
Installing:
aspnetcore-runtime-6.0 x86_64 6.0.8-1.el9_0 appstream 7.6 M
Installing dependencies:
dotnet-host x86_64 6.0.8-1.el9_0 appstream 159 k
dotnet-hostfxr-6.0 x86_64 6.0.8-1.el9_0 appstream 164 k
dotnet-runtime-6.0 x86_64 6.0.8-1.el9_0 appstream 23 M
lttng-ust x86_64 2.12.0-6.el9 appstream 282 k
Transaction Summary
===============================================================================
Install 5 Packages
Total download size: 31 M
Installed size: 89 M
Is this ok [y/N]: Y
Downloading Packages:
(1/5): dotnet-hostfxr-6.0-6.0.8-1.el9_0.x86_64.rpm 219 kB/s | 164 kB 00:00
(2/5): dotnet-host-6.0.8-1.el9_0.x86_64.rpm 162 kB/s | 159 kB 00:00
(3/5): lttng-ust-2.12.0-6.el9.x86_64.rpm 1.1 MB/s | 282 kB 00:00
[MIRROR] aspnetcore-runtime-6.0-6.0.8-1.el9_0.x86_64.rpm: Curl error (56): Failure when receiving data from the peer for https://ftp.jaist.ac.jp/pub/Linux/rocky/9.0/AppStream/x86_64/os/Packages/a/aspnetcore-runtime-6.0-6.0.8-1.el9_0.x86_64.rpm [OpenSSL SSL_read: Connection reset by peer, errno 104]
(4/5): aspnetcore-runtime-6.0-6.0.8-1.el9_0.x86_64.rpm 652 kB/s | 7.6 MB 00:11
(5/5): dotnet-runtime-6.0-6.0.8-1.el9_0.x86_64. 53% [========================- ] 1.9 MB/s | 17 MB 00:07 ETA
(5/5): dotnet-runtime-6.0-6.0.8-1.el9_0.x86_64. 53% [========================- ] 1.9 MB/s | 17 MB 00:07 ETA
[MIRROR] dotnet-runtime-6.0-6.0.8-1.el9_0.x86_64.rpm: Curl error (28): Timeout was reached for https://ftp.jaist.ac.jp/pub/Linux/rocky/9.0/AppStream/x86_64/os/Packages/d/dotnet-runtime-6.0-6.0.8-1.el9_0.x86_64.rpm [Operation too slow. Less than 1000 bytes/sec transferred the last 30 seconds]
(5/5): dotnet-runtime-6.0-6.0.8-1.el9_0.x86_64.rpm 446 kB/s | 23 MB 00:52
-------------------------------------------------------------------------------------------------------------------------------------
Total 595 kB/s | 31 MB 00:53
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : lttng-ust-2.12.0-6.el9.x86_64 1/5
Installing : dotnet-host-6.0.8-1.el9_0.x86_64 2/5
Installing : dotnet-hostfxr-6.0-6.0.8-1.el9_0.x86_64 3/5
Installing : dotnet-runtime-6.0-6.0.8-1.el9_0.x86_64 4/5
Installing : aspnetcore-runtime-6.0-6.0.8-1.el9_0.x86_64 5/5
Running scriptlet: aspnetcore-runtime-6.0-6.0.8-1.el9_0.x86_64 5/5
Verifying : dotnet-runtime-6.0-6.0.8-1.el9_0.x86_64 1/5
Verifying : dotnet-hostfxr-6.0-6.0.8-1.el9_0.x86_64 2/5
Verifying : dotnet-host-6.0.8-1.el9_0.x86_64 3/5
Verifying : aspnetcore-runtime-6.0-6.0.8-1.el9_0.x86_64 4/5
Verifying : lttng-ust-2.12.0-6.el9.x86_64 5/5
Installed:
aspnetcore-runtime-6.0-6.0.8-1.el9_0.x86_64 dotnet-host-6.0.8-1.el9_0.x86_64 dotnet-hostfxr-6.0-6.0.8-1.el9_0.x86_64
dotnet-runtime-6.0-6.0.8-1.el9_0.x86_64 lttng-ust-2.12.0-6.el9.x86_64
Complete!
confirm dotnet version
dotnet --list-runtimes
log:
Microsoft.AspNetCore.App 6.0.8 [/usr/lib64/dotnet/shared/Microsoft.AspNetCore.App]
Microsoft.NETCore.App 6.0.8 [/usr/lib64/dotnet/shared/Microsoft.NETCore.App]
16. install xvfb
sudo yum install -y xorg-x11-server-Xvfb
log:
Last metadata expiration check: 0:39:32 ago on Thu 18 Aug 2022 11:43:14 AM JST.
Dependencies resolved.
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
xorg-x11-server-Xvfb x86_64 1.20.11-10.el9 appstream 894 k
Transaction Summary
================================================================================
Install 1 Package
Total download size: 894 k
Installed size: 2.0 M
Is this ok [y/N]: y
Downloading Packages:
xorg-x11-server-Xvfb-1.20.11-10.el9.x86_64.rpm 1.2 MB/s | 894 kB 00:00
--------------------------------------------------------------------------------
Total 547 kB/s | 894 kB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : xorg-x11-server-Xvfb-1.20.11-10.el9.x86_64 1/1
Running scriptlet: xorg-x11-server-Xvfb-1.20.11-10.el9.x86_64 1/1
Verifying : xorg-x11-server-Xvfb-1.20.11-10.el9.x86_64 1/1
Installed:
xorg-x11-server-Xvfb-1.20.11-10.el9.x86_64
Complete!
17. install web player instance
error if you haven’y install .net:
Status notified as FAILED. The service exited with error code 127. Recent Logs:/usr/bin/xvfb-run: line 181: dotnet: command not found
error if you haven’y install xvfb:
Status notified as FAILED. The service exited with error code 127. Recent Logs: Error: /opt/tibco/tsnm-12.0.0.x86_64//nm/services/WebWorker NET Core-56.0.17330.5624-daaf80d7-f5d2-4972-9f3f-eb06f4071c33/Spotfire.Dxp.Worker.Host.sh:line5:xvfb-run:command not found
KAGAYA's Blog 