Answer
PROBLEM
The GFI LanGuard console hangs without displaying any error message.Consulting the EventViewer - Application log you see the Error (1002) : "The program LanGuard.exe stopped interacting with Windows and was closed"
Inspecting the log: lanss_v114_dashboard.csv - you notice the following error:
"error ","CrmiModule","Given DB connection is null."
ENVIRONMENT
- GFI LanGuard 2012 and newer versions
- GFI LanGuard is using an SQL Database
SOLUTION
Verify that the user logged into the server has access to the SQL Database following this procedure:- Open File Explorer and enable View > File name extensions
- Create an empty document on the Desktop | rightClick > New > Text Document
- Rename the new text document and change its extensions to .udl and open it with doubleClick
- Test the connection to the SQL DB using Windows Authentication or specific user name and password, depending on which settings you've configured in GFI LanGuard
- If the connection fails, troubleshoot your SQL Server
- Navigated to GFI LanGuard configuration files, usually located in: C:\ProgramData\GFI\LanGuard 11
- Open the XML file named: toolcfg_database.xml (rightClick > Edit)
- Locate the key: <Option Name="DbType"><![CDATA[1]]></Option> and change the CDATA value from [1] to [0]
- This will change the Database type of GFI LanGuard from SQL to Access
- Navigate the Console to: Configuration > Database Maintenance Options > Database backend settings...
- Reconnect your SQL Database
- The issue you were experiencing should be fixed
CAUSE
When the GFI LanGuard Console launches it pulls out all the settings from XML files in ProgramData/GFI and initiates a connection to the configured Database.Usually GFI LanGuard should display a connection error to the database, unless the database is corrupt and needs repair.