WEBUI Could not connect to the BigFix database

Hi.

Not sure if it’s the same case, but I’ve faced troubles with WebUI everytime after server restart. Then I realised there is “Deploy/Update WebUI Database Configuration” task/fixlet in “BES Support” site.

It’s description:

This fixlet will enable setting up an installed BigFix WebUI with the configuration needed to directly access the BigFix Database, or changing an existing configuration to repair the connection or change the credentials.

This Fixlet will:

  • Send the database connection configuration to the WebUI server
  • Encrypt the database credentials
  • Store the configuration within the WebUI folder

Now I use this task everytime after server restart, and WebUI works fine.

edit: In any case, you better check this page first: Troubleshooting

Unable to establish connection to the BigFix Database

Note: If the WebUI is deployed on MSSQL, the operator will see the database configuration tester wizard. If the WebUI is deployed on DB2, the operator will not be able to see the database configuration tester wizard, and the operator must use BES Support Fixlet 2687 to resolve their database connectivity issues.

My server uses linux, and the fixlet I mentioned has ID 2687 as mentioned in documentation. If your server uses Windows, approach could be different.