MTP web GUI has error Could not open database connection

book

Article ID: 48908

calendar_today

Updated On:

Products

APPLICATION DELIVERY ANALYSIS SUPERAGENT

Issue/Introduction

Description:

SSUE

The MTP web GUI has the error:

Error: Could not open database connection.Error in SqlCommand at Execute :
Data in SA from the MTP remains collecting.

This is caused by corruption in the Vertica database on the MTP, usually as a result of shutting down the MTP without gracefully shutting down the Vertica db first.

<Please see attached file for image>

Figure 1

Solution:

To resolve, you must recreate the Vertica database.

  • SSH to the MTP
  • Log in using the netqos account
  • Run the following commands

sudo /opt/NetQoS/scripts/stopprocs.sh (stops all the daemon processes)
sudo /opt/NetQoS/install/setupVertica.sh --new
sudo /opt/NetQoS/install/setupReplicateMySqlToVertica.sh
sudo /opt/NetQoS/scripts/startprocs.sh

Environment

Release:
Component: NQSPRA

Attachments

1558721349587000048908_sktwi1f5rjvs16w0x.gif get_app