Re: [Spacewalk-list] Random Oracle Error Spacewalk 1.4 centos 5.6 x86_64
Hi Phil, I think the list stripped off the actual patch file, any chance you could re-send it please ? I'd certainly be very interested to try it and also try to understand why this has happened, that way I can raise a bug for it and suggest your patch (assuming you've not done that already). thanks, Matt From: spacewalk-list-boun...@redhat.com [spacewalk-list-boun...@redhat.com] on behalf of Philip Rhodes [rho...@me.com] Sent: 15 June 2011 22:12 To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Random Oracle Error Spacewalk 1.4 centos 5.6 x86_64 Michael, Matt, I believe this patch fixed my problem as well. Just to be clear, I was getting XMLRPC 500 errors, and the following error in /var/log/httpd/error_log: SQL Error generated: (1484, 'ORA-01484: arrays can only be bound to PL/SQL statements\n', 'select ks.id from rhnKickstartSession ks where ( (ks.old_server_id = :server_id and ks.new_server_id is NULL) or ks.n ew_server_id = :server_id or ks.host_server_id = :server_id ) and ks.action_id = :action_id') This was raised by /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py I thought I'd put this info together to help people searching for a solution to this problem. Thanks for your help, -Phil -- Dr. Phil Rhodes Associate Professor Department of Computer and Information Science University of Mississippi On Jun 7, 2011, at 3:57 AM, Michael Mraka wrote: Matthew Darcy wrote: % Looking at the problems I've been having recently, this appears to be one of the core factors in it, and appears to tie into the error message I see in my apache error_log on a clean boot % % Any input as to what is causing Oracle to have a problem would be most appreciated. Hi Matt, it seems the bug is caused by changes in 3fd9dc08327d15d16d4307bfe847cb0878b85ac3. Could you try if following patch solves your issue? Regards, -- Michael Mráka Satellite Engineering, Red Hat - diff --git a/backend/server/rhnAction.py b/backend/server/rhnAction.py index 7c6cc89..1ac276d 100644 --- a/backend/server/rhnAction.py +++ b/backend/server/rhnAction.py @@ -123,7 +123,7 @@ def _invalidate_action_recursive(server_id, action_id, h, h_child): if not row: break child_ids = _invalidate_action_recursive(server_id, row['id'], h, h_child) -a_ids.append(child_ids) +a_ids += child_ids h.execute(server_id=server_id, action_id=action_id) s_row = h.fetchone_dict() if s_row and s_row['status'] 3: ___ Spacewalk-list mailing list Spacewalk-list@redhat.commailto:Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email _ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Random Oracle Error Spacewalk 1.4 centos 5.6 x86_64
On Thu, Jun 16, 2011 at 07:54:05AM +, Matthew Darcy wrote: I think the list stripped off the actual patch file, any chance you could re-send it please ? https://www.redhat.com/archives/spacewalk-list/2011-June/msg00044.html That's what you get for top-posting. I'd certainly be very interested to try it and also try to understand why this has happened, that way I can raise a bug for it and suggest your patch (assuming you've not done that already). The patch is already in Spacewalk master: 632869ad36b365934f98c5f85825624c9efc9a41 -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Server not seeing updates available for clients
On Mon, Jun 13, 2011 at 11:14:03AM -0400, Kyaphas G Hill wrote: My 1.1 Spacewalk server has stopped showing updates available for clients, even though running yum check-update on clients shows that several updates are available. The systems are CentOS 5.6, and I recall an email previously that said you might have to flush your channels due to a signature issue. I wasn't sure exactly how to flush the channels, so I just created new ones, moved the systems over and they saw their updates for a while. Now it's stopped again. Is there something else I need to change? We've fixed a couple of issues with the regeneration of the package cache which holds lists of package that might need to get updated since 1.1. You might want to upgrade your Spacewalk server to 1.4. Yours, -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] spacewalk problem while register clients
On Tue, Jun 14, 2011 at 11:00:21AM +0300, Aleksandar Pashaliyski wrote: Hi Matt, Yes, I'm able to resolve the hostname of machine and connect local to oracle database: [root@spacewalk ~]# sqlplus 'spacewalk/spacewalk@//localhost/XE' SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 14 10:54:55 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production [root@spacewalk ~]# sqlplus 'spacewalk/spacewalk@//spacewalk.local.net/XE' SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 14 10:55:15 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL SQL Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production Does satellite-sync / spacewalk-repo-sync work? Any AVC denials in /var/log/audit/audit.log? -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Manually accessing a channel using yum
On Thu, Jun 09, 2011 at 01:35:21PM +0100, Tom Brown wrote: Does anyone know if i can configure a channel as a repo? I'd like to present a couple of channels that are in spacewalk to systems that cant for one reason or another be registered in spacewalk but could do with using the packages in a repo https://Spacewalk URL/XMLRPC/GET-REQ/centos-5-x86_64-01122010/repodata/repomd.xml HTTP/1.1 200 871 Thats a client getting some repo data from the server - but is it possible to get at it in any other way? Not really. Being able to generate proper yum repos from Spacewalk channels is a natural RFE thou, so if you are an analyst or developer with some spare time, specs or patches are welcome. -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Manually accessing a channel using yum
Not really. Being able to generate proper yum repos from Spacewalk channels is a natural RFE thou, so if you are an analyst or developer with some spare time, specs or patches are welcome. OK thanks for the info - However, can i ask where the repo URL for a spacewalk kickstarted host come from? If from a spaewalk generated kickstart i can see a repo presented to anaconda at install time, surely that should be accesible from else where? thanks ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Manually accessing a channel using yum
On Thu, Jun 16, 2011 at 01:13:02PM +0100, Tom Brown wrote: Not really. Being able to generate proper yum repos from Spacewalk channels is a natural RFE thou, so if you are an analyst or developer with some spare time, specs or patches are welcome. OK thanks for the info - However, can i ask where the repo URL for a spacewalk kickstarted host come from? If from a spaewalk generated They are handlers defined in Apache's conf files. kickstart i can see a repo presented to anaconda at install time, surely that should be accesible from else where? Not really -- the repo is presented on the fly, merging content from /var/cache/rhn/repodata, /var/satellite/rhn, and /var/satellite/redhat. It's not stored in the repo tree anywhere. -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Manually accessing a channel using yum
On 16 June 2011 13:26, Jan Pazdziora jpazdzi...@redhat.com wrote: On Thu, Jun 16, 2011 at 01:13:02PM +0100, Tom Brown wrote: Not really. Being able to generate proper yum repos from Spacewalk channels is a natural RFE thou, so if you are an analyst or developer with some spare time, specs or patches are welcome. OK thanks for the info - However, can i ask where the repo URL for a spacewalk kickstarted host come from? If from a spaewalk generated They are handlers defined in Apache's conf files. kickstart i can see a repo presented to anaconda at install time, surely that should be accesible from else where? Not really -- the repo is presented on the fly, merging content from /var/cache/rhn/repodata, /var/satellite/rhn, and /var/satellite/redhat. It's not stored in the repo tree anywhere. generated on the fly by hitting a URL ? If so then cant i hit that URL from _any_ box? Fundamentally i'm trying to hit channels that are managed by spacewalk from machines that dont have spacewalk managed kickstarts, being pure cobbler instead. thanks ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Server not seeing updates available for clients
Ok. This happened after I updated from 1.0 to 1.1 and my intent is to update all the way to 1.4, I just thought I had to upgrade the clients at the same time as the server. I'll just update the server and clients together manually through to 1.4 and see how that goes. Thanks! Kyaphas Hill Network Engineer CSC 14120 Newbrook Drive - Suite 200, Chantilly, VA 20151 Integrated Customer Solutions | p: 703-364-6128 | c: 571-286-7698 | khil...@csc.com | www.csc.com This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. From: Jan Pazdziora jpazdzi...@redhat.com To: spacewalk-list@redhat.com Date: 06/16/2011 04:22 AM Subject: Re: [Spacewalk-list] Server not seeing updates available for clients On Mon, Jun 13, 2011 at 11:14:03AM -0400, Kyaphas G Hill wrote: My 1.1 Spacewalk server has stopped showing updates available for clients, even though running yum check-update on clients shows that several updates are available. The systems are CentOS 5.6, and I recall an email previously that said you might have to flush your channels due to a signature issue. I wasn't sure exactly how to flush the channels, so I just created new ones, moved the systems over and they saw their updates for a while. Now it's stopped again. Is there something else I need to change? We've fixed a couple of issues with the regeneration of the package cache which holds lists of package that might need to get updated since 1.1. You might want to upgrade your Spacewalk server to 1.4. Yours, -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] How To ...
OK, I'm a newbie at this Spacewalk thing (however, we do use Satellite at work). What's happened is that while setting up and populating my channels I've run out of space on Oracle XE. From what I've seen and read I've got the following options: Migrate from Oracle XE to standard Oracle (which I have running on another machine) - does the Oracle instance have to be local? Stop and drop everything and use Spacewalk PostgreSQL - what do I stand to loose with this? Stop and drop everything and use Spacewalk Oracle on the machine where Oracle is already running - this is a POC environment (no maintenance, no support) Cut back on the number of channels (currently, CentOS 5.6 i386/x86_64; Fedora 13 i386/x86_64; Fedora 14 i386/x86_64; Fedora 15 i386/x86_64)? Go back to using Satellite and add the CentOS and Fedora channels - Will Satellite go crazy if I add those? Help!!! Thanks, Gene Poole ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] How To ...
On 06/16/2011 04:46 PM, Gene Poole wrote: 1. Migrate from Oracle XE to standard Oracle (which I have running on another machine) - does the Oracle instance have to be local? No, oracle instance does not need to be local. 2. Stop and drop everything and use Spacewalk PostgreSQL - what do I stand to loose with this? You can migrate data: https://fedorahosted.org/spacewalk/wiki/PostgreSQLFromOracle 3. Stop and drop everything and use Spacewalk Oracle on the machine where Oracle is already running - this is a POC environment (no maintenance, no support) 4. Cut back on the number of channels (currently, CentOS 5.6 i386/x86_64; Fedora 13 i386/x86_64; Fedora 14 i386/x86_64; Fedora 15 i386/x86_64)? I think you do not need to think about this ones since 2 options above are much better. 5. Go back to using Satellite and add the CentOS and Fedora channels - Will Satellite go crazy if I add those? It is absolutely ok to use RHN Satellite with those channels. Just make sure you set enable_nvrea to 1 in rhn.conf. -- Miroslav Suchy Red Hat Satellite Engineering ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] Spacewalk 1.4: osa-dispatcher Problem
List: I reregistered a handful of systems on my Spacewalk server; however, after doing so, no client will pick up any actions from osad. Clients that were untouched are also affected. My current situation is almost exactly like: https://bugzilla.redhat.com/show_bug.cgi?id=662593 However, all clients and the server are running Spacewalk 1.4. I'm a bit stumped on how to proceed to fix the problem. Any help would be appreciated. Thank you. ___ Trevor T. Kates CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you. ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] RHEL channel sync
Hi ALL, I know we can't sync RHEL environment through Spacewalk, but I've found rhn-clone-errata.py and rhn_channel_download.pl scripts. Both of them have problems during the downloading (it can download first 20 rpms only). Do we really have a workable solution for upgrading our RHEL staff? As far as I understand, we can detach a specific server downloads all RHEL rpms through channel update and keeps local repo for Spacewalk. I don't have success during downloading. Does anyone know how we can cope with it? Kind regards, Ivan ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list