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| ...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 ...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 : Failed to format system error message (Error: 1813)
Issue : Able to start the application from Command Prompt and not from Services.msc. Worked fine with PGSQL but issue occurs after changing to MSSQL database Error Trace in Wrapper file :-1: Failed to format system error message (Error: 1813) ...Linux - Startup issue
System Halted error message during startup (Fresh installation) Error Trace : [16:36:59:243]|[04-15-2021]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: ErrorStream ::: /opt/MSP/ServiceDeskPlus-MSP/pgsql/bin/psql: error ...