Re: [Spacewalk-list] how to pull errata for rhel 7

[Boyd, Robert]

Vyas,

My name is Robert, and I'm the original poster of the archived message I 
referred to.

Before changing to use the cdn.redhat.com link you will want to read the 
archive message I mentioned.  There are several steps that you must perform 
that are spelled out there.  Simply switching to the URL I listed is only 1 of 
those steps.

Here's the archive link again:  
https://www.redhat.com/archives/spacewalk-list/2015-December/msg00100.html

Read that, follow the steps and see how it goes then.


Robert


From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Devaguddi, Vyas
Sent: Thursday, March 23, 2017 3:53 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] how to pull errata for rhel 7

Nick

When I have updated the url and I am getting this errors

[root@nblnxyum001t ~]# sh /usr/local/bin/spacewalk_reposync
==
| Channel: rhel7-x86_64
==
()
Repo URL: 
https://cdn.redhat.com/content/dist/rhel/server/7/7Server/x86_64/extras/os
Repo rhel-7-server-rpms forced skip_if_unavailable=True due to: 
/etc/pki/entitlement/6323587780140822793.pem
Repo rhel-7-server-rpms forced skip_if_unavailable=True due to: 
/etc/pki/entitlement/6323587780140822793-key.pem
ERROR: failure: repodata/repomd.xml from rhel7-x86_64: [Errno 256] No more 
mirrors to try.
https://cdn.redhat.com/content/dist/rhel/server/7/7Server/x86_64/extras/os/repodata/repomd.xml:
 [Errno 14] curl#58 - "unable to load client key: -8178 (SEC_ERROR_BAD_KEY)"
Sync completed.
Total time: 0:00:00

Vyas devaguddi
UNIX Systems
45745 Nokes Blvd. Suite 110
Dulles, VA 20166
Phone : 703-889-2040
Cell: 313-657-8930

From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Thursday, March 23, 2017 2:33 PM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: Re: [Spacewalk-list] how to pull errata for rhel 7

Vyas,

Spacewalk will automatically pull errata If you link your channel repository 
directly to 
https://cdn.redhat.com/content/dist/rhel/server/7/7Server/x86_64/optional/os

Have you looked at this message I posted a while back? Check out 
https://www.redhat.com/archives/spacewalk-list/2015-December/msg00100.html

It's an explanation of how to get a direct feed of the RHEL channels so that 
you don't have to pull errata through a separate process.

Robert


Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com<mailto:robert.b...@peoplefluent.com>

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]<http://www.peoplefluent.com/>
Click here<http://www.peoplefluent.com/> to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com<http://www.peoplefluent.com/> | Read: PeopleFluent 
Blog<http://peoplefluent.com/resources/peoplefluent-blog> | Follow: 
@PeopleFluent<http://twitter.com/peoplefluent>

From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Devaguddi, Vyas
Sent: Thursday, March 23, 2017 10:56 AM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: Re: [Spacewalk-list] how to pull errata for rhel 7

Hi Nick
Here is the procedure how I am pulling errata for rhel 7
[root@nblnxyum001t spacewalk_scripts-master]# ./ya-errata-import.pl --server 
127.0.0.1 --channel rhel7-x86_64 --os-version 7 --publish --redhat 
--redhat-channel=rhel-x86_64-server-7 -startfromprevious twoweeks-quiet
INFO: Architecture is not specified, will try to determine it based on the 
channel properties of 'rhel7-x86_64'
INFO: Setting the OS variant to Redhat, if this is wrong please remove the 
--redhat option
INFO: Server 127.0.0.1 is running API version 17
INFO: Your API version is supported
Please enter username: admin
Please enter password:
INFO: Authentication on 127.0.0.1 successful
Please enter RHN username: vyasdevaguddi
Please enter RHN password:
INFO: Authentication on rhn.redhat.com successful
INFO: User has administrator access to this server
INFO: Checking if channel rhel7-x86_64 exists on 127.0.0.1
INFO: Determining architecture for channel rhel7-x86_64
INFO: Detected architecture 'x86_64' for channel 'rhel7-x86_64'
INFO: Listing all packages in rhel7-x86_64
INFO: Listing all errata in rhel7-x86_64 on 127.0.0.1
INFO: Loading errata from rhn.redhat.com
INFO: Getting erratas from date  till now
WARNING: channel.software.listErrata returned an error: Fault returned from XML 
RPC Server, fault code -210: No such channel

INFO: No errata found, nothing will happen

Vyas devaguddi
UNIX Systems
45745 Nokes Blvd. Suite 110
Dulles, VA 20166
Phone : 703-889-2040
Cell: 313-657-8930

From: 
spacewalk-list-boun...@redhat.com<mailto:spac

Re: [Spacewalk-list] how to pull errata for rhel 7

[Boyd, Robert]

Vyas,

How are you linked to the RHEL7 distribution channels?   Are you using cdn or 
the old rhn?

Robert

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]
Click here to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com | Read: PeopleFluent 
Blog | Follow: 
@PeopleFluent



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Devaguddi, Vyas
Sent: Wednesday, March 22, 2017 3:00 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] how to pull errata for rhel 7

When I try to pull errata fro rhel 7  I am unable to find the channel

Vyas devaguddi
UNIX Systems
45745 Nokes Blvd. Suite 110
Dulles, VA 20166
Phone : 703-889-2040
Cell: 313-657-8930
[cid:image001.jpg@01CEF67E.83632C70]

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

[Spacewalk-list] Upgrade to Spacewalk 2.6 and problem with mchange-commons.jar

[Boyd, Robert]

Tomcat6 is having a problem finding mchange-commons when it's starting up which 
causes the web / api interface to fail, causing other parts of spacewalk to 
fail to initialize.

How / where can I get the mchange-commons installed and linked properly so that 
tomcat will be able to start?

Thanks!

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]
Click here to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com | Read: PeopleFluent 
Blog | Follow: 
@PeopleFluent

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

Re: [Spacewalk-list] Trying to activate my cert

[Boyd, Robert]

There is no –rhn-cert option for that command.  Don’t specify it on that 
command.  Why are you trying to do this step anyway?  Did you do the normal 
install and startup?  This is normally done by the  spacewalk-setup.

Robert

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]
Click here to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.com | Read: PeopleFluent 
Blog | Follow: 
@PeopleFluent



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Eric Korth
Sent: Thursday, February 02, 2017 1:46 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Trying to activate my cert

Hello,
When issuing the below command. I get the following:

rhn-satellite-activate --disconnected 
--rhn-cert=/usr/share/spacewalk/setup/spacewalk-public.cert
Usage: rhn-satellite-activate [options]

rhn-satellite-activate: error: no such option: --rhn-cert

This is a brand new install.

Any ideas?

Thank you very much in advance!
Eric Korth
Sr. Systems Administrator
404-367-1992   direct
770-354-1450   mobile
eric.ko...@greenskycredit.com
www.greensky.com
[http://www.greenskycredit.com/images/gs-logo-new-tm-small.jpg]
This email contains information from GreenSky, LLC which may be confidential 
and privileged. The information is intended to be for the use of the 
individual(s) named above. If you are not the intended recipient, please be 
aware that any disclosure, copying, distribution or use of this email and its 
contents is prohibited. If you have received this email in error, please delete 
it and notify us by e-mail immediately.

LICENSES:NMLS #1416362; CT SLC-1416362; NJ MT #1501607 C22
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] spacewalk-setup upgrade PostgreSQL setup coding error!

[Boyd, Robert]

I modified the settings so that PG_DATA points to /var/lib/pgsql/9.3/data and I 
still get errors:

[root@rdcengsw01 config]# spacewalk-setup upgrade
* Setting up SELinux..
Choose your database backend (oracle, postgresql)? postgresql
** Database: Setting up database connection for PostgreSQL backend.
** Database: Installing the database:
** Database: This is a long process that is logged in:
** Database:   /var/log/rhn/install_db.log
*** Progress: ##
Could not install database.
[root@rdcengsw01 config]# less /var/log/rhn/install_db.log
/usr/bin/spacewalk-setup-postgresql: line 87: isSUSE: command not found
/usr/bin/spacewalk-setup-postgresql: line 100: isSUSE: command not found
error reading information on service postgresql: No such file or directory

How shall I go about fixing / debugging this ?

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Wednesday, February 01, 2017 6:22 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] spacewalk-setup upgrade PostgreSQL setup coding error!


This sender failed our fraud detection checks and may not be who they appear to 
be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing>

Feedback<http://aka.ms/SafetyTipsFeedback>

This code will only work for pre 9.x PostgreSQL:
>From /usr/bin/spacewalk-setup-postgresql
...

PG_DATA=/var/lib/pgsql/data
PG_HBA="$PG_DATA/pg_hba.conf"
PG_IDENT="$PG_DATA/pg_ident.conf"
POSTGRESQL="$PG_DATA/postgresql.conf"
POSTGRESQL_SW_APPEND=/usr/share/spacewalk/setup/postgresql.conf
PORT=5432
PG_PIDFILE="/var/run/postmaster.$PORT.pid"
if isSUSE ; then
PG_PIDFILE="$PG_DATA/postmaster.pid"

Can someone please fix this program to CHECK for the version of pgsql on the 
server and select the correct directory accordingly???
I'm going to just hard code it for now to get through my upgrade.


Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com<mailto:robert.b...@peoplefluent.com>

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]<http://www.peoplefluent.com/>
Click here<http://www.peoplefluent.com/> to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com<http://www.peoplefluent.com/> | Read: PeopleFluent 
Blog<http://peoplefluent.com/resources/peoplefluent-blog> | Follow: 
@PeopleFluent<http://twitter.com/peoplefluent>

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

[Spacewalk-list] spacewalk-setup upgrade PostgreSQL setup coding error!

[Boyd, Robert]

This code will only work for pre 9.x PostgreSQL:
>From /usr/bin/spacewalk-setup-postgresql
...

PG_DATA=/var/lib/pgsql/data
PG_HBA="$PG_DATA/pg_hba.conf"
PG_IDENT="$PG_DATA/pg_ident.conf"
POSTGRESQL="$PG_DATA/postgresql.conf"
POSTGRESQL_SW_APPEND=/usr/share/spacewalk/setup/postgresql.conf
PORT=5432
PG_PIDFILE="/var/run/postmaster.$PORT.pid"
if isSUSE ; then
PG_PIDFILE="$PG_DATA/postmaster.pid"

Can someone please fix this program to CHECK for the version of pgsql on the 
server and select the correct directory accordingly???
I'm going to just hard code it for now to get through my upgrade.


Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]
Click here to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com | Read: PeopleFluent 
Blog | Follow: 
@PeopleFluent

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

Re: [Spacewalk-list] System Updates Trigger SSL /Certificate issues with Spacewalk

[Boyd, Robert]

Something is affecting spacewalk-- it's broken.  Taskomatic doesnt start 
anymore and the web interface is down. 

Sent from my iPhone

> On Jan 31, 2017, at 21:16, Steve Meier <em...@steve-meier.de> wrote:
> 
> Hi Robert,
> 
> this message was probably there before and is unlikely to be caused
> by any upgrades inside the RHEL 6 tree.
> 
> Apache complains that the name in your SSL certificate does not match
> the servers own FQDN (output from "hostname" command). That's nothing
> unusual and will not impact your SSL sessions in any way.
> 
> Kind regards,
>  Steve
> 
> Am 2017-01-31 18:31, schrieb Boyd, Robert:
>> I'm running Spacewalk 2.2 (preparing to upgrade to 2.6) on a RHEL6
>> server.   I wanted to update packages on the server prior to the
>> update of the Spacewalk software.
>> After upgrading packages I'm seeing this erroring the httpd
>> ssl_error_log:
>> [Tue Jan 31 17:17:03 2017] [warn] RSA server certificate CommonName
>> (CN) `' does NOT match server name!?
>> Where would this name have been configured and why would an update to
>> various packages (such as openssl and related ones) trigger this
>> problem?
>> Thanks for any help on how to resolve this.
>> Should I re-run the configure script to force an update of the various
>> configuration files?  I have a number of things that I've tuned in
>> http/tomcat for performance reasons, so I'm not sure what approach to
>> take to clear up this problem.
> 
> ___
> 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] System Updates Trigger SSL /Certificate issues with Spacewalk

[Boyd, Robert]

I'm running Spacewalk 2.2 (preparing to upgrade to 2.6) on a RHEL6 server.   I 
wanted to update packages on the server prior to the update of the Spacewalk 
software.

After upgrading packages I'm seeing this erroring the httpd ssl_error_log:

[Tue Jan 31 17:17:03 2017] [warn] RSA server certificate CommonName (CN) 
`' does NOT match server name!?


Where would this name have been configured and why would an update to various 
packages (such as openssl and related ones) trigger this problem?

Thanks for any help on how to resolve this.

Should I re-run the configure script to force an update of the various 
configuration files?  I have a number of things that I've tuned in http/tomcat 
for performance reasons, so I'm not sure what approach to take to clear up this 
problem.



Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]
Click here to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com | Read: PeopleFluent 
Blog | Follow: 
@PeopleFluent

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

[Spacewalk-list] Spacewalk 2.2 Proxy Server Failure after Disk Filled

[Boyd, Robert]

I had the disk of one of my proxy servers fill up recently.   I cleared the 
space and tried restarting everything/rebooting.  The proxy server will perform 
yum commands for itself just fine.   Any of the registered clients attempting 
to do anything yields errors like this at the client end:

yum check-update
Loaded plugins: rhnplugin, security
There was an error communicating with RHN.
Red Hat Satellite or RHN Classic support will be disabled.
Error communicating with server. The message was:
Internal Server Error

I tried re-initializing the proxy server with the proxy configure process, but 
that didn't fix the problem either.  I'm trying to figure out what has gotten 
hosed on this proxy so that I can get things working right again with the least 
amount of effort.   If necessary I'll resort to reinstalling from scratch but 
that seems like way more than should be necessary to sort this out.

Would one of you more familiar with the inner workings of the proxy server be 
able to look at this and come up with some idea of what might be broken and 
what to do to fix it?

Thanks!!

Robert

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]
Click here to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com | Read: PeopleFluent 
Blog | Follow: 
@PeopleFluent



The proxy server is sending me email notifications like the following:

Exception reported from spacewalk2-proxy.local.net
Time: Wed Aug 17 02:15:57 2016
Exception type  Exception while handling function 
handler Request object information:
URI: /XMLRPC
Remote Host: 192.169.15.120
Server Name: spacewalk2-proxy.local.net:80
Headers passed in:
Accept-Encoding: identity
CONTENT_LENGTH: 2215
CONTENT_TYPE: text/xml
DOCUMENT_ROOT: /var/www/html
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT_ENCODING: identity
HTTP_HOST: spacewalk2-proxy.local.net
HTTP_USER_AGENT: rhn.rpclib.py/2.5.72-1.el5
HTTP_X_CLIENT_VERSION: 1
HTTP_X_INFO: RPC Processor (C) Red Hat, Inc (version 
2.5.72-1.el5)
HTTP_X_RHN_CLIENT_CAPABILITY: 
caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1
HTTP_X_RHN_TRANSPORT_CAPABILITY: follow-redirects=3
HTTP_X_TRANSPORT_INFO: Extended Capabilities Transport (C) Red 
Hat, Inc (version 2.5.72-1.el5)
HTTP_X_UP2DATE_VERSION: 2.2.7-1.el5
Host: spacewalk2-proxy.local.net
PATH_INFO:
QUERY_STRING:
REMOTE_ADDR: 192.169.15.120
REMOTE_PORT: 37938
REQUEST_METHOD: POST
REQUEST_URI: /XMLRPC
SCRIPT_FILENAME: /usr/share/rhn/wsgi/xmlrpc.py
SCRIPT_NAME: /XMLRPC
SCRIPT_URI: http://spacewalk2-proxy.local.net/XMLRPC
SCRIPT_URL: /XMLRPC
SERVER_ADDR: 192.168.15.67
SERVER_ADMIN: root@localhost
SERVER_NAME: spacewalk2-proxy.local.net
SERVER_PORT: 80
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: Apache/2.2.15 (Red Hat) Server at 
spacewalk2-proxy.local.net Port 80

SERVER_SOFTWARE: Apache/2.2.15 (Red Hat)
User-Agent: rhn.rpclib.py/2.5.72-1.el5
X-Client-Version: 1
X-Info: RPC Processor (C) Red Hat, Inc (version 2.5.72-1.el5)
X-RHN-Client-Capability: 
caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1
X-RHN-Transport-Capability: follow-redirects=3
X-Transport-Info: Extended Capabilities Transport (C) Red Hat, 
Inc (version 2.5.72-1.el5)
X-Up2Date-Version: 2.2.7-1.el5
mod_ssl.is_https: 
mod_ssl.var_lookup: 
mod_wsgi.application_group: spacewalk2-proxy.local.net|/xmlrpc
mod_wsgi.callable_object: application
mod_wsgi.handler_script:
mod_wsgi.input_chunked: 

Re: [Spacewalk-list] ? Failures Cloning Channels with spacewalk-manage-channel-lifecycle

[Boyd, Robert]

I'm happy to report that after waiting a few days and letting the monthly 
cleanup /tuning jobs run on my spacewalk master server, the cloning process is 
working for all of the channels that were failing.

I suspect that a previous monthly job didn't complete properly due to running 
out of memory and left something problematic behind somewhere.  

I managed to clone 3 channel groups this morning without a hiccough much to my 
relief.   Just in time for the beginning of our patch cycle this quarter.


Robert Boyd
Sr. Systems Engineer 
PeopleFluent
e. robert.b...@peoplefluent.com


Click here to experience the power of the new PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.com | Read: PeopleFluent Blog | Follow: @PeopleFluent



-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Friday, January 29, 2016 2:45 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] ? Failures Cloning Channels with 
spacewalk-manage-channel-lifecycle

Here's some additional info about one of the failure modes I'm seeing.  I kept 
cranking up the memory limits until I now have the limits at default =4192 
max=16388.   Some channels are handled ok by this tool now.   

Others fail pretty quickly while clearing the first target channel.



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

Re: [Spacewalk-list] ? Failures Cloning Channels with spacewalk-manage-channel-lifecycle

[Boyd, Robert]

Thanks Avi,

I tried what you suggested and got some minor improvement -- the tool runs 
longer before things blow up.   I tried increasing the memory limits even more 
-- but that doesn't seem to make any difference.   It's still eventually 
blowing up the same way, and the logs you suggested looking at don't show 
anything interesting around the time of the failures.

Any other suggestions?   I could keep increasing the memory limits even 
farther, but I'm not sure that's a good idea.

Thanks,
Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Avi Miller
Sent: Thursday, January 28, 2016 6:12 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] ? Failures Cloning Channels with 
spacewalk-manage-channel-lifecycle

Hey,

> On 29 Jan 2016, at 9:56 AM, Boyd, Robert <robert.b...@peoplefluent.com> wrote:
> 
> I have tried poking at log files, but I haven’t found where there seems to be 
> an indication of a problem.   Can someone point me to a prioritized list of 
> logs I should be looking at to find the nature of what’s dying on the back 
> end?  I suspect there is a java resource failure or some other error and 
> would like to track it down and fix it rather than resort to manual/scripted 
> channel by channel cloning( which might fail in the same way).

You may want to increase the memory available to Tomcat and Taskomatic: 

http://docs.oracle.com/cd/E37670_01/E58680/html/sw22-issues-memory.html

This feels like a Tomcat issue to me, the logs are in /var/log/tomcat6 on the 
Spacewalk server. The Taskomatic logs are in 
/var/log/rhn/rhn_taskomatic_daemon.log

Cheers,
Avi

--
Oracle <http://www.oracle.com>
Avi Miller | Product Management Director | +61 (3) 8616 3496 Oracle Linux and 
Virtualization
417 St Kilda Road, Melbourne, Victoria 3004 Australia


___
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

Re: [Spacewalk-list] ? Failures Cloning Channels with spacewalk-manage-channel-lifecycle

[Boyd, Robert]

Here's some additional info about one of the failure modes I'm seeing.  I kept 
cranking up the memory limits until I now have the limits at default =4192 
max=16388.   Some channels are handled ok by this tool now.   

Others fail pretty quickly while clearing the first target channel.

One thing I see that concerns me are processes I see running Java that don't 
have the increased memory allocations.   Like this one:

root  3595  3349  6 14:32 ?00:00:13 
/usr/bin/java -Dibm.dst.compatibility=true -Xms1024m -Xmx4096m 
-Djava.library.path=/usr/lib:/usr/lib64:/usr/lib/oracle/11.2/client64/lib:/usr/lib/oracle/11.2/client/lib
 
-classpath 
/usr/share/java/tanukiwrapper.jar:/usr/share/rhn/classes:/usr/share/java/struts.jar:/usr/share/java/jfreechart.jar:/usr/share/java/jpam.jar:/usr/share/java/javamail.jar:/usr/share/java/axis/axis-ant.jar:/usr/share/java/quartz.jar:/usr/share/java/commons-codec.jar:/usr/share/java/commons-beanutils.jar:/usr/share/java/ojdbc14.jar:/usr/share/java/jta.jar:/usr/share/java/concurrent.jar:/usr/share/rhn/lib/spacewalk-asm.jar:/usr/share/java/axis/jaxrpc.jar:/usr/share/java/commons-collections.jar:/usr/share/java/taglibs-standard.jar:/usr/share/java/axis/axis.jar:/usr/share/java/xalan-j2.jar:/usr/share/java/commons-validator.jar:/usr/share/java/asm/asm-attrs.jar:/usr/share/java/jaf.jar:/usr/share/java/jdom.jar:/usr/share/java/oro.jar:/usr/share/rhn/lib/rhn.jar:/usr/share/java/redstone-xmlrpc.jar:/usr/share/java/oscache.jar:/usr/share/java/log4j.jar:/usr/share/java/wsdl4j.jar:/usr/share/java/jcommon.jar:/usr/share/java/commons-el.jar:/usr/share/java/taglibs-core.jar:/usr/share/java/commons-lang.jar:/usr/share/java/commons-digester.jar:/usr/share/java/jasper5-runtime.jar:/usr/share/java/jspapi.jar:/usr/share/java/c3p0.jar:/usr/share/java/sitemesh.jar:/usr/share/java/jasper5-compiler.jar:/usr/share/java/axis/saaj.jar:/usr/share/java/commons-logging.jar:/usr/share/java/commons-discovery.jar:/usr/share/java/xml-commons-apis.jar:/usr/share/java/axis/jaxrpc.jar:/usr/share/java/commons-cli.jar:/usr/share/java/bcel.jar:/usr/share/java/antlr.jar:/usr/share/java/xerces-j2.jar:/usr/share/java/hibernate3.jar:/usr/share/java/cglib.jar:/usr/share/java/dom4j.jar:/usr/share/rhn/lib/java-branding.jar:/usr/share/java/slf4j/api.jar:/usr/share/java/slf4j/jcl.jar:/usr/share/java/simple-core.jar:/usr/share/java/commons-dbcp.jar:/usr/share/java/commons-pool.jar:/usr/share/java/quartz-oracle.jar:/usr/share/java/postgresql-jdbc.jar:/usr/share/java/mchange-commons.jar:/usr/share/java/commons-io.jar
 
-Dwrapper.key=Ny4YUY7QmPOi432B 
-Dwrapper.port=32001 
-Dwrapper.jvm.port.min=31000 
-Dwrapper.jvm.port.max=31999 
-Dwrapper.pid=3349 -Dwrapper.version=3.2.3 
-Dwrapper.native_library=wrapper 
-Dwrapper.service=TRUE 
-Dwrapper.cpu.timeout=10 
-Dwrapper.jvmid=3
com.redhat.rhn.taskomatic.core.TaskomaticDaemon

What is the configuration file that controls the memory allocation for this 
process?

I already modified /usr/share/rhn/config-defaults/rhn_taskomatic_daemon.conf:

# Initial Java Heap Size (in MB)
wrapper.java.initmemory=4196

# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=16388

If the process I show is supposed to be controlled by this file, the memory 
allocation specified is being ignored, or applied in some way that doesn't 
match with the process shown.


: spacewalk-list-boun...@redhat.com [mailto:spacewalk-list-boun...@redhat.com] 
On Behalf Of Boyd, Robert
Sent: Friday, January 29, 2016 12:27 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] ? Failures Cloning Channels with 
spacewalk-manage-channel-lifecycle

Thanks Avi,

I tried what you suggested and got some minor improvement -- the tool runs 
longer before things blow up.   I tried increasing the memory limits even more 
-- but that doesn't seem to make any difference.   It's still eventually 
blowing up the same way, and the logs you suggested looking at don't show 
anything interesting around the time of the failures.

Any other suggestions?   I could keep increasing the memory limits even 
farther, but I'm not sure that's a good idea.

Thanks,
Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Avi Miller
Sent: Thursday, January 28, 2016 6:12 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] ? Failures Cloning Channels with 
spacewalk-manage-channel-lifecycle

Hey,

> On 29 Jan 2016, at 9:56 AM, Boyd, Robert <robert.b...@peoplefluent.com> wrote:
> 
> I have tried poking at log files, but I haven’t found where there seems to be 
> an indication of a problem.   Can someone point me to a prioritized list of 
> logs I should be looking at to find the nature of what’s dying on the back 
> end?  I suspect there is a java resource failure or some other error and 
> would like to track it down and fix it rather than resort to manual/scripted 
> channel by channel cloning( which might fail i

[Spacewalk-list] ? Failures Cloning Channels with spacewalk-manage-channel-lifecycle

[Boyd, Robert]

I've been using the spacewalk-manage-channel-lifecycle tool for a while.   
Lately I'm having a problem where the back end of spacewalk is failing and 
causing the tool to blow up with this error:

spacewalk-manage-channel-lifecycle -c oraclelinux6-x86_64 --promote 
--workflow=oracle --clear-channel ; date
Thu Jan 28 17:33:58 EST 2016
INFO: Parent Source: oraclelinux6-x86_64, destination: 
ora-preprod-oraclelinux6-x86_64
INFO: Clearing all errata from ora-preprod-oraclelinux6-x86_64
Traceback (most recent call last):
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 784, in 

merge_channels(parent_source, parent_dest)
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 420, in 
merge_channels
clear_channel(dest_label)
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 500, in 
clear_channel
False)
  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 1243, in request
Headers
xmlrpclib.ProtocolError: 

I have tried poking at log files, but I haven't found where there seems to be 
an indication of a problem.   Can someone point me to a prioritized list of 
logs I should be looking at to find the nature of what's dying on the back end? 
 I suspect there is a java resource failure or some other error and would like 
to track it down and fix it rather than resort to manual/scripted channel by 
channel cloning( which might fail in the same way).


Thanks,


Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]
Click here to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com | Read: PeopleFluent 
Blog | Follow: 
@PeopleFluent


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

Re: [Spacewalk-list] Spacewalk and RHEL client support

[Boyd, Robert]

Since I've seen no negative comments back on this thread, I'm going to post 
here the outline of the process as it has worked for me.  There may be other 
ways to get the required keys by way of the Red Hat Portal.   The ways that 
previously worked for me seem to no longer work the same, so I'm not going to 
refer to how I originally got them.

If you try following the steps I describe here and find something unclear or 
run into difficulties, please let me know and I can try to help.  It would be 
nice to have this nailed down in a simple step by step procedure that anyone 
who has gotten through installing spacewalk will be able to do.

If you're running spacewalk 2.2 or later this is pretty easy.  If you have a 
RHEL6 or RHEL7 server registered to RHN for updates, almost everything you need 
is in or pointed to by /etc/yum.repos.d/redhat.repo.

For the Red Hat repositories that you want to import to spacewalk find all of 
the relevant baseurls in redhat.repo.   You'll set up a single repository for 
each one that you want to sync with. There are different ways to associate them 
with channels.  I won't talk about that part of the process here.  You'll have 
to substitute the appropriate variable things with fixed strings such as in 
this example:

baseurl = 
https://cdn.redhat.com/content/dist/rhel/server/6/6Server/$basearch/extras/os

You'll use that string, but substitute x86_64 for $basearch.  Notice that in 
6Server the S must be capitalized.

In that file you'll also see references to sslcacert, sslclientkey, and 
sslclientcert.   These are the file names for the keys that you will need to 
put into spacewalk and associate with the repositories so that repo-sync will 
be able to download them.

In the spacewalk GUI Access to update keys:
Navigate to: Systems --> Kickstart --> GPG and SSL Keys 

For Red Hat you will need to enter the CA SSL Key, the Customer Entitlement SSL 
Key and the 
SSL Client Key.  In the redhat.repo file you'll see something like this:

sslcacert = /etc/rhsm/ca/redhat-uep.pem 
  (the RHEL CA Signing SSL certificate)
sslclientkey = /etc/pki/entitlement/-key.pem   (RHEL 
Client Key SSL certificate)
sslclientcert = /etc/pki/entitlement/.pem
(RHEL Entitlement/Client certificate)

The contents of the sslclientcert file is the key you want to register in 
spacewalk as the Red Hat Entitlement Key.   I created my keys with these names:

RHEL CA Signing Certificate, RHEL Client Key, and RHEL Entitlement.  For each 
key you create a key, put in the description, select type SSL and paste the 
contents of the appropriate file into the Key contents field.   Or if you're 
running the browser on the spacewalk server, you can browse to the file 
directly and upload from it.

Note:  annual contract renewal will probably require updating the RHEL 
Entitlement key, capture the contents of the associated file from the spacewalk 
master server, select all in the Key Update page, paste in the new key 
contents, click Update Key

When creating your repositories in spacewalk you'll use the appropriate URL, 
for SSL CA Certificate you use the RHEL CA Signing certificate, for SSL Client 
Certificate you use the RHEL Entitlement certificate, and for SSL Client Key 
you use RHEL Client Key.

For creating the channel for RHEL 5 and later for the GPG Key URL use 
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release.   For GPG Key ID: FD431D51, 
and GPG key fingerprint:  567E 347A D004 4ADE 55BA 8A5F 199E 2F91 FD43 1D51

Then once you have the repository associated with a channel, trigger the sync 
and be sure to set a schedule for pulling your updates.   Some of them I do 
nightly, some weekly and some monthly depending on which repository it is.

To watch the log of activity on the spacewalk server as root:  (e.g.) tail -f 
/var/log/rhn/reposync/rhel-x86_64-server-6.log

Please see if this is enough to get you going.  Please let me know if anything 
I've given you needs revision or isn't clear enough.

And let me know if/how it works for you.

Best of luck,

Robert Boyd

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Schindler, Daniel 
(STEAG Energy Services GmbH)
Sent: Monday, December 21, 2015 2:05 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk and RHEL client support

Yes please Robert :)

I'm also really interested.

Regards,
Daniel



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

Re: [Spacewalk-list] Need yum repository URLs for RHEL6 in spacewalk

[Boyd, Robert]

There is a more direct way to do this.  Please see my post from 3 weeks ago 
under the subject “Spacewalk and RHEL Client Support”


From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Morten Middelthon
Sent: Tuesday, January 12, 2016 1:35 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Need yum repository URLs for RHEL6 in spacewalk


You need to mirror the repos using fex reposync from the yum-utils package 
first, then create a local repo with createrepo or createrepo_c. Then you need 
to setup apache httpd or nginx to serve that repo and use that url for 
spacewalk. There should be several scripts and howtos available online for this 
already

With regards,
Morten
On 12 Jan 2016 07:14, "Shinde, Balaji" 
> wrote:
Hello All,

I have setup a 2.4 spacewalk server in our AWS infrastrucutre, but not sure 
which repository URLs should I use from where spacewalk server would download 
the contents.

I tried couple of below Red Hat 6 URLs but they don’t work.

https://rhui2-cds01.REGION.aws.ce.redhat.com/pulp/mirror/content/dist/rhel/rhui/server/6/$releasever/$basearch/os


Can anybody suggests the URLs please?



Balaji Shinde / Capgemini / India
AppsTwo Shared Services -  iSupport
Desk: +91-22-6686 0500 -2246410/ Mobile: +91 9820215514
VOIP: +: +1 312-799-  ext- 2246410 
www.capgemini.com
People matter, results count.


___
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

Re: [Spacewalk-list] Spacewalk and RHEL client support

[Boyd, Robert]

Since I've seen no negative comments back on this thread, I'm going to post 
here the outline of the process as it has worked for me.  There may be other 
ways to get the required keys by way of the Red Hat Portal.   The ways that 
previously worked for me seem to no longer work the same, so I'm not going to 
refer to how I originally got them.

If you try following the steps I describe here and find something unclear or 
run into difficulties, please let me know and I can try to help.  It would be 
nice to have this nailed down in a simple step by step procedure that anyone 
who has gotten through installing spacewalk will be able to do.

If you're running spacewalk 2.2 or later this is pretty easy.  If you have a 
RHEL6 or RHEL7 server registered to RHN for updates, almost everything you need 
is in or pointed to by /etc/yum.repos.d/redhat.repo.

For the Red Hat repositories that you want to import to spacewalk find all of 
the relevant baseurls in redhat.repo.   You'll set up a single repository for 
each one that you want to sync with. There are different ways to associate them 
with channels.  I won't talk about that part of the process here.  You'll have 
to substitute the appropriate variable things with fixed strings such as in 
this example:

baseurl = 
https://cdn.redhat.com/content/dist/rhel/server/6/6Server/$basearch/extras/os

You'll use that string, but substitute x86_64 for $basearch.  Notice that in 
6Server the S must be capitalized.

In that file you'll also see references to sslcacert, sslclientkey, and 
sslclientcert.   These are the file names for the keys that you will need to 
put into spacewalk and associate with the repositories so that repo-sync will 
be able to download them.

In the spacewalk GUI Access to update keys:
Navigate to: Systems --> Kickstart --> GPG and SSL Keys 

For Red Hat you will need to enter the CA SSL Key, the Customer Entitlement SSL 
Key and the 
SSL Client Key.  In the redhat.repo file you'll see something like this:

sslcacert = /etc/rhsm/ca/redhat-uep.pem 
  (the RHEL CA Signing SSL certificate)
sslclientkey = /etc/pki/entitlement/-key.pem   (RHEL 
Client Key SSL certificate)
sslclientcert = /etc/pki/entitlement/.pem
(RHEL Entitlement/Client certificate)

The contents of the sslclientcert file is the key you want to register in 
spacewalk as the Red Hat Entitlement Key.   I created my keys with these names:

RHEL CA Signing Certificate, RHEL Client Key, and RHEL Entitlement.  For each 
key you create a key, put in the description, select type SSL and paste the 
contents of the appropriate file into the Key contents field.   Or if you're 
running the browser on the spacewalk server, you can browse to the file 
directly and upload from it.

Note:  annual contract renewal will probably require updating the RHEL 
Entitlement key, capture the contents of the associated file from the spacewalk 
master server, select all in the Key Update page, paste in the new key 
contents, click Update Key

When creating your repositories in spacewalk you'll use the appropriate URL, 
for SSL CA Certificate you use the RHEL CA Signing certificate, for SSL Client 
Certificate you use the RHEL Entitlement certificate, and for SSL Client Key 
you use RHEL Client Key.

For creating the channel for RHEL 5 and later for the GPG Key URL use 
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release.   For GPG Key ID: FD431D51, 
and GPG key fingerprint:  567E 347A D004 4ADE 55BA 8A5F 199E 2F91 FD43 1D51

Then once you have the repository associated with a channel, trigger the sync 
and be sure to set a schedule for pulling your updates.   Some of them I do 
nightly, some weekly and some monthly depending on which repository it is.

To watch the log of activity on the spacewalk server as root:  (e.g.) tail -f 
/var/log/rhn/reposync/rhel-x86_64-server-6.log

Please see if this is enough to get you going.  Please let me know if anything 
I've given you needs revision or isn't clear enough.

And let me know if/how it works for you.

Best of luck,

Robert Boyd

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Schindler, Daniel 
(STEAG Energy Services GmbH)
Sent: Monday, December 21, 2015 2:05 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk and RHEL client support

Yes please Robert :)

I'm also really interested.

Regards,
Daniel



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

Re: [Spacewalk-list] Spacewalk and RHEL client support

[Boyd, Robert]

I’ve had the impression from the past that the people on the list who work for 
Red Hat were not free to discuss it directly.  I also had the impression that 
there was some kind of preference to not have it out in the open on the list.

Since I’m not an employee of Red Hat, I don’t have the first concern.   I’m not 
sure what the position of the list owner(s) is on the topic.

If others think it would be okay for us to discuss this openly, I’ll be happy 
to post the steps involved in setting up feeds from the cdn.redhat.com 
distributions.   In order to use them you have to already have a valid 
subscription.   So it won’t involve anything other than using things you’re 
already licensed for.

Would those who manage our list please provide some feedback as to what they 
think of me posting the exact steps to follow? It’s pretty straightforward when 
you know what to do.   From personal experience, it’s not so straightforward 
figuring it out the first time, even with coaching.

Robert

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Philipp Wehling
Sent: Friday, December 18, 2015 2:21 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk and RHEL client support

Hello,

why do you want to discuss these things off-list?

It is also important/good to know for me and others, I think.


kind regards,
Philipp


From: "Robert Boyd" 
<robert.b...@peoplefluent.com<mailto:robert.b...@peoplefluent.com>>
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Sent: Thursday, December 17, 2015 10:14:27 PM
Subject: Re: [Spacewalk-list] Spacewalk and RHEL client support

There is a better way in the more recent releases of Spacewalk.   You can cut 
out the mrepo middleman and the wasted storage/cpu time.   I'll be glad to 
discuss the details off-list.  If you have at least one system that is 
registered directly to Red Hat Network it is possible to get all the pieces you 
need to set things up fairly easily.Send me a direct email and I'll outline 
what you need to do.

Robert Boyd
robert.b...@peoplefluent.com<mailto:robert.b...@peoplefluent.com>


-Original Message-
From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Funk, Alex
Sent: Thursday, December 17, 2015 11:37 AM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: Re: [Spacewalk-list] Spacewalk and RHEL client support

Robert is correct, it certainly is possible.  I do it for my RHEL 5 systems 
from a CentOS 6 SW server.  I use mrepo to clone the RHN channels, but if 
there's a better option I'm all ears.

Thanks,
Alex

-Original Message-
From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Monday, December 14, 2015 2:29 PM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: Re: [Spacewalk-list] Spacewalk and RHEL client support

Georg,

The answer is yes -- you'll have to set up feeds for the RHEL channels.   If 
you like I can coach you through the process off list.

Send me a direct email at 
robert.b...@peoplefluent.com<mailto:robert.b...@peoplefluent.com>

Robert

-Original Message-
From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Georg Weiss
Sent: Wednesday, December 09, 2015 8:03 AM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: [Spacewalk-list] Spacewalk and RHEL client support

Hi List

I have a spacewalk 2.4 server running on CentOS 7.2 which i like to add RHEL 
servers (version 5,6).

The RHEL systems are currently added to the "Red Hat Subscription Management" 
as individual systems.

I searched webpage and mailing list for information on how to achieve that but 
i am missing clear information here.

Is it technically possible to have spacewalk running on centos support rhel 
clients?
If yes, how is the process to add channels and clients?

Thanks for any help



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

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

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

___
Spacewalk-list mailing list
Spacewalk-

Re: [Spacewalk-list] Spacewalk and RHEL client support

[Boyd, Robert]

There is a better way in the more recent releases of Spacewalk.   You can cut 
out the mrepo middleman and the wasted storage/cpu time.   I'll be glad to 
discuss the details off-list.  If you have at least one system that is 
registered directly to Red Hat Network it is possible to get all the pieces you 
need to set things up fairly easily.Send me a direct email and I'll outline 
what you need to do.

Robert Boyd
robert.b...@peoplefluent.com


-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Funk, Alex
Sent: Thursday, December 17, 2015 11:37 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk and RHEL client support

Robert is correct, it certainly is possible.  I do it for my RHEL 5 systems 
from a CentOS 6 SW server.  I use mrepo to clone the RHN channels, but if 
there's a better option I'm all ears.

Thanks,
Alex

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Monday, December 14, 2015 2:29 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk and RHEL client support

Georg,

The answer is yes -- you'll have to set up feeds for the RHEL channels.   If 
you like I can coach you through the process off list.

Send me a direct email at robert.b...@peoplefluent.com

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Georg Weiss
Sent: Wednesday, December 09, 2015 8:03 AM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Spacewalk and RHEL client support

Hi List

I have a spacewalk 2.4 server running on CentOS 7.2 which i like to add RHEL 
servers (version 5,6).

The RHEL systems are currently added to the "Red Hat Subscription Management" 
as individual systems.

I searched webpage and mailing list for information on how to achieve that but 
i am missing clear information here.

Is it technically possible to have spacewalk running on centos support rhel 
clients?
If yes, how is the process to add channels and clients?

Thanks for any help



___
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 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

Re: [Spacewalk-list] repository certificate update issue

[Boyd, Robert]

Here is what I was trying so hard to re-discover where it lives in spacewalk.  
If there's some clear documentation on this on the web it's not being indexed 
to where it's easy to find with web search engines.

When you need to apply and/or update CA/Entitlement/Client SSL keys:

Navigate this path in the GUI (Spacewalk 2.x)
Systems --> Kickstart --> GPG and SSL Keys

select the key you need to update (annual contract renewal will probably 
require updating the Entitlement key of the provider you're using), capture the 
contents of the associated file from the spacewalk master server, select all in 
the Key Update page, paste in the new key contents, click Update Key

Then on the Web UI navigate to Channels --> Manage Software Channels --> 
Select the "Repositories" tab. Select sub-tab "Sync", then click the "Sync Now" 
button.

To watch the log of activity log in/sudo as root on the spacewalk master server 
and enter

tail -f /var/log/rhn/reposync/.log

If you're subscribed to Red Hat and want to know where to find the key(s) you 
need, please send me a direct email and I'll tell you which directories to look 
in for each of the keys.

Robert Boyd

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com<mailto:robert.b...@peoplefluent.com>

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]<http://www.peoplefluent.com/>
Click here<http://www.peoplefluent.com/> to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com<http://www.peoplefluent.com/> | Read: PeopleFluent 
Blog<http://peoplefluent.com/resources/peoplefluent-blog> | Follow: 
@PeopleFluent<http://twitter.com/peoplefluent>




From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Tuesday, December 08, 2015 4:35 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] RedHat repository certificate issue

I discovered a partial answer to my question:

spacewalk-report repositories

will dump out all of the certificates registered to Spacewalk.

Now I'm investigating what's different between the old and the current CA 
certificates.



From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Tuesday, December 08, 2015 3:53 PM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: [Spacewalk-list] RedHat repository certificate issue


I'm having a problem with repo-sync which we've narrowed down with 
tcpdump/wireshark to see that my spacewalk server is rejecting the SSL CA cert 
from the remote end(at Red Hat) because it is failing to verify as having a 
valid signing authority.   I'm assuming that I need to re-load the certificate 
into spacewalk, but I'd like to compare the certificate that cdn.redhat.com is 
sending now to the one that I previously loaded in spacewalk.   Is this 
possible?

I'm currently running spacewalk 2.2 on RHEL6

How can I list the certificates I have loaded in spacewalk already?  On the 
repository details page I can see the names I assigned to them in the drop down 
lists for ssl ca cert and so forth.   Is there somewhere in the GUI that I can 
examine these names and the files/keys they are associated with?  Or is there 
some way with the command line tools to do that?

Thanks,

Robert Boyd

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

[Spacewalk-list] RedHat repository certificate issue

[Boyd, Robert]

I'm having a problem with repo-sync which we've narrowed down with 
tcpdump/wireshark to see that my spacewalk server is rejecting the SSL CA cert 
from the remote end(at Red Hat) because it is failing to verify as having a 
valid signing authority.   I'm assuming that I need to re-load the certificate 
into spacewalk, but I'd like to compare the certificate that cdn.redhat.com is 
sending now to the one that I previously loaded in spacewalk.   Is this 
possible?

I'm currently running spacewalk 2.2 on RHEL6

How can I list the certificates I have loaded in spacewalk already?  On the 
repository details page I can see the names I assigned to them in the drop down 
lists for ssl ca cert and so forth.   Is there somewhere in the GUI that I can 
examine these names and the files/keys they are associated with?  Or is there 
some way with the command line tools to do that?

Thanks,

Robert Boyd

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

Re: [Spacewalk-list] RedHat repository certificate issue

[Boyd, Robert]

I discovered a partial answer to my question:

spacewalk-report repositories

will dump out all of the certificates registered to Spacewalk.

Now I'm investigating what's different between the old and the current CA 
certificates.



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Tuesday, December 08, 2015 3:53 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] RedHat repository certificate issue


I'm having a problem with repo-sync which we've narrowed down with 
tcpdump/wireshark to see that my spacewalk server is rejecting the SSL CA cert 
from the remote end(at Red Hat) because it is failing to verify as having a 
valid signing authority.   I'm assuming that I need to re-load the certificate 
into spacewalk, but I'd like to compare the certificate that cdn.redhat.com is 
sending now to the one that I previously loaded in spacewalk.   Is this 
possible?

I'm currently running spacewalk 2.2 on RHEL6

How can I list the certificates I have loaded in spacewalk already?  On the 
repository details page I can see the names I assigned to them in the drop down 
lists for ssl ca cert and so forth.   Is there somewhere in the GUI that I can 
examine these names and the files/keys they are associated with?  Or is there 
some way with the command line tools to do that?

Thanks,

Robert Boyd

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

[Spacewalk-list] Repo Sync Failure -- how to debug?

[Boyd, Robert]

I'm getting errors like this from several of my repo syncs and I'd like some 
help figuring out how to find out what's going wrong:

Sync started: Mon Oct 26 23:00:00 2015
['/usr/bin/spacewalk-repo-sync', '--channel', ', '--type', 'yum', 
'']
Repo URL: 
ERROR: Cannot retrieve repository metadata (repomd.xml) for repository: 
. Please verify its path and try again
Sync completed.
Total time: 0:00:00

I tried a curl test using the relevant SSL certs to the URLs for the channels 
involved in the form /repodata/repomd.xml and get  < HTTP/1.1 200 
OK, so I don't think it's a certificate issue.

How can I get more info from the spacewalk reposync to show me what's going 
wrong?

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]
Click here to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.com | Read: PeopleFluent 
Blog | Follow: 
@PeopleFluent



Thanks




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

Re: [Spacewalk-list] Red Hat repository syncing and Errors while cloning/promoting channels

[Boyd, Robert]

Can someone email me directly at 
robert.b...@peoplefluent.com<mailto:robert.b...@peoplefluent.com>  if you have 
recent experience working with your Red Hat Entitlement certificate?  I'm very 
much in need of figuring out how to clear up the problem I'm having pulling 
updates since our contract renewal.

Thanks in advance,

Robert

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Friday, October 09, 2015 3:35 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Red Hat repository syncing and Errors while 
cloning/promoting channels

It looks like my issue is that I need to update my SSL Client Certificate.   
The problem I'm having now is that I am having trouble figuring out where to 
find the new entitlement certificate.   The mechanism that used to work for 
this seems to have been changed and it's no longer available from the same 
place it was before.  I found something on a RHEL 6 server that is subscribed 
directly to Red Hat, but when I try to load the text from that file (under 
/etc/pki/entitlement/.pem and -key.pem) the text is 
rejected as being invalid

Anyone able to email me privately and advise me on where to get it from?

Also,  how can I list the certificates I have loaded in spacewalk already?  On 
the repository details page I can see the names I assigned to them in the drop 
down lists for ssl ca cert and so forth.   Is there somewhere in the GUI that I 
can examine these names and the files/keys they are associated with?  Or is 
there some way with the command line tools to do that?  This is one aspect of 
spacewalk that still feels very difficult to deal with.   The instructions for 
managing certificates seem to be incomplete and hard to find, and the GUI 
interface is obscurely placed as well under Admin>Spacewalk 
Configuration>Certificate.   And that location only provides "Update" function, 
no display of existing certificates.

The last time I touched this stuff was about a year ago and it seems almost as 
mysterious now as it did back then.

Any help would be appreciated.

Thanks,

Robert

From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Friday, October 09, 2015 1:13 PM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: [Spacewalk-list] Red Hat repository syncing and Errors while 
cloning/promoting channels

Running taskomatic generates this:

2015-10-09 12:03:17,245 [Thread-78] ERROR 
com.redhat.rhn.taskomatic.task.RepoSyncTask  - ERROR: Cannot retrieve 
repository metadata (repomd.xml) for repository: 
rhel-server-6-supplementary-x86_64. Please verify its path and try again

I've looked at several of my reposyncs and it looks like all of the red hat 
syncs are failing, apparently since our support renewal recently.Can anyone 
advise me as to what I need to do to re-activate the syncing?



I see this happen about once out of 10 times I clone channels using the 
spacewalk-manage-channel-lifecycle script.   It seems something in the 
spacewalk engine is running off the rails.   When it happens I restart 
everything and the next time I try it things go fine.   Then later another run 
with it for the same or another channel will trigger the failure again. 
Which logs should I be looking at? And is this a known problem with channel 
cloning? I'd almost bet something is running out of resources in one of the 
background processes.


Thanks.

Here is the error when I'm cloning.

spacewalk-manage-channel-lifecycle -c rhel-x86_64-server-5 --promote -u 
redacteduser -p redacted --workflow=rms --clear-channel
WARNING: Existing session is invalid
INFO: Parent Source: rhel-x86_64-server-5, destination: 
rms-preprod-rhel-x86_64-server-5
INFO: Clearing all errata from rms-preprod-rhel-x86_64-server-5
Traceback (most recent call last):
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 784, in 

merge_channels(parent_source, parent_dest)
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 420, in 
merge_channels
clear_channel(dest_label)
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 500, in 
clear_channel
False)
  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 1243, in request
headers
xmlrpclib.ProtocolError: 
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

[Spacewalk-list] Red Hat repository syncing and Errors while cloning/promoting channels

[Boyd, Robert]

Running taskomatic generates this:

2015-10-09 12:03:17,245 [Thread-78] ERROR 
com.redhat.rhn.taskomatic.task.RepoSyncTask  - ERROR: Cannot retrieve 
repository metadata (repomd.xml) for repository: 
rhel-server-6-supplementary-x86_64. Please verify its path and try again

I've looked at several of my reposyncs and it looks like all of the red hat 
syncs are failing, apparently since our support renewal recently.Can anyone 
advise me as to what I need to do to re-activate the syncing?



I see this happen about once out of 10 times I clone channels using the 
spacewalk-manage-channel-lifecycle script.   It seems something in the 
spacewalk engine is running off the rails.   When it happens I restart 
everything and the next time I try it things go fine.   Then later another run 
with it for the same or another channel will trigger the failure again. 
Which logs should I be looking at? And is this a known problem with channel 
cloning? I'd almost bet something is running out of resources in one of the 
background processes.


Thanks.

Here is the error when I'm cloning.

spacewalk-manage-channel-lifecycle -c rhel-x86_64-server-5 --promote -u 
redacteduser -p redacted --workflow=rms --clear-channel
WARNING: Existing session is invalid
INFO: Parent Source: rhel-x86_64-server-5, destination: 
rms-preprod-rhel-x86_64-server-5
INFO: Clearing all errata from rms-preprod-rhel-x86_64-server-5
Traceback (most recent call last):
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 784, in 

merge_channels(parent_source, parent_dest)
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 420, in 
merge_channels
clear_channel(dest_label)
  File "/usr/local/bin/spacewalk-manage-channel-lifecycle", line 500, in 
clear_channel
False)
  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 1243, in request
headers
xmlrpclib.ProtocolError: 
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

[Spacewalk-list] spacewalk-manage-channel-lifecycle script

[Boyd, Robert]

I want to use spacewalk-manage-channel-lifecycle with a couple of different 
configuration files for different flows in our environment.  I'm trying to find 
where the format of the user configuration file is documented. So far I'm not 
finding anything.   Is there someone on the list who can show me where the 
format is documented?  Is there some way to use the script itself to generate a 
sample config file?   I've looked at the code, but it's not jumping out at me.

Thank you,

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com


Click here to experience the power of the new PeopleFluent Mirror Suite T
Visit: www.peoplefluent.com | Read: PeopleFluent Blog | Follow: @PeopleFluent

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Matt Micene
Sent: Wednesday, May 01, 2013 4:55 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Logic change to spacewalk-manage-channel-lifecycle 
script

(I spoke with Aron off-list and he suggested I post my changes to the list for 
comments)

Using spacewalk-manage-channel-lifecycle, I noted that the promote 
functionality has an issue with base channels that don't start with rhel-.  
I've made some changes to the logic to determine channel labels in the promote 
function to look at the phases array instead of the channels list.  My testing 
works so far (handles non-rhel- named base channels, won't promote past last 
phase) but I'm not a python guru by any stretch.




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

Re: [Spacewalk-list] spacewalk-manage-channel-lifecycle script

[Boyd, Robert]

 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Wednesday, May 06, 2015 12:52 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] spacewalk-manage-channel-lifecycle script

I want to use spacewalk-manage-channel-lifecycle with a couple of different 
configuration files for different flows in our environment.  I'm trying to find 
where the format of the user configuration file is documented. So far I'm not 
finding anything.   Is there someone on the list who can show me where the 
format is documented?  Is there some way to use the script itself to generate a 
sample config file?   I've looked at the code, but it's not jumping out at me.

Thank you,

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

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

Re: [Spacewalk-list] Registering clients

[Boyd, Robert]

At the command line try:

  Nslookukp spacewalk.perfect.com

And
  Ping spacewalk.perfect.com

And/or see if you have any entry in /etc/hosts for spacewalk.perfect.com.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite (tm)
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Irwin, Jeffrey R
Sent: Monday, May 04, 2015 3:15 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Registering clients

I initially registered clients, and they showed up in the GUI.  Shortly 
thereafter they went to inactive.  I attempted to reregister one of the 
machines and got the following:

Any help as to registering clients would be appreciated.  Last step in my 
endeavor.

rhnreg_ks --serverUrl=https://spacewalk.perfect.com/XMLRPC 
--sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT 
--activationkey=1-oraclelinux --force
An error has occurred:
Error communicating with server. The message was:
Name or service not known
See /var/log/up2date for more information
[root@phfdtestclient2 ~]# tail -100 /var/log/up2date
socket.AF_UNSPEC, socket.SOCK_STREAM)
class 'up2date_client.up2dateErrors.CommunicationError': Error communicating 
with server. The message was:
Name or service not known

[Mon May  4 15:07:50 2015] up2date A socket error occurred: [Errno -2] Name or 
service not known, attempt #1
[Mon May  4 15:07:50 2015] up2date
Traceback (most recent call last):
  File /usr/sbin/rhnreg_ks, line 218, in module
cli.run()
  File /usr/share/rhn/up2date_client/rhncli.py, line 96, in run
sys.exit(self.main() or 0)
  File /usr/sbin/rhnreg_ks, line 90, in main
rhnreg.getCaps()
  File /usr/share/rhn/up2date_client/rhnreg.py, line 248, in getCaps
s.capabilities.validate()
  File /usr/share/rhn/up2date_client/rhnserver.py, line 178, in 
__get_capabilities
self.registration.welcome_message()
  File /usr/share/rhn/up2date_client/rhnserver.py, line 63, in __call__
return rpcServer.doCall(method, *args, **kwargs)
  File /usr/share/rhn/up2date_client/rpcServer.py, line 203, in doCall
ret = method(*args, **kwargs)
  File /usr/lib64/python2.6/xmlrpclib.py, line 1199, in __call__
return self.__send(self.__name, args)
  File /usr/share/rhn/up2date_client/rpcServer.py, line 37, in _request1
ret = self._request(methodname, params)
  File /usr/lib/python2.6/site-packages/rhn/rpclib.py, line 384, in _request
self._handler, request, verbose=self._verbose)
  File /usr/lib/python2.6/site-packages/rhn/transports.py, line 170, in 
request
headers, fd = req.send_http(host, handler)
  File /usr/lib/python2.6/site-packages/rhn/transports.py, line 720, in 
send_http
self._connection.connect()
  File /usr/lib/python2.6/site-packages/rhn/connections.py, line 165, in 
connect
socket.AF_UNSPEC, socket.SOCK_STREAM)
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] registering clients after update

[Boyd, Robert]

Hemen,

If you already include a sub-channel for the Spacewalk Client tools under the 
channel your clients are subscribed to, you can simply update the repository to 
point to the 2.3 client feed, resync the sub-channel/repository, and then you 
will see the client update available to each of your clients.   The next time 
you update them automatically or manually they will pull the new client.

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com


Click here to experience the power of the new PeopleFluent Mirror Suite T
Visit: www.peoplefluent.com | Read: PeopleFluent Blog | Follow: @PeopleFluent

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of hemen.me...@gmail.com
Sent: Wednesday, April 29, 2015 10:00 AM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] registering clients after update

I had a working install of SW 2.2. with clients that were registered and 
working properly, then I decided to upgrade to SW 2.3 and followed the 
directions here:
https://fedorahosted.org/spacewalk/wiki/HowToUpgrade

I now would like to know how to upgrade the clients to work with the newly 
upgraded 2.3 server. (is it as simple as treating the existing clients as new 
clients and follow the procedures on this page?
https://fedorahosted.org/spacewalk/wiki/RegisteringClients)

Thank you for all your help, it is very much appreciated.

___
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

Re: [Spacewalk-list] Problem with Organisations

[Boyd, Robert]

Frank,

Have you looked through /var/log/rhn/rhn_taskomatic_daemon.log ?  Taskomatic 
builds the repomd.xml along with other files in the  
/var/cache/rhn/repodata/channel-label directories.  You might look in those 
directories and make sure the repomd.xml files are there.  What about 
permission or SE-Linux issues with those directories/files?  All possibilities 
to consider.

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com


Click here to experience the power of the new PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.com | Read: PeopleFluent Blog | Follow: @PeopleFluent

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Frank Paulick
Sent: Monday, April 20, 2015 5:19 AM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Problem with Organisations

Hi,

i have a spacewalk 2.3 server with a default Organisation and 2 non-default 
organisations.
i have added subscription entitlements to these 2 other organisations and am 
able to register clients to these organisations.
i can also register clients to the default organisation but running any yum 
command brings the error message can't find repomd.xml for every channel this 
system is subscribed to.

for me it looks like a config issue, but i have no clue anymore where to look 
any help is appreciated

Regards
Frank

--
beste Grüße,
Frank Paulick

Baader Bank AG
Weihenstephaner Str. 4
85716 Unterschleißheim
Deutschland

Telefon: +49-89/5150-1522
Telefax: +49-89/5150-2421

Email: frank.paul...@baaderbank.de
Internet: http://www.baaderbank.de
   http://www.bondboard.de
**
Baader Bank AG: Vorstand: Uto Baader (Vors.), Nico Baader, Dieter Brichmann; 
Vorsitzender des Aufsichtsrates: Dr. Horst Schiessl; Amtsgericht München HRB 
121537; Sitz der Gesellschaft: Unterschleissheim; StNr. 143/100/10066; 
USt-IdNr. DE114123893.
**
Diese Email enthält vertrauliche Informationen. Sollten Sie diese Email 
irrtümlich erhalten, machen wir Sie darauf aufmerksam, dass jegliche Verwendung 
strikt untersagt ist. Bitte informieren Sie uns gegebenenfalls unverzüglich und 
vernichten Sie das Original. Das unerlaubte Kopieren sowie die unbefugte 
Weitergabe dieser Email ist nicht gestattet.
Wir haben alle verkehrsüblichen Maßnahmen unternommen, um das Risiko der 
Verbreitung virenbefallener Software oder Emails zu minimieren, dennoch raten 
wir Ihnen, Ihre eigenen Virenkontrollen auf alle Anhänge an dieser Nachricht 
durchzuführen. Wir schließen außer für den Fall von Vorsatz die Haftung für 
jeglichen Verlust oder Schäden durch virenbefallene Software oder Emails aus.

___
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

Re: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI reports that there are

[Boyd, Robert]

This problem continues.  The master clearly sees that a number of packages need 
updating.  For some reason on the client these packages are not being seen.  I 
attempted scheduling updates from Spacewalk GUI.  Then ran rhn_check on the 
client.   Then I see this result on the master:

Summary:

Package Install scheduled by username

Details:

This action will be executed after 04/17/15 12:58:53 PM EDT.

This action's status is: Failed.
The client picked up this action on 04/17/15 12:59:09 PM EDT.
The client completed this action on 04/17/15 12:59:15 PM EDT.
Client execution returned Error while executing packages action: empty 
transaction [[6]] (code -1)
Packages Scheduled:
· xorg-x11-server-common-1.15.0-26.el6_6
· libipa_hbac-python-1.11.6-30.el6_6.4
· cyrus-sasl-2.1.23-15.el6_6.2
· scl-utils-20120927-27.el6_6
· kernel-2.6.32-504.12.2.el6
· sssd-1.11.6-30.el6_6.4
· dhcp-common-4.1.1-43.P1.el6_6.1:12
· busybox-1.15.1-21.el6_6:1
· nss-softokn-freebl-3.14.3-22.el6_6
· tzdata-2015b-1.el6
· kpartx-0.4.9-80.el6_6.3
· openssl-1.0.1e-30.el6_6.8
· samba-winbind-3.6.23-14.el6_6:0
· samba-winbind-clients-3.6.23-14.el6_6:0
· ntp-4.2.6p5-3.el6_6
· krb5-libs-1.10.3-37.el6_6
· sssd-krb5-common-1.11.6-30.el6_6.4
· perf-2.6.32-504.12.2.el6
· flac-1.2.1-7.el6_6
· krb5-workstation-1.10.3-37.el6_6
· freetype-2.3.11-15.el6_6.1
· cyrus-sasl-lib-2.1.23-15.el6_6.2
· unzip-6.0-2.el6_6
· dhclient-4.1.1-43.P1.el6_6.1:12
· augeas-libs-1.0.0-7.el6_6.1
· samba4-libs-4.0.0-66.el6_6.rc4:0
· samba-common-3.6.23-14.el6_6:0
· tzdata-java-2015b-1.el6
· sssd-client-1.11.6-30.el6_6.4
· dracut-004-356.el6_6.1
· curl-7.19.7-40.el6_6.4
· cyrus-sasl-plain-2.1.23-15.el6_6.2
· libsss_idmap-1.11.6-30.el6_6.4
· libcurl-7.19.7-40.el6_6.4
· sssd-proxy-1.11.6-30.el6_6.4
· libipa_hbac-1.11.6-30.el6_6.4
· openssl-devel-1.0.1e-30.el6_6.8
· krb5-devel-1.10.3-37.el6_6
· libssh2-1.4.2-1.el6_6.1
· nss-softokn-3.14.3-22.el6_6
· sssd-common-1.11.6-30.el6_6.4
· python-sssdconfig-1.11.6-30.el6_6.4
· shadow-utils-4.1.4.2-19.el6_6.1:2
· sssd-ipa-1.11.6-30.el6_6.4
· xorg-x11-server-Xorg-1.15.0-26.el6_6
· alsa-utils-1.0.22-9.el6_6
· sssd-krb5-1.11.6-30.el6_6.4
· kexec-tools-2.0.0-280.el6_6.2
· ruby-1.8.7.374-4.el6_6
· kernel-headers-2.6.32-504.12.2.el6
· sssd-ad-1.11.6-30.el6_6.4
· kernel-firmware-2.6.32-504.12.2.el6
· gdbm-1.8.0-38.el6
· openjpeg-libs-1.3-11.el6
· gdbm-devel-1.8.0-38.el6
· tcsh-6.17-25.el6_6
· sssd-ldap-1.11.6-30.el6_6.4
· dracut-kernel-004-356.el6_6.1
· nss-softokn-freebl-3.14.3-22.el6_6
· ruby-libs-1.8.7.374-4.el6_6
· cyrus-sasl-gssapi-2.1.23-15.el6_6.2
· sssd-common-pac-1.11.6-30.el6_6.4

Time:

04/17/15 12:58:53 PM EDT


Reschedule:

This history event was caused by a failed scheduled action.
If you have corrected the problem, you may reschedule the action b



Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI reports that there are

[Boyd, Robert]

I finally found the source of this problem.   I had a java heap max of 
1GB(Default?) configured for the taskomatic daemon.   I modified 
/usr/share/rhn/config-defaults/rhn_taskomatic_daemon.conf to bump up the heap:

# Initial Java Heap Size (in MB)
wrapper.java.initmemory=512

# Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=3072

After restarting spacewalk the RHN cache rebuilt cleanly and now things look 
matched.

Wouldn’t it be nice if somehow taskomatic could flag that it’s in trouble in 
some way that it emails the administrator or raises an alarm that would show up 
in the GUI to tell you it’s failing?  Does it already do this somewhere and I 
just don’t know about it?  I don’t see any emails to root about this problem.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Friday, April 17, 2015 1:03 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI 
reports that there are

This problem continues.  The master clearly sees that a number of packages need 
updating.  For some reason on the client these packages are not being seen.  I 
attempted scheduling updates from Spacewalk GUI.  Then ran rhn_check on the 
client.   Then I see this result on the master:


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

Re: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI reports that there are

[Boyd, Robert]

I tried running the spacewalk fsck utility.

I tried your suggestions as well.  Unfortunately so far nothing has changed.   
I tried deleting one of the systems from spacewalk and re-registering it. After 
registering, it still shows the same discrepancy.   A good number of updates 
listed in the GUI as being applicable, with only 2 showing on the client side 
with yum check-update.

I tried clearing out the yum cache on the client side, to no net effect.

I have another client that needed quite a number of updates.   I applied the 
updates with yum update.   After the update was complete, I now see the same 
discrepancy between the yum client list and the package updates showing 
available and applicable from the GUI.  All of the servers involved have been 
rebooted, so everything has been restarted. At least once.

Any suggestions about why yum queries are getting different results than I see 
in the spacewalk GUI?  And how to get things back in synch?

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Wednesday, April 01, 2015 1:00 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI 
reports that there are

check if a repomd sync job is stuck
this can occasionally happen on larger repos if Java isn't properly tuned.
the quick way to fix it is to restart taskomatic then resync the repo
Failing that you need to delete the directory containing the repomd file and 
resync the repo again to fully regenerate it.



On Wed, Apr 1, 2015 at 12:29 PM, Boyd, Robert 
robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com wrote:
I’m having this same problem – a number of clients show in the GUI to need 
quite a number of updates.   However at the client end yum check-update shows 1 
2 or 3 packages needing update.  And when I attempt to run the update I get 
dependency errors.   Some of the clients are showing an update for 
bind-libs.i686 when they only have the x86_64 package installed.  The 
appropriate update package for the correct architecture is on the spacewalk 
server and I can see in the GUI that it is listed as an update for the client, 
but the client can’t see it.   I’ve done all of the suggestions (and then some) 
for clearing this problem from the client end.  This suggestion about the cache 
looks like the first hopeful suggestion I’ve seen.

And for the record, we’re running on Spacewalk 2.0 currently.


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

Re: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI reports that there are

[Boyd, Robert]

I’m having this same problem – a number of clients show in the GUI to need 
quite a number of updates.   However at the client end yum check-update shows 1 
2 or 3 packages needing update.  And when I attempt to run the update I get 
dependency errors.   Some of the clients are showing an update for 
bind-libs.i686 when they only have the x86_64 package installed.  The 
appropriate update package for the correct architecture is on the spacewalk 
server and I can see in the GUI that it is listed as an update for the client, 
but the client can’t see it.   I’ve done all of the suggestions (and then some) 
for clearing this problem from the client end.  This suggestion about the cache 
looks like the first hopeful suggestion I’ve seen.

And for the record, we’re running on Spacewalk 2.0 currently.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Alan Pittman
Sent: Tuesday, March 31, 2015 9:03 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI 
reports that there are

Thanks for the replies, but neither suggestion helped. I got it to work with a 
wild shot in the dark. What I did was to  delete the 
/var/cache/rhn/repodata/channel sub-directories on the spacewalk server and 
force the Spacewalk application to repopulate them. Exactly what forces the 
re-population, I don’t know, but if I run a yum makecache on the client, it 
initially fails because there isn’t anything in the 
/var/cache/rhn/repodata/channel directory. Something triggers Spacewalk to 
rebuild/reload the directory and then the makecache command works for that 
channel. I have to run the makecache multiple times to force all of the data 
for all of the channels to be re-populated.

How the data in the /var/cache/rhn/repodata/channel directory got “stale”, I 
don’t know, but at least it’s working now.

Hopefully this makes some sense and is helpful for someone else.

Alan

From: 
spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Kobus Bensch
Sent: Tuesday, March 31, 2015 4:42 AM
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI 
reports that there are

I had this issue. I fixed it by running a repo sync manually.
On 31/03/2015 05:21, prmari...@gmail.commailto:prmari...@gmail.com wrote:
Try running rhn-profile-sync on the box in question then looking in the GUI 
again. This can happen if some one does a manual update in yum and does not run 
that command afterward.
Its well documented in the install procedure for every red hat errata‎ that you 
have to run that command after a yum update. You may also want to consider 
adding cron.daily job to do this with anacron that should execute it every day 
at a semi randomized time so you won't over laod your spacewalk server and the 
added load to the host while running it is negligible so it should not impact 
the performance of the applications you are running unless the box is already 
severly overloaded to begin with.


Sent from my BlackBerry 10 smartphone.
From: Alan Pittman
Sent: Monday, March 30, 2015 14:07
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Reply To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: [Spacewalk-list] Yum client reports no update, But Spacewalk GUI 
reports that there are


Hi,
  I'm having an issue with Spacewalk 2.0. I have two RHEL6 x86_64 servers that 
the Spacewalk GUI reports that there are available updates. However, if I run 
yum on these two machines, nothing is reported as being available for updating. 
I've done some Google searches and this has been an issue in the past for some 
individuals and occasionally the problem has been fixed by running yum clean 
all, followed by deleting the /var/cache/yum directory. Then a yum makecache. . 
I tried this and it didn't helped. I have also tried deleting the profile for 
the server and attempting a re-register. That didn't work either.  If anyone 
has any ideas/suggestions, I would like to hear them.

   Some other information that might be beneficial (I think):

   - All updates have been performed using yum. No rpm --install or --upgrade 
has been performed.
   - Since I had deleted and re-registered the client, I didn't think 
rhn-profile-sync would do any good, 

Re: [Spacewalk-list] Registering Clients in Spacewalk 2.2

[Boyd, Robert]

Yes,  I thought this part would be fairly apparent from the documentation / 
explanation of what that script does.

The way the spacewalk-create-yumrepo.py code works is that it reads the 
information from a channel that exists in spacewalk and creates a directory the 
necessary structures and links to serve as a front end to the packages in that 
channel.

You must create the channel and repository setup in spacewalk and be 
importing/synching the packages from the source repository into spacewalk.   
Once the channel is set up and the repository populated, then you can run the 
script.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Jason Calafiore
Sent: Thursday, February 26, 2015 10:41 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Registering Clients in Spacewalk 2.2

Hi Robert,
 I've been looking at this solution and I ran into an issue on step 3
3) Call the script: spacewalk-create-yumrepo.py (Which I installed in 
/usr/local/bin)

   /usr/local/bin/spacewalk-create-yumrepo.py -s SW IP ADDR -u admin -p  
-c SW channel name -d /var/www/html/pub/dir/software


/usr/local/bin/spacewalk-create-yumrepo.py -s 156.80.52.242 -u ghs_admin -p 
password -c Spacewalk-Client -d /^Cr/www/html/pub/spacewalk-client/packages

When I run this I get the following...

xmlrpclib.Fault: Fault -210: 'redstone.xmlrpc.XmlRpcFault: No such channel: 
Spacewalk-Client'


Do I have to create a channel first in spacewalk gui or should I be referring 
to my CentOS base channel?

Thank you,
Jason



  *   From: Boyd, Robert Robert Boyd peoplefluent com
  *   To: spacewalk-list redhat com spacewalk-list redhat com
  *   Subject: Re: [Spacewalk-list] Registering Clients in Spacewalk 2.2
  *   Date: Fri, 20 Feb 2015 17:39:02 +


I think you might consider using spacewalk-create-yumrepo.py to do this.

If you have a channel or subchannel with the Spacewalk Client packages you can 
use that python script to create a yum style repo front end to the Spacewalk 
content.  Then you can set up a temporary spacewalk-client repo config for yum 
on your clients that will point to the repo address on your Spacewalk server.

Here’s a fairly recent message from the list that discusses the create yum repo 
process:

Thank you a lot: I install it and works fine to me!
I'm thinking of improve it to include parameters to define last or all 
packages, and also to perform createrepo automatically on changed repos. If I 
do it, I'll submit to original author.

2014-10-07 13:27 GMT-03:00 Glen Collins glenc2004 comcast 
netmailto:glenc2004%20comcast%20net:

Oh, one thing I need to mention. I did have to make one change to the code in 
the script so it would link all rpm's. The code from GIT actually only links 
the latest in the channel and not everything. So the change I made was

Change spacewalk.channel.software.listLatestPackages to 
spacewalk.channel.software.listAllPackages. See below

-

## for pkg in spacewalk.channel.software.listLatestPackages(spacekey, 
options.channel):
for pkg in spacewalk.channel.software.listAllPackages(spacekey, 
options.channel):
det=spacewalk.packages.getDetails(spacekey, pkg['id'])
fn=det['path'].split(/)[-1]
if not os.path.exists(%s/packages/%s % (options.directory, fn)):
os.symlink(%s/%s % (options.satdir, det['path']), 
%s/packages/%s % (options.directory, fn))
spacewalk.auth.logout(spacekey)

-

Regards,

Glen Collins

- Original Message -

Hi Fabiano,

  Are you asking if you can create a pseudo repo in Spacewalk that can mimic a 
YUM repository via HTTP? If that is what you are asking, then yes it is 
possible. And I have done it so I can install my spacewalk clients using the 
yum method. Here is what you do...

1) Download and install: https://github.com/angrox/spacewalk-api-scripts

2) Create directory under: /var/www/html/pub/software name (this is 
accessible using the URL http://SWhttp://%3Csw/ IP ADDR/pub/software name)

3) Call the script: spacewalk-create-yumrepo.py (Which I installed in 
/usr/local/bin)

   /usr/local/bin/spacewalk-create-yumrepo.py -s SW IP ADDR -u admin -p  
-c SW channel name -d /var/www/html/pub/dir/software

4) Run createrepo against the new directory

Re: [Spacewalk-list] Registering Clients in Spacewalk 2.2

[Boyd, Robert]

I think you might consider using spacewalk-create-yumrepo.py to do this.

If you have a channel or subchannel with the Spacewalk Client packages you can 
use that python script to create a yum style repo front end to the Spacewalk 
content.  Then you can set up a temporary spacewalk-client repo config for yum 
on your clients that will point to the repo address on your Spacewalk server.

Here’s a fairly recent message from the list that discusses the create yum repo 
process:

Thank you a lot: I install it and works fine to me!
I'm thinking of improve it to include parameters to define last or all 
packages, and also to perform createrepo automatically on changed repos. If I 
do it, I'll submit to original author.


2014-10-07 13:27 GMT-03:00 Glen Collins 
glenc2...@comcast.netmailto:glenc2...@comcast.net:

Oh, one thing I need to mention. I did have to make one change to the code in 
the script so it would link all rpm's. The code from GIT actually only links 
the latest in the channel and not everything. So the change I made was

Change spacewalk.channel.software.listLatestPackages to 
spacewalk.channel.software.listAllPackages. See below

-

## for pkg in spacewalk.channel.software.listLatestPackages(spacekey, 
options.channel):
for pkg in spacewalk.channel.software.listAllPackages(spacekey, 
options.channel):
det=spacewalk.packages.getDetails(spacekey, pkg['id'])
fn=det['path'].split(/)[-1]
if not os.path.exists(%s/packages/%s % (options.directory, fn)):
os.symlink(%s/%s % (options.satdir, det['path']), 
%s/packages/%s % (options.directory, fn))
spacewalk.auth.logout(spacekey)

-

Regards,

Glen Collins

- Original Message -

Hi Fabiano,

  Are you asking if you can create a pseudo repo in Spacewalk that can mimic a 
YUM repository via HTTP? If that is what you are asking, then yes it is 
possible. And I have done it so I can install my spacewalk clients using the 
yum method. Here is what you do...

1) Download and install: https://github.com/angrox/spacewalk-api-scripts

2) Create directory under: /var/www/html/pub/software name (this is 
accessible using the URL http://SWhttp://%3cSW IP ADDR/pub/software name)

3) Call the script: spacewalk-create-yumrepo.py (Which I installed in 
/usr/local/bin)

   /usr/local/bin/spacewalk-create-yumrepo.py -s SW IP ADDR -u admin -p  
-c SW channel name -d /var/www/html/pub/dir/software

4) Run createrepo against the new directory: createrepo 
/var/www/html/pub/dir/software

5) And then configure you client using the stand YUM file in /etc/yum.repos.d

6) Verify you can see it using your web browser. You may run into permissions 
issue accessing the repomd.xml in the repodata directory. What I do is a chmod 
-R 755 on the entire /var/www/html/pub/dir/software so I don't have any 
issues with he web server accessing the files.

What this is doing is creating links to the actual RPM's in 
/var/satellite/. so when you access it via HTTP it looks exactly like a 
standard YUM repo. So you don't have to have any extra copies of any of the 
RPM's taking up extra space. Now while I only have done this for the SW client 
install, I can assume since it works for the client and it should work for 
everything include the OS, EPEL and all the other channels you may have in SW.

Regards,

Glen Collins

- Original Message -
Fabiano Martins wrote:
% Hi all,
%
% I have a Spacewalk 2.2 server running on my environment.
%
% But some machines aren't registered on Spacewalk (RHELs registered on RHN,
% CentOSs that sysadmin don't like to register on Spacewalk, etc.).
%
% Once my Spacewalk server already have a mirror of external repos (EPEL,
% VMWare, etc.), I would that these exceptions not use my Internet link when
% installing/updating packages.
%
% Have a form to offer these repos mirrored into Spacewalk as a pure http
% repo?

Hello Fabiano,

Unfortunately Spacewalk can't do this.

% I know that I can mirror external repos via rsync and re-mirror to
% Spacewalk via spacewalk-repo-sycnc, but on this case I would use 2 times
% each file on disk...
%
% Thanks,
%
% Fabiano Martins

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat

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

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 

Re: [Spacewalk-list] Osad errors on Spacewalk 2.2 Server

[Boyd, Robert]

] \twsgi.version: (1, 1)
[Mon Feb 09 15:31:47 2015] [error]
[Mon Feb 09 15:31:47 2015] [error] Exception Handler Information
[Mon Feb 09 15:31:47 2015] [error] Traceback (most recent call last):
[Mon Feb 09 15:31:47 2015] [error]   File 
/usr/lib/python2.6/site-packages/spacewalk/server/apacheHandler.py, line 80, 
in headerParserHandler
[Mon Feb 09 15:31:47 2015] [error] rhnSQL.initDB()
[Mon Feb 09 15:31:47 2015] [error]   File 
/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py, line 
117, in initDB
[Mon Feb 09 15:31:47 2015] [error] raise e
[Mon Feb 09 15:31:47 2015] [error] SQLConnectError: (None, None, 'spaceschema', 
'Attempting Re-Connect to the database failed')
[Mon Feb 09 15:31:47 2015] [error]

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Waldirio Manhães 
Pinheiro
Sent: Saturday, February 07, 2015 9:38 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Osad errors on Spacewalk 2.2 Server

Boyd, good morning

Fixed ?!!?

Take Care

__
Atenciosamente
Waldirio
msn: waldi...@gmail.commailto:waldi...@gmail.com
Skype: waldirio
Site: www.waldirio.com.brhttp://www.waldirio.com.br
Blog: blog.waldirio.com.brhttp://blog.waldirio.com.br
LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646
PGP: www.waldirio.com.br/public.htmlhttp://www.waldirio.com.br/public.html

On Mon, Feb 2, 2015 at 2:01 PM, Paul Robert Marino 
prmari...@gmail.commailto:prmari...@gmail.com wrote:
check the database the logs should be in
/var/lib/pgsql/data/pg_log/postgresql-3 character acronym for day of
the week.log

On Fri, Jan 30, 2015 at 12:33 PM, Boyd, Robert
robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com wrote:
 I'm getting these error messages every several times a minute -- looks like 
 at 10 second intervals.

 2015/01/30 12:30:28 -04:00 3011 0.0.0.0http://0.0.0.0: 
 osad/jabber_lib.main('ERROR', 'Error caught:')
 2015/01/30 12:30:28 -04:00 3011 0.0.0.0http://0.0.0.0: 
 osad/jabber_lib.main('ERROR', 'Traceback (most recent call last):\n  File 
 /usr/share/rhn/osad/jabber_lib.py, line 118, in main\n
 self.setup_config(config)\n  File /usr/share/rhn/osad/osa_dispatcher.py, 
 line 112, in setup_config\nrhnSQL.initDB()\n  File 
 /usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py, line 
 117, in initDB\nraise e\nSQLConnectError: (None, None, \'spaceschema\', 
 \'Attempting Re-Connect to the database failed\')\n')

 What does this mean and what can I do about it?

 Robert Boyd
 Sr. Systems Engineer
 PeopleFluent
 p. 919-645-2972tel:919-645-2972 | c. 919-306-4681tel:919-306-4681
 e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com




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

___
Spacewalk-list mailing list
Spacewalk-list@redhat.commailto: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

Re: [Spacewalk-list] Osad errors on Spacewalk 2.2 Server

[Boyd, Robert]

I am using an NFS share as my storage for the spacewalk repositories under 
/var/satellite.  I discovered today that I needed to do these:

setsebool -P httpd_use_nfs 1
setsebool -P spacewalk_nfs_mountpoint 1

Those 2 adjustments resolved a number of problems that I was seeing.

I’m now successfully running rhnpush.

I found the fix while running “denied” entries in  /var/log/audit/audit.log 
through audit2why

type=AVC msg=audit(1423517214.815:213656): avc:  denied  { add_name } for  
pid=25064 comm=httpd name=Deployment_Guide-de-DE-5.8-1.el5-noarchTA2GNf 
scontext=unconfined_u:system_r:httpd_t:s0 tcontext=system_u:object_r:nfs_t:s0 
tclass=dir

Was caused by:
One of the following booleans was set incorrectly.
Description:
spacewalk_nfs_mountpoint

Allow access by executing:
# setsebool -P spacewalk_nfs_mountpoint 1
Description:
Allow httpd to access nfs file systems

Allow access by executing:
# setsebool -P httpd_use_nfs 1

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Monday, February 09, 2015 3:45 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Osad errors on Spacewalk 2.2 Server

One issue turned out to be an SElinux issue with osa-dispatcher.



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

Re: [Spacewalk-list] Osad errors on Spacewalk 2.2 Server

[Boyd, Robert]

I'm getting these error messages every several times a minute -- looks like at 
10 second intervals.

2015/01/30 12:30:28 -04:00 3011 0.0.0.0: osad/jabber_lib.main('ERROR', 'Error 
caught:')
2015/01/30 12:30:28 -04:00 3011 0.0.0.0: osad/jabber_lib.main('ERROR', 
'Traceback (most recent call last):\n  File 
/usr/share/rhn/osad/jabber_lib.py, line 118, in main\n
self.setup_config(config)\n  File /usr/share/rhn/osad/osa_dispatcher.py, line 
112, in setup_config\nrhnSQL.initDB()\n  File 
/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py, line 
117, in initDB\nraise e\nSQLConnectError: (None, None, \'spaceschema\', 
\'Attempting Re-Connect to the database failed\')\n')

What does this mean and what can I do about it?

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com




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

Re: [Spacewalk-list] Redhat CDN Support?

[Boyd, Robert]

This is no longer correct with the latest version of spacewalk.  There has been 
discussion about this several times in the past few months.   Please search the 
archives for the relevant messages.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Matthew Madey
Sent: Wednesday, January 21, 2015 4:40 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Redhat CDN Support?


No, you will have to use mrepo or pulp. I recommend pulp. I have a separate 
server running pulp to pull down packages nightly, then sync spacewalk with the 
pulp repo

On Jan 21, 2015 2:44 PM, Ciro Iriarte 
cyru...@gmail.commailto:cyru...@gmail.com wrote:

 Hi!, is it possible to download packages directory from the Redhat CDN using 
 spacewalk-repo-sync ?. I've setup the SSL certificate/key pair but I keep 
 getting this error:

  Channel label: rhel7-x86_64 
 Repo URL: https://cdn.redhat.com/content/dist/rhel/server/7/7server/x86_64/os
 ERROR: Cannot retrieve repository metadata (repomd.xml) for repository: 
 rhel7-x86_64. Please verify its path and try again
 Sync completed.
 Total time: 0:00:04

 This is with Spacewalk 2.2

 Regards,

 --
 Ciro Iriarte
 http://iriarte.it
 --

 ___
 Spacewalk-list mailing list
 Spacewalk-list@redhat.commailto: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

Re: [Spacewalk-list] [External] Re: Spacewalk on RHEL

[Boyd, Robert]

This is not exactly correct.   It is possible with mrepo to import multiple 
versions of RHEL repos on a single server.   I set mine up to import RHEL 4, 5 
and 6 a couple of years ago.   I’ve upgraded to Spacewalk 2.0 so far using that 
scenario.  I’m preparing to switch to a new instantiation of Spacewalk 2.2 
using the direct import mechanisms in the near future to save on space and 
processing time.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[http://mktg.peoplefluent.com/rs/peopleclick/images/140410_PF4colorLOGOx150.png]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite ™
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Amedeo Salvati
Sent: Monday, December 22, 2014 10:22 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] [External] Re: Spacewalk on RHEL

I think it's mandatory to use different rhel server for each rhel version 5, 6, 
7, and don't forget for rhel 5 and 6 that could be 32bit or 64bit... but if you 
have a virtualization infrastructure you can create VMs for each version with 
poor resources, the only problems is the space for storing all rpms

Best Regards
Amedeo Salvati


Da spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com
A spacewalk-list@redhat.commailto:spacewalk-list@redhat.com 
spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Cc
Data Mon, 22 Dec 2014 15:03:57 +
Oggetto Re: [Spacewalk-list] [External] Re: Spacewalk on RHEL

 Hi Amedeo,
 Thank you for the reply. I just want clarify…

 Using mrepo we can configure RHEL in spacewalk with our existing RHEL license 
 subscriptions but it seems we would need to set up a RHEL server for each 
 version (ie 5, 6, 7) and export those RPM’s out to our Spacewalk server.

 Is there another method to configure all of this which is more convenient 
 without paying for the full Satellite package?

 Jason

 From: 
 spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
 [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Amedeo Salvati
 Sent: Monday, December 22, 2014 9:30 AM
 To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
 Subject: Re: [Spacewalk-list] [External] Re: Spacewalk on RHEL

 Hello Jason,

 I know that some guys configured spacewalk to serve as satellite 5.x 
 replacement using mrepo tool, so with one host with mrepo you could download 
 all rpms coming from red hat channels (your host with mrepo should have 
 channels subscription), so after downloaded all rpms, this will be available 
 as yum http repos and spacewalk can import them - you have doubled the 
 required space.

 But with this configuration you can use spacewalk as satellite replacement 
 without having a satellite certificate.

 Take a look to this guide: http://www.codarama.be/drupal/?q=node/4

 Best regards
 Amedeo Salvati



 Da spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com
 A spacewalk-list@redhat.commailto:spacewalk-list@redhat.com 
 spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
 Cc
 Data Mon, 22 Dec 2014 13:59:32 +
 Oggetto Re: [Spacewalk-list] [External] Re: Spacewalk on RHEL

  Hi All,
  Could someone assist me with my follow-up questions?
 
  Thank you,
  Jason
 
  -Original Message-
  From: 
  spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
  [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Calafiore, Jason 
  [USA]
  Sent: Thursday, December 18, 2014 9:27 AM
  To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
  Subject: Re: [Spacewalk-list] [External] Re: Spacewalk on RHEL
 
  Hi Michael,
  Any thoughts on my follow-up questions? I'd be very appreciative of your 
  feedback.
 
  Thank you,
  Jason
 
  -Original Message-
  From: Calafiore, Jason [USA]
  Sent: Tuesday, December 16, 2014 2:31 PM
  To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
  Subject: RE: [Spacewalk-list] [External] Re: Spacewalk on RHEL
 
  Hi Michael,
  A few more questions...
 
  About this..  On the other hand you need to sync RHEL content to Spacewalk 
  server first.To be able to sync that content directly from rhn.redhat.com 
  you need a certificate; this cert is a part of Red Hat Satellite 
  subscription.
  - We need a certificate to be able to sync RHEL clients using Spacewalk, 
  correct? Would we need to purchase a (Satellite) license to do this?
 
  - I had seen this on Spacewalk's FAQ and sounds like Spacewalk cannot be 
  used for RHEL. Could your clarify?
  Can I use Spacewalk to sync my entitlements for Red Hat Enterprise Linux 
  and other Red Hat software products?
  No. In order to be 

Re: [Spacewalk-list] Spacewalk performance tuning for deployments with 1000+ hosts

[Boyd, Robert]

Matthew,

I tried these tuning adjustments on my RHEL 6.6 / SW 2.0 Server and it led to 
some problems.   How did you arrive at the numbers you suggested?  What size 
RAM do you have on your master server?

Robert Boyd
Sr. Systems Engineer
PeopleFluent

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Matthew Madey
Sent: Tuesday, October 28, 2014 12:42 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk performance tuning for deployments with 
1000+ hosts


Here are some configurations you might find helpful for tuning 
Apache\Tomcat\Java\Networking.. Like others have mentioned.. when you get over 
1000+ clients, it's a good idea to start scaling horizontally with Spacewalk 
Proxies. We use 4 proxies in our production environment and are servicing 8000+ 
clients. We can actually patch 1600 clients at a time and the GUI is still 
pretty responsive. Can't guarantee this will resolve your issue, but this 
worked for us.

Add maxThreads to /etc/tomcat6/server.xml


Connector port=8080 protocol=HTTP/1.1 connectionTimeout=2 
redirectPort=8443 URIEncoding=UTF-8 address=127.0.0.1 maxThreads=1024 
maxKeepAliveRequests=1000/

!-- A Connector using the shared thread pool--

!--

Connector executor=tomcatThreadPool

   port=8080 protocol=HTTP/1.1

   connectionTimeout=2

   redirectPort=8443 /



!-- Define an AJP 1.3 Connector on port 8009 --

Connector port=8009 protocol=AJP/1.3 redirectPort=8443 
URIEncoding=UTF-8 address=127.0.0.1 maxThreads=1024/



Connector port=8009 protocol=AJP/1.3 redirectPort=8443 
URIEncoding=UTF-8 address=::1 maxThreads=1024/





Tune Apache to service more requests /etc/httpd/conf.d/zz-spacewalk-server.conf





###

# Authorship and versioning info

# $Author$

# $Date$

# $URL$

# $Rev$

# deployment_location: /etc/httpd/conf.d/

###

# ** DO NOT EDIT **

# Master configuration file for the rhn_server setup

#



##

## Spacewalk settings

##



VirtualHost *



IfModule mod_jk.c

# Inherit the mod_jk settings defined in zz-spacewalk-www.conf

JkMountCopy On

/IfModule



Directory /var/www/html/*

AllowOverride all

/Directory



RewriteEngine on

RewriteOptions inherit

/VirtualHost



# Override default httpd prefork settings

IfModule prefork.c

StartServers   8

MinSpareServers400

MaxSpareServers   400

ServerLimit  1024

MaxClients   1024

MaxRequestsPerChild  200

/IfModule



Include /etc/rhn/satellite-httpd/conf/rhn/rhn_monitoring.conf







 Also added some network tuning to /etc/sysctl.conf



net.ipv4.icmp_echo_ignore_broadcasts = 1

net.ipv4.conf.all.secure_redirects = 0

net.ipv4.tcp_max_syn_backlog = 8192

net.ipv4.conf.default.secure_redirects = 0

net.ipv4.tcp_syncookies = 1

net.ipv4.conf.all.accept_source_route = 0

net.ipv4.conf.all.rp_filter = 1

net.ipv4.conf.all.send_redirects = 0

net.ipv4.conf.default.accept_redirects = 0

net.ipv4.conf.all.accept_redirects = 0

net.ipv4.conf.default.send_redirects = 0

net.core.somaxconn = 1536

net.core.dev_weight = 512

##3x normal for a queue and budget suited to networks greater than 100mbps

net.core.netdev_budget = 1

net.core.netdev_max_backlog = 3





Depending on the amount of memory on your Spacewalk server, you may want to 
increase your JAVA_OPTS Xms and Xmx settings to something a little higher. 
Typically only needed if you are seeing Java Heap out of memory errors in your 
Spacewalk logs.


On Tue, Oct 28, 2014 at 11:21 AM, Waldirio Manhães Pinheiro 
waldi...@gmail.commailto:waldi...@gmail.com wrote:
Dear Krzysztof

Have you checked your numa configuration ?!

Maybe you can customize you environment to use the same bus to application / 
memory.

__
Atenciosamente
Waldirio
msn: waldi...@gmail.commailto:waldi...@gmail.com
Skype: waldirio
Site: www.waldirio.com.brhttp://www.waldirio.com.br
Blog: blog.waldirio.com.brhttp://blog.waldirio.com.br
LinkedIn: http://br.linkedin.com/pub/waldirio-pinheiro/22/b21/646
PGP: www.waldirio.com.br/public.htmlhttp://www.waldirio.com.br/public.html

On Tue, Oct 28, 2014 at 2:10 PM, Krzysztof Pawłowski 
mscic...@msciciel.eumailto:mscic...@msciciel.eu wrote:
We have dedicated machine for db pgsql (16GB RAM , 8 cores)  and seperate for 
spacewalk (16GB RAM, 8 Cores).

I think that problem is with enormous number of queries to database. During 
such request db is not utilized 100% and spacewalk is also not 100% utilized.


2014-10-28 16:25 GMT+01:00 Götz Reinicke - IT Koordinator 
goetz.reini...@filmakademie.demailto:goetz.reini...@filmakademie.de:
Hi,
Am 28.10.14 um 12:57 schrieb Krzysztof Pawłowski:
 Hi,
 Is there any guide about tuning spacewalk performance ? With every new
 host spacewalk is getting slowly. Using SSM with more than 200-300 hosts
 is impossible due timeouts. It's also 

Re: [Spacewalk-list] Migration from pgsql to oracle

[Boyd, Robert]

Paul Robert,

This sounds on the face of it like an interesting possibility.   On the other 
hand, I looked at the page you linked to.  There I see many technical points 
that require an understanding of database configuration and administration that 
I certainly don't possess at this point in time.   I think it's asking a bit 
much of a non-DBA to come up to speed to tackle such a task to get better 
performance out of Spacewalk.

It would be more beneficial for someone who has already done partitioning to 
offer a description of the steps they went through including any calculations 
they had to make with their own Spacewalk database so that someone else could 
replicate the process.

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com


Click here to experience the power of the new PeopleFluent Mirror Suite ™

Visit: www.peoplefluent.com | Read: PeopleFluent Blog | Follow: @PeopleFluent

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Wednesday, November 19, 2014 10:51 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Migration from pgsql to oracle

Have you considered using a less drastic approach like partitioning some of the 
tables and tuning the ram.
I some how doubt the single CPU core per query it the problem because 
PostgreSQL is very good at handling bulk queries as opposed to lots of queries 
for tiny data sets.

Here is something you can check if  a directory named 
/var/lib/pgsql/data/pg_tmp exist on your system then your queries are exceeding 
the allowed rem for a single query and PostgreSQL is using that directory to 
essentially create swap files for queries if that is happening you need more 
ram or you need to tune your PostgreSQL server.

Here is a good place to start reading about table partitions 
https://wiki.postgresql.org/wiki/Table_partitioning that with constraint 
exclusion enabled in the config can help a lot with large data sets.










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

Re: [Spacewalk-list] RHEL6 - Spacewalk - MREPO [SEC=UNOFFICIAL]

[Boyd, Robert]

Here is what I did a couple of years ago when I ran into this same problem:

I modified the beginning of the gensystemid code farther to find the 1st 
occurrence of  site-packages and stick the mrepo or rhn libraries before it 
like so:

import os, sys, getopt, getpass, urlparse, re
False = 0
True = 1
def find(target,items):
texp = re.compile(target)
found = False
i = 0
while (not(found) and i  len(items)):
if (texp.search(items[i])):
found = True
i += 1
return i

i = find('.*site-packages',sys.path)

print Packages at , i

if os.path.exists('/usr/share/mrepo/up2date_client/'):
sys.path.insert(i-1, '/usr/share/mrepo/')
sys.path.insert(i, '/usr/share/mrepo/up2date_client/')
#sys.path.insert(-1, '/usr/share/mrepo/rhn/')
elif os.path.exists('/usr/share/rhn/up2date_client/'):
sys.path.insert(i-1, '/usr/share/rhn/')
sys.path.insert(i, '/usr/share/rhn/up2date_client/')
else:
print sys.stderr, 'rhnget: up2date libraries are not installed. Aborting 
execution'
sys.exit(1)

And from another message:

If you're having trouble with gensystemid Try changing the first few lines of 
the code like this:

if os.path.exists('/usr/share/mrepo/up2date_client/'):
sys.path.insert(7, '/usr/share/mrepo/')
sys.path.insert(7, '/usr/share/mrepo/up2date_client/')
elif os.path.exists('/usr/share/rhn/up2date_client/'):
sys.path.insert(7, '/usr/share/rhn/')
sys.path.insert(7, '/usr/share/rhn/up2date_client/')

This will insert the mrepo or rhn libraries ahead of the python site-packages.  
For some reason the site packages were promoted by several hops in the path 
list.

A better alternative would be to actually search the list and insert the rhn or 
mrepo libraries just prior to the site packages.   Maybe I'll have to learn 
enough python to pull this off.

In any event, I'm now getting an intelligible error message . Error 
communicating with the server. The message was:  Name or service not known.   

That is something I can investigate more directly I think.

Robert

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Monday, August 06, 2012 5:52 PM
To: spacewalk-list@redhat.com; Alan Pittman; 'fn...@yahoo.com'
Subject: Re: [Spacewalk-list] mrepo / gensystemid errors

I found one answer to my question.   There is a handy tool called dumpObj that 
you can copy from 
http://code.activestate.com/recipes/137951-dump-all-the-attributes-of-an-object/

So I copied it and inserted it into gensystemid on both servers.   Here is the 
key thing I see that is different:

On the server where gensystemid fails (RHEL6.3) :

__file__  /usr/lib/python2.6/site-packages/rhn/rpclib.pyc
  __name__  rhn.rpclib
  __package__   rhn
  __version__   $Revision$

With sys.path:  ['/root', '/usr/lib64/python26.zip', '/usr/lib64/python2.6', 
'/usr/lib64/python2.6/plat-linux2', '/usr/lib64/python2.6/lib-tk', 
'/usr/lib64/python2.6/lib-old', '/usr/lib64/python2.6/lib-dynload', 
'/usr/lib64/python2.6/site-packages', 
'/usr/lib64/python2.6/site-packages/gst-0.10', 
'/usr/lib64/python2.6/site-packages/gtk-2.0', 
'/usr/lib64/python2.6/site-packages/webkit-1.0', 
'/usr/lib/python2.6/site-packages', '/usr/share/mrepo/', 
'/usr/share/mrepo/up2date_client/', 
'/usr/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg-info']

On the RHEL 5.8 server where it works:

__file__  /usr/share/mrepo/rhn/rpclib.pyc
  __name__  rhn.rpclib
  __version__   $Revision: 118741 $

sys.path:  ['/root', '/usr/lib64/python24.zip', '/usr/lib64/python2.4', 
'/usr/lib64/python2.4/plat-linux2', '/usr/lib64/python2.4/lib-tk', 
'/usr/lib64/python2.4/lib-dynload', '/usr/lib64/python2.4/site-packages', 
'/usr/lib64/python2.4/site-packages/Numeric', 
'/usr/lib64/python2.4/site-packages/gtk-2.0', '/usr/share/mrepo/', 
'/usr/share/mrepo/up2date_client/', '/usr/lib/python2.4/site-packages']

So on the failing configuration somehow it's not finding the module which is 
clearly there.   I checked.  

Is there something wrong with the new search order?   I see that there are many 
differences in these 2 lists.   Anyone have a suggestion about what needs to be 
changed on the RHEL 6.3/Python 2.6 configuration to get the right module found?



Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com


Click here to experience the power of the new PeopleFluent Mirror Suite T

Visit: www.peoplefluent.com | Read: PeopleFluent Blog | Follow: @PeopleFluent

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Lichtinger, Bernhard
Sent: Wednesday, October 01, 2014 3:08 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] RHEL6 - Spacewalk - MREPO [SEC=UNOFFICIAL]

Hi,

I had to patch /usr/bin/gensystemid on my

[Spacewalk-list] YUM failures: PYCURL ERROR 22 - The requested URL returned error: 416 Requested Range Not Satisfiable

[Boyd, Robert]

I have some servers subscribed to a satellite server and 3 or 4 servers are 
having this error: error was [Errno 14] PYCURL ERROR 22 - The requested URL 
returned error: 416 Requested Range Not Satisfiable  Does anyone have any 
suggestions?   I tried yum clean all and retry.  This makes no change.

This only happens for certain packages on certain servers. The same packages 
download and install cleanly on many other servers. Here is an example for one 
of the packages on one of the clients that experiences the problem:

yumdownloader --verbose kmod-vmware-tools-vmci.x86_64
Loading rhnplugin plugin Config time: 0.063
This system is receiving updates from RHN Classic or Red Hat Satellite.
Looking for repo options for [main]
Looking for repo options for [rhel-x86_64-server-6]
Repo 'rhel-x86_64-server-6' setting option 'enabled' = '1'
Repo 'rhel-x86_64-server-6' setting option 'gpgcheck' = '1'
Looking for repo options for [rhel-x86_64-server-optional-6]
Repo 'rhel-x86_64-server-optional-6' setting option 'enabled' = '1'
Repo 'rhel-x86_64-server-optional-6' setting option 'gpgcheck' = '1'
Looking for repo options for [rhel-server-6-supplementary-x86_64]
Repo 'rhel-server-6-supplementary-x86_64' setting option 'enabled' = '1'
Repo 'rhel-server-6-supplementary-x86_64' setting option 'gpgcheck' = '1'
Looking for repo options for [epel-6-x86_64]
Repo 'epel-6-x86_64' setting option 'enabled' = '1'
Repo 'epel-6-x86_64' setting option 'gpgcheck' = '1'
Looking for repo options for [spacewalk-client-6-x86_64]
Repo 'spacewalk-client-6-x86_64' setting option 'enabled' = '1'
Repo 'spacewalk-client-6-x86_64' setting option 'gpgcheck' = '1'
Looking for repo options for [vmware-tools-6-x86_64]
Repo 'vmware-tools-6-x86_64' setting option 'enabled' = '1'
Repo 'vmware-tools-6-x86_64' setting option 'gpgcheck' = '1'
repo time: 0.000
Setting up Package Sacks pkgsack time: 0.271
rpmdb time: 0.000
Could not download/verify pkg 
kmod-vmware-tools-vmci-9.5.13.0-2.6.32.71.el6.x86_64.5.el6.x86_64: failed to 
retrieve 
getPackage/kmod-vmware-tools-vmci-9.5.13.0-2.6.32.71.el6.x86_64.5.el6.x86_64.rpm
 from vmware-tools-6-x86_64 error was [Errno 14] PYCURL ERROR 22 - The 
requested URL returned error: 416 Requested Range Not Satisfiable

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[cid:image001.png@01CFD40C.A5B43320]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite (tm)

Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent
http://www.peoplefluent.com/

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

[Spacewalk-list] YUM failures: PYCURL ERROR 22 - The requested URL returned error: 416 Requested Range Not Satisfiable

[Boyd, Robert]

I should have said:

I have some servers subscribed to a *spacewalk* server and 3 or 4 servers are 
having this error: error was [Errno 14] PYCURL ERROR 22 - The requested URL 
returned error: 416 Requested Range Not Satisfiable  Does anyone have any 
suggestions?   I tried yum clean all and retry.  This makes no change.

This only happens for certain packages on certain servers. The same packages 
download and install cleanly on many other servers. Here is an example for one 
of the packages on one of the clients that experiences the problem:

yumdownloader --verbose kmod-vmware-tools-vmci.x86_64
Loading rhnplugin plugin Config time: 0.063
This system is receiving updates from RHN Classic or Red Hat Satellite.
Looking for repo options for [main]
Looking for repo options for [rhel-x86_64-server-6]
Repo 'rhel-x86_64-server-6' setting option 'enabled' = '1'
Repo 'rhel-x86_64-server-6' setting option 'gpgcheck' = '1'
Looking for repo options for [rhel-x86_64-server-optional-6]
Repo 'rhel-x86_64-server-optional-6' setting option 'enabled' = '1'
Repo 'rhel-x86_64-server-optional-6' setting option 'gpgcheck' = '1'
Looking for repo options for [rhel-server-6-supplementary-x86_64]
Repo 'rhel-server-6-supplementary-x86_64' setting option 'enabled' = '1'
Repo 'rhel-server-6-supplementary-x86_64' setting option 'gpgcheck' = '1'
Looking for repo options for [epel-6-x86_64]
Repo 'epel-6-x86_64' setting option 'enabled' = '1'
Repo 'epel-6-x86_64' setting option 'gpgcheck' = '1'
Looking for repo options for [spacewalk-client-6-x86_64]
Repo 'spacewalk-client-6-x86_64' setting option 'enabled' = '1'
Repo 'spacewalk-client-6-x86_64' setting option 'gpgcheck' = '1'
Looking for repo options for [vmware-tools-6-x86_64]
Repo 'vmware-tools-6-x86_64' setting option 'enabled' = '1'
Repo 'vmware-tools-6-x86_64' setting option 'gpgcheck' = '1'
repo time: 0.000
Setting up Package Sacks pkgsack time: 0.271
rpmdb time: 0.000
Could not download/verify pkg 
kmod-vmware-tools-vmci-9.5.13.0-2.6.32.71.el6.x86_64.5.el6.x86_64: failed to 
retrieve 
getPackage/kmod-vmware-tools-vmci-9.5.13.0-2.6.32.71.el6.x86_64.5.el6.x86_64.rpm
 from vmware-tools-6-x86_64 error was [Errno 14] PYCURL ERROR 22 - The 
requested URL returned error: 416 Requested Range Not Satisfiable

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

[cid:image001.png@01CFD40C.A5B43320]http://www.peoplefluent.com/
Click herehttp://www.peoplefluent.com/ to experience the power of the new 
PeopleFluent Mirror Suite (tm)

Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: PeopleFluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@PeopleFluenthttp://twitter.com/peoplefluent
http://www.peoplefluent.com/

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

Re: [Spacewalk-list] Support for postgresql 8.4

[Boyd, Robert]

I found some more things that need tweaking.

/etc/sysconfig/rhn/postgres/deploy.sql refers to 
/usr/share/pgsql/contrib/dblink.sql which doesn't exist in postgresql-9.3 in 
that location.   The new location is: 
/usr/pgsql-9.3/share/extension/dblink--1.1.sql
I haven't worked out the format of how that could be fixed inside the deploy 
script since I'm not a SQL programmer.  And this script seems to be generated 
on the fly, so I'm unsure as to where it's coming from.

As suggested by someone else I did go into /etc/sysconfig/rhn/postgres/main.sql 
and modify the problem line

 \i /usr/share/pgsql/contrib./dblink.sql
To
Create extension dblink;

It would be nice to have the script autodetect the version and do the right 
thing.

That got me to the point where I get errors with the tomcat start:

java.io.IOException: Failed to access resource /WEB-INF/lib/jta.jar
at 
org.apache.catalina.loader.WebappLoader.setRepositories(WebappLoader.java:1022)
at org.apache.catalina.loader.WebappLoader.start(WebappLoader.java:653)

So I rummaged around and found a suggestion to
 Yum install geronimo-jta-1.1-api

Also, I had to make more mods to /usr/bin/spacewalk-setup-postgresql and 
install the perl DBD postgresql module:  yum install perl-DBD-Pg
I moved the version detection code block for postgres to an earlier point in 
the  setup script and it now looks like this:

def_regexes
unset -f def_regexes

POSTGRES_SERVICE=postgresql
OIFS=$IFS; IFS=' '; read pgsyn pgformal pgnums  $(psql --version) ; 
IFS=$OIFS
OIFS=$IFS; IFS='.'; read pgvermajor pgverminor pgverpoint  ${pgnums} 
; IFS=$OIFS
case $pgvermajor in
8)
   PG_DATA=/var/lib/pgsql/data
  ;;
*) POSTGRES_SERVICE=${POSTGRES_SERVICE}-${pgvermajor}.${pgverminor}
   PG_DATA=/var/lib/pgsql/${pgvermajor}.${pgverminor}/data
  ;;
esac
PG_HBA=$PG_DATA/pg_hba.conf
PG_IDENT=$PG_DATA/pg_ident.conf

And the section I listed before has the version detection lifted out and is now 
just the version agnostic part:

postgresql_service() {

if [ -e $SPACEWALK_TARGET ] ; then
case $1 in
initdb) postgresql-setup initdb ;;
 *) systemctl $1 ${POSTGRES_SERVICE} ;;
esac
else
case $1 in
enable) chkconfig ${POSTGRES_SERVICE} on ;;
 *) service ${POSTGRES_SERVICE} $1 ;;
esac
fi
}

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CFABFD.EB8EE5C0]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Tuesday, July 29, 2014 1:42 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Support for postgresql  8.4

Also found I needed to change this routine in 
/usr/bin/spacewalk-setup-postgresql

postgresql_service() {
POSTGRES_SERVICE=postgresql
OIFS=$IFS; IFS=' '; read pgsyn pgformal pgnums  $(psql --version) ; 
IFS=$OIFS
OIFS=$IFS; IFS='.'; read pgvermajor pgverminor pgverpoint  ${pgnums} 
; IFS=$OIFS
case $pgvermajor in
8)
  ;;
*) POSTGRES_SERVICE=${POSTGRES_SERVICE}-${pgvermajor}${pgverminor}
  ;;
esac

if [ -e $SPACEWALK_TARGET ] ; then
case $1 in
initdb) postgresql-setup initdb ;;
 *) systemctl $1 ${POSTGRES_SERVICE};;
esac
else
case $1 in
enable) chkconfig postgresql on ;;
 *) service ${POSTGRES_SERVICE} $1 ;;
esac
fi
}

After all those changes I did this:

spacewalk-setup --disconnected 
--answer-file=/root/answer-files/spacewalk-configure  --clear-db

And presto!  I have the service up and running and I managed to login and 
initialize the administrator account.

Hopefully this will help someone else put all the pieces together, and maybe we 
can update the setup components to do these pieces automatically when 
PostgreSQL 9 or later is installed.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CFABFD.EB8EE5C0]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: 
spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert

Re: [Spacewalk-list] Support for postgresql 8.4

[Boyd, Robert]

Also found I needed to change this routine in 
/usr/bin/spacewalk-setup-postgresql

postgresql_service() {
POSTGRES_SERVICE=postgresql
OIFS=$IFS; IFS=' '; read pgsyn pgformal pgnums  $(psql --version) ; 
IFS=$OIFS
OIFS=$IFS; IFS='.'; read pgvermajor pgverminor pgverpoint  ${pgnums} 
; IFS=$OIFS
case $pgvermajor in
8)
  ;;
*) POSTGRES_SERVICE=${POSTGRES_SERVICE}-${pgvermajor}${pgverminor}
  ;;
esac

if [ -e $SPACEWALK_TARGET ] ; then
case $1 in
initdb) postgresql-setup initdb ;;
 *) systemctl $1 ${POSTGRES_SERVICE};;
esac
else
case $1 in
enable) chkconfig postgresql on ;;
 *) service ${POSTGRES_SERVICE} $1 ;;
esac
fi
}

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CFAB30.8ABD10A0]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Friday, July 25, 2014 3:52 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Support for postgresql  8.4

Here's what I replaced it with:

sub postgresql_start {
  my $postgres_version = `psql --version`;
  my ( $pName, $Official_Name, $pVersion ) = split  , $postgres_version;
  my ( $psql_Major,$psql_Minor,$psql_Point) = split /\./, $pVersion ;

SWITCH: {
if ( $psql_Major =~ /8/) { $psql_service_name = postgresql; last 
SWITCH }
if ( $psql_Major =~ /9/) { $psql_service_name = 
postgresql-.$psql_Major.$psql_Minor; last SWITCH }
 }

system('service $psql_service_name status /dev/null');
system('service $psql_service start /dev/null') if ($?  8);
return ($?  8);
}

Monday I'll be trying it out.   I expect to find some issues in shell scripts 
that need the same kind of version detection.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CFAB30.8ABD10A0]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: 
spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Coffman, Anthony J
Sent: Friday, July 25, 2014 12:54 PM
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Support for postgresql  8.4

Robert - just wanted to let you know I appreciate you blazing this trail.  I'm 
watching this thread with interest.  I want to make the same move with Postgres 
but don't have a lot of time to invest in working through these issues.

I think the relevant file is /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm

It's got these hardcoded service references


sub postgresql_start {
system('service postgresql status /dev/null');
system('service postgresql start /dev/null') if ($?  8);
return ($?  8);
}


--Tony



From: 
spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Friday, July 25, 2014 11:28 AM
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Support for postgresql  8.4

I just re-read the report from 2012 and finally understood what Jan logged 
against that ticket:

After re-reading that I did the following:

yum deplist spacewalk-postgresql
Loaded plugins: downloadonly, product-id, refresh-packagekit, rhnplugin, 
security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
This system is receiving updates from RHN Classic or Red Hat Satellite.
rhel-6-server-extras-rpms   
 | 2.6 kB   
  00:00
rhel-6-server-optional-rpms 
 | 3.5 kB   
  00:00
rhel-6-server-rhn-tools-rpms
 | 2.9 kB   
  00:00
rhel-6-server-rpms  
 | 3.7 kB   
  00:00
rhel-6-server

Re: [Spacewalk-list] Support for postgresql 8.4

[Boyd, Robert]

 of postgresql, extract the version number and select where to find 
the files necessary based on the version.

I'll be happy to have a go at it if I can figure out where the routines are 
that handle that.  At least perl is in my skillset.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CFA731.D7E5C730]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Jonathan Hoser
Sent: Thursday, July 24, 2014 11:00 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Support for postgresql  8.4

Hi Robert,

I faced the same issues (I think) - if I remember correctly;

I think I faked it,
by installing Postgres 8.x (from the default repos)
then getting 9.1 (for me) from postgres-repos

and then (re-)moving/hiding the 8.4 binaries.
Needed to take care of a bunch of Jars (9.x connectors etc)
but that was it...

If you want more details,
I might be able to tell you on Monday...
Best
-Jonathan

On 07/24/2014 04:38 PM, Boyd, Robert wrote:
Bedankt  for the suggestion Andreas,

It appears that someone previously - in 2012 logged a report about this very 
same problem with the installation procedure.

The installation guide on the wiki states:  Spacewalk uses database server to 
store its primary data. It supports either PostgreSQL (version 8.4 and higher) 
or Oracle RDBMS (version 10g or higher).  Unfortunately the rpm needs some 
help to differentiate when something higher than 8.4 is actually installed.   
As far as I can tell from what I read in the response to the bug report, the 
problem is that the RPM is looking for 8.4 specific files and needs to be 
updated to include handling the changes implemented for 9 and above.

Creating and managing RPMs is not in my current skillset - I would rather not 
spend my time learning how to do that when I won't be doing that as a regular 
thing.  It looks like I'd have to find the source of the spacewalk rpm to 
discover exactly how it's coded and how it's specifying the postgresql 
dependencies.  Then I could put together a fakeout rpm as a companion to the 
postgresql9x rpms that would provide the missing metadata to fake out the 
spacewalk rpm.

Seems like it would be a much easier effort for someone already well familiar 
with the spacewalk rpm construction to make the mods necessary to handle 
postgresql9x.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CFA731.D7E5C730]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: 
spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Andreas Dijkman
Sent: Thursday, July 24, 2014 3:12 AM
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] upgrading postgres (8.4  9.x) on the spacewalk 
server ?

Hi,

The RPM isn't actually looking at the file but at the file specs of all 
available RPM's. You need to install and rpm that provides the binary 
/usr/bin/psql in it's metadata. You could build an metadata-only-rpm that 
depends on all the postgresql-9.x-stuff and provides the necessary files in 
it's metadata and secretly creates symlinks underneath.

Met vriendelijke groet,

Andreas Dijkman
Oracle Technical Consultant
Phone: +31(0)50-210 0132 | Mobile: +31(0)6-8115 2982
Cygnishttp://www.cygnis.nl/ | Stationsweg 3B | 9726 AC Groningen
Op maandag afwezig

On 23 Jul, 2014, at 23:42 , Boyd, Robert 
robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com wrote:

I tried changing the link for /usr/bin/psql to directly link to the binary.  
That didn't help.

I tried removing the link and copying the binary to /usr/bin/psql -- that 
didn't help either.

I take it this means that the error message I'm getting isn't telling me the 
truth about what the real error is.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

-Original Message-
From: Boyd, Robert
Sent: Wednesday, July 23, 2014 5:33 PM
To: 'spacewalk-list@redhat.commailto:spacewalk-list@redhat.com'
Subject: RE: [Spacewalk-list] upgrading postgres (8.4  9.x) on the spacewalk 
server ?

I'm attempting an install of spacewalk

Re: [Spacewalk-list] Support for postgresql 8.4

[Boyd, Robert]

Here's what I replaced it with:

sub postgresql_start {
  my $postgres_version = `psql --version`;
  my ( $pName, $Official_Name, $pVersion ) = split  , $postgres_version;
  my ( $psql_Major,$psql_Minor,$psql_Point) = split /\./, $pVersion ;

SWITCH: {
if ( $psql_Major =~ /8/) { $psql_service_name = postgresql; last 
SWITCH }
if ( $psql_Major =~ /9/) { $psql_service_name = 
postgresql-.$psql_Major.$psql_Minor; last SWITCH }
 }

system('service $psql_service_name status /dev/null');
system('service $psql_service start /dev/null') if ($?  8);
return ($?  8);
}

Monday I'll be trying it out.   I expect to find some issues in shell scripts 
that need the same kind of version detection.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CFA820.4458BDC0]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Coffman, Anthony J
Sent: Friday, July 25, 2014 12:54 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Support for postgresql  8.4

Robert - just wanted to let you know I appreciate you blazing this trail.  I'm 
watching this thread with interest.  I want to make the same move with Postgres 
but don't have a lot of time to invest in working through these issues.

I think the relevant file is /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm

It's got these hardcoded service references


sub postgresql_start {
system('service postgresql status /dev/null');
system('service postgresql start /dev/null') if ($?  8);
return ($?  8);
}


--Tony



From: 
spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Friday, July 25, 2014 11:28 AM
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Support for postgresql  8.4

I just re-read the report from 2012 and finally understood what Jan logged 
against that ticket:

After re-reading that I did the following:

yum deplist spacewalk-postgresql
Loaded plugins: downloadonly, product-id, refresh-packagekit, rhnplugin, 
security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
This system is receiving updates from RHN Classic or Red Hat Satellite.
rhel-6-server-extras-rpms   
 | 2.6 kB   
  00:00
rhel-6-server-optional-rpms 
 | 3.5 kB   
  00:00
rhel-6-server-rhn-tools-rpms
 | 2.9 kB   
  00:00
rhel-6-server-rpms  
 | 3.7 kB   
  00:00
rhel-6-server-supplementary-rpms
 | 3.7 kB   
  00:00
Finding dependencies:
package: spacewalk-postgresql.noarch 2.2.2-1.el6
  dependency: /usr/bin/psql
   Unsatisfied .  dependency
  dependency: postgresql = 8.4
   provider: postgresql93.x86_64 9.3.4-1PGDG.rhel6
   provider: postgresql93.x86_64 9.3.3-1PGDG.rhel6
   provider: postgresql93.x86_64 9.3.5-1PGDG.rhel6
  dependency: postgresql-contrib = 8.4
   provider: postgresql93-contrib.x86_64 9.3.4-1PGDG.rhel6
   provider: postgresql93-contrib.x86_64 9.3.5-1PGDG.rhel6
   provider: postgresql93-contrib.x86_64 9.3.3-1PGDG.rhel6
  dependency: spacewalk-common = 2.2.2-1.el6
   provider: spacewalk-common.noarch 2.2.2-1.el6
  dependency: perl(DBD::Pg)
   provider: perl-DBD-Pg.x86_64 2.15.1-3.el6
   provider: perl-DBD-Pg.x86_64 2.15.1-4.el6_3
   provider: perl-DBD-Pg.x86_64 2.15.1-4.el6_3
   provider: perl-DBD-Pg.x86_64 2.15.1-3.el6
  dependency: spacewalk-backend-sql-postgresql
   provider: spacewalk-backend-sql-postgresql.noarch 2.2.43-1.el6
  dependency: spacewalk-java-postgresql
   provider: spacewalk-java-postgresql.noarch 2.2.123-1.el6

After this I manually selected the listed items:  yum install 
postgresql93-contrib spacewalk-common perl-DBD-Pg 
spacewalk-backend-sql-postgresql spacewalk-java-postgresql

If Jan's statement about the master package is correct then I've successfully 
installed all of the components.

I found the messages from the list about taking care of the jdbc and did all 
those fixes too

[Spacewalk-list] Support for postgresql 8.4

[Boyd, Robert]

Bedankt  for the suggestion Andreas,

It appears that someone previously - in 2012 logged a report about this very 
same problem with the installation procedure.

The installation guide on the wiki states:  Spacewalk uses database server to 
store its primary data. It supports either PostgreSQL (version 8.4 and higher) 
or Oracle RDBMS (version 10g or higher).  Unfortunately the rpm needs some 
help to differentiate when something higher than 8.4 is actually installed.   
As far as I can tell from what I read in the response to the bug report, the 
problem is that the RPM is looking for 8.4 specific files and needs to be 
updated to include handling the changes implemented for 9 and above.

Creating and managing RPMs is not in my current skillset - I would rather not 
spend my time learning how to do that when I won't be doing that as a regular 
thing.  It looks like I'd have to find the source of the spacewalk rpm to 
discover exactly how it's coded and how it's specifying the postgresql 
dependencies.  Then I could put together a fakeout rpm as a companion to the 
postgresql9x rpms that would provide the missing metadata to fake out the 
spacewalk rpm.

Seems like it would be a much easier effort for someone already well familiar 
with the spacewalk rpm construction to make the mods necessary to handle 
postgresql9x.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CFA72A.365A8240]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Andreas Dijkman
Sent: Thursday, July 24, 2014 3:12 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] upgrading postgres (8.4  9.x) on the spacewalk 
server ?

Hi,

The RPM isn't actually looking at the file but at the file specs of all 
available RPM's. You need to install and rpm that provides the binary 
/usr/bin/psql in it's metadata. You could build an metadata-only-rpm that 
depends on all the postgresql-9.x-stuff and provides the necessary files in 
it's metadata and secretly creates symlinks underneath.

Met vriendelijke groet,

Andreas Dijkman
Oracle Technical Consultant
Phone: +31(0)50-210 0132 | Mobile: +31(0)6-8115 2982
Cygnishttp://www.cygnis.nl/ | Stationsweg 3B | 9726 AC Groningen
Op maandag afwezig

On 23 Jul, 2014, at 23:42 , Boyd, Robert 
robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com wrote:


I tried changing the link for /usr/bin/psql to directly link to the binary.  
That didn't help.

I tried removing the link and copying the binary to /usr/bin/psql -- that 
didn't help either.

I take it this means that the error message I'm getting isn't telling me the 
truth about what the real error is.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

-Original Message-
From: Boyd, Robert
Sent: Wednesday, July 23, 2014 5:33 PM
To: 'spacewalk-list@redhat.commailto:spacewalk-list@redhat.com'
Subject: RE: [Spacewalk-list] upgrading postgres (8.4  9.x) on the spacewalk 
server ?

I'm attempting an install of spacewalk 2.2 using postgresql-9.3.

I installed and manually configured postgresql.

When I attempt to install spacewalk I get this error:

 yum install spacewalk-postgresql

 ... many dependencies resolved ... etc ...

 Error: Package: spacewalk-postgresql-2.2.2-1.el6.noarch (spacewalk)
  Requires: /usr/bin/psql

However there is clearly something there:

[root ~]# ll /usr/bin/psql
lrwxrwxrwx. 1 root root 28 Jul 21 12:35 /usr/bin/psql - 
/etc/alternatives/pgsql-psql

[root ~]# ll /etc/alternatives/pgsql-psql
lrwxrwxrwx. 1 root root 23 Jul 21 12:35 /etc/alternatives/pgsql-psql - 
/usr/pgsql-9.3/bin/psql

[root ~]# ll /usr/pgsql-9.3/bin/psql
-rwxr-xr-x. 1 root root 447560 Mar 18 03:19 /usr/pgsql-9.3/bin/psql

What is this package expecting to find there?  Is a symbolic link not good 
enough?  Can I fake it out by copying over the real binary or changing the link 
to point directly to the binary instead of an intermediate link?


Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com

___
Spacewalk-list mailing list
Spacewalk-list@redhat.commailto: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

Re: [Spacewalk-list] upgrading postgres (8.4 9.x) on the spacewalk server ?

[Boyd, Robert]

I'm attempting an install of spacewalk 2.2 using postgresql-9.3.  

I installed and manually configured postgresql.

When I attempt to install spacewalk I get this error:

  yum install spacewalk-postgresql

  ... many dependencies resolved ... etc ...

  Error: Package: spacewalk-postgresql-2.2.2-1.el6.noarch (spacewalk)
   Requires: /usr/bin/psql

However there is clearly something there:

[root ~]# ll /usr/bin/psql
lrwxrwxrwx. 1 root root 28 Jul 21 12:35 /usr/bin/psql - 
/etc/alternatives/pgsql-psql
[root ~]# ll /etc/alternatives/pgsql-psql
lrwxrwxrwx. 1 root root 23 Jul 21 12:35 /etc/alternatives/pgsql-psql - 
/usr/pgsql-9.3/bin/psql
[root ~]# ll /usr/pgsql-9.3/bin/psql
-rwxr-xr-x. 1 root root 447560 Mar 18 03:19 /usr/pgsql-9.3/bin/psql

What is this package expecting to find there?  Is a symbolic link not good 
enough?  Can I fake it out by copying over the real binary or changing the link 
to point directly to the binary instead of an intermediate link?


Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

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

Re: [Spacewalk-list] upgrading postgres (8.4 9.x) on the spacewalk server ?

[Boyd, Robert]

I tried changing the link for /usr/bin/psql to directly link to the binary.  
That didn't help. 

I tried removing the link and copying the binary to /usr/bin/psql -- that 
didn't help either. 

I take it this means that the error message I'm getting isn't telling me the 
truth about what the real error is.

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

-Original Message-
From: Boyd, Robert 
Sent: Wednesday, July 23, 2014 5:33 PM
To: 'spacewalk-list@redhat.com'
Subject: RE: [Spacewalk-list] upgrading postgres (8.4  9.x) on the spacewalk 
server ?

I'm attempting an install of spacewalk 2.2 using postgresql-9.3.  

I installed and manually configured postgresql.

When I attempt to install spacewalk I get this error:

  yum install spacewalk-postgresql

  ... many dependencies resolved ... etc ...

  Error: Package: spacewalk-postgresql-2.2.2-1.el6.noarch (spacewalk)
   Requires: /usr/bin/psql

However there is clearly something there:

[root ~]# ll /usr/bin/psql
lrwxrwxrwx. 1 root root 28 Jul 21 12:35 /usr/bin/psql - 
/etc/alternatives/pgsql-psql 

[root ~]# ll /etc/alternatives/pgsql-psql 
lrwxrwxrwx. 1 root root 23 Jul 21 12:35 /etc/alternatives/pgsql-psql - 
/usr/pgsql-9.3/bin/psql 

[root ~]# ll /usr/pgsql-9.3/bin/psql 
-rwxr-xr-x. 1 root root 447560 Mar 18 03:19 /usr/pgsql-9.3/bin/psql

What is this package expecting to find there?  Is a symbolic link not good 
enough?  Can I fake it out by copying over the real binary or changing the link 
to point directly to the binary instead of an intermediate link?


Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

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

Re: [Spacewalk-list] upgrading postgres (8.4 9.x) on the spacewalk server ?

[Boyd, Robert]

Andy,

When you do the upgrade I'd like to hear what if any details you discover that 
you have to work through that deviate from the postgres docs.  I'd like to make 
the same upgrade.  I looked at it a few months ago and decided to wait a while 
before tackling it.

Thanks,

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
e. robert.b...@peoplefluent.com

Visit: www.peoplefluent.com | Read: Peoplefluent Blog | Follow: @peoplefluent | 
Download: iPad App

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Andy Ingham
Sent: Monday, July 14, 2014 10:02 AM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] upgrading postgres (8.4  9.x) on the spacewalk 
server ?

Folks --

Any particular gotchas about attempting to upgrade the postgresql server for 
our spacewalk installation?  It's at version 8.4 and we'd like to get it into 
the 9.x series.

I'm assuming it should just be done according to the postgres docs?

TIA,
Andy


Andy Ingham
IT Infrastructure
Fuqua School of Business
Duke University

___
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

Re: [Spacewalk-list] No packages found by yum although there are packages in Spacewalk

[Boyd, Robert]

See if this archived message from April 3 2013 is what you need:


I came across this, when several repos were to be rebuild - especially for 
several very full fedora repo (25000 rpms);



The only way around that were

a) adding a bit more RAM to the taskomatic-java and

b) increasing timeout-values:



# Maximum Java Heap Size (in MB)

wrapper.java.maxmemory=4096



wrapper.ping.timeout=36000

wrapper.ping.interval=100



(In the config file, that I always forget the whereabouts - finally found it:) 
/usr/share/rhn/config-defaults/rhn_taskomatic_daemon.conf



Also refer to

http://wrapper.tanukisoftware.com/doc/english/properties.html for how-tos




Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CF99D6.7F050440]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Ning Zhang
Sent: Monday, July 07, 2014 10:51 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] No packages found by yum although there are 
packages in Spacewalk

Paul,

How can I give taskomatic 2Gb of ram? Here is its new log:

# tail rhn_taskomatic_daemon.log
INFO   | jvm 1| 2014/07/07 10:32:00 |   Copyright 1999-2006 Tanuki 
Software, Inc.  All Rights Reserved.
INFO   | jvm 1| 2014/07/07 10:32:00 |
INFO   | jvm 1| 2014/07/07 10:32:11 | Jul 7, 2014 10:32:11 AM 
com.mchange.v2.log.MLog clinit
INFO   | jvm 1| 2014/07/07 10:32:11 | INFO: MLog clients using java 1.4+ 
standard logging.
INFO   | jvm 1| 2014/07/07 10:32:12 | Jul 7, 2014 10:32:12 AM 
com.mchange.v2.c3p0.C3P0Registry banner
INFO   | jvm 1| 2014/07/07 10:32:12 | INFO: Initializing c3p0-0.9.1.2 
[built 06-August-2008 15:35:00; debug? false; trace: 5]
INFO   | jvm 1| 2014/07/07 10:32:12 | Jul 7, 2014 10:32:12 AM 
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
INFO   | jvm 1| 2014/07/07 10:32:12 | INFO: Initializing c3p0 pool... 
com.mchange.v2.c3p0.PoolBackedDataSource@5af97a6emailto:com.mchange.v2.c3p0.PoolBackedDataSource@5af97a6e
 [ connectionPoolDataSource - 
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@f2437ebdmailto:com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@f2437ebd
 [ acquireIncrement - 3, acquireRetryAttempts - 30, acquireRetryDelay - 
1000, autoCommitOnClose - false, automaticTestTable - null, 
breakAfterAcquireFailure - false, checkoutTimeout - 0, 
connectionCustomizerClassName - null, connectionTesterClassName - 
com.mchange.v2.c3p0.impl.DefaultConnectionTester, 
debugUnreturnedConnectionStackTraces - false, factoryClassLocation - null, 
forceIgnoreUnresolvedTransactions - false, identityToken - 
1bqr9az934s74cpo6sq9b|63e5414a, idleConnectionTestPeriod - 300, 
initialPoolSize - 5, maxAdministrativeTaskTime - 0, maxConnectionAge - 0, 
maxIdleTime - 300, maxIdleTimeExcessConnections - 0, maxPoolSize - 20, 
maxStatements - 0, maxStatementsPerConnection - 0, minPoolSize - 5, 
nestedDataSource - 
com.mchange.v2.c3p0.DriverManagerDataSource@5b6f75d4mailto:com.mchange.v2.c3p0.DriverManagerDataSource@5b6f75d4
 [ description - null, driverClass - null, factoryClassLocation - null, 
identityToken - 1bqr9az934s74cpo6sq9b|45c7fa1a, jdbcUrl - 
jdbc:postgresql://gdcusap83.corp.towerautomotive.com:5432/spacewalkhttp://gdcusap83.corp.towerautomotive.com:5432/spacewalk,
 properties - {user=**, password=**, driver_proto=jdbc:postgresql} ], 
preferredTestQuery - null, propertyCycle - 0, testConnectionOnCheckin - 
false, testConnectionOnCheckout - true, unreturnedConnectionTimeout - 0, 
usesTraditionalReflectiveProxies - false; userOverrides: {} ], dataSourceName 
- null, factoryClassLocation - null, identityToken - 
1bqr9az934s74cpo6sq9b|3d4b307a, numHelperThreads - 3 ]
INFO   | jvm 1| 2014/07/07 10:32:16 | 2014-07-07 10:32:16,715 [Thread-43] 
WARN  com.redhat.rhn.taskomatic.core.SchedulerKernel - Reinitializing 
errata-cache-default, found 1 runs in the future.
INFO   | jvm 1| 2014/07/07 10:32:17 | 2014-07-07 10:32:17,049 [Thread-43] 
ERROR com.redhat.rhn.common.hibernate.ConnectionManager - 
org.hibernate.TransactionException: Transaction not successfully started

Thanks..
NZ


On Tue, Jul 1, 2014 at 11:19 AM, Paul Robert Marino 
prmari...@gmail.commailto:prmari...@gmail.com wrote:
check the rhntaskomatic log for errors
also see if a repodata task is hung from the spacewalk interface.

The most common causes of this is either you ran out of database
connections or taskomatic doesnt have enough working memeory.
I have found that in the latest version of spacewalk you need to give
taskomatic 2Gb of ram however the default 

Re: [Spacewalk-list] Mutli distro kickstart issue.

[Boyd, Robert]

Paul Robert Marino,

This sounds intriguing.

You say you hesitate to write it out completely.   I'm wondering if you could 
give some hints as to how to start the little research. 
There are a couple of things you've mentioned before where you've said 
something like this about issues I'm interested in.   I could definitely use 
some hints about how to pursue things like this.  What tools/knowledge are 
required to start?  And where does one begin from?  I find it's easy to wind up 
chasing down many rabbit holes with little return other than learning about a 
great many things I don't need much for the time spent without some guidance.  

Thanks,

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com





Visit: www.peoplefluent.com | Read: Peoplefluent Blog | Follow: @peoplefluent | 
Download: iPad App


-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Tuesday, July 01, 2014 1:57 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Mutli distro kickstart issue.

...

Unfortunately the core API issue has never been fixed althouth the new method 
of syncing erratas via the yum repo does not seem to be effected by this so 
where possible try to use that method instead. the problem is CentOS hasn't 
adopted this method and I'm not sure about Oracle.
RHEL its pretty easy now to get the erratas using the new method if you do a 
little research although I hesitate to write it out for you completely.

...



On Tue, Jul 1, 2014 at 11:39 AM, Canalichio, Kevin 
canalic...@jmail.metronaviation.com wrote:
 I have set up my spacewalk server to have Redhat, Centos, and Oracle 
 linux distros available for kickstart.

 When kickstarting I will get the following error:



   “ The file libart_lgpl-2.3.20-5.1.el6.x86_64 cannot be opened. This 
 is due to a missing file, a corrupted package or corrupted media.”



 The problem occurs because the md5 checksums are different for the 
 same package name in the each of the different distros. I read 
 somewhere that the satellite server uses some sort of dedup or links 
 to not have multiple copies of the same file, which seems to work fine 
 for updates, but not so well for kickstarts.



 I can fix this problem by clearing out all three the repos and 
 resyncing the one I want to kickstart. But it take a while for the repo to 
 rsync.



 I have also found this bug report that no one seems to be working on
 http://bugs.centos.org/view.php?id=6977 which references this from the 
 archive 
 https://www.redhat.com/archives/spacewalk-list/2014-February/msg00048.
 html



 Has anyone else seen this, or have a better work around?


 ___
 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 mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk Systems Physical Systems ?

[Boyd, Robert]

I’m confused by your reply.   I’m not talking about RHEL6.   I’m talking about 
CentOS/RHEL4.  The repository for CentOS4 seems to have been killed or moved.  
The wiki page refers to this:

# rpm -ivh 
http://stahnma.fedorapeople.org/spacewalk-tools/spacewalk-client-tools-0.0-1.noarch.rpm
Well …. There is no stahnma.fedorapeople.org anymore.   Would someone care to 
update this information to either declare where this repository now lives or 
declare that there is no longer any support for RHEL4 client tools?  I must 
admit I’m a bit puzzled about why this is still in the wiki.

I looked at the repo config on one of these RHEL4 servers and see this:

Ø  rpm -q --filesbypkg spacewalk-client-tools
spacewalk-client-tools/etc/pki/rpm-gpg/SPACEWALK-CLIENT-TOOLS-RPM-GPG-KEY
spacewalk-client-tools/etc/yum.repos.d/GPL
spacewalk-client-tools/etc/yum.repos.d/spacewalk-client-tools.repo
spacewalk-client-tools/usr/share/doc/spacewalk-client-tools-0.0
spacewalk-client-tools/usr/share/doc/spacewalk-client-tools-0.0/GPL


Ø  less /etc/yum.repos.d/spacewalk-client-tools.repo
[spacewalk-client-tools]
name=Spacewalk Client Tools - $basearch
baseurl=http://stahnma.fedorapeople.org/spacewalk-tools/$releasever/$basearch
failovermethod=priority
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/SPACEWALK-CLIENT-TOOLS-RPM-GPG-KEY

[spacewalk-client-tools-source]
name=Extra Packages for Enterprise Linux 5 - $basearch - Source
baseurl=http://stahnma.fedorapeople.org/spacewalk-tools/$releasever/SRPMS
failovermethod=priority
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/SPACEWALK-CLIENT-TOOLS-RPM-GPG-KEY
gpgcheck=1



Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CF91FB.03533FC0]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Justin Edmands
Sent: Thursday, June 26, 2014 5:04 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk Systems Physical Systems ?

on the client run /usr/sbin/rhn-profile-sync.
If that fails, run a yum whatprovides /usr/sbin/rhn-profile-sync -or- rpm 
-qf /usr/sbin/rhn-profile-sync. Install the corresponding package as it may 
have been originally packaged separate of rhn-client-tools.

in my case, the result is:

rhn-client-tools-1.9.10-1.el6.noarch : Support programs and libraries for Red 
Hat Network or Spacewalk
Repo: spacewalk-client
Matched from:
Filename: /usr/sbin/rhn-profile-sync

a quick google showed that someone originally made the client tools and 
published to fedoraproject for rhel4/5. http://en.it-usenet.org/thread/19251/15/

On Thu, Jun 26, 2014 at 4:43 PM, Boyd, Robert 
robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com wrote:
I tried hardware refresh followed by rhn_check on the client.   I tried delete 
and reregister.   I’m not sure what this rhn-profile-sync is that you refer to. 
  Some of these servers are on RHEL4 and I don’t see anything named like that.

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972tel:919-645-2972 | c. 919-306-4681tel:919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CF91FB.03533FC0]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8



From: 
spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com]
 On Behalf Of Matthew Madey
Sent: Thursday, June 26, 2014 3:50 PM
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk Systems Physical Systems ?


I believe it uses dmidecode information to make the determination. Have you 
tried scheduling a hardware refresh in the GUI for the affected systems? You 
can also do rhn-profile-sync locally on the system
On Jun 26, 2014 2:09 PM, Boyd, Robert 
robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com wrote:
How does Spacewalk determine that a server is physical when selecting the 
Systems - Physical Systems button?

I have a few former physical servers that were virtualized.   I tried 
re-registering them.This succeeded in changing the status of some of them 
from physical to virtual, but there are an equal number that are still being 
flagged as physical, even though I can see when I click on the Hardware tab for 
each

Re: [Spacewalk-list] Spacewalk Systems Physical Systems ?

[Boyd, Robert]

If this is in fact the case, the wiki should clearly indicate that.   The 
current information in the wiki about this is clearly wrong now.

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com





Visit: www.peoplefluent.com | Read: Peoplefluent Blog | Follow: @peoplefluent | 
Download: iPad App


-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Dimitri Yioulos
Sent: Friday, June 27, 2014 12:42 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk Systems Physical Systems ?



RHEL4/CentOS 4 was EOL'd some time ago.  I'd be extremely surprised if there 
were any
repos out there that still support it.

Dimitri

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

___
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] Spacewalk Systems Physical Systems ?

[Boyd, Robert]

How does Spacewalk determine that a server is physical when selecting the 
Systems - Physical Systems button?

I have a few former physical servers that were virtualized.   I tried 
re-registering them.This succeeded in changing the status of some of them 
from physical to virtual, but there are an equal number that are still being 
flagged as physical, even though I can see when I click on the Hardware tab for 
each of them that VMware is the manufacturer.

Any pointers to clearing this up would be appreciated.

Thanks,

Robert Boyd
Sr. Systems Engineer
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com


[cid:image001.png@01CF914F.CDDD73C0]http://www.peoplefluent.com/



Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog | Follow: 
@peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8


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

Re: [Spacewalk-list] Spacewalk and CentOS / RHEL 7

[Boyd, Robert]

Now that RHEL 7 Beta/RC is on the street, what can anyone say about how we can 
plan for integrating the update streams into spacewalk?

Has anyone on the list already experimented with this to see how one can pull 
in the repositories for RHEL 7?

Robert Boyd
Sr. Systems Engineer 
PeopleFluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Wednesday, January 15, 2014 5:00 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk and CentOS / RHEL 7

Well no one from Red Hat will ever really give you a strait answer on any thing 
like this unless you've signed a NDA and talk to them off the list.
What I can tell you the spacewalk 2.1 code currently in development already 
supports deploying RHEL 7 servers and virtual machines. I havent tested it yet 
but since the clients and server both compile and run just fine on the latest 
version of Fedora I don't see any reason why it wouldn't support being 
installed on RHEL 7.




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

[Spacewalk-list] Relationship between Katello and Spacewalk

[Boyd, Robert]

I'm curious if someone in the know can say something definitive about what's 
happening with Katello and RHN/Spacewalk relative to each other?  The reading 
I've done so far leaves me curious and confused about the roadmap ahead.

Robert Boyd
Senior Systems Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:michael.dileona...@peoplefluent.com
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog
Follow: @peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8
[cid:image001.png@01CF477C.A7313350]
[cid:image002.png@01CF477C.A7313350]

inline: image001.pnginline: image002.png___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Client machine update issue without internet

[Boyd, Robert]

Dhaval,

I see that the yum repolist is failing to display the server that it's 
connecting to.  You either are not cleanly registered and/or you have 
extraneous information in some of the configuration files in /etc/yum.repos.d

I suggest you try adding an entry in /etc/hosts on the client for the master 
using the same name that the master uses in DNS.  Be sure to put in the FQDN 
and the short alias form with just the name.

Then try re-registering the client as Lukas was suggesting.

After you re-register using the name instead of the IP number, please try:

Verify on the master that the client is registered.Make sure to remove any 
duplicate entry from before that is no longer communicating.  Then:

Yum clean all
Yum repolist --verbose

See what you get then.

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Dhaval Oza
Sent: Tuesday, March 18, 2014 8:18 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Client machine update issue without internet

Robert,

We are not use /etc/hosts file on client side for resolving name (my spacewalk 
server ip is 192.168.12.52), as per your instruction we are remove gateway IP,  
when I trigger route -n and yum repolist --verbose it display below.

root@testspacewalk ~]# route -n
Kernel IP routing table
Destination Gateway Genmask Flags Metric RefUse Iface
192.168.12.00.0.0.0 255.255.255.0   U 1  00 eth0
192.168.122.0   0.0.0.0 255.255.255.0   U 0  00 virbr0
[root@testspacewalk ~]#
[root@testspacewalk ~]#
[root@testspacewalk ~]#
[root@testspacewalk ~]# yum repolist --verbose Loading rhnplugin plugin 
Loading fastestmirror plugin Loading refresh-packagekit plugin Loading 
security plugin Config time: 0.075 This system is receiving updates from RHN 
Classic or Red Hat Satellite.
Looking for repo options for [main]
Looking for repo options for [centos-6.4-x86_64-base] Repo 
'centos-6.4-x86_64-base' setting option 'enabled' = '1'
Repo 'centos-6.4-x86_64-base' setting option 'gpgcheck' = '1'
Yum Version: 3.2.29
Loading mirror speeds from cached hostfile
Error: Cannot retrieve metalink for repository: epel. Please verify its path 
and try again [root@testspacewalk ~]#

Awaiting your help,

Thanks and Regards,
Dhaval Oza



- Original Message -
From: Robert Boyd robert.b...@peoplefluent.com
To: spacewalk-list@redhat.com
Sent: Monday, March 17, 2014 8:58:53 PM
Subject: Re: [Spacewalk-list] Client machine update issue without internet

Dhaval,

So do you use /etc/hosts on the client to provide a name/IP address match for 
the spacewalk master server?
When you say you removed the gateway IP, do you have any routes in your route 
table?  What does route -n show?

Also, what do you get when you do this command:

  yum repolist --verbose

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Dhaval Oza
Sent: Friday, March 14, 2014 8:46 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Client machine update issue without internet

Hi Lukas,

Yes the client connects to spacewalk server locally, on a LAN, and it has 
network connection for communication with the spacewalk server. 

What I mean by stopping internet connection is the following:

I removed gateway IP on client side machines.
I removed DNS IPs on client side machines.

This is needed to be done since our requirement is that no client should be 
able to connect to internet, however they should be able to connect to 
spacewalk server.

I hope this makes it clear.

Awaiting your help,

Thanks and Regards,
Dhaval



- Original Message -
From: Lukas Pramuk lpra...@redhat.com
To: spacewalk-list@redhat.com
Sent: Thursday, March 13, 2014 9:09:15 PM
Subject: Re: [Spacewalk-list] Client machine update issue without internet

Hi,
I assume that the client connects to spacewalk server locally, on a LAN.
So the client needs network connection for communication with the spacewalk 
server.

What you mean with stop internet connection on client?
How do you do that?

Regards,

Lukas Pramuk
Systems Management QA, Red Hat


On 03/13/2014 03:56 PM, Dhaval Oza wrote:
 Dear Sir,

 We have configured and installed  Spacewalk Server 2.2  nightly on 
 Centos 6.5  spacewalk client machine. All things are working 
 perfectly fine on server side also the client side tool has been 
 installed on server to communicate with client machine with activation 
 key for getting updates from spacewalk server but the problem is when 
 i stop internet connection on client machine we are not getting any 
 updates and also when I trigger yum repolist command on client 
 machine it shows  0 packages available.

 My problem is what to configure on client machine so I can get all the 
 updates from spacewalk server without internet connection.

 And also let me know what to do on 

Re: [Spacewalk-list] Client machine update issue without internet

[Boyd, Robert]

Dhaval,

So do you use /etc/hosts on the client to provide a name/IP address match for 
the spacewalk master server?
When you say you removed the gateway IP, do you have any routes in your route 
table?  What does route -n show?

Also, what do you get when you do this command:

  yum repolist --verbose

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Dhaval Oza
Sent: Friday, March 14, 2014 8:46 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Client machine update issue without internet

Hi Lukas,

Yes the client connects to spacewalk server locally, on a LAN, and it has 
network connection for communication with the spacewalk server. 

What I mean by stopping internet connection is the following:

I removed gateway IP on client side machines.
I removed DNS IPs on client side machines.

This is needed to be done since our requirement is that no client should be 
able to connect to internet, however they should be able to connect to 
spacewalk server.

I hope this makes it clear.

Awaiting your help,

Thanks and Regards,
Dhaval



- Original Message -
From: Lukas Pramuk lpra...@redhat.com
To: spacewalk-list@redhat.com
Sent: Thursday, March 13, 2014 9:09:15 PM
Subject: Re: [Spacewalk-list] Client machine update issue without internet

Hi,
I assume that the client connects to spacewalk server locally, on a LAN.
So the client needs network connection for communication with the spacewalk 
server.

What you mean with stop internet connection on client?
How do you do that?

Regards,

Lukas Pramuk
Systems Management QA, Red Hat


On 03/13/2014 03:56 PM, Dhaval Oza wrote:
 Dear Sir,

 We have configured and installed  Spacewalk Server 2.2  nightly on 
 Centos 6.5  spacewalk client machine. All things are working 
 perfectly fine on server side also the client side tool has been 
 installed on server to communicate with client machine with activation 
 key for getting updates from spacewalk server but the problem is when 
 i stop internet connection on client machine we are not getting any 
 updates and also when I trigger yum repolist command on client 
 machine it shows  0 packages available.

 My problem is what to configure on client machine so I can get all the 
 updates from spacewalk server without internet connection.

 And also let me know what to do on client machine and which file we 
 have to check and do the changes accordingly .

 It will be grateful if any one can help us in solving the issue.

 Thanks and Regards,
 Dhaval Oza.

 ___
 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 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

Re: [Spacewalk-list] Spacewalk 2.1 Upgrade

[Boyd, Robert]

I was having a look at some other things and noticed the following:

https://fedorahosted.org/spacewalk/wiki/HowToUpgrade

These are upgrade instruction for upgrading Spacewalk 2.0 to Spacewalk 2.1
These upgrade instruction apply to Spacewalk installations meeting the 
following criteria:

 *   Spacewalk 2.0 running on Red Hat Enterprise Linux 5 Server, 6 Server or 
CentOS/Scientific Linux or Fedora 19/20.
 *   Your Spacewalk uses either of Oracle 10g (including XE) / Oracle 11g / 
PostgreSQL 8.4+ as a database backend.
 *   In most cases it's possible to perform Package upgrade and Schema upgrade 
steps from any previous version to the latest one directly (e.g. from 1.6 to 
2.1). Make sure you have a valid backup in case anything will go wrong.

When I'm logged on to my Spacewalk 2.0 Master and enter yum check-update I 
don't see any Spacewalk 2.1 update yet.

At  yum.spacewalkproject.org there is no 2.1 directory visible yet.   Normally 
wouldn't the availability of the directory precede posting the instructions?  
Kind of hard to update the yum repo links when the rpm isn't actually there yet.

Red Hat Enterprise Linux 6, Scientific Linux 6, CentOS 6

rpm -Uvh 
http://yum.spacewalkproject.org/2.1/RHEL/6/x86_64/spacewalk-repo-2.1-2.el6.noarch.rpm

Or has something bad happened to the server and the 2.1 files have gone missing?

Index of /
[cid:image001.gif@01CF32F3.BAF19530]

Namehttp://yum.spacewalkproject.org/?C=N;O=D

Last modifiedhttp://yum.spacewalkproject.org/?C=M;O=A

Sizehttp://yum.spacewalkproject.org/?C=S;O=A

Descriptionhttp://yum.spacewalkproject.org/?C=D;O=A



[cid:image002.gif@01CF32F3.BAF19530]

1.0-client/http://yum.spacewalkproject.org/1.0-client/

13-Aug-2010 10:00

-



[cid:image002.gif@01CF32F3.BAF19530]

1.0/http://yum.spacewalkproject.org/1.0/

29-Apr-2010 11:36

-



[cid:image002.gif@01CF32F3.BAF19530]

1.1-client/http://yum.spacewalkproject.org/1.1-client/

19-Nov-2010 04:47

-



[cid:image002.gif@01CF32F3.BAF19530]

1.1/http://yum.spacewalkproject.org/1.1/

17-Aug-2010 05:01

-



[cid:image002.gif@01CF32F3.BAF19530]

1.2-client/http://yum.spacewalkproject.org/1.2-client/

19-Nov-2010 05:24

-



[cid:image002.gif@01CF32F3.BAF19530]

1.2/http://yum.spacewalkproject.org/1.2/

19-Nov-2010 05:24

-



[cid:image002.gif@01CF32F3.BAF19530]

1.3-client/http://yum.spacewalkproject.org/1.3-client/

26-Apr-2011 04:22

-



[cid:image002.gif@01CF32F3.BAF19530]

1.3/http://yum.spacewalkproject.org/1.3/

26-Apr-2011 04:22

-



[cid:image002.gif@01CF32F3.BAF19530]

1.4-client/http://yum.spacewalkproject.org/1.4-client/

26-Apr-2011 03:36

-



[cid:image002.gif@01CF32F3.BAF19530]

1.4/http://yum.spacewalkproject.org/1.4/

26-Apr-2011 03:36

-



[cid:image002.gif@01CF32F3.BAF19530]

1.5-client/http://yum.spacewalkproject.org/1.5-client/

07-Mar-2012 02:03

-



[cid:image002.gif@01CF32F3.BAF19530]

1.5/http://yum.spacewalkproject.org/1.5/

07-Mar-2012 02:03

-



[cid:image002.gif@01CF32F3.BAF19530]

1.6-client/http://yum.spacewalkproject.org/1.6-client/

22-Dec-2011 07:21

-



[cid:image002.gif@01CF32F3.BAF19530]

1.6/http://yum.spacewalkproject.org/1.6/

22-Dec-2011 07:22

-



[cid:image002.gif@01CF32F3.BAF19530]

1.7-client/http://yum.spacewalkproject.org/1.7-client/

06-Mar-2012 14:36

-



[cid:image002.gif@01CF32F3.BAF19530]

1.7/http://yum.spacewalkproject.org/1.7/

05-Nov-2012 04:00

-



[cid:image002.gif@01CF32F3.BAF19530]

1.8-client/http://yum.spacewalkproject.org/1.8-client/

01-Nov-2012 11:39

-



[cid:image002.gif@01CF32F3.BAF19530]

1.8/http://yum.spacewalkproject.org/1.8/

01-Nov-2012 11:39

-



[cid:image002.gif@01CF32F3.BAF19530]

1.9-client/http://yum.spacewalkproject.org/1.9-client/

05-Mar-2013 15:17

-



[cid:image002.gif@01CF32F3.BAF19530]

1.9/http://yum.spacewalkproject.org/1.9/

05-Mar-2013 15:17

-



[cid:image002.gif@01CF32F3.BAF19530]

2.0-client/http://yum.spacewalkproject.org/2.0-client/

19-Jul-2013 06:19

-



[cid:image002.gif@01CF32F3.BAF19530]

2.0/http://yum.spacewalkproject.org/2.0/

19-Jul-2013 06:20

-



[cid:image003.gif@01CF32F3.BAF19530]

READMEhttp://yum.spacewalkproject.org/README

09-Apr-2013 07:17

117



[cid:image004.gif@01CF32F3.BAF19530]

RPM-GPG-KEY-spacewalk-2008http://yum.spacewalkproject.org/RPM-GPG-KEY-spacewalk-2008

20-Apr-2010 14:45

1.7K



[cid:image004.gif@01CF32F3.BAF19530]

RPM-GPG-KEY-spacewalk-2010http://yum.spacewalkproject.org/RPM-GPG-KEY-spacewalk-2010

13-Aug-2010 07:36

1.3K



[cid:image004.gif@01CF32F3.BAF19530]

RPM-GPG-KEY-spacewalk-2012http://yum.spacewalkproject.org/RPM-GPG-KEY-spacewalk-2012

06-Mar-2012 07:18

1.8K



[cid:image002.gif@01CF32F3.BAF19530]

archive/http://yum.spacewalkproject.org/archive/

20-May-2013 04:22

-



[cid:image002.gif@01CF32F3.BAF19530]

latest-client/http://yum.spacewalkproject.org/latest-client/

19-Jul-2013 06:19

-



[cid:image002.gif@01CF32F3.BAF19530]

latest/http://yum.spacewalkproject.org/latest/

19-Jul-2013 06:20

-

Re: [Spacewalk-list] timestamps and the spacecmd API

[Boyd, Robert]

Andy,

Have you looked at the datetime data objects ?   They allow for direct 
comparison and arithmetic operations.

https://wiki.python.org/moin/WorkingWithTime


http://docs.python.org/2/library/datetime.html

Cheers,
Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Andy Ingham
Sent: Thursday, February 06, 2014 1:14 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] timestamps and the spacecmd API

Hello all!

I need to compare the completed_date from the listSystemEvents method 
(published at 
http://www.spacewalkproject.org/documentation/api/1.9/handlers/SystemHandle
r.html#listSystems ) to the current time (when my python script runs).

The 'completed_date' is returned from the API in ISO8601 format, e.g.:
20131230T23:00:24

I'm grabbing the current timestamp via datetime.datetime.now(), which returns a 
format like: 2014-02-06 13:05:47.583122



Has anyone got python code that compares two timestamps for use with the 
spacewalk API?  (Ultimately, I want to create a conditional that says, if the 
event completed less than X hours ago, do Y)

TIA!


Andy

Andy Ingham
IT Infrastructure
Fuqua School of Business
Duke University







___
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

Re: [Spacewalk-list] timestamps and the spacecmd API

[Boyd, Robert]

Perhaps more to the point also look at this:

http://stackoverflow.com/questions/969285/how-do-i-translate-a-iso-8601-datetime-string-into-a-python-datetime-object?lq=1


-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Andy Ingham
Sent: Thursday, February 06, 2014 1:14 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] timestamps and the spacecmd API

Hello all!

I need to compare the completed_date from the listSystemEvents method 
(published at 
http://www.spacewalkproject.org/documentation/api/1.9/handlers/SystemHandle
r.html#listSystems ) to the current time (when my python script runs).

The 'completed_date' is returned from the API in ISO8601 format, e.g.:
20131230T23:00:24

I'm grabbing the current timestamp via datetime.datetime.now(), which returns a 
format like: 2014-02-06 13:05:47.583122



Has anyone got python code that compares two timestamps for use with the 
spacewalk API?  (Ultimately, I want to create a conditional that says, if the 
event completed less than X hours ago, do Y)

TIA!


Andy

Andy Ingham
IT Infrastructure
Fuqua School of Business
Duke University







___
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

Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to stop it?

[Boyd, Robert]

Yes -- absolutely -- it would be very helpful since many are switching to 
PostgreSQL.  I imagine many are like me not trained as DBAs and a bit of basic 
guidance would be much appreciated.   I've been a DBA long ago, but not 
recently.   So a handbook for basic tuning and backup/recovery operations for 
spacewalk/PostgreSQL would be good to have on the wiki.

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Friday, December 13, 2013 5:53 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to 
stop it?

Ill compare your configs with some of my note when I get into the office on 
Sunday Im sure there is more that can be tweaked but I dont have all the notes 
I wrote up on to tune this stuff handy right now.

Incidentally would it be helpful to nay one else if I created a Wiki page on 
the subject of tuning PostgreSQL for Spacewalk.

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

Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to stop it?

[Boyd, Robert]

Up until today I thought I would be stuck with the cpu-bound processes until 
spacewalk 2.1 is released.

However, yesterday I updated my spacewalk master server since rebooting 
performance is back to normal.   Here is the list of updates that were applied 
to the server before the reboot:

Dec 23 14:59:06 Updated: nspr-4.10.2-1.el6_5.x86_64
Dec 23 14:59:06 Updated: nss-util-3.15.3-1.el6_5.x86_64
Dec 23 14:59:06 Updated: nss-sysinit-3.15.3-3.el6_5.x86_64
Dec 23 14:59:07 Updated: nss-3.15.3-3.el6_5.x86_64
Dec 23 14:59:07 Updated: pixman-0.26.2-5.1.el6_5.x86_64
Dec 23 14:59:07 Updated: xorg-x11-server-common-1.13.0-23.1.el6_5.x86_64
Dec 23 14:59:10 Updated: samba-common-3.6.9-167.el6_5.x86_64
Dec 23 14:59:11 Updated: samba-winbind-clients-3.6.9-167.el6_5.x86_64
Dec 23 14:59:13 Updated: samba-winbind-3.6.9-167.el6_5.x86_64
Dec 23 14:59:13 Updated: libjpeg-turbo-1.2.1-3.el6_5.x86_64
Dec 23 14:59:18 Updated: kernel-firmware-2.6.32-431.1.2.el6.noarch
Dec 23 14:59:27 Installed: kernel-2.6.32-431.1.2.el6.x86_64
Dec 23 14:59:27 Updated: systemtap-runtime-2.3-4.el6_5.x86_64
Dec 23 14:59:28 Installed: python-six-1.4.1-1.el6.noarch
Dec 23 14:59:29 Updated: ca-certificates-2013.1.95-65.1.el6_5.noarch
Dec 23 14:59:30 Updated: openssl-1.0.1e-16.el6_5.1.x86_64
Dec 23 14:59:30 Updated: postgresql92-libs-9.2.6-1PGDG.rhel6.x86_64
Dec 23 14:59:30 Updated: mesa-dri-filesystem-9.2-0.5.el6_5.2.x86_64
Dec 23 14:59:32 Updated: mesa-dri-drivers-9.2-0.5.el6_5.2.x86_64
Dec 23 14:59:32 Updated: mesa-libGL-9.2-0.5.el6_5.2.x86_64
Dec 23 14:59:32 Updated: mesa-libGLU-9.2-0.5.el6_5.2.x86_64
Dec 23 14:59:32 Updated: mesa-libgbm-9.2-0.5.el6_5.2.x86_64
Dec 23 14:59:32 Installed: python-chardet-2.0.1-1.el6.rf.noarch
Dec 23 15:00:33 Installed: kernel-devel-2.6.32-431.1.2.el6.x86_64
Dec 23 15:00:34 Updated: systemtap-devel-2.3-4.el6_5.x86_64
Dec 23 15:00:39 Updated: systemtap-client-2.3-4.el6_5.x86_64
Dec 23 15:00:39 Updated: systemtap-2.3-4.el6_5.x86_64
Dec 23 15:00:39 Updated: python-debian-0.1.21-10.el6.noarch
Dec 23 15:00:39 Updated: mesa-libEGL-9.2-0.5.el6_5.2.x86_64
Dec 23 15:00:39 Updated: glx-utils-9.2-0.5.el6_5.2.x86_64
Dec 23 15:00:39 Updated: postgresql84-libs-8.4.19-1PGDG.rhel6.x86_64
Dec 23 15:00:40 Updated: xorg-x11-server-Xorg-1.13.0-23.1.el6_5.x86_64
Dec 23 15:00:52 Installed: firefox-24.2.0-1.el6_5.x86_64
Dec 23 15:00:52 Updated: libsmbclient-3.6.9-167.el6_5.x86_64
Dec 23 15:00:53 Updated: nss-tools-3.15.3-3.el6_5.x86_64
Dec 23 15:00:54 Updated: perf-2.6.32-431.1.2.el6.x86_64
Dec 23 15:00:55 Updated: libcgroup-0.40.rc1-5.el6_5.1.x86_64
Dec 23 15:00:58 Updated: tzdata-java-2013i-1.el6.noarch
Dec 23 15:01:00 Updated: samba4-libs-4.0.0-60.el6_5.rc4.x86_64
Dec 23 15:01:00 Updated: openjpeg-libs-1.3-10.el6_5.x86_64
Dec 23 15:01:02 Updated: kernel-headers-2.6.32-431.1.2.el6.x86_64
Dec 23 15:01:03 Updated: yum-3.2.29-43.el6_5.noarch
Dec 23 15:01:04 Updated: ansible-1.4.1-1.el6.noarch
Dec 23 15:01:07 Updated: tzdata-2013i-1.el6.noarch

I am guessing that the kits most likely to have helped would be the 
postgresql84-libs and kernel related.  Any thoughts about other kits that might 
be significant influencers of relieving the problem with the cpu bound query?

In any case I'm elated and relieved to have the server back to normal cpu 
loading patterns.

Perhaps with the 2.1 release performance will be even better than now! :)


-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Friday, December 13, 2013 5:53 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to 
stop it?

Ill compare your configs with some of my note when I get into the office on 
Sunday Im sure there is more that can be tweaked but I dont have all the notes 
I wrote up on to tune this stuff handy right now.

Incidentally would it be helpful to nay one else if I created a Wiki page on 
the subject of tuning PostgreSQL for Spacewalk.




On Fri, Dec 13, 2013 at 5:45 PM, Paul Robert Marino prmari...@gmail.com wrote:
 oh sorry I was reading it on my phone so the formatting was weird I misread 
 it.



 On Fri, Dec 13, 2013 at 5:37 PM, Boyd, Robert
 robert.b...@peoplefluent.com wrote:
 That's a configuration setting - not an error message.



 From: spacewalk-list-boun...@redhat.com
 [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert
 Marino
 Sent: Friday, December 13, 2013 4:27 PM
 To: spacewalk-list@redhat.com
 Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and
 how to stop it?



 Well that message at the end of the output you posted processing
 past damaged page headers. concerns me that means your database
 might have a very serious problem. The safest thing to do would be to
 back up the database via pgdump then drop and reload it. I would also
 do a  fsck on the volume if I were you.


 -- Sent from my HP Pre3



 

 On Dec 13, 2013 9:33, Boyd

Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to stop it?

[Boyd, Robert]

Thank you for the suggestions.

I had previously done periodic pgtune passes.   I managed to do some tuning of 
config settings as you suggested for postgres and get a pass through vacuuming 
and reindexing. The performance of the server seems to be a bit crisper.  
However it didn't eliminate the problem with a process going CPU bound. I'm 
still waiting to hear back on my question about when I might be able to apply 
the updates that Michael Mraka pointed to.

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Monday, December 09, 2013 4:25 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to 
stop it?

sorry for the delayed responce on this I thought I sent it but its been sitting 
in my drafts folder

On Wed, Dec 4, 2013 at 11:21 AM, Boyd, Robert robert.b...@peoplefluent.com 
wrote:
 I have several hundred servers in spacewalk.   How much time should I allow 
 for a window to run this db maintenance?
that depends on how fragmented the tables and free space in the tables are 
which is a direct correlation to how many changes have been made since 
autovacuume has cleaned it up.
my facilities are 24x7 365 mission critical but on the weekend no changes are 
allowed to any systems so I have a cron job that does it at midnight on the 
first Saturday of each month and I don't really time it.

if its the first time you are doing it I would schedule 4 hours.
1 hour if you skip the reindex and second vacuum analyze. the reindex is whats 
really time consuming and not really required.



 And how does this relate to the bugzilla that Michael mentioned?

Yes and no they are and are not related
Not doing the maintenance I mentioned would significantly exacerbate the issue 
in the bugzilla ticket.
this is because it seems to be a planner issue and the planer utilizes the 
statistics created by the analyze process to figure out how to handle complex 
queries like this.

additionally you could more quickly help it if you tune the planner for example 
in ~postgres/data/postgresql.conf adjusting the size of effective_cache_size 
can be extremely helpful.

Also turning on constraint_exclusion in the same file is helpfull with 
spacewalk! it means the planner takes longer but can automatically figure out 
things to exclude in subqueries and joins based on constraints in the other 
parts of the overall query so the resulting query can be faster.
by default constraint_exclusion is turned off in PostgreSQL because if you 
don't do a lot of joins and conditional sub queries it will hurt you 
performance but in the case of spacewalk its a significant help.

the query planner in PostgreSQL is a complex subject but the major things to 
look at for spacewalk tuning are

shared_buffers (increase a lot)
work_mem (increase a lot if possible)
effective_cache_size (definitely increase a lot) default_statistics_target 
(increase a little or a lot but the down size is it makes analyze take longer 
the more you increase it and there is a point of diminishing returns) 
constraint_exclusion (enable this) from_collapse_limit (increase slightly) 
join_collapse_limit (increase slightly)

Also you you want to speed up vacuum, autovacuum, and reindex, and analyze 
operations increasing the maintenance_work_mem is helpful for that but keep in 
mind that autovacuums may use that during normal database operation so be 
careful not to make it too high so for example on my production boxes I have it 
set to 1GB


 Michael, how long before the spacewalk-java update will move from nightly to 
 production release?

 Thank you both for your assistance!

 Robert


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

Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to stop it?

[Boyd, Robert]

Michael,

Do you have any idea when the fix will be escaping into the production updates? 
 I presume from the bugzilla track that it's already in the nightly packages.

Thanks!
Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Michael Mraka
Sent: Tuesday, December 03, 2013 1:54 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to 
stop it?

Boyd, Robert wrote:
% Charles,  Here's what I found associated with the CPU bound process:  -- so, 
what is this being triggered by and what is it doing? Why is it taking so long? 
 And is it ever going to finish?
% 

Hello Robert,

you've most likely hit https://bugzilla.redhat.com/show_bug.cgi?id=1022279.


Regards,

--
Michael Mráka
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

Re: [Spacewalk-list] Spacewalk 2.0 Upgrade Issue

[Boyd, Robert]

Anytime you change anything in yum.repos.d it's a good idea to invoke 'yum 
clean all' before asking yum to do any work.

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Shawn Cannon
Sent: Monday, December 09, 2013 2:53 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk 2.0 Upgrade Issue

Nevermind I found this site that helped me get around the checksum issue.

http://dagarthedragon.blogspot.com/2012/01/spacewalk-and-repos.html



From: sh...@shawncannon.commailto:sh...@shawncannon.com
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: Spacewalk 2.0 Upgrade Issue
Date: Mon, 9 Dec 2013 14:25:15 -0500
I am trying a Spacewalk 2.0 upgrade again and this time I updated my REPO 
first.  Now I am getting a different error:

http://yum.spacewalkproject.org/2.0/RHEL/6/x86_64/repodata/filelists.sqlite.bz2:
 [Errno -1] Metadata file does not match checksum

This tries to pull from spacewalk/filelists_db

Any ideas?


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

Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to stop it?

[Boyd, Robert]

Michael Mráka,

I see this and other spacewalk-java*2.1 rpms on the nightly:   
http://spacewalk.redhat.com/yum/nightly/RHEL/6/x86_64/spacewalk-java-postgresql-2.1.90-1.el6.noarch.rpm

I downloaded this one and it doesn't list any other 2.1 spacewalk components as 
dependencies when I do a yum deplist on it.   Does that mean that I can safely 
update my spacewalk server with this before the update to spacewalk 2.1 is 
released?  Or do I need the spacewalk-java and spacewalk-java-config and 
spacewalk-java-lib updates as well?  Or do I just have to wait for 2.1?

Thank you,
Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Monday, December 09, 2013 2:27 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to 
stop it?

Michael,

Do you have any idea when the fix will be escaping into the production updates? 
 I presume from the bugzilla track that it's already in the nightly packages.

Thanks!
Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Michael Mraka
Sent: Tuesday, December 03, 2013 1:54 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to 
stop it?

Boyd, Robert wrote:
% Charles,  Here's what I found associated with the CPU bound process:  -- so, 
what is this being triggered by and what is it doing? Why is it taking so long? 
 And is it ever going to finish?
% 

Hello Robert,

you've most likely hit https://bugzilla.redhat.com/show_bug.cgi?id=1022279.


Regards,

--
Michael Mráka
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 mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to stop it?

[Boyd, Robert]

I have several hundred servers in spacewalk.   How much time should I allow for 
a window to run this db maintenance?

And how does this relate to the bugzilla that Michael mentioned?

Michael, how long before the spacewalk-java update will move from nightly to 
production release?

Thank you both for your assistance!

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Tuesday, December 03, 2013 1:16 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and how to 
stop it?

I think I know whats going on here.
The autovacuum process in PostgreSQL 8.x was new and wasn't quite perfected 
yet. you need to stop spacewalk and do a full vacuum analyze on the database.
chances are your planner stats are out of date. It also may not hurt to do a 
reindexdb as well.
I schedule a monthly window to do these procedures to absolutely ensure that 
every thing is working optimally.

here is what I run

#!/bin/bash
spacewalk-service stop
export PGUSER=postgres
export PGPASSWORD=password
vacuumdb -azvf
reindexdb -a
vacuumdb -a
spacewalk-service start



On Tue, Dec 3, 2013 at 11:52 AM, Boyd, Robert robert.b...@peoplefluent.com 
wrote:
 Charles,  Here's what I found associated with the CPU bound process:  
 -- so, what is this being triggered by and what is it doing? Why is it 
 taking so long?  And is it ever going to finish?



 spaceschema=# select * from pg_stat_activity;

 datid |   datname   | procpid | usesysid |  usename  |
 current_query

 | waiting |  xact_start   |
 query_start  | backend_start | client_addr | client

 _port



 16384 | spaceschema |   15809 |16388 | spaceuser | SELECT DISTINCT
 snv.server_id AS server_id, S.name, S.release, SA.name as arch,

 | f   | 2013-12-02 13:30:00.7034-05   |
 2013-12-03 11:45:02.564862-05 | 2013-12-02 12:43:22.424659-05 | 
 127.0.0.1
 |

 43711

   : urn.user_id



   :   FROM (



   : --



   : select 
 rhnChannelErrata.errata_id, rhnChannelErrata.channel_id, 
 rhnServerChannel.server_id, rhnE

 rrataPackage.package_id

   : from 
 rhnChannelErrata, rhnErrataPackage, rhnChannelNewestPackage, 
 rhnPackageEVR,



   :
 rhnServerChannel, rhnServerPackage, rhnPackageUpgradeArchCompat



   : where 
 rhnChannelErrata.errata_id = rhnErrataPackage.errata_id



   : --



   : and
 rhnChannelErrata.channel_id = rhnChannelNewestPackage.channel_id



   : and
 rhnErrataPackage.package_id = rhnChannelNewestPackage.package_id



   : --



   : and
 rhnChannelErrata.channel_id = rhnServerChannel.channel_id



   : and
 rhnChannelNewestPackage.name_id = rhnServerPackage.name_id



   : and
 rhnServerChannel.server_id = rhnServerPackage.server_id



   : --



   : and
 rhnChannelNewestPackage.evr_id = rhnPackageEVR.id



   : --



   : and
 rhnServerPackage.package_arch_id =
 rhnPackageUpgradeArchCompat.package_arch_id



   : and
 rhnPackageUpgradeArchCompat.pack



 From: spacewalk-list-boun...@redhat.com 
 [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Charles 
 Richards
 Sent: Tuesday, December 03, 2013 11:18 AM
 To: spacewalk-list@redhat.com
 Subject: Re: [Spacewalk-list] CPU bound postgresql process ? Why and 
 how to stop it?



 You can check what postgresql is doing by running the following query 
 as the postgres user:



 select * from pg_stat_activity;



 I've seen this behavior on my instance when the errata_cache task 
 runs, but have not found a resolution for it (running SW 1.9  / PG 
 8.4.13)





 On Dec 2, 2013, at 1:18 PM, Boyd, Robert 
 robert.b...@peoplefluent.com
 wrote:



 I'm running spacewalk 2.0 on RHEL 6.4 with database local postgresql 
 8.4 all patched current.  In recent days I'm seeing one or more very 
 busy processes like this one:



 15809 postgres

Re: [Spacewalk-list] Installation of spacewalk on RHEL 6

[Boyd, Robert]

Susi,

What happens if you try this:

wget 
http://yum.spacewalkproject.org/2.0/RHEL/6/x86_64/spacewalk-repo-2.0-3.el6.noarch.rpm

?

Is it possible that you have a firewall or intrusion detection system that 
might be interfering with your connection to the spacewalk distro server on 
port 80?

Robert

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Susindran Suruli
Sent: Tuesday, October 29, 2013 4:19 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Installation of spacewalk on RHEL 6

Hi Team,

I am new to spacewalk..I am trying to install spacewalk on our test server its 
running under RHEL 6.4.I am getting below error while trying to isntall.Please 
let us know what the problem..I can able to ping the spacewalk IP from my 
server,.

Find the below for error.

[root@ ~]# rpm -Uvh 
http://yum.spacewalkproject.org/2.0/RHEL/6/x86_64/spacewalk-repo-2.0-3.el6.noarch.rpm
Retrieving 
http://yum.spacewalkproject.org/2.0/RHEL/6/x86_64/spacewalk-repo-2.0-3.el6.noarch.rpm
curl: (56) Failure when receiving data from the peer
error: skipping 
http://yum.spacewalkproject.org/2.0/RHEL/6/x86_64/spacewalk-repo-2.0-3.el6.noarch.rpm
 - transfer failed
[root@~]#

[root@ ~]# curl -v 
http://yum.spacewalkproject.org/2.0/RHEL/6/x86_64/spacewalk-repo-2.0-3.el6.noarch.rpm
* About to connect() to 
yum.spacewalkproject.orghttp://yum.spacewalkproject.org port 80 (#0)
*   Trying 209.132.183.81... connected
* Connected to yum.spacewalkproject.orghttp://yum.spacewalkproject.org 
(209.132.183.81) port 80 (#0)
 GET /2.0/RHEL/6/x86_64/spacewalk-repo-2.0-3.el6.noarch.rpm HTTP/1.1
 User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 
 NSS/3.14.0.0http://3.14.0.0 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
 Host: yum.spacewalkproject.orghttp://yum.spacewalkproject.org
 Accept: */*

* Closing connection #0
* Failure when receiving data from the peer
curl: (56) Failure when receiving data from the peer
[root@ ~]#

[root@ ~]# ping yum.spacewalkproject.orghttp://yum.spacewalkproject.org
PING spacewalk.redhat.comhttp://spacewalk.redhat.com (209.132.183.81) 56(84) 
bytes of data.
64 bytes from spacewalk.redhat.comhttp://spacewalk.redhat.com 
(209.132.183.81): icmp_seq=1 ttl=238 time=88.4 ms
64 bytes from spacewalk.redhat.comhttp://spacewalk.redhat.com 
(209.132.183.81): icmp_seq=2 ttl=238 time=88.3 ms
64 bytes from spacewalk.redhat.comhttp://spacewalk.redhat.com 
(209.132.183.81): icmp_seq=3 ttl=238 time=89.2 ms
64 bytes from spacewalk.redhat.comhttp://spacewalk.redhat.com 
(209.132.183.81): icmp_seq=4 ttl=238 time=88.4 ms
64 bytes from spacewalk.redhat.comhttp://spacewalk.redhat.com 
(209.132.183.81): icmp_seq=5 ttl=238 time=88.6 ms
^C
--- spacewalk.redhat.comhttp://spacewalk.redhat.com ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4467ms
rtt min/avg/max/mdev = 88.396/88.652/89.243/0.408 ms
[root@ ~]#


Thanks,
Susi.S

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

[Spacewalk-list] Monitoring reposync jobs success/failure status

[Boyd, Robert]

I'm curious to see if anyone is using automated monitoring to detect when 
reposync jobs are failing?   There doesn't seem to be any provision that I've 
come across yet to show in the web GUI any indication of success/failure status 
of the taskomatic reposync jobs.   I recently ran into some issues with a few 
of my reposyncs after the upgrade to spacewalk 2.0.   Now I would like very 
much to have some sort of status indicator that gives me a summary of how all 
of these jobs are behaving.  Ideally I'd like to get some kind of alert if 
there is a serious failure.   After what I've seen, I think it won't do anymore 
to go happily along with no idea if they are working unless I look into the log 
files myself.

Is there a way now with spacecmd or the API to display the most recent 
successful reposync for a particular channel?   It would be nice from my 
perspective to have the last successful sync date posted alongside the channel 
info at least under Software Channel Management if not the Full Channel List 
page.

Is there anything in the works to display this information?

Thank you,

Robert Boyd
Senior Systems Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.commailto:michael.dileona...@peoplefluent.com
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog
Follow: @peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8
[cid:image001.png@01CE9F33.324F0130]
[cid:image002.png@01CE9F33.324F0130]

inline: image001.pnginline: image002.png___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] how do I clear spacewalk's repo-sync cache?

[Boyd, Robert]

Andy or anyone,

What did you do to clear the problem?  Did it clear up by virtue the stale 
mirror(s) eventually catching up?  Or did you change the URL you were using for 
the repository?

I found I had the same problem today and changed the URL to point to 
dl.fedora.org instead of download.fedora.org and got it to work.   I'm sure in 
the long run it would be better to switch it back to the one that points to the 
mirrors.


Robert Boyd
Senior Systems Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com
Visit: www.peoplefluent.com | Read: Peoplefluent Blog
Follow: @peoplefluent | Download: iPad App





-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Andy Ingham
Sent: Monday, April 29, 2013 11:56 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] how do I clear spacewalk's repo-sync cache?

Jan --

That appears to have been the issue.

Many thanks!

Andy


On 4/29/13 11:04 AM, Jan Pazdziora jpazdzi...@redhat.com wrote:

...

Is it possible you use a caching HTTP proxy (possibly a transparent
one) that gives you the stale data?

If you do

GET 
'http://archive.linux.duke.edu/pub/epel/6/x86_64/repodata/repomd.xml'
| grep primary.sqlite

do you see the correct content?

--
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] 1.6 to 1.7 upgrade bug 869985 reappeared?

[Boyd, Robert]

It would be extremely helpful to update the Wiki pages on upgrades to indicate 
the maximum jumps which will work. 

In other words -- on the V2.0 page indicate the oldest version that can be 
directly upgraded to 2.0.  For each release this would be very helpful.   
Otherwise it would be normal to assume that one must do the intervening steps.  
 

I mistakenly went through all of the intervening steps to go from 1.7 to 2.0 -- 
I would have saved a lot of time if I had known I could go directly.

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Milan Zazrivec
Sent: Tuesday, August 13, 2013 5:16 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] 1.6 to 1.7 upgrade bug 869985 reappeared?

 If I understand you correct you are saying I can upgrade from 1.6 
 directly to 1.8? I thought it was required to do a step by step 
 upgrade. My objective is to get all the way to 2.0.

Yes, you can upgrade directly from 1.6 to 2.0. There's no need to do the 
particular steps. If you encounter any problems during the upgrade, feel free 
to ask here, I'll try to help if I can.

-MZ

 
 From: spacewalk-list-boun...@redhat.com 
 [spacewalk-list-boun...@redhat.com]
 on behalf of Milan Zazrivec [mzazri...@redhat.com] Sent: Monday, 
 August 12, 2013 9:56 AM
 To: spacewalk-list@redhat.com
 Subject: Re: [Spacewalk-list] 1.6 to 1.7 upgrade bug 869985 reappeared?
 
  I am attempting to upgrade from 1.6 to 1.7 and have encountered the
  following:
  
  'SPACEWALK-SCHEMA-1.6-TO-SPACEWALK-SCHEMA-1.7/007-RHNPACKAGEGROUP-TR
  IM.SQ
  
  - 
  spacewalk-schema-1.6-to-spacewalk-schema-1.7/007-rhnPackageGroup-tri
  m.sql
  
  
  77722 rows updated.
  
  update rhnpackagegroup set name = substr(name, 1, length(name)-1)
  *
  ERROR at line 1:
  ORA-1: unique constraint (SPACEWALK.RHN_PACKAGE_GROUP_NAME_UQ)
  violated
  
  
  This appears to be a bug listed as fixed.
  https://bugzilla.redhat.com/show_bug.cgi?id=869985
  
  Presuming it is the same issue clearly its not fixed or the repo has 
  somehow reverted back which seems very unlikely. I am using
  spacewalk-repo-1.7-5.el5 pulled from 
  http://yum.spacewalkproject.org/1.7/RHEL/5/x86_64/. Following the 
  directions at https://fedorahosted.org/spacewalk/wiki/HowToUpgrade17.
 
 Yes, this bug was fixed for Spacewalk 1.8, i.e. you would not hit this 
 problem when upgrading from any version to Spacewalk 1.8. The problem 
 has not been backported to Spacewalk 1.7 packages, i.e. you either can 
 upgrade to something later or apply that fix manually.
 
 -Milan Zázrivec
 
 ___
 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 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

Re: [Spacewalk-list] upgrade from 1.9 to 2.0 questions

[Boyd, Robert]

Brian,

You can update the channel / repository info to point to the 2.0 location.   I 
just did this in the last couple of days.   And you will need to resync it or 
wait for your scheduled sync to run.  

Once the sync(s) complete you can see what needs to be updated on a particular 
client -- just do the ordinary yum check-update.

You don't need to update the spacewalk-client-repo because you only use that 
when not subscribed to the client packages via a channel.

If you do yum update all of the relevant packages will be handled.

Robert Boyd


-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Brian Millett
Sent: Tuesday, August 13, 2013 1:40 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] upgrade from 1.9 to 2.0 questions


I'm ready to upgrade spacewalk server from 1.9 to 2.0 and I have no questions 
about the server upgrade, however, I do about the clients and the older 
spacewalk client 1.9 channels.

Q) Do I need to add a new channel for 2.0 or can I modify the 1.9 channel  
repo to point to the new 2.0 location?

Q) Since the clients are already registered, do I need to anything? Update the 
spacewalk-client-repo rpm package?

Thanks.
--
Brian Millett
You know, you're demented.
   -- [ Garibaldi, TKO]

___
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

Re: [Spacewalk-list] upgrade from 1.9 to 2.0 questions

[Boyd, Robert]

Another note about updating to 2.0.   I just noticed also that the clients I 
updated so far have a nice change on them.
Before with the 1.7 client on them I would always see this message:

This system is not registered to Red Hat Subscription Management. You can use 
subscription-manager to register.

It was possible to remove the subscription-manager to get this to stop.   But 
that's such a bother.   Now after updating to 2.0 I see this instead:

This system is receiving updates from RHN Classic or Red Hat Satellite.

Robert Boyd

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Tuesday, August 13, 2013 2:23 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] upgrade from 1.9 to 2.0 questions

Brian,

You can update the channel / repository info to point to the 2.0 location.   I 
just did this in the last couple of days.   And you will need to resync it or 
wait for your scheduled sync to run.  

Once the sync(s) complete you can see what needs to be updated on a particular 
client -- just do the ordinary yum check-update.

You don't need to update the spacewalk-client-repo because you only use that 
when not subscribed to the client packages via a channel.

If you do yum update all of the relevant packages will be handled.

Robert Boyd


-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Brian Millett
Sent: Tuesday, August 13, 2013 1:40 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] upgrade from 1.9 to 2.0 questions


I'm ready to upgrade spacewalk server from 1.9 to 2.0 and I have no questions 
about the server upgrade, however, I do about the clients and the older 
spacewalk client 1.9 channels.

Q) Do I need to add a new channel for 2.0 or can I modify the 1.9 channel  
repo to point to the new 2.0 location?

Q) Since the clients are already registered, do I need to anything? Update the 
spacewalk-client-repo rpm package?

Thanks.
--
Brian Millett
You know, you're demented.
   -- [ Garibaldi, TKO]

___
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 mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Clients don't see packages after re-registration

[Boyd, Robert]

You might look at your /etc/yum/pluginconf.d/rhnplugin.conf and verify that the 
repo(s) are actually enabled.  I ran into a couple of clients recently where 
someone had disabled the primary channel in the rhnplugin.

Cheers,
Robert

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Jacek
Sent: Tuesday, June 25, 2013 10:40 AM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Clients don't see packages after re-registration


Hello,


I've just reinstalled Spacewalk on different machine.

It was 1.5 now it is 1.9.



I created couple of channels and repos.

After that I created Activation Keys to these channels.



For example one of this Channels is:

server-5-x86_64

repo:

5Server-x86_64

and key:

1-5-server-x86_64 that is connected to base channel server-5-x86_64



After that I installed mrepo, generated system id for all repos.

Configuration for mentioned above repo from mrepo.conf



[main]
srcdir = /mrepo
wwwdir = /var/www/mrepo
confdir = /etc/mrepo.conf.d
shareiso = yes
rhnlogin = user:pass
hardlink = yes
hardlinkpluscmd = /usr/bin/hardlink++ 2/dev/null
plugins = 1
logfile = /var/log/mrepo.log

[5Server]
name = Red Hat Enterprise Linux $release Server ($arch)
release = 5
arch = i386 x86_64
iso = rhel-server-5.9-$arch-dvd.iso
metadata = repomd yum
updates = rhns:///rhel-$arch-server-$release





Then I executed mrepo -ugvvv

After that sync to spacewalk channels.

Everything was fine. I can see packages in channels os spacewalk webpage.



Lastly I hat to reregister machines to Spacewalk.



So:



rpm -Uvh http://spacewalker/pub/rhn-org-trusted-ssl-cert-1.0-1.noarch.rpm 
--force

and

rhnreg_ks --force --activationkey=1-5-server-x86_64



After that I can see registered machine on spacewalk webpage.

I can see, that it has 42 package updates.

But...



On that machine:



[root@systemX ~]# yum update
Loaded plugins: rhnplugin, security
This system is receiving updates from RHN Classic or RHN Satellite.
Setting up Update Process
No Packages marked for Update



[root@www-live01 ~]# yum repolist
Loaded plugins: rhnplugin, security
This system is receiving updates from RHN Classic or RHN Satellite.
repo id  repo name  
   status
server-5-x86_64  
server-5-x86_64   0
repolist: 0



I've tried to remove this machine and reregister.

I didn't made any change.

It was working on previous instance of Spacewalk.



What is wrong? Did I missed something?

Do you have any suggestions?



Regards,

Jacek

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

[Spacewalk-list] System-ID not found errors

[Boyd, Robert]

Suddenly this afternoon I started getting these error messages on several 
spacewalk clients:

There was an error communicating with RHN.
RHN Satellite or RHN Classic support will be disabled.
Error communicating with server. The message was:

Error Message:
Please run rhn_register as root on this client
Error Class Code: 9
Error Class Info: Invalid System Credentials.
Explanation:
 An error has occurred while processing your request. If this problem
 persists please enter a bug report at bugzilla.redhat.com.
 If you choose to submit the bug report, please be sure to include
 details of what you were trying to do when this error occurred and
 details on how to reproduce this problem.

When I look on the spacewalk server I see the following types of errors in  
/var/log/rhn/rhn_server_xmlrpc.log:

2013/04/08 17:48:16 -04:00 15214 172.23.2.157: 
xmlrpc/up2date.listChannels(110241,)
2013/04/08 17:48:18 -04:00 14942 10.36.7.72: 
rhnServer/server_certificate.valid('Server id ID-110038 not found in 
database',)
2013/04/08 17:48:28 -04:00 14966 10.67.6.56: 
rhnServer/server_certificate.valid('Server id ID-110010 not found in 
database',)
2013/04/08 17:48:57 -04:00 14947 10.100.1.201: 
rhnServer/server_certificate.valid('Server id ID-110309 not found in 
database',)
2013/04/08 17:48:58 -04:00 14939 10.67.6.56: 
rhnServer/server_certificate.valid('Server id ID-110010 not found in 
database',)
2013/04/08 17:49:27 -04:00 15216 10.100.1.201: 
rhnServer/server_certificate.valid('Server id ID-110309 not found in 
database',)
2013/04/08 17:50:24 -04:00 14952 10.100.1.201: 
rhnServer/server_certificate.valid('Server id ID-110309 not found in 
database',)


These are all clients that have been successfully connecting to spacewalk for 
some time.   No changes have been made to the spacewalk configuration other 
than adding new clients.   Today I found a duplicate name and deleted the older 
of the duplicates.

I did have 5 spacewalk Proxy Servers registered.   It appears that somehow all 
of my spacewalk proxy servers have been un-registered from the master.   How do 
I discover when and by whom these might have become unregistered?



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

Re: [Spacewalk-list] spacewalk-postgresql-1.8.6-1.el5.noarch.rpm requires postgresql84-contrib

[Boyd, Robert]

Paul Robert,

I'm curious about how things stand regarding the wiki you were going to write 
up about replication/failover/gluster.  How have things gone for you since 
November with this?

I'm running spacewalk 1.7 on postgresql 8.4.   I'm wanting to upgrade to 
postgresql 9.2 and spacewalk 1.9.   I'd like to see about setting up some kind 
of replication / failover capability in the end.

Do you (or anyone else for that matter) have any suggestions about what I 
should upgrade first?   I see that there are at least 2 paths for upgrading 
postgresql since there's now the option of using the pg_upgrade tool to avoid 
the backup/reload method.   Is there anyone who has successfully migrated the 
spacewalk DB using pg_upgrade who would be willing to talk about any issues 
related to that?

And I see that the manual setup instructions on the wiki only provide 
instructions for pgsql 8.4.   What version does the 
spacewalk-setup-embedded-postgresql package install?  Does it give you a 
choice? How does it work? It would be nice to have a bit more elaboration on 
this in the wiki. 

Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
 
e. robert.b...@peoplefluent.com 
Visit: www.peoplefluent.com | Read: Peoplefluent Blog
Follow: @peoplefluent | Download: iPad App



-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Tuesday, November 20, 2012 6:01 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] spacewalk-postgresql-1.8.6-1.el5.noarch.rpm 
requires postgresql84-contrib

Ive been running on PostgreSQL 9.1 for some time and am about to switch to 9.2 
for cascading streaming replication support which should work nicely with 
pgpool auto master failover and recovery. I'm using the RPMs from PGDG's repos 
here http://yum.postgresql.org/repopackages.php

The only issue I ran into was this
https://www.redhat.com/archives/spacewalk-list/2012-February/msg00052.html

There is one more issue I found but its not a show stopper again its the JDBC 
driver unfortunately it breaks pgpools load balancing because it wraps all 
queries in a transaction even if the programer didn't ask it to. the result is 
all queries go to the master. This only prevents it from utilizing the backup 
node for speed but doesn't effect any critical functionality.


I do intend to write a wiki doc soon on how to do this and utilize gluster to 
allow live live load balancing and failover between nodes.


On Tue, Nov 20, 2012 at 2:12 PM, Jeremy Davis jdavis4...@gmail.com wrote:
 Hello Jan and All,

 Sorry I should have given a little background. I converted my 
 Spacewalk Oracle 11G(External DB) solution to Spacewalk PostgreSQL 
 9.1(External DB) using Spacewalk 1.6 a while back. Now that 1.8 is 
 released I am cleaning things up a little bit as in order to get 1.6 
 working with postgresql 9.1 I had to use the 84 packages and not 9.1 
 on the app server. Now that I am cleaning up the packages I would like 
 to use the 9.1 packages as I feel it might clear some issues up that I 
 am seeing or maybe improve the situation a little. (Note: These issues 
 I am talking about seem to be fixed with bug fixes for 1.8 so I don't 
 think these are 9.1 specific issues just would like to rule out any 
 incompatibility issues by using the 9.1 packages with a 9.1 DB instead 
 of 8.4 packages.)

 Based on the Spacewalk wiki documentation it states the following 
 please make sure the postgresql-contrib = 8.4 (or postgresql84-contrib on 
 RHEL 5
 ) is installed on the PostgreSQL server. and PostgreSQL 8.4+ as a 
 database backend. Which leads me to think that I could use a version 
 higher than 8.4. I also obtained a couple of fixes for escape issues 
 that I was having with 9.1. Seeing as how I was obtaining support for 
 9.1 in the way of bugs being fixed I assumed it would be ok to use 9.1.

 What I am really asking is if we can update the rpm require lines to 
 reflect postgresql-contrib instead of postgresql84-contrib and use the 
 postgresql =
 8.4 as the means to make sure we get at least 8.4 when installed via yum.
 This also seems a lot cleaner than requiring postgresql84-contrib when 
 that package provides postgresql-contrib in the package. So it would 
 be really easy to change that to require just postgresql-contrib 
 instead of postgresql84-contrib. This would allow users to choose 
 which version of PostgreSQL to use, help smash any bugs that are found 
 with different versions, and allow Spacewalk to support newer version more 
 quickly.

 If I can't use 9.1 than I would recommend that you update the wiki or 
 allow me to update the wiki to change the documentation to state that 
 only 8.4 is a solid requirement and that you can't use a newer version.

 Thank you for your time and have a great day!

 Regards,
 Jeremy

 On Tue, Nov 20, 2012 at 10:52 AM, Jan Pazdziora 
 jpazdzi...@redhat.com
 wrote:

 On Tue, 

Re: [Spacewalk-list] Spacewalk 1.7 CPU Maxed out by postgresql (8.4)

[Boyd, Robert]

There is probably nothing wrong (other than maybe some tuning needed?) with 
Spacewalk or PostgreSQL on this server.

It would appear that Red Hat released approximately 100 updates in the RHEL5 
x86_64 space yesterday. At least that's what it looks like from the errata-sync 
log.   The errata got loaded into the master I'm running around the time I can 
see the cpu maxing out.   My guess is that it's crunching through auditing all 
of the client servers against the errata list since I'm getting bombarded 
(slowly) with Spacewalk Alert emails. I'm curious as to why this activity 
would be generating so much cpu load for so long though.   We only have about 
250 servers registered in the system.  It seems crazy that it would take hours 
to check 250 servers against 100 errata unless there's a serious problem in the 
design of the data / algorithm for doing the checks.

Is there any easy way to take a read on Spacewalk and see that it's busy?  
Would be nice if there was a dashboard with meters giving a clue about whatever 
it's busy processing.  The way I finally figured out my situation this time was 
noticing the flood of emails and working back to the nightly errata sync logs 
to see the flood of updates imported this morning.

Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog
Follow: @peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8
[cid:image007.jpg@01CDED9A.EE073A50]http://www.peoplefluent.com/
[cid:image008.jpg@01CDED9A.EE073A50]http://www.peoplefluent.com/mobile-talent-management

From: Boyd, Robert
Sent: Tuesday, January 08, 2013 11:44 AM
To: spacewalk-list@redhat.com
Subject: Spacewalk 1.7 CPU Maxed out by postgresql (8.4)

Sometime this morning my spacewalk server pegged 100% on cpu utilization and 
has been staying there ever since.   I tried a reboot, and just for grins 
updated errata/packages on the server.   After rebooting it's still pegging the 
cpu usage with this process:

postgres  2888 77.7  1.3 470128 53708 ?Rs   10:35  52:05 postgres: 
spaceuser spaceschema 127.0.0.1(46206) SELECT

I am able to use  the Spacewalk admin website without any problem other than a 
bit of slow response.
How can I discover what is causing this (and hopefully fix it)?

Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681

e. robert.b...@peoplefluent.com
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog
Follow: @peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8
[cid:image005.jpg@01CDED9A.0E5C02F0]http://www.peoplefluent.com/
[cid:image006.jpg@01CDED9A.0E5C02F0]http://www.peoplefluent.com/mobile-talent-management

inline: image005.jpginline: image006.jpginline: image007.jpginline: image008.jpg___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

[Spacewalk-list] Spacewalk 1.7 CPU Maxed out by postgresql (8.4)

[Boyd, Robert]

Sometime this morning my spacewalk server pegged 100% on cpu utilization and 
has been staying there ever since.   I tried a reboot, and just for grins 
updated errata/packages on the server.   After rebooting it's still pegging the 
cpu usage with this process:

postgres  2888 77.7  1.3 470128 53708 ?Rs   10:35  52:05 postgres: 
spaceuser spaceschema 127.0.0.1(46206) SELECT

I am able to use  the Spacewalk admin website without any problem other than a 
bit of slow response.
How can I discover what is causing this (and hopefully fix it)?

Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog
Follow: @peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8
[cid:image005.jpg@01CDED95.75AF5FB0]http://www.peoplefluent.com/
[cid:image006.jpg@01CDED95.75AF5FB0]http://www.peoplefluent.com/mobile-talent-management

inline: image005.jpginline: image006.jpg___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] How to use Spacewalk to upgrade RHEL to higher version(s)?

[Boyd, Robert]

Red Hat generally recommends against upgrading inplace from one major version 
to another even using the distribution disc much less this way.

I wish they'd come up with a way that is smoother like other Unix based OSes 
like Tru64 Unix, Mac OS X and others that will help you upgrade in place.   
Unfortunately that's not the model with Linux.  One can hope and dream.   
Having spent many years supporting OpenVMS, this was one of the nicer features 
of that OS from the very beginning.

I'm really not sure why the engineering teams behind OS upgrades for linux 
think that their method of delete and reimage for major upgrades is an 
acceptable model.   It makes it more simple in terms of clearing the deck of 
any cruft that the previous release(s) might have included that need to go away 
instead of having to carefully craft scripts that will comb through and eject 
things that must disappear.   It however makes it a major pain for the system 
admin who must worry about reconstructing the server exactly as it was under 
the new OS.   I'm sure that kickstart mechanisms can make this much simpler, 
but it's still a pain when you think about all the twisty little passages that 
make up a system configuration after the initial setup for special purpose 
servers.  Plus if you've installed custom packages that integrate into the 
directories under /etc and other system trees, you have to re-install them - 
you can't just back them up and restore them unless you're very clever.   Am I 
wrong?   Anyone have a different experience than this?   Tell me there's a 
magic easy way and I'll be happy to learn it.

Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog
Follow: @peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8
[cid:image005.jpg@01CDCF0D.7AFF5250]http://www.peoplefluent.com/
[cid:image006.jpg@01CDCF0D.7AFF5250]http://www.peoplefluent.com/mobile-talent-management

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Hamilton, James
Sent: Friday, November 30, 2012 2:45 PM
To: fn...@yahoo.com; spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] How to use Spacewalk to upgrade RHEL to higher 
version(s)?

I would not recommend doing this and i know it is not supported.  It will most 
likely not go smoothly either but if you enjoy troubleshooting and dont plan to 
put any of those systems in production, go for it.

Thanks
Jim


From: 
spacewalk-list-boun...@redhat.commailto:spacewalk-list-boun...@redhat.com 
[spacewalk-list-boun...@redhat.com] on behalf of 
fn...@yahoo.commailto:fn...@yahoo.com [fn...@yahoo.com]
Sent: Friday, November 30, 2012 2:14 PM
To: spacewalk-list@redhat.commailto:spacewalk-list@redhat.com
Subject: [Spacewalk-list] How to use Spacewalk to upgrade RHEL to higher 
version(s)?
Hi,

I've tried to upgrade rhel 5 to rhel 6 for both i386 and x86 systems, but none 
of them working. What I have done were:

(1) Attach the higher version's channel to the client in Spacewalk server.
(2) Use 'yum upgrade' from the Spacewalk client.

Here are some errors from 'yum update':

Error: Missing Dependency: libpoldiff.so.1(VERS_1.2) is needed by package 
setools-gui-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libseaudit.so.4 is needed by package 
setools-gui-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libgio-2.0.so.0 is needed by package 
setools-gui-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libseaudit.so.4 is needed by package 
setools-libs-tcl-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: tcl(abi) = 8.5 is needed by package 
bwidget-1.8.0-5.1.el6.noarch (rhel_6_i386)
Error: Missing Dependency: libapol.so.4(VERS_4.0) is needed by package 
setools-gui-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libtcl8.5.so is needed by package 
setools-libs-tcl-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: avahi = 0.6.25-11.el6 is needed by package 
avahi-compat-libdns_sd-0.6.25-11.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libqpol.so.1(VERS_1.2) is needed by package 
setools-gui-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libapol.so.4(VERS_4.0) is needed by package 
setools-libs-tcl-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libpoldiff.so.1(VERS_1.3) is needed by package 
setools-gui-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libpoldiff.so.1(VERS_1.3) is needed by package 
setools-libs-tcl-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libglade-2.0.so.0 is needed by package 
setools-gui-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: libpoldiff.so.1 is needed by package 
setools-libs-tcl-3.3.7-4.el6.i686 (rhel_6_i386)
Error: Missing Dependency: 

[Spacewalk-list] FW: semi-automated spacewalk client registration

[Boyd, Robert]

This is in response to some of the questions I've seen about registering 
clients.  I'm including sanitized versions of 2 scripts that I wrote to make 
this whole process easier since we have several hundred clients spread over 
about multiple sites in multiple cities with various odd domain names involved.

I created spacewalk proxy servers for each of the cities that are remote from 
the master.  These scripts help to automate placing tools on the pub site and 
subtrees for each spacewalk/proxy server and for registration help to pick the 
correct proxy/master when registering a client.

If you decide to use any of what I'm including here you'll need to carefully 
work through the parts that relate the domain name to spacewalk / proxy server. 
  I tried to confine most of that logic to a very small segment of the scripts 
so it won't take searching all over the script for those pieces.  You'll also 
want to pay attention to the activation key naming convention I used and 
replace that with your own.

Also mentioned in this script is a piece that I came up with that gets injected 
into VMware clients for dealing with forcing a reconfig of the vmware tools on 
boot after a kernel update.   This may not be needed with future versions of 
the vmware tools, but most of the servers I'm dealing with still need this.   
If you're interested in having a copy of that script let me know.

On the spacewalk master I use reposync/createrepo to build replicas of the 
minimum components necessary to hook up spacewalk clients and push out copies 
of those to the /var/www/html/pub  trees of the proxy servers. The 
particular content that I pull with reposync is limited by the conf file:

/etc/reposync.conf
[epel-6]
name=Extra Packages for Enterprise Linux 6 - $basearch
baseurl=http://download.fedoraproject.org/pub/epel/6/$basearch/
mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6arch=$basearch
failovermethod=priority
gpgkey=http://download.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL
gpgcheck=1
enabled=1
includepkgs=bea-stax* cobbler editarea gc gc-devel git* jabberd jabberpy* 
jakarta-commons-cli jcommon   \
jfreechart libapreq2 libgsasl* libntlm* libyaml perl-Algorithm-Diff 
perl-Apache-DBI \
perl-BerkeleyDB perl-Cache-Cache perl-Class-MethodMaker 
perl-Class-Singleton\
perl-Convert-BinHex perl-Config-IniFiles perl-Crypt-DES 
perl-Crypt-GeneratePassword \
perl-DateTime perl-DateTime-Format-Mail perl-DateTime-Format-W3CDTF 
perl-Error  \
perl-FreezeThaw perl-Frontier-RPC perl-GD perl-Git perl-Math-FFT 
perl-HTML-TableExtract \
perl-IO-Capture perl-IO-stringy perl-IPC-ShareLite perl-libapreq2 
perl-MIME-Lite\
perl-MIME-tools perl-Net-IPv4Addr perl-Net-SNMP 
perl-Params-Validate perl-Proc-Daemon   \
perl-SOAP-Lite perl-TermReadKey perl-Text-Diff perl-Unix-Syslog 
perl-XML-RSS perl-version   \
perlAlgorithm-Diff python-cheetah python-dmidecode python-ethtool 
python-hashlib python-hwdata python-netaddr PyYAML \
python-simplejson rhino tzdata-java udns*

[rpmforge-6]
name = RPMforge for Enterprise Linux 6 - $basearch
baseurl = http://apt.sw.be/redhat/el6/en/$basearch/rpmforge
mirrorlist = http://apt.sw.be/redhat/el6/en/mirrors-rpmforge
#mirrorlist = file:///etc/yum.repos.d/mirrors-rpmforge
enabled = 1
protect = 0
gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-rpmforge-dag
gpgcheck = 1
includepkgs=amavisd-new arc cabextract clamav* clamd freeze lha lzop nomarch 
perl-Archive-Zip perl-Convert-TNEF \
perl-Convert-UUlib perl-MailTools perl-Net-Server ripole unarj zoo
[spacewalk-client-6]
name = Spacewalk Client for Enterprise Linux 6 - $basearch
baseurl = http://spacewalk.redhat.com/yum/1.7-client/RHEL/6/$basearch/
gpgkey = http://spacewalk.redhat.com/yum/RPM-GPG-KEY-spacewalk-2012
gpgcheck=1

[epel-5]
name=Extra Packages for Enterprise Linux 5 - $basearch
baseurl=http://download.fedoraproject.org/pub/epel/5/$basearch/
mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-5arch=$basearch
failovermethod=priority
gpgkey=http://download.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL
gpgcheck=1
enabled=1
includepkgs=bea-stax* cobbler editarea gc gc-devel git* jabberd jabberpy* 
jakarta-commons-cli jcommon   \
jfreechart libapreq2 libgsasl* libntlm* libyaml perl-Algorithm-Diff 
perl-Apache-DBI \
perl-BerkeleyDB perl-Cache-Cache perl-Class-MethodMaker 
perl-Class-Singleton\
perl-Convert-BinHex perl-Config-IniFiles perl-Crypt-DES 
perl-Crypt-GeneratePassword \
perl-DateTime perl-DateTime-Format-Mail perl-DateTime-Format-W3CDTF 
perl-Error  \
perl-FreezeThaw perl-Frontier-RPC perl-GD perl-Git perl-Math-FFT 
perl-HTML-TableExtract \
perl-IO-Capture perl-IO-stringy perl-IPC-ShareLite 

Re: [Spacewalk-list] feature of spacewalk

[Boyd, Robert]

Yes you can tell yum to install whatever packages you like, or use the Red Hat 
GUI if your client is RHEL; e.g. :

Yum install packagename



Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
e. robert.b...@peoplefluent.com
Visit: www.peoplefluent.comhttp://www.peoplefluent.com/ | Read: Peoplefluent 
Bloghttp://peoplefluent.com/resources/peoplefluent-blog
Follow: @peoplefluenthttp://twitter.com/peoplefluent | Download: iPad 
Apphttp://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8
[cid:image001.jpg@01CDC7E4.297AFF90]http://www.peoplefluent.com/
[cid:image002.jpg@01CDC7E4.297AFF90]http://www.peoplefluent.com/mobile-talent-management

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Mohit Vadhera
Sent: Wednesday, November 21, 2012 12:16 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] feature of spacewalk

Hi,

Can anybody let me know what are other feature of spacewalk other than pushing 
packages from server side ?  Can we install packages from client side or not if 
yes how ?

Thanks,
Mohit
inline: image001.jpginline: image002.jpg___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Organization/Content of spacewalk wiki

[Boyd, Robert]

Chris,

I'm in agreement with you on the organization and content of the Wiki.   My 
experience before coming to spacewalk was working with RHN Satellite Server for 
3+ years and I still found it tricky to get the whole thing working.  I'm still 
in the dark about some of it after getting the basic functions working.

One of the best things that you bring to the table is a fresh set of eyes of 
the person who doesn't have a clue about it from the beginning.   My sense of 
the Wiki is that too much of it is based on presumptions about what people will 
know when they begin the process.   

I have been doing system admin work for 30+ years.  I find it more productive 
when developing instruction guides to do my best to assume my reader knows 
nothing except some bare pre-requisites.

And when there may be thousands of people reading it, also make sure the 
language uses as little jargon as possible especially since many of the readers 
won't be native speakers of English.

And, even though there may be other documentation for other tools that spells 
things out more generously on certain topics, I find it VERY important to 
include a fair amount of how to details when referencing tools that are 
necessary to complete the task.  I prefer to err on the side of verbosity and 
explicit examples rather than the left as an exercise to the student approach 
with reference guides and assembly instructions.

Earlier this year I had some suggestions about a way to make the instructions 
more useful and made suggested edits on the wiki for it.   One of the long time 
contributors shot me down at the time.   I considered what they had to say and 
decided to drop it for the time being.After considering the comments from 
that time I still disagree with the other person's point of view.  From a 
certain perspective they are correct.  From the perspective of making the 
wiki as helpful as possible to neophytes correct isn't the right angle to 
start from.  Sometimes when I'm writing I have to put myself back to the point 
before I knew and understood what I'm teaching so I can help the learner enter 
the depths of the dark forest and hand them a flashlight, a GPS unit and a 
walkie-talkie as they go in.

Spacewalk has many intricacies to it and it would be helpful even to those of 
us with some experience with RHN/Sat Server to have more of the architecture of 
the software laid out in structural and flow diagrams.  I'd also like to see a 
collection of more pointers for difficult issues that arise when learning to 
work with spacewalk. It would be nice to have a much fuller FAQ/compendium of 
that kind.

There are also some links on the wiki that go to the wrong place, e.g. the one 
for how to set up Red Hat clients.  I had to piece together setting up RHEL 
support from several different sites with varying degrees of accuracy since 
they were written relative to different releases of spacewalk and mrepo.  Is 
there some prohibition from Red Hat for having the complete guide for that in 
the wiki for spacewalk?

Whew, That is probably more than enough for this round.


Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
 
e. robert.b...@peoplefluent.com 
Visit: www.peoplefluent.com | Read: Peoplefluent Blog
Follow: @peoplefluent | Download: iPad App




-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Snyder, Chris
Sent: Monday, November 19, 2012 11:57 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Can't register RHEL5 host with 'spacewalk 
default' key

First, I do appreciate the help, and yes, I do realize that the page I 
referenced is an old, CentOS page.But it's been the most clear set of 
instructions I've been able to find.Prior to two weeks ago, I'd done Red 
Hat work for years and never once touched RHN or anything related to it (we 
simply buy our required number RH licenses for all our hosts, use one to 
actually register a single host with RHN, then slurp down the OS + updates via 
mrepo with that host and the do everything else via our local mrepo setup and 
yum - awesome), so channels, keys, etc are all very, very confusing with no 
frame of reference.

I have to admit I'm not finding the actual Spacewalk Wiki all that helpful.  So 
far most of my knowledge has come from the aforementioned (old) CentOS page, 
the RHN Satellite Reference Guide (v5.5), the SW ML archives, and various 
websites out there.   The wiki feels very scattered in the available data and 
the organization of that data.  But that could just be me.

It's been an uphill battle to say the least.  But I've made it this far, so 
I'll go upgrade and see what happens then.

Thank you for the help.
Chris.

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Jan Pazdziora
Sent: Monday, November 19, 2012 11:21 AM
To: spacewalk-list@redhat.com

Re: [Spacewalk-list] rhn-ssl-tool inconsistency

[Boyd, Robert]

Jan,

When I check the help for --gen-server on 1.7 this is what I see:

rhn-ssl-tool --gen-server --help
Usage: rhn-ssl-tool [options]

If confused, please refer to the man page or other documentation
for sample usage.

Options:
  --gen-server  generate the web server's SSL key set, RPM and tar
archive. Review --gen-server --help for more
information.
  --server-key=SERVER_KEY
the web server's SSL private key filename (default:
server.key)
  --server-cert-req=SERVER_CERT_REQ
location of the web server's SSL certificate request
filename (default: server.csr)
  -p PASSWORD, --password=PASSWORD
CA password
  --ca-cert=CA_CERT CA certificate filename (default: RHN-ORG-TRUSTED-SSL-
CERT)
  --ca-key=CA_KEY   CA private key filename (default: RHN-ORG-PRIVATE-SSL-
KEY)
  --startdate=STARTDATE
start date for the web server's SSL certificate
validity (format: YYMMDDHHMMSSZ - where Z is a letter;
default is 1 week ago: 121026155251Z)
  --server-cert=SERVER_CERT
the web server SSL certificate filename (default:
server.crt)
...


This seems to be in conflict with what is in the man page, which as you say 
makes no mention of --ca-cert under --gen-server.

Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
 
e. robert.b...@peoplefluent.com 
Visit: www.peoplefluent.com | Read: Peoplefluent Blog
Follow: @peoplefluent | Download: iPad App




-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Jan Pazdziora
Sent: Friday, November 02, 2012 11:52 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] rhn-ssl-tool inconsistency

On Fri, Nov 02, 2012 at 04:37:50PM +0100, Steve Meier wrote:
 Dear all,
 
 I am currently in the process of migrating my Spacewalk servers from 
 self-signed to trusted certificates.
 
 I am using rhn-ssl-tool to build a new RPM with keys but encountered 
 one problem. While the help and the man page say that there is a --ca-cert 
 option it is not recognized when I call rhn-ssl-tool like this:
 
 [root@spacewalk ssl-build]# rhn-ssl-tool --gen-server --rpm-only 
 --server-key=server.key --server-cert=server.crt 
 --ca-cert=startssl-class2-server.pem
 usage: rhn-ssl-tool [options]
 
 rhn-ssl-tool: error: no such option: --ca-cert
 
 Am I doing something wrong or is there an inconsistency between code and 
 documentation?

I can see the --ca-cert option only mentioned for --gen-ca, not for 
--gen-server.

--
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

Re: [Spacewalk-list] Spacewalk not pushing packages.

[Boyd, Robert]

Steven,

What do you get for output when you do this on a client:

Yum --verbose repolist

?

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Steven Reilly
Sent: Wednesday, October 17, 2012 10:00 AM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Spacewalk not pushing packages.

Hi,

First post.

I've installed and setup Spacewalk on a CentOS 5.8 machine (all of my clients 
are CentOS 5.8 32 and 64 bit)

I have configured Spacewalk to download various CentOS and other repositories 
and all the clients are registered with the server and have osad installed and 
running.

Spacewalk shows that each client is registered and requires a various number of 
update packages but, apart from a job appearing in the Schedule Pending Actions 
when I send packages, nothing much happens. 
Eventually it fails.

The other thing I don't understand is that unless I have .repo files under 
/etc/yum.repo.d/ for repositories which can supply the update packages, when I 
do yum update I get no results - despite Spacewalk telling me that there 
should be.

Also, when I DO add .repo files under /etc/yum.repo.d/ that point to 
repositories which can supply the update packages the downloaded packages come 
from those external servers rather than the local Spacewalk server.

I must have something configured incorrectly.

Any pointers?

Steve

-- 

=
Steven J. Reilly, EDA Engineer
Allegro Microsystems Europe Ltd
Adam Ferguson House, Eskmills Park,
Musselburgh, EH21 7PQ, Scotland.
Tel:+44 (0)131 273 4306
Fax:+44 (0)131 273 4301
e-mail: srei...@allegromicro.com

Any views expressed by me in this mail are mine ... all mine!

Tux-power! Sent from Thunderbird on Linux Mint 13 (xfce)

___
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

Re: [Spacewalk-list] Spacewalk not pushing packages.

[Boyd, Robert]

Steve -- I agree -- that looks fairly similar to what I have on typical clients.

What if you do this on the client end: 

yum --verbose check-update

?

And have you dug around in the rhn or httpd logs on either end?

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Steven Reilly
Sent: Wednesday, October 17, 2012 10:52 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk not pushing packages.

Robert,

It looks valid enough.

yum --verbose repolist
Loading rhnplugin plugin
Loading fastestmirror plugin
Loading priorities plugin
Loading security plugin
Config time: 0.046
Looking for repo options for [main]
Looking for repo options for [centos5-base-x86_64] Repo 'centos5-base-x86_64' 
setting option 'enabled' = '1'
Repo 'centos5-base-x86_64' setting option 'gpgcheck' = '0'
Looking for repo options for [rpmforge-el5-x86_64] Repo 'rpmforge-el5-x86_64' 
setting option 'enabled' = '1'
Repo 'rpmforge-el5-x86_64' setting option 'gpgcheck' = '0'
Looking for repo options for [spacewalk-client-el5-x86_64] Repo 
'spacewalk-client-el5-x86_64' setting option 'enabled' = '1'
Repo 'spacewalk-client-el5-x86_64' setting option 'gpgcheck' = '0'
Looking for repo options for [centos5-extras-x86_64] Repo 
'centos5-extras-x86_64' setting option 'enabled' = '1'
Repo 'centos5-extras-x86_64' setting option 'gpgcheck' = '0'
Looking for repo options for [centos5-updates-x86_64] Repo 
'centos5-updates-x86_64' setting option 'enabled' = '1'
Repo 'centos5-updates-x86_64' setting option 'gpgcheck' = '0'
Yum Version: 3.2.22
Loading mirror speeds from cached hostfile
centos5-base-x86_64 
   |  871 B 
 00:00
centos5-extras-x86_64 
   |  871 B 
 00:00
centos5-updates-x86_64 
   |  871 B 
 00:00
rpmforge-el5-x86_64 
   |  871 B 
 00:00
spacewalk-client-el5-x86_64 
   |  871 B 
 00:00
Setting up Package Sacks
pkgsack time: 0.021
Repo-id  : centos5-base-x86_64
Repo-name: CentOS 5 Base - x86_64
Repo-updated : Wed Oct 10 15:00:58 2012
Repo-pkgs: 3,590
Repo-size: 4.6 G
Repo-baseurl : 
http://edcswalk.eng.allegro.msad/XMLRPC/GET-REQ/centos5-base-x86_64
Repo-expire  : 3,600 second(s) (last: Wed Oct 17 15:42:15 2012)

Repo-id  : centos5-extras-x86_64
Repo-name: CentOS 5 Extras - x86_64
Repo-updated : Wed Oct 10 15:21:25 2012
Repo-pkgs: 274
Repo-size: 157 M
Repo-baseurl : 
http://edcswalk.eng.allegro.msad/XMLRPC/GET-REQ/centos5-extras-x86_64
Repo-expire  : 3,600 second(s) (last: Wed Oct 17 15:42:15 2012)

Repo-id  : centos5-updates-x86_64
Repo-name: CentOS 5 Updates - x86_64
Repo-updated : Wed Oct 10 00:15:03 2012
Repo-pkgs: 1,083
Repo-size: 5.0 G
Repo-baseurl : 
http://edcswalk.eng.allegro.msad/XMLRPC/GET-REQ/centos5-updates-x86_64
Repo-expire  : 3,600 second(s) (last: Wed Oct 17 15:42:15 2012)

Repo-id  : rpmforge-el5-x86_64
Repo-name: RPMforge EL5 - x86_64
Repo-updated : Sat Oct  6 14:32:11 2012
Repo-pkgs: 11,148
Repo-size: 5.8 G
Repo-baseurl : 
http://edcswalk.eng.allegro.msad/XMLRPC/GET-REQ/rpmforge-el5-x86_64
Repo-expire  : 3,600 second(s) (last: Wed Oct 17 15:42:15 2012)

Repo-id  : spacewalk-client-el5-x86_64
Repo-name: Spacewalk Client - EL5 - x86_64
Repo-updated : Sat Oct  6 14:33:25 2012
Repo-pkgs: 21
Repo-size: 1.9 M
Repo-baseurl : 
http://edcswalk.eng.allegro.msad/XMLRPC/GET-REQ/spacewalk-client-el5-x86_64
Repo-expire  : 3,600 second(s) (last: Wed Oct 17 15:42:15 2012)

repolist: 16,116

The machine I ran it on has 5 updates showing in Spacewalk BUT when I click to 
see which patches I see 8?!

Running yum update on the client gives no updates (none in yumex either)

Steve


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

[Spacewalk-list] Kickstart related error -- need help debugging

[Boyd, Robert]

I'm getting emails sent to root on my spacewalk 1.7 server.   It looks like 
there's something going on with kickstarts, even though I'm not really using 
kickstart explicitly currently.  There's a lot of output - where should I send 
this kind of error output to have someone look through it for clues?

Here is the first part of one of these messages:

Exception reported from rhqengbld03.corp.peopleclick.com
Time: Mon Oct  8 13:03:49 2012
Exception type type 'exceptions.IOError'
Exception while handling function repodata
Request object information:
URI: /XMLRPC/GET-REQ/rhel-x86_64-server-5/repodata/comps.xml
Remote Host:  sanitized client name
Server Name: spacewalk-server:80
Headers passed in:
Accept-Encoding: identity
Connection: close
DOCUMENT_ROOT: /var/www/html
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT_ENCODING: identity
HTTP_CONNECTION: close
HTTP_HOST: spacewalk-server
HTTP_PRAGMA: no-cache
HTTP_USER_AGENT: rhn.rpclib.py/$Revision$
HTTP_X_RHN_AUTH: 2cnQ5FDMfiI4HfZb6EH1wA==
HTTP_X_RHN_AUTH_EXPIRE_OFFSET: 3600.0
HTTP_X_RHN_AUTH_SERVER_TIME: 1349712229.44
HTTP_X_RHN_AUTH_USER_ID:
HTTP_X_RHN_SERVER_ID: 110223
HTTP_X_RHN_TRANSPORT_CAPABILITY: follow-redirects=3
Host: spacewalk-server
PATH_INFO: /GET-REQ/rhel-x86_64-server-5/repodata/comps.xml
PATH_TRANSLATED: 
/var/www/html/GET-REQ/rhel-x86_64-server-5/repodata/comps.xml
Pragma: no-cache
QUERY_STRING:
REMOTE_ADDR: ip address deleted
REMOTE_PORT: 50434
REQUEST_METHOD: GET
REQUEST_URI: /XMLRPC/GET-REQ/rhel-x86_64-server-5/repodata/comps.xml
SCRIPT_FILENAME: /usr/share/rhn/wsgi/xmlrpc.py
   SCRIPT_NAME: /XMLRPC
SCRIPT_URI: 
http://spacewalk-server/XMLRPC/GET-REQ/rhel-x86_64-server-5/repodata/comps.xml
SCRIPT_URL: /XMLRPC/GET-REQ/rhel-x86_64-server-5/repodata/comps.xml
SERVER_ADDR: ip address deleted
SERVER_ADMIN: root@localhost
SERVER_NAME: spacewalk-server
SERVER_PORT: 80
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: addressApache Server at spacewalk-server Port 
80/address

SERVER_SOFTWARE: Apache
User-Agent: rhn.rpclib.py/$Revision$
X-RHN-Auth: 2cnQ5FDMfiI4HfZb6EH1wA==
X-RHN-Auth-Expire-Offset: 3600.0
X-RHN-Auth-Server-Time: 1349712229.44
X-RHN-Auth-User-Id:
X-RHN-Server-Id: 110223
X-RHN-Transport-Capability: follow-redirects=3
mod_wsgi.application_group: spacewalk-server|/xmlrpc
mod_wsgi.callable_object: application
mod_wsgi.handler_script:
mod_wsgi.input_chunked: 0
mod_wsgi.listener_host:
mod_wsgi.listener_port: 80
mod_wsgi.process_group:
mod_wsgi.request_handler: wsgi-script
mod_wsgi.script_reloading: 1
mod_wsgi.version: (3, 2)
wsgi.errors: mod_wsgi.Log object at 0x7fd1fddbdfb0
wsgi.file_wrapper: built-in method file_wrapper of mod_wsgi.Adapter 
object at 0x7fd1fe0103f0
wsgi.input: mod_wsgi.Input object at 0x7fd216f23b30
wsgi.multiprocess: True
wsgi.multithread: False
wsgi.run_once: False
wsgi.url_scheme: http
wsgi.version: (1, 1)

Exception Handler Information
Traceback (most recent call last):
  File /usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py, 
line 122, in call_function
response = apply(func, params)
  File /usr/lib/python2.6/site-packages/spacewalk/server/rhnRepository.py, 
line 252, in repodata
return self._repodata_taskomatic(file_name)
  File /usr/lib/python2.6/site-packages/spacewalk/server/rhnRepository.py, 
line 221, in _repodata_taskomatic
return self._repodata_python(file_name)
  File /usr/lib/python2.6/site-packages/spacewalk/server/rhnRepository.py, 
line 196, in _repodata_python
output = repo.get_comps_file()
  File 
/usr/lib/python2.6/site-packages/spacewalk/server/repomd/repository.py, line 
165, in get_comps_file
return comps_view.get_file()
  File /usr/lib/python2.6/site-packages/spacewalk/server/repomd/view.py, line 
347, in get_file
comps_file = open(self.comps.filename)
IOError: [Errno 2] No such file or directory: 
'/var/satellite/rhn/kickstart/ks-rhel-x86_64-server-5/Server/repodata/comps-rhel5-server-core.xml'


I'm not sure why anything is looking for something under kickstart at all ... 
if someone is willing to look at it, I can send the rest of the error output.

Thanks,

Robert Boyd
Senior Systems Engineer
Phone: 919-645-2972
Mobile: 919-306-4681
Peoplefluent
434 Fayetteville Street
Raleigh, NC  27601

robert.b...@peoplefluent.commailto:michael.dileona...@peoplefluent.com

[cid:image001.png@01CDA55D.63E13EA0]



This email message is for the sole use of the intended recipient(s) and may 
contain confidential information. Any unauthorized review, use, disclosure or 
distribution is prohibited. If you are 

Re: [Spacewalk-list] Use gensystemid to create systemid, then mrepo to download RHEL6 repositories

[Boyd, Robert]

You need an update to the lookup table for release names.   I have the updated 
table on my spacewalk server.   I will send you something afterwhile - I can't 
get to it right now.

Robert

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of fn...@yahoo.com
Sent: Friday, October 05, 2012 3:45 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Use gensystemid to create systemid, then mrepo to 
download RHEL6 repositories

Hi, This should be a common issue, but I haven't found the solution yet.

# gensystemid -u rhnusername -p rhnpassword --release=6server --arch=x86_64 
/mrepo/rhel_6_server-x86_64
gensystemid: Release name 6server is not a known RHN release.

# gensystemid -h | grep rhnrelease
  -r, --release=rhnrelease specify rhn release {2.1,3,4}{AS,ES,WS,Desktop} 
5{Server,Client}

The question is how to use gensystemid to create systemid and then mrepo to 
download RHEL6 repositories?

Thank you in advance!

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

Re: [Spacewalk-list] Feature Request: Extra CSV Dumps

[Boyd, Robert]

Jan,

Thank you for this suggestion.   I'm curious where exactly I should go to find 
out what the reports package is capable of doing.
I looked at the wiki pages and I'm having difficulty finding any reference to 
this package.

Robert

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Jan Pazdziora
Sent: Monday, October 01, 2012 3:57 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Feature Request: Extra CSV Dumps

On Fri, Sep 28, 2012 at 01:32:08PM -0400, Boyd, Robert wrote:
 Actually what would be also nice would be to have a report that will list the 
 date/times when each item was updated for each client.   
 
 So -- what I would want based on my experience with requests from auditors is 
 a list by client of package name, new version, release date, some kind of 
 indication if the update is an errata bugfix, old version and date the update 
 occurred.   Having it as CSV would be an extra bonus I suppose.
 

Please check the spacewalk-reports package, it's been created with auditors in 
mind.

--
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] Error trying to access Proxy link

[Boyd, Robert]

When looking at a spacewalk proxy server detail information page there is a 
button/tab for Proxy
When I click on this 
https://spacewalk-server.company.com/network/systems/details/proxy.pxt?sid=110038

I get the following:
Permission Error

You do not have the appropriate permission set to access the requested page. 
You may have reached this error page in one of several ways:

 1.  Your login session has expired. For security reasons, Red Hat Network 
terminates your login session after 15 minutes of inactivity. To sign in again, 
click herehttps://spacewalk.corp.peopleclick.com/.
 2.  You've found an error in our site. Please contact your Support 
representative with details of how you received this message.
 3.  Your browser does not have cookies enabled. The Red Hat Network requires 
cookies in order to function; if you have disabled them, please re-enable them 
to use the site.
 4.  You've done something naughty. Stop it.

The strange thing is that I'm logged in as the organization manager when I 
tried to do this.   I believe this user has all of the necessary privileges.   
So ... what else could be going on here?  Everything else in the web site seems 
to be working normally.



Robert Boyd
Senior Systems Engineer
Phone: 919-645-2972
Mobile: 919-306-4681
Peoplefluent
434 Fayetteville Street
Raleigh, NC  27601

robert.b...@peoplefluent.commailto:michael.dileona...@peoplefluent.com

[cid:image001.png@01CDA002.B93B4360]



This email message is for the sole use of the intended recipient(s) and may 
contain confidential information. Any unauthorized review, use, disclosure or 
distribution is prohibited. If you are not the intended recipient, please 
contact the sender by reply email and destroy all copies of the original 
message.

inline: image001.png___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Feature Request: Extra CSV Dumps

[Boyd, Robert]

Actually what would be also nice would be to have a report that will list the 
date/times when each item was updated for each client.   

So -- what I would want based on my experience with requests from auditors is a 
list by client of package name, new version, release date, some kind of 
indication if the update is an errata bugfix, old version and date the update 
occurred.   Having it as CSV would be an extra bonus I suppose.

Thanks for bringing this up Anton.

Robert Boyd

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Anton Pritchard-Meaker
Sent: Friday, September 28, 2012 1:00 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Feature Request: Extra CSV Dumps

Hi,

I don't know if this will be useful for anyone else, but for audit and change 
management purposes I have to log which packages are updated during patching. 
Would it be possible for Spacewalk to generate a csv of any packages that are 
to be updated when this is kicked off via the GUI? 

The screen showing the existing package and the one replacing it would be 
really nice to get a csv of for this. We're currently using ouputs of yum 
commands.

Cheers, 


Anton Pritchard-Meaker | Unix Engineer

antonpm1 Skype

 

KIT digital | York | www.kitd.com  |  NASDAQ: KITD  |  Vision of the Future

___
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

Re: [Spacewalk-list] Spacewalk server stopped due to Tomcat6 Error code 4

[Boyd, Robert]

Why is it calling out /logs?   What OS are you running on?  On RHEL it should 
be pointing to /var/log/tomcat6

What shows up in /var/log/messages for the time when you try to restart 
spacewalk?   Are you using  the command spacewalk-server restart ?

Robert

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of fn...@yahoo.com
Sent: Tuesday, September 25, 2012 11:50 AM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] Spacewalk server stopped due to Tomcat6 Error code 4

Hi, We have a new issue here. The Spacewalk server was working fine one month 
ago, and we haven't touched it during this period of time. In other words, no 
configurations have been changed. It's a virtual host and I am not sure if 
there is any vmware change. Now all the sudden it can't be started because of a 
Tomcat6 issue. Here are the errors:

# service tomcat6 restart
Stopping tomcat6:  [  OK  ]
Starting tomcat6: Error code 4   [FAILED]

# tomcat6 start
/usr/sbin/tomcat6: line 30: /logs/catalina.out: No such file or directory
Please help. Thank you!

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

[Spacewalk-list] Spacewalk Startup Problems after yum update

[Boyd, Robert]

I'm running spacewalk 1.7 on RHEL6.3 and Friday I applied yum updates.   This 
morning I discovered that there is something severely wrong with the server.   
I attempted to sign in to the spacewalk management website and got a 404 error:

HTTP Status 404 -

type Status report
message
description The requested resource () is not available.

Apache Tomcat/6.0.24

I see that there is a series of error messages about JVM failing to start in 
/var/log/messages:

Sep 24 11:09:00 rhqengbld03 wrapper[2230]: Startup failed: Timed out waiting 
for signal from JVM.
Sep 24 11:09:01 rhqengbld03 wrapper[2230]: JVM did not exit on request, 
terminated
Sep 24 11:09:01 rhqengbld03 wrapper[2230]: JVM exited in response to signal 
SIGKILL (9).
Sep 24 11:09:05 rhqengbld03 wrapper[2230]: Launching a JVM...
Sep 24 11:09:34 rhqengbld03 wrapper[2230]: Startup failed: Timed out waiting 
for signal from JVM.
Sep 24 11:09:34 rhqengbld03 wrapper[2230]: JVM did not exit on request, 
terminated
Sep 24 11:09:35 rhqengbld03 wrapper[2230]: JVM exited in response to signal 
SIGKILL (9).
Sep 24 11:09:39 rhqengbld03 wrapper[2230]: Launching a JVM...
Sep 24 11:10:08 rhqengbld03 wrapper[2230]: Startup failed: Timed out waiting 
for signal from JVM.
Sep 24 11:10:08 rhqengbld03 wrapper[2230]: JVM did not exit on request, 
terminated
Sep 24 11:10:09 rhqengbld03 wrapper[2230]: JVM exited in response to signal 
SIGKILL (9).
Sep 24 11:10:13 rhqengbld03 wrapper[2230]: Launching a JVM...
Sep 24 11:10:42 rhqengbld03 wrapper[2230]: Startup failed: Timed out waiting 
for signal from JVM.
Sep 24 11:10:42 rhqengbld03 wrapper[2230]: JVM did not exit on request, 
terminated
Sep 24 11:10:43 rhqengbld03 wrapper[2230]: JVM exited in response to signal 
SIGKILL (9).
Sep 24 11:10:47 rhqengbld03 wrapper[2230]: Launching a JVM...
Sep 24 11:11:16 rhqengbld03 wrapper[2230]: Startup failed: Timed out waiting 
for signal from JVM.
Sep 24 11:11:16 rhqengbld03 wrapper[2230]: JVM did not exit on request, 
terminated
Sep 24 11:11:17 rhqengbld03 wrapper[2230]: JVM exited in response to signal 
SIGKILL (9).
Sep 24 11:11:17 rhqengbld03 wrapper[2230]: There were 5 failed launches in a 
row, each lasting less than 300 seconds.  Giving up.
Sep 24 11:11:17 rhqengbld03 wrapper[2230]:   There may be a configuration 
problem: please check the logs.
Sep 24 11:11:17 rhqengbld03 wrapper[2230]: -- Wrapper Stopped

Looking at /var/log/tomcat6/catalina logs I found several messages.   One that 
looks like it might be central to the problems is this:

INFO: Deploying configuration descriptor rhn.xml
Sep 24, 2012 11:08:12 AM org.apache.catalina.loader.WebappLoader start
SEVERE: LifecycleException
java.io.IOException: Failed to access resource /WEB-INF/lib/postgresql-jdbc.jar
at 
org.apache.catalina.loader.WebappLoader.setRepositories(WebappLoader.java:1022)
at org.apache.catalina.loader.WebappLoader.start(WebappLoader.java:653)
at 
org.apache.catalina.core.StandardContext.start(StandardContext.java:4341)
at 
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at 
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
at 
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at 
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at 
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)


I looked for the listed postgresql-jdbc.jar file and see that there is a failed 
link:

lrwxrwxrwx. 1 tomcat tomcat 35 Aug  3 19:02 
/var/lib/tomcat6/webapps/rhn/WEB-INF/lib/postgresql-jdbc.jar - 
/usr/share/java/postgresql-jdbc.jar

In /usr/share/java there are these 2 files:

-rwxr-xr-x. 1 root root 502118 Nov 18  2010 postgresql-8.4-702.jdbc3.jar
-rwxr-xr-x. 1 root root 539510 Nov 18  2010 postgresql-8.4-702.jdbc4.jar

There is no plain vanilla versionless postgresql-jdbc.jar

So I linked the missing name to the postgresql-8.4-702.jdbc4.jar to see what 
will happen.

I restarted the server and now the spacewalk web service appears to be fully 
operational again.


My question is:  why would this link have been trashed?  Is there anything I 
can do preemptively to prevent getting caught like this again?


Robert Boyd
Senior Systems Engineer
Phone: 919-645-2972
Mobile: 919-306-4681
Peoplefluent
434 Fayetteville Street
Raleigh, NC  27601

robert.b...@peoplefluent.commailto:michael.dileona...@peoplefluent.com

[cid:image001.png@01CD9A4E.D98CEAB0]



This email message is for the sole use of the intended recipient(s) and may 
contain confidential information. Any unauthorized review, use, disclosure or 
distribution is prohibited. If you are not the intended recipient, please 
contact the sender by reply email and destroy all copies of the original 
message.

inline: 

[Spacewalk-list] spacewalk-common-channels infinite looping

[Boyd, Robert]

I am trying to use spacewalk-common-channels to create all of the channel 
structures for CentOS 4, 5 and 6 and I'm running into a problem right away.   
It appears that the  program is going into an infinite loop processing the 
channel info.   If I tell it to list the available channels I get some nice 
output.   When I tell it to create the channels for CentOS5  it goes away and 
never comes back.I added some additional print to take advantage of the 
verbose option and was able to see that it was looping forever over what 
appears to be the same data.

I only know enough python to hack around a little bit, so I'm not sure how to 
debug this thing.   There really isn't very much built in diagnostic output to 
be able to see what it's trying to do.   I'll be happy to throw several debug 
statements in once I have some better understanding of how the code is 
structured.

Anyone on the list familiar with the code enough to give me some pointers?

Thanks,


Robert Boyd
Senior Systems Engineer
Phone: 919-645-2972
Mobile: 919-306-4681
Peoplefluent
434 Fayetteville Street
Raleigh, NC  27601

robert.b...@peoplefluent.commailto:michael.dileona...@peoplefluent.com

[cid:image001.png@01CD974F.93FC2BC0]



This email message is for the sole use of the intended recipient(s) and may 
contain confidential information. Any unauthorized review, use, disclosure or 
distribution is prohibited. If you are not the intended recipient, please 
contact the sender by reply email and destroy all copies of the original 
message.

inline: image001.png___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] spacewalk-common-channels infinite looping

[Boyd, Robert]

I reworked some of the debug output and now it's actually doing something that 
looks more or less rational.I'm not sure what the problem was, but it 
appears that I may have made a small but significant error in indent level at 
some point when inserting the debug output statements.

I must say - it would be very nice if code like this routine was well 
commented.  It seems that if it's going to be looked at in an open-source 
community there should be more elaborate comments that explain the design of 
the program.   The code is easy to read, but it not self documenting.

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Boyd, Robert
Sent: Thursday, September 20, 2012 4:48 PM
To: spacewalk-list@redhat.com
Subject: [Spacewalk-list] spacewalk-common-channels infinite looping

I am trying to use spacewalk-common-channels to create all of the channel 
structures for CentOS 4, 5 and 6 and I'm running into a problem right away.   
It appears that the  program is going into an infinite loop processing the 
channel info.   If I tell it to list the available channels I get some nice 
output.   When I tell it to create the channels for CentOS5  it goes away and 
never comes back.I added some additional print to take advantage of the 
verbose option and was able to see that it was looping forever over what 
appears to be the same data.

I only know enough python to hack around a little bit, so I'm not sure how to 
debug this thing.   There really isn't very much built in diagnostic output to 
be able to see what it's trying to do.   I'll be happy to throw several debug 
statements in once I have some better understanding of how the code is 
structured.

Anyone on the list familiar with the code enough to give me some pointers?

Thanks,


Robert Boyd
Senior Systems Engineer
Phone: 919-645-2972
Mobile: 919-306-4681
Peoplefluent
434 Fayetteville Street
Raleigh, NC  27601

robert.b...@peoplefluent.commailto:michael.dileona...@peoplefluent.com

[cid:image001.png@01CD9751.E71412D0]



This email message is for the sole use of the intended recipient(s) and may 
contain confidential information. Any unauthorized review, use, disclosure or 
distribution is prohibited. If you are not the intended recipient, please 
contact the sender by reply email and destroy all copies of the original 
message.

inline: image001.png___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] PostGreSQL Maintenance Guidelines for Spacewalk

[Boyd, Robert]

Thank you for your reply.

The idea of a video of your lectures sounds perfect.   You could post the 
handouts to a website and put a link in the description/comments posted with 
the video.

So, in the pgsql documentation I will find clear easy to follow instructions on 
how to make regular backups of the spacewalk database?

Thank you,
Robert

From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Paul Robert Marino
Sent: Friday, September 14, 2012 4:06 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] PostGreSQL Maintenance Guidelines for Spacewalk


Well you can find that scattered all over the web but. The best place is 
postgresqls documentation its self.
That being said I'm considering doing a series of lectures starting with 
initial basic configuration and maitnence then eventialy doing one on streaming 
replication, possibly even one covering some more advanced stuff like plsql and 
plperl. If I do would it be helpfull to video tape the lectures and put them on 
youtube or simmilar streaming video site.  My only problem with youtube is I 
can't attache the handouts directly to the video which is the only reason I 
would consider putting it somwhere else.
On Sep 14, 2012 2:29 PM, Boyd, Robert 
robert.b...@peoplefluent.commailto:robert.b...@peoplefluent.com wrote:
Since I'm not an experienced PostGreSQL admin, where can I find guidelines, 
scripts, etc for doing routine maintenance tasks like DB backups, storage 
tuning, etc like there is for the users who have Oracle as their back end?


Robert Boyd
Senior Systems Engineer
Phone: 919-645-2972tel:919-645-2972
Mobile: 919-306-4681tel:919-306-4681
Peoplefluent
434 Fayetteville Street
Raleigh, NC  27601

robert.b...@peoplefluent.commailto:michael.dileona...@peoplefluent.com

[cid:image001.png@01CD9586.910B0FF0]



This email message is for the sole use of the intended recipient(s) and may 
contain confidential information. Any unauthorized review, use, disclosure or 
distribution is prohibited. If you are not the intended recipient, please 
contact the sender by reply email and destroy all copies of the original 
message.


___
Spacewalk-list mailing list
Spacewalk-list@redhat.commailto:Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
inline: image001.png___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list