Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-23 Thread Michael Mraka
TOMAŠKOVIČ Marcel:
> Hi Michael,
> Thank you and development team for this project. I think, this project is 
> very sucessful.
> I have question - is there another solution / product for system mangment in 
> linux (RHEL)? Somethng like Spacewalk..

Hello Marcel,

New version of Red Hat Satellite (aka Satellite 6) is based on 
https://theforeman.org
project with Katello plugin (https://theforeman.org/plugins/katello/).

There's also https://www.uyuni-project.org which is a fork of Spacewalk made by 
SUSE.

> Thank you,
> Best regards
> Marcel

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-20 Thread Brian Long
+1.  Thanks for the extended support.

On Fri, Mar 20, 2020 at 9:30 AM Coffman, Anthony J
 wrote:
>
> Michael Mráka
> >Spacewalk 2.10 was the last official release of Spacewalk.
>
> Thank you very much to the development team and to the community for this 
> highly successful project and software.
>
> Regards,
> --Tony Coffman
>
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list


___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-20 Thread TOMAŠKOVIČ Marcel
Hi Michael,
Thank you and development team for this project. I think, this project is very 
sucessful.
I have question - is there another solution / product for system mangment in 
linux (RHEL)? Somethng like Spacewalk..

Thank you,
Best regards
Marcel


-Original Message-
From: spacewalk-list-boun...@redhat.com  On 
Behalf Of Michael Mraka
Sent: Friday, March 20, 2020 2:04 PM
To: spacewalk-list@redhat.com; spacewalk-de...@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk 2.10 Released!

> Hello everyone,
> 
> We are proudly announcing release of Spacewalk 2.10, a systems management 
> solution.

Hello Spacewalkers,

I'd like to set properly expectations about future of this project. As you most 
likely know this project is an upstream for Red Hat Satellite 5 product.
And Satellite 5 is going to be End Of Life on May 31 2020. This also means Red 
Hat will discontinue an active support of this project.

The most important message is
Spacewalk 2.10 was the last official release of Spacewalk.

Git repo, project pages, documentation and wiki will still be available (we 
plan to switch them to readonly). COPR repos (which means packages) will also 
remain available.


Regards,

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-20 Thread Coffman, Anthony J
Michael Mráka
>Spacewalk 2.10 was the last official release of Spacewalk.

Thank you very much to the development team and to the community for this 
highly successful project and software.

Regards,
--Tony Coffman

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-20 Thread Michael Mraka
> Hello everyone,
> 
> We are proudly announcing release of Spacewalk 2.10, a systems management 
> solution.

Hello Spacewalkers,

I'd like to set properly expectations about future of this project. As you 
most likely know this project is an upstream for Red Hat Satellite 5 product.
And Satellite 5 is going to be End Of Life on May 31 2020. This also means Red 
Hat
will discontinue an active support of this project.

The most important message is
Spacewalk 2.10 was the last official release of Spacewalk.

Git repo, project pages, documentation and wiki will still be available
(we plan to switch them to readonly). COPR repos (which means packages)
will also remain available.


Regards,

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-20 Thread Michael Mraka
Eckert, Doug:
> Thanks. So, in my instance, it should get '106' right?

Yes.
 
> rhnschema=# select * from rhnPackageProvider;
>  id  |   name   |created|   modified
> -+--+---+---
> 
>  100 | Red Hat Inc. | 2020-02-18 10:56:43.314315-05 | 2020-02-18
> 10:56:43.314315-05
>  101 | Fedora   | 2020-02-18 10:56:43.316934-05 | 2020-02-18
> 10:56:43.316934-05
>  102 | CentOS   | 2020-02-18 10:56:43.318202-05 | 2020-02-18
> 10:56:43.318202-05
>  103 | Scientific Linux | 2020-02-18 10:56:43.319269-05 | 2020-02-18
> 10:56:43.319269-05
>  104 | SUSE | 2020-02-18 10:56:43.320548-05 | 2020-02-18
> 10:56:43.320548-05
>  105 | Oracle Inc.  | 2020-02-18 10:56:43.321994-05 | 2020-02-18
> 10:56:43.321994-05
>  106 | Spacewalk| 2020-02-18 10:56:43.323291-05 | 2020-02-18
> 10:56:43.323291-05
>  107 | EPEL | 2020-02-18 10:56:43.324363-05 | 2020-02-18
> 10:56:43.324363-05
>  108 | Novell Inc.  | 2020-02-18 10:56:43.325785-05 | 2020-02-18
> 10:56:43.325785-05
> (9 rows)
> 
> On Thu, Mar 19, 2020 at 10:56 AM Michael Mraka 
> wrote:
> 
> > Eckert, Doug:
> > > If someone would run the below, I'd be very grateful:
> > >
> > > select name from rhnPackageProvider where id=(select provider_id from
> > > rhnPackageKey where key_id='49fc0fd89bd837ba');
> >
> > It's Spacewalk 2.9 client key.
> >
> > Regards,

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Eckert, Doug
Thanks. So, in my instance, it should get '106' right?

rhnschema=# select * from rhnPackageProvider;
 id  |   name   |created|   modified
-+--+---+---

 100 | Red Hat Inc. | 2020-02-18 10:56:43.314315-05 | 2020-02-18
10:56:43.314315-05
 101 | Fedora   | 2020-02-18 10:56:43.316934-05 | 2020-02-18
10:56:43.316934-05
 102 | CentOS   | 2020-02-18 10:56:43.318202-05 | 2020-02-18
10:56:43.318202-05
 103 | Scientific Linux | 2020-02-18 10:56:43.319269-05 | 2020-02-18
10:56:43.319269-05
 104 | SUSE | 2020-02-18 10:56:43.320548-05 | 2020-02-18
10:56:43.320548-05
 105 | Oracle Inc.  | 2020-02-18 10:56:43.321994-05 | 2020-02-18
10:56:43.321994-05
 106 | Spacewalk| 2020-02-18 10:56:43.323291-05 | 2020-02-18
10:56:43.323291-05
 107 | EPEL | 2020-02-18 10:56:43.324363-05 | 2020-02-18
10:56:43.324363-05
 108 | Novell Inc.  | 2020-02-18 10:56:43.325785-05 | 2020-02-18
10:56:43.325785-05
(9 rows)

On Thu, Mar 19, 2020 at 10:56 AM Michael Mraka 
wrote:

> Eckert, Doug:
> > If someone would run the below, I'd be very grateful:
> >
> > select name from rhnPackageProvider where id=(select provider_id from
> > rhnPackageKey where key_id='49fc0fd89bd837ba');
>
> It's Spacewalk 2.9 client key.
>
> Regards,
>
> --
> Michael Mráka
> System Management Engineering, Red Hat
>
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list



-- 
Doug Eckert
LEAD ENGINEER, COMPUTE
[image: NewsTech] 
M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993 <+1+555+555+>
E: doug.eck...@dowjones.com 
A: PO Box 300, Princeton, NJ 08543
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Michael Mraka
Eckert, Doug:
> If someone would run the below, I'd be very grateful:
> 
> select name from rhnPackageProvider where id=(select provider_id from
> rhnPackageKey where key_id='49fc0fd89bd837ba');

It's Spacewalk 2.9 client key.

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Eckert, Doug
If someone would run the below, I'd be very grateful:

select name from rhnPackageProvider where id=(select provider_id from
rhnPackageKey where key_id='49fc0fd89bd837ba');



On Thu, Mar 19, 2020 at 9:00 AM Eckert, Doug 
wrote:

> I still have one key (49fc0fd89bd837ba) with a NULL provider_id. That one
> isn't inserted in the schema_upgrade. Not sure what to use for the
> 'lookup_package_provider' function.
>
> So, I checked out the code for the function (rhnschema=# \df+
> lookup_package_provider;) and saw it queries rhnPackageProvider;
>
> Anyone know which is the appropriate provided for key_id
> 49fc0fd89bd837ba?
>
> rhnschema=# select * from rhnPackageProvider;
>  id  |   name   |created|
> modified
>
> -+--+---+---
>  100 | Red Hat Inc. | 2020-02-18 10:56:43.314315-05 | 2020-02-18
> 10:56:43.314315-05
>  101 | Fedora   | 2020-02-18 10:56:43.316934-05 | 2020-02-18
> 10:56:43.316934-05
>  102 | CentOS   | 2020-02-18 10:56:43.318202-05 | 2020-02-18
> 10:56:43.318202-05
>  103 | Scientific Linux | 2020-02-18 10:56:43.319269-05 | 2020-02-18
> 10:56:43.319269-05
>  104 | SUSE | 2020-02-18 10:56:43.320548-05 | 2020-02-18
> 10:56:43.320548-05
>  105 | Oracle Inc.  | 2020-02-18 10:56:43.321994-05 | 2020-02-18
> 10:56:43.321994-05
>  106 | Spacewalk| 2020-02-18 10:56:43.323291-05 | 2020-02-18
> 10:56:43.323291-05
>  107 | EPEL | 2020-02-18 10:56:43.324363-05 | 2020-02-18
> 10:56:43.324363-05
>  108 | Novell Inc.  | 2020-02-18 10:56:43.325785-05 | 2020-02-18
> 10:56:43.325785-05
> (9 rows)
>
> On Thu, Mar 19, 2020 at 8:47 AM Ree, Jan-Albert van 
> wrote:
>
>> Thanks a lot , the update works perfectly here as well
>>
>> I had 3 updates to make and now all is as it should be
>>
>> --
>>
>> Jan-Albert
>>
>>
>>
>> Jan-Albert van Ree | HPC Specialist | Digital Services
>> MARIN | T +31 317 49 35 48 | j.a.v@marin.nl | www.marin.nl
>>
>> [image: LinkedIn] <https://www.linkedin.com/company/marin> [image:
>> YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter]
>> <https://twitter.com/MARIN_nieuws> [image: Facebook]
>> <https://www.facebook.com/marin.wageningen>
>> MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship
>> design
>> <https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>
>>
>> ----------
>> *From:* spacewalk-list-boun...@redhat.com <
>> spacewalk-list-boun...@redhat.com> on behalf of Eckert, Doug <
>> doug.eck...@dowjones.com>
>> *Sent:* Thursday, March 19, 2020 13:28
>> *To:* spacewalk-list@redhat.com
>> *Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released!
>>
>> I tried, but it wouldn't let me remove the record due to foreign key
>> reference, so I updated the existing record instead with the value it
>> would've used from the 'insert' command:
>>
>> rhnschema=# update rhnPackageKey set
>> provider_id=lookup_package_provider('CentOS') where
>> key_id='05b555b38483c65d';
>> UPDATE 1
>> rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
>>  id  |  key_id  | key_type_id | provider_id |created
>>|   modified
>>
>> -+--+-+-+---+---
>>  157 | 05b555b38483c65d | 100 | 102 | 2020-02-21
>> 09:06:55.782751-05 | 2020-03-19 08:26:56.268446-04
>> (1 row)
>>
>> ​
>>
>> ___
>> Spacewalk-list mailing list
>> Spacewalk-list@redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> --
> Doug Eckert
> LEAD ENGINEER, COMPUTE
> [image: NewsTech] <http://www.newscorp.com/>
> M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993
> <+1+555+555+>
> E: doug.eck...@dowjones.com 
> A: PO Box 300, Princeton, NJ 08543
>


-- 
Doug Eckert
LEAD ENGINEER, COMPUTE
[image: NewsTech] <http://www.newscorp.com/>
M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993 <+1+555+555+>
E: doug.eck...@dowjones.com 
A: PO Box 300, Princeton, NJ 08543
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Eckert, Doug
I still have one key (49fc0fd89bd837ba) with a NULL provider_id. That one
isn't inserted in the schema_upgrade. Not sure what to use for the
'lookup_package_provider' function.

So, I checked out the code for the function (rhnschema=# \df+
lookup_package_provider;) and saw it queries rhnPackageProvider;

Anyone know which is the appropriate provided for key_id  49fc0fd89bd837ba?

rhnschema=# select * from rhnPackageProvider;
 id  |   name   |created|   modified
-+--+---+---
 100 | Red Hat Inc. | 2020-02-18 10:56:43.314315-05 | 2020-02-18
10:56:43.314315-05
 101 | Fedora   | 2020-02-18 10:56:43.316934-05 | 2020-02-18
10:56:43.316934-05
 102 | CentOS   | 2020-02-18 10:56:43.318202-05 | 2020-02-18
10:56:43.318202-05
 103 | Scientific Linux | 2020-02-18 10:56:43.319269-05 | 2020-02-18
10:56:43.319269-05
 104 | SUSE | 2020-02-18 10:56:43.320548-05 | 2020-02-18
10:56:43.320548-05
 105 | Oracle Inc.  | 2020-02-18 10:56:43.321994-05 | 2020-02-18
10:56:43.321994-05
 106 | Spacewalk| 2020-02-18 10:56:43.323291-05 | 2020-02-18
10:56:43.323291-05
 107 | EPEL | 2020-02-18 10:56:43.324363-05 | 2020-02-18
10:56:43.324363-05
 108 | Novell Inc.  | 2020-02-18 10:56:43.325785-05 | 2020-02-18
10:56:43.325785-05
(9 rows)

On Thu, Mar 19, 2020 at 8:47 AM Ree, Jan-Albert van 
wrote:

> Thanks a lot , the update works perfectly here as well
>
> I had 3 updates to make and now all is as it should be
>
> --
>
> Jan-Albert
>
>
>
> Jan-Albert van Ree | HPC Specialist | Digital Services
> MARIN | T +31 317 49 35 48 | j.a.v@marin.nl | www.marin.nl
>
> [image: LinkedIn] <https://www.linkedin.com/company/marin> [image:
> YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter]
> <https://twitter.com/MARIN_nieuws> [image: Facebook]
> <https://www.facebook.com/marin.wageningen>
> MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship
> design
> <https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>
>
> --
> *From:* spacewalk-list-boun...@redhat.com <
> spacewalk-list-boun...@redhat.com> on behalf of Eckert, Doug <
> doug.eck...@dowjones.com>
> *Sent:* Thursday, March 19, 2020 13:28
> *To:* spacewalk-list@redhat.com
> *Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released!
>
> I tried, but it wouldn't let me remove the record due to foreign key
> reference, so I updated the existing record instead with the value it
> would've used from the 'insert' command:
>
> rhnschema=# update rhnPackageKey set
> provider_id=lookup_package_provider('CentOS') where
> key_id='05b555b38483c65d';
> UPDATE 1
> rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
>  id  |  key_id  | key_type_id | provider_id |created
>  |   modified
>
> -+--+-+-+---+---
>  157 | 05b555b38483c65d | 100 | 102 | 2020-02-21
> 09:06:55.782751-05 | 2020-03-19 08:26:56.268446-04
> (1 row)
>
> ​
>
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list



-- 
Doug Eckert
LEAD ENGINEER, COMPUTE
[image: NewsTech] <http://www.newscorp.com/>
M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993 <+1+555+555+>
E: doug.eck...@dowjones.com 
A: PO Box 300, Princeton, NJ 08543
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Ree, Jan-Albert van
Yes indeed, I just went on as described and saw now adverse effects.

​--

Jan-Albert​

Jan-Albert van Ree | HPC Specialist | Digital Services
MARIN | T +31 317 49 35 48 | j.a.v@marin.nl<mailto:j.a.v@marin.nl> | 
www.marin.nl<http://www.marin.nl>

[LinkedIn]<https://www.linkedin.com/company/marin> [YouTube] 
<http://www.youtube.com/marinmultimedia>  [Twitter] 
<https://twitter.com/MARIN_nieuws>  [Facebook] 
<https://www.facebook.com/marin.wageningen>
MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship 
design<https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>


From: spacewalk-list-boun...@redhat.com  on 
behalf of Eckert, Doug 
Sent: Thursday, March 19, 2020 13:36
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk 2.10 Released!

One last question... when you were done, you just proceeded with 
'spacewalk-setup --upgrade'?


___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Ree, Jan-Albert van
Thanks a lot , the update works perfectly here as well

I had 3 updates to make and now all is as it should be

--

Jan-Albert


Jan-Albert van Ree | HPC Specialist | Digital Services
MARIN | T +31 317 49 35 48 | j.a.v@marin.nl<mailto:j.a.v@marin.nl> | 
www.marin.nl<http://www.marin.nl>

[LinkedIn]<https://www.linkedin.com/company/marin> [YouTube] 
<http://www.youtube.com/marinmultimedia>  [Twitter] 
<https://twitter.com/MARIN_nieuws>  [Facebook] 
<https://www.facebook.com/marin.wageningen>
MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship 
design<https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>


From: spacewalk-list-boun...@redhat.com  on 
behalf of Eckert, Doug 
Sent: Thursday, March 19, 2020 13:28
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk 2.10 Released!

I tried, but it wouldn't let me remove the record due to foreign key reference, 
so I updated the existing record instead with the value it would've used from 
the 'insert' command:

rhnschema=# update rhnPackageKey set 
provider_id=lookup_package_provider('CentOS') where key_id='05b555b38483c65d';
UPDATE 1
rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
 id  |  key_id  | key_type_id | provider_id |created
|   modified
-+--+-+-+---+---
 157 | 05b555b38483c65d | 100 | 102 | 2020-02-21 
09:06:55.782751-05 | 2020-03-19 08:26:56.268446-04
(1 row)

​


___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Eckert, Doug
gt;>>
>>>>
>>>> Jan-Albert van Ree | HPC Specialist | Digital Services
>>>> MARIN | T +31 317 49 35 48 | j.a.v@marin.nl | www.marin.nl
>>>>
>>>> [image: LinkedIn] <https://www.linkedin.com/company/marin> [image:
>>>> YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter]
>>>> <https://twitter.com/MARIN_nieuws> [image: Facebook]
>>>> <https://www.facebook.com/marin.wageningen>
>>>> MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship
>>>> design
>>>> <https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>
>>>>
>>>> --
>>>> *From:* spacewalk-list-boun...@redhat.com <
>>>> spacewalk-list-boun...@redhat.com> on behalf of Eckert, Doug <
>>>> doug.eck...@dowjones.com>
>>>> *Sent:* Thursday, March 19, 2020 13:08
>>>> *To:* spacewalk-list@redhat.com
>>>> *Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released!
>>>>
>>>> Did you skip the one with the duplicate key constraint error, or did
>>>> you remove the existing record with the matching key and re-insert?
>>>>
>>>> ___
>>>> Spacewalk-list mailing list
>>>> Spacewalk-list@redhat.com
>>>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>>
>>>
>>>
>>> --
>>> Doug Eckert
>>> LEAD ENGINEER, COMPUTE
>>> [image: NewsTech] <http://www.newscorp.com/>
>>> M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993
>>> <+1+555+555+>
>>> E: doug.eck...@dowjones.com 
>>> A: PO Box 300, Princeton, NJ 08543
>>>
>>
>>
>> --
>> Doug Eckert
>> LEAD ENGINEER, COMPUTE
>> [image: NewsTech] <http://www.newscorp.com/>
>> M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993
>> <+1+555+555+>
>> E: doug.eck...@dowjones.com 
>> A: PO Box 300, Princeton, NJ 08543
>>
>
>
> --
> Doug Eckert
> LEAD ENGINEER, COMPUTE
> [image: NewsTech] <http://www.newscorp.com/>
> M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993
> <+1+555+555+>
> E: doug.eck...@dowjones.com 
> A: PO Box 300, Princeton, NJ 08543
>


-- 
Doug Eckert
LEAD ENGINEER, COMPUTE
[image: NewsTech] <http://www.newscorp.com/>
M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993 <+1+555+555+>
E: doug.eck...@dowjones.com 
A: PO Box 300, Princeton, NJ 08543
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Eckert, Doug
FYI - I also had the same issue with the last key insert. Did the same for
it, using the ' lookup_package_provider' as specified in the insert command

rhnschema=# insert into rhnPackageKey (id, key_id, key_type_id,
provider_id) values
rhnschema-# (sequence_nextval('rhn_pkey_id_seq'), '21ea45ab2f86d6a1',
lookup_package_key_type('gpg'), lookup_package_provider('EPEL'));
ERROR:  duplicate key value violates unique constraint "rhn_pkey_keyid_uq"
DETAIL:  Key (key_id)=(21ea45ab2f86d6a1) already exists.

rhnschema=# update rhnPackageKey set
provider_id=lookup_package_provider('EPEL') where key_id='21ea45ab2f86d6a1';
UPDATE 1

rhnschema=# select * from rhnPackageKey where key_id='21ea45ab2f86d6a1';
 id  |  key_id  | key_type_id | provider_id |created
 |   modified
-+--+-+-+---+---
 158 | 21ea45ab2f86d6a1 | 100 | 107 | 2020-02-21
10:53:24.558639-05 | 2020-03-19 08:30:05.672277-04
(1 row)

On Thu, Mar 19, 2020 at 8:28 AM Eckert, Doug 
wrote:

> I tried, but it wouldn't let me remove the record due to foreign key
> reference, so I updated the existing record instead with the value it
> would've used from the 'insert' command:
>
> rhnschema=# update rhnPackageKey set
> provider_id=lookup_package_provider('CentOS') where
> key_id='05b555b38483c65d';
> UPDATE 1
> rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
>  id  |  key_id  | key_type_id | provider_id |created
>  |   modified
>
> -+--+-+-+---+---
>  157 | 05b555b38483c65d | 100 | 102 | 2020-02-21
> 09:06:55.782751-05 | 2020-03-19 08:26:56.268446-04
> (1 row)
>
> On Thu, Mar 19, 2020 at 8:21 AM Eckert, Doug 
> wrote:
>
>> I asked because on my server, the matching key_id has an empty
>> 'provider_id' field
>>
>> rhnschema=# insert into rhnPackageKey (id, key_id, key_type_id,
>> provider_id) values
>> rhnschema-# (sequence_nextval('rhn_pkey_id_seq'), '05b555b38483c65d',
>> lookup_package_key_type('gpg'), lookup_package_provider('CentOS'));
>> ERROR:  duplicate key value violates unique constraint "rhn_pkey_keyid_uq"
>> DETAIL:  Key (key_id)=(05b555b38483c65d) already exists.
>>
>> rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
>>  id  |  key_id  | key_type_id | provider_id |created
>>|   modified
>>
>> -+--+-+-+---+---
>>  157 | 05b555b38483c65d | 100 | | 2020-02-21
>> 09:06:55.782751-05 | 2020-02-21 09:06:55.782751-05
>> (1 row)
>>
>> Actually, there are 3 rows (out of 160) with a NULL provider_id.
>>
>> 156 | 49fc0fd89bd837ba | 100 | | 2020-02-19
>> 02:06:37.884325-05 | 2020-02-19 02:06:37.884325-05
>> 157 | 05b555b38483c65d | 100 | | 2020-02-21
>> 09:06:55.782751-05 | 2020-02-21 09:06:55.782751-05
>> 158 | 21ea45ab2f86d6a1 | 100 | | 2020-02-21
>> 10:53:24.558639-05 | 2020-02-21 10:53:24.558639-05
>>
>> Wondering if it would be wiser to remove the record
>>
>> delete from  rhnPackageKey  where key_id='05b555b38483c65d';
>>
>> Then re-insert it with the same id (157 in my case):
>>
>> insert into rhnPackageKey (id, key_id, key_type_id, provider_id) values
>> (157, '05b555b38483c65d', lookup_package_key_type('gpg'),
>> lookup_package_provider('CentOS'));
>>
>>
>>
>>
>> On Thu, Mar 19, 2020 at 8:14 AM Ree, Jan-Albert van 
>> wrote:
>>
>>> ​I skipped nothing but executed all queries, continuing on errors with
>>> the next one and assumed that if there was an existing record it would be
>>> fine already...
>>>
>>> Maybe not the best way, but it worked.
>>>
>>> --
>>>
>>> Jan-Albert
>>>
>>>
>>>
>>> Jan-Albert van Ree | HPC Specialist | Digital Services
>>> MARIN | T +31 317 49 35 48 | j.a.v@marin.nl | www.marin.nl
>>>
>>> [image: LinkedIn] <https://www.linkedin.com/company/marin> [image:
>>> YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter]
>>> <https://twitter.com/MARIN_nieuws> [image: Facebook]
>>> <https://www.facebook.com/marin.wageningen>
>>> MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship
>>> design
>

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Eckert, Doug
I tried, but it wouldn't let me remove the record due to foreign key
reference, so I updated the existing record instead with the value it
would've used from the 'insert' command:

rhnschema=# update rhnPackageKey set
provider_id=lookup_package_provider('CentOS') where
key_id='05b555b38483c65d';
UPDATE 1
rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
 id  |  key_id  | key_type_id | provider_id |created
 |   modified
-+--+-+-+---+---
 157 | 05b555b38483c65d | 100 | 102 | 2020-02-21
09:06:55.782751-05 | 2020-03-19 08:26:56.268446-04
(1 row)

On Thu, Mar 19, 2020 at 8:21 AM Eckert, Doug 
wrote:

> I asked because on my server, the matching key_id has an empty
> 'provider_id' field
>
> rhnschema=# insert into rhnPackageKey (id, key_id, key_type_id,
> provider_id) values
> rhnschema-# (sequence_nextval('rhn_pkey_id_seq'), '05b555b38483c65d',
> lookup_package_key_type('gpg'), lookup_package_provider('CentOS'));
> ERROR:  duplicate key value violates unique constraint "rhn_pkey_keyid_uq"
> DETAIL:  Key (key_id)=(05b555b38483c65d) already exists.
>
> rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
>  id  |  key_id  | key_type_id | provider_id |created
>  |   modified
>
> -+--+-+-+---+---
>  157 | 05b555b38483c65d | 100 | | 2020-02-21
> 09:06:55.782751-05 | 2020-02-21 09:06:55.782751-05
> (1 row)
>
> Actually, there are 3 rows (out of 160) with a NULL provider_id.
>
> 156 | 49fc0fd89bd837ba | 100 | | 2020-02-19
> 02:06:37.884325-05 | 2020-02-19 02:06:37.884325-05
> 157 | 05b555b38483c65d | 100 | | 2020-02-21
> 09:06:55.782751-05 | 2020-02-21 09:06:55.782751-05
> 158 | 21ea45ab2f86d6a1 | 100 | | 2020-02-21
> 10:53:24.558639-05 | 2020-02-21 10:53:24.558639-05
>
> Wondering if it would be wiser to remove the record
>
> delete from  rhnPackageKey  where key_id='05b555b38483c65d';
>
> Then re-insert it with the same id (157 in my case):
>
> insert into rhnPackageKey (id, key_id, key_type_id, provider_id) values
> (157, '05b555b38483c65d', lookup_package_key_type('gpg'),
> lookup_package_provider('CentOS'));
>
>
>
>
> On Thu, Mar 19, 2020 at 8:14 AM Ree, Jan-Albert van 
> wrote:
>
>> ​I skipped nothing but executed all queries, continuing on errors with
>> the next one and assumed that if there was an existing record it would be
>> fine already...
>>
>> Maybe not the best way, but it worked.
>>
>> --
>>
>> Jan-Albert
>>
>>
>>
>> Jan-Albert van Ree | HPC Specialist | Digital Services
>> MARIN | T +31 317 49 35 48 | j.a.v@marin.nl | www.marin.nl
>>
>> [image: LinkedIn] <https://www.linkedin.com/company/marin> [image:
>> YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter]
>> <https://twitter.com/MARIN_nieuws> [image: Facebook]
>> <https://www.facebook.com/marin.wageningen>
>> MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship
>> design
>> <https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>
>>
>> --
>> *From:* spacewalk-list-boun...@redhat.com <
>> spacewalk-list-boun...@redhat.com> on behalf of Eckert, Doug <
>> doug.eck...@dowjones.com>
>> *Sent:* Thursday, March 19, 2020 13:08
>> *To:* spacewalk-list@redhat.com
>> *Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released!
>>
>> Did you skip the one with the duplicate key constraint error, or did you
>> remove the existing record with the matching key and re-insert?
>>
>> ___
>> Spacewalk-list mailing list
>> Spacewalk-list@redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> --
> Doug Eckert
> LEAD ENGINEER, COMPUTE
> [image: NewsTech] <http://www.newscorp.com/>
> M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993
> <+1+555+555+>
> E: doug.eck...@dowjones.com 
> A: PO Box 300, Princeton, NJ 08543
>


-- 
Doug Eckert
LEAD ENGINEER, COMPUTE
[image: NewsTech] <http://www.newscorp.com/>
M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993 <+1+555+555+>
E: doug.eck...@dowjones.com 
A: PO Box 300, Princeton, NJ 08543
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Elsever Sadigov

Jan-Albert,

Thank you for explanation, it works for me. Btw update process takes 
long time, if anyone wonders.


--
*Best Regards,*
***Sadigov Elsevar*

*
*

On 3/19/2020 11:55, Ree, Jan-Albert van wrote:


I followed these steps :


cat 
/etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql


​su - postgres

psql -d rhnschema


Then just copy all the queries , one at a time , from the cat above in 
the postgresql session and then quit postgresql and continued the 
upgrade as if the database upgrade was successful.



Regards,

--

Jan-Albert



Jan-Albertvan Ree| HPC Specialist| Digital Services
MARIN| T +31 317 49 35 48| j.a.v@marin.nl 
<mailto:j.a.v@marin.nl> | www.marin.nl <http://www.marin.nl>


LinkedIn <https://www.linkedin.com/company/marin> YouTube 
<http://www.youtube.com/marinmultimedia> Twitter 
<https://twitter.com/MARIN_nieuws> Facebook 
<https://www.facebook.com/marin.wageningen>
MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship 
design 
<https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design> 



*From:* spacewalk-list-boun...@redhat.com 
 on behalf of Elsever Sadigov 


*Sent:* Thursday, March 19, 2020 08:08
*To:* spacewalk-list@redhat.com
*Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released!

Hi Jan-Albert,

Can you share what exactly you did?

I'm facing same issue:


--
*Best Regards,*
***Sadigov Elsevar*

On 3/19/2020 00:45, Ree, Jan-Albert van wrote:

Congrats to the devel team.

Just performed an upgrade and am back up and running with 2.10

Ran in to one minor issue ,

  
spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql
(1 row)

INSERT 0 1
INSERT 0 1
psql:/var/log/spacewalk/schema-upgrade/20200318-170518-script.sql:289: ERROR:  duplicate 
key value violates unique constraint "rhn_pkey_keyid_uq"
DETAIL:  Key (key_id)=(05b555b38483c65d) already exists.

Solved it by running all the queries in that (last) upgrade script manually

Thanks for all the hard work!
--
Jan-Albert van Ree


Jan-Albert van Ree  | HPC Specialist | Digital Services
MARIN | T +31 317 49 35 48 |mailto:j.a.v@marin.nl  |http://www.marin.nl


From:spacewalk-list-boun...@redhat.comon 
behalf of Michael Mraka
Sent: Wednesday, March 18, 2020 16:10
To:spacewalk-announce-l...@redhat.com;spacewalk-list@redhat.com;spacewalk-de...@redhat.com
Subject: [Spacewalk-list] Spacewalk 2.10 Released!

Hello everyone,

We are proudly announcing release of Spacewalk 2.10, a systems management 
solution.

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list



**


*Help us improve the spam filter. If this message contains SPAM, click 
here 
<https://www.mailcontrol.com/sr/BHYZOjXwzSPGX2PQPOmvUmQbZlJUA6MY-6selOctPjlczNG52tIWkM23y1bo3ioD_VsvySeweOuNc_rJiVGaJg==> 
to report. Thank you, MARIN Support Group*



___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

**

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Eckert, Doug
I asked because on my server, the matching key_id has an empty
'provider_id' field

rhnschema=# insert into rhnPackageKey (id, key_id, key_type_id,
provider_id) values
rhnschema-# (sequence_nextval('rhn_pkey_id_seq'), '05b555b38483c65d',
lookup_package_key_type('gpg'), lookup_package_provider('CentOS'));
ERROR:  duplicate key value violates unique constraint "rhn_pkey_keyid_uq"
DETAIL:  Key (key_id)=(05b555b38483c65d) already exists.

rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
 id  |  key_id  | key_type_id | provider_id |created
 |   modified
-+--+-+-+---+---
 157 | 05b555b38483c65d | 100 | | 2020-02-21
09:06:55.782751-05 | 2020-02-21 09:06:55.782751-05
(1 row)

Actually, there are 3 rows (out of 160) with a NULL provider_id.

156 | 49fc0fd89bd837ba | 100 | | 2020-02-19
02:06:37.884325-05 | 2020-02-19 02:06:37.884325-05
157 | 05b555b38483c65d | 100 | | 2020-02-21
09:06:55.782751-05 | 2020-02-21 09:06:55.782751-05
158 | 21ea45ab2f86d6a1 | 100 | | 2020-02-21
10:53:24.558639-05 | 2020-02-21 10:53:24.558639-05

Wondering if it would be wiser to remove the record

delete from  rhnPackageKey  where key_id='05b555b38483c65d';

Then re-insert it with the same id (157 in my case):

insert into rhnPackageKey (id, key_id, key_type_id, provider_id) values
(157, '05b555b38483c65d', lookup_package_key_type('gpg'),
lookup_package_provider('CentOS'));




On Thu, Mar 19, 2020 at 8:14 AM Ree, Jan-Albert van 
wrote:

> ​I skipped nothing but executed all queries, continuing on errors with the
> next one and assumed that if there was an existing record it would be fine
> already...
>
> Maybe not the best way, but it worked.
>
> --
>
> Jan-Albert
>
>
>
> Jan-Albert van Ree | HPC Specialist | Digital Services
> MARIN | T +31 317 49 35 48 | j.a.v@marin.nl | www.marin.nl
>
> [image: LinkedIn] <https://www.linkedin.com/company/marin> [image:
> YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter]
> <https://twitter.com/MARIN_nieuws> [image: Facebook]
> <https://www.facebook.com/marin.wageningen>
> MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship
> design
> <https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>
>
> --
> *From:* spacewalk-list-boun...@redhat.com <
> spacewalk-list-boun...@redhat.com> on behalf of Eckert, Doug <
> doug.eck...@dowjones.com>
> *Sent:* Thursday, March 19, 2020 13:08
> *To:* spacewalk-list@redhat.com
> *Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released!
>
> Did you skip the one with the duplicate key constraint error, or did you
> remove the existing record with the matching key and re-insert?
>
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list



-- 
Doug Eckert
LEAD ENGINEER, COMPUTE
[image: NewsTech] <http://www.newscorp.com/>
M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993 <+1+555+555+>
E: doug.eck...@dowjones.com 
A: PO Box 300, Princeton, NJ 08543
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Ree, Jan-Albert van
​I skipped nothing but executed all queries, continuing on errors with the next 
one and assumed that if there was an existing record it would be fine already...

Maybe not the best way, but it worked.

--

Jan-Albert


Jan-Albert van Ree | HPC Specialist | Digital Services
MARIN | T +31 317 49 35 48 | j.a.v@marin.nl<mailto:j.a.v@marin.nl> | 
www.marin.nl<http://www.marin.nl>

[LinkedIn]<https://www.linkedin.com/company/marin> [YouTube] 
<http://www.youtube.com/marinmultimedia>  [Twitter] 
<https://twitter.com/MARIN_nieuws>  [Facebook] 
<https://www.facebook.com/marin.wageningen>
MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship 
design<https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>


From: spacewalk-list-boun...@redhat.com  on 
behalf of Eckert, Doug 
Sent: Thursday, March 19, 2020 13:08
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk 2.10 Released!

Did you skip the one with the duplicate key constraint error, or did you remove 
the existing record with the matching key and re-insert?


___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Eckert, Doug
Did you skip the one with the duplicate key constraint error, or did you
remove the existing record with the matching key and re-insert?

On Thu, Mar 19, 2020 at 3:56 AM Ree, Jan-Albert van 
wrote:

> I followed these steps :
>
>
> cat
> /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql
>
> ​su - postgres
>
> psql -d rhnschema
>
>
> Then just copy all the queries , one at a time , from the cat above in the
> postgresql session and then quit postgresql and continued the upgrade as if
> the database upgrade was successful.
>
>
> Regards,
>
> --
>
> Jan-Albert
>
>
>
> Jan-Albert van Ree | HPC Specialist | Digital Services
> MARIN | T +31 317 49 35 48 | j.a.v@marin.nl | www.marin.nl
>
> [image: LinkedIn] <https://www.linkedin.com/company/marin> [image:
> YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter]
> <https://twitter.com/MARIN_nieuws> [image: Facebook]
> <https://www.facebook.com/marin.wageningen>
> MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship
> design
> <https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>
>
> --
> *From:* spacewalk-list-boun...@redhat.com <
> spacewalk-list-boun...@redhat.com> on behalf of Elsever Sadigov <
> e.sadi...@millikart.az>
> *Sent:* Thursday, March 19, 2020 08:08
> *To:* spacewalk-list@redhat.com
> *Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released!
>
>
> Hi Jan-Albert,
>
> Can you share what exactly you did?
>
> I'm facing same issue:
>
>
> --
> *Best Regards,*
> *Sadigov Elsevar*
> On 3/19/2020 00:45, Ree, Jan-Albert van wrote:
>
> Congrats to the devel team.
>
> Just performed an upgrade and am back up and running with 2.10
>
> Ran in to one minor issue ,
>
>  
> spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql
> (1 row)
>
> INSERT 0 1
> INSERT 0 1
> psql:/var/log/spacewalk/schema-upgrade/20200318-170518-script.sql:289: ERROR: 
>  duplicate key value violates unique constraint "rhn_pkey_keyid_uq"
> DETAIL:  Key (key_id)=(05b555b38483c65d) already exists.
>
> Solved it by running all the queries in that (last) upgrade script manually
>
> Thanks for all the hard work!
> --
> Jan-Albert van Ree
>
>
> Jan-Albert van Ree  | HPC Specialist | Digital Services
> MARIN | T +31 317 49 35 48 | mailto:j.a.v@marin.nl  | 
> http://www.marin.nl
>
> ____
> From: spacewalk-list-boun...@redhat.com  
>  on behalf of Michael Mraka 
>  
> Sent: Wednesday, March 18, 2020 16:10
> To: spacewalk-announce-l...@redhat.com; spacewalk-list@redhat.com; 
> spacewalk-de...@redhat.com
> Subject: [Spacewalk-list] Spacewalk 2.10 Released!
>
> Hello everyone,
>
> We are proudly announcing release of Spacewalk 2.10, a systems management 
> solution.
>
> ___
> Spacewalk-list mailing 
> listSpacewalk-list@redhat.comhttps://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
>
> *Help us improve the spam filter. If this message contains SPAM, click
> here
> <https://www.mailcontrol.com/sr/BHYZOjXwzSPGX2PQPOmvUmQbZlJUA6MY-6selOctPjlczNG52tIWkM23y1bo3ioD_VsvySeweOuNc_rJiVGaJg==>
> to report. Thank you, MARIN Support Group*
>
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list



-- 
Doug Eckert
LEAD ENGINEER, COMPUTE
[image: NewsTech] <http://www.newscorp.com/>
M: +1.732.666.3681 <+1+555+555+>O: +1.609.520.4993 <+1+555+555+>
E: doug.eck...@dowjones.com 
A: PO Box 300, Princeton, NJ 08543
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Michael Mraka
Eckert, Doug:
> Have a relatively recent fresh-install of Spacewalk 2.9 trying to update to
> 2.10, but getting the following from 'yum upgrade'
> 
> I know a lot of 'jpp5' RPMs are/removed with previous updates, but this
> one's in there.
> 
> Error: Package: cglib-2.1.3-4.jpp5.noarch (@jpackage-generic)
>Requires: asm >= 1.5.3
>Removing: asm-1.5.3-7.jpp5.noarch (@jpackage-generic)
>asm = 1.5.3-7.jpp5
>Obsoleted By: spacewalk-java-2.10.19-1.el7.noarch (spacewalk)
>Not found
> Error: Package: google-guice-3.1.3-9.el7.noarch (base)
>Requires: mvn(cglib:cglib)
>  You could try using --skip-broken to work around the problem
>  You could try running: rpm -Va --nofiles --nodigest

Hello Doug,

Jpp5 packages has been removed in Spacewalk 2.7. If you still have one
please remove /etc/yum.repos.d/jpackage-generic.repo and remove
any leftover packages comming from it.
  
  rpm -e *.jpp5

Also check if there are not locked packages, namely cglib and c3p0

  yum versionlock list
  yum versionlock delete cglib c3p0

Subsequent upgrade should download correct packages from CentOS.


Regards,

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Ree, Jan-Albert van
I followed these steps :


cat 
/etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql

​su - postgres

psql -d rhnschema


Then just copy all the queries , one at a time , from the cat above in the 
postgresql session and then quit postgresql and continued the upgrade as if the 
database upgrade was successful.


Regards,

--

Jan-Albert


Jan-Albert van Ree | HPC Specialist | Digital Services
MARIN | T +31 317 49 35 48 | j.a.v@marin.nl<mailto:j.a.v@marin.nl> | 
www.marin.nl<http://www.marin.nl>

[LinkedIn]<https://www.linkedin.com/company/marin> [YouTube] 
<http://www.youtube.com/marinmultimedia>  [Twitter] 
<https://twitter.com/MARIN_nieuws>  [Facebook] 
<https://www.facebook.com/marin.wageningen>
MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship 
design<https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>


From: spacewalk-list-boun...@redhat.com  on 
behalf of Elsever Sadigov 
Sent: Thursday, March 19, 2020 08:08
To: spacewalk-list@redhat.com
Subject: Re: [Spacewalk-list] Spacewalk 2.10 Released!


Hi Jan-Albert,

Can you share what exactly you did?

I'm facing same issue:
[cid:part1.69431512.B31AE872@millikart.az]

--
Best Regards,
Sadigov Elsevar

On 3/19/2020 00:45, Ree, Jan-Albert van wrote:

Congrats to the devel team.

Just performed an upgrade and am back up and running with 2.10

Ran in to one minor issue ,

 
spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql
(1 row)

INSERT 0 1
INSERT 0 1
psql:/var/log/spacewalk/schema-upgrade/20200318-170518-script.sql:289: ERROR:  
duplicate key value violates unique constraint "rhn_pkey_keyid_uq"
DETAIL:  Key (key_id)=(05b555b38483c65d) already exists.

Solved it by running all the queries in that (last) upgrade script manually

Thanks for all the hard work!
--
Jan-Albert van Ree


Jan-Albert van Ree  | HPC Specialist | Digital Services
MARIN | T +31 317 49 35 48 | mailto:j.a.v@marin.nl | http://www.marin.nl


From: 
spacewalk-list-boun...@redhat.com<mailto:spacewalk-list-boun...@redhat.com> 
<mailto:spacewalk-list-boun...@redhat.com> 
on behalf of Michael Mraka 
<mailto:michael.mr...@redhat.com>
Sent: Wednesday, March 18, 2020 16:10
To: 
spacewalk-announce-l...@redhat.com<mailto:spacewalk-announce-l...@redhat.com>; 
spacewalk-list@redhat.com<mailto:spacewalk-list@redhat.com>; 
spacewalk-de...@redhat.com<mailto:spacewalk-de...@redhat.com>
Subject: [Spacewalk-list] Spacewalk 2.10 Released!

Hello everyone,

We are proudly announcing release of Spacewalk 2.10, a systems management 
solution.

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com<mailto:Spacewalk-list@redhat.com>
https://www.redhat.com/mailman/listinfo/spacewalk-list







Help us improve the spam filter. If this message contains SPAM, click 
here<https://www.mailcontrol.com/sr/BHYZOjXwzSPGX2PQPOmvUmQbZlJUA6MY-6selOctPjlczNG52tIWkM23y1bo3ioD_VsvySeweOuNc_rJiVGaJg==>
 to report. Thank you, MARIN Support Group


___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-19 Thread Elsever Sadigov

Hi Jan-Albert,

Can you share what exactly you did?

I'm facing same issue:


--
*Best Regards,*
***Sadigov Elsevar*

On 3/19/2020 00:45, Ree, Jan-Albert van wrote:

Congrats to the devel team.

Just performed an upgrade and am back up and running with 2.10

Ran in to one minor issue ,

  
spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql
(1 row)

INSERT 0 1
INSERT 0 1
psql:/var/log/spacewalk/schema-upgrade/20200318-170518-script.sql:289: ERROR:  duplicate 
key value violates unique constraint "rhn_pkey_keyid_uq"
DETAIL:  Key (key_id)=(05b555b38483c65d) already exists.

Solved it by running all the queries in that (last) upgrade script manually

Thanks for all the hard work!
--
Jan-Albert van Ree


Jan-Albert van Ree  | HPC Specialist | Digital Services
MARIN | T +31 317 49 35 48 | mailto:j.a.v@marin.nl | http://www.marin.nl


From: spacewalk-list-boun...@redhat.com  on behalf 
of Michael Mraka 
Sent: Wednesday, March 18, 2020 16:10
To: spacewalk-announce-l...@redhat.com; spacewalk-list@redhat.com; 
spacewalk-de...@redhat.com
Subject: [Spacewalk-list] Spacewalk 2.10 Released!

Hello everyone,

We are proudly announcing release of Spacewalk 2.10, a systems management 
solution.

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list



**
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-18 Thread Ree, Jan-Albert van


Congrats to the devel team.

Just performed an upgrade and am back up and running with 2.10

Ran in to one minor issue ,

 
spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql
(1 row)

INSERT 0 1
INSERT 0 1
psql:/var/log/spacewalk/schema-upgrade/20200318-170518-script.sql:289: ERROR:  
duplicate key value violates unique constraint "rhn_pkey_keyid_uq"
DETAIL:  Key (key_id)=(05b555b38483c65d) already exists.

Solved it by running all the queries in that (last) upgrade script manually

Thanks for all the hard work!
--
Jan-Albert van Ree


Jan-Albert van Ree  | HPC Specialist | Digital Services
MARIN | T +31 317 49 35 48 | mailto:j.a.v@marin.nl | http://www.marin.nl


From: spacewalk-list-boun...@redhat.com  on 
behalf of Michael Mraka 
Sent: Wednesday, March 18, 2020 16:10
To: spacewalk-announce-l...@redhat.com; spacewalk-list@redhat.com; 
spacewalk-de...@redhat.com
Subject: [Spacewalk-list] Spacewalk 2.10 Released!

Hello everyone,

We are proudly announcing release of Spacewalk 2.10, a systems management 
solution.

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list



Re: [Spacewalk-list] Spacewalk 2.10 Released!

2020-03-18 Thread Eckert, Doug
Have a relatively recent fresh-install of Spacewalk 2.9 trying to update to
2.10, but getting the following from 'yum upgrade'

I know a lot of 'jpp5' RPMs are/removed with previous updates, but this
one's in there.

Error: Package: cglib-2.1.3-4.jpp5.noarch (@jpackage-generic)
   Requires: asm >= 1.5.3
   Removing: asm-1.5.3-7.jpp5.noarch (@jpackage-generic)
   asm = 1.5.3-7.jpp5
   Obsoleted By: spacewalk-java-2.10.19-1.el7.noarch (spacewalk)
   Not found
Error: Package: google-guice-3.1.3-9.el7.noarch (base)
   Requires: mvn(cglib:cglib)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

Current repolist is

# yum repolist
Loaded plugins: fastestmirror, langpacks, tmprepo, versionlock
Loading mirror speeds from cached hostfile
 * base: centos.mirror.constant.com
 * epel: fedora-epel.mirrors.tds.net
 * extras: centos.mirror.constant.com
 * updates: centos.mirror.constant.com
repo id   repo name
   status
base/7/x86_64 CentOS-7 -
Base
 10,095+2
epel/x86_64   Extra
Packages for Enterprise Linux 7 - x86_64
  13,212
extras/7/x86_64   CentOS-7 -
Extras
335
group_spacewalkproject-java-packages  Copr repo for
java-packages owned by @spacewalkproject 155+56
spacewalk/x86_64  Spacewalk
 138+68
updates/7/x86_64  CentOS-7 -
Updates
 1,487
repolist: 25,422

On Wed, Mar 18, 2020 at 11:11 AM Michael Mraka 
wrote:

>
> Hello everyone,
>
> We are proudly announcing release of Spacewalk 2.10, a systems management
> solution.
>
> Spacewalk 2.10 could be installed on
>
>   * RHEL 6
>   * RHEL 7
>   * Fedora 30
>   * Fedora 31
>
> The download location is
>   *
> https://copr.fedorainfracloud.org/coprs/g/spacewalkproject/spacewalk-2.10/
>
> with client repositories under
>   *
> https://copr.fedorainfracloud.org/coprs/g/spacewalkproject/spacewalk-2.10-client/
>
>
> For fresh installations, please use steps from
>
>   * https://github.com/spacewalkproject/spacewalk/wiki/HowToInstall
>
> If you plan to upgrade from older release, search no more -- the following
> page will guide you:
>
>   * https://github.com/spacewalkproject/spacewalk/wiki/HowToUpgrade
>
> Features & Enhancements in Spacewalk 2.10
>
>   * Spacewalk now installable on Fedora 30 and 31
>   * Spacewalk supports Fedora 30 and 31, Red Hat Enterprise Linux and
> CentOS 8 clients
>   * Number of bugfixes and security fixes
>
> The up-to-date API documentation can be found at
> http://spacewalkproject.github.io/documentation/api/2.10/
>
>
> Contributors
>
> Our thanks go to the community members who contributed to this release:
>
>  * Christian Hailer
>  * Eduardo Suarez-Santana
>  * Elena Zaharia
>  * Jay McCanta
>  * Josef Hak
>  * Kenny Tordeurs
>  * Kim Sondrup
>  * Laurence Rochfort
>  * Michael Mraka
>  * Robert Paschedag
>  * Rostislav Medvěd
>  * Stefan Bluhm
>  * Tomas Kasparek
>  * Vladislav Belogrudov
>  * Yuriy Kashirin
>
> Some statistics
>
> In Spacewalk 2.10, we've seen
>
> * 46 major bugs fixed
> * 230 changesets committed
> * 429 commits done
>
>
> User community, reporting issues
>
> To reach the user community with questions and ideas, please use
> mailing list spacewalk-list@redhat.com. On this list, you can of
> course also discuss issues you might find when installing or using
> Spacewalk, but please do not be surprised if we ask you to file a bug
> at https://bugzilla.redhat.com/enter_bug.cgi?product=Spacewalk with more
> details or full logs.
>
> Thank you for using Spacewalk.
>
> --
> Michael Mráka
> System Management Engineering, Red Hat
>
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

[Spacewalk-list] Spacewalk 2.10 Released!

2020-03-18 Thread Michael Mraka

Hello everyone,

We are proudly announcing release of Spacewalk 2.10, a systems management 
solution.

Spacewalk 2.10 could be installed on

  * RHEL 6
  * RHEL 7
  * Fedora 30
  * Fedora 31
  
The download location is 
  * https://copr.fedorainfracloud.org/coprs/g/spacewalkproject/spacewalk-2.10/

with client repositories under
  * 
https://copr.fedorainfracloud.org/coprs/g/spacewalkproject/spacewalk-2.10-client/


For fresh installations, please use steps from

  * https://github.com/spacewalkproject/spacewalk/wiki/HowToInstall 

If you plan to upgrade from older release, search no more -- the following page 
will guide you:

  * https://github.com/spacewalkproject/spacewalk/wiki/HowToUpgrade

Features & Enhancements in Spacewalk 2.10

  * Spacewalk now installable on Fedora 30 and 31
  * Spacewalk supports Fedora 30 and 31, Red Hat Enterprise Linux and CentOS 8 
clients
  * Number of bugfixes and security fixes
 
The up-to-date API documentation can be found at
http://spacewalkproject.github.io/documentation/api/2.10/
  

Contributors

Our thanks go to the community members who contributed to this release:

 * Christian Hailer
 * Eduardo Suarez-Santana
 * Elena Zaharia
 * Jay McCanta
 * Josef Hak
 * Kenny Tordeurs
 * Kim Sondrup
 * Laurence Rochfort
 * Michael Mraka
 * Robert Paschedag
 * Rostislav Medvěd
 * Stefan Bluhm
 * Tomas Kasparek
 * Vladislav Belogrudov
 * Yuriy Kashirin

Some statistics

In Spacewalk 2.10, we've seen

* 46 major bugs fixed
* 230 changesets committed
* 429 commits done


User community, reporting issues

To reach the user community with questions and ideas, please use
mailing list spacewalk-list@redhat.com. On this list, you can of
course also discuss issues you might find when installing or using
Spacewalk, but please do not be surprised if we ask you to file a bug
at https://bugzilla.redhat.com/enter_bug.cgi?product=Spacewalk with more
details or full logs.

Thank you for using Spacewalk.

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list