The smdba tool fails with a "Gate error"

This document (000020914) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Manager 4.x

Situation

When running the smdba backup tool, this fails with the following error:

General error:
Gate error: Cannot find database component tablespace on disk

Resolution

Remove restrictions in the /etc/sudoers file (using visudo) that prevents the root user from using sudo.

Cause

The sudoers file was changed to not allow root to use sudo.

Additional Information

To verify if the above is the reason, run "smdba system-check" and / or "smdba db-status" which should then return something like the below output:

smdba system-check
General error:
Gate error: Non zero exit code (1) returned while calling ['sudo', '-u', 'postgres', '/bin/bash']
STDIN:
cat - << EOF | /usr/bin/psql -t --pset footer=off susemanager
show all
EOF
STDOUT: sudo: sudoers specifies that root is not allowed to sudo

STDERR:

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.