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

[Paul-Andre Panon]

Well, since the default rhn_check interval is 4 hours, you would have to
wait that long. Even after a manual rhn_check, the change isn’t
instantaneous because it takes a few minutes before the queued taskomatic
task executes. But if you wait overnight, all your servers should update.


On Sat, Dec 22, 2018 at 3:47 PM philippe bidault <philippe.bidault at gmail.com>
wrote:

> 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
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__bugzilla.redhat.com_show-5Fbug.cgi-3Fid-3D1661347&d=DwMFaQ&c=q3cDpHe1hF8lXU5EFjNM_A&r=2sQoWEMcncSKL5kWoc_nrZbhUyhuj8tJfA91_lDSglQ&m=9Td0Je5VLi1R4E4S0vJsnUBgKXfOqHEZmjYwV-Ul4cY&s=ebhTpxGQlekAIAnqOi_VHplD-WL6ouWR6qFoRRFyK-Y&e=>
>> , 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
>>>>
>>> --
Paul-Andre Panon
Senior Systems Administrator

*Avigilon*
A Motorola Solutions Company
Office +1 604-629-5182 ext. 2341  |  Mobile +1 604-679-1617
Support +1 888-281-5182  |  avigilon.com
Facebook <https://www.facebook.com/avigiloncorporation>  |  LinkedIn
<https://www.linkedin.com/company/avigilon>  |  Twitter
<https://twitter.com/Avigilon> |  YouTube
<https://www.youtube.com/user/Avigilon>
This email, including any files attached hereto (the "email"), contains
privileged and confidential information and is only for the intended
addressee(s). If this email has been sent to you in error, such sending
does not constitute waiver of privilege and we request that you kindly
delete the email and notify the sender. Any unauthorized use or disclosure
of this email is prohibited. Avigilon and certain other trade names used
herein are the registered and/or unregistered trademarks of Avigilon
Corporation and/or its affiliates in Canada and other jurisdictions
worldwide.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20181231/190993e0/attachment.htm>