[Spacewalk-list] Spacewalk 1.7 released

[Patrick Hurrelmann]

On 07.03.2012 10:43, Jan Pazdziora wrote:
> 
> Hello friends of the walks in space,
> 
> we are happy to announce the release 1.7 of Spacewalk, a systems
> management solution.
> 
> The download locations are
> 
>   * http://spacewalk.redhat.com/yum/1.7/RHEL/5/$basearch/
>   * http://spacewalk.redhat.com/yum/1.7/RHEL/6/$basearch/
>   * http://spacewalk.redhat.com/yum/1.7/Fedora/15/x86_64/
>   * http://spacewalk.redhat.com/yum/1.7/Fedora/16/x86_64/
> 
> with client repositories under
> 
>   * http://spacewalk.redhat.com/yum/1.7-client
>   * http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/1.7/openSUSE_11.4/
>   * http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/1.7/openSUSE_12.1/
>   * http://download.opensuse.org/repositories/systemsmanagement:/spacewalk:/1.7/openSUSE_Factory/
>   * http://miroslav.suchy.cz/spacewalk/debian
> 
> For fresh installations, please use steps from
> 
>   * https://fedorahosted.org/spacewalk/wiki/HowToInstall
> 
> If you plan to upgrade from older release, the following page can be
> helpful:
> 
>   * http://fedorahosted.org/spacewalk/wiki/HowToUpgrade
> 
> Features & Enhancements in Spacewalk 1.7
> 
>   * Monitoring is now working on the PostgreSQL database backend,
>     making both database backends feature-comparable
>   * OpenSCAP integration -- for details, see
>     https://fedorahosted.org/spacewalk/wiki/Scap
>   * Fully asynchronous clearing of orphaned monitoring data
>   * Stock rhnpush is able to push debian packages
>   * New spacewalk-clone-by-date tool
>   * Numerous spacecmd enhancements
>   * Improved messages printed when certificate activation fails
>   * Modified API calls:
>       * channel.software.getDetails returns empty strings instead of
>         omitting attributes
>       * configchannel.createOrUpdatePath, createOrUpdateSymlink,
>         getEncodedFileRevision, getFileRevision, getFileRevisions,
>         lookupFileInfo, system.config.createOrUpdatePath,
>         createOrUpdateSymlink, lookupFileInfo, and
>         system.provisioning.snapshot.listSnapshotConfigFiles now return
>         contents_enc64 field which identifies whether contents is
>         Base64-encoded
>       * system.comparePackages and system.comparePackageProfile return
>         package_arch value
>       * system.provisionVirtualGuest default values now match those on
>         the WebUI
>   * New API calls:
>       * configchannel.getEncodedFileRevision
>       * system.scap.scheduleXccdfScan
> 
> The up-to-date API documentation can be found at
> 
>   * http://spacewalk.redhat.com/documentation/api/
> 
> Contributors
> 
> Our thanks go to the community members who contributed to this
> release:
> 
>   * Aron Parsons
>   * Jiří Mikulka
>   * Joerg Steffens
>   * Joshua Roys
>   * Michael Calmer
>   * Pierre Casenove
>   * Simon Lukasik
>   * Speagle, Andy
>   * Steven Hardy
> 
>   * https://fedorahosted.org/spacewalk/wiki/ContributorList
> 
> You can view the history of Spacewalk from its start to 1.7 at
> 
>   * http://www.youtube.com/watch?v=jsx6cGmBtzg
> 
> Some statistics
> 
> In Spacewalk 1.7, we've seen
> 
>   * 49 bugs fixed
>   * 1246 changesets committed
>   * 1581 commits done
> 
> Reporting errors
> 
> To report issues with Spacewalk, please use mailing list
> spacewalk-list at redhat.com to reach the user community. We might ask
> you to file bugzilla at http://bugzilla.redhat.com/ with more details
> or full logs. From now on, errors related to PostgreSQL database
> backend are considered bug defects vs. missing capabilities.
> 
> Thank you for using Spacewalk.
> 

Hi and thanks a lot!

I'm really looking forward to this new release. I just tried to upgrade
my SW 1.6 installation on CentOS 6.2 with PostgreSQL but it failed to
upgrade the database.

/usr/bin/spacewalk-schema-upgrade
Schema upgrade: [spacewalk-schema-1.6.42-1.el6] ->
[spacewalk-schema-1.7.55-1.el6]
Searching for upgrade path: [spacewalk-schema-1.6.42-1] ->
[spacewalk-schema-1.7.55-1]
Searching for upgrade path: [spacewalk-schema-1.6.42] ->
[spacewalk-schema-1.7.55]
Searching for upgrade path: [spacewalk-schema-1.6] -> [spacewalk-schema-1.7]
The path: [spacewalk-schema-1.6] -> [spacewalk-schema-1.7]
Planning to run spacewalk-sql with
[/var/log/spacewalk/schema-upgrade/20120307-112200-script.sql]
Hit Enter to continue or Ctrl+C to interrupt:
Executing spacewalk-sql, the log is in
[/var/log/spacewalk/schema-upgrade/20120307-112200-to-spacewalk-schema-1.7.log].
Upgrade failed, please see log
[/var/log/spacewalk/schema-upgrade/20120307-112200-to-spacewalk-schema-1.7.log].


Excerpt from log:
                                ?column?
-------------------------------------------------------------------------
 spacewalk-schema-1.6-to-spacewalk-schema-1.7/111-rhnPackageKey-data.sql
(1 row)

INSERT 0 1
INSERT 0 1
INSERT 0 1
COMMIT
CREATE FUNCTION
 create_varnull_constriants
----------------------------
                          0
(1 row)

psql:/var/log/spacewalk/schema-upgrade/20120307-112200-script.sql:5172:
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 rhnPackageEVR(id,
epoch, version, release, evr) values (' ||  $1  || ', ' ||
coalesce(quote_literal( $2 ), 'NULL') || ', ' || coalesce(quote_literal(
$3 ), 'NULL') || ', ' || coalesce(quote_literal( $4 ), 'NULL') || ', '
|| evr_t(coalesce(quote_literal( $2 ), 'NULL'), coalesce(quote_literal(
$3 ), 'NULL'), coalesce(quote_literal( $4 ), 'NULL')) || ')' )"
PL/pgSQL function "lookup_evr" line 14 at PERFORM


But according to the 20120307-112200-script.sql and the log it seems
that all changes were performed though?

Regards
Patrick

-- 
Lobster LOGsuite GmbH, Hauptstraße 67, D-82327 Tutzing

HRB 178831, Amtsgericht München
Geschäftsführer: Dr. Martin Fischer, Rolf Henrich