[Spacewalk-list] Updates not displayed in web interface

[Stefan Förster]

* Stefan Förster <cite+spacewalk-users at incertum.net>:
> 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