Configuring logging to an Oracle database using the command line

You can configure action logging to write to an Oracle database by running additional scripts needed for logging to a database. Sample scripts are included in the installation kit for Spotfire Server.

About this task

This topic describes the steps required to run the configuration scripts from the command line. Alternatively, you can enable and configure the action logging and system monitoring using the configuration tool.

Before you begin

You must have administrative credentials for Spotfire Server.
You must have enabled logging to a database.

Procedure

Log in to Spotfire Server, and in the file system, browse to the directory containing the installation kit files that you downloaded from the TIBCO eDelivery site.
In the installation kit directory, browse to the directory containing the scripts to create a new database and schema.
For Oracle, this directory is /scripts/oracle_install/actionlog.
Using a text editor, open the script file create_actionlog_db.bat (or, for Linux, create_actionlog_db.sh).
In the script file, edit the section containing the database name spotfire_actionlog, setting the variables to reflect your database environment.

You must provide the database password in this script. If you do not have the password, consult your database administrator for assistance.

Note: If you want to use the information layer for analyzing action logs, you should not change the ACTIONDB_USER from the default spotfire_actionlog, or else, you must use the Redirect dependent elements functionality in Information Designer (in Spotfire Analyst) to fix the mapping. See the Spotfire Analyst help topic Redirecting the Information Model for more information on this functionality.
Optional: If your database is running on Amazon RDS, also edit the script file create_actionlog_db_rds.bat (or, for Linux, create_actionlog_db_rds.sh), specifying the same information.
Run the script to create the database.
Information and error logs are written to a file named actionlog.txt in the directory from where you run the script. If the script takes a very long time, or if it fails, check this text file for more information.

The database is created on the server.
On Spotfire Server, from the Start menu, open a command-line window as administrator.
Browse to <installation dir>\tomcat\spotfire-bin.
Export the configuration: At the command prompt, type the command config export-config.
```
config export-config --force 
```
When prompted, supply the tools password. See export-config for more information.
At the command prompt, type the command config config-action-log-database-logger, passing in the arguments specifying the details of the database.
For example, to specify the Oracle database URL, driver class, user name, and password. The following example demonstrates the information you must provide.
```
config config-action-log-database-logger 
--database-url="jdbc:tibcosoftwareinc:oracle://some.oraserver.com:1521;ServiceName=pdborcl.example.com" 
--driver-class="tibcosoftwareinc.jdbc.oracle.OracleDriver" --username="spotfire_actionlog" 
```
When prompted, supply the tools password. See config-action-log-database-logger for more information.
At the command prompt, type the command config import-config.
```
config import-config --comment="adding database configuration for action logging." 
```
When prompted, supply the tools password. See import-config for more information.
Restart Spotfire Server.

Results

The database is configured for use.

What to do next

If desired, follow the instructions in Importing a library for analyzing action logs in Spotfire Analyst, to get a quick start with your action log analysis.