[Spacewalk-list] SLES 11 SP3 channels show Content Provider as "unknown"
Tomas Lestach
tlestach at redhat.com
Thu Oct 16 09:14:01 UTC 2014
Hello,
echo "select pk.key_id, count(package_id) as package_count from rhnPackageKey pk join rhnPackageKeyAssociation pka on pka.key_id = pk.id where provider_id is null group by pk.key_id;" | spacewalk-sql -i
will list you the count of packages for every key without a known Content Provider.
Regards,
--
Tomas Lestach
Red Hat Satellite Engineering, Red Hat
----- Original Message -----
> From: "Chris Will" <CWill at bcbsm.com>
> To: spacewalk-list at redhat.com
> Sent: Monday, October 13, 2014 1:45:14 PM
> Subject: Re: [Spacewalk-list] SLES 11 SP3 channels show Content Provider as "unknown"
>
> I do not think so. How would this be done? My guess is that I would
> have to set up the GPG key, url and fingerprint fields for the
> channel with the information I get from our SLES mirror credentials
> but I see no examples of this.
>
> Chris Will
> Systems Software
> (313) 549-9729 Cell
> cwill at bcbsm.com
>
> -----Original Message-----
> From: spacewalk-list-bounces at redhat.com
> [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Tomas
> Lestach
> Sent: Monday, October 13, 2014 5:13 AM
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] SLES 11 SP3 channels show Content
> Provider as "unknown"
>
> And are you sure the packages are really signed with e3a5c360307e3d54
> key?
>
> Regards,
> --
> Tomas Lestach
> Red Hat Satellite Engineering, Red Hat
>
>
> ----- Original Message -----
> > From: "Chris Will" <CWill at bcbsm.com>
> > To: spacewalk-list at redhat.com
> > Sent: Friday, October 10, 2014 4:06:50 PM
> > Subject: Re: [Spacewalk-list] SLES 11 SP3 channels show Content
> > Provider as "unknown"
> >
> > I upgraded to 2.2 but the packages still show unknown. Also, the
> > GUI
> > on IE does not work correctly and firefox mostly works with a few
> > page
> > corruptions(repo sync page).
> >
> > Chris Will
> >
> > -----Original Message-----
> > From: spacewalk-list-bounces at redhat.com
> > [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Tomas
> > Lestach
> > Sent: Thursday, October 09, 2014 10:03 AM
> > To: spacewalk-list at redhat.com
> > Subject: Re: [Spacewalk-list] SLES 11 SP3 channels show Content
> > Provider as "unknown"
> >
> > If you have the key correctly associated with the provider (what
> > you
> > have - according to the posted query), Content Provider should be
> > properly displayed.
> >
> > rhnschema=# select * from rhnPackageKey where
> > key_id='e3a5c360307e3d54';
> > id | key_id | key_type_id | provider_id |
> > created | modified
> > -----+------------------+-------------+-------------+-------------------------------+-------------------------------
> > 128 | e3a5c360307e3d54 | 100 | 104 | 2013-10-04
> > 09:03:54.396637-04 | 2013-10-04 09:03:54.396637-04
> > (1 row)
> >
> > At least I see it correctly on my Spacewalk nightly.
> > There's a chance it was fixed in the mean time. Do you have a
> > chance
> > to check the behavior on Spacewalk 2.2?
> >
> > Regards,
> > --
> > Tomas Lestach
> > Red Hat Satellite Engineering, Red Hat
> >
> >
> > ----- Original Message -----
> > > From: "Chris Will" <CWill at bcbsm.com>
> > > To: spacewalk-list at redhat.com
> > > Sent: Thursday, October 9, 2014 2:00:52 PM
> > > Subject: Re: [Spacewalk-list] SLES 11 SP3 channels show Content
> > > Provider as "unknown"
> > >
> > > I see it on this page.
> > >
> > > https://xxx/rhn/channels/ChannelPackages.do?cid=110
> > >
> > > Also see an error on the rpm -qip command.
> > >
> > > rpm -qip timezone-2014g-0.3.1.s390x.rpm
> > > warning: timezone-2014g-0.3.1.s390x.rpm: Header V3 RSA/SHA256
> > > Signature, key ID 307e3d54: NOKEY
> > > Name : timezone Relocations: (not
> > > relocatable)
> > > Version : 2014g Vendor: SUSE
> > > LINUX
> > > Products GmbH, Nuernberg, Germany
> > > Release : 0.3.1 Build Date: Mon 08
> > > Sep
> > > 2014 10:56:39 AM EDT
> > > Install Date: (not installed) Build Host: s390lp4
> > > Group : System/Base Source RPM:
> > > timezone-2014g-0.3.1.src.rpm
> > > Size : 1263106 License:
> > > BSD-3-Clause
> > > and SUSE-Public-Domain
> > > Signature : RSA/8, Mon 08 Sep 2014 10:56:47 AM EDT, Key ID
> > > e3a5c360307e3d54
> > > Packager : http://bugs.opensuse.org
> > > URL : http://www.iana.org/time-zones
> > > Summary : Timezone Descriptions
> > > Description :
> > > These are configuration files that describe available time zones.
> > > You
> > > can select an appropriate time zone for your system with YaST.
> > >
> > > Chris Will
> > > Systems Software
> > > (313) 549-9729 Cell
> > > cwill at bcbsm.com
> > >
> > > -----Original Message-----
> > > From: spacewalk-list-bounces at redhat.com
> > > [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Tomas
> > > Lestach
> > > Sent: Thursday, October 09, 2014 6:32 AM
> > > To: spacewalk-list at redhat.com
> > > Subject: Re: [Spacewalk-list] SLES 11 SP3 channels show Content
> > > Provider as "unknown"
> > >
> > > > We are running Spacewalk 2.0 on RHEL 6. We have successfully
> > > > mirrored the channels from SUSE (SLES 11 SP3 s390x) with our
> > > > mirror credentials, however all the packages display “unknown”
> > > > for
> > > > content provider.
> > >
> > > What WebUI page do you mean?
> > > Is it /rhn/channels/ChannelPackages.do?cid=<cid> ?
> > >
> > > Regards,
> > > --
> > > Tomas Lestach
> > > Red Hat Satellite Engineering, Red Hat
> > >
> > > _______________________________________________
> > > Spacewalk-list mailing list
> > > Spacewalk-list at redhat.com
> > > https://www.redhat.com/mailman/listinfo/spacewalk-list
> > >
> > >
> > > The information contained in this communication is highly
> > > confidential and is intended solely for the use of the
> > > individual(s)
> > > to whom this communication is directed. If you are not the
> > > intended
> > > recipient, you are hereby notified that any viewing, copying,
> > > disclosure or distribution of this information is prohibited.
> > > Please
> > > notify the sender, by electronic mail or telephone, of any
> > > unintended receipt and delete the original message without making
> > > any copies.
> > >
> > > Blue Cross Blue Shield of Michigan and Blue Care Network of
> > > Michigan are nonprofit corporations and independent licensees of
> > > the
> > > Blue Cross and Blue Shield Association.
> > >
> > > _______________________________________________
> > > Spacewalk-list mailing list
> > > Spacewalk-list at redhat.com
> > > https://www.redhat.com/mailman/listinfo/spacewalk-list
> >
> > _______________________________________________
> > Spacewalk-list mailing list
> > Spacewalk-list at redhat.com
> > https://www.redhat.com/mailman/listinfo/spacewalk-list
> >
> >
> > The information contained in this communication is highly
> > confidential
> > and is intended solely for the use of the individual(s) to whom
> > this
> > communication is directed. If you are not the intended recipient,
> > you
> > are hereby notified that any viewing, copying, disclosure or
> > distribution of this information is prohibited. Please notify the
> > sender, by electronic mail or telephone, of any unintended receipt
> > and
> > delete the original message without making any copies.
> >
> > Blue Cross Blue Shield of Michigan and Blue Care Network of
> > Michigan
> > are nonprofit corporations and independent licensees of the Blue
> > Cross and Blue Shield Association.
> >
> > _______________________________________________
> > Spacewalk-list mailing list
> > Spacewalk-list at redhat.com
> > https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
> The information contained in this communication is highly
> confidential and is intended solely for the use of the individual(s)
> to whom this communication is directed. If you are not the intended
> recipient, you are hereby notified that any viewing, copying,
> disclosure or distribution of this information is prohibited. Please
> notify the sender, by electronic mail or telephone, of any
> unintended receipt and delete the original message without making
> any copies.
>
> Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan
> are nonprofit corporations and independent licensees of the Blue
> Cross and Blue Shield Association.
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list