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

Document ID : KB000122238
Last Modified Date : 03/12/2018
Show Technical Document Details
Issue:
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 '10.58.15.230' (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. 

For a full list of ports that need to be open between NFA servers please review the link below:
https://docops.ca.com/ca-network-flow-analysis/9-5-0/en/installing/system-recommendations-and-requirements/windows-servers/firewall-configuration

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 reporter
truncate table harvester_status;

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