Re: [Spacewalk-list] Spacewalk client not checking in on CentOS 7

2020-01-08 Thread Nicole Beck 
Hi Len,
I had the same problem with centos 7.  I think I had to enable and start the 
rhnsd.timer as well as rhnsd.service in order for the client to check in.

This is what I have in my notes.

systemctl enable rhnsd.service
systemctl start rhnsd.service

systemctl enable rhnsd.timer
systemctl start rhnsd.timer

[root@gonzo ~]# systemctl is-active rhnsd.timer
active
[root@gonzo ~]#
[root@gonzo ~]# systemctl is-enabled rhnsd.timer
enabled

[root@gonzo ~]# systemctl list-timers
NEXT LEFT  LAST PASSED UNIT
Wed 2019-05-29 13:50:43 EDT  5s left   n/a  n/asystemd-tmpfiles-clean.ti
Wed 2019-05-29 16:10:13 EDT  2h 19min left n/a  n/arhnsd.timer

Hope this helps.
Nicole



From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Brian Long
Sent: Wednesday, January 8, 2020 8:03 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk client not checking in on CentOS 7

On Wed, Jan 8, 2020 at 7:54 AM Len Ewen 
mailto:ew...@uindy.edu>> wrote:
I know this a stupid noob question but I have a problem.  I've got a clean 
built, fresh out of the box spacewalk 2.9 server and a 2.9 client.  The client 
checked in once, but hasn't checked again for the last 16 hours.  16 hours 
seems like a long time for a check in to happen, but I am not sure what is 
going on.  What am I missing?  Do I need to set up a cron job to update or 
something?

Look into setting up the optional osad.  
https://github.com/spacewalkproject/spacewalk/wiki/OsadHowTo

/Brian/

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

Re: [Spacewalk-list] [EXT]:Re: CentOS repos reappear in /etc/yum.repos.d

2019-12-05 Thread Nicole Beck 
Hello,
I double checked my configuration, and I did not have "enabled=0" in the base, 
updates, and extras stanzas of the /etc/yum.repos.d/CentOS-Base.repo file.  
After adding this, either by editing the file with vi or using 
yum-config-manager --disable, I am able to update the centos-release package 
and the CentOS repository files are not changed.

Thank you all for your help! 
Nicole

-Original Message-
From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Gerald Vogt
Sent: Wednesday, November 27, 2019 3:18 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] [EXT]:Re: CentOS repos reappear in 
/etc/yum.repos.d

On 27.11.19 20:11, Dawn Mathews John wrote:
> Just an assumption.
> 
> I have been through this situation, that the /etc/yum.repos.d/ 
> CentOS-* are enabled even after disabling or deleting the files. Upon

I find that most peculiar that you have centos7 repositories still enabled even 
after deleting the repo files. Are you sure? After deleting 
/etc/yum.repos.d/CentOS-Base.repo  'yum repolist' does still show a repository 
with repo id "base/7/x86_64"?

Whatever I tried, for me it all works as expected. If I take the original 
CentOS-Base.repo (i.e. without disabling the base, updates and extras 
repositories in the file) I see those repositories ids. If I delete the file, 
those repositories are gone (until of course, a later centos-release update 
restores it...)

> investigating I found that, updating packages by yum update will also 
> update the rpm package - centos-release*.rpm. Once this RPM is 
> installed, this would replace the original contents of the repo directory.

Well, each minor CentOS Update (e.g. 7.6 to 7.7. will update centos-release and 
thus restore the repo file if you delete it).

However, we have all repositories in the repo files disabled, as we provide 
them through spacewalk, and they are never popping up again after any update.

-Gerald

> 
> I wonder, if this is your issue.
> 
> 
> On Thu, 28 Nov, 2019, 12:30 am Kennedy, Cameron, 
> mailto:cameron.kenn...@lendlease.com>>
> wrote:
> 
> I am suspect that you don't have all the enable=0 set throughout the
> repo file. (there is usually more than 1). Perhaps for the sake of
> testing, Remove the files from /etc/yum.repos.d and then try again.
> Then add them back in to identify the offending one. Also check
> /etc/yum.conf doesn't have any repo entries directly in there.
> 
> 
> -Original Message-
> From: spacewalk-list-boun...@redhat.com
> <mailto:spacewalk-list-boun...@redhat.com>
>  <mailto:spacewalk-list-boun...@redhat.com>> On Behalf Of Nicole Beck
> Sent: Wednesday, November 27, 2019 1:52 PM
> To: 'spacewalk-list@redhat.com <mailto:spacewalk-list@redhat.com>'
> mailto:spacewalk-list@redhat.com>>
> Subject: [EXT]:Re: [Spacewalk-list] CentOS repos reappear in
> /etc/yum.repos.d
> 
> Thank you for your replies!
> 
> This is the repolist after installing the spacewalk client software
> but before registering the client:
> 
> # yum repolist
> Loaded plugins: fastestmirror, langpacks Loading mirror speeds from
> cached hostfile
>   * base: mirror.siena.edu <http://mirror.siena.edu>
>   * epel: mirror.siena.edu <http://mirror.siena.edu>
>   * extras: mirror.siena.edu <http://mirror.siena.edu>
>   * updates: mirror.siena.edu <http://mirror.siena.edu>
> repo id                  repo name 
>        status
> base/7/x86_64            CentOS-7 - Base   
>        10,097
> epel/x86_64              Extra Packages for Enterprise Linux 7 -
> x86_64   13,476
> extras/7/x86_64          CentOS-7 - Extras 
>           305
> spacewalk-client/x86_64  Spacewalk Client Tools 
>           95
> updates/7/x86_64         CentOS-7 - Updates 
>          738
> repolist: 24,711
> 
> I registered the client. All of the /etc/yum.repos.d/CentOS* files
> already have "enabled=0" set (before registering the client). I then
> ran "yum clean all", and the "yum repolist" still shows the CentOS7
> repos as well as my local repos.  Shouldn't I just see my local
> spacewalk repos when running "yum repolist?
> 
> # spacewalk-channel -l
> centos7-updates
> centos7-spacewalk29-client
> centos7-base
> centos7
> 
> # yum repolist
> Loaded plugins: fastestmirror, langpacks, rhnplugin This system is
> receiving updates from RHN Classic or Red Hat Satellite.
&

Re: [Spacewalk-list] CentOS repos reappear in /etc/yum.repos.d

2019-11-27 Thread Nicole Beck 
st this sender and 
>>> know the content is safe before clicking on any links or attachments.
>>> The centos-release rpm contains all the repo files. If they are 
>>> missing they are restored during the next install/update. That is 
>>> standard rpm behavior for config files in rpms.
>>> Don't (re)move the CentOS repo files. If you don't want to use those 
>>> repos, modify the files and set all repositories in the files to 
>>> "enabled=0".
>>> Config files are not overwritten if they exist. That's the case for 
>>> any config file from any rpm.
>>> For example, if you have installed the apache webserver with the 
>>> httpd rpm you cannot remove the welcome page by deleting 
>>> /etc/httpd/conf.d/welcome.conf. It would come back during the next 
>>> update.
>>> -Gerald
>>> On 27.11.19 18:43, Nicole Beck wrote:
>>>> Hello,
>>>>
>>>> I have a Spacewalk 2.9 server and a CentOS 7 client using the 
>>>> Spacewalk
>>>> 2.9 client.  After registering the client with rhnreg_ks, I moved 
>>>> all of the files from /etc/yum.repos.d to /etc/yum.repos.d.o. The 
>>>> "yum repolist" command shows that I'm using the repositories from 
>>>> my spacewalk server. I've noticed that when I update the client 
>>>> (specifically the centos-release package), the Centos-* repository 
>>>> files reappear in /etc/yum.repos.d.  Is there any way to prevent 
>>>> this from happening?
>>>>
>>>> Thanks,
>>>>
>>>> Nicole
>>>>
>>>>
>>>> ___
>>>> Spacewalk-list mailing list
>>>> Spacewalk-list@redhat.com
>>>> https://urldefense.com/v3/__https://www.redhat.com/mailman/listinfo
>>>> /sp 
>>>> acewalk-list__;!vF5gcTc1DeE!ziEpNqL3OxQw46m6GWCxxERXFNhqOHdMKqHStJr
>>>> P0V
>>>> b5lgUwobIzd5yBLoKe51E$
>>>>
>>> ___
>>> Spacewalk-list mailing list
>>> Spacewalk-list@redhat.com
>>> https://urldefense.com/v3/__https://www.redhat.com/mailman/listinfo/
>>> spacewalk-list__;!vF5gcTc1DeE!ziEpNqL3OxQw46m6GWCxxERXFNhqOHdMKqHStJ
>>> rP0Vb5lgUwobIzd5yBLoKe51E$ 
>>> ___
>>> 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
>>
> 
> This electronic transmission (and any attachments thereto) is intended 
> solely for the use of the addressee(s). It may contain confidential or 
> legally privileged information. If you are not the intended recipient 
> of this message, you must delete it immediately and notify the sender. 
> Any unauthorized use or disclosure of this message is strictly prohibited.
> Faurecia does not guarantee the integrity of this transmission and 
> shall therefore never be liable if the message is altered or falsified 
> nor for any virus, interception or damage to your system.
> 
> ___
> 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] CentOS repos reappear in /etc/yum.repos.d

2019-11-27 Thread Nicole Beck 
Hello,
I have a Spacewalk 2.9 server and a CentOS 7 client using the Spacewalk 2.9 
client.  After registering the client with rhnreg_ks, I moved all of the files 
from /etc/yum.repos.d to /etc/yum.repos.d.o.  The "yum repolist" command shows 
that I'm using the repositories from my spacewalk server. I've noticed that 
when I update the client (specifically the centos-release package), the 
Centos-* repository files reappear in /etc/yum.repos.d.  Is there any way to 
prevent this from happening?

Thanks,
Nicole

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

Re: [Spacewalk-list] help with ubuntu16 client and spacewalk2.9 server

2019-08-28 Thread Nicole Beck 
Hi Robert,

Here are the pertinent lines for "apt-get --simulate upgrade".

root@beaker:/etc/apt/sources.list.d# apt-get --simulate upgrade  python-wadllib 
Reading package lists... Done Building dependency tree Reading state 
information... Done Calculating upgrade... Done The following package was 
automatically installed and is no longer required:
  libsigsegv2
Use 'apt autoremove' to remove it.
The following packages have been kept back:
  libdrm2 libparse-debianchangelog-perl libpython-stdlib linux-image-virtual
  lsb-release open-vm-tools python python-minimal python3 ubuntu-minimal The 
following packages will be upgraded:
...
  python-wadllib python2.7 python2.7-minimal python3-apparmor python3-apport ...
Inst python-wadllib [1.3.2-3] (1.3.2-3ubuntu0.16.04.1 
Ubuntu:16.04/ubuntu16-xenial-updates [all]) ...
Conf python-wadllib (1.3.2-3ubuntu0.16.04.1 
Ubuntu:16.04/ubuntu16-xenial-updates [all])


I have everything commented out of /etc/apt/sources.list so it is getting the 
packages from /etc/apt/sources.list.d/spacewalk.list.  

I'm not sure if this is helpful or not, but " apt list --upgradable|wc" is 496, 
but in spacewalk, Systems - Software - Packages - Upgrade shows 247.

Thanks!
Nicole

-Original Message-
From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Robert Paschedag
Sent: Tuesday, August 27, 2019 2:43 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] help with ubuntu16 client and spacewalk2.9 server

Can you check from the client with "apt-get", if the package "python-wadllib" 
is really an upgrade candidate?

Might be an error, that spacewalk "thinks" it is an update for the server but 
it isn't.

Robert

⁣sent from my mobile device​


 Originale Nachricht 
Von: Nicole Beck 
Gesendet: Tue Aug 27 19:13:51 GMT+02:00 2019
An: "'spacewalk-list@redhat.com'" 
Betreff: [Spacewalk-list] help with ubuntu16 client and spacewalk2.9 server

Hello,
I'm trying to get an Ubuntu 16 xenial client setup to do updates from a 
spacewalk 2.9 server installed on CentOS7.  I am able to register the client, 
install and remove, or update a single package thru the spacewalk web 
interface. But when I try to update all of the packages on (choose system - 
Software - Packages tab - Upgrade tab - choose Select All - Upgrade packages - 
confirm), then run "rhn_check -vvv" on the client, it fails with:

...
Apt-Spacewalk: Updating sources.list
D: Failed to update package['python-wadllib', '1.3.2', '3ubuntu0.16.04.1', '', 
'all-deb']
D: Sending back response(1, 'update failed', {})
D: do_call packages.checkNeedUpdate('rhnsd=1',){}
D: Called refresh_list
Updating package profile
D: rpcServer: Calling XMLRPC registration.welcome_message
D: rpcServer: Calling XMLRPC registration.update_packages
D: local action status: (0, 'package list refreshed', {})
D: rpcServer: Calling XMLRPC registration.welcome_message

I could use the web interface to update the single package that it says it is 
failing on.

I used the steps listed in 
https://www.redhat.com/archives/spacewalk-list/2019-January/msg6.html to 
get this setup. I installed the 2.8 spacewalk client referenced in the thread, 
and I signed the repos per the documentation at 
http://www.devops-blog.net/spacewalk/gpg-signing-apt-repository-in-spacewalk. I 
checked, and I think the necessary patches referenced in that document are 
already the client and server. I used spacewalks spacewalk-repo-sync command to 
sync the Ubuntu repositories. However, I did not run the script to setup 
multiarch headers that is referenced in 
https://www.redhat.com/archives/spacewalk-list/2018-September/msg00072.html. Is 
that still needed? The documentation for Ubuntu and spacewalk isn't that great, 
some is for older versions of spacewalk, so I'm piecing things together and I'm 
not sure what is still needed and what is not, of if I installed things 
correctly.

Any suggestions are appreciated.

Thanks!
Nicole




___
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] help with ubuntu16 client and spacewalk2.9 server

2019-08-27 Thread Nicole Beck 
Hi Robert,

Here are the pertinent lines for "apt-get --simulate upgrade".

root@beaker:/etc/apt/sources.list.d# apt-get --simulate upgrade  python-wadllib
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following package was automatically installed and is no longer required:
  libsigsegv2
Use 'apt autoremove' to remove it.
The following packages have been kept back:
  libdrm2 libparse-debianchangelog-perl libpython-stdlib linux-image-virtual
  lsb-release open-vm-tools python python-minimal python3 ubuntu-minimal
The following packages will be upgraded:
...
  python-wadllib python2.7 python2.7-minimal python3-apparmor python3-apport
...
Inst python-wadllib [1.3.2-3] (1.3.2-3ubuntu0.16.04.1 
Ubuntu:16.04/ubuntu16-xenial-updates [all])
...
Conf python-wadllib (1.3.2-3ubuntu0.16.04.1 
Ubuntu:16.04/ubuntu16-xenial-updates [all])


I have everything commented out of /etc/apt/sources.list so it is getting the 
packages from /etc/apt/sources.list.d/spacewalk.list.  

I'm not sure if this is helpful or not, but " apt list --upgradable|wc" is 496, 
but in spacewalk, Systems - Software - Packages - Upgrade shows 247.

Thanks!
Nicole

-Original Message-
From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Robert Paschedag
Sent: Tuesday, August 27, 2019 2:43 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] help with ubuntu16 client and spacewalk2.9 server

Can you check from the client with "apt-get", if the package "python-wadllib" 
is really an upgrade candidate?

Might be an error, that spacewalk "thinks" it is an update for the server but 
it isn't.

Robert

⁣sent from my mobile device​


 Originale Nachricht 
Von: Nicole Beck 
Gesendet: Tue Aug 27 19:13:51 GMT+02:00 2019
An: "'spacewalk-list@redhat.com'" 
Betreff: [Spacewalk-list] help with ubuntu16 client and spacewalk2.9 server

Hello,
I'm trying to get an Ubuntu 16 xenial client setup to do updates from a 
spacewalk 2.9 server installed on CentOS7.  I am able to register the client, 
install and remove, or update a single package thru the spacewalk web 
interface. But when I try to update all of the packages on (choose system - 
Software - Packages tab - Upgrade tab - choose Select All - Upgrade packages - 
confirm), then run "rhn_check -vvv" on the client, it fails with:

...
Apt-Spacewalk: Updating sources.list
D: Failed to update package['python-wadllib', '1.3.2', '3ubuntu0.16.04.1', '', 
'all-deb']
D: Sending back response(1, 'update failed', {})
D: do_call packages.checkNeedUpdate('rhnsd=1',){}
D: Called refresh_list
Updating package profile
D: rpcServer: Calling XMLRPC registration.welcome_message
D: rpcServer: Calling XMLRPC registration.update_packages
D: local action status: (0, 'package list refreshed', {})
D: rpcServer: Calling XMLRPC registration.welcome_message

I could use the web interface to update the single package that it says it is 
failing on.

I used the steps listed in 
https://www.redhat.com/archives/spacewalk-list/2019-January/msg6.html to 
get this setup. I installed the 2.8 spacewalk client referenced in the thread, 
and I signed the repos per the documentation at 
http://www.devops-blog.net/spacewalk/gpg-signing-apt-repository-in-spacewalk. I 
checked, and I think the necessary patches referenced in that document are 
already the client and server. I used spacewalks spacewalk-repo-sync command to 
sync the Ubuntu repositories. However, I did not run the script to setup 
multiarch headers that is referenced in 
https://www.redhat.com/archives/spacewalk-list/2018-September/msg00072.html. Is 
that still needed? The documentation for Ubuntu and spacewalk isn't that great, 
some is for older versions of spacewalk, so I'm piecing things together and I'm 
not sure what is still needed and what is not, of if I installed things 
correctly.

Any suggestions are appreciated.

Thanks!
Nicole




___
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] help with ubuntu16 client and spacewalk2.9 server

2019-08-27 Thread Nicole Beck 
Hello,
I'm trying to get an Ubuntu 16 xenial client setup to do updates from a 
spacewalk 2.9 server installed on CentOS7.  I am able to register the client, 
install and remove, or update a single package thru the spacewalk web 
interface. But when I try to update all of the packages on (choose system - 
Software - Packages tab - Upgrade tab - choose Select All - Upgrade packages - 
confirm), then run "rhn_check -vvv" on the client, it fails with:

...
Apt-Spacewalk: Updating sources.list
D: Failed to update package['python-wadllib', '1.3.2', '3ubuntu0.16.04.1', '', 
'all-deb']
D: Sending back response(1, 'update failed', {})
D: do_call packages.checkNeedUpdate('rhnsd=1',){}
D: Called refresh_list
Updating package profile
D: rpcServer: Calling XMLRPC registration.welcome_message
D: rpcServer: Calling XMLRPC registration.update_packages
D: local action status: (0, 'package list refreshed', {})
D: rpcServer: Calling XMLRPC registration.welcome_message

I could use the web interface to update the single package that it says it is 
failing on.

I used the steps listed in 
https://www.redhat.com/archives/spacewalk-list/2019-January/msg6.html to 
get this setup. I installed the 2.8 spacewalk client referenced in the thread, 
and I signed the repos per the documentation at 
http://www.devops-blog.net/spacewalk/gpg-signing-apt-repository-in-spacewalk. I 
checked, and I think the necessary patches referenced in that document are 
already the client and server. I used spacewalks spacewalk-repo-sync command to 
sync the Ubuntu repositories. However, I did not run the script to setup 
multiarch headers that is referenced in 
https://www.redhat.com/archives/spacewalk-list/2018-September/msg00072.html. Is 
that still needed? The documentation for Ubuntu and spacewalk isn't that great, 
some is for older versions of spacewalk, so I'm piecing things together and I'm 
not sure what is still needed and what is not, of if I installed things 
correctly.

Any suggestions are appreciated.

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

[Spacewalk-list] wrong packages in channels

2018-05-08 Thread Nicole Beck 
Hello,
When running "yum update" on my spacewalk clients I'm seeing some dependency 
failures and strange dependencies. For example, a CentOS 6 server wants to 
install a package meant for CentOS 7, or an OL7 server wants to install an OL6 
package.  When I look at the list packages in the channels in Spacewalk ( 
Channel - Manage Software channel - centos6-updates - Packages- List/remove 
packages), I see things that don't belong.  For instance, in my Centos7 
channels, I see both "Oracle Inc" as well as CentOS listed in the "Content 
Provider" column.

Another example is that my oraclelinux6-updates channel has both "Oracle Inc" 
and CentOS listed in the "Content Provider" column, as well as packages with 
".el7" in the name (these have "Oracle Inc" listed as the "Content Provider").

Has anyone seen this before, and have suggestions why this happened?

Thanks!
Nicole


Nicole Beck
Information Technology Analyst
Information Technolgy Services - Core Infrustructure Services - Unix

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

[Spacewalk-list] spacewalk 2.7 client on uln

2018-04-11 Thread Nicole Beck 
Hi,
I have a spacewalk 2.7 server running on CentOS 7, and I want to setup some 
Oracle Enterprise Linux clients. I installed the spacewalk 2.7 client software 
(from the Spacewalk project, not from Oracle) on a ULN6 and ULN7 test machine 
using the instructions at 
https://github.com/spacewalkproject/spacewalk/wiki/RegisteringClients.

On both servers, all the spacewalk packages get updated, but I get the 
following errors:
ULN 6:
rhn-plugin: ERROR: can not find ULN CA file: /usr/share/rhn/ULN-CA-CERT

ULN 7:
ERROR: can not find RHNS CA file: /usr/share/rhn/ULN-CA-CERT

Is that to be expected?  Both servers were previously registered with ULN as to 
simulate our production servers.

The documentation has the warning below about RedHat, so I'm wondering if the 
same goes for ULN. I do not want to invalidate my ULN support.
"Warning: If you are installing these packages on a Red Hat Enterprise Linux 
installation it will override some of the original base packages and you may 
well be invalidating your support agreement with Red Hat!"

I'll note that I could see the ULN clients in the Spacewalk GUI, and could 
update packages both thru the gui and with yum, so it works. But I'm wondering 
about the errors.

Thanks!
Nicole
Nicole Beck
Information Technology Analyst
Information Technolgy Services - Core Infrustructure Services - Unix

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

Re: [Spacewalk-list] spacewalk-repo-sync gives "HTTPS Error 401 - Unauthorized" for ULN repository

2018-03-28 Thread Nicole Beck 
Great! Thank you!!!

-Original Message-
From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Avi Miller
Sent: Wednesday, March 28, 2018 11:56 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] spacewalk-repo-sync gives "HTTPS Error 401 - 
Unauthorized" for ULN repository

Hey all,


> On 29 Mar 2018, at 2:14 am, Avi Miller  wrote:
> 
> I will ask the product team to push this fix upstream ASAP and I 
> apologise for any confusion my confusion caused. :)


I’ve learned that QA only passed the fix for this bug late last week so the 
upstream push will happen in the next few days. 

Thanks,
Avi

--
Oracle 
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] spacewalk-repo-sync gives "HTTPS Error 401 - Unauthorized" for ULN repository

2018-03-28 Thread Nicole Beck 
Hi Avi,
I don't see a package for spacwalk-backend-2.7.139-1.0.2 at 
http://yum.spacewalkproject.org/latest/RHEL/7/x86_64/.  It only has 
spacewalk-backend-2.7.139-1, which is what I already have installed on my 
server.  Should I be looking somewhere else?

Thanks,
Nicole

-Original Message-
From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Avi Miller
Sent: Tuesday, March 27, 2018 5:16 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] spacewalk-repo-sync gives "HTTPS Error 401 - 
Unauthorized" for ULN repository

Hi,

> On 27 Mar 2018, at 5:10 pm, Sadri, Wafa (BITBW)  
> wrote:
> 
> SW 2.7 does not support the ULN! I’ve had a support ticket with oracle 
> regarding this issue and after 3 weeks they told me that since the new 
> repo-sync is now used, ULN sync doesn’t work anymore. So if you want to use 
> ULN repos, you have to use SW 2.6 or use the public yum repos form oracle 
> instead (which is what we ended up doing).

Actually, it has been fixed in SPACEWALK-BACKEND-2.7.139-1.0.2 for Bug 
27468275. You should upgrade to get it working again.

The cause was due to upstream changing the download mechanism to improve 
performance, but it broke how we handle AuthN tokens.

Thanks,
Avi


---
Oracle 
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] spacewalk-repo-sync gives "HTTPS Error 401 - Unauthorized" for ULN repository

2018-03-27 Thread Nicole Beck 
Thank you Wafa.
I’ve changed my repo to point to 
http://yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64 instead of ULN, and it 
is syncing now.
Nicole

From: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com> On 
Behalf Of Sadri, Wafa (BITBW)
Sent: Tuesday, March 27, 2018 2:10 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] spacewalk-repo-sync gives "HTTPS Error 401 - 
Unauthorized" for ULN repository

Hi everyone,

SW 2.7 does not support the ULN! I’ve had a support ticket with oracle 
regarding this issue and after 3 weeks they told me that since the new 
repo-sync is now used, ULN sync doesn’t work anymore. So if you want to use ULN 
repos, you have to use SW 2.6 or use the public yum repos form oracle instead 
(which is what we ended up doing).

regards,
Wafa

Von: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
[mailto:spacewalk-list-boun...@redhat.com] Im Auftrag von Nicole Beck
Gesendet: Montag, 26. März 2018 21:44
An: 'spacewalk-list@redhat.com' 
<spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>>
Betreff: Re: [Spacewalk-list] spacewalk-repo-sync gives "HTTPS Error 401 - 
Unauthorized" for ULN repository

Thank you Avi.
Nicole

From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
<spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com>> 
On Behalf Of Avi Miller
Sent: Monday, March 26, 2018 3:26 PM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: Re: [Spacewalk-list] spacewalk-repo-sync gives "HTTPS Error 401 - 
Unauthorized" for ULN repository

Hi,

On 27 Mar 2018, at 5:37 am, Nicole Beck 
<nsky...@syr.edu<mailto:nsky...@syr.edu>> wrote:

I’m trying to setup channels for Oracle Linux on my Spacewalk 2.7 server 
(running  CentOS 7), but the spacewalk-repo-sync is failing with the 
“unauthorized” error below.

Hmm. That’s interesting (because the ULN connection worked sufficiently to get 
the number of packages to download. It’s just when it tries to grab the 
individual package that it breaks.

We’re still in the process of building and testing our 2.7 release, but I’ll 
check with development in case we encountered the same issue.

Thanks,
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

Re: [Spacewalk-list] Spacewalk and Oracle Linux

2018-03-26 Thread Nicole Beck 
Hi Avi,
We are still doing some R of spacewalk and my test server is CentOS. I 
thought about building on Oracle Linux if we go production with it. Doesn’t the 
Oracle build of Spacewalk require an Oracle database, vs postgres?

I really appreciate your help!
Nicole

From: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com> On 
Behalf Of Avi Miller
Sent: Monday, March 26, 2018 3:22 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk and Oracle Linux

Hi,



On 27 Mar 2018, at 12:58 am, Nicole Beck 
<nsky...@syr.edu<mailto:nsky...@syr.edu>> wrote:

Will the ULN clients that get patched with a Spacewalk instance running on 
CentOS still be eligible for Oracle support?

Yes. As long as the packages you’re installing on your Oracle Linux servers are 
signed by Oracle (i.e. are synced from yum.oracle.com<http://yum.oracle.com> or 
ULN), you will get support. However, we will not support your Spacewalk 
instance or any issues you have connecting your Oracle Linux servers to that 
instance.

Frankly, it makes way more sense to deploy the Oracle build of Spacewalk on 
Oracle Linux 7 so that you have a fully supported stack and then you can update 
your CentOS instances from that. You don’t get support for CentOS anyway, so 
there is zero loss here, but you gain support for the Spacewalk infrastructure.

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

Re: [Spacewalk-list] spacewalk-repo-sync gives "HTTPS Error 401 - Unauthorized" for ULN repository

2018-03-26 Thread Nicole Beck 
Thank you Avi.
Nicole

From: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com> On 
Behalf Of Avi Miller
Sent: Monday, March 26, 2018 3:26 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] spacewalk-repo-sync gives "HTTPS Error 401 - 
Unauthorized" for ULN repository

Hi,


On 27 Mar 2018, at 5:37 am, Nicole Beck 
<nsky...@syr.edu<mailto:nsky...@syr.edu>> wrote:

I’m trying to setup channels for Oracle Linux on my Spacewalk 2.7 server 
(running  CentOS 7), but the spacewalk-repo-sync is failing with the 
“unauthorized” error below.

Hmm. That’s interesting (because the ULN connection worked sufficiently to get 
the number of packages to download. It’s just when it tries to grab the 
individual package that it breaks.

We’re still in the process of building and testing our 2.7 release, but I’ll 
check with development in case we encountered the same issue.

Thanks,
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] spacewalk-repo-sync gives "HTTPS Error 401 - Unauthorized" for ULN repository

2018-03-26 Thread Nicole Beck 
Hi,
I'm trying to setup channels for Oracle Linux on my Spacewalk 2.7 server 
(running  CentOS 7), but the spacewalk-repo-sync is failing with the 
"unauthorized" error below.

[root@spacewalk rpm-gpg]# spacewalk-repo-sync --type uln 
--channel=ol6_x86_64_spacewalk26_client 
--url=uln:///ol6_x86_64_spacewalk26_client --verbose
14:03:49 ==
14:03:49 | Channel: ol6_x86_64_spacewalk26_client
14:03:49 ==
14:03:49 Sync of channel started.
14:03:49 Repo URL: uln:///ol6_x86_64_spacewalk26_client
The download URL is: 
https://linux-update.oracle.com/XMLRPC/GET-REQ/ol6_x86_64_spacewalk26_client
14:03:52 Packages in repo:56
14:03:52 Packages already synced:  0
14:03:52 Packages to sync:40
14:03:52 New packages to download:40
14:03:52 Downloading total 40 files from 1 queues.
14:03:52 ERROR: Download failed: 
https://linux-update.oracle.com/XMLRPC/GET-REQ/ol6_x86_64_spacewalk26_client/getPackage/jabberpy-0.5-0.21.el6.noarch.rpm
 - [Errno 14] HTTPS Error 401 - Unauthorized.


I put my ULN username and password in /etc/rhn/spacewalk-repo-sync/uln.conf, 
and the permissions are 0400. I verified that the username and password are 
correct by copying and pasting from this file into the login for 
https://uln.oracle.com.  If I put the wrong password in uln.conf, I get the 
"Fault 60: Invalid username or password" error when running 
spacewalk-repo-sync, so I'm assuming the file is correct.

I tried stopping Spacewalk, removing the appropriate subdirectories in 
/var/cache/rhn/reposync/1/ and restarting Spacewalk, but this did not help.  
Does anyone have suggestions? The directions at 
https://github.com/spacewalkproject/spacewalk/blob/master/backend/README.ULN 
are pretty straightforward, but I'm obviously missing something.
Thanks.
Nicole
Nicole Beck
Information Technology Analyst
Information Technolgy Services - Core Infrustructure Services - Unix

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

Re: [Spacewalk-list] Spacewalk and Oracle Linux

2018-03-26 Thread Nicole Beck 
Hi Avi,
Will the ULN clients that get patched with a Spacewalk instance running on 
CentOS still be eligible for Oracle support?   
Thanks!
Nicole

-Original Message-
From: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com> On 
Behalf Of Avi Miller
Sent: Friday, March 23, 2018 4:56 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk and Oracle Linux

Hi,


> On 24 Mar 2018, at 7:47 am, Nicole Beck <nsky...@syr.edu> wrote:
> 
> I want to use spacewalk to manage patches for both CentOS and Oracle Linux.  
> Is it possible to do this with my Spacewalk server that is running CentOS? Or 
> does the Spacewalk server have to be running Oracle Linux?

You can use the Spacewalk instance running on CentOS, but it would not be 
eligible for support from Oracle. 

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

[Spacewalk-list] Spacewalk and Oracle Linux

2018-03-23 Thread Nicole Beck 
Hello,
I want to use spacewalk to manage patches for both CentOS and Oracle Linux.  Is 
it possible to do this with my Spacewalk server that is running CentOS? Or does 
the Spacewalk server have to be running Oracle Linux?

Thanks!
Nicole

Nicole Beck
Information Technology Analyst
Information Technolgy Services - Core Infrustructure Services - Unix

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

Re: [Spacewalk-list] activation keys

2018-03-22 Thread Nicole Beck 
Thank you for the reply David.  
We are not using Spacewalk to kickstart servers, as we have another server for 
that. For now, we just want to use it for patching management.  I'm just 
learning to use Spacewalk and we have a pretty simple channel setup.

Centos6 (base)
  |_ centos6-updates
  |_ spacewalk27
  |_ epel
Centos7
  |_ centos7-base
  |_ centos7-updates
  |_ spacewalk27
  |_ epel

I plan to add ULN channels as well.  It sounds like doing what you suggested 
and having an activation key for each OS and register with the appropriate key 
is probably the easiest.

Thanks again.
Nicole

-Original Message-
From: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com> On 
Behalf Of David Rock
Sent: Wednesday, March 21, 2018 4:04 PM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] activation keys


> On Mar 21, 2018, at 14:02, Nicole Beck <nsky...@syr.edu> wrote:
> 
> Hello,
> I’m looking for recommendations for setting up activation keys. Do you 
> normally have an activation key set for each OS version(centos6, centos7) , 
> and specify the appropriate base and child channels in each? I tested this, 
> and registering the client with “rhnreg_ks” and the appropriate key, and I my 
> client is subscribed to the expected channels. 
>  
> I’m also testing the “Spacewalk Default” base channel and the “Universal 
> Default” key, and it’s not working as I expect it to.  Is there a way to 
> setup a “generic” spacewalk activation key so that client registering with it 
> is subscribed to the channels for the correct OS version?  I’m thinking of 
> something analogous to using “rhn_register” to register a RH server with the 
> old RHN, or an Oracle Enterprise Server with ULN, you type in your username 
> and password, and something behind the scenes figures out what OS version is 
> installed and subscribes you to the correct channels.  Is that what 
> “Spacewalk Default” and “Universal Default” do, or am I misunderstanding it.  
> I’ve created base and child channels for centos-6 and centos-7, but I don’t 
> have a channel named “Spacewalk Default”.
> 

The main thing you have to be careful of is if you have config channel 
priorities in multiple keys.  The system has no logic to determine relative 
priority, so last key in wins, but the order they get applied is undetermined.

If you aren’t trying to manage complicated config channels, making one for the 
base OS, and one for “other stuff” will work ok.

We created a single key that has everything for each type to avoid any 
confusion (we were originally getting oracle-specific configs overwritten by 
the more generic configs, which caused issues when we tried to get too fancy 
with the keys).

The Spacewalk Default and Universal Defaults are not what you want.  The best 
way to get what you expect to get is create a key for each OS that contains the 
parent/child channels you want to apply and use that in the KS profile.  The 
basic workflow at build time is:

1. use the GA release from the kickstart tree in the KS profile to install the 
base os 2. apply the activation key with the related clone channels, etc 3. yum 
update to bring everything up to current that’s in your clone channel


—
David Rock
da...@graniteweb.com





___
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] activation keys

2018-03-21 Thread Nicole Beck 
Hello,
I'm looking for recommendations for setting up activation keys. Do you normally 
have an activation key set for each OS version(centos6, centos7) , and specify 
the appropriate base and child channels in each? I tested this, and registering 
the client with "rhnreg_ks" and the appropriate key, and I my client is 
subscribed to the expected channels.

I'm also testing the "Spacewalk Default" base channel and the "Universal 
Default" key, and it's not working as I expect it to.  Is there a way to setup 
a "generic" spacewalk activation key so that client registering with it is 
subscribed to the channels for the correct OS version?  I'm thinking of 
something analogous to using "rhn_register" to register a RH server with the 
old RHN, or an Oracle Enterprise Server with ULN, you type in your username and 
password, and something behind the scenes figures out what OS version is 
installed and subscribes you to the correct channels.  Is that what "Spacewalk 
Default" and "Universal Default" do, or am I misunderstanding it.  I've created 
base and child channels for centos-6 and centos-7, but I don't have a channel 
named "Spacewalk Default".

Any tips would be helpful.
Thanks!
Nicole

Nicole Beck
Information Technology Analyst
Information Technolgy Services - Core Infrustructure Services - Unix
315.506.9744
nsky...@syr.edu<mailto:nsky...@syr.edu>
215 Machinery Hall, Syracuse, NY 13244
syracuse.edu
Syracuse University


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

Re: [Spacewalk-list] postgres DB backup question

2018-02-28 Thread Nicole Beck 
Thanks everyone. There are a lot of different ways to do it!

The man page for pg_dumpall says "pg_dumpall also dumps global objects that are 
common to all databases. (pg_dump does not save these objects.) This currently 
includes information about database users and groups, tablespaces, and 
properties such as access permissions that apply to databases as a whole."  Is 
that something we have to worry about if we just use the "pg_dump rhnschema" 
method to backup? Spacewalk is the only database I have.


Nicole


From: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com> on 
behalf of Brian Long <briandl...@gmail.com>
Sent: Tuesday, February 27, 2018 10:49 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] postgres DB backup question

I use the "db-control" program to handle an online (DB running) backup.
db-control online-backup /local/backups/satellite-pgsql.$DATE 1>/dev/null

/Brian/

On Mon, Feb 26, 2018 at 1:23 PM, Nicole Beck 
<nsky...@syr.edu<mailto:nsky...@syr.edu>> wrote:
Hello!
I’m trying to backup my postgress DB using the Spacewalk install documentation 
at https://github.com/spacewalkproject/spacewalk/wiki/SpacewalkBackup, and it 
fails with the errors below. If I try it without spacewalk running,  it gives 
an error and creates an empty backup file. If I try it with spacewalk running, 
it creates a 3.9 GB backup file, but I can’t restore it. Spacewalk is the only 
thing using this database. How do you all do your database backups?

Errors when spacewalk not running(creates empty backup file):

[root@spacewalk ~]# spacewalk-service stop
Shutting down spacewalk services...
Redirecting to /bin/systemctl stop taskomatic.service
Stopping cobblerd (via systemctl): [  OK  ]
Redirecting to /bin/systemctl stop rhn-search.service
Redirecting to /bin/systemctl stop osa-dispatcher.service
Redirecting to /bin/systemctl stop httpd.service
Redirecting to /bin/systemctl stop tomcat.service
Redirecting to /bin/systemctl stop jabberd.service
Redirecting to /bin/systemctl stop postgresql.service
Done.
[root@spacewalk ~]# su - postgres -c  'pg_dumpall > 
/var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'
pg_dumpall: could not connect to database "template1": could not connect to 
server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
[root@spacewalk ~]# ls -al /var/lib/pgsql/backups
total 0
drwx-- 2 postgres postgres  47 Feb 26 12:32 .
drwx-- 6 postgres postgres 122 Nov  1 14:55 ..
-rw-r--r-- 1 postgres postgres   0 Feb 26 12:32 
full_postgres_backup-20180226.sql


Errors when spacewalk running

[root@spacewalk ~]# spacewalk-service start
Starting spacewalk services...
Redirecting to /bin/systemctl start
Redirecting to /bin/systemctl start postgresql.service
Redirecting to /bin/systemctl start jabberd.service
Redirecting to /bin/systemctl start tomcat.service
Waiting for tomcat to be ready ...
Redirecting to /bin/systemctl start httpd.service
Redirecting to /bin/systemctl start osa-dispatcher.service
Redirecting to /bin/systemctl start rhn-search.service
Starting cobblerd (via systemctl): [  OK  ]
Redirecting to /bin/systemctl start taskomatic.service
Done.
[root@spacewalk ~]# su - postgres -c  'pg_dumpall > 
/var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'
pg_dump: [archiver (db)] connection to database "template1" failed: FATAL:  no 
pg_hba.conf entry for host "[local]", user "postgres", database "template1", 
SSL off
pg_dumpall: pg_dump failed on database "template1", exiting
[root@spacewalk backups]# ls -al
total 3910032
drwx-- 2 postgres postgres 47 Feb 26 12:32 .
drwx-- 6 postgres postgres122 Nov  1 14:55 ..
-rw-r--r-- 1 postgres postgres 4003869597 Feb 26 12:40 
full_postgres_backup-20180226.sql

But you can’t restore per the github.com<http://github.com> directions:

[root@spacewalk backups]# su - postgres
Last login: Mon Feb 26 12:38:18 EST 2018 on pts/0
-bash-4.2$ SPACEWALK_DB_NAME=spacewalkdb
-bash-4.2$ ls /var/lib/pgsql/backups
full_postgres_backup-20180226.sql
-bash-4.2$ 
SPACEWALK_DB_BACKUPFILE=/var/lib/pgsql/backups/full_postgres_backup-20180226.sql
-bash-4.2$ full_postgres_backup-20180226.sql^C
-bash-4.2$ id
uid=26(postgres) gid=26(postgres) groups=26(postgres)
-bash-4.2$ dropdb $SPACEWALK_DB_NAME
dropdb: could not connect to database template1: could not connect to server: 
No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Thanks!
Nicole


Nicole Beck
Information Technology Analyst
Information Technolgy Services – Core Infrustructure Services - Unix
315.506

[Spacewalk-list] postgres DB backup question

2018-02-26 Thread Nicole Beck 
Hello!
I'm trying to backup my postgress DB using the Spacewalk install documentation 
at https://github.com/spacewalkproject/spacewalk/wiki/SpacewalkBackup, and it 
fails with the errors below. If I try it without spacewalk running,  it gives 
an error and creates an empty backup file. If I try it with spacewalk running, 
it creates a 3.9 GB backup file, but I can't restore it. Spacewalk is the only 
thing using this database. How do you all do your database backups?

Errors when spacewalk not running(creates empty backup file):

[root@spacewalk ~]# spacewalk-service stop
Shutting down spacewalk services...
Redirecting to /bin/systemctl stop taskomatic.service
Stopping cobblerd (via systemctl): [  OK  ]
Redirecting to /bin/systemctl stop rhn-search.service
Redirecting to /bin/systemctl stop osa-dispatcher.service
Redirecting to /bin/systemctl stop httpd.service
Redirecting to /bin/systemctl stop tomcat.service
Redirecting to /bin/systemctl stop jabberd.service
Redirecting to /bin/systemctl stop postgresql.service
Done.
[root@spacewalk ~]# su - postgres -c  'pg_dumpall > 
/var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'
pg_dumpall: could not connect to database "template1": could not connect to 
server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
[root@spacewalk ~]# ls -al /var/lib/pgsql/backups
total 0
drwx-- 2 postgres postgres  47 Feb 26 12:32 .
drwx-- 6 postgres postgres 122 Nov  1 14:55 ..
-rw-r--r-- 1 postgres postgres   0 Feb 26 12:32 
full_postgres_backup-20180226.sql


Errors when spacewalk running

[root@spacewalk ~]# spacewalk-service start
Starting spacewalk services...
Redirecting to /bin/systemctl start
Redirecting to /bin/systemctl start postgresql.service
Redirecting to /bin/systemctl start jabberd.service
Redirecting to /bin/systemctl start tomcat.service
Waiting for tomcat to be ready ...
Redirecting to /bin/systemctl start httpd.service
Redirecting to /bin/systemctl start osa-dispatcher.service
Redirecting to /bin/systemctl start rhn-search.service
Starting cobblerd (via systemctl): [  OK  ]
Redirecting to /bin/systemctl start taskomatic.service
Done.
[root@spacewalk ~]# su - postgres -c  'pg_dumpall > 
/var/lib/pgsql/backups/full_postgres_backup-`date +%Y%m%d`.sql'
pg_dump: [archiver (db)] connection to database "template1" failed: FATAL:  no 
pg_hba.conf entry for host "[local]", user "postgres", database "template1", 
SSL off
pg_dumpall: pg_dump failed on database "template1", exiting
[root@spacewalk backups]# ls -al
total 3910032
drwx-- 2 postgres postgres 47 Feb 26 12:32 .
drwx-- 6 postgres postgres122 Nov  1 14:55 ..
-rw-r--r-- 1 postgres postgres 4003869597 Feb 26 12:40 
full_postgres_backup-20180226.sql

But you can't restore per the github.com directions:

[root@spacewalk backups]# su - postgres
Last login: Mon Feb 26 12:38:18 EST 2018 on pts/0
-bash-4.2$ SPACEWALK_DB_NAME=spacewalkdb
-bash-4.2$ ls /var/lib/pgsql/backups
full_postgres_backup-20180226.sql
-bash-4.2$ 
SPACEWALK_DB_BACKUPFILE=/var/lib/pgsql/backups/full_postgres_backup-20180226.sql
-bash-4.2$ full_postgres_backup-20180226.sql^C
-bash-4.2$ id
uid=26(postgres) gid=26(postgres) groups=26(postgres)
-bash-4.2$ dropdb $SPACEWALK_DB_NAME
dropdb: could not connect to database template1: could not connect to server: 
No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Thanks!
Nicole


Nicole Beck
Information Technology Analyst
Information Technolgy Services - Core Infrustructure Services - Unix
315.506.9744
nsky...@syr.edu<mailto:nsky...@syr.edu>
215 Machinery Hall, Syracuse, NY 13244
syracuse.edu
Syracuse University


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

[Spacewalk-list] advice about organizing channels and repositories

2017-12-01 Thread Nicole Beck 
Hi,
I'm new to spacewalk, and I'm not sure how to organize the channels.  If, for 
example, you are running CentOS 6.7 without spacewalk, and you run "yum 
update", you will end up at CentOS 6.9.  If I add spacewalk, what is the best 
way to do that?  Do I make a centos67-base with a centos67-updates child, then 
a centos69-base with a centos69-update child, using the respective repositories 
(which I think are a vault.centos.org and 
http://mirror.centos.org/centos-6/6.9/os/x86_64/)? But then do I have to change 
which channel my server is subscribed to from the centos67 to centos69? Or 
should I make a centos6 channel with the child centos6-updates channel using 
the repositories for latest minor version 
(http://mirror.centos.org/centos-6/6/os/x86_64/ )? Is this advisable?

Is there documentation for best practices for setting up/organizing channels?

Thanks for your advice!
Nicole

Nicole Beck
Information Technology Analyst
Information Technolgy Services - Core Infrustructure Services - Unix
315.506.9744
nsky...@syr.edu<mailto:nsky...@syr.edu>
215 Machinery Hall, Syracuse, NY 13244
syracuse.edu
Syracuse University



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