[Spacewalk-list] Problem populating the database

[Max León]

Hello,

I'm attempting to do a fresh install of Spacewalk 1.7 on a CentOS 5.8 box.

I have installed postgresql 8.4 and the contrib.

I have straighten out the user, auth and the permissions for the user, also I have installed the 'plpgsql' languate on the DB engine.

It starts populating but at some point I get stuck with:

** Database: Populating database.

*** Progress: ######################

Could not populate database.

Now the log of the DB is a bit:

WARNING:  there is no transaction in progress

ERROR:  could not establish connection

DETAIL:  fe_sendauth: no password supplied

CONTEXT:  SQL statement "SELECT  dblink_connect('at_conn', 'dbname=' || current_database())"

        PL/pgSQL function "pg_dblink_exec" line 2 at PERFORM

        SQL statement "SELECT  pg_dblink_exec( 'insert into rhnPackageName(id, name) values (' ||  $1  || ', ' || coalesce(quote_literal( $2 ), 'NULL') || ')')"

        PL/pgSQL function "lookup_package_name" line 16 at PERFORM

STATEMENT:  insert into rhnPackageSyncBlacklist (package_name_id)

                values (lookup_package_name('gpg-pubkey'));

LOG:  incomplete startup packet

The odd part is that I do provide de user/password when requested by the installer and if I try this:

# psql -U spacewalk -W -d spacewalk -h localhost

Password for user spacewalk:

psql (8.4.9)

Type "help" for help.

spacewalk=# 

Any idea on where can I try to find the error?

Right now the spacewalk packages that are installed are:

spacewalk-admin-1.7.4-1.el5

spacewalk-backend-1.7.38-1.el5

spacewalk-backend-app-1.7.38-1.el5

spacewalk-backend-applet-1.7.38-1.el5

spacewalk-backend-config-files-1.7.38-1.el5

spacewalk-backend-config-files-common-1.7.38-1.el5

spacewalk-backend-config-files-tool-1.7.38-1.el5

spacewalk-backend-iss-1.7.38-1.el5

spacewalk-backend-iss-export-1.7.38-1.el5

spacewalk-backend-libs-1.7.38-1.el5

spacewalk-backend-package-push-server-1.7.38-1.el5

spacewalk-backend-server-1.7.38-1.el5

spacewalk-backend-sql-1.7.38-1.el5

spacewalk-backend-sql-postgresql-1.7.38-1.el5

spacewalk-backend-tools-1.7.38-1.el5

spacewalk-backend-xml-export-libs-1.7.38-1.el5

spacewalk-backend-xmlrpc-1.7.38-1.el5

spacewalk-backend-xp-1.7.38-1.el5

spacewalk-base-1.7.28-1.el5

spacewalk-base-minimal-1.7.28-1.el5

spacewalk-branding-1.7.1-1.el5

spacewalk-certs-tools-1.7.3-1.el5

spacewalk-common-1.7.3-1.el5

spacewalk-config-1.7.2-1.el5

spacewalk-doc-indexes-1.1.1-1.el5

spacewalk-grail-1.7.28-1.el5

spacewalk-html-1.7.28-1.el5

spacewalk-java-1.7.54-1.el5

spacewalk-java-config-1.7.54-1.el5

spacewalk-java-lib-1.7.54-1.el5

spacewalk-java-postgresql-1.7.54-1.el5

spacewalk-monitoring-1.4.1-1.el5

spacewalk-monitoring-selinux-1.7.2-1.el5

spacewalk-postgresql-1.7.3-1.el5

spacewalk-pxt-1.7.28-1.el5

spacewalk-repo-1.7-5.el5

spacewalk-schema-1.7.55-1.el5

spacewalk-search-1.7.3-1.el5

spacewalk-selinux-1.7.2-1.el5

spacewalk-setup-1.7.10-1.el5

spacewalk-setup-jabberd-1.6.5-1.el5

spacewalk-slf4j-1.6.1-1.el5

spacewalk-sniglets-1.7.28-1.el5

spacewalk-taskomatic-1.7.54-1.el5

Thank you.

[Jan Pazdziora]

On Tue, Mar 20, 2012 at 05:06:42PM -0600, Max León wrote:
> Hello,
> I'm attempting to do a fresh install of Spacewalk 1.7 on a CentOS 5.8 box.
>
> I have installed postgresql 8.4 and the contrib.
>
> I have straighten out the user, auth and the permissions for the user, also
> I have installed the 'plpgsql' languate on the DB engine.
> It starts populating but at some point I get stuck with:
> ** Database: Populating database.
> *** Progress: ######################
> Could not populate database.
>
>
> Now the log of the DB is a bit:
>
> WARNING: there is no transaction in progress
> ERROR: could not establish connection
> DETAIL: fe_sendauth: no password supplied

Please make sure you have the

local spaceschema postgres ident

near the top of your

/var/lib/pgsql/data/pg_hba.conf

file.

--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewa...@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list