spacwalk-services can not be started after migration from SUSE Manager 3.2 to 4.1

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

Environment

SUSE Manager Server 3.2
SUSE Manager Server 4.1

Situation

spacewalk services can not be started correctly after migration from SUSE Manager 3.2 to 4.1 with the following error message:

Starting spacewalk services...
  Running DB schema upgrade. This may take a while.
  Call the following command to see progress: journalctl -f -u uyuni-check-database.service
? uyuni-check-database.service - Uyuni check database
   Loaded: loaded (/usr/lib/systemd/system/uyuni-check-database.service; static; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2021-01-12 15:15:49 CET; 107ms ago
  Process: 24243 ExecStart=/usr/sbin/spacewalk-startup-helper check-database (code=exited, status=1/FAILURE)
Main PID: 24243 (code=exited, status=1/FAILURE)

Jan 12 15:15:49 xxdevmon systemd[1]: Starting Uyuni check database...
Jan 12 15:15:49 xxdevmon spacewalk-startup-helper[24243]: psql: error: FATAL:  password authentication failed for user "susemanager"
Jan 12 15:15:49 xxdevmon spacewalk-startup-helper[24243]: Database version '' is not supported for SUSE Manager/Uyuni on SUSE Linux Enterprise Server 15 SP2. Perform database migration.

Resolution

Set the correct database password into /etc/rhn/rhn.conf and verify that by running:

somehostname:~ # echo "show server_version;" | spacewalk-sql --select-mode -
 server_version
----------------
 12.5
(1 row)

Cause

Database password (db_password) in /etc/rhn/rhn.conf is not correct. You can verify that the password for susemanager user is correct by running:

echo "show server_version;" | spacewalk-sql --select-mode -

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.