How to solve the unable to login or create first user for web interface in satellite 5.7?

Solution Verified - Updated -

Environment

  • Red Hat Satellite 5.7

Issue

  • Unable to login into the satellite web interface or to create the first admin user.
  • When trying to login there is an Internal Server Error.
  • While resetting user password on Satellite v 5.7 webui, it fails with Internal Server Error

Resolution

  • Make sure the database schema is up to date on the Satellite server.
# rpm -q satellite-schema
# rhn-schema-version
  • If not, upgrade the database schema.
# spacewalk-schema-upgrade
  • If still the issue is not resolved, please call Red Hat support for the next steps which involve manual sql execution.
    Note: Please take a backup of the database

Root Cause

  • The column userinfo0_.tasko_notify does not exist in the database.

Diagnostic Steps

Verify the contents of the following log file: /var/log/tomcat6/catalina.out

Caused by:
org.postgresql.util.PSQLException: ERROR: column userinfo0_.tasko_notify does not exist
  Position: 174
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:269)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1985)
        at org.hibernate.loader.Loader.doQuery(Loader.java:838)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:298)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:280)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:2060)
        ... 77 more

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.