tibco spotfire server 7 · this document contains confidential information that is subject to u.s....

TIBCO Spotfire® Server 7.0

Quick Start Guide

Revision date: May 2017

Important Information

SOME TIBCO SOFTWARE EMBEDS OR BUNDLES OTHER TIBCO SOFTWARE. USE OF SUCH

EMBEDDED OR BUNDLED TIBCO SOFTWARE IS SOLELY TO ENABLE THE FUNCTIONALITY

(OR PROVIDE LIMITED ADD-ON FUNCTIONALITY) OF THE LICENSED TIBCO SOFTWARE.

THE EMBEDDED OR BUNDLED SOFTWARE IS NOT LICENSED TO BE USED OR ACCESSED BY ANY OTHER TIBCO SOFTWARE OR FOR ANY OTHER PURPOSE.

USE OF TIBCO SOFTWARE AND THIS DOCUMENT IS SUBJECT TO THE TERMS AND

CONDITIONS OF A LICENSE AGREEMENT FOUND IN EITHER A SEPARATELY EXECUTED

SOFTWARE LICENSE AGREEMENT, OR, IF THERE IS NO SUCH SEPARATE AGREEMENT,

THE CLICKWRAP END USER LICENSE AGREEMENT WHICH IS DISPLAYED DURING

DOWNLOAD OR INSTALLATION OF THE SOFTWARE (AND WHICH IS DUPLICATED IN THE

LICENSE FILE) OR IF THERE IS NO SUCH SOFTWARE LICENSE AGREEMENT OR

CLICKWRAP END USER LICENSE AGREEMENT, THE LICENSE(S) LOCATED IN THE

“LICENSE” FILE(S) OF THE SOFTWARE. USE OF THIS DOCUMENT IS SUBJECT TO THOSE

TERMS AND CONDITIONS, AND YOUR USE HEREOF SHALL CONSTITUTE ACCEPTANCE OF

AND AN AGREEMENT TO BE BOUND BY THE SAME.

This document contains confidential information that is subject to U.S. and international copyright laws

and treaties. No part of this document may be reproduced in any form without the written authorization of TIBCO Software Inc.

TIBCO, TIBCO Spotfire, TIBCO Spotfire Server, TIBCO Spotfire Web Player, and TIBCO Spotfire

Automation Services are either registered trademarks or trademarks of TIBCO Software Inc. and/or

subsidiaries of TIBCO Software Inc. in the United States and/or other countries. All other product and

company names and marks mentioned in this document are the property of their respective owners and are mentioned for identification purposes only.

TIBCO Spotfire is covered by U.S. Patent No. 6,014,661 and U.S. Patent No. 7, 216, 116. Other patent(s) pending.

THIS SOFTWARE MAY BE AVAILABLE ON MULTIPLE OPERATING SYSTEMS. HOWEVER,

NOT ALL OPERATING SYSTEM PLATFORMS FOR A SPECIFIC SOFTWARE VERSION ARE

RELEASED AT THE SAME TIME. SEE THE README FILE FOR THE AVAILABILITY OF THIS

SOFTWARE VERSION ON A SPECIFIC OPERATING SYSTEM PLATFORM.

THIS DOCUMENT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER

EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT.

THIS DOCUMENT COULD INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL

ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN; THESE

CHANGES WILL BE INCORPORATED IN NEW EDITIONS OF THIS DOCUMENT. TIBCO

SOFTWARE INC. MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE PRODUCT(S)

AND/OR THE PROGRAM(S) DESCRIBED IN THIS DOCUMENT AT ANY TIME.

THE CONTENTS OF THIS DOCUMENT MAY BE MODIFIED AND/OR QUALIFIED, DIRECTLY

OR INDIRECTLY, BY OTHER DOCUMENTATION WHICH ACCOMPANIES THIS SOFTWARE, INCLUDING BUT NOT LIMITED TO ANY RELEASE NOTES AND "READ ME" FILES.

Copyright © 1996 - 2017 TIBCO Software Inc. ALL RIGHTS RESERVED.

TIBCO Software Inc. Confidential Information

iii (43)

TIBCO Spotfire System Overview ............................................................................................ 4

Steps to Get Spotfire Server Up and Running .................................................................. 5

Spotfire Server on Windows ..................................................................................................... 6

Set Up the Spotfire Database ............................................................................................ 6 Oracle on Windows .............................................................................................................. 6 Microsoft SQL Server on Windows ....................................................................................... 7

Install Spotfire Server ........................................................................................................ 9

Configure Spotfire Server ................................................................................................ 17 Create the bootstrap.xml File .............................................................................................. 17 Create and Save a Basic Configuration .............................................................................. 20 Create a User and Promote to Administrator ...................................................................... 21 Deploy Client Packages to Spotfire Server ......................................................................... 23

Start Spotfire Server ......................................................................................................... 23

Spotfire Server on Linux ......................................................................................................... 24

Set Up the Spotfire Database .......................................................................................... 24 Oracle on Linux .................................................................................................................. 24

Install Spotfire Server ...................................................................................................... 25 Install Spotfire Server Using a Graphical User Interface ..................................................... 25 Install Spotfire Server Using a Command Line Interface ..................................................... 28

Configure Spotfire Server ................................................................................................ 30 Create the bootstrap.xml File .............................................................................................. 30 Create and Save a Basic Configuration .............................................................................. 34 Create a User and Promote to Administrator ...................................................................... 37 Deploy Client Packages to Spotfire Server ......................................................................... 40

Start Spotfire Server ......................................................................................................... 42

How to Check If Your Linux Server Has a GUI ...................................................................... 43

TIBCO Spotfire Server Overview

4 (43)

TIBCO Spotfire System Overview The TIBCO Spotfire® Server is used by TIBCO Spotfire®, TIBCO Spotfire® Web Player, and

TIBCO Spotfire® Automation Services to identify users and assign privileges, and it serves as a

central storage for settings, preferences, updates, and analyses.

Overview TIBCO Spotfire Server

5 (43)

Steps to Get Spotfire Server Up and Running

The purpose of this document is to outline the steps necessary to install and configure

the Spotfire® Server on a Windows or Linux operating system.

This configuration gets the Spotfire Server up and running, but no integration with

other systems is set up. In many cases additional configuration will be required. For

instructions on additional configuration, see the TIBCO Spotfire Server Installation

and Configuration Manual.

Note: Prior to installing Spotfire Server, verify that your system complies with the

latest system requirements at http://support.spotfire.com/sr.asp.

Installation

Supported: Oracle® and Microsoft® SQL Server® database engines.

64 bit only.

The bootstrap file provides the database connection information.

Saving the configuration is the default minimum action.

Administration

1. Set up the Spotfire database

2. Run the Spotfire Server installer

3. Create the bootstrap.xml file

4. Create and save a basic Spotfire Server configuration

5. Create a user and promote to Administrator

6. Deploy client packages to Spotfire Server

7. Start Spotfire Server

http://support.spotfire.com/sr.asp

TIBCO Spotfire Server Windows operating system

6 (43)

Spotfire Server on Windows

Set Up the Spotfire Database Assistance from your database administrator may be required to copy the install folder

to the database and to provide information about the database variables.

Note: Make sure to provide all information indicated in the installation scripts.

Oracle on Windows

1. Copy the oracle_install folder from <Spotfire Server Installation Kit>\scripts folder

to the database server.

2. Edit the create_databases.bat file and provide the appropriate database server details

in the section under “Set these variables to reflect the local environment”:

Before modifications:

rem Set these variables to reflect the local environment:

set ROOTFOLDER=<ROOTFOLDER>

set CONNECTIDENTIFIER=<SID>

set ADMINNAME=system

set ADMINPASSWORD=<ADMINPASSWORD>

set SERVERDB_USER=<SERVERDB_USER>

set SERVERDB_PASSWORD=<SERVERDB_PASSWORD>

set SERVER_DATA_TABLESPACE=SPOTFIRE_DATA

set SERVER_TEMP_TABLESPACE=SPOTFIRE_TEMP

Example of how it could look after modifications:

rem Set these variables to reflect the local environment:

set ROOTFOLDER=C:\oracle\app\orcl

set CONNECTIDENTIFIER=orcl

set ADMINNAME=system

set ADMINPASSWORD=admin123

set SERVERDB_USER=spotfire_db

set SERVERDB_PASSWORD=spotfire_db123

set SERVER_DATA_TABLESPACE=SPOTFIRE_DATA

set SERVER_TEMP_TABLESPACE=SPOTFIRE_TEMP

ROOTFOLDER The location where the tablespaces will be

created. It must be a directory that is writable for

the Oracle instance, usually <oracle install

dir>/oradata/<SID>.

Note: Do not add a slash or backslash after the

<SID>.

CONNECTIDENTIFIER The Oracle TNS (Transparent Network

Substrate) name of the database. Usually the

same as the SID.

ADMINNAME The name of a user with database administrator

privileges, usually “system”. If not set, the

default is system account.

ADMINPASSWORD The password of the above user.

Windows operating system TIBCO Spotfire Server

7 (43)

SERVERDB_USER The user that will be created and used to set up

the Spotfire database.

SERVERDB_PASSWORD The password for the above user.

SERVER_DATA_TABLESPAC

E

The name of the tablespace that will be created.

The default value will work for most systems.

SERVER_TEMP_TABLESPAC

E

The name of the temporary tablespace that will

be created. The default value will work for most

systems.

3. Launch a command prompt and navigate to the directory where you placed the scripts.

4. Type create_databases.bat and press Enter.

Response: If all the parameters are correct, the following excerpt in the command

prompt is displayed:

C:\scripts\oracle\install>create_databases.bat Creating Spotfire Server table spaces and user Creating Spotfire Server tables Populating Spotfire Server tables Spotfire Server demo database user and data will not be created ---------------------------------------------------------------- Please review the log file (log.txt) for any errors or warnings! C:\scripts\oracle\install

Microsoft SQL Server on Windows

1. Copy the mssql_install folder from <Spotfire Server Installation Kit>\scripts folder

to the database server.

2. Edit the create_databases.bat file by providing the appropriate database server details

in the section under “Set these variables to reflect the local environment”:

Before modifications: rem Set these variables to reflect the local environment: set CONNECTIDENTIFIER=<SERVER>\<MSSQL_INSTANCENAME> set ADMINNAME=sa set ADMINPASSWORD=<ADMINPASSWORD> set SERVERDB_NAME=spotfire_server_700 set SERVERDB_USER=<SERVERDB_USER> set SERVERDB_PASSWORD=<SERVERDB_PASSWORD>


rem Set these variables to reflect the local environment: set CONNECTIDENTIFIER=DBSERVER\MSSQL set ADMINNAME=sa set ADMINPASSWORD=admin123 set SERVERDB_NAME=spotfire_server_700 set SERVERDB_USER=spotfire_db set SERVERDB_PASSWORD=spotfire_db123


8 (43)

CONNECTIDENTIFIER Replace <SERVER> with the name of the server

running the SQL Server instance, and replace

<MSSQL_INSTANCENAME> with the name of the

SQL Server instance.

ADMINNAME The name of a user with admin privileges on the

database, usually “sa”.


SERVERDB_NAME The name of the database that will be created.

SERVERDB_USER The user that will be created and used to set up this

database.

SERVERDB_PASSWORD The password for the above user.

3. Launch a command prompt and navigate to the directory where you placed the scripts.

4. Type create_databases.bat and press Enter.

Response: If all the parameters are correct, the following excerpt in the command

prompt is displayed:

C:\scripts\mssql_install>create_databases.bat Creating Spotfire Server tables Populating Spotfire Server tables Creating Spotfire Server database user Spotfire Server demo database user and data will not be created ---------------------------------------------------------------- Please review the log file (log.txt) for any errors or warnings! C:\scripts\mssql_install>


9 (43)

Install Spotfire Server Note: Spotfire Server is no longer supported on 32-bit systems.

1. Run the setup-win64.exe installer from the server installation kit.

2. The installation wizard Welcome dialog is displayed.

Click Next.


10 (43)

3. The TIBCO license dialog is displayed. Read the license agreement and select the

appropriate radio button.

Click Next.

4. The Third Party Components dialog is displayed. These components are not needed for

basic configuration. Select Do not download third party components.

Note: Although these components are not required for basic setup, they are required

for setting up NTLM authentication. If you expect to use NTLM in the future, you can

download them now or later.


11 (43)

Click Next.


12 (43)

5. The Destination Folder dialog is displayed. You can change the path to a different

location by clicking Change. Specify where to install Spotfire Server.

Click Next.

6. The Windows Service dialog is displayed. Select Create Windows Service.


13 (43)

Click Next.


14 (43)

7. Specify the Spotfire Server port. The default port is port 80. It is the default port for

web servers such as IIS and Apache. Make sure the port you choose is not used by any

other application or service. You can use netstat –a in a command prompt to check if

a port is in use.

Click Next.

8. The Ready to Install the Program dialog is displayed.


15 (43)

Click Install.


16 (43)

9. The Completed dialog is displayed. Select Launch the configuration tool.

Click Finish.

Note: Check for hotfixes for Spotfire Server at

http://support.spotfire.com/patches_spotfireserver.asp. Download and apply the latest

collection.

http://support.spotfire.com/patches_spotfireserver.asp


17 (43)

Configure Spotfire Server

Create the bootstrap.xml File The bootstrap.xml file configures the database connection and is created using the

Configuration Tool. The Configuration Tool was launched in the last step of the

installation wizard and can be opened at any time from the Start menu (Start >

TIBCO Spotfire Server 7.0 > Configure TIBCO Spotfire Server), or by running

uiconfig.bat (located in the <installation dir>\tomcat\bin folder).

1. On the System Status tab, click Create new bootstrap file.


18 (43)

Response: The Bootstrap tab is displayed.

2. Enter the Bootstrap file path information:

Bootstrap file Path Specify where the bootstrap file will be located.

You can keep the default location.

Note: The file name must be bootstrap.xml in

order for the Spotfire server to work

3. Enter the Database connection information:

Database connection

Driver template: Select from the drop-down menu.

Hostname: Enter the database host name.

Port: The Spotfire Database port.

Identifier

(SID/database/service):

Enter Server ID. (e.g. the ORCLE SID or the

MSSQL database name)

Username: The name of the database account used by the

Spotfire Server to connect to the Spotfire

database. Enter correct database login details.

Password: The password of the database account. Enter

correct database login details.


19 (43)

URL: The JDBC connection URL. This field is pre-

populated from selections made.

Driver class: This field is pre-populated from selections made,

and should not be edited.

4. Click the Test connection button.

Response: The Configuration Tool checks that database drivers are installed and that

the database is running. It also checks that the database accepts the given credentials.

5. Enter the Other settings information.

Other settings

Configuration tool password: Specify a password that will be used to protect the

server configuration from unauthorized access.

Note: The Configuration Tool password will be

required when running the configuration tool now

and later. Choose a configuration tool password.

Confirm tool password: Retype the configuration tool password.

Server Name: This field is pre-populated from selections made,


Encryption Password

(optional):

Will be used for encrypting other passwords

stored in the database. You can typically leave

this field blank.

Confirm encryption password: Retype the encryption password if you chose to

use an encryption password.

6. Click the Save Bootstrap button.



A dialog is displayed showing successful or unsuccessful creation of the bootstrap file.

The System Status tab of the Configuration Tool is displayed if successful.


20 (43)

7. Click the OK button.

Response: The System Status tab of the Configuration Tool is displayed.

Create and Save a Basic Configuration 1. In the Configuration Tool, click the Configuration tab.

2. Review the configuration. Verify that BASIC Database is selected in the

Authentication drop-down menu and that Database is selected in the User directory

drop-down menu.

3. Scroll to the bottom of the window and click Save configuration.

Response: The Save Configuration wizard is displayed.

4. Database is pre-selected in the Choose destination dialog.


21 (43)

5. Click Next.

Response: The Save configuration dialog is displayed. To import the configuration you

must provide a comment describing your changes: “BASIC Database Configuration”

6. Enter a comment, for example “Initial configuration”.

Click Finish.

Create a User and Promote to Administrator

1. Go to the Administration tab in the Configuration Tool.

2. In the Create new user section, type the user name and password that you would like

to use for your Spotfire Administrator account and click Create.


22 (43)

Response: The Created new user window will open.

Click OK.

3. Select the new user name from the Users column and click Promote to add that user to

the Administrators group.


23 (43)

Deploy Client Packages to Spotfire Server Note: Before proceeding, if applicable, download and apply the latest collection of

Spotfire Server hotfixes. Go to http://support.spotfire.com/patches_spotfireserver.asp.

1. Unzip the Spotfire Deployment, for example TIB_sfire_deploy_7.0.2_win.zip from

TIBCO Spotfire Client Deployment Kit installation media, provided with the

Spotfire Client installation.

2. Go to the System Status tab in the Configuration Tool.

3. Click the Deploy client packages link.

Response: The Deploy Client Packages dialog is displayed.

4. Click Browse and go to the deployment kit folder

\TIB_sfiredeploy_7.0.2_win\Products\TIBCO Spotfire Distribution, and select the

Spotfire.Dxp.sdn file.

Click Open.

5. Click Deploy.

Start Spotfire Server

1. Log on to the Spotfire Server machine as an administrator.

2. Click Start > Control Panel > Administrative Tools > Services. Locate the service

called TIBCO Spotfire Server 7.0.

3. To the left of the list, click Start.

Verify that the Spotfire Server is up and running by connecting a Spotfire Client.


TIBCO Spotfire Server Linux operating system

24 (43)

Spotfire Server on Linux

Set Up the Spotfire Database Assistance from your database administrator may be required for this step.

Note: Make sure to provide all information indicated in the installation scripts.

Oracle on Linux

1. Copy the oracle_install directory from <Spotfire_Server_Installation_Kit>/scripts

to the Oracle Database Server running on a Linux OS.

2. Edit the create_databases.sh file by providing the appropriate database server details

in the section under: “Set these variables to reflect the local environment”.

Before modifications: # Set these variable to reflect the local environment:

ROOTFOLDER=<ROOTFOLDER>

CONNECTIDENTIFIER=<SID>

ADMINNAME=system

ADMINPASSWORD=<ADMINPASSWORD>

SERVERDB_USER=<SERVERDB_USER>

SERVERDB_PASSWORD=<SERVERDB_PASSWORD>

SERVER_DATA_TABLESPACE=SPOTFIRE_DATA

SERVER_TEMP_TABLESPACE=SPOTFIRE_TEMP


# Set these variable to reflect the local environment:

ROOTFOLDER=/opt/app/oracle/oradata/orcl

CONNECTIDENTIFIER=orcl

ADMINNAME=system

ADMINPASSWORD=admin123

SERVERDB_USER=spotfire_db

SERVERDB_PASSWORD=spotfire_db123

SERVER_DATA_TABLESPACE=SPOTFIRE_DATA

SERVER_TEMP_TABLESPACE=SPOTFIRE_TEMP

ROOTFOLDER The location where the tablespaces will be created. It

must be a directory that is writable for the Oracle

instance, usually <oracle install dir>/oradata/<SID>.

Note: Do not add a slash or backslash after the <SID>.

CONNECTIDENTIFIE

R

The Oracle TNS (Transparent Network Substrate)

name of the database, usually the same as the SID.

ADMINNAME The name of a user with database administrator

privileges, usually “system”. If not set, the default is

system account.


SERVERDB_USER The user that will be created and used to set up the

Spotfire database.

SERVERDB_PASSWO

RD

The password of the above user.

Linux operating system TIBCO Spotfire Server

25 (43)

SERVER_DATA_TABL

ESPACE

The name of the tablespace that will be created. The

default value will work for most systems.

SERVER_TEMP_TAB

LESPACE

The name of the temporary tablespace that will be

created. The default value will work for most systems.

3. Run the create_databases.sh script.

Response: If all the parameters are correct, you should see the following output in the

command prompt.

[oracle@ts-oracle scripts]$ cd oracle_install

[oracle@ts-oracle oracle_install]$ pwd

/home/oracle/scripts/oracle_install

[oracle@ts-oracle oracle_install]$ sh create_databases.sh

Creating Spotfire Server table spaces and user

Creating Spotfire Server tables

Populating Spotfire Server tables

Creating Spotfire Server demo data user

Creating Spotfire Server demo database tables

Populating Spotfire Server demo data tables

-----------------------------------------------------------------

Please review the log file (log.txt) for any errors or warnings!

Install Spotfire Server Note: Spotfire Server is no longer supported on 32-bit systems.

Note: This section will walk you through the installation of the RPM-based version of

the Linux installer. It is also possible to install a Tarball Linux version. For

information on the Tarball Linux installation, see the TIBCO Spotfire Server

Installation and Configuration Manual.

The installation is described for using a graphical user interface (GUI) or using a

command line interface (CLI). If necessary, see “How to Check If Your Linux Server

Has a GUI”.

Note: You will either need to know the root user’s password or have sudo privileges to

install the RPM.

Install Spotfire Server Using a Graphical User Interface

1. On a Linux server with a graphical user interface, double-click the RPM package to

install Spotfire Server.


26 (43)

Response: The Do you want to install this file? dialog is displayed.

2. Click Install.

Response: The Authenticate dialog is displayed.

3. Type the root user’s password to continue.

Click Authenticate.

Response: The Testing changes dialog is displayed. The progress bar moves until the

dialog window disappears.


27 (43)

4. Verify the installation by navigating to /usr/local/bin/tibco/tss/7.0.2/ in a window

manager. You should see three directories and a shell script named configure.

Note: If applicable, download and apply the latest collection of Spotfire Server

hotfixes before proceeding: http://support.spotfire.com/patches_spotfireserver.asp.



28 (43)

Install Spotfire Server Using a Command Line Interface

Note: If you attempt to install the RPM without using sudo or not as the root user, you

will see the following output in the terminal:

$ rpm -ivh tss-7.0.2.x86_64.rpm

error: can't create transaction lock on /var/lib/rpm/.rpm.lock (Permission

denied)

1. Navigate to the directory where you extracted the Spotfire Installer Tape Archive

(TAR) file TIB_ss_7.0.2_linux.tar and list the contents of that directory.

For example:

$ cd /Installers/TIBCO/Spotfire/Server/7.0.x

$ ls -l

total 310736

drwxr-xr-x 2 support support 4096 Feb 6 07:56 datafunctions

drwxr-xr-x 4 support support 4096 Feb 6 07:56 demodata

drwxr-xr-x 2 support support 4096 Feb 6 07:56 documentation

drwxr-xr-x 2 support support 4096 Feb 6 07:56 geoanalytics

drwxr-xr-x 4 support support 4096 Feb 6 10:17 scripts

-rwxr-xr-x 1 support support 158898429 Feb 4 03:37 tss-7.0.2.x86_64.rpm

-rwxr-xr-x 1 support support 159272160 Feb 4 03:38 tss-7.0.2.x86_64.tar.gz

2. Verify the RPM package by typing the following in a command prompt:

rpm –K tss-7.0.2.x86_64.rpm.

$ rpm -K tss-7.0.2.x86_64.rpm

tss-7.0.2.x86_64.rpm: sha1 md5 OK

3. Install the RPM package by typing the following in a command prompt:

rpm –ivh tss-7.0.2.x86_64.rpm.

$ sudo rpm -ivh tss-7.0.2.x86_64.rpm

Preparing... ###########################################

[100%]

1:tss-7.0.2 ###########################################

[100%]

You must now execute /usr/local/bin/tibco/tss/7.0.2/configure to complete

the configuration.

4. At the end of the RPM installation you will see the text “You must now execute

/usr/local/bin/tibco/tss/7.0.2/configure to complete the configuration.” Navigate to the

newly installed Spotfire installation root directory as follows:

$ cd /usr/local/bin/tibco/tss/7.0.2/

$ ls -l

total 16

-rwxrwxr-x. 1 root root 3268 Feb 1 07:51 configure

drwxrwxr-x. 7 root root 4096 Mar 4 18:07 jdk

drwxrwxr-x. 10 root root 4096 Mar 4 18:07 tomcat

drwxrwxr-x. 4 root root 4096 Mar 4 18:07 tools

5. Run the supplied configure script:


29 (43)

$ sudo sh configure

[sudo] password for user:

TIBCO Spotfire Server 7.0.2 Configuration

-----------------------------------------

This will configure essential settings that are needed before

the server can start for the first time. Press <Enter> to accept the

defaults.

Ctrl-C will abort.

Do you want to download and install third party components? (y/n) [y]:

Specify the port that will be used by Spotfire Server. The valid range is

10 to 65535. [80]:

Third party components (jcifs_1.3.17) have been downloaded and installed.

Post install configuration of TIBCO Spotfire Server 7.0.2 successful.

Note: If you attempt to run the configure script without using sudo or not as the root

user, you will see the following output in the terminal:

TIBCO Spotfire Server 7.0.2 Configuration

-----------------------------------------

This will configure essential settings that are needed before

the server can start for the first time. Press <Enter> to accept the

defaults.

Ctrl-C will abort.

Do you want to download and install third party components? (y/n) [y]:

Specify the port that will be used by Spotfire Server [80]:

/usr/local/bin/tibco/tss/7.0.2/tomcat/webapps/spotfire/WEB-

INF/lib/components.zip: Permission denied

unzip: cannot find or open


INF/lib/components.zip,


INF/lib/components.zip.zip or


INF/lib/components.zip.ZIP.

rm: cannot remove

`/usr/local/bin/tibco/tss/7.0.2/tomcat/webapps/spotfire/WEB-

INF/lib/components.zip': No such file or directory

Third party components (jcifs_1.3.17) have been downloaded and installed.

sed: couldn't open temporary file

/usr/local/bin/tibco/tss/7.0.2/tomcat/conf/sedAUJgMj: Permission denied

sed: couldn't open temporary file

/usr/local/bin/tibco/tss/7.0.2/tomcat/conf/sedpd6KRm: Permission denied

Post install configuration of TIBCO Spotfire Server 7.0.2 successful.

touch: cannot touch `/usr/local/bin/tibco/tss/7.0.2/configured': Permission

denied


30 (43)

Configure Spotfire Server

Create the bootstrap.xml File The bootstrap.xml file configures the database connection and is created using the

Configuration Tool or the Configuration Command Line Tool. This section will walk

you through creating the bootstrap.xml file using either the GUI or the CLI on Linux.

If necessary, see How to Check If Your Linux Server Has a GUI.

Create the bootstrap.xml File Using a Graphical User Interface

1. Navigate to /usr/local/bin/tibco/tss/7.0.2/tomcat/bin in a window manager.

2. Double-click on the uiconfig.sh script.

Response: The Do you want to run “uiconfig.sh”, or display its contents? Dialog

window will open. Click the “Run” button.

3. On the System Status tab, click the Create new bootstrap file link.


31 (43)

Response: The Bootstrap tab is displayed.

4. Enter the Bootstrap file path information:

Bootstrap file Path Specify where the bootstrap file will be located.

You can keep the default location.

Note: The file name must be bootstrap.xml in

order for the Spotfire server to work

5. Enter the Database connection information:

Database connection

Driver template: Select from the drop-down menu.

Hostname: Enter the database host name.

Port: The Spotfire Database port.

Identifier

(SID/database/service):

Enter Server ID. (e.g. the ORCLE SID or the

MSSQL database name)

Username: The name of the database account used by the

Spotfire Server to connect to the Spotfire

database. Enter correct database login details.

Password: The password of the database account. Enter

correct database login details.

URL: The JDBC connection URL. This field is pre-

populated from selections made.

Driver class: This field is pre-populated from selections made,


32 (43)


6. Click the Test connection button.



7. Enter the Other settings information.

Other settings

Configuration tool password: Specify a password that will be used to protect the

server configuration from unauthorized access.

Note: The Configuration Tool password will be

required when running the configuration tool now

and later. Choose a configuration tool password.

Confirm tool password: Retype the configuration tool password.

Server Name: This field is pre-populated from selections made,


Encryption Password

(optional):

Will be used for encrypting other passwords

stored in the database. You can typically leave

this field blank.

Confirm encryption password: Retype the encryption password if you chose to

use an encryption password.

8. Click the Save Bootstrap button.



A dialog is displayed showing successful or unsuccessful creation of the bootstrap file.

The System Status tab of the Configuration Tool is displayed if successful.

9. Click the OK button.

Response: The System Status tab of the Configuration Tool is displayed.


33 (43)

Create the bootstrap.xml File Using a Command Line Interface

1. Open a command prompt and navigate to /usr/local/bin/tibco/tss/7.0.2/tomcat/bin.

2. Run a specific command using the Command Line Configuration Tool config.sh to

create the bootstrap.xml file. The basic syntax of the command is as follows:

sh $CONFIG bootstrap --force --driver-class $DB_DRIVER --database-url

"$DB_URL" --username $DB_USER --password $DB_PASSWORD --tool-password

$CONFIG_TOOL_PASSWORD $BOOTSTRAP_FILE

Here is an example using the supplied TIBCO DataDirect Driver for Oracle:

sh /usr/local/bin/tibco/tss/7.0.2/tomcat/bin/config.sh bootstrap --force --

driver-class tibcosoftwareinc.jdbc.oracle.OracleDriver --database-url

jdbc:tibcospotfireinc:oracle://dbsrv.example.com:1521;SID=orcl --username

spotfire_db --password spotfire_db123 --tool-password admin123 --

encryption-password


INF/bootstrap.xml

Note: You can also use the following script to create the bootstrap.xml file. Create a

text file on your Linux machine, name it create-bootstrap.sh and paste the following

text:

#!/bin/bash

#title :create-bootstrap.sh

#description :Create bootstrap.xml file on a newly installed 7.0.2

Spotfire Server

#author :TIBCO Software, Inc.

#date :20150118

#version :7.0.2

#usage :./create-bootstrap.sh

#===============================================================

export CATALINA_HOME=/usr/local/bin/tibco/tss/7.0.2/tomcat

export CONFIG=$CATALINA_HOME/bin/config.sh

export CONFIG_FILE=$CATALINA_HOME/bin/configuration.xml

export BOOTSTRAP_FILE=$CATALINA_HOME/webapps/spotfire/WEB-INF/bootstrap.xml

export DB_DRIVER=tibcosoftwareinc.jdbc.oracle.OracleDriver

export

DB_URL="jdbc:tibcospotfireinc:oracle://dbsrv.example.com:1521;SID=orcl"

export DB_USER=spotfire_db

export DB_PASSWORD=spotfire_db123

export CONFIG_TOOL_PASSWORD=admin123

## Create bootstrap.xml

echo "Creating the database connection configuration..."

sh $CONFIG bootstrap --force --driver-class $DB_DRIVER --database-url

"$DB_URL" --username $DB_USER --password $DB_PASSWORD --tool-password

$CONFIG_TOOL_PASSWORD --encryption-password $BOOTSTRAP_FILE

Note: Remember to make the appropriate changes to the supplied variables, save the

script, and run it.


run the script.


34 (43)

Create and Save a Basic Configuration This section will walk you through creating and importing a new configuration using

either the GUI or the CLI on Linux.

Create and Save a Basic Configuration Using a Graphical User Interface

This section will walk you through creating and importing a new configuration using

the Configuration Tool uiconfig.sh.





3. Click the Configuration tab.

4. Review the configuration. Verify that BASIC Database is selected in the

Authentication drop-down menu and that Database is selected in the User Directory

drop-down menu.

5. Click Save configuration in the bottom right-hand corner of the window.


35 (43)

Response: The Save Configuration wizard is displayed.

6. Database (recommended) is pre-selected in the Choose destination dialog.

Click Next.

Response: The “To import the configuration you must provide a comment” dialog is

displayed.

7. Enter a comment, for example “BASIC Database Configuration”.

Click Finish.


36 (43)

Create and Save a Basic Configuration Using a Command Line Interface

1. In a command prompt, navigate to /usr/local/bin/tibco/tss/7.0.2/tomcat/bin.

2. Run two specific commands using the Configuration Command Line Configuration

tool config.sh to create and import a new default configuration. The basic syntax of

the commands are as follows:

sh $CONFIG create-default-config --force $CONFIG_FILE

sh $CONFIG import-config --bootstrap-config $BOOTSTRAP_FILE --tool-password

$CONFIG_TOOL_PASSWORD --comment="TIBCO Spotfire $SPOTFIRE_VERSION Basic

Configuration" $CONFIG_FILE

Here is an example of the two commands:

sh /usr/local/bin/tibco/tss/7.0.2/tomcat/bin/config.sh create-default-

config –force /usr/local/bin/tibco/tss/7.0.2/tomcat/bin/configuration.xml

sh /usr/local/bin/tibco/tss/7.0.2/tomcat/bin/config.sh import-config --

bootstrap-config


INF/bootstrap.xml --tool-password admin123 --comment="TIBCO Spotfire

$SPOTFIRE_VERSION Basic Configuration"

/usr/local/bin/tibco/tss/7.0.2/tomcat/bin/configuration.xml

Note: You can also use the following script to create and import the basic

configuration. Create a text file on your Linux machine, name it create-import-basic-

config.sh, and paste the following text:

#!/bin/bash

#title :create-import-basic-config.sh

#description :Create+import a basic config on newly installed 7.0.2

Spotfire Server


#date :20150206

#version : 7.0.2

#usage :./create-import-basic-config.sh

#============================================================================

export CATALINA_HOME=/usr/local/bin/tibco/tss/7.0.2/tomcat

export CONFIG=$CATALINA_HOME/bin/config.sh

export CONFIG_FILE=$CATALINA_HOME/bin/configuration.xml

export BOOTSTRAP_FILE=$CATALINA_HOME/webapps/spotfire/WEB-INF/bootstrap.xml

export CONFIG_TOOL_PASSWORD=admin123

# Create default config

echo "Creating the default configuration..."

sh $CONFIG create-default-config --force $CONFIG_FILE

# Import Basic Config

echo "Importing the configuration..."

sh $CONFIG import-config --bootstrap-config $BOOTSTRAP_FILE --tool-password

$CONFIG_TOOL_PASSWORD --comment="TIBCO Spotfire $SPOTFIRE_VERSION Basic

Configuration" $CONFIG_FILE

Note: Remember to make the appropriate changes to the supplied variables, save the

script, and run it.


run the script.


37 (43)

Create a User and Promote to Administrator Every Spotfire Server must have at least one Administrator user.

This section will walk you through creating a new user and promoting that new user to

Administrator using either the GUI or the CLI on Linux.

Create and Promote a User to Administrator Using a Graphical User Interface

Using the Configuration Tool uiconfig.sh:





3. Click the Administration tab.

4. In the Create new user section, enter the user name and password that you would like

to use for your Spotfire Administrator account.

Click Create.

Response: The Created new user window will open.


38 (43)

Click OK.

5. Select the new user name from the Users column and click Promote to add that user to

the Administrators group.


39 (43)

Create and Promote a User to Administrator Using a Command Line Interface

1. In a command prompt, navigate to /usr/local/bin/tibco/tss/7.0.2/tomcat/bin.

2. Run two specific commands using the Configuration Command Line Tool config.sh to

create and import a new default configuration. The basic syntax of the commands are

as follows:

sh $CONFIG create-user --bootstrap-config $BOOTSTRAP_FILE --tool-password

$CONFIG_TOOL_PASSWORD --username $ADMIN_USER --password $ADMIN_PASSWORD

sh $CONFIG promote-admin --bootstrap-config $BOOTSTRAP_FILE --tool-password

$CONFIG_TOOL_PASSWORD --username $ADMIN_USER

Here is an example of the two commands:

sh /usr/local/bin/tibco/tss/7.0.2/tomcat/bin/config.sh create-user --

bootstrap-config


INF/bootstrap.xml --tool-password admin123 --username admin --password

admin123

sh /usr/local/bin/tibco/tss/7.0.2/tomcat/bin/config.sh promote-admin --

bootstrap-config


INF/bootstrap.xml --tool-password admin123 --username admin

You can also use the following script to create and promote a new user to

Administrator. Create a text file on your Linux machine, name it create-promote-

admin.sh, and paste the following text:

#!/bin/bash

#title :create-promote-admin.sh

#description :Create+promote new user to Administrator on newly installed

7.0.2 Spotfire Server


#date :20150118

#version : 7.0.2

#usage :./create-promote-admin.sh

#============================================================================

export CATALINA_HOME="/usr/local/bin/tibco/tss/7.0.2/tomcat"

export CONFIG="$CATALINA_HOME/bin/config.sh"

export BOOTSTRAP_FILE="$CATALINA_HOME/webapps/spotfire/WEB-INF/bootstrap.xml"

export CONFIG_TOOL_PASSWORD="admin123"

export ADMIN_USER="admin"

export ADMIN_PASSWORD="admin123"

# Create $ADMIN_USER

echo "Creating the user '$ADMIN_USER' to become Administrator..."

sh $CONFIG create-user --bootstrap-config $BOOTSTRAP_FILE --tool-password

$CONFIG_TOOL_PASSWORD --username $ADMIN_USER --password $ADMIN_PASSWORD

# Promote $ADMIN_USER to Administrator

echo "Making the created user '$ADMIN_USER' an Administrator..."

sh $CONFIG promote-admin --bootstrap-config $BOOTSTRAP_FILE --tool-password

$CONFIG_TOOL_PASSWORD --username $ADMIN_USER

Note: Remember to make the appropriate changes to the supplied variables. Then save

the script and run it.


run the script.


40 (43)

Deploy Client Packages to Spotfire Server Note: Before proceeding, if applicable, download and apply the latest collection of

TIBCO Spotfire Server hotfixes. Go to


Deploy Client Packages Using a Graphical User Interface

1. Unzip the Spotfire Deployment, for example TIB_sfire_deploy_7.0.2_win.zip from

TIBCO Spotfire Client Deployment Kit installation media, provided with the

Spotfire Client installation.





4. Go to the System Status tab in the Configuration Tool.

5. Click the Deploy Client Packages link.

Response: The Deploy Client Packages dialog is displayed.

6. Click Browse and go to the deployment kit folder

\TIB_spotdeploy_7.0.2_win\Products\TIBCO Spotfire Distribution, select the

Spotfire.Dxp.sdn file.

Click OK.

7. In the drop-down list, select the deployment area to which you want to deploy.

8. Click Deploy.



41 (43)

Deploy Client Packages Using a Command Line Interface

This section will walk you through deploying the Spotfire Client Packages to the

Spotfire Server. Each browser acts differently on different operating systems, but for

as long as you’re running one of the supported browsers. it should behave the same.

1. Unzip the TIBCO Spotfire Deployment, for example TIB_spotdeploy_7.0.2_win.zip

from TIBCO Spotfire Client Deployment Kit installation media, provided with the

TIBCO Spotfire Client installation.

2. Browse to the deployment kit folder \TIB_spotdeploy_7.0.2_win\Products\TIBCO

Spotfire Distribution, note the path to the Spotfire.Dxp.sdn file.

3. Run the command update deployment and insert the path from the previous step.

sh /usr/local/bin/tibco/tss/7.0.2/tomcat/bin/config.sh update-deployment --

bootstrap-config


INF/bootstrap.xml --tool-password admin123

"/TIB_spotdeploy_7.0.2_win/Products/TIBCO Spotfire

Distribution/Spotfire.Dxp.sdn"


42 (43)

Start Spotfire Server Note: If you used the supplied TIBCO-Spotfire-Setup.sh script, your Spotfire Server

should already be running.

1. At a command prompt, run the following command:

$ sudo service tss-7.0.2 start

You should see the following output:

$ sudo service tss-7.0.2 start

[sudo] password for support:

Starting tss-7.0.2: Using CATALINA_BASE:

/usr/local/bin/tibco/tss/7.0.2/tomcat

Using CATALINA_HOME: /usr/local/bin/tibco/tss/7.0.2/tomcat

Using CATALINA_TMPDIR: /usr/local/bin/tibco/tss/7.0.2/tomcat/temp

Using JRE_HOME: /usr/local/bin/tibco/tss/7.0.2/jdk/jre

Using CLASSPATH:

/usr/local/bin/tibco/tss/7.0.2/tomcat/bin/bootstrap.jar:/usr/local/bin/tibco/

tss/7.0.2/tomcat/bin/tomcat-juli.jar

Using CATALINA_PID: /usr/local/bin/tibco/tss/7.0.2/tomcat/bin/catalina.pid

Note: On SuSE® Linux you will need to start the daemon directly using the following

command: sudo /etc/init.d/tss-7.0.2 start

Verify that Spotfire Server is up and running by connecting a Spotfire client.

Reference Tips & Tricks

43 (43)

How to Check If Your Linux Server Has a GUI

If you are logged in to your Linux machine Command Line Interface (CLI) and are not

sure if you have a Graphical User Interface (GUI), depending on the exact flavor of

your Linux server, one quick and easy way to see if you have a GUI might be to

execute the following command:

$ ls -l /etc/X11

If you see no such file or directory it likely means that you do not have a graphical

user interface:

$ ls -l /etc/X11

ls: cannot access /etc/X11: No such file or directory

If you see this instead it means that you do have a graphical user interface:

$ ls -l /etc/X11

total 28

drwxr-xr-x. 2 root root 4096 Sep 23 2011 applnk

drwxr-xr-x. 2 root root 4096 Feb 26 10:48 fontpath.d

-rwxr-xr-x. 1 root root 1328 Sep 17 05:55 prefdm

drwxr-xr-x. 5 root root 4096 Feb 26 10:46 xinit

-rw-r--r--. 1 root root 547 Aug 16 2010 Xmodmap

drwxr-xr-x. 2 root root 4096 Jan 24 11:16 xorg.conf.d

-rw-r--r--. 1 root root 493 Aug 16 2010 Xresources

tibco spotfire server 7 · this document contains confidential information that is subject to u.s....

Documents