-
Title
Foglight Server Startup page reports "Database LifecycleService Stopped." -
Description
When starting Foglight Management Server (FMS) the "Server Startup" splash screen (C:\Quest_Software\Foglight\state\splash\foglightStartup.html) reports the following error:
"Database LifecycleService Stopped."
The Foglight Management Server log shows the following:
"FATAL [main] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error connecting to database. Shutting down Foglight server... Check and make sure your database configuration is correct and the database server is up running. "
and:
"java.lang.Exception: Fatal error connecting to database"
-
Cause
Possible causes:
- The FMS cannot contact the SQL Server host machine (network name resolution problems, firewall blocking, etc)
- The external SQL Server database has not been started, not attached to the SQL Server database engine or has been deleted from the SQL Server database repository.
- If "database offline", "database detached" or "database deleted" errors are the same in the management server logs.
- After a failed upgrade the FMS database is corrupted
-
Resolution
FMS cannot contact the SQL Server host machine:
From the FMS machine:
- reference the database host that is listed in "\fms_home\config\server.config". For example:foglight.database.host = "MyDatabaseHost";
foglight.database.port = "1433";
foglight.database.name = "foglight";
foglight.database.user = "foglight";
foglight.database.password = "q25f5a0c606fa55f9ee9dc65f698d8e6d";
foglight.database.type = "sqlsvr";Can the FMS machine ping "MyDatabaseHost" ? If not, make sure that name resolution works.Is there a firewall between the FMS machine and the SQL Server machine? For testing turn off the firewall on the FMS and SQL Server machine and retest the startup.If there is a hardware firewall between the FMS and SQL Server machine, make sure the port listed in the Foglight config file is open on that firewall?Has someone changed or disabled the user or changed the password to access the Foglight database on the SQL Server instance? The "foglight.database.password" parameter that is stored in Foglight config file, as an encrypted string - "q25f5a0c606fa55f9ee9dc65f698d8e6d" which is the word "foglight". Try to connect to the database as foglight.database.user?Database is detached:
First check if the physical mdf and ldf files of the database are still exist. The database can be dropped, specifying to leave the files intact. If they are there, reattach the database using SQL Management Studio using the "attach" command.
Database removed from SQL inventory:
If a valid recent SQL Server backup or a Litespeed backup of the external Foglight database exist, restore this.
If the database has been restored and the database ownership has not been modified, it should not affect the Foglight server startup. However it is advised to alter the database owner back to user "foglight" using the following command in SQL Query window:
- Stop the Foglight server/processes
- Execute command: sp_changedbowner 'foglight', local
- Then verify using this command: sp_helpdb 'foglightexternaldbname'
- Start the Foglight Management Server.
Failed Upgrade:
Restore the FMS database from the backup which has been taken before the upgrade.