Any tool available to check
On Mon, 18 Feb 2019 18:17:45, Thomas Schweikle
<tschwei...@gmail.com> wrote:
>Hi!
>Is there any tool available to check spacewalk database for consistency
and for being complete (all >tables having all columns spacewalk awaits)?
>--
>Thomas
Well, if you're wondering about schema completeness, as long as you're
using Postgres, there's a number of free DB design tools that do round
trip engineering that you could try.
https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
Just build and initialize a fresh database for your version, then reverse
engineer it into a model, and compare that with your existing database.
------------------------------
Message: 2
Date: Tue, 19 Feb 2019 08:31:46 +0000
From: Wachauer Harald <harald.wacha...@akm.at>
To: "spacewalk-list@redhat.com" <spacewalk-list@redhat.com>
Subject: Re: [Spacewalk-list] Spacewalk 2.8 | Offline Clients
Message-ID: <81cf184257e34220860596b44ad4f...@akm.at>
Content-Type: text/plain; charset="iso-2022-jp"
Phil,
Still a problem with the offline clients.
It looks like that the rhn daemon stops working after some time.
Redirecting to /bin/systemctl status rhnsd.service
? rhnsd.service - Spacewalk Server daemon
Loaded: loaded (/usr/lib/systemd/system/rhnsd.service; static; vendor
preset: disabled)
Active: inactive (dead)
And some more:
I have no /etc/sysconfig/rhn/rhnsd
[root@vie-srv-XXX log]# cd /etc/sysconfig/rhn/
[root@vie-srv-XXX rhn]# ls -la
total 24
drwxr-xr-x. 4 root root 4096 Feb 19 09:18 .
drwxr-xr-x. 7 root root 4096 Jan 23 16:48 ..
drwxr-xr-x. 4 root root 37 Jan 23 16:48 allowed-actions
drwxr-xr-x. 2 root root 37 Feb 14 12:19 clientCaps.d
-rw-------. 1 root root 129 Jan 29 16:48 osad-auth.conf.rpmsave
-rw-r--r--. 1 root root 1446 Nov 26 21:50 rhncfg-client.conf
-rw-------. 1 root root 1321 Jan 23 16:51 systemid
-rw-r--r--. 1 root root 1948 Jan 23 16:51 up2date
In the rhncfg-client.conf I can find a log directory: script_log_file =
/var/log/rhn/rhncfg-action-output.log
But even this log file does not exist??
Warm regards,
Harald
Von: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com>
Im Auftrag von p.cook...@bham.ac.uk
Gesendet: Donnerstag, 14. Februar 2019 14:46
An: spacewalk-list@redhat.com
Betreff: Re: [Spacewalk-list] Spacewalk 2.8 | Offline Clients
No problem Harald. If you want to continue using rhnsd you can still
reduce the check-in time in /etc/sysconfig/rhn/rhnsd if you want though
(default is 240 mins):
# cat /etc/sysconfig/rhn/rhnsd
INTERVAL=240
#
Regards
Phil
From:
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com
>
<spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.co
m>> On Behalf Of harald.wacha...@akm.at<mailto:harald.wacha...@akm.at>
Sent: 14 February 2019 11:18
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: Re: [Spacewalk-list] Spacewalk 2.8 | Offline Clients
Hi Phil,
Thanks for your reply.
It looks like it was a rookie mistake.
I am new at Spacewalk and I followed the instructions here to register a
client.
https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_spacewalkp
roject_spacewalk_wiki_RegisteringClients&d=DwICAg&c=q3cDpHe1hF8lXU5EFjNM_A
&r=2sQoWEMcncSKL5kWoc_nrZbhUyhuj8tJfA91_lDSglQ&m=rQzksXP1uce_DHHtSiT7UWAMa
P4RBIR2nS2d3LXG-gs&s=ku28VreapnsJLj6Wwf44fezyLXxKiX67dzJdUcWKiCM&e=
Unfortunately there was no hint that you have to start the rhnsd service.
So I have started the service now and configured it to start
automatically.
And I need no osad at the moment. Every 4 hours check in is fine for me.
Thanks again,
Warm regards,
Harald
Von:
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com
>
<spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.co
m>> Im Auftrag von p.cook...@bham.ac.uk<mailto:p.cook...@bham.ac.uk>
Gesendet: Donnerstag, 14. Februar 2019 10:01
An: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Betreff: Re: [Spacewalk-list] Spacewalk 2.8 | Offline Clients
Hi Harald
Were they ok originally, and stopped working properly, or are you just
trying to setup OSAD for the first time? Either way if you work through my
personal notes (for OSAD), below, it may help to identify your problem. If
everything has been done correctly it may be an infrastructure problem
though ie un-reliable network connection or NTP?
By default, the rhnsd daemon on a client system connects to the Spacewalk
server every four hours (see /etc/sysconfig/rhn/rhnsd) and performs any
updates or actions that have been scheduled. If you install the OSA
daemon, you can apply updates and actions to client systems immediately
from the Spacewalk server.
osa-dispatcher
Server-side service that determines when an osad client instance needs to
be pinged or run rhn_check and sends a message telling them to do so. This
is installed when Spacewalk is installed.
Open Source Architecture Daemon (OSAD)
Client-side service that responds to pings and runs rhn_check when told to
by osa-dispatcher.
See official documentation, at the following link, for more details:
https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_spacewalkp
roject_spacewalk_wiki_OSADSetup&d=DwICAg&c=q3cDpHe1hF8lXU5EFjNM_A&r=2sQoWE
McncSKL5kWoc_nrZbhUyhuj8tJfA91_lDSglQ&m=rQzksXP1uce_DHHtSiT7UWAMaP4RBIR2nS
2d3LXG-gs&s=0T3K1Fqu460950yP4Ci6GLJYr69L9pvLGF9a2dUH_lw&e=
Install OSAD and related RHN/Spacewalk packages
# yum -y install osad rhncfg rhncfg-actions rhncfg-client
Spacewalk Actions Control - Enable Scheduled Actions
# rhn-actions-control --enable-all
Spacewalk Actions Control - Show Status
# rhn-actions-control --report
Start OSAD
# systemctl start osad.service OR service osad start
Enable OSAD
# systemctl enable osad.service OR chkconfig osad on
OSAD Log File
/var/log/osad
Hope this is of help
Phil
From:
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com
>
<spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.co
m>> On Behalf Of harald.wacha...@akm.at<mailto:harald.wacha...@akm.at>
Sent: 14 February 2019 08:22
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: Re: [Spacewalk-list] Spacewalk 2.8 | Offline Clients
Hi, Jonathan,
Looks good:
[root@vie-srv-log02 ~]# netstat -tn|grep 5222
tcp 0 0 172.21.0.181:46018 172.21.0.166:5222
ESTABLISHED
Nerveless the client is offline in spacewalk.
Warm regards,
Harald
Von:
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com
>
<spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.co
m>> Im Auftrag von Jonathan Horne
Gesendet: Mittwoch, 13. Februar 2019 21:48
An: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Betreff: Re: [Spacewalk-list] Spacewalk 2.8 | Offline Clients
all your clients should have established traffic to the spacewalk server
on port 5222. it should stay in an established state.
[jhorne@dlp-log01 ~]$ netstat -tn|grep 5222
tcp 0 0 10.12.59.52:38718 10.12.59.64:5222
ESTABLISHED
________________________________
From:
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com
>
<spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.co
m>> on behalf of Wachauer Harald
<harald.wacha...@akm.at<mailto:harald.wacha...@akm.at>>
Sent: Wednesday, February 13, 2019 10:17:45 AM
To: spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>
Subject: [Spacewalk-list] Spacewalk 2.8 | Offline Clients
Hi all,
I have the problem that most of my systems (CentOS 6 & 7) are going
offline after approximately one day.
Only if I run rhn_check the systems come online again, but only for short
time.
I have tried to install osad service, the service is running but nerveless
the client is going offline.
Any help would be very appreciated.
Best regards,
Harald
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.redhat.com_archi
ves_spacewalk-2Dlist_attachments_20190219_abadd95b_attachment.html&d=DwICA
g&c=q3cDpHe1hF8lXU5EFjNM_A&r=2sQoWEMcncSKL5kWoc_nrZbhUyhuj8tJfA91_lDSglQ&m
=rQzksXP1uce_DHHtSiT7UWAMaP4RBIR2nS2d3LXG-gs&s=ZMAD0JUQ9Ze3oH8XCJIxblKm083
sM_FD4lOwXpdG3Tg&e=>
------------------------------
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.redhat.com_mailma
n_listinfo_spacewalk-2Dlist&d=DwICAg&c=q3cDpHe1hF8lXU5EFjNM_A&r=2sQoWEMcnc
SKL5kWoc_nrZbhUyhuj8tJfA91_lDSglQ&m=rQzksXP1uce_DHHtSiT7UWAMaP4RBIR2nS2d3L
XG-gs&s=ax68_eh94tjxhGIT-kQaHNh5LsMrXUks9vsF8xTGiyY&e=
End of Spacewalk-list Digest, Vol 129, Issue 31
***********************************************
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
