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;
New to ADSelfService Plus?
Related Articles
Scheduled Backup failure due to permission issue in pgsql folder
Error Traces: [com.adventnet.db.adapter.BackupRestoreUtil]|[WARNING]|[250]: pg_basebackup: could not get write-ahead log end position from server: ERROR: could not open file "./pg_hba.conf_3may23.bkp": Permission denied| ...Startup issue in Linux after fresh installation_Error code 10001
In certain scenario, the application cannot be started just after the fresh install. Below are the error traces, [06:24:57:427]|[10-11-2021]|[pglog]|[INFO]|[18]: -sh: 1: /root/ManageEngine/ServiceDeskPlus-MSP/pgsql/bin/pg_ctl: Permission denied| ...Application startup issue due to mismatch in java
A startup issue after the upgrade to the version 14.3 Error message: "Application startup halted due to mismatch in java". Issue: After a JRE upgrade, typically, if the "jre_old" folder exists, it will be deleted. Then, the "jre" folder will be ...Unable to start the application after power failure
Issue: In certain cases, after a power failure, when the server restarts, the application fails to start and we could see indexoutofboundsexception in the log traces. Cause: This error occurs because the license file gets corrupted which may be due ...Failed to start the database
For the error "Failed to start the database", Check what database being used and, execute changeDBServer.bat. For Pgsql, Start PGSQL from the command link, execute StartDB.bat 65432 under C:\Manageengine\ServiceDesk\bin 65432 is the default port ...