You do not have permission to log in. Database Error Connection not established

[andrew_gjertsen]

Description: You do not have permission to log in. Database Error Connection not established - 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

Analysis:

Here's a screenshot of the wvlog.txt.

2023-01-03 11:29:38   00004000 postgres 00187 IRPQLSRV 12.2.0       004800 - 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
2023-01-03 11:29:38   00004000 postgres 00205 IRPQLSRV 12.2.0       004800 - 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
2023-01-03 11:29:39   00004700 pqlserve 00203 IRPQLSRV 12.2.0       004800 - FIPS initialization                                                                    PQL Server Communication secured with OpenSSL FIPS 140-2 Certified Library version OpenSSL 1.0.2u-fips  20 Dec 2019
2023-01-03 11:29:58   00031402 ctradapt 00912 IRAVAYA_ 12.2.0       005056 - PACE gatherer error.                                                             31402 GWSGSipRegInfo:Cannot get password for Password Key 'SmgrWebAPIIT_HAM_SMGR'
2023-01-03 11:43:09   00001050 promgrp  05675 irpromgs 12.2.0       002008 - Process stop detected. Trying to restart.                                              AVAYA_PB:AVAYA_PBX
2023-01-03 11:43:25   00031402 ctradapt 00912 IRAVAYA_ 12.2.0       011456 - PACE gatherer error.                                                             31402 GWSGSipRegInfo:Cannot get password for Password Key 'SmgrWebAPIIT_HAM_SMGR'
2023-01-03 12:56:15   00004011 tfrsip   00448 IRAUTOAN 12.2.0       004456 - MEMORY LIMIT EXCEEDED

Here's some steps to troubleshoot

1. Definitely check the wvlog.txt
   1. As highlighted above, it kind of tells you that there's a "postgres password" issue
2. Try rebooting the server(s) because the customer could of gotten a new license and that can cause this error
   1. Also rebooting could fix a cert issue with the webpage which can cause this error 

Resolution:

Saw this error in wvlog: Internal program error - Database Exception: Message: fe_sendauth: no password supplied Connection Role: MASTER Connection Type: undefined Connection String: Driver={prognosispostgresql
So when I went into the Passwords Configuration on the Thick Client, saw both customer were missing these entries in his PASSWORD config.

PQL: prognosis
PQL: postgres
PQL: replication
ADD PASSWORD("PQL: prognosis", "prognosis"
ADD PASSWORD("PQL: postgres", "postgres"
ADD PASSWORD("PQL: replication", "replication"

Once we added those and gave the username and passwords, he was able to login to the web no problem.

The entries should look like this:

Gotchas:

When putting those entries above into the Password config, I'd recommend for both the usernames and passwords, type them out in notepad or something like that, then copy the text into the username and password fields to ensure no additional issues.

[andrew_gjertsen · Accepted solution]

**NOTE**

Don't know the cause. Could be maybe when both the Web UI and Windows Client are both used to add devices, but loosing these 3 logins without upgrade/patch is pretty rare.