[Spacewalk-devel] Registering New Client on SW1.2 postgres

2011-01-11 Thread Jonathan Hoser 

Hi all,

I've managed to get the kickstart-creation going on the SW1.2 postgres 
version,

(and if told how, will gladly supply you the information of the changes)
but now am facing some issue with the registration of the new 
kickstarted client:


On running the rhnreg_ks commandline I only get
'Internal Server Error'
with nothing being written to the logs, neither on the catalina logs nor 
anywhere else.


Where would I have to increase verbosity levels (by the way - I'm doing 
my debugging via recompiling the fat-jar and adding sysouts since I 
couldn't get the log4j to read/accept my settings)?

Is this part of the python backend?

Any help would be greatly appreciated,
best
-Jonathan

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Registering New Client on SW1.2 postgres

2011-01-11 Thread Jonathan Hoser 

On 01/11/2011 01:19 PM, Jan Pazdziora wrote:

On Tue, Jan 11, 2011 at 01:04:23PM +0100, Jonathan Hoser wrote:

Hi all,

I've managed to get the kickstart-creation going on the SW1.2
postgres version,
(and if told how, will gladly supply you the information of the changes)

Just send the patches to this mailing list.

Thanks!


OK, will do -- targeting next week.

Back to my problem:
It turns out that the second (the automatically generated key that does 
the channel-subscription) is the culprit and somehow doesn't get handled:

--activationkey=1-01bdb7dd9ebe[...],1-basicFedora14
does result in a 'Internal Server Error'
whereas
--activationkey=1-basicFedora14
results in
'This system is not subscribed to any channels. RHN channel support will 
be disabled'


Getting the system back into the channels again forced the debugging and 
changing of a bunch of SQL(or related) stuff.


Any idea on the automatically asigned channel-key thing?

best
-Jonathan


___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

[Spacewalk-devel] Fresh Spacewalk install issues

2011-06-28 Thread Jonathan Hoser 

Hi all,

I was just about to do a fresh spacewalk 1.4 on a virtualized centos
using a remote Postgres database,
when I hit an issue:

The populating of the database (spacewalk setup) failed, because the
language 'plpgsql' was not setup;
fun thing is, the Postgres installation I am using for this experiment
actually already is hosting my current live-spacewalk system,
only in a different database.

By adding the basic two lines (from the Postgres manual) to my
/etc/sysconfig/rhn/postgres/main.sql I actually got it working:

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS
'$libdir/plpgsql' LANGUAGE C;

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql
HANDLER plpgsql_call_handler;

I don't know why this issue surfaced when it did -
maybe this is something that only happens on remote-postgresql
installations, as I haven't noticed it before.

Just wanted to share it with you,
best
-Jonathan

--
Jonathan Hoser
Institute of Bioinformatics and System Biology



Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Bring out your patches

2011-07-20 Thread Jonathan Hoser 

Hi all,

dang, a bit too slow;

I have a small patch for util/spacewalk-common-channels.ini
basically adding centos6 and fedora15 repos;

Best
-Jonathan

On 07/18/2011 06:02 PM, Jan Pazdziora wrote:

Hello,

I plan to branch Spacewalk 1.5 later this week.

Please send in any patches that you wish to see in Spacewalk 1.5 so
that we can review and commit them before the branching event.

Thank you,




--
Jonathan Hoser, M.Sc.
Institute of Bioinformatics and System Biology
Phone: +49-89-3187-4556
Fax: +49-89-3187-3585
Email: jonathan.ho...@helmholtz-muenchen.de
WWW: http://mips.helmholtz-muenchen.de



Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671
diff --git a/utils/spacewalk-common-channels.ini b/utils/spacewalk-common-channels.ini
index 0d9a010..043fc18 100644
--- a/utils/spacewalk-common-channels.ini
+++ b/utils/spacewalk-common-channels.ini
@@ -113,6 +113,82 @@ checksum = sha256
 base_channels = fedora14-%(arch)s
 yumrepo_url = https://mirrors.fedoraproject.org/metalink?repo=fedora-debug-14&arch=%(arch)s
 
+[fedora15]
+checksum = sha256
+archs= %(_x86_archs)s
+checksum = sha256
+name = Fedora 15 (%(arch)s)
+gpgkey_url = http://download.fedoraproject.org/pub/fedora/linux/releases/15/Fedora/i386/os/RPM-GPG-KEY-fedora
+gpgkey_id = 069C8460
+gpgkey_fingerprint = 25DB B54B DED7 0987 F4C1  0042 B4EB F579 069C 8460
+yumrepo_url = https://mirrors.fedoraproject.org/metalink?repo=fedora-15&arch=%(arch)s
+
+[fedora15-updates]
+label= %(base_channel)s-updates
+name = Fedora 15 Updates (%(arch)s)
+archs= %(_x86_archs)s
+checksum = sha256
+base_channels = fedora15-%(arch)s
+yumrepo_url = https://mirrors.fedoraproject.org/metalink?repo=updates-released-f15&arch=%(arch)s
+
+[fedora15-debug]
+label= %(base_channel)s-debug
+name= Fedora 15 Debug (%(arch)s)
+archs= %(_x86_archs)s
+checksum = sha256
+base_channels = fedora15-%(arch)s
+yumrepo_url = https://mirrors.fedoraproject.org/metalink?repo=fedora-debug-15&arch=%(arch)s
+
+[centos6]
+archs= %(_x86_archs)s
+name = CentOS 6 (%(arch)s)
+gpgkey_url = http://mirror.centos.org/centos/RPM-GPG-KEY-CentOS-6
+gpgkey_id = C105B9DE
+gpgkey_fingerprint = C1DA C52D 1664 E8A4 386D  BA43 0946 FCA2 C105 B9DE
+yumrepo_url = http://mirrorlist.centos.org/?release=6&arch=%(arch)s&repo=os
+
+[centos6-addons]
+label= %(base_channel)s-addons
+archs= %(_x86_archs)s
+name = CentOS 6 Addons (%(arch)s)
+base_channels = centos6-%(arch)s
+yumrepo_url = http://mirrorlist.centos.org/?release=6&arch=%(arch)s&repo=addons
+
+[centos6-centosplus]
+label= %(base_channel)s-centosplus
+archs= %(_x86_archs)s
+name = CentOS 6 Plus (%(arch)s)
+base_channels = centos6-%(arch)s
+yumrepo_url = http://mirrorlist.centos.org/?release=6&arch=%(arch)s&repo=centosplus
+
+[centos6-contrib]
+label= %(base_channel)s-contrib
+archs= %(_x86_archs)s
+name = CentOS 6 Contrib (%(arch)s)
+base_channels = centos6-%(arch)s
+yumrepo_url = http://mirrorlist.centos.org/?release=6&arch=%(arch)s&repo=contrib
+
+[centos6-extras]
+label= %(base_channel)s-extras
+archs= %(_x86_archs)s
+name = CentOS 6 Extras (%(arch)s)
+base_channels = centos6-%(arch)s
+yumrepo_url = http://mirrorlist.centos.org/?release=6&arch=%(arch)s&repo=extras
+
+[centos6-fasttrack]
+label= %(base_channel)s-fasttrack
+archs= %(_x86_archs)s
+name = CentOS 6 FastTrack (%(arch)s)
+base_channels = centos6-%(arch)s
+yumrepo_url = http://mirrorlist.centos.org/?release=6&arch=%(arch)s&repo=fasttrack
+
+[centos6-updates]
+label= %(base_channel)s-updates
+archs= %(_x86_archs)s
+name = CentOS 6 Updates (%(arch)s)
+base_channels = centos6-%(arch)s
+yumrepo_url = http://mirrorlist.centos.org/?release=6&arch=%(arch)s&repo=updates
+
 [centos5]
 archs= %(_x86_archs)s
 name = CentOS 5 (%(arch)s)
___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

[Spacewalk-devel] [PATCH] Speedup Taskomatic cleanup-query X-fold!?!

2011-08-19 Thread Jonathan Hoser 

Hi all,
here's a small proposal from my end:
Changing the Taskomatic cleanup-query's subselect to something that
makes it sane and speedy;

I noticed this query being stuck on my Spacewalk 1.4 Servers Postgresql
backend for more than 2800 CPU minutes,
when wanting to upgrade to 1.5.

Anyhow, some stats:
The two tables in question on my current installation:
rhnPackageChangeLogData301'103 rows
rhnPackageChangeLogRec4'385'607 rows

DISTINCTING and ORDERing the subquery (see patch) on
'rhnPackageChangeLogRec' brings the relevant row count down to 301'103;

Testdriving the two queries got me the following:
Original:still running since 30minutes now (top-CPU time)
modified:  3184ms


I'm not sure if the DISTINCT and ORDER stuff is syntactically correct
for Oracle, or if the issue has shown up anywhere else;
So if someone could please test it on an Oracle installation?
In the worst case, (if I'm really the only one with the issue) it
shouldn't slow down stuff too much - and in the best case accelerate the
query quite a bit.

Questions, comments?
Best
-Jonathan


--
Jonathan Hoser, M.Sc.
Institute of Bioinformatics and System Biology

WWW: http://mips.helmholtz-muenchen.de



Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
index 051e597..e352bbe 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
@@ -295,7 +295,7 @@ SELECT id, channel_label, client, reason, force, bypass_filters, next_action
 

 DELETE FROM rhnPackageChangeLogData
-WHERE id NOT IN ( SELECT changelog_data_id FROM rhnPackageChangeLogRec )
+WHERE id NOT IN ( SELECT DISTINCT changelog_data_id FROM rhnPackageChangeLogRec ORDER BY changelog_data_id ASC )

 
 
___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] [PATCH] Speedup Taskomatic cleanup-query X-fold!?!

2011-08-22 Thread Jonathan Hoser 
le
  - ORDER BY cannot make any speed improvements, in opposite, it take some time 
to sort the query
  - regarding DISTINCT, I'm not sure, if it can have such a great impact on 
performance in this concrete case
Could you, please, send explain plans for the original and the 'DISTINCT 
variant'?


Regards,
Tomas
--
Tomas Lestach
RHN Satellite Engineering, Red Hat

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel




--
Jonathan Hoser, M.Sc.
Institute of Bioinformatics and System Biology

WWW: http://mips.helmholtz-muenchen.de



Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Outstanding patches? Send them in.

2012-02-29 Thread Jonathan Hoser 

Hi!

I take it you are still collecting patches?

Here's a minute one I came across in 1.6 that I could fix.

Best
-Jonathan

On 02/27/2012 01:30 PM, Jan Pazdziora wrote:

Hello Spacewalk hackers,

it's that time of year again -- we are aiming for the next Spacewalk
release. If you have a patch in stash which you'd like to see
included, don't wait any longer and send it to the mailing list (or
push it if you have commit access and you are comfortable with your
changeset).

Thank you,




Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671
>From 0d9b2649e4dc1d59370325d90796952c159d3730 Mon Sep 17 00:00:00 2001
From: Jonathan Hoser 
Date: Wed, 29 Feb 2012 15:09:43 +0100
Subject: [PATCH] Added 'as' to the SQL command, since PostgreSQL 9.x 
 (possibly also 8.x) stumbles over it

---
 backend/server/rhnServer/server_kickstart.py |2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/backend/server/rhnServer/server_kickstart.py b/backend/server/rhnServer/server_kickstart.py
index 0eca170..30c107b 100644
--- a/backend/server/rhnServer/server_kickstart.py
+++ b/backend/server/rhnServer/server_kickstart.py
@@ -221,7 +221,7 @@ def schedule_kickstart_sync(server_id, kickstart_session_id):
 
 def _get_ks_virt_type(type_id):
 _query_kickstart_virt_type = rhnSQL.Statement("""
-select  kvt.label label
+select  kvt.label as label
 fromrhnKickstartVirtualizationType kvt
 where   kvt.id = :id
 """)
-- 
1.7.7.6

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Outstanding patches? Send them in.

2012-03-01 Thread Jonathan Hoser 

Hi,

seems to be working just the same -
but I'm not sure I managed to trigger the function -
at least I didn't see anything (read the 'select' statement)
in my postgres-logs.

If anyone has some pointers for me what action will trigger the
'get_kickstart_session_type(server_id, action_id)'
I'd be happy to give it a go!

Best
-Jonathan

On 02/29/2012 05:01 PM, Jan Pazdziora wrote:

On Wed, Feb 29, 2012 at 04:41:38PM +0100, Jonathan Hoser wrote:

Hi!

I take it you are still collecting patches?

Here's a minute one I came across in 1.6 that I could fix.

How about just doing the

  select  kvt.label

instead, dropping the column alias altogether? The

  select  kvt.label label

seems like identity mapping.




Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Outstanding patches? Send them in.

2012-03-24 Thread Jonathan Hoser 

Hi again,

am working on a fresh installation of SW 1.7,

and again encountered the issue I suggested a patch for.
This time, I applied the suggested variant
"Select label from [...]" and it is working all the same.

It is triggered on a rhn_register call from a client.
Please find the corresponding patch attached.


Btw - is it just me or is the auto deployment of rhn-* client libs
from SW-generated kickstarts *really* lacking?
I only see it trying to install pyOpenSSL, libxml2-python and rhnlib -
my take is that these are definitly not sufficient for running the
KS-included step of
"Red Hat management server registration" as obviously the above don't
install the rhn_register
and other binaries.

Maybe I'm doing something wrong, but I really expected this to work
out-of-the-box without respecifying the rhn-* client rpms to install.

Best
-Jonathan



On 03/01/2012 01:46 PM, Jonathan Hoser wrote:

Hi,

seems to be working just the same -
but I'm not sure I managed to trigger the function -
at least I didn't see anything (read the 'select' statement)
in my postgres-logs.

If anyone has some pointers for me what action will trigger the
'get_kickstart_session_type(server_id, action_id)'
I'd be happy to give it a go!

Best
-Jonathan

On 02/29/2012 05:01 PM, Jan Pazdziora wrote:

On Wed, Feb 29, 2012 at 04:41:38PM +0100, Jonathan Hoser wrote:

Hi!

I take it you are still collecting patches?

Here's a minute one I came across in 1.6 that I could fix.

How about just doing the

   select  kvt.label

instead, dropping the column alias altogether? The

   select  kvt.label label

seems like identity mapping.



Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel






Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671
>From 0d9b2649e4dc1d59370325d90796952c159d3730 Mon Sep 17 00:00:00 2001
From: Jonathan Hoser 
Date: Wed, 29 Feb 2012 15:09:43 +0100
Subject: [PATCH] Added 'as' to the SQL command, since PostgreSQL 9.x 
 (possibly also 8.x) stumbles over it

---
 backend/server/rhnServer/server_kickstart.py |2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/backend/server/rhnServer/server_kickstart.py b/backend/server/rhnServer/server_kickstart.py
index 0eca170..30c107b 100644
--- a/backend/server/rhnServer/server_kickstart.py
+++ b/backend/server/rhnServer/server_kickstart.py
@@ -221,7 +221,7 @@ def schedule_kickstart_sync(server_id, kickstart_session_id):
 
 def _get_ks_virt_type(type_id):
 _query_kickstart_virt_type = rhnSQL.Statement("""
-select  kvt.label label
+select  label
 fromrhnKickstartVirtualizationType kvt
 where   kvt.id = :id
 """)
-- 
1.7.7.6

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Outstanding patches? Send them in.

2012-03-26 Thread Jonathan Hoser 
rror] \twsgi.version: (1, 1)
[Sun Mar 25 00:20:40 2012] [error] Extra information about this error:
[Sun Mar 25 00:20:40 2012] [error] SQL Error generated: ('syntax error
at or near "label"\\nLINE 2: select  kvt.label
label\\n  ^\\n', 0, '\\nselect
kvt.label label\\nfromrhnKickstartVirtualizationType
kvt\\nwhere   kvt.id = %(id)s\\n')
[Sun Mar 25 00:20:40 2012] [error]
[Sun Mar 25 00:20:40 2012] [error] Exception Handler Information
[Sun Mar 25 00:20:40 2012] [error] Traceback (most recent call last):
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/lib/python2.7/site-packages/spacewalk/server/apacheRequest.py",
line 122, in call_function
[Sun Mar 25 00:20:40 2012] [error] response = apply(func, params)
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 502, in
new_system
[Sun Mar 25 00:20:40 2012] [error] architecture, data)
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 403, in
create_system
[Sun Mar 25 00:20:40 2012] [error] newserv.process_kickstart_info()
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnServer/server_class.py",
line 780, in process_kickstart_info
[Sun Mar 25 00:20:40 2012] [error] kickstart_session_id)
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnServer/server_kickstart.py",
line 253, in subscribe_to_tools_channel
[Sun Mar 25 00:20:40 2012] [error] ks_type =
_get_ks_virt_type(ks_type_id)
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnServer/server_kickstart.py",
line 229, in _get_ks_virt_type
[Sun Mar 25 00:20:40 2012] [error] prepared_query.execute(id=type_id)
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 163, in execute
[Sun Mar 25 00:20:40 2012] [error] return
apply(self._execute_wrapper, (self._execute, ) + p, kw)
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 282, in _execute_wrapper
[Sun Mar 25 00:20:40 2012] [error] retval = apply(function, p, kw)
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 217, in _execute
[Sun Mar 25 00:20:40 2012] [error] return self._execute_(args, kwargs)
[Sun Mar 25 00:20:40 2012] [error]   File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 295, in _execute_
[Sun Mar 25 00:20:40 2012] [error]
self._real_cursor.execute(self.sql, params)
[Sun Mar 25 00:20:40 2012] [error] SQLStatementPrepareError: ('syntax
error at or near "label"\\nLINE 2: select  kvt.label
label\\n  ^\\n', 0, '\\nselect
kvt.label label\\nfromrhnKickstartVirtualizationType
kvt\\nwhere   kvt.id = %(id)s\\n')
[Sun Mar 25 00:20:40 2012] [error]


Best
-Jonathan



On 03/26/2012 10:29 AM, Miroslav Suchy wrote:

On 25.3.2012 01:39, Jonathan Hoser wrote:

and again encountered the issue I suggested a patch for.
This time, I applied the suggested variant
"Select label from [...]" and it is working all the same.

It is triggered on a rhn_register call from a client.
Please find the corresponding patch attached.

Sorry for joining this thread so late, but you said;


  >  Added 'as' to the SQL command, since PostgreSQL 9.x
  >  (possibly also 8.x) stumbles over it

What do you mean "stumbles"? Can you point me to some error message?
I installed pg 9.1 to test it and I did:

psql (9.1.3)
Type "help" for help.

postgres=# create table test (id int);
CREATE TABLE
postgres=# select id from test;
   id

(0 rows)

postgres=# select id from test t;
   id

(0 rows)

postgres=# select t.id from test t;
   id

(0 rows)

postgres=# select t.id id from test t;
   id

(0 rows)

postgres=# select t.id as id from test t;
   id

(0 rows)

And I see no errors from PostgreSQL server in all cases.

Mirek

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel






Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Bootstrap image feature

2012-08-01 Thread Jonathan Hoser 

Hello Uwe -

from the user-side this is a cool feature,
and seeing it implemented and working would be a great enhancement of
spacewalk.

If there was an additional way of putting that 'pre-Image' onto a USB stick,
to boot from it (with Manager/Spacewalk Details for registration) that
would be even better!

(We have to preregister MACs to get them to PXEboot,
so a prestart without PXE (showing the MACs) would a big boon, thought
only for me!?!)

Just my 5 cents,

Best
-Jonathan

On 08/01/2012 10:42 AM, Uwe Gansert wrote:

Hi,

during hackweek here at SUSE, I did a feature for bootstrapping new
machines with Spacewalk/SUSE Manager.
It works so far but I'd like to show it to you and ask if you are
interested in the feature and what you think in general about it.

I introduced the feature here:
http://suse.gansert.net/?p=542

maybe you can tell me what you think about it?





--
Jonathan Hoser, M.Sc.
Institute of Bioinformatics and System Biology

WWW: http://mips.helmholtz-muenchen.de


Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Large changes from dropping monitoring and solaris support

2014-12-17 Thread Jonathan Hoser 
On 12/17/2014 04:54 PM, Duncan Mac-Vicar P. wrote:
> On 12/17/2014 04:41 PM, Stephen Herr wrote:
>> Hey everyone,
>>
>> In preparation for Spacewalk 2.3 I have merged the perl-removal branch
>> into master, which (among other things) drops support for solaris and
>> monitoring. This is a large change, involving the deletion of many
>> database tables and obsoleting many packages. I will work to get master
>> back into a stable state, but I fully expect that there will be things
>> that are broken in the short-term. We need to work everything out now so
>> that Spacewalk 2.3 is stable and functional.
>>
>> If you notice problems related to solaris or monitoring being mentioned
>> in remaining pages, installers, tools, or problems related to upgrading
>> schema or packages, please help fix them or point them out to me so that
>> we can get everything stable for 2.3.
> Monitoring integrated somehow with the overview/alerts page.
>
> Will some infrastructure remain in place so that in the future some
> external monitoring system can be plugged in?
>
> We have a plugin that sends Spacewalk data -> Nagios and it could make
> sense providing the reverse. Spacewalk would offer just a "coord" that
> can be plugged into some monitoring system with an adaptor and you would
> see some basic status of the systems registered in both inside Spacewalk.
>
> If there are ideas around it, it could enable our team to contribute to
> that.
With that topic of integration around - I propose the vague idea of an
interface
to intersect system-status pages with something like Racktables or similar
e.g. for location or rack-management.

Just food for thought...

Two thumbs up for the perl-removal, thought!

Best
-Jonathan

--
Jonathan Hoser, M.Sc.
Institute of Bioinformatics and System Biology

WWW: http://mips.helmholtz-muenchen.de


Helmholtz Zentrum München
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)
Ingolstädter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe
Geschäftsführer: Prof. Dr. Günther Wess, Dr. Nikolaus Blum, Dr. Alfons Enhsen
Registergericht: Amtsgericht München HRB 6466
USt-IdNr: DE 129521671

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

[Spacewalk-devel] Fedora22 - DNF and spacewalk-plugin

2015-06-26 Thread Jonathan Hoser 
Dear all,

we are not sure anymore what we are doing - everyone is going mad atm...

Maybe due to our current experience with Fedora22, DNF and the
spacewalk-plugin.
Don't get us wrong, we are delighted there is one,
but we have a ton of trouble with it.

It may be because somewhere a rhnlib got cross-installed on the new
systems,
but I thought, I'd just share our experience for others...

After getting DNF to talk, the following was reported:

Traceback (most recent call last):
  File "/usr/bin/dnf", line 36, in 
main.user_main(sys.argv[1:], exit_code=True)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 185, in
user_main
errcode = main(args)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 84, in main
return _main(base, args)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 115, in
_main
cli.configure(map(ucd, args))
  File "/usr/lib/python2.7/site-packages/dnf/cli/cli.py", line 983, in
configure
self.base.plugins.load(self.base.conf.pluginpath, opts.disableplugins)
  File "/usr/lib/python2.7/site-packages/dnf/plugin.py", line 94, in load
import_modules(package, files)
  File "/usr/lib/python2.7/site-packages/dnf/plugin.py", line 123, in
import_modules
module = importlib.import_module(name)
  File "/usr/lib64/python2.7/importlib/__init__.py", line 37, in
import_module
__import__(name)
  File "/usr/lib/python2.7/site-packages/dnf-plugins/spacewalk.py", line
34, in 
import up2date_client.up2dateAuth
  File "/usr/share/rhn/up2date_client/up2dateAuth.py", line 3, in 
import rhnserver
  File "/usr/share/rhn/up2date_client/rhnserver.py", line 34, in 
import rpcServer
  File "/usr/share/rhn/up2date_client/rpcServer.py", line 5, in 
import config
  File "/usr/share/rhn/up2date_client/config.py", line 16, in 
from rhn.connections import idn_ascii_to_puny, idn_puny_to_unicode
ImportError: cannot import name idn_ascii_to_puny


=> idn_pune_to_unicode idn_ascii_to_pune

We had a hard time finding and identifying the missing imports
and funnily we didn't see idn_ascii_to_puny, idn_puny_to_unicode but
idn_pune_to_unicode idn_ascii_to_pune
are in the rhnlib that is atm on the system. It might be the wrong one
(i.e. from fedora repos),
and this error followed us some time around, until I replaced a number
of 'y's with 'e's.

Now we got the plugin working, BUT

 dnf repolist -d 10 -e 10
timer: config: 9 ms
cachedir: /var/cache/dnf/x86_64/22
Loaded plugins: builddep, Query, generate_completion_cache, noroot,
config-manager, download, protected_packages, migrate, reposync,
debuginfo-install, copr, playground, langpacks, kickstart,
needs-restarting, spacewalk
initialized Langpacks plugin
initializing!! Spacewalk plugin
initializing.past config parsing Spacewalk plugin
initialized Spacewalk plugin
DNF version: 1.0.1
Command: dnf repolist -d 10 -e 10
Installroot: /
Releasever: 22
Base command: repolist
Extra commands: []
This system is receiving updates from Spacewalk server.
Cleaning up.
Traceback (most recent call last):
  File "/usr/bin/dnf", line 36, in 
main.user_main(sys.argv[1:], exit_code=True)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 185, in
user_main
errcode = main(args)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 84, in main
return _main(base, args)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 115, in
_main
cli.configure(map(ucd, args))
  File "/usr/lib/python2.7/site-packages/dnf/cli/cli.py", line 1016, in
configure
self.base.plugins.run_config()
  File "/usr/lib/python2.7/site-packages/dnf/plugin.py", line 82, in fn
dnf.util.mapall(operator.methodcaller(method), self.plugins)
  File "/usr/lib/python2.7/site-packages/dnf/util.py", line 157, in mapall
return list(map(fn, *seq))
  File "/usr/lib/python2.7/site-packages/dnf-plugins/spacewalk.py", line
84, in config
self.activate_channels(self.cli.demands.sack_activation)
  File "/usr/lib/python2.7/site-packages/dnf-plugins/spacewalk.py", line
158, in activate_channels
'enabled': conf.enabled,
  File "/usr/lib/python2.7/site-packages/dnf-plugins/spacewalk.py", line
227, in __init__
except InvalidGpgKeyLocation as e:
NameError: global name 'InvalidGpgKeyLocation' is not defined

(Yes, there's some debug messages from me in the DNF load);

In yum-rhn-plugin/rhnplugin.py there was/is a class defined:
class InvalidGpgKeyLocation(Exception):
but this is not present in dnf-plugins/spacewalk.py
...

Arg. Just saw the FIXME note in dnf-plugins/spacewalk.py
that a number of functions should be moved to rhn-client-tools

We will look further.

Best
-Jonathan

-- 
Jonathan

Re: [Spacewalk-devel] Fedora22 - DNF and spacewalk-plugin

2015-06-26 Thread Jonathan Hoser 
Ok, we are getting a bit further:

(after adding the follwing to dnf-plugins/spacewalk.py:

class InvalidGpgKeyLocation(Exception):
msg = ""

def __init__(self, msgtext):
self.msg = msgtext

#pass


(Sorry, we don't do python for a living, so it is a bit bumpy.)

On it goes:
dnf repolist -d 10 -e 10
[...]
not found deltainfo for: Fedora 22 Updates (x86_64)
repo: downloading from remote: fedora22-x86_64, _Handle: metalnk: None,
mlist: None, urls [u'https://OURSPACEWALK/XMLRPC/GET-REQ/fedora22-x86_64'].
not found deltainfo for: Fedora 22 (x86_64)
not found updateinfo for: Fedora 22 (x86_64)
repo: downloading from remote: clone-spacewalk23-client-fedora21-x86_64,
_Handle: metalnk: None, mlist: None, urls
[u'https://OURSPACEWALK/XMLRPC/GET-REQ/clone-spacewalk23-client-fedora21-x86_64'].
not found deltainfo for: Clone of Spacewalk Client 2.3 for Fedora 21
(x86_64)
not found updateinfo for: Clone of Spacewalk Client 2.3 for Fedora 21
(x86_64)
timer: sack setup: 63303 ms
ibis-special-fedora-22: using metadata from Fri Jun 26 15:05:22 2015.
fedora22-x86_64-updates: using metadata from Fri Jun 26 15:05:24 2015.
fedora22-x86_64: using metadata from Fri Jun 26 15:05:34 2015.
clone-spacewalk23-client-fedora21-x86_64: using metadata from Fri Jun 26
15:06:23 2015.
Last metadata expiration check performed 0:00:00 ago on Fri Jun 26
15:06:23 2015.
Completion plugin: Generating completion cache...
Cleaning up.
Traceback (most recent call last):
  File "/usr/bin/dnf", line 36, in 
main.user_main(sys.argv[1:], exit_code=True)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 185, in
user_main
errcode = main(args)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 84, in main
return _main(base, args)
  File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 134, in
_main
cli.run()
  File "/usr/lib/python2.7/site-packages/dnf/cli/cli.py", line 1077, in run
return self.command.run(self.base.extcmds)
  File "/usr/lib/python2.7/site-packages/dnf/cli/commands/repolist.py",
line 216, in run
if repo.repofile:
AttributeError: 'SpacewalkRepo' object has no attribute 'repofile'

On 06/26/2015 02:55 PM, Jonathan Hoser wrote:
> Dear all,
>
> we are not sure anymore what we are doing - everyone is going mad atm...
>
> Maybe due to our current experience with Fedora22, DNF and the
> spacewalk-plugin.
> Don't get us wrong, we are delighted there is one,
> but we have a ton of trouble with it.
>
> It may be because somewhere a rhnlib got cross-installed on the new
> systems,
> but I thought, I'd just share our experience for others...
>
> After getting DNF to talk, the following was reported:
>
> Traceback (most recent call last):
>   File "/usr/bin/dnf", line 36, in 
> main.user_main(sys.argv[1:], exit_code=True)
>   File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 185, in
> user_main
> errcode = main(args)
>   File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 84, in main
> return _main(base, args)
>   File "/usr/lib/python2.7/site-packages/dnf/cli/main.py", line 115, in
> _main
> cli.configure(map(ucd, args))
>   File "/usr/lib/python2.7/site-packages/dnf/cli/cli.py", line 983, in
> configure
> self.base.plugins.load(self.base.conf.pluginpath, opts.disableplugins)
>   File "/usr/lib/python2.7/site-packages/dnf/plugin.py", line 94, in load
> import_modules(package, files)
>   File "/usr/lib/python2.7/site-packages/dnf/plugin.py", line 123, in
> import_modules
> module = importlib.import_module(name)
>   File "/usr/lib64/python2.7/importlib/__init__.py", line 37, in
> import_module
> __import__(name)
>   File "/usr/lib/python2.7/site-packages/dnf-plugins/spacewalk.py", line
> 34, in 
> import up2date_client.up2dateAuth
>   File "/usr/share/rhn/up2date_client/up2dateAuth.py", line 3, in 
> import rhnserver
>   File "/usr/share/rhn/up2date_client/rhnserver.py", line 34, in 
> import rpcServer
>   File "/usr/share/rhn/up2date_client/rpcServer.py", line 5, in 
> import config
>   File "/usr/share/rhn/up2date_client/config.py", line 16, in 
> from rhn.connections import idn_ascii_to_puny, idn_puny_to_unicode
> ImportError: cannot import name idn_ascii_to_puny
>
>
> => idn_pune_to_unicode idn_ascii_to_pune
>
> We had a hard time finding and identifying the missing imports
> and funnily we didn't see idn_ascii_to_puny, idn_puny_to_unicode but
> idn_pune_to_unicode idn_ascii_to_pune
> are in the rhnlib that is atm on the system. It might be the wrong one
> (i.e. from

Re: [Spacewalk-devel] Fedora22 - DNF and spacewalk-plugin

2015-06-26 Thread Jonathan Hoser 
Thanks Jan, Tomas!
> [1] https://bugzilla.redhat.com/show_bug.cgi?id=1235574
>
> Regards,
Yes, we know it is upstream, but on the other hand,
we wanted to try our hand at Fedora22 and Spacewalk;

We are way away of being ready for role-out, that said,
my take is that using upstream and nightly should be ok for
the preliminary testing/fiddling.

If we can help someone else along, the better.

Towards that:

What is the sense behind the code in dnf-plugin/spacewalk.py:
get_gpg_key_urls / is_valid_gpg_key_url?
Are there - in row/followup of complaining about non-local gpg-key-files
- plans to automatically import them to dnf/yum/rpm?

Might I raise the point that such changes should then also be carried
over to e.g. spacewalk-common-channels?

AND installing dnf-plugin-spacewalk does disable the spacewalk-repos on
the machine... (/etc/dnf/plugins/spacewalk.conf )

We head of for more testing and tinkering,
best
-Jonathan

-- 
Jonathan Hoser, M.Sc.
Institute of Bioinformatics and System Biology


Helmholtz Zentrum Muenchen
Deutsches Forschungszentrum fuer Gesundheit und Umwelt (GmbH)
Ingolstaedter Landstr. 1
85764 Neuherberg
www.helmholtz-muenchen.de
Aufsichtsratsvorsitzende: MinDir'in Baerbel Brumme-Bothe
Geschaeftsfuehrer: Prof. Dr. Guenther Wess, Dr. Nikolaus Blum, Dr. Alfons Enhsen
Registergericht: Amtsgericht Muenchen HRB 6466
USt-IdNr: DE 129521671


___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel