WebUI login page Issue

Post WebUI installation the initial page says "The WebUI is Initializing. The login screen will appear shortly but even I waited more than a day, but still login page not loaded

Log -Login

2018-06-21T11:58:23.293Z bf:login:error Error: write EPROTO 101057795:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol:openssl\ssl\s23_clnt.c:827:

at exports._errnoException (util.js:1020:11)
at WriteWrap.afterWrite (net.js:812:14)

Thu, 21 Jun 2018 11:58:23 GMT bf:bfquery:error GET https://localhost:5000/current-apps failed: Error: write EPROTO 101057795:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol:openssl\ssl\s23_clnt.c:827:

2018-06-21T11:58:23.415Z bf:login:error Error: write EPROTO 101057795:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol:openssl\ssl\s23_clnt.c:827:

at exports._errnoException (util.js:1020:11)
at WriteWrap.afterWrite (net.js:812:14)

Sounds like a configuration issue with WebUI. Are there any other errors in the other WebUI logs? Typically when the “WebUI is initializing” message remains up for longer than expected it’s due to database connectivity or related issues.

Please re-post with any additional errors from the other WebUI logs and we’ll go from there.

Thu, 21 Jun 2018 17:41:05 GMT bf:appmonitor:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:41:05 GMT bf:appmonitor:debug For Autopatch app, nodeArgs:
Thu, 21 Jun 2018 17:41:05 GMT bf:appmonitor:debug [ ‘–expose_gc’, ‘–max-old-space-size=8192’ ]
Thu, 21 Jun 2018 17:42:15 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:42:15 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:42:15 GMT bf:appmonitor:debug sync pending sites
Thu, 21 Jun 2018 17:42:15 GMT bf:appmonitor:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:42:15 GMT bf:appmonitor:debug For Autopatch app, nodeArgs:
Thu, 21 Jun 2018 17:42:15 GMT bf:appmonitor:debug [ ‘–expose_gc’, ‘–max-old-space-size=8192’ ]
Thu, 21 Jun 2018 17:43:25 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:43:25 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:43:25 GMT bf:appmonitor:debug sync pending sites
Thu, 21 Jun 2018 17:43:25 GMT bf:appmonitor:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:43:25 GMT bf:appmonitor:debug For Autopatch app, nodeArgs:
Thu, 21 Jun 2018 17:43:25 GMT bf:appmonitor:debug [ ‘–expose_gc’, ‘–max-old-space-size=8192’ ]
Thu, 21 Jun 2018 17:44:35 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:44:35 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:44:36 GMT bf:appmonitor:debug sync pending sites
Thu, 21 Jun 2018 17:44:36 GMT bf:appmonitor:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:44:36 GMT bf:appmonitor:debug For Autopatch app, nodeArgs:
Thu, 21 Jun 2018 17:44:36 GMT bf:appmonitor:debug [ ‘–expose_gc’, ‘–max-old-space-size=8192’ ]
Thu, 21 Jun 2018 17:45:46 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:45:46 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:45:46 GMT bf:appmonitor:debug sync pending sites
Thu, 21 Jun 2018 17:45:46 GMT bf:appmonitor:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:45:46 GMT bf:appmonitor:debug For Autopatch app, nodeArgs:
Thu, 21 Jun 2018 17:45:46 GMT bf:appmonitor:debug [ ‘–expose_gc’, ‘–max-old-space-size=8192’ ]
Thu, 21 Jun 2018 17:46:56 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:46:56 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:46:56 GMT bf:appmonitor:debug sync pending sites
Thu, 21 Jun 2018 17:46:56 GMT bf:appmonitor:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:46:56 GMT bf:appmonitor:debug For Autopatch app, nodeArgs:
Thu, 21 Jun 2018 17:46:56 GMT bf:appmonitor:debug [ ‘–expose_gc’, ‘–max-old-space-size=8192’ ]
Thu, 21 Jun 2018 17:48:06 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:48:06 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:48:06 GMT bf:appmonitor:debug sync pending sites
Thu, 21 Jun 2018 17:48:06 GMT bf:appmonitor:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:48:06 GMT bf:appmonitor:debug For Autopatch app, nodeArgs:
Thu, 21 Jun 2018 17:48:06 GMT bf:appmonitor:debug [ ‘–expose_gc’, ‘–max-old-space-size=8192’ ]
Thu, 21 Jun 2018 17:49:16 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:49:16 GMT bf:bfquery:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:49:17 GMT bf:appmonitor:debug sync pending sites
Thu, 21 Jun 2018 17:49:17 GMT bf:appmonitor:debug GET https://prod.bigfix.com:52315/api/webui-sites
Thu, 21 Jun 2018 17:49:17 GMT bf:appmonitor:debug For Autopatch app, nodeArgs:
Thu, 21 Jun 2018 17:49:17 GMT bf:appmonitor:debug [ ‘–expose_gc’, ‘–max-old-space-size=8192’

ed, 20 Jun 2018 21:55:41 GMT bf:datasync:initialize:debug Updating schema version at 2018-06-20T21:55:41+00:00
Wed, 20 Jun 2018 21:55:41 GMT bf:datasync:initialize:debug Schema version update completed at 2018-06-20T21:55:41+00:00
Wed, 20 Jun 2018 21:55:41 GMT bf:datasync:initialize:debug Successfully completed initialization at 2018-06-20T21:55:41+00:00
2018-06-21T11:45:14.683Z bf:bfapp:debug datasync 1.0.0 listening on port 5003 in production mode
Thu, 21 Jun 2018 11:45:16 GMT bf:datasync:initialize:debug Beginning initialization at 2018-06-21T11:45:16+00:00
Thu, 21 Jun 2018 11:45:16 GMT bf:datasync:initialize:debug Initiating Cache Refresh with TTL : 600 sec
Thu, 21 Jun 2018 11:45:20 GMT bf:datasync:initialize:debug Reset completed, Check if need to reset sequence
Thu, 21 Jun 2018 11:45:20 GMT bf:datasync:initialize:debug sequence check completed, initializing custom app tables at 2018-06-21T11:45:20+00:00
Thu, 21 Jun 2018 11:45:20 GMT bf:datasync:initialize:debug Creating tables!
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Custom app table initialization completed at 2018-06-21T11:45:21+00:00
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Table definitions have not changed, skipping initialization
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Functions definitions have not changed, skipping initialization
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug View definitions have not changed, skipping initialization
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Initializing stored procedures at: 2018-06-21T11:45:21+00:00
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Removing any existing stored procedures.
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Finished removing any existing stored procedures.
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Stored procedure initialization completed at 2018-06-21T11:45:21+00:00
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Index definitions have not changed, skipping initialization
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Updating schema version at 2018-06-21T11:45:21+00:00
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Schema version update completed at 2018-06-21T11:45:21+00:00
Thu, 21 Jun 2018 11:45:21 GMT bf:datasync:initialize:debug Successfully completed initialization at 2018-06-21T11:45:21+00:00

Can you configure WebUI to directly access the BigFix server SQL database directly?

It looks like you are using the ETL process. Mi was unable to use that method and had to switch to direct SQL access for WebUI.

Hi Tim - WebUI server able to access directly to SQL DB. Double validated Port 1433 is Telnet working from WebUI Server

@yuvarajdass- I am assuming this is a brand new WebUI installation. A few questions.

Question

  1. What values did you specify for the config values?
  2. Assuming this is Windows.
  3. is MsSQL on box or off?
  4. if you utilized a Windows Account (domain or local) does that account have appropriate rights to the BigFix database?

-Jgo

2 Likes

@yuvarajdass Are you able to solve the issue? If you are still stuck at the initialization page, you can open a PMR with your logs and we will dig into it.

Finally identified the issue, due to the same port number issued in different application. It got resolved.