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-boun...@redhat.com <spacewalk-list-boun...@redhat.com> on behalf of Matt Moldvan <m...@moldvan.com> Sent: Friday, February 24, 2017 1:23 PM To: spacewalk-list@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 <whten...@up.com<mailto:whten...@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 <darylr...@outlook.com<mailto:darylr...@outlook.com>> To: "spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>" <spacewalk-list@redhat.com<mailto:spacewalk-list@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-boun...@redhat.com<mailto:spacewalk-list-boun...@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-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> <spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com>> on behalf of Matt Moldvan <m...@moldvan.com<mailto:m...@moldvan.com>> Sent: Friday, February 24, 2017 10:08 AM To: spacewalk-list@redhat.com<mailto:spacewalk-list@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 <darylr...@outlook.com<mailto:darylr...@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@redhat.com<mailto:Spacewalk-list@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@redhat.com<mailto:Spacewalk-list@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@redhat.com<mailto: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
