Re: [Spacewalk-list] Switching the jabberd database to sqlite/pgsql

2017-03-03 Thread Konstantin Raskoshnyi
In tutorial you shared there's no one main point - you have to reinstall
either reinstall osad on all machines or remove osad-auth.conf and restart
osad.

On Fri, Mar 3, 2017 at 8:54 PM, Robert Paschedag 
wrote:

> Am 3. März 2017 22:11:27 MEZ schrieb Avi Miller :
> >Hi everyone,
> >
> >I was searching for a simple tutorial on how to switch the jabberd
> >database away from the Spacewalk default of BerkeleyDB to something
> >more robust. While I did find some scattered documentation, there was
> >nothing specific for Spacewalk, so I wrote up two:
> >
> >Switching to SQLite:
> >
> >https://omg.dje.li/2017/02/configuring-spacewalks-
> jabberd-to-use-an-sqlite-backend/
> >
> >Switching to PostgreSQL:
> >
> >https://omg.dje.li/2017/03/configuring-spacewalks-
> jabberd-to-use-a-postgresql-backend/
> >
> >Hopefully someone finds this useful. If anything is unclear or if you
> >have any comments/improvements/corrections, please let me know!
> >
> >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
>
> Hi Avi,
>
> Thank you for sharing this information. Although I did not yet had many
> problems with the jabber db, I heard it should be far better with SQLite.
>
> Regards
> Robert
>
> ___
> 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] Switching the jabberd database to sqlite/pgsql

2017-03-03 Thread Robert Paschedag
Am 3. März 2017 22:11:27 MEZ schrieb Avi Miller :
>Hi everyone,
>
>I was searching for a simple tutorial on how to switch the jabberd
>database away from the Spacewalk default of BerkeleyDB to something
>more robust. While I did find some scattered documentation, there was
>nothing specific for Spacewalk, so I wrote up two:
>
>Switching to SQLite: 
>
>https://omg.dje.li/2017/02/configuring-spacewalks-jabberd-to-use-an-sqlite-backend/
>
>Switching to PostgreSQL: 
>
>https://omg.dje.li/2017/03/configuring-spacewalks-jabberd-to-use-a-postgresql-backend/
>
>Hopefully someone finds this useful. If anything is unclear or if you
>have any comments/improvements/corrections, please let me know!
>
>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

Hi Avi,

Thank you for sharing this information. Although I did not yet had many 
problems with the jabber db, I heard it should be far better with SQLite.

Regards
Robert

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

[Spacewalk-list] Switching the jabberd database to sqlite/pgsql

2017-03-03 Thread Avi Miller
Hi everyone,

I was searching for a simple tutorial on how to switch the jabberd database 
away from the Spacewalk default of BerkeleyDB to something more robust. While I 
did find some scattered documentation, there was nothing specific for 
Spacewalk, so I wrote up two:

Switching to SQLite: 

https://omg.dje.li/2017/02/configuring-spacewalks-jabberd-to-use-an-sqlite-backend/

Switching to PostgreSQL: 

https://omg.dje.li/2017/03/configuring-spacewalks-jabberd-to-use-a-postgresql-backend/

Hopefully someone finds this useful. If anything is unclear or if you have any 
comments/improvements/corrections, please let me know!

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


Re: [Spacewalk-list] Channel/repository deleted but packages remain.

2017-03-03 Thread Soham Chakraborty
Not to nitpick did you run with --remove? In my case having --remove
worked. Probably stupid suggestion but...

On 3 Mar 2017 19:51, "Dimitri Yioulos"  wrote:

Michael,

Thanks for the response.

I did run spacewalk-data-fsck.  The channels were for rpmforge which, as we
know, has ridden off into the sunset.  Perhaps I didn't remove the
channels/repositories/packages in proper order?  What I ended up doing is
deleting the packages manually e.g. " find . -type f -name '*rf.noarch.rpm'
-exec rm {} +".  After I did that, I ran spacewalk-data-fsck, but got no
output.  I know I should rtfm, but I'll ask anyway - what's the proper way
to remove a channel and its associated packages?

Thanks again.

Dimitri

editorial:  Rpmforge, originally created in 2002 by Dag Wieers, and known
as the Dag RPM Repository for a long time, was the first non-Redhat
repository.  I used it from its inception, and it saved my bacon lots of
times.  Thanks, Dag!


-Original Message-
From: spacewalk-list-boun...@redhat.com [mailto:spacewalk-list-
boun...@redhat.com] On Behalf Of Michael Mraka
Sent: Friday, March 03, 2017 4:30 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Channel/repository deleted but packages
remain.

> Hello, all.
>
> I recently did some maintenance to our Spacewalk 2.6 server, which
included removing some no longer needed channels, and their associated
repositories.  I thought this would also remove the packages associated
with the channels.  Wrong.  The packages are still on the server, and
running my standard clean-up tools (swalk-clean-old-packages.py and
spacewalk-data-fsck) aren't removing them.  I'd like to remove these
packages and reclaim disk space.  How can I accomplish this?
>
> With thanks.

spacewalk-data-fsck --remove should do it. If not then packages are still
referenced from the database. Maybe they were linked to more channels and
one of them is still alive?

Regards,

--
Michael Mráka
System Management 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] Channel/repository deleted but packages remain.

2017-03-03 Thread Dimitri Yioulos
Michael,

Thanks for the response.

I did run spacewalk-data-fsck.  The channels were for rpmforge which, as we 
know, has ridden off into the sunset.  Perhaps I didn't remove the 
channels/repositories/packages in proper order?  What I ended up doing is 
deleting the packages manually e.g. " find . -type f -name '*rf.noarch.rpm' 
-exec rm {} +".  After I did that, I ran spacewalk-data-fsck, but got no 
output.  I know I should rtfm, but I'll ask anyway - what's the proper way to 
remove a channel and its associated packages?

Thanks again.

Dimitri

editorial:  Rpmforge, originally created in 2002 by Dag Wieers, and known as 
the Dag RPM Repository for a long time, was the first non-Redhat repository.  I 
used it from its inception, and it saved my bacon lots of times.  Thanks, Dag!


-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Michael Mraka
Sent: Friday, March 03, 2017 4:30 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Channel/repository deleted but packages remain.

> Hello, all.
> 
> I recently did some maintenance to our Spacewalk 2.6 server, which included 
> removing some no longer needed channels, and their associated repositories.  
> I thought this would also remove the packages associated with the channels.  
> Wrong.  The packages are still on the server, and running my standard 
> clean-up tools (swalk-clean-old-packages.py and spacewalk-data-fsck) aren't 
> removing them.  I'd like to remove these packages and reclaim disk space.  
> How can I accomplish this?
> 
> With thanks.

spacewalk-data-fsck --remove should do it. If not then packages are still 
referenced from the database. Maybe they were linked to more channels and one 
of them is still alive?

Regards,

--
Michael Mráka
System Management 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] jpackage.org?

2017-03-03 Thread Kalchik, Jeffery
And this appears to be the solution.

Thanks to all who replied.

Jeff Kalchik
Systems Engineering
Land O'Lakes
651-375-2421

-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Michael Mraka
Sent: Friday, March 3, 2017 2:25 AM
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] jpackage.org?

Kalchik, Jeffery:
> I'm finally getting around to running the 2.5->2.6 upgrade here this 
> afternoon and discovering that the JPackage repo 
> (https://na01.safelinks.protection.outlook.com/?url=www.jpackage.org&data=01%7C01%7Cjdkalchik%40landolakes.com%7C56e18c3617d14688155708d4620fc4e7%7C21ab97d78e754056826b9d8ec665c5a3%7C1&sdata=VhSurKA%2BRm8KTTO8CoWUuYaZ8DSqGmZ%2BfVJ28Gsiucg%3D&reserved=0)
>  is apparently unavailable.  Not only that, but so are the 3 name servers the 
> whois registration points to (ns[012].zarb.org.) I'm also not sure if 
> https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.zarb.org&data=01%7C01%7Cjdkalchik%40landolakes.com%7C56e18c3617d14688155708d4620fc4e7%7C21ab97d78e754056826b9d8ec665c5a3%7C1&sdata=BmQiPS9lMpP4ZwU1BGwwSf0NHnkNgDqERy3A4jlwhcA%3D&reserved=0
>  looks much like I'd expect.
>
> Or am I wildly hallucinating?

Hi Jeffery,

Yep, jpackage.org is completely down including dns.
There are basically 2 solutions/workarounds:
a) edit your jpackage-generic.repo file and comment out mirrorlist and 
uncomment baseurl (see updated instructions on 
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fspacewalkproject%2Fspacewalk%2Fwiki%2FHowToInstall%23additional-repos--packages&data=01%7C01%7Cjdkalchik%40landolakes.com%7C56e18c3617d14688155708d4620fc4e7%7C21ab97d78e754056826b9d8ec665c5a3%7C1&sdata=JLxzxh1WLbRP%2BAESxUfHrCw8Tr5JXE%2BiMLEgk2Yyd18%3D&reserved=0),
b) we've also created last resort backup on 
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fyum.spacewalkproject.org%2Fjpackage%2F&data=01%7C01%7Cjdkalchik%40landolakes.com%7C56e18c3617d14688155708d4620fc4e7%7C21ab97d78e754056826b9d8ec665c5a3%7C1&sdata=VW4BheMS4f%2BOkF13byXhXn5jAke9WixItx%2BoRpcQ27c%3D&reserved=0
(use it as basurl in your jpackage-generic.repo file).

> Jeff Kalchik
> Systems Engineering
> Land O'Lakes

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.redhat.com%2Fmailman%2Flistinfo%2Fspacewalk-list&data=01%7C01%7Cjdkalchik%40landolakes.com%7C56e18c3617d14688155708d4620fc4e7%7C21ab97d78e754056826b9d8ec665c5a3%7C1&sdata=j3TOElRlGv6FcJJlcp%2BHDc%2FqnZO%2FKKssr20b7PfpLdc%3D&reserved=0
This message may contain confidential material from Land O'Lakes, Inc. (or its 
subsidiary) for the sole use of the intended recipient(s) and may not be 
reviewed, disclosed, copied, distributed or used by anyone other than the 
intended recipient(s). If you are not the intended recipient, please contact 
the sender by reply email and delete all copies of this message.

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

Re: [Spacewalk-list] jpackage.org?

2017-03-03 Thread Soham Chakraborty
This URL was floating in IRC yesterday:
https://github.com/Pajinek/docker-spacewalk/commit/be8e764892dfe6013af3254d53f1b57a5bd9cb34

This has alternate baseurl.

Thanks,

On Fri, Mar 3, 2017 at 2:18 PM, Rob Sterenborg 
wrote:

> Hi,
>
> I’ve used this repo file to install jpackage:
>
> ==
> [jpackage-generic]
> name=JPackage generic
> #baseurl=http://mirrors.dotsrc.org/pub/jpackage/5.0/generic/free/
> mirrorlist=http://www.jpackage.org/mirrorlist.php?dist=generic&type=free&;
> release=5.0
> enabled=1
> gpgcheck=1
> gpgkey=http://www.jpackage.org/jpackage.asc
> ==
>
>
> My DNS shows this:
>
> # dig +short jpackage.org ns
> ns3.zarb.org.
> # dig +short www.jpackage.org @ns3.zarb.org
> jpackage.org.
> 51.15.1.41
>
> The mirrorlist currently shows this:
>
> # No local mirror detected - defaulting to adding them all
> ftp://jpackage.hmdc.harvard.edu/JPackage/5.0/generic/free
> http://sunsite.informatik.rwth-aachen.de/ftp/pub/Linux/
> jpackage/5.0/generic/free
> http://ftp.heanet.ie/pub/jpackage/5.0/generic/free
> ftp://ftp.pbone.net/pub/jpackage/5.0/generic/free
> http://mirror.ibcp.fr/pub/jpackage/5.0/generic/free
> http://sunsite.rediris.es/mirror/jpackage/5.0/generic/free
> ftp://gsa10.eps.cdf.udc.es/jpackage/5.0/generic/free
> http://mirrors.dotsrc.org/jpackage/5.0/generic/free
>
> Hope this helps.
>
>
> --
> Rob
>
>
>
> -Original Message-
> From: spacewalk-list-boun...@redhat.com [mailto:spacewalk-list-
> boun...@redhat.com] On Behalf Of Michael Mraka
> Sent: vrijdag 3 maart 2017 09:25
> To: spacewalk-list@redhat.com
> Subject: Re: [Spacewalk-list] jpackage.org?
>
> Kalchik, Jeffery:
> > I'm finally getting around to running the 2.5->2.6 upgrade here this
> afternoon and discovering that the JPackage repo (www.jpackage.org<
> http://www.jpackage.org>) is apparently unavailable.  Not only that, but
> so are the 3 name servers the whois registration points to (ns[012].
> zarb.org.) I'm also not sure if http://www.zarb.org looks much like I'd
> expect.
> >
> > Or am I wildly hallucinating?
>
> Hi Jeffery,
>
> Yep, jpackage.org is completely down including dns.
> There are basically 2 solutions/workarounds:
> a) edit your jpackage-generic.repo file and comment out mirrorlist and
> uncomment baseurl (see updated instructions on
> https://github.com/spacewalkproject/spacewalk/
> wiki/HowToInstall#additional-repos--packages),
> b) we've also created last resort backup on http://yum.spacewalkproject.
> org/jpackage/
> (use it as basurl in your jpackage-generic.repo file).
>
> > Jeff Kalchik
> > Systems Engineering
> > Land O'Lakes
>
> Regards,
>
> --
> Michael Mráka
> System Management 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] Channel/repository deleted but packages remain.

2017-03-03 Thread Michael Mraka
> Hello, all.
> 
> I recently did some maintenance to our Spacewalk 2.6 server, which included 
> removing some no longer needed channels, and their associated repositories.  
> I thought this would also remove the packages associated with the channels.  
> Wrong.  The packages are still on the server, and running my standard 
> clean-up tools (swalk-clean-old-packages.py and spacewalk-data-fsck) aren't 
> removing them.  I'd like to remove these packages and reclaim disk space.  
> How can I accomplish this?
> 
> With thanks.

spacewalk-data-fsck --remove should do it. If not then packages are
still referenced from the database. Maybe they were linked to more
channels and one of them is still alive?

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

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

Re: [Spacewalk-list] Pulling working configs

2017-03-03 Thread Michael Mraka
InvalidPath:
> >> >> So, silly question.. my boss asked me today, "Can Spacewalk pull the
> >> >> current routing tables from the servers registered to it?"
> >> >
> >> > Yes, it can, if you have remote configuration enabled: 
> >> > http://docs.oracle.com/cd/E52668_01/E71078/html/swk24-manageclisys.html
> >> >
> >> > You could then run a remote command, e.g. “ip route show” across 
> >> > multiple client machines: 
> >> > http://docs.oracle.com/cd/E52668_01/E71078/html/swk24-lbw_npz_js.html
> >> >
> >> > Getting the results is slightly tedious though. :) You’ll see the result 
> >> > as the output from each remote command.
> >> >
> >> > Cheers,
> >> > Avi
> >>
> >> Thanks Avi.. So you can't like, pull then generate conf files on a per
> >> system basis then?  Configuration management, to me, should include
> >> the mundane things like this.
> >
> > If you want to see client's configuration in server interface you can
> > run remote command and then inspect the result.
> >
> > If you want to configure client (a.k.a. push config file from server to 
> > client)
> > then there are Configuration Channels / Files for it. You can use
> > different macros to have a single config file expanded properly on more
> > clients.
> 
> 
> Thanks Michael.. So once more just so I understand.  You cannot pull,
> in bulk, config files (or generate config files) from registered
> systems?

Correct. There's no easy way to do it.
A complicated way to achieve it would comprise of getting file content
with remote command and comparing it via a custom (spacewalk-)report or so.

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

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

Re: [Spacewalk-list] jpackage.org?

2017-03-03 Thread Rob Sterenborg
Hi,

I’ve used this repo file to install jpackage:

==
[jpackage-generic]
name=JPackage generic
#baseurl=http://mirrors.dotsrc.org/pub/jpackage/5.0/generic/free/
mirrorlist=http://www.jpackage.org/mirrorlist.php?dist=generic&type=free&release=5.0
enabled=1
gpgcheck=1
gpgkey=http://www.jpackage.org/jpackage.asc
==


My DNS shows this:

# dig +short jpackage.org ns
ns3.zarb.org.
# dig +short www.jpackage.org @ns3.zarb.org
jpackage.org.
51.15.1.41

The mirrorlist currently shows this:

# No local mirror detected - defaulting to adding them all
ftp://jpackage.hmdc.harvard.edu/JPackage/5.0/generic/free
http://sunsite.informatik.rwth-aachen.de/ftp/pub/Linux/jpackage/5.0/generic/free
http://ftp.heanet.ie/pub/jpackage/5.0/generic/free
ftp://ftp.pbone.net/pub/jpackage/5.0/generic/free
http://mirror.ibcp.fr/pub/jpackage/5.0/generic/free
http://sunsite.rediris.es/mirror/jpackage/5.0/generic/free
ftp://gsa10.eps.cdf.udc.es/jpackage/5.0/generic/free
http://mirrors.dotsrc.org/jpackage/5.0/generic/free

Hope this helps.


--
Rob



-Original Message-
From: spacewalk-list-boun...@redhat.com 
[mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Michael Mraka
Sent: vrijdag 3 maart 2017 09:25
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] jpackage.org?

Kalchik, Jeffery:
> I'm finally getting around to running the 2.5->2.6 upgrade here this 
> afternoon and discovering that the JPackage repo 
> (www.jpackage.org) is apparently unavailable.  Not 
> only that, but so are the 3 name servers the whois registration points to 
> (ns[012].zarb.org.) I'm also not sure if http://www.zarb.org looks much like 
> I'd expect.
> 
> Or am I wildly hallucinating?

Hi Jeffery,

Yep, jpackage.org is completely down including dns.
There are basically 2 solutions/workarounds:
a) edit your jpackage-generic.repo file and comment out mirrorlist and
uncomment baseurl (see updated instructions on
https://github.com/spacewalkproject/spacewalk/wiki/HowToInstall#additional-repos--packages),
b) we've also created last resort backup on 
http://yum.spacewalkproject.org/jpackage/
(use it as basurl in your jpackage-generic.repo file).
 
> Jeff Kalchik
> Systems Engineering
> Land O'Lakes

Regards,

--
Michael Mráka
System Management 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] jpackage.org?

2017-03-03 Thread Michael Mraka
Kalchik, Jeffery:
> I'm finally getting around to running the 2.5->2.6 upgrade here this 
> afternoon and discovering that the JPackage repo 
> (www.jpackage.org) is apparently unavailable.  Not 
> only that, but so are the 3 name servers the whois registration points to 
> (ns[012].zarb.org.) I'm also not sure if http://www.zarb.org looks much like 
> I'd expect.
> 
> Or am I wildly hallucinating?

Hi Jeffery,

Yep, jpackage.org is completely down including dns.
There are basically 2 solutions/workarounds:
a) edit your jpackage-generic.repo file and comment out mirrorlist and
uncomment baseurl (see updated instructions on
https://github.com/spacewalkproject/spacewalk/wiki/HowToInstall#additional-repos--packages),
b) we've also created last resort backup on 
http://yum.spacewalkproject.org/jpackage/
(use it as basurl in your jpackage-generic.repo file).
 
> Jeff Kalchik
> Systems Engineering
> Land O'Lakes

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

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