[Spacewalk-list] [Solaris support] installed patches not refreshed

[Pierre Casenove]

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 <pcasenove at gmail.com>

> 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 <jpazdziora at redhat.com>
>
>> 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
>> 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/20121204/742e2462/attachment.htm>