Unable to start the application due to Pgsql privilege issue
ISSUE:
Application does not start via both services and command prompt.
ERROR TRACE:
Serverout:
[16:26:36:443]|[05-10-2023]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[SEVERE]|[27]: Exception occurred while obtaining mode of the database| [16:26:36:443]|[05-10-2023]|[SYSERR]|[INFO]|[27]: java.sql.SQLException: ERROR: permission denied for function pg_is_in_recovery|
Wrapper:
Problem while Starting Server
INFO | jvm 1 | 2023/09/28 08:32:56 | System halted
STATUS | wrapper | 2023/09/28 08:32:58 | JVM process exited with a code of -1, setting the Wrapper exit code to -1.
STATUS | wrapper | 2023/09/28 08:32:58 | -1: Failed to format system error message (Error: 1001) (Original Error: 0xffffffff)
STATUS | wrapper | 2023/09/28 08:32:58 | <-- Wrapper Stopped
SOLUTION:
>> Open the command prompt as an administrator and navigate to the following location: Drive:\ManageEngine\ServiceDeskPlus MSP\pgsql\bin. Then, execute the command below:
psql.exe -U postgres -p 65432 -d servicedesk -h 127.0.0.1
>> The password for the postgres user is "For password contact support".
>> Once you are connected, execute the following query and check the output:
\df+ pg_is_in_recovery;
>> Next, execute the following query to resolve the issue and start the application:
GRANT ALL ON FUNCTION pg_is_in_recovery() to sdpadmin;