* Stefan Förster <[email protected]>: > at our Spacewalk 0.8 server (upgraded from 0.6 to 0.7 and then from > 0.7 to 0.8), available updates don't show up in the web interface. We > are generating the reports about updates with our regular reporting > system, using the following SQL against an Oracle 10.2 database: > > set linesize 200; > set pagesize 100; > > column Hostname format a30; > column Updates format 9999999; > > SELECT srv.name "Hostname", > count(srv.name) "Updates" > FROM spacewalk.rhnserver SRV > JOIN spacewalk.RHNSERVERNEEDEDPACKAGEVIEW NPV ON SRV.ID = NPV.Server_id > GROUP BY SRV.id, SRV.name > ORDER BY SRV.name; > > > However, these updates are not displayed in the web interface. More > precise, the table "rhnServerNeededCache" never get's filled. We have > to execute the following SQL to get it filled: > > delete from rhnServerNeededCache; > insert into rhnServerNeededCache(SERVER_ID,PACKAGE_ID) (select > SERVER_ID,PACKAGE_ID from RHNSERVERNEEDEDPACKAGEVIEW); > > How do we fix that problem?
Nobody? Any input would be greatly appreciated. Cheers Stefan _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
