Overview

Site Configuration allows administrators to customize system-wide behavior for OneDB. These settings affect how OneDB handles user authentication, security controls, traffic processing, and overall platform behavior.

Most settings can be changed at any time and take effect without requiring a system restart.

Password Settings

The Password Settings section is used to define password policy requirements for OneDB user accounts.

Administrators can configure password complexity rules to help improve account security and reduce the risk of weak passwords.

Password Complexity Options

The following password complexity options may be enabled:

Minimum Password Length

The Minimum Password Length field defines the minimum required password length for user accounts.

Example:

8

If the minimum password length is set to 8, users must create passwords with at least 8 characters.

Recommended password policy example:

Traffic Protection Settings

Traffic Protection Settings control how OneDB handles large SQL statements, slow database connections, and temporary traffic spikes.

These settings help balance security, performance, and system stability. In most environments, the default values are recommended.

Max SQL Inspection Size

Defines the maximum SQL size that OneDB will inspect before applying security and protection rules.

If a SQL statement exceeds this limit, OneDB follows the action configured in Large or Unsupported SQL Action.

Large or Unsupported SQL Action

Determines how OneDB handles SQL that exceeds the inspection limit or cannot be safely analyzed.

Available options:

For security-focused deployments, Block is recommended.

Database Connect Timeout

Specifies how long OneDB waits for a database connection before terminating the request.

Increasing this value may be helpful when databases are located across slower networks.

Advanced Safety Limits

Advanced Safety Limits provide additional protection against unusually large requests and temporary traffic surges.

These settings are intended for advanced environments and normally do not require modification.

Temporary Traffic Limit

Defines the maximum amount of client traffic OneDB can temporarily buffer while waiting for a database connection.

Temporary Message Limit

Defines the maximum number of client messages that can be held temporarily before OneDB begins slowing down or timing out requests.

Max Batch Check Size

Defines the largest batch operation OneDB will inspect before applying protection rules.

Max Batch Parts

Defines the maximum number of batch segments OneDB can temporarily hold while preparing SQL for inspection.

Max SQL Rebuild Size

Defines the largest SQL statement OneDB can reconstruct when SQL traffic arrives in multiple network packets.

This allows OneDB to inspect fragmented SQL statements before they are forwarded to the database.

Best Practices

• Use the default values unless a specific operational requirement exists.
• Configure Large or Unsupported SQL Action to Block for security-focused deployments.
• Increase limits only after evaluating memory and performance requirements.
• Monitor audit logs regularly for SQL statements that exceed inspection limits.
• Review advanced settings carefully before making changes in production environments.

Main Functions

Administrators can use the Site Configurations menu to:

• Configure the default number of records displayed per page
• Configure the maximum number of characters displayed per field or column
• Define password complexity requirements
• Set the minimum password length
• Configure the application time zone
• Standardize timestamp display across the OneDB Admin Console

Pagination Settings

The Pagination Settings section controls how many records are displayed in list or table views within the OneDB Admin Console.

This helps administrators manage screen readability and performance when viewing large datasets.

Pagination Setting Fields

Limit Per Page

The Limit Per Page setting determines how many records are shown on each page.

Example:

20

If the value is set to 20, OneDB displays up to 20 records per page in supported list views.

This setting may affect pages such as:

• User list
• Group list
• API user list
• Connection list
• Template list
• Audit trail list
• Database browser list

Max Characters Per Field

The Max Characters Per Field setting determines how many characters are displayed for each field or column.

Example:

50

If a field value is longer than the configured limit, OneDB may shorten or truncate the displayed value in the interface.

This is useful for improving readability when displaying long values such as:

• URLs
• Tokens
• Long text fields
• Request details
• Log details
• Database field values

This setting affects display behavior only. It does not change the actual value stored in the database.

Password Settings

The Password Settings section is used to define password policy requirements for OneDB user accounts.

Administrators can configure password complexity rules to help improve account security and reduce the risk of weak passwords.

Password Complexity Options

The following password complexity options may be enabled:

Minimum Password Length

The Minimum Password Length field defines the minimum required password length for user accounts.

Example:

8

If the minimum password length is set to 8, users must create passwords with at least 8 characters.

Recommended password policy example:

Time Zone Configuration

The Time Zone Configuration section is used to define the application time zone for OneDB.

This setting affects how timestamps are displayed across the OneDB Admin Console.

Application Time Zone

The Application Time Zone field defines the time zone used by the OneDB interface.

Example:

Asia/Jakarta

This setting may affect timestamp display in areas such as:

• Audit Trail
• Monitoring
• Syslog Setting
• Backup/Restore history
• Configuration update timestamps
• Other time-based records in the Admin Console

Recommended Practice

Set the application time zone based on the organization’s operational location or primary administrator location.

For example:

For environments managed by regional or global teams, the selected time zone should be agreed internally to avoid confusion when reviewing audit records, logs, or operational events.

How to Update Site Configuration

1. Open Site Configurations from the Settings menu.
2. Configure Limit Per Page under Pagination Settings.
3. Configure Max Characters Per Field.
4. Select the required password complexity options.
5. Set the Minimum Password Length.
6. Select the Application Time Zone.
7. Save the configuration if required by the interface.

Important Notes

• Site Configuration settings affect the behavior and display of the OneDB Admin Console.
• Pagination and maximum character settings are intended to improve readability and usability when viewing records in the interface.
• The Max Characters Per Field setting controls displayed characters only and does not modify the actual stored value.
• Password complexity settings help enforce stronger password requirements for OneDB users.
• Changes to password policy may affect new password creation or password update activities, depending on the OneDB version and implementation.
• The application time zone affects how timestamps are displayed in the Admin Console. It does not necessarily change the underlying system time or database server time.
• Administrators should align the application time zone with the organization’s operational and audit review requirements.

Recommended Practice