Log Database Externalization
Last updated
Last updated
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.
Click on the “Administration” icon On the left-hand panel.
Once clicked, Click on the “Global settings.”
Once inside the “Global settings” Page, click on the “Log Database setting” as shown below.
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.
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.
Restart the Tomcat server once the Log Database setup is complete to ensure the new configurations take effect.
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.
It will show you the process logs, including the process information
This table will show the information related to the system roles assigned.
This table will show the information related to the Users added to the system.
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
