System Status shows "Database Down" and "ODBC Connect Service State is Down"
search cancel

System Status shows "Database Down" and "ODBC Connect Service State is Down"

book

Article ID: 122238

calendar_today

Updated On: 09-09-2024

Products

Network Flow Analysis

Issue/Introduction

The NFA Admin->System Status page shows errors like below for the Harvester:

Database Down
ODBC Connect Service State is Down



The Watchdog*.log files from the \CA\NFA\Reporter\Logs directory show errors like:
 ERROR HY000] [MySQL][ODBC 5.3(w) Driver]Can't connect to MySQL server on 'x.x.x.x' (10060)
System.Data.Odbc.OdbcException (0x80131937):

When testing a remote Mysql connection from the Console server to the Harvester using the command below, the same error is seen:

mysql -D harvester -unetqos -pnetqos -h  x.x.x.x

ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (10060) 

Environment

NFA all versions

Cause

Blocked firewall port. 

Resolution

Ensure that any external or Windows/Linux firewalls between the Console and the harvester allow ports 161 and 3308 to allow the Watchdog Service to Poll all of the NFA Servers. 


Once the MySql connection is opened up, the error may persist. 
To resolve this, on the NFA Console server, open a command prompt and run:

mysql -unetqos -pnetqos reporter
truncate table harvester_status;




Then restart the Netqos ReporterAnalyzer Watchdog service, and wait a few minutes, then refresh the NFA System Status page. 

Additional Information

Added mysql PW to command