backend/spacewalk-backend.spec rel-eng/packages
by Milan Zazrivec
backend/spacewalk-backend.spec | 23 ++++++++++++++++++++++-
rel-eng/packages/spacewalk-backend | 2 +-
2 files changed, 23 insertions(+), 2 deletions(-)
New commits:
commit d060681ccf4bc815a09e45dec5060db6b8feb5e1
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu Oct 1 17:31:24 2009 +0200
Automatic commit of package [spacewalk-backend] release [0.7.5-1].
diff --git a/backend/spacewalk-backend.spec b/backend/spacewalk-backend.spec
index 2495958..11d28df 100644
--- a/backend/spacewalk-backend.spec
+++ b/backend/spacewalk-backend.spec
@@ -7,7 +7,7 @@ Name: spacewalk-backend
Summary: Common programs needed to be installed on the Spacewalk servers/proxies
Group: Applications/Internet
License: GPLv2
-Version: 0.7.4
+Version: 0.7.5
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -581,6 +581,27 @@ rm -f %{rhnconf}/rhnSecret.py*
# $Id$
%changelog
+* Thu Oct 01 2009 Milan Zazrivec <mzazrivec(a)redhat.com> 0.7.5-1
+- rhn-db-stats: split database & schema statistics (mzazrivec(a)redhat.com)
+- fixes for 524231, 523393, 523760, 523384 (jpazdziora(a)redhat.com)
+- catch all exceptions, so that we commit in all cases. (jpazdziora(a)redhat.com)
+- If we fail, let us commit the previous updates (done in this transaction).
+ (jpazdziora(a)redhat.com)
+- Do the rhn_rpm.get_package_header before we do the actual move.
+ (jpazdziora(a)redhat.com)
+- No commit in processPackageKeyAssociations. (jpazdziora(a)redhat.com)
+- clean up (pkilambi(a)redhat.com)
+- if nevra enabled use md5sum as a unique constraint for package pushes
+ (pkilambi(a)redhat.com)
+- Move the debug message up; if the OS operation fail, we will know what we
+ were trying to do. (jpazdziora(a)redhat.com)
+- Add more actual values to log messages, to make debugging easier.
+ (jpazdziora(a)redhat.com)
+- No need to sleep if we want the /var/satellite migration to be faster.
+ (jpazdziora(a)redhat.com)
+- Update using id, as there is no index on rhnPackage.path which could be used.
+ (jpazdziora(a)redhat.com)
+
* Fri Sep 04 2009 Michael Mraka <michael.mraka(a)redhat.com> 0.7.4-1
- fixed output of multivalue variables in spacewalk-cfg-get
diff --git a/rel-eng/packages/spacewalk-backend b/rel-eng/packages/spacewalk-backend
index 44d22f3..b45f4bd 100644
--- a/rel-eng/packages/spacewalk-backend
+++ b/rel-eng/packages/spacewalk-backend
@@ -1 +1 @@
-0.7.4-1 backend/
+0.7.5-1 backend/
14 years, 7 months
Changes to 'refs/tags/spacewalk-setup-0.7.5-1'
by Milan Zazrivec
Tag 'spacewalk-setup-0.7.5-1' created by Milan Zazrivec <mzazrivec(a)redhat.com> at 2009-10-01 15:23 +0000
Tagging package [spacewalk-setup] version [0.7.5-1] in directory [spacewalk/setup/].
Changes since yum-rhn-plugin-0.7.6-1:
Milan Zazrivec (2):
rhn-db-stats: split database & schema statistics
Automatic commit of package [spacewalk-setup] release [0.7.5-1].
---
backend/satellite_tools/Makefile | 2
backend/satellite_tools/rhn-db-stats | 59 ++++-------------
backend/satellite_tools/rhn-db-stats.sgml | 18 ++++-
backend/satellite_tools/rhn-schema-stats | 53 +++++++++++++++
backend/satellite_tools/rhn-schema-stats.sgml | 89 ++++++++++++++++++++++++++
backend/satellite_tools/spacewalk-debug | 3
backend/spacewalk-backend.spec | 2
rel-eng/packages/spacewalk-setup | 2
spacewalk/setup/spacewalk-setup.spec | 8 ++
9 files changed, 186 insertions(+), 50 deletions(-)
---
14 years, 7 months
rel-eng/packages spacewalk/setup
by Milan Zazrivec
rel-eng/packages/spacewalk-setup | 2 +-
spacewalk/setup/spacewalk-setup.spec | 8 +++++++-
2 files changed, 8 insertions(+), 2 deletions(-)
New commits:
commit 0603c79a26be3c66867147e13f59252396680296
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu Oct 1 17:23:37 2009 +0200
Automatic commit of package [spacewalk-setup] release [0.7.5-1].
diff --git a/rel-eng/packages/spacewalk-setup b/rel-eng/packages/spacewalk-setup
index 5e84c01..c588ecc 100644
--- a/rel-eng/packages/spacewalk-setup
+++ b/rel-eng/packages/spacewalk-setup
@@ -1 +1 @@
-0.7.4-1 spacewalk/setup/
+0.7.5-1 spacewalk/setup/
diff --git a/spacewalk/setup/spacewalk-setup.spec b/spacewalk/setup/spacewalk-setup.spec
index 596b834..32c64f5 100644
--- a/spacewalk/setup/spacewalk-setup.spec
+++ b/spacewalk/setup/spacewalk-setup.spec
@@ -1,5 +1,5 @@
Name: spacewalk-setup
-Version: 0.7.4
+Version: 0.7.5
Release: 1%{?dist}
Summary: Initial setup tools for Red Hat Spacewalk
@@ -106,6 +106,12 @@ rm -rf %{buildroot}
%dir %{_sysconfdir}/pki/spacewalk/jabberd
%changelog
+* Thu Oct 01 2009 Milan Zazrivec <mzazrivec(a)redhat.com> 0.7.5-1
+- 476851 - removal of tables: rhn_db_environment, rhn_environment (msuchy(a)redhat.com)
+- fixed check_users_exist, check_groups_exist - only first user/group was
+ checked (michael.mraka(a)redhat.com)
+- spacewalk-setup-jabberd man page fixes (mzazrivec(a)redhat.com)
+
* Wed Sep 02 2009 Michael Mraka <michael.mraka(a)redhat.com> 0.7.4-1
- db-backend is set in idefaults
- 520441 - don't apply ExtUtils::MY->fixin(shift) to perl executables
14 years, 7 months
backend/satellite_tools backend/spacewalk-backend.spec
by Milan Zazrivec
backend/satellite_tools/Makefile | 2
backend/satellite_tools/rhn-db-stats | 59 ++++-------------
backend/satellite_tools/rhn-db-stats.sgml | 18 ++++-
backend/satellite_tools/rhn-schema-stats | 53 +++++++++++++++
backend/satellite_tools/rhn-schema-stats.sgml | 89 ++++++++++++++++++++++++++
backend/satellite_tools/spacewalk-debug | 3
backend/spacewalk-backend.spec | 2
7 files changed, 178 insertions(+), 48 deletions(-)
New commits:
commit 9ae6aaaf641f0dcd2b8b6a5a6d42082d7d982742
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu Oct 1 13:28:28 2009 +0200
rhn-db-stats: split database & schema statistics
New divison:
- rhn-db-stats: for database statistics
- rhh-schema-stats: for schema statistics
diff --git a/backend/satellite_tools/Makefile b/backend/satellite_tools/Makefile
index e14fdaa..fb22c4b 100644
--- a/backend/satellite_tools/Makefile
+++ b/backend/satellite_tools/Makefile
@@ -16,7 +16,7 @@ FILES = __init__ connection diskImportLib messages \
SCRIPTS = satellite-sync spacewalk-debug\
rhn-schema-version rhn-satellite-activate rhn-charsets \
- rhn-ssl-dbstore update-packages rhn-db-stats \
+ rhn-ssl-dbstore update-packages rhn-db-stats rhn-schema-stats \
spacewalk-repo-sync spacewalk-report
SPACEWALK_SUBDIRS = reports reports/data
diff --git a/backend/satellite_tools/rhn-db-stats b/backend/satellite_tools/rhn-db-stats
index a90073b..0895cdd 100755
--- a/backend/satellite_tools/rhn-db-stats
+++ b/backend/satellite_tools/rhn-db-stats
@@ -1,54 +1,27 @@
#!/bin/sh
-if [ $# -lt 1 -o $# -gt 2 ]; then
- echo "Usage: `basename $0` output-file [connect-string]"
+if [[ $@ =~ "--help|-h" ]] || [ $# -lt 1 -o $# -gt 2 ]; then
+ echo "Usage: `basename $0` -h | --help | output-file [connect-string]"
exit
fi
-CONNECT=$(spacewalk-cfg-get default_db)
-[ -n "$2" ] && CONNECT=$2
+connect=$(spacewalk-cfg-get default_db)
+[ -n "$2" ] && connect=$2
-# sqlplus ... | cat > ... is here to fool selinux, since oracle_sqlplus_t
-# cannot write just anywhere
-sqlplus $CONNECT << EOS | cat > $1
-set echo on
+sql="
set serverout on
set pagesize 2000 linesize 145
-column name_col_plus_show_param format a40 word wrap
-column value_col_plus_show_param format a90 word wrap
+column name_col_plus_show_param format a40 word wrap heading PARAMETER
+column value_col_plus_show_param format a90 word wrap heading VALUE
select dbms_stats.get_param('METHOD_OPT') from dual;
-
show parameter;
-
-declare
- n number;
-begin
- for i in (select * from user_tables order by table_name)
- loop
- execute immediate 'select count(*) from ' || i.table_name into n;
- dbms_output.put_line(i.table_name || ': ' || n);
- end loop;
-end;
-/
-
-column label format a30
-column name format a25
-column epoch format a10
-column version format a10
-column release format a10
-
-select
- rvi.label, to_char(rvi.created, 'YYYY-MM-DD') created, to_char(rvi.modified, 'YYYY-MM-DD') modified,
- rpn.name,
- rpe.epoch, rpe.version, rpe.release
-from
- rhnVersionInfo rvi,
- rhnPackageName rpn,
- rhnPackageEvr rpe
-where
- rvi.evr_id = rpe.id and
- rvi.name_id = rpn.id;
-
-quit;
-EOS
+"
+
+if [ "$1" == "-" ]; then
+ echo "$sql" | sqlplus -S $connect
+else
+ # sqlplus ... | cat ... is here to fool selinux, since oracle_sqlplus_t
+ # cannot write just anywhere (via spool ...)
+ echo "$sql" | sqlplus -S $connect | cat > $1
+fi
diff --git a/backend/satellite_tools/rhn-db-stats.sgml b/backend/satellite_tools/rhn-db-stats.sgml
index ac07a3d..3ff342c 100644
--- a/backend/satellite_tools/rhn-db-stats.sgml
+++ b/backend/satellite_tools/rhn-db-stats.sgml
@@ -22,8 +22,9 @@ utility for querying important database parameters used by
<Synopsis>
<cmdsynopsis>
<command>&THECOMMAND;</command>
- <arg choice="req">output-file</arg>
- <arg>db-conect-string</arg>
+ <arg choice="opt">-h | --help</arg>
+ <arg choice="req">output-file</arg>
+ <arg choice="opt">db-conect-string</arg>
</cmdsynopsis>
</Synopsis>
</RefSynopsisDiv>
@@ -31,7 +32,7 @@ utility for querying important database parameters used by
<RefSect1><Title>Description</Title>
<para>
-rhn-db-stats retrieves important statistics and parameters from Oracle database
+rhn-db-stats retrieves important parameters from Oracle database
used by your Satellite / Spacewalk installation. It is used by spacewalk-debug
(satellite-debug) or it can be used standalone.
</para>
@@ -41,9 +42,17 @@ used by your Satellite / Spacewalk installation. It is used by spacewalk-debug
<RefSect1><Title>Options</Title>
<variablelist>
<varlistentry>
+ <term>-h | --help</term>
+ <listitem>
+ <para>Print usage information.</para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term>output-file</term>
<listitem>
- <para>File name to save the retrieved information to.</para>
+ <para>File name to save the retrieved information to. Use - if you wish to
+ print the output to stdout.</para>
</listitem>
</varlistentry>
<varlistentry>
@@ -70,6 +79,7 @@ used by your Satellite / Spacewalk installation. It is used by spacewalk-debug
<RefSect1><Title>See Also</Title>
<simplelist>
<member>spacewalk-debug(8)</member>
+ <member>rhn-schema-stats(8)</member>
</simplelist>
</RefSect1>
diff --git a/backend/satellite_tools/rhn-schema-stats b/backend/satellite_tools/rhn-schema-stats
new file mode 100755
index 0000000..03c5de9
--- /dev/null
+++ b/backend/satellite_tools/rhn-schema-stats
@@ -0,0 +1,53 @@
+#!/bin/bash
+
+if [[ $@ =~ "--help|-h" ]] || [ $# -lt 1 -o $# -gt 2 ]; then
+ echo "Usage: `basename $0` -h | --help | output-file [connect-string]"
+ exit
+fi
+
+connect=$(spacewalk-cfg-get default_db)
+[ -n "$2" ] && connect=$2
+
+sql="
+set pagesize 2000 linesize 140
+set serverout on
+
+declare
+ n number;
+begin
+ for i in (select * from user_tables order by table_name)
+ loop
+ execute immediate 'select count(*) from ' || i.table_name into n;
+ dbms_output.put_line(i.table_name || ': ' || n);
+ end loop;
+end;
+/
+
+column label format a30
+column name format a25
+column epoch format a10
+column version format a10
+column release format a10
+
+select
+ rvi.label, to_char(rvi.created, 'YYYY-MM-DD') created, to_char(rvi.modified, 'YYYY-MM-DD') modified,
+ rpn.name,
+ rpe.epoch, rpe.version, rpe.release
+from
+ rhnVersionInfo rvi,
+ rhnPackageName rpn,
+ rhnPackageEvr rpe
+where
+ rvi.evr_id = rpe.id and
+ rvi.name_id = rpn.id;
+
+quit;
+"
+
+if [ "$1" == "-" ]; then
+ echo "$sql" | sqlplus -S $connect
+else
+ # sqlplus ... | cat ... is here to fool selinux, since oracle_sqlplus_t
+ # cannot write just anywhere (via spool ...)
+ echo "$sql" | sqlplus -S $connect | cat > $1
+fi
diff --git a/backend/satellite_tools/rhn-schema-stats.sgml b/backend/satellite_tools/rhn-schema-stats.sgml
new file mode 100644
index 0000000..e3f7ba2
--- /dev/null
+++ b/backend/satellite_tools/rhn-schema-stats.sgml
@@ -0,0 +1,89 @@
+<!DOCTYPE refentry PUBLIC "-//OASIS//DTD DocBook V3.1//EN" [
+<!ENTITY RHNSAT "RHN Satellite Server" >
+<!ENTITY THECOMMAND "rhn-schema-stats" >
+
+]>
+<refentry>
+
+<RefMeta>
+<RefEntryTitle>&THECOMMAND;</RefEntryTitle><manvolnum>8</manvolnum>
+<RefMiscInfo>Version 1.0.0</RefMiscInfo>
+</RefMeta>
+
+<RefNameDiv>
+<RefName><command>&THECOMMAND;</command></RefName>
+<RefPurpose>
+utility for querying important Spacewalk / Satellite database schema statistics.
+</RefPurpose>
+</RefNameDiv>
+
+<RefSynopsisDiv>
+<Synopsis>
+ <cmdsynopsis>
+ <command>&THECOMMAND;</command>
+ <arg choice="opt">-h | --help</arg>
+ <arg choice="req">output-file</arg>
+ <arg choice="opt">db-conect-string</arg>
+ </cmdsynopsis>
+</Synopsis>
+</RefSynopsisDiv>
+
+<RefSect1><Title>Description</Title>
+
+<para>
+rhn-schema-stats retrieves important statistics from your Satellite / Spacewalk database
+schema. Ordinarily, is used by spacewalk-debug (satellite-debug), but it can be used standalone.
+</para>
+
+</RefSect1>
+
+<RefSect1><Title>Options</Title>
+<variablelist>
+ <varlistentry>
+ <term>-h | --help</term>
+ <listitem>
+ <para>Print usage information.</para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term>output-file</term>
+ <listitem>
+ <para>File name to save the retrieved information to. Use - if you wish to
+ print the output to stdout.</para>
+ </listitem>
+ </varlistentry>
+ <varlistentry>
+ <term>db-connect-string</term>
+ <listitem>
+ <para>Connection string to your Oracle database.</para>
+ </listitem>
+ </varlistentry>
+</variablelist>
+</RefSect1>
+
+<RefSect1><Title>Files</Title>
+<simplelist>
+ <member>/usr/bin/&THECOMMAND;</member>
+</simplelist>
+</RefSect1>
+
+<RefSect1><Title>Example</Title>
+<simplelist>
+ <member><command>&THECOMMAND; database.log</command></member>
+</simplelist>
+</RefSect1>
+
+<RefSect1><Title>See Also</Title>
+<simplelist>
+ <member>spacewalk-debug(8)</member>
+ <member>rhn-db-stats(8)</member>
+</simplelist>
+</RefSect1>
+
+<RefSect1><Title>Authors</Title>
+<simplelist>
+ <member>Milan Zazrivec <email>mzazrivec(a)redhat.com</email></member>
+</simplelist>
+</RefSect1>
+</RefEntry>
diff --git a/backend/satellite_tools/spacewalk-debug b/backend/satellite_tools/spacewalk-debug
index 8372440..879ff7f 100755
--- a/backend/satellite_tools/spacewalk-debug
+++ b/backend/satellite_tools/spacewalk-debug
@@ -205,6 +205,9 @@ df -h > $DIR/diskinfo
echo " * get database statistics"
/usr/bin/rhn-db-stats $DIR/database/db-stats.log
+echo " * get schema statistics"
+/usr/bin/rhn-schema-stats $DIR/database/schema-stats.log
+
# alert.log
if [ -f /rhnsat/admin/rhnsat/bdump/alert_rhnsat.log ] ; then
echo " * copying alert_rhnsat.log"
diff --git a/backend/spacewalk-backend.spec b/backend/spacewalk-backend.spec
index 59f83a0..2495958 100644
--- a/backend/spacewalk-backend.spec
+++ b/backend/spacewalk-backend.spec
@@ -511,6 +511,7 @@ rm -f %{rhnconf}/rhnSecret.py*
%attr(755,root,root) %{_bindir}/update-packages
%attr(755,root,root) %{_bindir}/spacewalk-repo-sync
%attr(755,root,root) %{_bindir}/rhn-db-stats
+%attr(755,root,root) %{_bindir}/rhn-schema-stats
%attr(750,root,root) %{_bindir}/satpasswd
%attr(750,root,root) %{_bindir}/satwho
%{rhnroot}/satellite_tools/SequenceServer.py*
@@ -551,6 +552,7 @@ rm -f %{rhnconf}/rhnSecret.py*
%{_mandir}/man8/rhn-schema-version.8*
%{_mandir}/man8/rhn-ssl-dbstore.8*
%{_mandir}/man8/rhn-db-stats.8*
+%{_mandir}/man8/rhn-schema-stats.8*
%{_mandir}/man8/satellite-sync.8*
%{_mandir}/man8/spacewalk-debug.8*
%{_mandir}/man8/spacewalk-report.8*
14 years, 7 months
Changes to 'refs/tags/yum-rhn-plugin-0.7.6-1'
by Miroslav Suchý
Tag 'yum-rhn-plugin-0.7.6-1' created by Miroslav Suchý <msuchy(a)redhat.com> at 2009-10-01 07:06 +0000
Tagging package [yum-rhn-plugin] version [0.7.6-1] in directory [client/rhel/yum-rhn-plugin/].
Changes since yum-rhn-plugin-0.7.5-1:
Jan Pazdziora (3):
Do the rhn_rpm.get_package_header before we do the actual move.
If we fail, let us commit the previous updates (done in this transaction).
Catch all exceptions, so that we commit in all cases.
Justin Sherrill (1):
workaround for hibernate not handling in caluses of more than 1000
Milan Zazrivec (1):
524231 - correctly expand file list for RPM v3 packages
Miroslav Suchý (3):
523673 - generate repomd for zstreams too
525453 - change license in header from GPL to correct GPLv2
Automatic commit of package [yum-rhn-plugin] release [0.7.6-1].
---
backend/satellite_tools/updatePackages.py | 11 +--
backend/server/importlib/headerSource.py | 3
client/rhel/yum-rhn-plugin/actions/packages.py | 2
client/rhel/yum-rhn-plugin/yum-rhn-plugin.spec | 5 +
java/code/src/com/redhat/rhn/domain/channel/Channel.java | 11 +++
java/code/src/com/redhat/rhn/domain/server/ServerFactory.java | 31 +++++++---
rel-eng/packages/yum-rhn-plugin | 2
7 files changed, 47 insertions(+), 18 deletions(-)
---
14 years, 7 months
2 commits - client/rhel rel-eng/packages
by Miroslav Suchý
client/rhel/yum-rhn-plugin/actions/packages.py | 2 +-
client/rhel/yum-rhn-plugin/yum-rhn-plugin.spec | 5 ++++-
rel-eng/packages/yum-rhn-plugin | 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
New commits:
commit 69c7fbeb4edda1d038ccce2f7d7d3989610e070f
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Thu Oct 1 09:06:31 2009 +0200
Automatic commit of package [yum-rhn-plugin] release [0.7.6-1].
diff --git a/client/rhel/yum-rhn-plugin/yum-rhn-plugin.spec b/client/rhel/yum-rhn-plugin/yum-rhn-plugin.spec
index 95b6619..342f849 100644
--- a/client/rhel/yum-rhn-plugin/yum-rhn-plugin.spec
+++ b/client/rhel/yum-rhn-plugin/yum-rhn-plugin.spec
@@ -1,6 +1,6 @@
Summary: RHN support for yum
Name: yum-rhn-plugin
-Version: 0.7.5
+Version: 0.7.6
Release: 1%{?dist}
License: GPLv2
Group: System Environment/Base
@@ -50,6 +50,9 @@ rm -rf $RPM_BUILD_ROOT
%doc LICENSE
%changelog
+* Thu Oct 1 2009 Miroslav Suchý <msuchy(a)redhat.com> 0.7.6-1
+- change licence in header to correct GPLv2
+
* Wed Sep 30 2009 Miroslav Suchý <msuchy(a)redhat.com> 0.7.5-1
- add LICENSE
diff --git a/rel-eng/packages/yum-rhn-plugin b/rel-eng/packages/yum-rhn-plugin
index bf19612..f78d976 100644
--- a/rel-eng/packages/yum-rhn-plugin
+++ b/rel-eng/packages/yum-rhn-plugin
@@ -1 +1 @@
-0.7.5-1 client/rhel/yum-rhn-plugin/
+0.7.6-1 client/rhel/yum-rhn-plugin/
commit 5a7f3a2ba16a80d142039f491c7a5f6f75c7b9eb
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Thu Oct 1 09:05:31 2009 +0200
525453 - change license in header from GPL to correct GPLv2
diff --git a/client/rhel/yum-rhn-plugin/actions/packages.py b/client/rhel/yum-rhn-plugin/actions/packages.py
index a3792ef..fdaefd9 100644
--- a/client/rhel/yum-rhn-plugin/actions/packages.py
+++ b/client/rhel/yum-rhn-plugin/actions/packages.py
@@ -1,4 +1,4 @@
-# Copyright (c) 1999-2002 Red Hat, Inc. Distributed under GPL.
+# Copyright (c) 1999-2002 Red Hat, Inc. Distributed under GPLv2
#
# Author: James Bowes <jbowes(a)redhat.com>
#
14 years, 7 months