Updated on 2022-12-30 GMT+08:00

Step 1: Add a Database

Database audit supports databases built on ECS, BMS, and RDS on Huawei Cloud. After purchasing a database audit instance, you need to add the database to be audited to the instance.

For details about the types and versions of databases that can be audited by database audit, see Supported Database Types and Versions.

Prerequisites

You have purchased a database audit instance and the Status is Running.

Adding a Database

  1. Log in to the management console.
  2. Select a region, click , and choose Security & Compliance > Database Security Service. The Dashboard page is displayed.
  3. In the navigation tree on the left, choose Databases.
  4. In the Instance drop-down list, select the instance whose database is to be added.
  5. Click Add Database.
  6. In the dialog box displayed, set the database information, as shown in Figure 1.

    Figure 1 Add Database dialog box
    Table 1 Parameters

    Parameter

    Description

    Example Value

    Name

    Custom name of the database to be added

    test1

    IP Address

    IP address of the database to be added.

    It must be an intranet IPv4 (for example, 192.168.1.1) or intranet IPv6 (for example, fe80:0000:0000:0000:0000:0000:0000:0000) address.

    192.168.1.1

    Type

    Supported database type. The options are as follows:
    • MYSQL
    • ORACLE
    • POSTGRESQL
    • SQLSERVER
    • DWS
    • GaussDB(for MYSQL)
    • GaussDB(for openGauss)
    • DAMENG
    • KINGBASE
    • MongoDB
    NOTE:

    If ORACLE is selected, to make the audit settings take effect, restart the applications to be audited and log in to the database again.

    MYSQL

    Port

    Port number of the database to be added

    3306

    Version

    Supported database versions

    • When Type is set to MYSQL, the following versions are available:
      • 5.0, 5.1, 5.5, 5.6, 5.7
      • 8.0 (8.0.11 and earlier)
      • 8.0.23
      • 8.0.25
      • If RDS database is selected, a list of database instances will be displayed for you to choose from. You do not need to install the agent.
    • When Type is set to ORACLE, the following versions are available:
      • 11g
      • 12c
      • 19c
    • When Type is set to POSTGRESQL, the following versions are available:

      7.4 or later

    • When Type is set to SQLSERVER, the following versions are available:
      • 2008
      • 2012
      • 2014
      • 2016
      • 2017
    • When Type is set to DWS, the following versions are available:
      • 1.5
    • When Type is set to GaussDB(for MySQL), the following versions are available:
      • When Database Type is set to Self-built database, you can select the MySQL 8.0 version.
      • If RDS database is selected, a list of database instances will be displayed for you to choose from. You do not need to install the agent.
    • When Type is set to GaussDB(for openGauss), the following version is available:
      • 1.4 Enterprise Edition
    • When Type is set to DAMENG, the following version is available:
      • DM8
    • When Type is set to KINGBASE, the following version is available:
      • V8

    5.0

    Instance

    Instance name of the database to be audited

    NOTE:
    • If you do not configure the Instance field, database audit will audit all instances in the database.
    • If you enter an instance name, database audit will audit the entered instance. Enter a maximum of five instance names and use semicolons (;) to separate instance names.

    -

    Character Set

    Encoding format of the database character set. The options are as follows:

    • UTF-8
    • GBK

    UTF-8

    OS

    OS of the added database. The options are as follows:
    • LINUX64
    • WINDOWS64

    LINUX64

    Database Type

    Type of the database to be added. Its value can be RDS database or Self-built database.

    RDS database

  7. Click OK. Then a database in the Disabled state has been added to the database list. See Figure 2.

    Figure 2 Successfully adding a database
    • After adding the database, confirm that the database information is correct. If the database information is incorrect, locate the target database and click Delete in the Operation column, and add the database again.