Troubleshooting VIOM DB restoration failure on new MS server

book

Article ID: 100066073

calendar_today

Updated On:

Description

Error Message

 

Cause

The ownership and permissions settings for various VIOM directories were checked and it was confirmed that /opt/VRTSsfmcs/pgsql/bin had the correct ownership (ie habdbsync:habdbsync) and that the pgsql binary existed. However, the permissions for /vomdb/var/opt/VRTSsfmcs/db/data and the /vomdb/opt/VRTSsfmcs/db/.VRTSsfmcs/db/data  link were not correct, thus causing the permission error.

 

Resolution

The VIOM services were stopped and the permissions (either 777 or 700 can be used)  and ownership ( habdbsync:habdbsync ) were set. Then the VIOM services were successfully restarted and VIOM was confirmed to be working properly.

 

 

Issue/Introduction

The VIOM DB restoration process failed on a new MS server running RHEL 8.9. When attempting to start the VIOM database service using the following command: # su habdbsync -c "LD_LIBRARY_PATH=/opt/VRTSsfmcs/pgsql/lib; export LD_LIBRARY_PATH; /opt/VRTSsfmcs/pgsql/bin/pg_ctl -o '-p 5636' -w start -D /vomdb/opt/VRTSsfmcs/db/data " an error message indicating a permissions issue with pgsql was reported.

Additional Information

JIRA: STESC-8808