cancel
Showing results for 
Search instead for 
Did you mean: 

Default Password missing - Cannot connect to PostgreSQL

Highlighted
Staff

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: The Journey to Microsoft Teams - Readiness Phase (part 2)

Having looked at the planning phase in session one of this series, we will turn our focus to the readiness phase. The all important technical capabilities assessment, ensuring the network, endpoints and users are adequately prepared for the move.

Hear first hand from IR's Global Head of Information Systems and Technology, Jason Schwendinger, on how he has been tackling these issues.

Join webinar