[Spacewalk-list] Ubuntu 18.04 package management in Spacewalk 2.8

[philippe bidault]

Bonjour Paul-André,

I did try your procedure and ...amazing !

Before applying the SP, I had to change the OWNER as it is rhnuser in my
case :

ALTER FUNCTION rpm.rpmstrcmp(string1 character varying, string2 character
varying) OWNER TO *rhnuser*;

To apply the SP :

# su - postgres
Last login: Sat Dec 22 16:20:46 CET 2018 on pts/1
-bash-4.2$ psql rhnschema -f /var/tmp/rpm.rpmstrcmp.sql
SET
CREATE FUNCTION
ALTER FUNCTION

And I did restart the satellite service.

However even after waiting and finally force the "rhn_check" on a
registered Ubuntu 18.04 server, nothing occured. I did have to remove and
register again the Ubuntu client server to see the difference, means no
more packages flagged as upgradable appaearing on the Spacewalk server.

Will continue to keep an eye on this, will let you know if I notice
something strange.

Thanks again !

Regards,
Philippe.

On Sat, 22 Dec 2018 at 08:50, Paul-Andre Panon <
paul-andre.panon at avigilon.com> wrote:

> Bonjour Phillipe,
>
> Robert can vouch that this issue's actually been bugging me since SW 2.8
> came out, when I found out that this was still a problem despite PR500's
> improvements. I just haven't had enough time until this month to look at it
> and dig through all the layers to figure out the root cause.
>
> If you go to the bug, https://bugzilla.redhat.com/show_bug.cgi?id=1661347
> , I had added an attachment there. You should be able to download the
> attachment and
> 1) stop your Spacewalk service
> 2) backup your database
> 3) sudo su postgres or add your spaceuser/password to psql -i
> rpm.rpmstrcmp.sql
> 4) exit psql if needed and restart your Spacewalk service
> and then wait for servers to run the next rhn_check to update their needed
> updates list.
>
> Cheers,
>
> Paul-Andre Panon
> Senior Systems Administrator
>
> *Avigilon*
> A Motorola Solutions Company
>
>
> On Fri, 21 Dec 2018 at 04:00, philippe bidault <philippe.bidault at gmail.com>
> wrote:
>
>> Indeed, really appreciated Paul-Andre, I did not expect somebody to work
>> so fast to solve this issue !!
>> Not sure that I will be able to implement your new PostgreSQL SP in our
>> current Spacewalk platform, I need to understand before the full
>> implication of such modification and the harmless way to do it.
>>
>> Do you think that a patch, update or something will be delivered soon to
>> allow an easy implementation of your work ?
>>
>> Regards,
>> Philippe.
>>
>>
>>
>>
>> On Fri, 21 Dec 2018 at 07:27, Robert Paschedag <robert.paschedag at web.de>
>> wrote:
>>
>>> Am 21. Dezember 2018 00:44:02 MEZ schrieb Paul-Andre Panon <
>>> paul-andre.panon at avigilon.com>:
>>> >I created Bugzilla Bug 1661347 regarding this issue
>>>
>>> Great job, Paul-Andre. Thanks.
>>>
>>> Robert
>>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20181223/d891bba7/attachment.htm>