O&M Asset Proxy Service

Constraints and Limitations

For server information management, the IPv4 address of the primary server must be modified preferentially after image initialization.

Modifying Primary Server

1. Logging in to the Database Operations and Maintenance Management System using the sysadmin system administrator account.
2. Select Ops Asset Management > Ops Asset Proxy Server from the left navigation pane to display the proxy service list.
3. Click the Edit icon at the top left of the page to modify primary server configurations.
   Figure 1 Editing primary server
   

4. Click the OK button after completing modifications.

   Table 1 Table1 Parameter description of primary server

   Parameter	Description
   Main Server Name	Customize the name according to actual business implications. (Required)
   Machine Name	Hostname of the server. (Required)
   Intranet IP	IP address of the server where the platform is deployed, which is also used for providing proxy services externally. (Required)
   Public IP	Public IP address of the server for external network access.

Adding New Proxy Service

1. Logging in to the Database Operations and Maintenance Management System using the sysadmin system administrator account.
2. Select Ops Asset Management > Ops Asset Proxy Server on the left navigation bar to display the proxy service list.
3. Click Add Proxy Server, and the corresponding configuration window pops up to add proxy services for the current server.
   Figure 2 Adding new proxy service
   

4. Enter the proxy service name, port number, database type and remarks, and configure whether to enable access control.
5. Click OK.

   Table 2 Table2 Proxy service parameter specification

   Parameter	Description
   Main Server	Only the host server can be selected. (Required)
   Proxy Server Name	Name of the proxy service. (Required)
   Proxy Port	Listening port for the proxy service. Apply port numbers within the specified range based on network topology; input numeric values ranging from 2026 to 3026. (Required)
   Database Type	Database type of the data source (asset repository) proxied by the service, including but not limited to MySQL, PostgreSQL, Oracle, DB2, SQL Server, MariaDB, Kingbase, DM, Greenplum and OpenGauss. (Required)
   Notes	Supplementary functional description.
   Enable access control	Enabled by default; the option can be toggled off to disable system access permission control, while policies configured in Policy Management remain effective.

Related Operations

You may perform the following operations on the Ops Asset Proxy Server page as needed:

• Start Proxy Service: Select an inactive proxy service and click Start to launch it. Only proxy services bound to Ops Asset Control are functional after startup.
• Stop Proxy Service: Select a running proxy service and click Stop to shut it down. Only proxy services bound to Ops Asset Control are meaningful to stop.
• Edit Proxy Service: Click Edit to modify proxy service configurations as required. Note that the database type of the proxy service cannot be altered.
• Delete Proxy Service: Click Delete to remove the proxy service. Direct deletion is prohibited for proxy services bound to Ops Asset Control; the associated asset control must be deleted beforehand.
• Bind Controlled Repository: Click the More button and select Associated Control. The page will redirect and locate the associated asset control instantly.
• Bind Asset: Click the More button and select Associated Assets. The page will jump to and pinpoint the corresponding bound asset repository.
• BYPASS: Bypass mode means the proxy skips access control and data desensitization. In the proxy service list, select a target service and click BYPASS Enable or BYPASS Disabled under the More menu. Disabling BYPASS is recommended under normal circumstances.
• Operation Mode: Toggle between Operation mode shutdown or Operation mode enabled, which determines the initialization scope of cached database structures. When disabled, the proxy caches full database metadata by default. When enabled, the proxy only loads metadata of database tables that have been accessed via the proxy service. Enabling Operation Mode is recommended for routine O&M scenarios.

• O&M staff access databases through proxy services to forward requests and data traffic. Therefore, keep proxy services running under normal circumstances.
• Proxy services can only be edited or deleted after all proxy services are stopped.
• Editing is not allowed when a proxy service is running.
• If a proxy service is bound to an O&M Asset Control, direct deletion is prohibited. Click the More dropdown and select Associated Control, delete the corresponding O&M Asset Control first, and then delete the proxy service.