Changes to 'refs/tags/spacewalk-schema-1.9.16-1'
by Jan Pazdziora
Tag 'spacewalk-schema-1.9.16-1' created by Jan Pazdziora <jpazdziora(a)redhat.com> at 2013-01-22 18:19 +0000
Tagging package [spacewalk-schema] version [1.9.16-1] in directory [schema/spacewalk/].
Changes since spacewalk-schema-1.9.15-1:
Jan Pazdziora (3):
We need to recreate the view from scratch.
We need to drop rhn_download_id_seq as well.
Automatic commit of package [spacewalk-schema] release [1.9.16-1].
---
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 6 +++++-
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql | 1 +
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql | 1 +
4 files changed, 8 insertions(+), 2 deletions(-)
---
11 years, 3 months
rel-eng/packages schema/spacewalk
by Jan Pazdziora
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 6 +++++-
2 files changed, 6 insertions(+), 2 deletions(-)
New commits:
commit 9f7ee33c769c93170b8ff861bf83d392447c887b
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Jan 22 19:19:17 2013 +0100
Automatic commit of package [spacewalk-schema] release [1.9.16-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index abffddc..4a68194 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.9.15-1 schema/spacewalk/
+1.9.16-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index 0480c9d..f211c70 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.9.15
+Version: 1.9.16
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -68,6 +68,10 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Tue Jan 22 2013 Jan Pazdziora 1.9.16-1
+- We need to drop rhn_download_id_seq as well.
+- We need to recreate the view from scratch.
+
* Tue Jan 22 2013 Jan Pazdziora 1.9.15-1
- Adding dependency for rhnContentSourceSsl.
11 years, 3 months
2 commits - schema/spacewalk
by Jan Pazdziora
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql | 1 +
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql | 1 +
2 files changed, 2 insertions(+)
New commits:
commit 6114a074ed003ea4c8da19e055578f72469c83ec
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Jan 22 19:18:53 2013 +0100
We need to drop rhn_download_id_seq as well.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql
index 7b30871..298e2e5 100644
--- a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql
@@ -2,4 +2,5 @@
drop table rhnChannelDownloads;
drop table rhnDownloads;
drop table rhnDownloadType;
+drop sequence rhn_download_id_seq;
commit 68d4f302ac7221008925e7458d1d040b61c9b11e
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Jan 22 19:16:34 2013 +0100
We need to recreate the view from scratch.
Addressing
psql:/var/log/spacewalk/schema-upgrade/20130122-125951-script.sql:5630: ERROR: cannot change name of view column "last_checkin_days_ago" to "crash_count"
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql
index c6fdf75..1321fb6 100644
--- a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql
@@ -1,3 +1,4 @@
+drop view rhnServerOverview;
create or replace view
rhnServerOverview
(
11 years, 3 months
Changes to 'refs/tags/spacewalk-schema-1.9.15-1'
by Jan Pazdziora
Tag 'spacewalk-schema-1.9.15-1' created by Jan Pazdziora <jpazdziora(a)redhat.com> at 2013-01-22 15:34 +0000
Tagging package [spacewalk-schema] version [1.9.15-1] in directory [schema/spacewalk/].
Changes since spacewalk-reports-1.9.2-1:
Jan Pazdziora (2):
Adding dependency for rhnContentSourceSsl.
Automatic commit of package [spacewalk-schema] release [1.9.15-1].
---
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/common/tables/tables.deps | 1 +
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
3 files changed, 6 insertions(+), 2 deletions(-)
---
11 years, 3 months
2 commits - rel-eng/packages schema/spacewalk
by Jan Pazdziora
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/common/tables/tables.deps | 1 +
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
3 files changed, 6 insertions(+), 2 deletions(-)
New commits:
commit 3dcae43d06c7909fc09ca0700c17afd55c01c6f1
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Jan 22 16:34:18 2013 +0100
Automatic commit of package [spacewalk-schema] release [1.9.15-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 4ed1ccd..abffddc 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.9.14-1 schema/spacewalk/
+1.9.15-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index 969cea0..0480c9d 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.9.14
+Version: 1.9.15
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -68,6 +68,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Tue Jan 22 2013 Jan Pazdziora 1.9.15-1
+- Adding dependency for rhnContentSourceSsl.
+
* Tue Jan 22 2013 Jan Pazdziora 1.9.14-1
- When adding a column to view, we better name it as well.
commit 8f477830dc890e61c689ba57a54d77ede9300bae
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Jan 22 16:32:58 2013 +0100
Adding dependency for rhnContentSourceSsl.
Addressing
psql:/etc/sysconfig/rhn/postgres/deploy.sql:3443: ERROR: relation "rhncryptokey" does not exist
diff --git a/schema/spacewalk/common/tables/tables.deps b/schema/spacewalk/common/tables/tables.deps
index 244a25e..e3fc61b 100644
--- a/schema/spacewalk/common/tables/tables.deps
+++ b/schema/spacewalk/common/tables/tables.deps
@@ -54,6 +54,7 @@ rhnChannelPackageArchCompat :: rhnPackageArch rhnChannelArch
rhnChannelPermission :: rhnChannelPermissionRole rhnChannel web_contact
rhnChannelTrust :: rhnChannel
rhnChannelContentSource :: rhnChannel rhnContentSourceType rhnContentSource
+rhnContentSourceSsl :: rhnContentSource rhnCryptoKey
rhnChecksum :: rhnChecksumType
rhnClientCapability :: rhnClientCapabilityName
rhnConfigContent :: rhnChecksum
11 years, 3 months
Changes to 'refs/tags/spacewalk-reports-1.9.2-1'
by Tomáš Kašpárek
Tag 'spacewalk-reports-1.9.2-1' created by Tomas Kasparek <tkasparek(a)redhat.com> at 2013-01-22 13:40 +0000
Tagging package [spacewalk-reports] version [1.9.2-1] in directory [reporting/].
Changes since spacewalk-schema-1.9.14-1:
Tomas Kasparek (2):
768074 - report of package upgrades available for systems
Automatic commit of package [spacewalk-reports] release [1.9.2-1].
---
rel-eng/packages/spacewalk-reports | 2
reporting/reports/data/packages-updates-all | 54 ++++++++++++++++++++++
reporting/reports/data/packages-updates-newest | 61 +++++++++++++++++++++++++
reporting/spacewalk-reports.spec | 7 ++
4 files changed, 122 insertions(+), 2 deletions(-)
---
11 years, 3 months
rel-eng/packages reporting/spacewalk-reports.spec
by Tomáš Kašpárek
rel-eng/packages/spacewalk-reports | 2 +-
reporting/spacewalk-reports.spec | 7 ++++++-
2 files changed, 7 insertions(+), 2 deletions(-)
New commits:
commit fba7b6016c02901da9bec6a0a5448a1c1740d137
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Tue Jan 22 14:40:51 2013 +0100
Automatic commit of package [spacewalk-reports] release [1.9.2-1].
diff --git a/rel-eng/packages/spacewalk-reports b/rel-eng/packages/spacewalk-reports
index 39b96bc..0996154 100644
--- a/rel-eng/packages/spacewalk-reports
+++ b/rel-eng/packages/spacewalk-reports
@@ -1 +1 @@
-1.9.1-1 reporting/
+1.9.2-1 reporting/
diff --git a/reporting/spacewalk-reports.spec b/reporting/spacewalk-reports.spec
index 9d0bfa9..fabab25 100644
--- a/reporting/spacewalk-reports.spec
+++ b/reporting/spacewalk-reports.spec
@@ -2,7 +2,7 @@ Name: spacewalk-reports
Summary: Script based reporting
Group: Applications/Internet
License: GPLv2
-Version: 1.9.1
+Version: 1.9.2
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -43,6 +43,11 @@ rm -rf $RPM_BUILD_ROOT
%doc COPYING
%changelog
+* Tue Jan 22 2013 Tomas Kasparek <tkasparek(a)redhat.com> 1.9.2-1
+- 768074 - report of package upgrades available for systems
+ (tkasparek(a)redhat.com)
+- 745342 - system custom info report (tkasparek(a)redhat.com)
+
* Thu Jan 17 2013 Tomas Kasparek <tkasparek(a)redhat.com> 1.9.1-1
- parametrization of spacewalk-report with spacewalk config
- security fix + fixing typo
11 years, 3 months
reporting/reports
by Tomáš Kašpárek
reporting/reports/data/packages-updates-all | 54 ++++++++++++++++++++++
reporting/reports/data/packages-updates-newest | 61 +++++++++++++++++++++++++
2 files changed, 115 insertions(+)
New commits:
commit 0730c5a6711fa4fec175e4add8c5c3432078e2de
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Tue Jan 22 14:36:32 2013 +0100
768074 - report of package upgrades available for systems
packages-updates-all shows all upgrades available for packages
packages-updates-newest shows only newest versions of packages which can be upgraded
diff --git a/reporting/reports/data/packages-updates-all b/reporting/reports/data/packages-updates-all
new file mode 100644
index 0000000..e86d491
--- /dev/null
+++ b/reporting/reports/data/packages-updates-all
@@ -0,0 +1,54 @@
+
+synopsis:
+
+ List of packages which can be upgraded
+
+description:
+
+ Prints list of packages which can be upgraded for all systems in spacewalk
+
+columns:
+
+ system_id System id
+ org_id Id of organization system belongs to
+ package_name Name of the package
+ package_epoch Epoch of the package
+ package_version Version of the package
+ package_release Release of the package
+ package_arch Architecture of the package
+ newer_epoch Version of the newer package available
+ newer_version Release of the newer package available
+ newer_release Architecture of the newer package available
+
+sql:
+
+ select * from (
+ select RS.id as system_id,
+ RS.org_id as org_id,
+ RPN.name as package_name,
+ RPE.epoch as package_epoch,
+ RPE.version as package_version,
+ RPE.release as package_release,
+ RPA.label as package_arch,
+ RPE1.epoch as newer_epoch,
+ RPE1.version as newer_version,
+ RPE1.release as newer_release
+ from rhnServer RS
+ join rhnServerPackage RSP on RS.id=RSP.server_id
+ join rhnPackageName RPN on RSP.name_id=RPN.id
+ join rhnPackageEvr RPE on RSP.evr_id=RPE.id
+ join rhnPackageArch RPA on RSP.package_arch_id=RPA.id,
+ rhnServer RS1
+ join rhnServerChannel RSC on RS1.id=RSC.server_id
+ join rhnChannelPackage RCP on RSC.channel_id=RCP.channel_id
+ join rhnPackage RP on RCP.package_id=RP.id
+ join rhnPackageName RPN1 on RP.name_id=RPN1.id
+ join rhnPackageEvr RPE1 on RP.evr_id=RPE1.id
+ join rhnPackageArch RPA1 on RP.package_arch_id=RPA1.id
+ where RS.id=RS1.id
+ and RPN.name=RPN1.name
+ and RPE.evr < RPE1.evr
+ ) X
+ -- where placeholder
+ order by org_id, system_id
+
diff --git a/reporting/reports/data/packages-updates-newest b/reporting/reports/data/packages-updates-newest
new file mode 100644
index 0000000..92dc0d0
--- /dev/null
+++ b/reporting/reports/data/packages-updates-newest
@@ -0,0 +1,61 @@
+
+synopsis:
+
+ List of packages which can be upgraded
+
+description:
+
+ Prints list of packages which can be upgraded for all systems in spacewalk
+
+columns:
+
+ system_id System id
+ org_id Id of organization system belongs to
+ package_name Name of the package
+ package_epoch Epoch of the package
+ package_version Version of the package
+ package_release Release of the package
+ package_arch Architecture of the package
+ newest_epoch Version of the newest package available
+ newest_version Release of the newest package available
+ newest_release Architecture of the newest package available
+
+sql:
+
+ select * from (
+ select RS.id as system_id,
+ RS.org_id as org_id,
+ RPN.name as package_name,
+ RPE.epoch as package_epoch,
+ RPE.version as package_version,
+ RPE.release as package_release,
+ RPA.label as package_arch,
+ RPE1.epoch as newest_epoch,
+ RPE1.version as newest_version,
+ RPE1.release as newest_release
+ from rhnServer RS
+ join rhnServerPackage RSP on RS.id=RSP.server_id
+ join rhnPackageName RPN on RSP.name_id=RPN.id
+ join rhnPackageEvr RPE on RSP.evr_id=RPE.id
+ join rhnPackageArch RPA on RSP.package_arch_id=RPA.id,
+ rhnServer RS1
+ join rhnServerChannel RSC on RS1.id=RSC.server_id
+ join rhnChannelPackage RCP on RSC.channel_id=RCP.channel_id
+ join rhnPackage RP on RCP.package_id=RP.id
+ join rhnPackageName RPN1 on RP.name_id=RPN1.id
+ join rhnPackageEvr RPE1 on RP.evr_id=RPE1.id
+ join rhnPackageArch RPA1 on RP.package_arch_id=RPA1.id
+ where RS.id=RS1.id
+ and RPN.name=RPN1.name
+ and RPE.evr < RPE1.evr
+ and RPE1.evr = (
+ select max(RPE2.evr)
+ from rhnPackage RP1
+ join rhnPackageName RPN2 on RP1.name_id=RPN2.id
+ join rhnPackageEvr RPE2 on RP1.evr_id=RPE2.id
+ where RPN.name=RPN2.name
+ )
+ ) X
+ -- where placeholder
+ order by org_id, system_id
+
11 years, 3 months
Changes to 'refs/tags/spacewalk-schema-1.9.14-1'
by Jan Pazdziora
Tag 'spacewalk-schema-1.9.14-1' created by Jan Pazdziora <jpazdziora(a)redhat.com> at 2013-01-22 13:34 +0000
Tagging package [spacewalk-schema] version [1.9.14-1] in directory [schema/spacewalk/].
Changes since spacewalk-config-1.9.2-1:
Jan Pazdziora (1):
Automatic commit of package [spacewalk-schema] release [1.9.14-1].
---
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
2 files changed, 5 insertions(+), 2 deletions(-)
---
11 years, 3 months
Changes to 'refs/tags/spacewalk-config-1.9.2-1'
by Jan Pazdziora
Tag 'spacewalk-config-1.9.2-1' created by Jan Pazdziora <jpazdziora(a)redhat.com> at 2013-01-22 13:34 +0000
Tagging package [spacewalk-config] version [1.9.2-1] in directory [spacewalk/config/].
Changes since spacewalk-certs-tools-1.9.2-1:
Jan Pazdziora (3):
We no longer ship /var/www/html/applications.
When adding a column to view, we better name it as well.
Automatic commit of package [spacewalk-config] release [1.9.2-1].
---
rel-eng/packages/spacewalk-config | 2 +-
schema/spacewalk/common/views/rhnServerOverview.sql | 1 +
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql | 1 +
spacewalk/config/etc/httpd/conf.d/zz-spacewalk-www.conf | 6 ------
spacewalk/config/spacewalk-config.spec | 5 ++++-
5 files changed, 7 insertions(+), 8 deletions(-)
---
11 years, 3 months