[Spacewalk-list] How to tell what Errata has been applied

[Daryl Rose]

Ah.....requires php-pgsql.   Perhaps that is what I'm having issues with.


Actually, I was going to put it on a SLES server that I have setup with LAMP, but perhaps I'll set something else up somewhere else using a server that I can add php-pgsql to.


Thank you Matt for providing this script.


Daryl


________________________________
From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com> on behalf of Matt Moldvan <matt at moldvan.com>
Sent: Friday, February 24, 2017 1:23 PM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] How to tell what Errata has been applied

William is right, this will get you what you need.  :)

You'll also need php and php-pgsql packages installed, assuming it's a RHEL/CentOS system you'll be putting this on.

On Fri, Feb 24, 2017 at 1:53 PM William H. ten Bensel <WHTENBEN at up.com<mailto:WHTENBEN at up.com>> wrote:
I believe the User and password are stored in the rhn.conf

awk -F= '/db_[user|password]/ {print $2}' /etc/rhn/rhn.conf

- Thanks and good luck



From:        Daryl Rose <darylrose at outlook.com<mailto:darylrose at outlook.com>>
To:        "spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>" <spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>>
Date:        02/24/2017 12:44 PM

Subject:        Re: [Spacewalk-list] How to tell what Errata has been applied

Sent by:        spacewalk-list-bounces at redhat.com<mailto:spacewalk-list-bounces at redhat.com>

________________________________



This email originated from outside of the company. Please use discretion if opening attachments or clicking on links.
________________________________


Matt,

Thank you very much for this tool.  I'll give it a try, however, I'm not sure what the postgres db user and password is.  I don't remember what I set those to when I installed SW.

Is there a way for me to pull that information from the database?

Thanks

Daryl

________________________________

From: spacewalk-list-bounces at redhat.com<mailto:spacewalk-list-bounces at redhat.com> <spacewalk-list-bounces at redhat.com<mailto:spacewalk-list-bounces at redhat.com>> on behalf of Matt Moldvan <matt at moldvan.com<mailto:matt at moldvan.com>>
Sent: Friday, February 24, 2017 10:08 AM
To: spacewalk-list at redhat.com<mailto:spacewalk-list at redhat.com>
Subject: Re: [Spacewalk-list] How to tell what Errata has been applied

I hacked together some PHP which connects directly to the Postgres database and provides some "pretty" reports to operations folks and anyone else that wanted to see what we'd done (Information Security/Compliance/App teams/etc).

I just took a few minutes to sanitize it and upload it to GitHub, if you're interested.  It's not overly pretty, but it works for our needs...

https://github.com/sandwormusmc/spacewalk-php-reports
GitHub - sandwormusmc/spacewalk-php-reports<https://github.com/sandwormusmc/spacewalk-php-reports>
github.com<http://github.com>
Contribute to spacewalk-php-reports development by creating an account on GitHub.



Feedback welcome.  :D

On Tue, Feb 21, 2017 at 10:11 AM Daryl Rose <darylrose at outlook.com<mailto:darylrose at outlook.com>> wrote:
Is there a way to list what errata has already been applied to a machine?  I can list what is available, but I need to know what has been applied.

Thank you.

Daryl
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>

https://www.redhat.com/mailman/listinfo/spacewalk-listThis email originated from outside of the company.  Please use discretion if opening attachments or clicking on links.


_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>

https://www.redhat.com/mailman/listinfo/spacewalk-list



**



This email and any attachments may contain information that is confidential and/or privileged for the sole use of the intended recipient. Any use, review, disclosure, copying, distribution or reliance by others, and any forwarding of this email or its contents, without the express permission of the sender is strictly prohibited by law. If you are not the intended recipient, please contact the sender immediately, delete the e-mail and destroy all copies.

**

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170224/1e97fb9b/attachment.htm>