Log Database Externalization

This document outlines the process for externalizing log storage by allowing log entries to be stored in other databases, such as MySQL, PostgreSQL, and SQL Server.

Steps to Configure Log Database

Accessing Global Settings

1. Click on the “Administration” icon On the left-hand panel.

2. Once clicked, Click on the “Global settings.”

Administration tab commands

Configuring Log Database Settings

Once inside the “Global settings” Page, click on the “Log Database setting” as shown below.

Global setting page

Entering Database Configuration Details

You will see several fields to configure your log database instance:

• Type: Select the type of database (e.g., MySQL, PostgreSQL, SQLServer).

• Host: Enter the hostname or IP address of your database server.

• Port: Specify the port number used for database connections.

• Username: Input the username for database access.

• Password: Enter the corresponding password for the specified username.

• Database Name: Provide the database name where logs will be stored.

• Schema: If applicable, specify the schema to be used.

Once you fill in these details, the URL will auto-fill based on the provided configuration.

Testing connection and saving Changes

• Once you have completed and tested all the settings, click the “ save changes” button to save them.

• Click the “Test Connection” button to validate the connection.

Log Database setup

Important Notification

Restart the Tomcat server once the Log Database setup is complete to ensure the new configurations take effect.

Testing Logs on your database

Once Setup is complete and any command is run, you can see the logs in your Database, which is added as the location for your Log Database. Inside your database, you will be able to see three tables.

PROCESS_TABLE

It will show you the process logs, including the process information

Includes all process related information like status, command, Timestamp, etc.

SYS_ROLE

This table will show the information related to the system roles assigned.

It include system information like Policy, createdetdate, type, etc

SYS_USER

This table will show the information related to the Users added to the system.

It Include user informations like firstname, lastname, role, etc.

Using the above informations and following the given steps user can set up there external log database to externalize their log information in the database of their choise