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" <[email protected]> > To: [email protected] > 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 > [email protected] > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Tomas > Lestach > Sent: Monday, October 13, 2014 5:13 AM > To: [email protected] > 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" <[email protected]> > > To: [email protected] > > 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: [email protected] > > [mailto:[email protected]] On Behalf Of Tomas > > Lestach > > Sent: Thursday, October 09, 2014 10:03 AM > > To: [email protected] > > 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" <[email protected]> > > > To: [email protected] > > > 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 > > > [email protected] > > > > > > -----Original Message----- > > > From: [email protected] > > > [mailto:[email protected]] On Behalf Of Tomas > > > Lestach > > > Sent: Thursday, October 09, 2014 6:32 AM > > > To: [email protected] > > > 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 > > > [email protected] > > > 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 > > > [email protected] > > > https://www.redhat.com/mailman/listinfo/spacewalk-list > > > > _______________________________________________ > > Spacewalk-list mailing list > > [email protected] > > 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 > > [email protected] > > https://www.redhat.com/mailman/listinfo/spacewalk-list > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > 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 > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
