cancel
Showing results for 
Search instead for 
Did you mean: 

Default Password missing - Cannot connect to PostgreSQL

Highlighted
06 Trekker

Default Password missing - Cannot connect to PostgreSQL

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.

Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar