[Spacewalk-list] Nightly/git version question !

[Michael Mraka]

Franz Skale wrote:
% -----BEGIN PGP SIGNED MESSAGE-----
% Hash: SHA1
% 
% Hi,
% i have installed the lastest version for testing purposes.
% THe nighty build don't work as expected so i tested the git version
% and rebuild all packages.
% But the problem still extists.
% Neither rhnpush nor spacewalk-repo-sync is working.
% The exception isn't so clear to me and i hope someone can bring
% something to light.
% The exception is as follows:
% 
% Extra information about this error:
% SQL Error generated: ('ORA-00904: "P"."MD5SUM": invalid identifier\n',
% 904, 'select p.md5sum md5sum, p.path path from rhnPackageEVR pe,
% rhnPackageName pn, rhnPackage p, rhnPackageArch pa where pn.name     =
% :pkg_name and  ( pe.epoch  = :pkg_epoch or ( pe.epoch is null and
% :pkg_epoch is null ) ) and  pe.version  = :pkg_version and
% pe.release  = :pkg_rel and  ( p.org_id  = :orgid or ( p.org_id is null
% and :orgid is null ) ) and  p.name_id   = pn.id and  p.evr_id    =
% pe.id and  p.package_arch_id = pa.id and  pa.label    = :pkg_arch and
% p.md5sum =: md5sum')
% 
% Is there a problem in  checksum/md5sum handling or is the schema
% different ?

We are currently in the middle of checksum/md5sum changes but these
changes are being done in separate branch. You should not experience
such errors in git master.

Could you post how your rhnPackage table looks like?
# sqlplus spacewalk/spacewalk at xe
SQL> desc rhnPackage


% Thanks in advance
% 
% Franz

--
Michael Mráka
Satellite Engineering, Red Hat