Redwood Platform Admin Server

This section covers usage of the admin server to:

• Install or upgrade the database schema - Database Installation/Upgrade
• Configure authentication - Authentication Configuration:
  • Using LDAP as an external authentication system
  • Using Internal Authentication, called Database
  • Using Redwood Platform authentication, called Application Server (not recommended)
• Configure Auto upgrade - Bootstrap Configuration
• Editing the registry - Registry Editor
• Using DB Tools - DB Tools:
  • execute SQL - Execute an SQL file against the database
  • Export - Export database tables
  • Import - Import database tables
  • Clear - Truncate database tables

Install Upgrade the Database Schema

Database Installation/Upgrade allows you to validate that the database schema exists, is valid, and up-to-date. When you install your central Redwood server, you use this to install the database schema. When you upgrade your central Redwood server, this option allows you to upgrade the database. You enable Bootstrap Configuration > Auto upgrade to allow the central Redwood server to update the database automatically on startup without having to upgrade the database using the admin server.

Configure Authentication

Authentication Configuration allows you to select the authentication and authorization system, the following are supported:

• Application Server - (default) Use Redwood Platform authentication, this option stores users and role memberships in tomcat-users.xml with plain text passwords; changes require you restart the central Redwood server. The admin server always uses this method. This option is not recommended for the central Redwood server.
• Database - Use a database table to store users and role memberships. See Database Security for more information.
• LDAP - Use an LDAP system (such as ActiveDirectory, OpenLDAP or Oracle Internet Direcotry) for authentication and role memberships. See External Security Systems for more information.

Bootstrap Configuration

You enable auto-upgrade to ensure the database is automatically updated when you upgrade.

Registry Editor

The registry editor allows you to inspect and modify the registry. Note that it may take a few seconds to load the registry hives.

DB Tools

The database tooling is used to manage the underlying database.

Execute SQL

This option allows you to run an SQL file that resides on the central Redwood server. Note that the SQL file needs to have native SQL calls. For example, on Oracle you make PL/SQL calls, PL/pgSQL calls on PostgreSQL.

Export

This option allows you to export specific tables matching a regex specified in the Pattern field to a directory on the central Redwood server. The current working directory is <install_dir>/j2ee/cluster/adminserver1/logs so you can always specify../temp as output directory as a safe option. Do backup the CSV files and the bindata directory.

Import

This option allows you to import exported tables from a directory on the central Redwood server. You specify relative paths relative to the current working directory, which is <install_dir>/j2ee/cluster/adminserver1/logs.

Clear

This option allows you to truncate specified tables that match a regex specified in the Pattern field. Note that by default, the Test Run field is checked, this means that a dry run is performed, only the tables that would have been cleared are listed.

onsiteTopic