Documentation Center
AlienVault® USM Appliance™

Known Issue: Update Database Option Visible in Console

Reported Version: 5.2.5
Deployment: All deployments
AlienVault Ticket ID ENG-103875

Description

In AlienVault USM Appliance the TokuDB engine was introduced in order to improve database performance. If the USM Appliance setup menu is still showing you the option for upgrading the AlienVault database, even after it has been updated, we should check to see if a database update is needed.

AlienVault USM version 5.0 Setup window with Upgrade prompt

To verify that we have the database updated (using TokuDB engine), we can execute the next instructions:

# ossim-db

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 553399

Server version: 5.6.25-73.1 Percona Server (GPL), Release 73.1, Revision 07b797f

 

Copyright (c) 2009-2015 Percona LLC and/or its affiliates

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> use alienvault_siem;

Database changed

 

mysql> show table status;

We should see some tables like acid_event and extra_data using the TokuDB engine, as shown in the next example:

Workaround

If your tables are using TokuDB like the example, a database update is not necessary. If not, please update your database according to the instructions in Updating the AlienVault USM Database Engine.