Error in the Management Server log is:
2012-06-29 19:21:46.995 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.
2012-06-29 19:21:46.995 DEBUG [main] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error connecting to database
java.lang.RuntimeException: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection))
The foglight.database.host that was set in the foglight.config was abcdefg123.
Apparently the firewall was changed to allow connections for the alias abc.
The foglight server had not been restarted since 1 year so the connection was never re-established until today when it failed.
Edit the server.config file to have the alias name:
foglight.database.host = abc
Now restart the FMS.
