spacewalk-commits July 2010

spacewalk-commits@lists.fedorahosted.org

11 participants
474 discussions

Changes to 'refs/tags/spacewalk-schema-1.1.9-1'
by Jan Pazdziora 02 Jul '10

02 Jul '10

Tag 'spacewalk-schema-1.1.9-1' created by Jan Pazdziora <jpazdziora(a)redhat.com> at 2010-07-02 15:02 +0000 Tagging package [spacewalk-schema] version [1.1.9-1] in directory [schema/spacewalk/]. Changes since spacewalk-schema-1.1.8-1: Jan Pazdziora (3): Triggers that call something in rhn_email package (schema) are not useful because we do not have rhn_email. Use the { call ... } syntax instead of the direct PL/SQL. Automatic commit of package [spacewalk-schema] release [1.1.9-1]. Michael Mraka (1): 526864 - don't allow duplicated rows in rhnServerPackage Shannon Hughes (1): bug fixes to repo sync schema upgrades and sql --- java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml | 4 java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml | 4 java/code/src/com/redhat/rhn/common/db/datasource/xml/User_queries.xml | 20 --- java/code/src/com/redhat/rhn/common/db/datasource/xml/test_queries.xml | 4 rel-eng/packages/spacewalk-schema | 2 schema/spacewalk/common/tables/rhnContentSource.sql | 4 schema/spacewalk/common/tables/rhnServerPackage.sql | 2 schema/spacewalk/postgres/triggers/rhnServerGroupMembers_email.sql | 62 ---------- schema/spacewalk/postgres/triggers/rhnUserGroupMembers_email.sql | 61 --------- schema/spacewalk/postgres/triggers/rhnUserServerGroupPerms.sql | 60 --------- schema/spacewalk/spacewalk-schema.spec | 9 + schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/001-repo-sync.sql | 13 ++ schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/019-rhnServerPackage-index.sql | 21 +++ 13 files changed, 54 insertions(+), 212 deletions(-) ---

1 0

rel-eng/packages schema/spacewalk
by Jan Pazdziora 02 Jul '10

02 Jul '10

rel-eng/packages/spacewalk-schema | 2 +- schema/spacewalk/spacewalk-schema.spec | 9 ++++++++- 2 files changed, 9 insertions(+), 2 deletions(-) New commits: commit 727e4b6134d08e3f681461638adbfc9a8849af0d Author: Jan Pazdziora <jpazdziora(a)redhat.com> Date: Fri Jul 2 17:02:52 2010 +0200 Automatic commit of package [spacewalk-schema] release [1.1.9-1]. diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema index d5f36d0..700b327 100644 --- a/rel-eng/packages/spacewalk-schema +++ b/rel-eng/packages/spacewalk-schema @@ -1 +1 @@ -1.1.8-1 schema/spacewalk/ +1.1.9-1 schema/spacewalk/ diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec index 255cbad..56df9e6 100644 --- a/schema/spacewalk/spacewalk-schema.spec +++ b/schema/spacewalk/spacewalk-schema.spec @@ -2,7 +2,7 @@ Name: spacewalk-schema Group: Applications/Internet Summary: Oracle SQL schema for Spacewalk server -Version: 1.1.8 +Version: 1.1.9 Release: 1%{?dist} Source0: %{name}-%{version}.tar.gz @@ -58,6 +58,13 @@ rm -rf $RPM_BUILD_ROOT %{_mandir}/man1/spacewalk-schema-upgrade* %changelog +* Fri Jul 02 2010 Jan Pazdziora 1.1.9-1 +- bug fixes to repo sync schema upgrades and sql (shughes(a)redhat.com) +- 526864 - don't allow duplicated rows in rhnServerPackage + (michael.mraka(a)redhat.com) +- Triggers that call something in rhn_email package (schema) are not useful + because we do not have rhn_email. + * Fri Jul 02 2010 Miroslav Suchý <msuchy(a)redhat.com> 1.1.8-1 - fix index creation and duplicite name of index (msuchy(a)redhat.com) - would be much better if it fails with error when something bad happens

1 0

schema/spacewalk
by Shannon Hughes 02 Jul '10

02 Jul '10

schema/spacewalk/common/tables/rhnContentSource.sql | 4 +-- schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/001-repo-sync.sql | 13 ++++++++++ 2 files changed, 15 insertions(+), 2 deletions(-) New commits: commit dfb1f7740dc6ebf562a78df153e9fecb7b3ee08f Author: Shannon Hughes <shughes(a)redhat.com> Date: Fri Jul 2 10:31:34 2010 -0400 bug fixes to repo sync schema upgrades and sql diff --git a/schema/spacewalk/common/tables/rhnContentSource.sql b/schema/spacewalk/common/tables/rhnContentSource.sql index 876dc7d..479bae8 100644 --- a/schema/spacewalk/common/tables/rhnContentSource.sql +++ b/schema/spacewalk/common/tables/rhnContentSource.sql @@ -20,12 +20,12 @@ create table rhnContentSource ( id number NOT NULL - constraint rhn_ccs_id_pk primary key, + constraint rhn_cs_id_pk primary key, org_id number constraint rhn_cs_org_fk references web_customer (id), type_id number NOT NULL - constraint rhn_ccs_type_fk + constraint rhn_cs_type_fk references rhnContentSourceType(id), source_url varchar2(512) NOT NULL, label varchar2(64) NOT NULL, diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/001-repo-sync.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/001-repo-sync.sql index ef7d9d7..e853e72 100644 --- a/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/001-repo-sync.sql +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/001-repo-sync.sql @@ -1,6 +1,18 @@ ALTER table rhnChannelContentSource rename to rhnContentSource; +-- remove constraint; prepare for rhnChannelContentSource uq +ALTER TABLE rhnContentSource + DROP CONSTRAINT rhn_ccs_uq; +ALTER TABLE rhnContentSource + ADD CONSTRAINT rhn_cs_uq UNIQUE (id, type_id, source_url) + USING INDEX TABLESPACE [[4m_tbs]]; +-- rename constraints +ALTER TABLE rhnContentSource + RENAME CONSTRAINT rhn_ccs_type_fk to rhn_cs_type_fk; +ALTER TABLE rhnContentSource + RENAME CONSTRAINT rhn_ccs_id_pk to rhn_cs_id_pk; + -- create new table for mapping channels and repos CREATE TABLE rhnChannelContentSource ( @@ -63,4 +75,5 @@ END; -- we don't need the channel_id column anymore since mapping table will handle it ALTER TABLE rhnContentSource DROP (channel_id); +-- remove last_synced since rhnChannel will now take care of this data ALTER TABLE rhnContentSource DROP (last_synced);

1 0

java/code
by Jan Pazdziora 02 Jul '10

02 Jul '10

java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml | 4 -- java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml | 4 -- java/code/src/com/redhat/rhn/common/db/datasource/xml/User_queries.xml | 20 ++-------- java/code/src/com/redhat/rhn/common/db/datasource/xml/test_queries.xml | 4 -- 4 files changed, 8 insertions(+), 24 deletions(-) New commits: commit 73a318ccd254d4abd16ee40f2913dc183f652f8e Author: Jan Pazdziora <jpazdziora(a)redhat.com> Date: Fri Jul 2 15:35:54 2010 +0200 Use the { call ... } syntax instead of the direct PL/SQL. diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml index 916463a..c5dd5b2 100644 --- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml +++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Org_queries.xml @@ -157,9 +157,7 @@ AND sg.org_id != 1 <callable-mode name="oai_customer_sync"> <query params="org_id"> - begin - XXRH_OAI_WRAPPER.sync_customer(:org_id); - end; + { call XXRH_OAI_WRAPPER.sync_customer(:org_id) } </query> </callable-mode> diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml index 79e10de..5b5a2a8 100644 --- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml +++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml @@ -1430,9 +1430,7 @@ SELECT 1 <callable-mode name="update_perms_for_server"> <query params="sid"> - begin - rhn_cache.update_perms_for_server(:sid); - end; + { call rhn_cache.update_perms_for_server(:sid) } </query> </callable-mode> diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/User_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/User_queries.xml index f088ac3..21c8ffc 100644 --- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/User_queries.xml +++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/User_queries.xml @@ -264,42 +264,32 @@ SELECT system_group_id <callable-mode name="oai_contact_sync"> <query params="user_id"> - begin - XXRH_OAI_WRAPPER.sync_contact(:user_id); - end; + { call XXRH_OAI_WRAPPER.sync_contact(:user_id) } </query> </callable-mode> <callable-mode name="update_perms_for_user"> <query params="user_id"> - begin - rhn_cache.update_perms_for_user(:user_id); - end; + { call rhn_cache.update_perms_for_user(:user_id) } </query> </callable-mode> <callable-mode name="delete_user"> <query params="user_id"> - begin - rhn_org.delete_user(:user_id); - end; + { call rhn_org.delete_user(:user_id) } </query> </callable-mode>  <callable-mode name="disable_user"> <query params="victim_id, admin_id"> - begin - web_disable_user_pkg.disable_user(:victim_id, :admin_id); - end; + { call web_disable_user_pkg.disable_user(:victim_id, :admin_id) } </query> </callable-mode> <callable-mode name="enable_user"> <query params="victim_id, admin_id"> - begin - web_disable_user_pkg.reenable_user(:victim_id, :admin_id); - end; + { call web_disable_user_pkg.reenable_user(:victim_id, :admin_id) } </query> </callable-mode> diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/test_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/test_queries.xml index 724164b..93b5e44 100644 --- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/test_queries.xml +++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/test_queries.xml @@ -171,9 +171,7 @@ update rhnServerGroup set group_type = :type_id where id = :sgid <callable-mode name="stored_procedure_oracle_format"> <query params="label, arch"> - begin - :arch := lookup_package_arch( :label ); - end; + { :arch = call lookup_package_arch( :label ) } </query> </callable-mode>

1 0

schema/spacewalk
by Michael Mraka 02 Jul '10

02 Jul '10

schema/spacewalk/common/tables/rhnServerPackage.sql | 2 schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/019-rhnServerPackage-index.sql | 21 ++++++++++ 2 files changed, 22 insertions(+), 1 deletion(-) New commits: commit c02321cb7ef1046c462389fbcc0f1502f9dae925 Author: Michael Mraka <michael.mraka(a)redhat.com> Date: Fri Jul 2 15:34:41 2010 +0200 526864 - don't allow duplicated rows in rhnServerPackage diff --git a/schema/spacewalk/common/tables/rhnServerPackage.sql b/schema/spacewalk/common/tables/rhnServerPackage.sql index b55ddf2..e55f8e3 100644 --- a/schema/spacewalk/common/tables/rhnServerPackage.sql +++ b/schema/spacewalk/common/tables/rhnServerPackage.sql @@ -33,7 +33,7 @@ TABLESPACE [[server_package_tablespace]] ENABLE ROW MOVEMENT ; -CREATE INDEX rhn_sp_snep_idx +CREATE UNIQUE INDEX rhn_sp_snep_uq ON rhnServerPackage (server_id, name_id, evr_id, package_arch_id) TABLESPACE [[128m_tbs]] NOLOGGING; diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/019-rhnServerPackage-index.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/019-rhnServerPackage-index.sql new file mode 100644 index 0000000..009a839 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/019-rhnServerPackage-index.sql @@ -0,0 +1,21 @@ +DELETE FROM rhnServerPackage A + WHERE EXISTS + (SELECT 1 FROM (SELECT server_id, + name_id, + evr_id, + package_arch_id, + min(created) min_created + FROM rhnServerPackage + GROUP BY server_id, name_id, evr_id, package_arch_id + HAVING count(*) > 1) N + WHERE a.server_id = n.server_id + AND a.name_id = n.name_id + AND a.evr_id = n.evr_id + AND a.package_arch_id = n.package_arch_id + AND a.created > n.min_created); + +DROP INDEX rhn_sp_snep_idx; +CREATE UNIQUE INDEX rhn_sp_snep_uq + ON rhnServerPackage (server_id, name_id, evr_id, package_arch_id) + TABLESPACE [[128m_tbs]] + NOLOGGING;

1 0

schema/spacewalk
by Jan Pazdziora 02 Jul '10

02 Jul '10

schema/spacewalk/postgres/triggers/rhnServerGroupMembers_email.sql | 62 ---------- schema/spacewalk/postgres/triggers/rhnUserGroupMembers_email.sql | 61 --------- schema/spacewalk/postgres/triggers/rhnUserServerGroupPerms.sql | 60 --------- 3 files changed, 183 deletions(-) New commits: commit b04b27c23c3dcfbd8114bd18896b4891cceba363 Author: Jan Pazdziora <jpazdziora(a)redhat.com> Date: Fri Jul 2 14:05:40 2010 +0200 Triggers that call something in rhn_email package (schema) are not useful because we do not have rhn_email. diff --git a/schema/spacewalk/postgres/triggers/rhnServerGroupMembers_email.sql b/schema/spacewalk/postgres/triggers/rhnServerGroupMembers_email.sql deleted file mode 100644 index 2e9b077..0000000 --- a/schema/spacewalk/postgres/triggers/rhnServerGroupMembers_email.sql +++ /dev/null @@ -1,62 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- --- triggers for rhnServerGroupMembers WRT email notification --- --- EXCLUDE: all --- XXX devel code, back off - -create or replace function rhn_sg_member_email_mod_trig_fun() returns trigger -as -$$ -begin - perform rhn_email.add_for_server(new.server_id); - - return new; -end; -$$ -language plpgsql; - - - - -create trigger -rhn_sg_member_email_mod_trig -before insert or update on rhnServerGroupMembers -for each row -execute procedure rhn_sg_member_email_mod_trig_fun(); - - - --- this will catch rhnServerGroup deletions and server deletions -create or replace function rhn_sg_member_email_del_trig_fun() returns trigger as -$$ -begin - perform rhn_email.add_for_server(old.server_id); -end; -$$ -language plpgsql; - - -create trigger -rhn_sg_member_email_del_trig -after delete on rhnServerGroupMembers -for each row -execute procedure rhn_sg_member_email_del_trig_fun(); - - - diff --git a/schema/spacewalk/postgres/triggers/rhnUserGroupMembers_email.sql b/schema/spacewalk/postgres/triggers/rhnUserGroupMembers_email.sql deleted file mode 100644 index 4989b77..0000000 --- a/schema/spacewalk/postgres/triggers/rhnUserGroupMembers_email.sql +++ /dev/null @@ -1,61 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- --- triggers for rhnUserGroupMembers WRT email notification --- --- EXCLUDE: all --- XXX devel code, back off - - -create or replace function rhn_ug_member_email_mod_trig_fun() returns trigger -as -$$ -begin - perform rhn_email.add_for_user(new.user_id); - - return new; -end; -$$ language plpgsql; - - -create trigger -rhn_ug_member_email_mod_trig -before insert or update on rhnUserGroupMembers -for each row -execute procedure rhn_ug_member_email_mod_trig_fun(); - - --- this will catch rhnUserGroup deletions as well -create or replace function rhn_ug_member_email_del_trig_fun() returns trigger -as -$$ -begin - perform rhn_email.add_for_user(old.user_id); -end; -$$ language plpgsql; - - - -create trigger -rhn_ug_member_email_del_trig -after delete on rhnUserGroupMembers -for each row -execute procedure rhn_ug_member_email_del_trig_fun(); - - - - diff --git a/schema/spacewalk/postgres/triggers/rhnUserServerGroupPerms.sql b/schema/spacewalk/postgres/triggers/rhnUserServerGroupPerms.sql deleted file mode 100644 index b15633b..0000000 --- a/schema/spacewalk/postgres/triggers/rhnUserServerGroupPerms.sql +++ /dev/null @@ -1,60 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- --- --- --- EXCLUDE: all --- XXX devel code, shush you. - --- updates should never happen, AFAICT. maybe make them error? - - -create or replace function rhn_usgp_email_mod_fun() returns trigger as -$$ -begin - perform rhn_email.add_for_user(new.user_id); - - return new; -end; - -$$ language plpgsql; - -create trigger -rhn_usgp_email_mod -before insert on rhnUserServerGroupPerms -for each row -execute procedure rhn_usgp_email_mod_fun(); - -create or replace function rhn_usgp_email_del_fun() returns trigger as -$$ - -begin - perform rhn_email.add_for_user(old.user_id); - - return old; -end; -$$ -language plpgsql; - - -create trigger -rhn_usgp_email_del -before delete on rhnUserServerGroupPerms -for each row -execute procedure rhn_usgp_email_del_fun(); - - - -

1 0

Changes to 'refs/tags/spacewalk-schema-1.1.8-1'
by Miroslav Suchý 02 Jul '10

02 Jul '10

Tag 'spacewalk-schema-1.1.8-1' created by Miroslav Suchý <msuchy(a)redhat.com> at 2010-07-02 10:27 +0000 Tagging package [spacewalk-schema] version [1.1.8-1] in directory [schema/spacewalk/]. Changes since spacewalk-schema-1.1.7-1: Michael Mraka (1): would be much better if it fails with error when something bad happens Miroslav Suchý (3): fix index creation and duplicite name of index add example of answers.txt file Automatic commit of package [spacewalk-schema] release [1.1.8-1]. --- rel-eng/packages/spacewalk-schema | 2 +- schema/spacewalk/common/tables/rhnContentSource.sql | 4 ++-- schema/spacewalk/oracle/start.sql | 2 +- schema/spacewalk/spacewalk-schema.spec | 7 ++++++- spacewalk/setup/answers.txt | 18 ++++++++++++++++++ spacewalk/setup/spacewalk-setup.spec | 2 +- 6 files changed, 29 insertions(+), 6 deletions(-) ---

1 0

rel-eng/packages schema/spacewalk
by Miroslav Suchý 02 Jul '10

02 Jul '10

rel-eng/packages/spacewalk-schema | 2 +- schema/spacewalk/spacewalk-schema.spec | 7 ++++++- 2 files changed, 7 insertions(+), 2 deletions(-) New commits: commit 1e6759fdab641272873d921663ff55458b742684 Author: Miroslav Suchý <msuchy(a)redhat.com> Date: Fri Jul 2 12:27:16 2010 +0200 Automatic commit of package [spacewalk-schema] release [1.1.8-1]. diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema index a594d61..d5f36d0 100644 --- a/rel-eng/packages/spacewalk-schema +++ b/rel-eng/packages/spacewalk-schema @@ -1 +1 @@ -1.1.7-1 schema/spacewalk/ +1.1.8-1 schema/spacewalk/ diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec index fc7a760..255cbad 100644 --- a/schema/spacewalk/spacewalk-schema.spec +++ b/schema/spacewalk/spacewalk-schema.spec @@ -2,7 +2,7 @@ Name: spacewalk-schema Group: Applications/Internet Summary: Oracle SQL schema for Spacewalk server -Version: 1.1.7 +Version: 1.1.8 Release: 1%{?dist} Source0: %{name}-%{version}.tar.gz @@ -58,6 +58,11 @@ rm -rf $RPM_BUILD_ROOT %{_mandir}/man1/spacewalk-schema-upgrade* %changelog +* Fri Jul 02 2010 Miroslav Suchý <msuchy(a)redhat.com> 1.1.8-1 +- fix index creation and duplicite name of index (msuchy(a)redhat.com) +- would be much better if it fails with error when something bad happens + (michael.mraka(a)redhat.com) + * Fri Jul 02 2010 Miroslav Suchý <msuchy(a)redhat.com> 1.1.7-1 - table rhnChannelContentSource depends on rhnContentSource (msuchy(a)redhat.com) - Match the types of parameters of create_new_user to those given to us by the

1 0

2 commits - schema/spacewalk spacewalk/setup
by Miroslav Suchý 02 Jul '10

02 Jul '10

schema/spacewalk/common/tables/rhnContentSource.sql | 4 ++-- spacewalk/setup/answers.txt | 18 ++++++++++++++++++ spacewalk/setup/spacewalk-setup.spec | 2 +- 3 files changed, 21 insertions(+), 3 deletions(-) New commits: commit c310088327dbf3c0a4a745db8e55cc438ea752ce Author: Miroslav Suchý <msuchy(a)redhat.com> Date: Fri Jul 2 12:02:40 2010 +0200 add example of answers.txt file diff --git a/spacewalk/setup/answers.txt b/spacewalk/setup/answers.txt new file mode 100644 index 0000000..3286958 --- /dev/null +++ b/spacewalk/setup/answers.txt @@ -0,0 +1,18 @@ +admin-email = root@localhost +ssl-set-org = Example Org +ssl-set-org-unit = Some Dept. +ssl-set-city = Brno +ssl-set-state = CZ +ssl-set-country = CZ +ssl-password = x +ssl-set-email = root@localhost +ssl-config-sslvhost = Y +satellite-cert-file = /usr/share/spacewalk/setup/spacewalk-public.cert +db-backend=oracle +db-user=foo +db-password=bar +db-sid=oracle_sid +db-host=hostname.of.your.db +db-port=1521 +db-protocol=TCP +enable-tftp=N diff --git a/spacewalk/setup/spacewalk-setup.spec b/spacewalk/setup/spacewalk-setup.spec index b629ed2..272cdce 100644 --- a/spacewalk/setup/spacewalk-setup.spec +++ b/spacewalk/setup/spacewalk-setup.spec @@ -89,7 +89,7 @@ rm -rf %{buildroot} %files %defattr(-,root,root,-) -%doc Changes README +%doc Changes README answers.txt %{perl_vendorlib}/* %{_bindir}/spacewalk-setup %{_bindir}/spacewalk-make-mount-points commit 2332403caee0ff3b726b52b83af450a54f355d4a Author: Miroslav Suchý <msuchy(a)redhat.com> Date: Fri Jul 2 11:52:33 2010 +0200 fix index creation and duplicite name of index addressing: SQL> SQL> CREATE UNIQUE INDEX rhn_ccs_uq 2 ON rhnContentSource (channel_id, type_id, source_url) 3 TABLESPACE DATA_TBS; ON rhnContentSource (channel_id, type_id, source_url) * ERROR at line 2: ORA-00904: "CHANNEL_ID": invalid identifier diff --git a/schema/spacewalk/common/tables/rhnContentSource.sql b/schema/spacewalk/common/tables/rhnContentSource.sql index d7912c3..876dc7d 100644 --- a/schema/spacewalk/common/tables/rhnContentSource.sql +++ b/schema/spacewalk/common/tables/rhnContentSource.sql @@ -39,8 +39,8 @@ rhnContentSource create sequence rhn_chan_content_src_id_seq start with 500; -create unique index rhn_ccs_uq - on rhnContentSource(channel_id, type_id, source_url) +create unique index rhn_cs_uq + on rhnContentSource(id, type_id, source_url) tablespace [[64k_tbs]] ;

1 0

schema/spacewalk
by Michael Mraka 02 Jul '10

02 Jul '10

schema/spacewalk/oracle/start.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) New commits: commit 759e64920eef5051fe8ecedebc617f7688d0e936 Author: Michael Mraka <michael.mraka(a)redhat.com> Date: Fri Jul 2 11:51:48 2010 +0200 would be much better if it fails with error when something bad happens diff --git a/schema/spacewalk/oracle/start.sql b/schema/spacewalk/oracle/start.sql index a1e60f7..093eb46 100644 --- a/schema/spacewalk/oracle/start.sql +++ b/schema/spacewalk/oracle/start.sql @@ -14,5 +14,5 @@ -- SET ECHO ON -WHENEVER SQLERROR EXIT +WHENEVER SQLERROR EXIT SQL.SQLCODE

1 0

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

spacewalk-commits July 2010