The NFA Admin->System Status page shows errors like below for the Harvester:
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:
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;
Added mysql PW to command