[Spacewalk-list] How to set the package Content Provider

[Stephen Berg (Contractor)]

Justin Sherrill wrote:
> The installing OS doesn't really make any difference. We store a mapping
> of GPG Key ids -> Providers in the rhnPackageKey table.  Here's an
> example of an insertion that we do upon installation of spacewalk:
>
> #sqlplus spacewalk/spacewalk at xe
>
> sqlplus>  insert into rhnPackageKey (id, key_id, key_type_id,
> provider_id) values
> (rhn_pkey_id_seq.nextval, 'b44269d04f2a6fd2',
> lookup_package_key_type('gpg'), lookup_package_provider('Fedora'));
>
> This requires on their being a package provider (from
> rhnPackageProvider) named 'Fedora'.  To insert that, we ran:
>
> sqlplus>  insert into rhnPackageProvider (id, name) values
> (rhn_package_provider_id_seq.nextval, 'Fedora' );
> sqlplus>commit
>
>
> To get the gpg key ID that you need to insert, simply run 'rpm -qip
> package.rpm' and look for the "Key ID" field.   I'd like to make a UI
> for adding package Ids and providers, but currently there isn't a way to
> do that.  What were the GPG ids for packages that are showing up as unknown?
>   
For updates coming out of rpmfusion-nonfree 206f8182b1981b68
rpmfusion-free 855099b249c8885a
Fedora updates (newkey) 62aec3dc6df2196f
Fedora (everything, original key) b44269d04f2a6fd2

-- 
Stephen Berg
Systems Administrator
NRL Code: 7321
Office: 228-688-5738
stephen.berg.ctr at nrlssc.navy.mil