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

[Pierre Casenove]

Hello,
Did you find why the new query doesn't worki either?
Do you want me to fill a BZ?

Thanks,

Pierre


2012/12/4 Pierre Casenove <pcasenove at gmail.com>

> 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/20121218/21a5440e/attachment.htm>