[Spacewalk-list] Problem to resign certificate
Hi all. I'm trying to resign the spacewalk-public.cert with a new owner name, but I'm having a problem (the same happens with the template.cert). I successfully did this same process with Spacewalk 1.5 on CentOS 5.7, but now in Spacewalk 1.6 on a RHEL6.2 I receive this: # perl gen-oss-sat-cert.pl --signer --resign /usr/share/spacewalk/setup/spacewalk-public.cert Passphrase: Can't connect to data source '' because I can't work out what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix and the DBI_DRIVER env var is not set) at /usr/share/perl5/vendor_perl/RHN/DB/DataSource.pm line 70 Comparing the DataSource.pm of 1.6 with the same file shipped with 1.5 I found just one little diff: # diff /usr/share/perl5/vendor_perl/RHN/DB/DataSource.pm /tmp/oldDataSource.pm 2c2 # Copyright (c) 2008--2011 Red Hat, Inc. --- # Copyright (c) 2008--2010 Red Hat, Inc. 47c47 my $query_body = sprintf $original_body, join(, , map { :$_ } sort keys %param_map); --- my $query_body = sprintf $original_body, join(, , map { :$_ } keys %param_map); Searching on the web I found this https://bugzilla.redhat.com/show_bug.cgi?id=529371, but I guess that isn't the same cause. Does anybody is having the same issue? Thanks in advance, Nilton Moura. ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] clone-errata ChanMap advice
Hi John, Let's see if'n I can't clarify things for you... see below. After upgrading to 1.6 I decided to give clone-errata another try. I managed to have some success with version .2 getting my CentOS 5 x64 base channel errata working. Couldn't get any others to work though, then I discovered that clone- errata was up to ver 0.9 I'm now getting more errata published but they don't seem to apply to my 6 clients at all. The ChanMap and SuffixMap sections are a bit confusing as the examples on the web seem to reference RHEL channels only not CentOS ones. Ok, let me make sure I understand what you're trying to do. You're connecting to RHN in order to pull errata from RHEL software channels, but are trying to apply those errata to CentOS channels in Spacewalk, yes? If that's the case, then this simply isn't going to work. Errata from RHN are meant for RHEL software channels, not CentOS channels. Any how this is what I've done: [ChanMap] rhel-x86_64-server-5=centos5-x86_64 rhel-x86_64-server-supplementary-5=centos5-x86_64-extras rhel-x86_64-server-6=centos6-x86_64 rhel-x86_64-server-optional-6=centos6-x86_64-extras [ChanSuffixMap] rhel-x86_64-server-5=R5-64 rhel-x86_64-server-supplementary-5=R5-64-S rhel-x86_64-server-6=R6-64 rhel-x86_64-server-optional-6=R6-64-O Clearly I've at least confused the Suffix Map as I used both S and O. Have I messed this up royally or what? The suffix map is intended to map official RHEL software channels from RHN with whatever names you gave your RHEL channels in spacewalk. In my case, they're mostly the same, to save myself some hassle... but this allows you some flexibility in your channel naming convention. Here are my channel labels and repos they point to: centos5-x86_64 -- http://mirror.centos.org/centos-5/5/os/x86_64/ centos5-x86_64-extras -- http://mirror.centos.org/centos/5/extras/x86_64/ centos5-x86_64-updates -- http://mirror.centos.org/centos-5/5/updates/x86_64/ centos6-x86_64 -- http://mirror.centos.org/centos-6/6/os/x86_64/ centos6-x86_64-extras -- http://mirror.centos.org/centos/6/extras/x86_64/ centos6-x86_64-updates -- http://mirror.centos.org/centos-6/6/updates/x86_64/ I wasn't aware that the CentOS maintainers published any official errata for their software... please clue me in if'n that's not the case. Remember, just because they may be named the same thing, and lay down the exact same software; these packages are not the same. I almost forgot, I'm getting this error when clone-errata exits: Skipping errata due to missing package(s)... RHSA-2008:0529 Traceback (most recent call last): File ./rhn-clone-errata-0.9.0.py, line 807, in module main() File ./rhn-clone-errata-0.9.0.py, line 716, in main 0) File ./rhn-clone-errata-0.9.0.py, line 445, in searchNVREA return self.server.packages.findByNvrea(self.rhnSession,name,version,release,arch label) File /usr/lib64/python2.6/xmlrpclib.py, line 1199, in __call__ return self.__send(self.__name, args) File /usr/lib64/python2.6/xmlrpclib.py, line 1489, in __request verbose=self.__verbose File /usr/lib64/python2.6/xmlrpclib.py, line 1253, in request return self._parse_response(h.getfile(), sock) File /usr/lib64/python2.6/xmlrpclib.py, line 1392, in _parse_response return u.close() File /usr/lib64/python2.6/xmlrpclib.py, line 838, in close raise Fault(**self._stack[0]) xmlrpclib.Fault: Fault -1: 'redstone.xmlrpc.XmlRpcFault: Could not find method: findByNvrea in class: com.redhat.rhn.frontend.xmlrpc.packages.PackagesHandler with params: [java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String]' This last part has me initially stumped at first look. Does this happen every time? Thanks, Andy ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] gensystemid error RHEL 6
I am attempting to configure mrepo to allow me to put all my repo's on the spacewalk server; however I cannot work past the following error with gensystemid. Has anyone encountered this issue before? * I am using the latest mrepo from https://github.com/dagwieers/mrepo I am missing something simple and can't place it. Any help or suggestions would be greatly appreciated. gensystemid -r 5Server -a x86_64 /local/repo/rhel5-server-x86_64 Traceback (most recent call last): File /usr/bin/gensystemid, line 15, in module from up2date_client import config, rpcServer, up2dateErrors File /usr/share/mrepo/up2date_client/rpcServer.py, line 18, in module import up2dateAuth File /usr/share/mrepo/up2date_client/up2dateAuth.py, line 17, in module from rhn import rpclib File /usr/lib/python2.6/site-packages/rhn/rpclib.py, line 20, in module import transports File /usr/lib/python2.6/site-packages/rhn/transports.py, line 22, in module import connections File /usr/lib/python2.6/site-packages/rhn/connections.py, line 18, in module from platform import python_version ImportError: cannot import name python_version Rich J. Bogle Engineering Specialist Infrastructure Computing Systems Information Technology WILLIAMS INTERNATIONAL A COMPANY WITH A VISION This email message and any attachment(s) are for the sole use of the intended recipient(s) and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient(s), please contact the sender by reply email and destroy the original message and any copies of the message as well as any attachment(s) to the original message. This email message does not form a binding contract or contract amendment with the sender, unless it clearly states in writing that it is a contract or contract amendment. ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] Trouble cloning a channel
Hi all, I was trying to clone a channel this morning and ran into an Internal 500 error. I am wondering if any of you have seen this issue and if so if you know of a fix. Our spacewalk server is running version 1.5 on a CentOS 5.7 system with a postgresql database. Below is the traceback. The following exception occurred while executing this request: POST /network/software/channels/manage/edit.pxt HTTP/1.1 (from browser) /network/software/channels/manage/edit.pxt (from Apache) Date: Thu Jan 12 07:57:49 2012 Headers: Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Accept-Encoding: gzip, deflate Accept-Language: en-us,en;q=0.5 Connection: keep-alive Content-Length: 403 Content-Type: application/x-www-form-urlencoded Cookie: amlbcookie=01; ObLEXMARK=0xe5eaaadb33a4fb37|0xca82ba7caef3ea209e6632c3e78452f1; iPlanetDirectoryPro=AQIC5wM2LY4SfcxoOIPfCQ1EotmXkpv7OvTiv56YdMG9Rwo.*AAJTSQACMDYAAlMxAAIwMQ..*; pxt-session-cookie=6709x087acd0c39109ad064d145320cdc6ca2 DNT: 1 Host: spacewalk.lpdev.prtdev.lexmark.com Referer: https://spacewalk.lpdev.prtdev.lexmark.com/network/software/channels/manage/edit.pxt?clone_from=355clone_type=current User-Agent: Mozilla/5.0 (X11; Linux i686; rv:9.0.1) Gecko/20100101 Firefox/9.0.1 Form variables: channel_arch = 500 channel_description = channel_gpg_key_fp = channel_gpg_key_id = channel_gpg_key_url = http://mirror.centos.org/centos/RPM-GPG-KEY-CentOS-6 channel_name = LPDEV_CENT6_BASE_i386_STABLE channel_summary = LPDEV CentOS 6 Stable for i386 architecture cid = clone_from = 355 clone_type = current new_channel_label = lpdev-cent6-base-i386-stable pxt:trap = rhn:channel_edit_cb submit = Create Channel User Information: User admin (id 1, org_id 1) Error notes: (none) Initial Request: Yes Error message: Cannot bind unknown placeholder ':p1' at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 560. -- Thanks, Eric Lake ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Problem to resign certificate
Just to inform that I exported my gpg key to the machine with Spacewalk 1.5 and there I did this with success. 2012/1/12 Nilton Moura red...@nmoura.eti.br Hi all. I'm trying to resign the spacewalk-public.cert with a new owner name, but I'm having a problem (the same happens with the template.cert). I successfully did this same process with Spacewalk 1.5 on CentOS 5.7, but now in Spacewalk 1.6 on a RHEL6.2 I receive this: # perl gen-oss-sat-cert.pl --signer --resign /usr/share/spacewalk/setup/spacewalk-public.cert Passphrase: Can't connect to data source '' because I can't work out what driver to use (it doesn't seem to contain a 'dbi:driver:' prefix and the DBI_DRIVER env var is not set) at /usr/share/perl5/vendor_perl/RHN/DB/DataSource.pm line 70 Comparing the DataSource.pm of 1.6 with the same file shipped with 1.5 I found just one little diff: # diff /usr/share/perl5/vendor_perl/RHN/DB/DataSource.pm /tmp/oldDataSource.pm 2c2 # Copyright (c) 2008--2011 Red Hat, Inc. --- # Copyright (c) 2008--2010 Red Hat, Inc. 47c47 my $query_body = sprintf $original_body, join(, , map { :$_ } sort keys %param_map); --- my $query_body = sprintf $original_body, join(, , map { :$_ } keys %param_map); Searching on the web I found this https://bugzilla.redhat.com/show_bug.cgi?id=529371, but I guess that isn't the same cause. Does anybody is having the same issue? Thanks in advance, Nilton Moura. ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] Query Continuously Running
Spacewalk 1.5 (PostgreSQL) on Cent 6 I've been seeing a process keep popping up that uses as much cpu as it can get. It appears to be a delete transaction. I've run the following query in psql: select current_query from pg_stat_activity where current_query 'IDLE' and current_query not like '%pg_stat_activity%'; It appears that the query that is hanging is: DELETE FROM rhnPackageChangeLogData WHERE id NOT IN ( SELECT changelog_data_id FROM rhnPackageChangeLogRec ) Any insight into this? Thanks, Greg ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] clone-errata ChanMap advice
Hey Andy thanks for the reply. RE: apply RHEL errata to CentOS: Ya I tend to do things a little differently, but I normally get there. CentOS is typically used for "customers" and getting them to apply patches is as we all know painful at best so being able to know when they are needed is really beneficial to both my workflow and applying pressure when patching is needed. CentOS announces errata notifications just like RH. I can forward you a few if you wish. http://lists.centos.org/mailman/listinfo/centos-announce Is there a web resource to pull them from like you do with RH I'm unsure of. The CentOS announcements actually point back to RH for the real description so the errata seem to follow a very 1 to 1 relationship. Clearly the underling packages are different though. In general what I've done seems to be working great the CentOS 5 clients are getting the proper errata's listed but the 6 clients are not getting any listings. I'm happy to help in anyway I can at digging up CentOS info and testing. However my Python skills are terrible and work load prevents it from improving much, so offering patches is pretty much out of the question. Sorry. As for the ending error yes it occurs every time. John On 1/12/2012 6:57 AM, Speagle, Andy wrote: Hi John, Let's see if'n I can't clarify things for you... see below. After upgrading to 1.6 I decided to give clone-errata another try. I managed to have some success with version .2 getting my CentOS 5 x64 base channel errata working. Couldn't get any others to work though, then I discovered that clone- errata was up to ver 0.9 I'm now getting more errata published but they don't seem to apply to my 6 clients at all. The ChanMap and SuffixMap sections are a bit confusing as the examples on the web seem to reference RHEL channels only not CentOS ones. Ok, let me make sure I understand what you're trying to do. You're connecting to RHN in order to pull errata from RHEL software channels, but are trying to apply those errata to CentOS channels in Spacewalk, yes? If that's the case, then this simply isn't going to work. Errata from RHN are meant for RHEL software channels, not CentOS channels. Any how this is what I've done: [ChanMap] rhel-x86_64-server-5=centos5-x86_64 rhel-x86_64-server-supplementary-5=centos5-x86_64-extras rhel-x86_64-server-6=centos6-x86_64 rhel-x86_64-server-optional-6=centos6-x86_64-extras [ChanSuffixMap] rhel-x86_64-server-5=R5-64 rhel-x86_64-server-supplementary-5=R5-64-S rhel-x86_64-server-6=R6-64 rhel-x86_64-server-optional-6=R6-64-O Clearly I've at least confused the Suffix Map as I used both S and O. Have I messed this up royally or what? The suffix map is intended to map official RHEL software channels from RHN with whatever names you gave your RHEL channels in spacewalk. In my case, they're mostly the same, to save myself some hassle... but this allows you some flexibility in your channel naming convention. Here are my channel labels and repos they point to: centos5-x86_64 -- http://mirror.centos.org/centos-5/5/os/x86_64/ centos5-x86_64-extras -- http://mirror.centos.org/centos/5/extras/x86_64/ centos5-x86_64-updates -- http://mirror.centos.org/centos-5/5/updates/x86_64/ centos6-x86_64 -- http://mirror.centos.org/centos-6/6/os/x86_64/ centos6-x86_64-extras -- http://mirror.centos.org/centos/6/extras/x86_64/ centos6-x86_64-updates -- http://mirror.centos.org/centos-6/6/updates/x86_64/ I wasn't aware that the CentOS maintainers published any official errata for their software... please clue me in if'n that's not the case. Remember, just because they may be named the same thing, and lay down the exact same software; these packages are not the same. I almost forgot, I'm getting this error when clone-errata exits: Skipping errata due to missing package(s)... RHSA-2008:0529 Traceback (most recent call last): File "./rhn-clone-errata-0.9.0.py", line 807, in module main() File "./rhn-clone-errata-0.9.0.py", line 716, in main 0) File "./rhn-clone-errata-0.9.0.py", line 445, in searchNVREA return self.server.packages.findByNvrea(self.rhnSession,name,version,release,arch label) File "/usr/lib64/python2.6/xmlrpclib.py", line 1199, in __call__ return self.__send(self.__name, args) File "/usr/lib64/python2.6/xmlrpclib.py", line 1489, in __request verbose=self.__verbose File "/usr/lib64/python2.6/xmlrpclib.py", line 1253, in request return self._parse_response(h.getfile(), sock) File "/usr/lib64/python2.6/xmlrpclib.py", line 1392, in _parse_response return u.close() File "/usr/lib64/python2.6/xmlrpclib.py", line 838, in close
[Spacewalk-list] Fedora Errata
I've seem some mention in the list and elsewhere of people trying to import errata for Fedora. Does anyone have a known working script to do this already? Or can anyone confirm that the below scripts work with the fedora package-announce lists? http://www.bioss.ac.uk/staff/davidn/spacewalk-stuff/ Karl ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] kickstart profiles resetting to 3GB disk, and vibr0
On Thu, Jan 12, 2012 at 7:41 AM, Tomas Lestach tlest...@redhat.com wrote: On Wednesday 28 of December 2011 19:43:31 Ian Forde wrote: First of all, thanks for Spacewalk 1.6. Lots-o-bugs fixed, including the can't kickstart if you have the Provisioning entitlement bug. I've got a strange one. Periodically, all of my kickstart profiles revert to 3GB disk and Virtual Bridge vibr0. All of them. Very weird. The number of virtual CPUs may also reset, but I'm not sure as I don't currently have any multi-CPU profiles. Could you describe, you you exactly do and after what time the change happens? Do you write about kvm guest kickstart profiles? How can I reproduce it? I didn't do anything - that's the strange thing. At some point, they simply... revert. I'm not sure how to reproduce the issue. Is there anywhere where the vibr0 is set as a default that I can change? ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] Subscription Management with Postgres in SW 1.6
Has anyone successfully used Overview/Subscription Management/System Entitlements successfully in 1.6? I'm trying to remove all of the monitoring entitlements from my boxes, so I enabled Monitoring, restarted Spacewalk, went to the aforementioned page, selected the boxes, clicked on Remove Entitlement, and got an Internal Server Error page. In the emailed traceback, I saw the following: Exception: javax.servlet.ServletException: ERROR: function rhn_install_org_satellites(bigint, bigint, bigint) does not exist at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) of course, there was much more output, but I think this one is the crux of it... -I ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list