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 <jonathan.ho...@helmholtz-muenchen.de>
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
         from    rhnKickstartVirtualizationType 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

Reply via email to