Bug 1396921 - There are Solaris and Monitoring entries in 5.8 database schema
Summary: There are Solaris and Monitoring entries in 5.8 database schema
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 580
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Ales Dujicek
URL:
Whiteboard:
Depends On:
Blocks: sat580-upgrades
TreeView+ depends on / blocked
 
Reported: 2016-11-21 08:27 UTC by Ales Dujicek
Modified: 2017-06-21 12:19 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-06-21 12:19:34 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Ales Dujicek 2016-11-21 08:27:07 UTC
Description of problem:

5.8 Solaris and monitoring removal is not complete

Version-Release number of selected component (if applicable):
satellite-schema-5.8.0.12-1.el6sat.noarch
spacewalk-schema-2.5.1-18.el6sat.noarch

How reproducible:
always

Steps to Reproduce:
1. rhn-config-schema.pl --source=/etc/sysconfig/rhn/postgres/main.sql --target=deploy.sql --tablespace-name=data_tbs

Actual results:
deploy.sql still contains monitoring and solaris related entries


Details:
> Monitoring:
insert into rhnOrgEntitlementType (id, label, name)
        values (sequence_nextval('rhn_org_entitlement_type_seq'),
                'rhn_monitor','Red Hat Network Monitoring'
        );

insert into rhnServerGroupType (id, label, name, permanent, is_base)
        values (sequence_nextval('rhn_servergroup_type_seq'),
                'monitoring_entitled', 'RHN Monitoring Entitled Servers',
        'N', 'N'
        );

insert into rhn_config_parameter(group_name,name,value,security_type,last_update_user,last_update_date) values ( 'notification', 'fromname', 'Monitoring Satellite Notification', 'INTERNAL', 'system',current_timestamp);

-- many entries like:
insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
        values (lookup_server_arch('i386-redhat-linux'),
            lookup_sg_type('monitoring_entitled'));


> Solaris:
-- there are more entries in each table:
insert into rhnArchType (id, label, name) values
        (sequence_nextval('rhn_archtype_id_seq'), 'sysv-solaris', 'SysV-Solaris');

insert into rhnChannelArch (id, label, name, arch_type_id) values
(sequence_nextval('rhn_channel_arch_id_seq'), 'channel-sparc-sun-solaris', 'Sparc Solaris', lookup_arch_type('sysv-solaris'));

insert into rhnServerArch (id, label, name, arch_type_id) values
(sequence_nextval('rhn_server_arch_id_seq'), 'sparc-sun4m-solaris', 'Sparc Solaris', lookup_arch_type('sysv-solaris'));

insert into rhnPackageArch (id, label, name, arch_type_id) values
(sequence_nextval('rhn_package_arch_id_seq'), 'sparc-solaris', 'Sparc Solaris', lookup_arch_type('sysv-solaris'));

INSERT
  INTO rhnArchTypeActions (arch_type_id, action_style, action_type_id)
       (SELECT ArchT.id, 'install', ActionT.id
          FROM rhnArchType ArchT, rhnActionType ActionT
         WHERE ArchT.label = 'sysv-solaris'
           AND ActionT.label = 'solarispkgs.install');

insert into rhnActionType values (24, 'solarispkgs.install', 'Solaris Package Install', 'Y', 'Y');

insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-sparc-sun-solaris'), LOOKUP_PACKAGE_ARCH('sparc-solaris'));

insert into rhnChildChannelArchCompat (parent_arch_id, child_arch_id)
values (LOOKUP_CHANNEL_ARCH('channel-sparc'), LOOKUP_CHANNEL_ARCH('channel-sparc-sun-solaris'));

insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('sparc-solaris'), LOOKUP_PACKAGE_ARCH('noarch-solaris'), current_timestamp, current_timestamp);

insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
(LOOKUP_SERVER_ARCH('sparc-sun4m-solaris'), LOOKUP_CHANNEL_ARCH('channel-sparc-sun-solaris'));

insert into rhnServerPackageArchCompat
(server_arch_id, package_arch_id, preference) values
(LOOKUP_SERVER_ARCH('sparc-sun4m-solaris'), LOOKUP_PACKAGE_ARCH('sparc.sun4u-solaris'), 10);

insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
   values (lookup_server_arch('sparc-sun4m-solaris'),
           lookup_sg_type('enterprise_entitled'));


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