Changes to 'refs/tags/spacewalk-schema-1.1.9-1'
by Jan Pazdziora
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(-)
---
13 years, 10 months
rel-eng/packages schema/spacewalk
by Jan Pazdziora
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
13 years, 10 months
schema/spacewalk
by Shannon Hughes
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);
13 years, 10 months
java/code
by Jan Pazdziora
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>
<!-- The Following two procedures are managed by the web team, we simply call them -->
<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>
13 years, 10 months
schema/spacewalk
by Michael Mraka
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;
13 years, 10 months
schema/spacewalk
by Jan Pazdziora
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();
-
-
-
-
13 years, 10 months
Changes to 'refs/tags/spacewalk-schema-1.1.8-1'
by Miroslav Suchý
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(-)
---
13 years, 10 months
rel-eng/packages schema/spacewalk
by Miroslav Suchý
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
13 years, 10 months
2 commits - schema/spacewalk spacewalk/setup
by Miroslav Suchý
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]]
;
13 years, 10 months
schema/spacewalk
by Michael Mraka
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
13 years, 10 months