NFA Console Fails to Load with ODBC Error 80004005 After Install

Products

• Network Observability
• Network Flow Analysis

Issue/Introduction

After a new installation of NFA, the web console page fails to load․ You may initially encounter a HTTP 500 error, followed by an ODBC connection error indicating a failure to connect to the MySQL server on the default port․​​​​​​​‍​

ERROR MESSAGE:

Microsoft OLE DB Provider for ODBC drivers error '80004005'

[MySQL][ODBC 9․3(w) Driver]Can't connect to MySQL server on 'localhost:3306' (10061)

/LM/W3SVC/1/ROOT/global․asa, line 98

 

 

Environment

NFA Any Supported version

Cause

This issue occurs when the NFA services cannot read the configuration files due to missing filesystem permissions, causing the connection string to revert to default MySQL settings․

The 'IUSR' and 'IIS_IUSRS' accounts lacked permissions to the installation directory․ Consequently, the application could not read the 'my․ini' configuration file to determine the correct port (3308) and defaulted to trying port 3306, resulting in a connection failure․

Resolution

 

• VERIFY DIRECTORY PERMISSIONS

  Navigate to the NFA installation directory (Example: E:\CA\NFA )․

  Right-click the folder and select Properties > Security․

  EXPECTED: The groups 'IUSR' and 'IIS_IUSRS' should be present․

• ADD MISSING PERMISSIONS

  If missing, click Edit > Add․

  Add the following objects:

  • IUSR

  • IIS_IUSRS

  Grant them 'Read & Execute', 'List folder contents', and 'Read' permissions to the directory and all subdirectories․