The following WVLOG errors are an indication that a default password entry in Prognosis has been deleted and postgres connection is affected:
2018-10-31 01:00:57 00004000 postgres 00188 IRPQLSRV 11.5.0 002744 - Internal program error - Cannot connect to PostgreSQL for Writing: Database Exception: Message: fe_sendauth: no password supplied Connection Role: MASTER Connection Type: READ_WRITE Connection String: Driver={prognosispostgresql unicode};Server=localhost;Port=5432;Database=prognosis;Uid=prognosis;Pwd=;sslmode=require
2018-10-31 01:00:58 00004000 postgres 00206 IRPQLSRV 11.5.0 002744 - Internal program error - Cannot connect to PostgreSQL for Reading: Database Exception: Message: fe_sendauth: no password supplied Connection Role: MASTER Connection Type: READ_ONLY Connection String: Driver={prognosispostgresql unicode};Server=localhost;Port=5432;Database=prognosis;Uid=prognosis;Pwd=;sslmode=require
Root Cause: At some stage during password editing, these passwords were deleted. Possibly caused by an older password configuration being started manually
Solution: recreate the password entries as per above
Steps/Specifics
1. In the Prognosis Windows Client, locate the “Passwords” Configuration and right click and properties on that.
2. You will be presented with an input window – Click the + symbol at the top to create a new entry and enter then exactly as per above screenshot.
The password for PQL: prognosis is prognosis
The password for PQL: postgres is postgres
Note: Usernames and passwords are case sensitive. Enter them exactly as per above.
