7018263: Sentinel upgrade fails with message “FATAL: password authentication failed for user “dbauser”” and “The database schema upgrade failed.”

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

Environment

NetIQ Sentinel Server 7.x

Situation

When attempting to upgrade the Sentinel server, the upgrade fails and reports the following error in the /var/opt/novell/sentinel/log/install.log:

The installed PostgreSQL Version is 9_4
The installed Sentinel version is 7_4_0_0
Backing up of the configuration data before the upgrade has not been enabled.
The operating systems SUSE Linux Enterprise Server 11 SP3 is supported.
============================================================================
Sentinel database update
============================================================================
Beginning the database update.
Config File /opt/novell/sentinel/setup/db_update/cfg/postgresql/db_patch_matrix.xml
Initializing DB connection…
Connecting to SIEM on localhost (port 5432) as dbauser, server set to postgresql
Error: Failed to get current database version: FATAL: password authentication failed for user “dbauser” – SQLState : 28P01 – ErrorCode : 0
Error: null
The database schema upgrade failed.
Log files are found in /var/opt/novell/sentinel/log/db_migration.
=============================================================================
Sentinel database update was halted.
=============================================================================

Resolution

Modify the /etc/hosts file to ensure that the loopback address is specified.

1. Navigate to the /etc directory and make a backup of the hosts file
2. Edit the hosts file and if the loopback address is commented, then uncomment it by removing the # and save the file.

E.g. 127.0.0.1localhost

3. If the loopback address is not in the hosts file, add it to the beginning of the file but at the end of the initial comments section, as in the following example:
#
# hosts This file describes a number of hostname-to-address
# mappings for the TCP/IP subsystem. It is mostly
# used at boot time, when no name servers are running.
# On small systems, this file can be used instead of a
# “named” name server.
# Syntax:
#
# IP-Address Full-Qualified-Hostname Short-Hostname
#
127.0.0.1 localhost
4. Save the hosts file
5. Reboot the server.
6. Upgrade Sentinel.

Cause

The loopback address is either not specified or commented in the /etc/hosts file.

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/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.

Related:

Leave a Reply