In fact, the query seems to be a bit too much restrictive. I've downloaded a recent patch (not installed on my system) from oracle support and rhnpushed it. When I go in the details of the patch, in the tab "target system" my client is listed. But when I go in my system details, Software --> Patches --> Install, it is not listed.
Patch number: 121430 spaceschema=# select * from rhnServerOutdatedPackages where server_id = 1000010008; server_id | package_name_id | package_evr_id | package_nvre | errata_id | errata_advisory ------------+-----------------+----------------+---------------------------+-----------+----------------- 1000010008 | 7143 | 8682 | patch-solaris-121430-73-1 | | The patch is listed as needed! But the patch is not listed in the list of patches that can be installed on my system. Pierre 2012/12/4 Pierre Casenove <[email protected]> > I've modified as Jan suggested. > The query is now correctly executed. > And the query is much better: I get a list of 39 patches only, but when I > take a closer look, these patches are not applicable to my ystem, as the > package it patches is not installed. > Exemple with patch 120412: > warning: The following requested patches have packages not installed on > the system > warning: Package SUNWcleu2 from directory SUNWcleu2 in patch 120412-11 is > not installed on the system. Changes for package SUNWcleu2 will not be > applied to the system. > > I'm not sure if spacewalk is able to detect that, even more because I > actually didn't rhnpushed all the Solaris packages to spacewalk server, but > only the patches. > > If the behaviour is as expected, you can commit. > > > 2012/12/4 Jan Pazdziora <[email protected]> > >> On Tue, Dec 04, 2012 at 04:21:18PM +0100, Pierre Casenove wrote: >> > hello, >> > I've patched rhn.jar... and now, I get an ISE: >> > >> > Caused by: org.postgresql.util.PSQLException: ERROR: column reference >> > "name" is ambiguous >> > I'm on RHEL 5 with pgsql 8.4. >> >> Could you change that >> >> order by upper(name || '-' || evr_t_as_vre_simple(full_list.evr)) >> >> in the patch to >> >> order by upper(pn.name || '-' || >> evr_t_as_vre_simple(full_list.evr)) >> >> ? (Not tested, just looking at the code.) >> >> -- >> Jan Pazdziora >> Principal Software Engineer, Satellite Engineering, Red Hat >> >> _______________________________________________ >> Spacewalk-list mailing list >> [email protected] >> https://www.redhat.com/mailman/listinfo/spacewalk-list >> > >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
