[Spacewalk-list] Problem to resign certificate

2012-01-12 Thread Nilton Moura
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

2012-01-12 Thread Speagle, Andy
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

2012-01-12 Thread RBogle
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

2012-01-12 Thread Eric Lake
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

2012-01-12 Thread Nilton Moura
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

2012-01-12 Thread Wojtak, Greg (Superfly)
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

2012-01-12 Thread John McCoy

  
  
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

2012-01-12 Thread Grindley, Karl - 0663 - MITLL

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

2012-01-12 Thread Ian Forde
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

2012-01-12 Thread Ian Forde
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