Changes to 'refs/tags/spacewalk-java-1.2.115-1'
by Lukas Zapletal
Tag 'spacewalk-java-1.2.115-1' created by Lukas Zapletal <lzap+git(a)redhat.com> at 2010-11-25 12:13 +0000
Tagging package [spacewalk-java] version [1.2.115-1] in directory [java/].
Changes since spacewalk-web-1.2.28-1:
Lukas Zapletal (2):
Bug 657259 - Enable Spacewalk Configuration Management fails
Automatic commit of package [spacewalk-java] release [1.2.115-1].
---
java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml | 2 +-
java/spacewalk-java.spec | 5 ++++-
rel-eng/packages/spacewalk-java | 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
---
13 years, 5 months
Branch 'SPACEWALK-1.2' - 2 commits - java/code java/spacewalk-java.spec rel-eng/packages
by Lukas Zapletal
java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml | 2 +-
java/spacewalk-java.spec | 5 ++++-
rel-eng/packages/spacewalk-java | 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
New commits:
commit 9c2ee356ddb22291f01f438a1380dfd35aed487e
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 13:13:08 2010 +0100
Automatic commit of package [spacewalk-java] release [1.2.115-1].
diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec
index b2a808d..d8e8b95 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.2.114
+Version: 1.2.115
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -434,6 +434,9 @@ fi
%{jardir}/postgresql-jdbc.jar
%changelog
+* Thu Nov 25 2010 Lukas Zapletal 1.2.115-1
+- Bug 657259 - Enable Spacewalk Configuration Management fails
+
* Thu Nov 25 2010 Lukas Zapletal 1.2.114-1
- Fixing two queries in system overview (monitoring)
- Replacing DECODE with ANSI compatible CASE-WHEN
diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java
index abb6d1e..9702a58 100644
--- a/rel-eng/packages/spacewalk-java
+++ b/rel-eng/packages/spacewalk-java
@@ -1 +1 @@
-1.2.114-1 java/
+1.2.115-1 java/
commit 18ef32f067f1e7953cce59de2b07d03667082094
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 11:56:46 2010 +0100
Bug 657259 - Enable Spacewalk Configuration Management fails
Adressing
ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while
processing cached statement sql: INSERT INTO rhnActionPackage (id,
action_id, name_id, evr_id) VALUES (sequence_nextval('rhn_act_p_id_seq', ?,
?, ?) com.redhat.rhn.common.db.WrappedSQLException: ORA-00917: missing comma
introduced by e79ff356
(cherry picked from commit 1780a77532906d137a750f4606c4c9a1dae50f12)
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
index 520662c..fc365c7 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
@@ -281,7 +281,7 @@ VALUES (sequence_nextval('rhn_act_p_id_seq'), :action_id, :name_id, :evr_id, :ar
<write-mode name="schedule_action_no_arch">
<query params="action_id, name_id, evr_id">
INSERT INTO rhnActionPackage (id, action_id, name_id, evr_id)
-VALUES (sequence_nextval('rhn_act_p_id_seq', :action_id, :name_id, :evr_id)
+VALUES (sequence_nextval('rhn_act_p_id_seq'), :action_id, :name_id, :evr_id)
</query>
</write-mode>
13 years, 5 months
Changes to 'refs/tags/spacewalk-java-1.3.16-1'
by Lukas Zapletal
Tag 'spacewalk-java-1.3.16-1' created by Lukas Zapletal <lzap+git(a)redhat.com> at 2010-11-25 12:11 +0000
Tagging package [spacewalk-java] version [1.3.16-1] in directory [java/].
Changes since spacewalk-reports-1.3.1-1:
Lukas Zapletal (2):
Bug 657259 - Enable Spacewalk Configuration Management fails
Automatic commit of package [spacewalk-java] release [1.3.16-1].
Michael Mraka (2):
don't require server unsubscribe when --skip-channels is used
fixed typo
---
backend/satellite_tools/spacewalk-remove-channel | 40 +++++-----
java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml | 2
java/spacewalk-java.spec | 5 +
rel-eng/packages/spacewalk-java | 2
4 files changed, 27 insertions(+), 22 deletions(-)
---
13 years, 5 months
2 commits - java/code java/spacewalk-java.spec rel-eng/packages
by Lukas Zapletal
java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml | 2 +-
java/spacewalk-java.spec | 5 ++++-
rel-eng/packages/spacewalk-java | 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
New commits:
commit 3ae17201c707421e7696a1529bccbb446ad915c5
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 13:11:28 2010 +0100
Automatic commit of package [spacewalk-java] release [1.3.16-1].
diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec
index f0d2e94..5a6dd12 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.3.15
+Version: 1.3.16
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -446,6 +446,9 @@ fi
%{jardir}/postgresql-jdbc.jar
%changelog
+* Thu Nov 25 2010 Lukas Zapletal 1.3.16-1
+- Bug 657259 - Enable Spacewalk Configuration Management fails
+
* Wed Nov 24 2010 Lukas Zapletal 1.3.15-1
- 615026 - [Multi-Org] Grants for channel permission edits throws ISE
- 642226 - do not look for the VT channel in case of RHEL6 base channels
diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java
index 5c37dc1..cf5a659 100644
--- a/rel-eng/packages/spacewalk-java
+++ b/rel-eng/packages/spacewalk-java
@@ -1 +1 @@
-1.3.15-1 java/
+1.3.16-1 java/
commit 1780a77532906d137a750f4606c4c9a1dae50f12
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 11:56:46 2010 +0100
Bug 657259 - Enable Spacewalk Configuration Management fails
Adressing
ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while
processing cached statement sql: INSERT INTO rhnActionPackage (id,
action_id, name_id, evr_id) VALUES (sequence_nextval('rhn_act_p_id_seq', ?,
?, ?) com.redhat.rhn.common.db.WrappedSQLException: ORA-00917: missing comma
at
com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:84)
at
com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
at
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)
introduced by e79ff356
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
index 99c61d9..ee0de64 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Action_queries.xml
@@ -281,7 +281,7 @@ VALUES (sequence_nextval('rhn_act_p_id_seq'), :action_id, :name_id, :evr_id, :ar
<write-mode name="schedule_action_no_arch">
<query params="action_id, name_id, evr_id">
INSERT INTO rhnActionPackage (id, action_id, name_id, evr_id)
-VALUES (sequence_nextval('rhn_act_p_id_seq', :action_id, :name_id, :evr_id)
+VALUES (sequence_nextval('rhn_act_p_id_seq'), :action_id, :name_id, :evr_id)
</query>
</write-mode>
13 years, 5 months
backend/satellite_tools
by Michael Mraka
backend/satellite_tools/spacewalk-remove-channel | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 6b1f330f58573c2858a07f56a527bb7fedfeec26
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Nov 25 10:20:44 2010 +0100
fixed typo
diff --git a/backend/satellite_tools/spacewalk-remove-channel b/backend/satellite_tools/spacewalk-remove-channel
index 62f1dd9..65a2280 100755
--- a/backend/satellite_tools/spacewalk-remove-channel
+++ b/backend/satellite_tools/spacewalk-remove-channel
@@ -127,7 +127,7 @@ def main():
if child_test_fail:
return -1
- if not options.skip_channels
+ if not options.skip_channels:
if __serverCheck(channels.keys(), options.unsubscribe):
return -1
13 years, 5 months
backend/satellite_tools
by Michael Mraka
backend/satellite_tools/spacewalk-remove-channel | 40 ++++++++++++-----------
1 file changed, 21 insertions(+), 19 deletions(-)
New commits:
commit 4bd2be58dc7da4a43804bd3cf7c8610e5afe284f
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Nov 25 10:11:51 2010 +0100
don't require server unsubscribe when --skip-channels is used
diff --git a/backend/satellite_tools/spacewalk-remove-channel b/backend/satellite_tools/spacewalk-remove-channel
index 7e58ab0..62f1dd9 100755
--- a/backend/satellite_tools/spacewalk-remove-channel
+++ b/backend/satellite_tools/spacewalk-remove-channel
@@ -107,30 +107,32 @@ def main():
if not dict_label.has_key(channel):
print "Unknown channel %s" % channel
return -1
- # Sanity check: verify subchannels are deleted as well if base
- # channels are selected
- if not dict_parents.has_key(channel):
- continue
- # this channel is a parent channel?
- children = []
- for subch in dict_parents[channel]:
- if not channels.has_key(subch):
- child_test_fail = True
- children.append(subch)
- if children:
- print "Error: cannot remove channel %s: subchannel(s) exist: " %(
- channel)
- for child in children:
- print "\t\t\t" + child
+ if not options.skip_channels:
+ # Sanity check: verify subchannels are deleted as well if base
+ # channels are selected
+ if not dict_parents.has_key(channel):
+ continue
+ # this channel is a parent channel?
+ children = []
+ for subch in dict_parents[channel]:
+ if not channels.has_key(subch):
+ child_test_fail = True
+ children.append(subch)
+ if children:
+ print "Error: cannot remove channel %s: subchannel(s) exist: " %(
+ channel)
+ for child in children:
+ print "\t\t\t" + child
if child_test_fail:
return -1
- if __serverCheck(channels.keys(), options.unsubscribe):
- return -1
+ if not options.skip_channels
+ if __serverCheck(channels.keys(), options.unsubscribe):
+ return -1
- if __kickstartCheck(channels.keys()):
- return -1
+ if __kickstartCheck(channels.keys()):
+ return -1
try:
13 years, 5 months
Changes to 'refs/tags/spacewalk-web-1.2.28-1'
by Lukas Zapletal
Tag 'spacewalk-web-1.2.28-1' created by Lukas Zapletal <lzap+git(a)redhat.com> at 2010-11-25 09:08 +0000
Tagging package [spacewalk-web] version [1.2.28-1] in directory [web/].
Changes since spacewalk-java-1.2.114-1:
Lukas Zapletal (1):
Automatic commit of package [spacewalk-web] release [1.2.28-1].
---
rel-eng/packages/spacewalk-web | 2 +-
web/spacewalk-web.spec | 5 ++++-
2 files changed, 5 insertions(+), 2 deletions(-)
---
13 years, 5 months
Changes to 'refs/tags/spacewalk-java-1.2.114-1'
by Lukas Zapletal
Tag 'spacewalk-java-1.2.114-1' created by Lukas Zapletal <lzap+git(a)redhat.com> at 2010-11-25 09:08 +0000
Tagging package [spacewalk-java] version [1.2.114-1] in directory [java/].
Changes since spacewalk-java-1.2.113-1:
Lukas Zapletal (4):
Adding missing monitoring state (UNKNOWN)
Replacing DECODE with ANSI compatible CASE-WHEN
Fixing two queries in system overview (monitoring)
Automatic commit of package [spacewalk-java] release [1.2.114-1].
---
java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml | 49 +++++-----
java/spacewalk-java.spec | 7 +
rel-eng/packages/spacewalk-java | 2
web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 4
4 files changed, 38 insertions(+), 24 deletions(-)
---
13 years, 5 months
Branch 'SPACEWALK-1.2' - 5 commits - java/code java/spacewalk-java.spec rel-eng/packages web/modules web/spacewalk-web.spec
by Lukas Zapletal
java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml | 49 +++++-----
java/spacewalk-java.spec | 7 +
rel-eng/packages/spacewalk-java | 2
rel-eng/packages/spacewalk-web | 2
web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml | 4
web/spacewalk-web.spec | 5 -
6 files changed, 43 insertions(+), 26 deletions(-)
New commits:
commit 0a049a0cee5dee1b9063000af23fc02c88f9cdcf
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 10:08:35 2010 +0100
Automatic commit of package [spacewalk-web] release [1.2.28-1].
diff --git a/rel-eng/packages/spacewalk-web b/rel-eng/packages/spacewalk-web
index 79d13ee..6056d59 100644
--- a/rel-eng/packages/spacewalk-web
+++ b/rel-eng/packages/spacewalk-web
@@ -1 +1 @@
-1.2.27-1 web/
+1.2.28-1 web/
diff --git a/web/spacewalk-web.spec b/web/spacewalk-web.spec
index 4e6d83e..c45103c 100644
--- a/web/spacewalk-web.spec
+++ b/web/spacewalk-web.spec
@@ -2,7 +2,7 @@ Name: spacewalk-web
Summary: Spacewalk Web site packages
Group: Applications/Internet
License: GPLv2
-Version: 1.2.27
+Version: 1.2.28
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -256,6 +256,9 @@ rm -rf $RPM_BUILD_ROOT
# $Id$
%changelog
+* Thu Nov 25 2010 Lukas Zapletal 1.2.28-1
+- Adding missing monitoring state (UNKNOWN)
+
* Mon Nov 15 2010 Jan Pazdziora 1.2.27-1
- bumping api version (jsherril(a)redhat.com)
commit 70be4c8c6406e48a8378d1fbbb46e190876e4cc9
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 10:08:21 2010 +0100
Automatic commit of package [spacewalk-java] release [1.2.114-1].
diff --git a/java/spacewalk-java.spec b/java/spacewalk-java.spec
index 8f7a89e..b2a808d 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.2.113
+Version: 1.2.114
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -434,6 +434,11 @@ fi
%{jardir}/postgresql-jdbc.jar
%changelog
+* Thu Nov 25 2010 Lukas Zapletal 1.2.114-1
+- Fixing two queries in system overview (monitoring)
+- Replacing DECODE with ANSI compatible CASE-WHEN
+- Adding missing monitoring state (UNKNOWN)
+
* Thu Nov 18 2010 Jan Pazdziora 1.2.113-1
- Turning off checkstyle in the java spec for F14 (cherry picked from commit
2e31f06f5cbb580cc5c82ab6421d315139c1a72a) (lzap+git(a)redhat.com)
diff --git a/rel-eng/packages/spacewalk-java b/rel-eng/packages/spacewalk-java
index 65b7f78..abb6d1e 100644
--- a/rel-eng/packages/spacewalk-java
+++ b/rel-eng/packages/spacewalk-java
@@ -1 +1 @@
-1.2.113-1 java/
+1.2.114-1 java/
commit 90c046fee5ec0d35d3672456f25294edf4f5490f
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 10:07:37 2010 +0100
Fixing two queries in system overview (monitoring)
There were problems with ANSI LEFT OUTER JOIN syntax for PG. It was
incorrect. Now the query was rewritten to be ANSI compatible correctly.
(cherry picked from commit f8fc790513588228feb21b97b590e63fa01bf64b)
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 94f34e4..7f00d80 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
@@ -1189,11 +1189,12 @@ select distinct sgm.server_id as ID, 1 as virtual_host
</query>
<query name="system_overview_most_critical" params="">
- SELECT SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA, ENHANCEMENT_ERRATA, OUTDATED_PACKAGES, SERVER_NAME,
+ SELECT SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA, ENHANCEMENT_ERRATA, OUTDATED_PACKAGES, SERVER_NAME,
SERVER_ADMINS, GROUP_COUNT, NOTE_COUNT, MODIFIED, CHANNEL_LABELS, HISTORY_COUNT,
LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE, SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED,
- config_files_with_differences,
- ( SELECT CASE MAX(CASE PS.state
+ config_files_with_differences, MONITORING_STATUS.ST AS MONITORING_STATUS
+ FROM rhnServerOverview OV LEFT OUTER JOIN
+ ( SELECT CP.host_id, CASE MAX(CASE PS.state
WHEN 'OK' THEN 1
WHEN 'PENDING' THEN 2
WHEN 'UNKNOWN' THEN 3
@@ -1207,19 +1208,19 @@ select distinct sgm.server_id as ID, 1 as virtual_host
FROM rhn_probe_state PS, rhnServerOverview OV
LEFT OUTER JOIN rhn_check_probe CP ON OV.server_id = CP.host_id
WHERE PS.probe_id = CP.probe_id
- GROUP BY OV.server_id ) MONITORING_STATUS
- FROM rhnServerOverview OV
+ GROUP BY CP.host_id ) MONITORING_STATUS ON OV.server_id = MONITORING_STATUS.host_id
WHERE server_id IN (%s)
ORDER BY SECURITY_ERRATA DESC, BUG_ERRATA DESC, ENHANCEMENT_ERRATA DESC
</query>
<query name="virtual_system_overview" params="">
- SELECT VI.id,
+ SELECT VI.id,
SERVER_ID as system_id, SECURITY_ERRATA, BUG_ERRATA, ENHANCEMENT_ERRATA, OUTDATED_PACKAGES, SERVER_NAME,
SERVER_ADMINS, GROUP_COUNT, NOTE_COUNT, OV.MODIFIED, CHANNEL_LABELS, CHANNEL_ID, HISTORY_COUNT,
LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE, SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED,
- config_files_with_differences,
- ( SELECT CASE MAX(CASE PS.state
+ config_files_with_differences, MONITORING_STATUS.ST AS MONITORING_STATUS
+ FROM rhnVirtualInstance VI, rhnServerOverview OV LEFT OUTER JOIN
+ ( SELECT CP.host_id, CASE MAX(CASE PS.state
WHEN 'OK' THEN 1
WHEN 'PENDING' THEN 2
WHEN 'UNKNOWN' THEN 3
@@ -1233,8 +1234,7 @@ ORDER BY SECURITY_ERRATA DESC, BUG_ERRATA DESC, ENHANCEMENT_ERRATA DESC
FROM rhn_probe_state PS, rhnServerOverview OV
LEFT OUTER JOIN rhn_check_probe CP ON OV.server_id = CP.host_id
WHERE PS.probe_id = CP.probe_id
- GROUP BY OV.server_id ) MONITORING_STATUS
- FROM rhnServerOverview OV, rhnVirtualInstance VI
+ GROUP BY CP.host_id ) MONITORING_STATUS ON OV.server_id = MONITORING_STATUS.host_id
WHERE VI.id IN (%s)
AND ( ( VI.uuid IS NULL
AND OV.server_id = VI.host_system_id)
commit c281f5696043560230d937e6bec866c7f9c1b727
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 10:05:51 2010 +0100
Replacing DECODE with ANSI compatible CASE-WHEN
(cherry picked from commit baa480636bd9c63c5568fc464c1d23b6b55b9faa)
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 40ac62e..94f34e4 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
@@ -1151,15 +1151,24 @@ ORDER BY S.ID
SERVER_ADMINS, GROUP_COUNT, NOTE_COUNT, MODIFIED, CHANNEL_LABELS, CHANNEL_ID, HISTORY_COUNT,
LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE, SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED,
config_files_with_differences,
- ( SELECT CASE
- MAX(CASE PS.state WHEN 'OK' THEN 1 WHEN 'PENDING' THEN 2 WHEN 'UNKNOWN' THEN 3 WHEN 'WARNING' THEN 4 WHEN 'CRITICAL' THEN 5 END)
- WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
- FROM rhn_probe_state PS, rhnServerOverview OV
- LEFT OUTER JOIN rhn_check_probe CP ON OV.server_id = CP.host_id
- WHERE PS.probe_id = CP.probe_id
- GROUP BY OV.server_id ) MONITORING_STATUS
- FROM rhnServerOverview OV
- WHERE server_id IN (%s)
+ MONITORING_STATUS.ST AS MONITORING_STATUS
+ FROM rhnServerOverview OV LEFT OUTER JOIN
+ ( SELECT CP.host_id, CASE MAX(CASE PS.state
+ WHEN 'OK' THEN 1
+ WHEN 'PENDING' THEN 2
+ WHEN 'UNKNOWN' THEN 3
+ WHEN 'WARNING' THEN 4
+ WHEN 'CRITICAL' THEN 5 END)
+ WHEN 1 THEN 'OK'
+ WHEN 2 THEN 'PENDING'
+ WHEN 3 THEN 'UNKNOWN'
+ WHEN 4 THEN 'WARNING'
+ WHEN 5 THEN 'CRITICAL' END ST
+ FROM rhn_check_probe CP, rhn_probe_state PS
+ WHERE PS.probe_id = CP.probe_id
+ GROUP BY CP.host_id ) MONITORING_STATUS
+ ON OV.server_id = MONITORING_STATUS.host_id
+ WHERE server_id IN (%s)
ORDER BY UPPER(NVL(SERVER_NAME, '(none)')), SERVER_ID
</query>
commit 3c38e5becfd9c921ee0c896a6b299a005732a56c
Author: Lukas Zapletal <lzap+git(a)redhat.com>
Date: Thu Nov 25 10:04:58 2010 +0100
Adding missing monitoring state (UNKNOWN)
(cherry picked from commit 5e52731a3ea813ea17a3dba463a49a766772f262)
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 52ea2aa..40ac62e 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
@@ -1292,7 +1292,7 @@ ORDER BY NAME, VI.virtual_system_id, VI.uuid DESC
<query name="monitoring_status" params="sid">
SELECT CASE
MAX(CASE PS.state WHEN 'OK' THEN 1 WHEN 'PENDING' THEN 2 WHEN 'UNKNOWN' THEN 3 WHEN 'WARNING' THEN 4 WHEN 'CRITICAL' THEN 5 END)
- WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
+ WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 3 THEN 'UNKNOWN' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
FROM rhn_check_probe CP, rhn_probe_state PS
WHERE PS.probe_id = CP.probe_id
AND CP.host_id = :sid
diff --git a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
index 4232776..d330308 100644
--- a/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
+++ b/web/modules/rhn/RHN/DB/DataSource/xml/System_queries.xml
@@ -1032,8 +1032,8 @@ ORDER BY UPPER(NVL(S.name, '(none)')), S.id
LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE, SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED,
( SELECT CASE
MAX(CASE PS.state WHEN 'OK' THEN 1 WHEN 'PENDING' THEN 2 WHEN 'UNKNOWN' THEN 3 WHEN 'WARNING' THEN 4 WHEN 'CRITICAL' THEN 5 END)
- WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
- FROM rhn_probe_state PS, rhnServerOverview OV
+ WHEN 1 THEN 'OK' WHEN 2 THEN 'PENDING' WHEN 3 THEN 'UNKNOWN' WHEN 4 THEN 'WARNING' WHEN 5 THEN 'CRITICAL' END ST
+ FROM rhn_probe_state PS
LEFT OUTER JOIN rhn_check_probe CP ON OV.server_id = CP.host_id
WHERE PS.probe_id = CP.probe_id
GROUP BY OV.server_id ) MONITORING_STATUS,
13 years, 5 months
Changes to 'refs/tags/spacewalk-reports-1.3.1-1'
by Michael Mraka
Tag 'spacewalk-reports-1.3.1-1' created by Michael Mraka <michael.mraka(a)redhat.com> at 2010-11-25 08:26 +0000
Tagging package [spacewalk-reports] version [1.3.1-1] in directory [reporting/].
Changes since spacewalk-java-1.3.15-1:
Michael Mraka (3):
added --skip-channels to spacewalk-remove-channel
fixed namespace of imported modules
Automatic commit of package [spacewalk-reports] release [1.3.1-1].
---
backend/satellite_tools/spacewalk-remove-channel | 19 +++++++++++++------
rel-eng/packages/spacewalk-reports | 2 +-
reporting/spacewalk-report | 9 ++-------
reporting/spacewalk-reports.spec | 5 ++++-
4 files changed, 20 insertions(+), 15 deletions(-)
---
13 years, 5 months