Changes to 'refs/tags/spacewalk-java-1.7.50-1'
by Tomas Lestach
Tag 'spacewalk-java-1.7.50-1' created by Tomas Lestach <tlestach(a)redhat.com> at 2012-03-01 12:59 +0000
Tagging package [spacewalk-java] version [1.7.50-1] in directory [java/].
Changes since spacewalk-schema-1.7.52-1:
Tomas Lestach (2):
do not check removed acl
Automatic commit of package [spacewalk-java] release [1.7.50-1].
---
java/code/webapp/WEB-INF/nav/channel_detail.xml | 2 +-
java/spacewalk-java.spec | 6 +++++-
rel-eng/packages/spacewalk-java | 2 +-
3 files changed, 7 insertions(+), 3 deletions(-)
---
12 years, 2 months
java/spacewalk-java.spec rel-eng/packages
by Tomas Lestach
java/spacewalk-java.spec | 6 +++++-
rel-eng/packages/spacewalk-java | 2 +-
2 files changed, 6 insertions(+), 2 deletions(-)
New commits:
commit 088fa6a11abd35bc1fb1c223e939e2ffd31b3ac7
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Thu Mar 1 13:59:32 2012 +0100
Automatic commit of package [spacewalk-java] release [1.7.50-1].
diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec
index cc1cf61..bafbe48 100644
--- a/java/spacewalk-java.spec
+++ b/java/spacewalk-java.spec
@@ -17,7 +17,7 @@ Name: spacewalk-java
Summary: Spacewalk Java site packages
Group: Applications/Internet
License: GPLv2
-Version: 1.7.49
+Version: 1.7.50
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -585,6 +585,10 @@ fi
%{jardir}/postgresql-jdbc.jar
%changelog
+* Thu Mar 01 2012 Tomas Lestach <tlestach(a)redhat.com> 1.7.50-1
+- do not check removed acl (tlestach(a)redhat.com)
+- remove hibernate not-null constraint on bug.summary (tlestach(a)redhat.com)
+
* Wed Feb 29 2012 Tomas Lestach <tlestach(a)redhat.com> 1.7.49-1
- remove unused method and appropriate query (tlestach(a)redhat.com)
- remove unused method and appropriate query (tlestach(a)redhat.com)
diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java
index f4b78d3..1b2fc4c 100644
--- a/rel-eng/packages/spacewalk-java
+++ b/rel-eng/packages/spacewalk-java
@@ -1 +1 @@
-1.7.49-1 java/
+1.7.50-1 java/
12 years, 2 months
java/code
by Tomas Lestach
java/code/webapp/WEB-INF/nav/channel_detail.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit cacf91862817dace8ac8e08de105e827ba9df6aa
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Thu Mar 1 13:54:35 2012 +0100
do not check removed acl
diff --git a/java/code/webapp/WEB-INF/nav/channel_detail.xml b/java/code/webapp/WEB-INF/nav/channel_detail.xml
index e14b388..55d99a9 100644
--- a/java/code/webapp/WEB-INF/nav/channel_detail.xml
+++ b/java/code/webapp/WEB-INF/nav/channel_detail.xml
@@ -30,6 +30,6 @@
<rhn-tab-url>/rhn/channels/TargetSystems.do</rhn-tab-url>
<rhn-tab-url>/rhn/channels/TargetSystemsConfirm.do</rhn-tab-url>
</rhn-tab>
- <rhn-tab name="Downloads" acl="channel_has_downloads()" url="/rhn/software/channel/downloads/Download.do" />
+ <rhn-tab name="Downloads" url="/rhn/software/channel/downloads/Download.do" />
</rhn-navi-tree>
12 years, 2 months
Changes to 'refs/tags/spacewalk-schema-1.7.52-1'
by Jan Pazdziora
Tag 'spacewalk-schema-1.7.52-1' created by Jan Pazdziora <jpazdziora(a)redhat.com> at 2012-03-01 12:25 +0000
Tagging package [spacewalk-schema] version [1.7.52-1] in directory [schema/spacewalk/].
Changes since spacewalk-selinux-1.7.2-1:
Jan Pazdziora (2):
Create the dblink* functions during schema upgrade as well.
Automatic commit of package [spacewalk-schema] release [1.7.52-1].
Milan Zazrivec (3):
use autonomous_transaction for insert only
use pg_dblink_exec to execute insert inside lookup_xccdf_profile
lookup_xccdf_profile: schema upgrade
Tomas Lestach (1):
remove hibernate not-null constraint on bug.summary
---
java/code/src/com/redhat/rhn/domain/errata/impl/PublishedBug.hbm.xml | 3
java/code/src/com/redhat/rhn/domain/errata/impl/UnpublishedBug.hbm.xml | 3
rel-eng/packages/spacewalk-schema | 2
schema/spacewalk/oracle/procs/insert_xccdf_profile.sql | 27 +++++
schema/spacewalk/oracle/procs/lookup_xccdf_profile.sql | 48 ++++-----
schema/spacewalk/oracle/procs/procs.deps | 3
schema/spacewalk/postgres/procs/insert_xccdf_profile.sql | 2
schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql | 52 +++++-----
schema/spacewalk/postgres/procs/procs.deps | 2
schema/spacewalk/spacewalk-schema.spec | 9 +
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.oracle | 39 +++++++
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.postgresql | 34 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.postgresql | 4
14 files changed, 176 insertions(+), 53 deletions(-)
---
12 years, 2 months
2 commits - rel-eng/packages schema/spacewalk
by Jan Pazdziora
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 9 ++++++++-
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.oracle | 1 +
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.postgresql | 4 ++++
4 files changed, 14 insertions(+), 2 deletions(-)
New commits:
commit e715270c078cb39783144dfa18b1ea8b6904ad87
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Mar 1 13:25:30 2012 +0100
Automatic commit of package [spacewalk-schema] release [1.7.52-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 632eac5..d3dc60c 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.7.51-1 schema/spacewalk/
+1.7.52-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index bd841b6..6b0387e 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.7.51
+Version: 1.7.52
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -66,6 +66,13 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Thu Mar 01 2012 Jan Pazdziora 1.7.52-1
+- Create the dblink* functions during schema upgrade as well.
+- lookup_xccdf_profile: schema upgrade (mzazrivec(a)redhat.com)
+- use pg_dblink_exec to execute insert inside lookup_xccdf_profile
+ (mzazrivec(a)redhat.com)
+- use autonomous_transaction for insert only (mzazrivec(a)redhat.com)
+
* Wed Feb 29 2012 Jan Pazdziora 1.7.51-1
- Blend is case sensitive, let's try to play by its rules.
- remove unused data from the rhnUserGroupType table (tlestach(a)redhat.com)
commit e84e664bf0eebda98561d958c5293a95e7eb5933
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Mar 1 13:23:09 2012 +0100
Create the dblink* functions during schema upgrade as well.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.postgresql
new file mode 100644
index 0000000..4c6a2ff
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/109-dblink.sql.postgresql
@@ -0,0 +1,4 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+
+\i /usr/share/pgsql/contrib/dblink.sql
+
12 years, 2 months
java/code
by Tomas Lestach
java/code/src/com/redhat/rhn/domain/errata/impl/PublishedBug.hbm.xml | 3 +--
java/code/src/com/redhat/rhn/domain/errata/impl/UnpublishedBug.hbm.xml | 3 +--
2 files changed, 2 insertions(+), 4 deletions(-)
New commits:
commit 51b8596b9cf1394116e39dbbf7c166c78a379280
Author: Tomas Lestach <tlestach(a)redhat.com>
Date: Thu Mar 1 13:05:23 2012 +0100
remove hibernate not-null constraint on bug.summary
this causes troubles, when cloning Red Hat errata, where bug.summary isn't filled
diff --git a/java/code/src/com/redhat/rhn/domain/errata/impl/PublishedBug.hbm.xml b/java/code/src/com/redhat/rhn/domain/errata/impl/PublishedBug.hbm.xml
index 85094cd..ee7220f 100644
--- a/java/code/src/com/redhat/rhn/domain/errata/impl/PublishedBug.hbm.xml
+++ b/java/code/src/com/redhat/rhn/domain/errata/impl/PublishedBug.hbm.xml
@@ -12,8 +12,7 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
<key-property name="id" column="bug_id" type="long"/>
</composite-id>
- <property name="summary" column="summary" type="string" length="4000"
- not-null="true"/>
+ <property name="summary" column="summary" type="string" length="4000"/>
<property name="url" column="href" type="string" length="255" />
<property name="created" column="created" type="timestamp"
insert="false" update="false"/>
diff --git a/java/code/src/com/redhat/rhn/domain/errata/impl/UnpublishedBug.hbm.xml b/java/code/src/com/redhat/rhn/domain/errata/impl/UnpublishedBug.hbm.xml
index b1e4a4d..f50788d 100644
--- a/java/code/src/com/redhat/rhn/domain/errata/impl/UnpublishedBug.hbm.xml
+++ b/java/code/src/com/redhat/rhn/domain/errata/impl/UnpublishedBug.hbm.xml
@@ -12,8 +12,7 @@ PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
<key-property name="id" column="bug_id" type="long"/>
</composite-id>
- <property name="summary" column="summary" type="string" length="4000"
- not-null="true"/>
+ <property name="summary" column="summary" type="string" length="4000"/>
<property name="url" column="href" type="string" length="255" />
<property name="created" column="created" type="timestamp"
insert="false" update="false"/>
12 years, 2 months
3 commits - schema/spacewalk
by Milan Zazrivec
schema/spacewalk/oracle/procs/insert_xccdf_profile.sql | 27 +++++
schema/spacewalk/oracle/procs/lookup_xccdf_profile.sql | 48 ++++-----
schema/spacewalk/oracle/procs/procs.deps | 3
schema/spacewalk/postgres/procs/insert_xccdf_profile.sql | 2
schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql | 52 +++++-----
schema/spacewalk/postgres/procs/procs.deps | 2
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.oracle | 39 +++++++
schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.postgresql | 34 ++++++
8 files changed, 160 insertions(+), 47 deletions(-)
New commits:
commit 989bf5ca4a5edfe0b716100f4e39f182d878b3d0
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu Mar 1 11:23:05 2012 +0100
lookup_xccdf_profile: schema upgrade
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.oracle
new file mode 100644
index 0000000..af34125
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.oracle
@@ -0,0 +1,39 @@
+create or replace function
+insert_xccdf_profile(identifier_in in varchar2, title_in in varchar2)
+return number
+is
+ pragma autonomous_transaction;
+ profile_id number;
+begin
+ insert into rhnXccdfProfile (id, identifier, title)
+ values (rhn_xccdf_profile_id_seq.nextval, identifier_in, title_in) returning id into profile_id;
+ commit;
+ return profile_id;
+end;
+/
+show errors
+
+create or replace function
+lookup_xccdf_profile(identifier_in in varchar2, title_in in varchar2)
+return number
+is
+ profile_id number;
+begin
+ select id
+ into profile_id
+ from rhnXccdfProfile
+ where identifier = identifier_in and title = title_in;
+ return profile_id;
+exception when no_data_found then
+ begin
+ profile_id := insert_xccdf_profile(identifier_in, title_in);
+ exception when dup_val_on_index then
+ select id
+ into profile_id
+ from rhnXccdfProfile
+ where identifier = identifier_in and title = title_in;
+ end;
+ return profile_id;
+end lookup_xccdf_profile;
+/
+show errors
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.postgresql
new file mode 100644
index 0000000..1cb8a02
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.6-to-spacewalk-schema-1.7/108-lookup_xccdf_profile.sql.postgresql
@@ -0,0 +1,34 @@
+-- oracle equivalent source sha1 cbf75718e61e14bc1e042d56b023ed99ff74ff1c
+
+create or replace function
+lookup_xccdf_profile(identifier_in in varchar, title_in in varchar)
+returns numeric
+as
+$$
+declare
+ profile_id numeric;
+begin
+ select id
+ into profile_id
+ from rhnXccdfProfile
+ where identifier = identifier_in and title = title_in;
+
+ if not found then
+ profile_id := nextval('rhn_xccdf_profile_id_seq');
+ begin
+ perform pg_dblink_exec(
+ 'insert into rhnXccdfProfile (id, identifier, title) values (' ||
+ profile_id || ', ' ||
+ coalesce(quote_literal(identifier_in), 'NULL') || ', ' ||
+ coalesce(quote_literal(title_in), 'NULL') || ')' );
+ exception when unique_violation then
+ select id
+ into profile_id
+ from rhnXccdfProfile
+ where identifier = identifier_in and title = title_in;
+ end;
+ end if;
+
+ return profile_id;
+end;
+$$ language plpgsql;
commit cbbbc3f97ecf5b343427074d579e9ccbc22e68a3
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu Mar 1 11:18:21 2012 +0100
use pg_dblink_exec to execute insert inside lookup_xccdf_profile
diff --git a/schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql b/schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql
index a930f44..8644be8 100644
--- a/schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql
+++ b/schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql
@@ -14,27 +14,35 @@
-- in this software or its documentation.
--
-CREATE OR REPLACE FUNCTION
-lookup_xccdf_profile(identifier_in IN VARCHAR, title_in IN VARCHAR)
-RETURNS NUMERIC
-AS
+create or replace function
+lookup_xccdf_profile(identifier_in in varchar, title_in in varchar)
+returns numeric
+as
$$
-DECLARE
- profile_id NUMERIC;
-BEGIN
- SELECT id
- INTO profile_id
- FROM rhnXccdfProfile
- WHERE identifier = identifier_in
- AND title = title_in;
+declare
+ profile_id numeric;
+begin
+ select id
+ into profile_id
+ from rhnXccdfProfile
+ where identifier = identifier_in and title = title_in;
- IF NOT FOUND THEN
- INSERT INTO rhnXccdfProfile (id, identifier, title)
- VALUES (nextval('rhn_xccdf_profile_id_seq'),
- identifier_in, title_in)
- RETURNING id INTO profile_id;
- END IF;
+ if not found then
+ profile_id := nextval('rhn_xccdf_profile_id_seq');
+ begin
+ perform pg_dblink_exec(
+ 'insert into rhnXccdfProfile (id, identifier, title) values (' ||
+ profile_id || ', ' ||
+ coalesce(quote_literal(identifier_in), 'NULL') || ', ' ||
+ coalesce(quote_literal(title_in), 'NULL') || ')' );
+ exception when unique_violation then
+ select id
+ into profile_id
+ from rhnXccdfProfile
+ where identifier = identifier_in and title = title_in;
+ end;
+ end if;
- RETURN profile_id;
-END;
-$$ LANGUAGE PLPGSQL;
+ return profile_id;
+end;
+$$ language plpgsql;
diff --git a/schema/spacewalk/postgres/procs/procs.deps b/schema/spacewalk/postgres/procs/procs.deps
index bd5e893..06f303d 100644
--- a/schema/spacewalk/postgres/procs/procs.deps
+++ b/schema/spacewalk/postgres/procs/procs.deps
@@ -108,6 +108,8 @@ lookup_xccdf_benchmark :: rhnXccdfBenchmark pg_dblink_exec
lookup_xccdf_ident :: rhnXccdfIdentSystem \
rhnXccdfIdent \
pg_dblink_exec
+lookup_xccdf_profile :: rhnXccdfProfile \
+ pg_dblink_exec
pxt_session_cleanup :: PXTSessions
queue_server :: rhnServerNeededPackageCache rhnTaskQueue \
rhnServer \
commit 6811a60ea283408078f1ca9d80f4830c143c0098
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu Mar 1 11:10:27 2012 +0100
use autonomous_transaction for insert only
diff --git a/schema/spacewalk/oracle/procs/insert_xccdf_profile.sql b/schema/spacewalk/oracle/procs/insert_xccdf_profile.sql
new file mode 100644
index 0000000..9bb528d
--- /dev/null
+++ b/schema/spacewalk/oracle/procs/insert_xccdf_profile.sql
@@ -0,0 +1,27 @@
+-- Copyright (c) 2012 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.
+
+create or replace function
+insert_xccdf_profile(identifier_in in varchar2, title_in in varchar2)
+return number
+is
+ pragma autonomous_transaction;
+ profile_id number;
+begin
+ insert into rhnXccdfProfile (id, identifier, title)
+ values (rhn_xccdf_profile_id_seq.nextval, identifier_in, title_in) returning id into profile_id;
+ commit;
+ return profile_id;
+end;
+/
+show errors
diff --git a/schema/spacewalk/oracle/procs/lookup_xccdf_profile.sql b/schema/spacewalk/oracle/procs/lookup_xccdf_profile.sql
index abbf837..1ccacdf 100644
--- a/schema/spacewalk/oracle/procs/lookup_xccdf_profile.sql
+++ b/schema/spacewalk/oracle/procs/lookup_xccdf_profile.sql
@@ -1,4 +1,3 @@
---
-- Copyright (c) 2012 Red Hat, Inc.
--
-- This software is licensed to you under the GNU General Public License,
@@ -11,29 +10,28 @@
-- 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.
---
-CREATE OR REPLACE FUNCTION
-lookup_xccdf_profile(identifier_in IN VARCHAR2, title_in IN VARCHAR2)
-RETURN NUMBER
-IS
- PRAGMA AUTONOMOUS_TRANSACTION;
- profile_id NUMBER;
-BEGIN
- SELECT id
- INTO profile_id
- FROM rhnXccdfProfile
- WHERE identifier = identifier_in
- AND title = title_in;
- RETURN profile_id;
-EXCEPTION
- WHEN NO_DATA_FOUND THEN
- INSERT INTO rhnXccdfProfile (id, identifier, title)
- VALUES (rhn_xccdf_profile_id_seq.nextval,
- identifier_in, title_in)
- RETURNING id INTO profile_id;
- COMMIT;
- RETURN profile_id;
-END lookup_xccdf_profile;
+create or replace function
+lookup_xccdf_profile(identifier_in in varchar2, title_in in varchar2)
+return number
+is
+ profile_id number;
+begin
+ select id
+ into profile_id
+ from rhnXccdfProfile
+ where identifier = identifier_in and title = title_in;
+ return profile_id;
+exception when no_data_found then
+ begin
+ profile_id := insert_xccdf_profile(identifier_in, title_in);
+ exception when dup_val_on_index then
+ select id
+ into profile_id
+ from rhnXccdfProfile
+ where identifier = identifier_in and title = title_in;
+ end;
+ return profile_id;
+end lookup_xccdf_profile;
/
-SHOW ERRORS
+show errors
diff --git a/schema/spacewalk/oracle/procs/procs.deps b/schema/spacewalk/oracle/procs/procs.deps
index b55f698..eb44188 100644
--- a/schema/spacewalk/oracle/procs/procs.deps
+++ b/schema/spacewalk/oracle/procs/procs.deps
@@ -70,6 +70,7 @@ insert_tag_name :: rhnTagName
insert_transaction_package :: rhnTransactionPackage
insert_xccdf_benchmark :: rhnXccdfBenchmark
insert_xccdf_ident_system :: rhnXccdfIdentSystem
+insert_xccdf_profile :: rhnXccdfProfile
is_user_applicant :: rhnUserGroupType web_contact rhnUserGroup \
rhnUserGroupMembers
lookup_arch_type :: data/rhnArchType rhn_exception.pks
@@ -120,6 +121,8 @@ lookup_xccdf_ident :: insert_xccdf_ident \
insert_xccdf_ident_system \
rhnXccdfIdentSystem \
rhnXccdfIdent
+lookup_xccdf_profile :: insert_xccdf_profile \
+ rhnXccdfProfile
pxt_session_cleanup :: PXTSessions
queue_server :: rhnServerNeededPackageCache rhnTaskQueue \
rhnServer \
diff --git a/schema/spacewalk/postgres/procs/insert_xccdf_profile.sql b/schema/spacewalk/postgres/procs/insert_xccdf_profile.sql
new file mode 100644
index 0000000..7d74f15
--- /dev/null
+++ b/schema/spacewalk/postgres/procs/insert_xccdf_profile.sql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 6890e6ed27e8fae8e53cc2f6648efe05d6cf5340
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql b/schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql
index 4c0e49d..a930f44 100644
--- a/schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql
+++ b/schema/spacewalk/postgres/procs/lookup_xccdf_profile.sql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 883bbbca80021e8954b5ecc532bed962416807ad
+-- oracle equivalent source sha1 9d091d9787a9a3353e6e1b6d13b430f836dfad89
--
-- Copyright (c) 2012 Red Hat, Inc.
--
12 years, 2 months
Changes to 'refs/tags/spacewalk-selinux-1.7.2-1'
by Jan Pazdziora
Tag 'spacewalk-selinux-1.7.2-1' created by Jan Pazdziora <jpazdziora(a)redhat.com> at 2012-03-01 08:33 +0000
Tagging package [spacewalk-selinux] version [1.7.2-1] in directory [selinux/spacewalk-selinux/].
Changes since osad-5.10.40-1:
Jan Pazdziora (2):
Allow PostgreSQL to use dblink.
Automatic commit of package [spacewalk-selinux] release [1.7.2-1].
---
rel-eng/packages/spacewalk-selinux | 2 +-
selinux/spacewalk-selinux/spacewalk-selinux.spec | 5 ++++-
selinux/spacewalk-selinux/spacewalk.te | 8 ++++++++
3 files changed, 13 insertions(+), 2 deletions(-)
---
12 years, 2 months
2 commits - rel-eng/packages selinux/spacewalk-selinux
by Jan Pazdziora
rel-eng/packages/spacewalk-selinux | 2 +-
selinux/spacewalk-selinux/spacewalk-selinux.spec | 5 ++++-
selinux/spacewalk-selinux/spacewalk.te | 8 ++++++++
3 files changed, 13 insertions(+), 2 deletions(-)
New commits:
commit 8a34be96b42965215b6f3336bab8df0d72288397
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Mar 1 09:33:58 2012 +0100
Automatic commit of package [spacewalk-selinux] release [1.7.2-1].
diff --git a/rel-eng/packages/spacewalk-selinux b/rel-eng/packages/spacewalk-selinux
index e2f27e7..1edcfd4 100644
--- a/rel-eng/packages/spacewalk-selinux
+++ b/rel-eng/packages/spacewalk-selinux
@@ -1 +1 @@
-1.7.1-1 selinux/spacewalk-selinux/
+1.7.2-1 selinux/spacewalk-selinux/
diff --git a/selinux/spacewalk-selinux/spacewalk-selinux.spec b/selinux/spacewalk-selinux/spacewalk-selinux.spec
index 0db99da..a0e1862 100644
--- a/selinux/spacewalk-selinux/spacewalk-selinux.spec
+++ b/selinux/spacewalk-selinux/spacewalk-selinux.spec
@@ -7,7 +7,7 @@
%define modulename spacewalk
Name: spacewalk-selinux
-Version: 1.7.1
+Version: 1.7.2
Release: 1%{?dist}
Summary: SELinux policy module supporting Spacewalk Server
@@ -113,6 +113,9 @@ fi
%attr(0755,root,root) %{_sbindir}/%{name}-enable
%changelog
+* Thu Mar 01 2012 Jan Pazdziora 1.7.2-1
+- Allow PostgreSQL to use dblink.
+
* Tue Feb 14 2012 Tomas Lestach <tlestach(a)redhat.com> 1.7.1-1
- rename rhn-installation.log to rhn_installation.log (tlestach(a)redhat.com)
- Bumping package versions for 1.7. (mzazrivec(a)redhat.com)
commit d74c2075f0547e90a59cf36b31eaf074232062bb
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Mar 1 08:46:03 2012 +0100
Allow PostgreSQL to use dblink.
diff --git a/selinux/spacewalk-selinux/spacewalk.te b/selinux/spacewalk-selinux/spacewalk.te
index ed1932b..908958c 100644
--- a/selinux/spacewalk-selinux/spacewalk.te
+++ b/selinux/spacewalk-selinux/spacewalk.te
@@ -94,3 +94,11 @@ optional_policy(`
# rpm_dontaudit_search_db(httpd_t) is not available on RHELs
dontaudit httpd_t rpm_var_lib_t:dir list_dir_perms;
dontaudit httpd_t rpm_var_lib_t:file read_file_perms;
+
+# Allow PostgreSQL to use dblink
+optional_policy(`
+ gen_require(`
+ type postgresql_t;
+ ')
+ allow postgresql_t self:unix_stream_socket { connectto };
+')
12 years, 2 months
Changes to 'refs/tags/osad-5.10.40-1'
by Miroslav Suchý
Tag 'osad-5.10.40-1' created by Miroslav Suchý <msuchy(a)redhat.com> at 2012-03-01 08:16 +0000
Tagging package [osad] version [5.10.40-1] in directory [client/tools/osad/].
Changes since spacewalk-schema-1.7.51-1:
Miroslav Suchý (2):
creating files for %ghost should be done in %install instead of %build
Automatic commit of package [osad] release [5.10.40-1].
---
client/tools/osad/osad.spec | 11 +++++++----
rel-eng/packages/osad | 2 +-
2 files changed, 8 insertions(+), 5 deletions(-)
---
12 years, 2 months