On Tue, 2009-08-11 at 14:59 -0500, Pradeep Kilambi wrote: > If you ran the upgrade scripts, there should a update table to > default > to sha1 for existing channels. > > spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnChannel.sql is > the > one I believe. > > ~ Prad
I ran all of the upgrade scripts per the upgrade documentation. This was the output in the logs. SQL> select 'spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnChannel.sql' from dual; 'SPACEWALK-SCHEMA-0.5-TO-SPACEWALK-SCHEMA-0.6/191-RHNCHANNEL.SQ --------------------------------------------------------------- spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnChannel.sql SQL> -- Add a checksum_type_id column, and fk to rhnChecksumType SQL> ALTER TABLE rhnChannel 2 ADD checksum_type_id number 3 CONSTRAINT rhn_channel_checksum_fk 4 REFERENCES rhnChecksumType(id); Table altered. SQL> SQL> -- Update any existing channels that are not set SQL> UPDATE rhnChannel SET 2 checksum_type_id = (select id 3 from rhnChecksumType 4 where LABEL = 'sha1') 5 WHERE checksum_type_id is null; 23 rows updated. SQL> SQL> show errors No errors. SQL> commit; Commit complete. Thoughts? Andy
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Spacewalk-devel mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-devel
