Help Center/ Database Security Service/ User Guide (ME-Abu Dhabi Region)/ FAQs/ Agent/ What Do I Do If the Communication Between the Agent and Database Audit Instance Is Abnormal?
Updated on 2023-12-27 GMT+08:00

What Do I Do If the Communication Between the Agent and Database Audit Instance Is Abnormal?

Symptom

An agent has been installed on the database or application, but the SQL statement is not displayed in the SQL statement list after you enter an SQL statement in the database.

Checking the Audited Database

  1. Log in to the management console.
  2. Select a region, click , and choose Security > 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 checked.
  5. Check the information about the database to be audited, as shown in Figure 1.

    Figure 1 Viewing the information about the database to be audited
    • If the database information is correct, go to 6.
    • If the database information is incorrect, click Delete to delete the database, and then click Add Database to add the database again.
      • If the fault is rectified, no further operation is required.
      • If the problem persists, go to 6.

  6. Check the audit status of the database to be audited, as shown in Figure 2.

    Figure 2 Checking the database audit status

Checking the Security Group Rules of the Database Audit Instance

  1. Click next to the database to expand the details about the agent and record the value of Installing Node IP Address, as shown in Figure 3.

    Figure 3 Recording the IP address of the installing node

  2. In the navigation tree on the left, choose Database Audit > Instances.
  3. Click the required instance. The Overview page is displayed.
  4. In the Network Settings area, record the value of Security Group (for example, default) of the database audit instance, as shown in Figure 4.

    Figure 4 Checking the security group of the database audit instance

  5. Click in the upper left corner of the management console and choose Network > Virtual Private Cloud.
  6. In the navigation tree on the left, choose Access Control > Security Groups. The security group list page is displayed.
  7. Enter the security group default recorded in 4 in the search box in the upper right corner of the list, and click or press Enter. Its information is displayed in the list.
  8. Click the name of the security group default. Click the Inbound Rules tab.
  9. Check inbound rules of the security group default.

    Check whether TCP (port number 8000) and UDP protocols (port number from 7000 to 7100) are configured in the inbound rules of the security group for the IP address of the installing node in 1.

  10. Add inbound rules for the security group of the database audit instance.

    1. Click Add Rule, as shown in Figure 5.
      Figure 5 Adding rules
    2. In the Add Inbound Rule dialog box, add TCP (port number 8000) and UDP protocols (port number from 7000 to 7100) for the installing node IP address in 1. See Figure 6.
      Figure 6 Add Inbound Rule dialog box
    3. Click OK.

Check the running status of the agent on the installing node.

  • Linux OS
    1. Log in to the node where the agent is installed as user root using SSH through a cross-platform remote access tool (such as PuTTY).
    2. Run the following command to view the running status of the agent:

      service audit_agent status

      • If the following information is displayed, the agent is running properly. Go to Verifying the Result.
        1
        audit agent is running.
        
      • If no information is displayed, the agent is running abnormally. Run the following command to restart the agent:

        service audit_agent restart

  • Windows OS
    1. Open the Task Manager.
    2. Query the status of the dbss_audit_agent process.
      • If the process is running, go to Verifying the Result.
      • If the process is stopped, go to the directory where the agent installation file is stored, and double-click the start.bat file to start the audit process.

Verifying the Result

In your database, run an SQL statement on the node where the agent is installed. Choose Overview > Statements and then search for the executed statement.
  • If the SQL statement is found, the problem has been solved.
  • If the SQL statement is not found, the problem persists. Contact customer service.