Bug 509206 - Cleanup references to Xen in Action types
Summary: Cleanup references to Xen in Action types
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Virtualization
Version: 530
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Milan Zázrivec
QA Contact: Jiri Kastner
URL:
Whiteboard:
Depends On:
Blocks: sat540-blockers
TreeView+ depends on / blocked
 
Reported: 2009-07-01 18:51 UTC by Brad Buckingham
Modified: 2010-10-28 14:50 UTC (History)
7 users (show)

Fixed In Version: satellite-schema-5.4.0.4-1 spacewalk-schema-1.2.21-2
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-10-28 14:50:05 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Brad Buckingham 2009-07-01 18:51:15 UTC
Description of problem:

There are several action types that include "Xen" in the text description.  If possible, it would be good to make those references generic so that it supports other types in the future (e.g. KVM).

Examples from rhnActionType_data.sql include:

insert into rhnActionType values (36, 'virt.shutdown', 'Shuts down a Xen domain.', 'N', 'N');
insert into rhnActionType values (37, 'virt.start', 'Starts up a Xen domain.', 'N', 'N');
insert into rhnActionType values (38, 'virt.suspend', 'Suspends a Xen domain.', 'N', 'N');
insert into rhnActionType values (39, 'virt.resume', 'Resumes a Xen domain.', 'N', 'N');
insert into rhnActionType values (40, 'virt.reboot', 'Reboots a Xen domain.', 'N', 'N');
insert into rhnActionType values (41, 'virt.destroy', 'Destroys a Xen Domain.', 'N', 'N');
insert into rhnActionType values (42, 'virt.setMemory', 'Sets the maximum memory usage for a Xen domain.', 'N', 'N');
insert into rhnActionType values (48, 'virt.setVCPUs', 'Sets the Vcpu  usage for a Xen domain.', 'N', 'N');

Could be changed to: 

insert into rhnActionType values (36, 'virt.shutdown', 'Shuts down a virtual domain.', 'N', 'N');
insert into rhnActionType values (37, 'virt.start', 'Starts up a virtual domain.', 'N', 'N');
insert into rhnActionType values (38, 'virt.suspend', 'Suspends a virtual domain.', 'N', 'N');
insert into rhnActionType values (39, 'virt.resume', 'Resumes a virtual domain.', 'N', 'N');
insert into rhnActionType values (40, 'virt.reboot', 'Reboots a virtual domain.', 'N', 'N');
insert into rhnActionType values (41, 'virt.destroy', 'Destroys a virtual Domain.', 'N', 'N');
insert into rhnActionType values (42, 'virt.setMemory', 'Sets the maximum memory usage for a virtual domain.', 'N', 'N');
insert into rhnActionType values (48, 'virt.setVCPUs', 'Sets the Vcpu  usage for a virtual domain.', 'N', 'N');


Version-Release number of selected component (if applicable):
5.3.0

How reproducible:
Always

Steps to Reproduce:
1. Initiate any of the above actions from the UI and see the reference to Xen or can select the rows from the rhnActionType directly.
2.
3.
  
Actual results:
Xen included

Expected results:
something generic

Additional info:

Comment 4 Jiri Kastner 2010-10-06 13:02:20 UTC
SQL> select count(*) from rhnActionType where name like '%domain%';

  COUNT(*)
----------
	 8

SQL> select count(*) from rhnActionType where name like '%Xen%';

  COUNT(*)
----------
	 0

SQL> select count(*) from rhnActionType where name like '%xen%';

  COUNT(*)
----------
	 0

Comment 5 Michael Mráka 2010-10-20 14:40:33 UTC
Verified in stage.

[root@hp-bl685cg6-01 ~]# sqlplus $(spacewalk-cfg-get default_db)

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Oct 20 10:38:29 2010
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from rhnActionType where name like '%domain%';
  COUNT(*)
----------
         8

SQL> select count(*) from rhnActionType where name like '%Xen%';
  COUNT(*)
----------
         0

SQL> select count(*) from rhnActionType where name like '%xen%';
  COUNT(*)
----------
         0

Comment 6 Clifford Perry 2010-10-28 14:45:06 UTC
The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release. 


RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10332

RHEA-2010:0803 - RHN Tools enhancement update
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10333

RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10334

RHEA-2010:0800 - RHN Satellite Server 5.4.0
https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10335

Docs are available:

http://docs.redhat.com/docs/en-US/Red_Hat_Network_Satellite/index.html 

Regards,
Clifford


Note You need to log in before you can comment on or make changes to this bug.