Disable Write-Ahead Logging

Required Tenable Security Center User Role: Root user

Note: This topic assumes a basic understanding of Linux.

If you experience issues with write-ahead logging (WAL), disable WAL by reverting your Tenable Security Center Director databases to DELETE journaling mode. For more information, see Tenable Security Center Director Database Journaling Modes.

Before you begin:

  • Perform a backup of Tenable Security Center Director, as described in Perform a Backup.

To disable WAL:

  1. Log in to Tenable Security Center Director via the command line interface (CLI).

  2. Stop Tenable Security Center Director, as described in Start, Stop, or Restart Tenable Security Center Director.

  3. In the CLI in Tenable Security Center Director, run the following command to start the converDatabaseMode.php script:

    /opt/sc/support/bin/php /opt/sc/src/tools/convertDatabaseMode.php -m DELETE

    The script runs.

  4. If the script detects any running tns user processes, repeat the following steps for each tns user process detected:

    1. Follow the prompts in the error output to halt the tns user process.

      Example error output:

      Error! The Tenable Security Center process with PID '10135' is still running and needs to be halted before this script can be executed successfully.

         Command: /opt/sc/support/bin/php -f /opt/sc/daemons/Jobd.php

      Bailing with 146.

    2. Run the following command to restart the converDatabaseMode.php script:

      /opt/sc/support/bin/php /opt/sc/src/tools/convertDatabaseMode.php -m DELETE

      The script restarts.

    Tenable Security Center Director converts supported databases to DELETE journaling mode. For more information, see Databases Affected.

  5. Start Tenable Security Center Director, as described in Start, Stop, or Restart Tenable Security Center Director.

What to do next:

  • Perform regular backups of Tenable Security Center Director, as described in Perform a Backup.