Troubleshooting VIOM DB restoration failure on new MS server
book
Article ID: 100066073
calendar_today
Updated On:
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
Was this article helpful?
thumb_up
Yes
thumb_down
No