How to configure permissions for Postgresql Database in Linux?
Note : Applicable only for Linux Distribution Servers
In Linux machines, due to customer environment configuration, we have been facing several issues when migrating the Application that involves upgrading PostgreSQL to higher version. Particularly, we are encountering these issues when using root user for upgrade operation.
When the upgrade is invoked as Root user, we create a new user named "postgres" in the customer environment in "other users" group. In all the below cases, the ownership of all the files will be under Root and Other users like "postgres" doesn't have read & execute permissions. Since we perform all the database operations with "postgres" user, we are facing "Permission Denied" Issue.
Resolution
When you encounter such issues, we can follow the below steps to provide sufficient permissions.
Step 1 : Set umask value equal or lesser than 022.
Umask value controls the permission of directories or file that will be created in the future. In our case, folders and files created during upgrade will inherit this permission. Hence, it should allow other users to read and execute.
Command to check the umask value
- umask
Command to set the umask value
- umask 022
Step 2 : Ensure All the parent directories provide read & execute permission for other users
Please navigate to all parent directories of product installation location and check whether it has sufficient permissions and you should provide the executable permission for other users with the command "chmod -R 755 <folder_name>" till the root directory starting from installation location. The last three digits of permission value should be rwx or r-x. it should not be like r-- or ---.
you can find the permission of a files in a directory using the below command
- ls -la
which shows the output like
drwxr-xr-x 1 <hostname> <hostname> <date & time> <folder name>
For Example, if your installation location path is /usr/share/ManageEngine/ServiceDesk, you should execute the following command.
- cd /usr/share/ManageEngine/ServiceDesk
- chmod -R 755 *
- cd ..
- chmod -R 755 ServiceDesk
- cd ..
- chmod 755 ManageEngine
- cd ..
- chmod 755 share
- cd ..
- chmod 755 usr
Step 3 : Ensure "./initpgsql" script under <product_installation_folder>/bin directory can be executed smoothly without any issues.
If you see any failures in the command output returned, Please report it to our Support with the Screenshot of output.
After all of these steps, You can proceed with the upgrade. If you face futher issues with same permission denied trace, please share the logs and output of <initpgsql.sh> script file.
New to ADSelfService Plus?
Related Articles
How to change the database from MySQL/PostgreSQL to MSSQL
The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB. For ...Securing PostgreSQL Database Connection with SSL in ServiceDeskPlus
Overview This article serves as a comprehensive guide for customers intending to secure their database connections when using with ServiceDeskPlus Application with PostgreSQL database, similar to securing Microsoft SQL Server (MSSQL) connections. The ...Migration of ServiceDesk Plus from Windows to Linux Server
The following instructions will help you migrate the ServiceDesk Plus from Windows to Linux Server 1. Take a trimmed backup using the commands below, cmd> cd [ServiceDesk-Home]\bin cmd> backupdata.bat --trimmed The backup will now be created under ...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 ...How to connect to the ServiceDesk database?
Open command prompt on the server and change the directory to MangeEngine\ServiceDesk\bin, invoke the batch file 'changeDBServer.bat' For MSSQL database Connect to the query analyzer of the SQL server and execute the queries. For PostgreSQL database ...